DBA Data[Home] [Help]

APPS.PA_ADW_COLLECT_FACTS dependencies on PA_TSK_BGT_LINES_IT

Line 2581: PA_TSK_BGT_LINES_IT

2577:
2578: -- First Try to Update the Row in the Interface Table
2579:
2580: UPDATE
2581: PA_TSK_BGT_LINES_IT
2582: SET
2583: LAST_UPDATE_DATE = TRUNC(SYSDATE),
2584: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
2585: CREATION_DATE = TRUNC(SYSDATE),

Line 2623: INSERT INTO PA_TSK_BGT_LINES_IT

2619:
2620: IF (SQL%ROWCOUNT = 0) THEN
2621:
2622: -- No row was updated, So Insert a new row into the interface table
2623: INSERT INTO PA_TSK_BGT_LINES_IT
2624: (
2625: TASK_BUDGET_LINE_KEY,
2626: TASK_ID,
2627: PA_PERIOD_KEY,