DBA Data[Home] [Help]

APPS.PA_ADW_COLLECT_DIMENSIONS dependencies on PA_CLASS_CATGS_IT

Line 1176: PA_CLASS_CATGS_IT

1172:
1173: -- First Try to Update the Row in the Interface Table
1174:
1175: UPDATE
1176: PA_CLASS_CATGS_IT
1177: SET
1178: DESCRIPTION = CLASS_CATEGORIES_R.DESCRIPTION,
1179: LAST_UPDATE_DATE = TRUNC(SYSDATE),
1180: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 1206: INSERT INTO PA_CLASS_CATGS_IT

1202: -- Check If Any row was updated
1203:
1204: IF (SQL%ROWCOUNT = 0) THEN
1205: -- No row was updated, So Insert a new row into the interface table
1206: INSERT INTO PA_CLASS_CATGS_IT
1207: (
1208: CLASS_CATEGORY,
1209: DESCRIPTION,
1210: LAST_UPDATE_DATE,