DBA Data[Home] [Help]

APPS.PA_ADW_COLLECT_DIMENSIONS dependencies on PA_CLASS_CODES

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,

Line 1421: PA_CLASS_CODES

1417:
1418: -- Mark the class categories as transferred to Interface table
1419:
1420: UPDATE
1421: PA_CLASS_CODES
1422: SET
1423: ADW_NOTIFY_FLAG = 'N'
1424: WHERE
1425: CLASS_CATEGORY = CLASS_CODES_R.CLASS_CATEGORY