DBA Data[Home] [Help]

APPS.JAI_RETRO_PRC_PKG dependencies on JAI_RETRO_LINE_CHANGES_S

Line 2849: jai_retro_line_changes_s.nextval

2845: ln_skip_rcpt_cnt := ln_skip_rcpt_cnt + 1;
2846: ELSE
2847: --get the retro line change id the receipt from a sequence
2848: SELECT
2849: jai_retro_line_changes_s.nextval
2850: INTO
2851: ln_retro_line_changes_id
2852: FROM
2853: DUAL;

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

2906: , last_updated_by
2907: , object_version_number
2908: )
2909: VALUES
2910: ( ln_retro_line_changes_id --=> jai_retro_line_changes_s.nextval
2911: , 'RECEIPT' --=> 'RECEIPT'
2912: , jai_rcv_lines_rec.shipment_header_id --=> shipment_header_id from jai_rcv_lines
2913: , jai_rcv_lines_rec.shipment_line_id --=> shipment_Line_Id from jai_rcv_lines
2914: , NULL --=> NULL

Line 3329: JAI_RETRO_LINE_CHANGES_S.NEXTVAL

3325: pv_process_message := '';
3326:
3327: BEGIN
3328: SELECT
3329: JAI_RETRO_LINE_CHANGES_S.NEXTVAL
3330: INTO
3331: ln_retro_line_changes_id
3332: FROM dual;
3333: EXCEPTION