DBA Data[Home] [Help]

APPS.PA_ADW_COLLECT_DIMENSIONS dependencies on PA_PRJ_TYPES_IT

Line 614: PA_PRJ_TYPES_IT

610:
611: -- First Try to Update the Row in the Interface Table
612:
613: UPDATE
614: PA_PRJ_TYPES_IT
615: SET
616: ALL_PROJECT_TYPES = PROJECT_TYPES_R.ALL_PROJECT_TYPES,
617: LAST_UPDATE_DATE = TRUNC(SYSDATE),
618: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 645: INSERT INTO PA_PRJ_TYPES_IT

641: -- Check If Any row was updated
642:
643: IF (SQL%ROWCOUNT = 0) THEN
644: -- No row was updated, So Insert a new row into the interface table
645: INSERT INTO PA_PRJ_TYPES_IT
646: (
647: PROJECT_TYPE,
648: LAST_UPDATE_DATE,
649: LAST_UPDATED_BY,