DBA Data[Home] [Help]

APPS.PA_ADW_COLLECT_DIMENSIONS dependencies on PA_PRJ_CLASSES_IT

Line 1016: PA_PRJ_CLASSES_IT

1012:
1013: -- First Try to Update the Row in the Interface Table
1014:
1015: UPDATE
1016: PA_PRJ_CLASSES_IT
1017: SET
1018: LAST_UPDATE_DATE = TRUNC(SYSDATE),
1019: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
1020: CREATION_DATE = TRUNC(SYSDATE),

Line 1047: INSERT INTO PA_PRJ_CLASSES_IT

1043: -- Check If Any row was updated
1044:
1045: IF (SQL%ROWCOUNT = 0) THEN
1046: -- No row was updated, So Insert a new row into the interface table
1047: INSERT INTO PA_PRJ_CLASSES_IT
1048: (
1049: PROJECT_ID,
1050: CLASS_CATEGORY,
1051: CLASS_CODE,