DBA Data[Home] [Help]

APPS.PA_ADW_COLLECT_DIMENSIONS dependencies on PA_EXP_ORGS_IT

Line 3094: PA_EXP_ORGS_IT

3090:
3091: -- First Try to Update the Row in the Interface Table
3092:
3093: UPDATE
3094: PA_EXP_ORGS_IT
3095: SET
3096: LAST_UPDATE_DATE = TRUNC(SYSDATE),
3097: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
3098: CREATION_DATE = TRUNC(SYSDATE),

Line 3125: INSERT INTO PA_EXP_ORGS_IT

3121: -- Check If Any row was updated
3122:
3123: IF (SQL%ROWCOUNT = 0) THEN
3124: -- No row was updated, So Insert a new row into the interface table
3125: INSERT INTO PA_EXP_ORGS_IT
3126: (
3127: ORGANIZATION_ID,
3128: LAST_UPDATE_DATE,
3129: LAST_UPDATED_BY,