APPS.CSTPPACQ dependencies on DUAL

Line 607: FROM dual;

603: -- Get next header id from sequence
604: -----------------------------------------------------------
605: SELECT cst_rcv_acq_costs_s.nextval
606: INTO l_header
607: FROM dual;
608:
609: /* begin changes for dropshipment project */
610: /* Includes Changes for Service Line Types */
611: l_stmt_num := 120;

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 1105: from dual;

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:
1109: select decode(l_pri_quantity_invoiced,0,0,(c_inv.unit_price * c_inv.quantity_invoiced / l_pri_quantity_invoiced)) into l_priuom_cost

Line 1110: from dual;

1106:
1107: l_stmt_num := 105;
1108:
1109: select decode(l_pri_quantity_invoiced,0,0,(c_inv.unit_price * c_inv.quantity_invoiced / l_pri_quantity_invoiced)) into l_priuom_cost
1110: from dual;
1111:
1112: l_stmt_num := 110;
1113:
1114: Insert_into_acqdtls_tables (

Line 1277: FROM dual;

1273:
1274: l_stmt_num := 1040;
1275: SELECT cst_rcv_acq_costs_s.nextval
1276: INTO l_header_id
1277: FROM dual;
1278:
1279: l_stmt_num := 1050;
1280:
1281: l_nr_tax_rate := get_rcv_tax(c_rec.transaction_id);

Line 1654: FROM dual;

1650: IF (l_prior_landed_cost <> l_new_landed_cost) THEN
1651: l_stmt_num := 1210;
1652: SELECT cst_rcv_acq_costs_s.nextval
1653: INTO l_header_id
1654: FROM dual;
1655:
1656: l_stmt_num := 1220;
1657:
1658: Insert_into_acqhdr_tables(

Line 1822: FROM DUAL);

1818: c_rec.inventory_item_id,
1819: l_new_landed_cost unit_price,
1820: l_prior_landed_cost,
1821: 1
1822: FROM DUAL);
1823: ELSE
1824: l_stmt_num := 1245;
1825: INSERT into RCV_ACCOUNTING_EVENTS(
1826: accounting_event_id,

Line 1997: from dual;

1993: Returning accounting_event_id INTO l_rcv_accounting_event_id;
1994: l_stmt_num := 1260;
1995: select MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL
1996: into l_transaction_id
1997: from dual;
1998: l_stmt_num := 1265;
1999: l_um_rate := 1;
2000: CSTPPINV.get_um_rate(
2001: i_txn_org_id => c_rec.organization_id,

Line 2247: FROM DUAL);

2243: c_rec.inventory_item_id,
2244: l_new_landed_cost unit_price,
2245: l_prior_landed_cost,
2246: 1
2247: FROM DUAL);
2248: END IF;
2249: END LOOP;
2250: IF l_recs_processed >= l_commit_records_count THEN
2251: IF g_debug = 'Y' THEN

Line 2448: FROM dual;

2444: -- Get next header id from sequence
2445: -----------------------------------------------------------
2446: SELECT cst_rcv_acq_costs_s.nextval
2447: INTO l_header
2448: FROM dual;
2449:
2450: /* begin changes for dropshipment project */
2451: /* Includes Changes for Service Line Types */
2452: l_stmt_num := 121;

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 2935: from dual;

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:
2939: select decode(l_pri_quantity_invoiced,0,0,(c_inv.unit_price * c_inv.quantity_invoiced / l_pri_quantity_invoiced)) into l_priuom_cost

Line 2940: from dual;

2936:
2937: l_stmt_num := 106;
2938:
2939: select decode(l_pri_quantity_invoiced,0,0,(c_inv.unit_price * c_inv.quantity_invoiced / l_pri_quantity_invoiced)) into l_priuom_cost
2940: from dual;
2941:
2942: l_stmt_num := 111;
2943:
2944: Insert_into_acqdtls_tables (

Line 4451: from dual;

4447:
4448:
4449: l_stmt_num := 90;
4450: select MTL_MATERIAL_TRANSACTIONS_S.NEXTVAL into l_transaction_id
4451: from dual;
4452:
4453: /* get the period close date for the current open period */
4454:
4455: l_stmt_num := 100;

Line 4511: from dual;

4507: /* Now insert stuff into MMT */
4508:
4509: l_stmt_num := 80;
4510: select LEAST(l_period_close_date,sysdate) into l_least_date
4511: from dual;
4512:
4513: l_stmt_num := 90;
4514:
4515: /* bug 4322574. CHanged the Costed_flag to NULL from 'N' so that the perpetual cost worker does not try and