p_i_as_of_date_id               IN       VARCHAR2,

        p_i_order_by_code               IN       VARCHAR2,

        p_i_po_code                     IN       VARCHAR2,

        p_i_wh                          IN       VARCHAR2

    ) RETURN NUMBER

    IS

        x_vch_error_msg VARCHAR2(255);

    BEGIN

        INSERT INTO GMY_ACTUAL_DS_SCC(

                order_by_code,

                po_code,

                wh )

        VALUES( p_i_order_by_code,

                p_i_po_code,

                p_i_wh);

        COMMIT;

        RETURN GMY_GA000_PKG.gn#OK;

    EXCEPTION

        WHEN OTHERS THEN

            x_vch_error_msg := p_i_job_id||'''' Function Name: InsToActualScc'''';

            COM_LOG.PUTLINE(p_i_job_id,x_vch_error_msg);

            x_vch_error_msg := p_i_job_id

上一页  [1] [2] [3] [4] [5] [6] [7] [8] [9]  下一页