APPS.PA_TRANSACTIONS dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 577: INSERT INTO pa_expenditure_items_all (

573: IF P_DEBUG_MODE THEN
574: pa_cc_utils.log_message('InsItems: ' || 'Start of bulk insert for EI insertion');
575: END IF;
576: FORALL i IN 1..Rows ---{
577: INSERT INTO pa_expenditure_items_all (
578: expenditure_item_id
579: , expenditure_id
580: , expenditure_item_date
581: , task_id

Line 853: **INSERT INTO pa_expenditure_items_all (

849:
850: --PA-K Changes: Commented the following as bulk insert for EIs is being done now
851: /*IF nvl(X_gl_flag,'N') <> 'Y' THEN
852: **
853: **INSERT INTO pa_expenditure_items_all (
854: ** )
855: ** VALUES (
856: ** );
857: **ELSE

Line 858: ** INSERT INTO pa_expenditure_items_all (

854: ** )
855: ** VALUES (
856: ** );
857: **ELSE
858: ** INSERT INTO pa_expenditure_items_all (
859: ** )
860: ** VALUES (
861: ** );
862: */

Line 1145: INSERT INTO pa_expenditure_items_all(

1141: END LOOP;
1142:
1143: /* Insert the Reversing expenditure Items */
1144: FORALL i IN 1..Rows
1145: INSERT INTO pa_expenditure_items_all(
1146: expenditure_item_id
1147: , task_id
1148: , expenditure_type
1149: , system_linkage_function

Line 1378: pa_expenditure_items_all ei

1374: , ei.vendor_id ei_vendor_id
1375: , ei.document_type
1376: , ei.document_distribution_type
1377: FROM
1378: pa_expenditure_items_all ei
1379: WHERE
1380: ei.expenditure_item_id = TfrEiTab(i);
1381:
1382: FOR i IN 1..Rows LOOP