DBA Data[Home] [Help]

APPS.PA_ADW_COLLECT_DIMENSIONS dependencies on PA_ORGS_IT

Line 3001: PA_ORGS_IT

2997:
2998: -- First Try to Update the Row in the Interface Table
2999:
3000: UPDATE
3001: PA_ORGS_IT
3002: SET
3003: LAST_UPDATE_DATE = TRUNC(SYSDATE),
3004: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
3005: CREATION_DATE = TRUNC(SYSDATE),

Line 3032: INSERT INTO PA_ORGS_IT

3028: -- Check If Any row was updated
3029:
3030: IF (SQL%ROWCOUNT = 0) THEN
3031: -- No row was updated, So Insert a new row into the interface table
3032: INSERT INTO PA_ORGS_IT
3033: (
3034: ORGANIZATION_ID,
3035: LAST_UPDATE_DATE,
3036: LAST_UPDATED_BY,