APPS.CSTPPACQ dependencies on CST_RCV_ACQ_COST_DETAILS_S

Line 1025: select cst_rcv_acq_cost_details_s.nextval into l_details_nextvalue FROM dual ;

1021:
1022:
1023: FOR i in c_price_correction(c_inv.invoice_distribution_id) LOOP
1024:
1025: select cst_rcv_acq_cost_details_s.nextval into l_details_nextvalue FROM dual ;
1026:
1027: Insert_into_acqdtls_tables (
1028: l_header,
1029: l_details_nextvalue,

Line 1104: select cst_rcv_acq_cost_details_s.nextval into l_details_nextvalue

1100: END;
1101:
1102: If l_chrg_present = 0 then /* means that this has not been allocated */
1103:
1104: select cst_rcv_acq_cost_details_s.nextval into l_details_nextvalue
1105: from dual;
1106:
1107: l_stmt_num := 105;
1108:

Line 1389: cst_rcv_acq_cost_details_s.nextval,

1385: LAST_UPDATE_LOGIN
1386: )
1387: VALUES (
1388: l_header_id,
1389: cst_rcv_acq_cost_details_s.nextval,
1390: 'LCM',
1391: l_po_line_loc,
1392: NULL,
1393: -1,

Line 1718: cst_rcv_acq_cost_details_s.nextval,

1714: LAST_UPDATE_LOGIN
1715: )
1716: VALUES (
1717: l_header_id,
1718: cst_rcv_acq_cost_details_s.nextval,
1719: 'LCM',
1720: c_rec.line_location_id,
1721: NULL,
1722: -1,

Line 2853: select cst_rcv_acq_cost_details_s.nextval into l_details_nextvalue FROM dual ;

2849: --------------------------------------------------------------------------------
2850:
2851: FOR i in c_price_correction(c_inv.invoice_distribution_id) LOOP
2852:
2853: select cst_rcv_acq_cost_details_s.nextval into l_details_nextvalue FROM dual ;
2854:
2855: Insert_into_acqdtls_tables (
2856: l_header,
2857: l_details_nextvalue,

Line 2934: select cst_rcv_acq_cost_details_s.nextval into l_details_nextvalue

2930: END;
2931:
2932: If l_chrg_present = 0 then /* means that this has not been allocated */
2933:
2934: select cst_rcv_acq_cost_details_s.nextval into l_details_nextvalue
2935: from dual;
2936:
2937: l_stmt_num := 106;
2938:

Line 3451: cst_rcv_acq_cost_details_s.nextval,

3447: LAST_UPDATE_LOGIN
3448: )
3449: SELECT
3450: i_hdr,
3451: cst_rcv_acq_cost_details_s.nextval,
3452: 'INVOICE',
3453: NULL,
3454: i_item_dist,
3455: rownum + 1,

Line 3678: cst_rcv_acq_cost_details_s.nextval,

3674: LAST_UPDATE_LOGIN
3675: )
3676: SELECT
3677: i_hdr,
3678: cst_rcv_acq_cost_details_s.nextval,
3679: 'INVOICE',
3680: NULL,
3681: i_item_dist,
3682: rownum + 1,

Line 3987: cst_rcv_acq_cost_details_s.nextval,

3983: LAST_UPDATE_LOGIN
3984: )
3985: VALUES (
3986: i_header,
3987: cst_rcv_acq_cost_details_s.nextval,
3988: 'PO',
3989: i_po_line_loc,
3990: NULL,
3991: -1,

Line 4259: cst_rcv_acq_cost_details_s.nextval,

4255: LAST_UPDATE_LOGIN
4256: )
4257: VALUES (
4258: i_header,
4259: cst_rcv_acq_cost_details_s.nextval,
4260: 'PO',
4261: i_po_line_loc,
4262: NULL,
4263: -1,