DBA Data[Home] [Help]

APPS.PA_ADW_COLLECT_DIMENSIONS dependencies on PA_SRVC_TYPES_IT

Line 2584: PA_SRVC_TYPES_IT

2580:
2581: -- First Try to Update the Row in the Interface Table
2582:
2583: UPDATE
2584: PA_SRVC_TYPES_IT
2585: SET
2586: ALL_SERVICE_TYPES = SERVICE_TYPES_R.ALL_SERVICE_TYPES,
2587: LAST_UPDATE_DATE = TRUNC(SYSDATE),
2588: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 2615: INSERT INTO PA_SRVC_TYPES_IT

2611: -- Check If Any row was updated
2612:
2613: IF (SQL%ROWCOUNT = 0) THEN
2614: -- No row was updated, So Insert a new row into the interface table
2615: INSERT INTO PA_SRVC_TYPES_IT
2616: (
2617: SERVICE_TYPE_CODE,
2618: LAST_UPDATE_DATE,
2619: LAST_UPDATED_BY,