DBA Data[Home] [Help]

APPS.JAI_RETRO_PRC_PKG dependencies on JAI_RETRO_LINE_CHANGES_S

Line 2862: jai_retro_line_changes_s.nextval

2858: ln_skip_rcpt_cnt := ln_skip_rcpt_cnt + 1;
2859: ELSE
2860: --get the retro line change id the receipt from a sequence
2861: SELECT
2862: jai_retro_line_changes_s.nextval
2863: INTO
2864: ln_retro_line_changes_id
2865: FROM
2866: DUAL;

Line 2923: ( ln_retro_line_changes_id --=> jai_retro_line_changes_s.nextval

2919: , last_updated_by
2920: , object_version_number
2921: )
2922: VALUES
2923: ( ln_retro_line_changes_id --=> jai_retro_line_changes_s.nextval
2924: , 'RECEIPT' --=> 'RECEIPT'
2925: , jai_rcv_lines_rec.shipment_header_id --=> shipment_header_id from jai_rcv_lines
2926: , jai_rcv_lines_rec.shipment_line_id --=> shipment_Line_Id from jai_rcv_lines
2927: , NULL --=> NULL

Line 3374: JAI_RETRO_LINE_CHANGES_S.NEXTVAL

3370: pv_process_message := '';
3371:
3372: BEGIN
3373: SELECT
3374: JAI_RETRO_LINE_CHANGES_S.NEXTVAL
3375: INTO
3376: ln_retro_line_changes_id
3377: FROM dual;
3378: EXCEPTION