DBA Data[Home] [Help]

APPS.PA_ADW_COLLECT_DIMENSIONS dependencies on PA_PRJ_ORGS_IT

Line 2853: PA_PRJ_ORGS_IT

2849:
2850: -- First Try to Update the Row in the Interface Table
2851:
2852: UPDATE
2853: PA_PRJ_ORGS_IT
2854: SET
2855: LAST_UPDATE_DATE = TRUNC(SYSDATE),
2856: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
2857: CREATION_DATE = TRUNC(SYSDATE),

Line 2884: INSERT INTO PA_PRJ_ORGS_IT

2880: -- Check If Any row was updated
2881:
2882: IF (SQL%ROWCOUNT = 0) THEN
2883: -- No row was updated, So Insert a new row into the interface table
2884: INSERT INTO PA_PRJ_ORGS_IT
2885: (
2886: ORGANIZATION_ID,
2887: LAST_UPDATE_DATE,
2888: LAST_UPDATED_BY,