DBA Data[Home] [Help]

APPS.PA_TRANSACTIONS dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 645: INSERT INTO pa_expenditure_items_all (

641: IF P_DEBUG_MODE THEN
642: pa_cc_utils.log_message('InsItems: ' || 'Start of bulk insert for EI insertion');
643: END IF;
644: FORALL i IN 1..Rows ---{
645: INSERT INTO pa_expenditure_items_all (
646: expenditure_item_id
647: , expenditure_id
648: , expenditure_item_date
649: , task_id

Line 943: **INSERT INTO pa_expenditure_items_all (

939:
940: --PA-K Changes: Commented the following as bulk insert for EIs is being done now
941: /*IF nvl(X_gl_flag,'N') <> 'Y' THEN
942: **
943: **INSERT INTO pa_expenditure_items_all (
944: ** )
945: ** VALUES (
946: ** );
947: **ELSE

Line 948: ** INSERT INTO pa_expenditure_items_all (

944: ** )
945: ** VALUES (
946: ** );
947: **ELSE
948: ** INSERT INTO pa_expenditure_items_all (
949: ** )
950: ** VALUES (
951: ** );
952: */

Line 1238: INSERT INTO pa_expenditure_items_all(

1234:
1235: /* Insert the Reversing expenditure Items */
1236:
1237: FORALL i IN 1..Rows
1238: INSERT INTO pa_expenditure_items_all(
1239: expenditure_item_id
1240: , task_id
1241: , expenditure_type
1242: , system_linkage_function

Line 1495: pa_expenditure_items_all ei

1491: , ei.Interface_Run_Id /* end changes for 12581268 */
1492: , ei.cbs_element_id -- Added for CBS Enhancement Bug 16220146
1493:
1494: FROM
1495: pa_expenditure_items_all ei
1496: WHERE
1497: ei.expenditure_item_id = TfrEiTab(i);
1498:
1499: FOR i IN 1..Rows LOOP