DBA Data[Home] [Help]

APPS.PA_ADW_COLLECT_DIMENSIONS dependencies on PA_OPER_UNITS_IT

Line 3242: PA_OPER_UNITS_IT

3238:
3239: -- First Try to Update the Row in the Interface Table
3240:
3241: UPDATE
3242: PA_OPER_UNITS_IT
3243: SET
3244: LAST_UPDATE_DATE = TRUNC(SYSDATE),
3245: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
3246: CREATION_DATE = TRUNC(SYSDATE),

Line 3274: INSERT INTO PA_OPER_UNITS_IT

3270: -- Check If Any row was updated
3271:
3272: IF (SQL%ROWCOUNT = 0) THEN
3273: -- No row was updated, So Insert a new row into the interface table
3274: INSERT INTO PA_OPER_UNITS_IT
3275: (
3276: ORGANIZATION_ID,
3277: LAST_UPDATE_DATE,
3278: LAST_UPDATED_BY,