DBA Data[Home] [Help]

APPS.PA_ADW_COLLECT_DIMENSIONS dependencies on PA_CLASS_CODES_IT

Line 1332: PA_CLASS_CODES_IT

1328:
1329: -- First Try to Update the Row in the Interface Table
1330:
1331: UPDATE
1332: PA_CLASS_CODES_IT
1333: SET
1334: DESCRIPTION = CLASS_CODES_R.DESCRIPTION,
1335: LAST_UPDATE_DATE = TRUNC(SYSDATE),
1336: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 1363: INSERT INTO PA_CLASS_CODES_IT

1359: -- Check If Any row was updated
1360:
1361: IF (SQL%ROWCOUNT = 0) THEN
1362: -- No row was updated, So Insert a new row into the interface table
1363: INSERT INTO PA_CLASS_CODES_IT
1364: (
1365: CLASS_CATEGORY,
1366: CLASS_CODE,
1367: DESCRIPTION,