DBA Data[Home] [Help]

APPS.PA_ADW_COLLECT_DIMENSIONS dependencies on PA_EXP_BUSINESS_GRPS_IT

Line 3187: PA_EXP_BUSINESS_GRPS_IT

3183:
3184: -- First Try to Update the Row in the Interface Table
3185:
3186: UPDATE
3187: PA_EXP_BUSINESS_GRPS_IT
3188: SET
3189: LAST_UPDATE_DATE = TRUNC(SYSDATE),
3190: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
3191: CREATION_DATE = TRUNC(SYSDATE),

Line 3204: INSERT INTO PA_EXP_BUSINESS_GRPS_IT

3200: BUSINESS_GROUP = exp_bsns_grp_r.BUSINESS_GROUP;
3201:
3202: IF (SQL%ROWCOUNT = 0) THEN
3203: -- No row was updated, So Insert a new row into the interface table
3204: INSERT INTO PA_EXP_BUSINESS_GRPS_IT
3205: (
3206: BUSINESS_GROUP,
3207: LAST_UPDATE_DATE,
3208: LAST_UPDATED_BY,