DBA Data[Home] [Help]

APPS.PA_ADW_COLLECT_DIMENSIONS dependencies on PA_RES_LISTS_IT

Line 1807: PA_RES_LISTS_IT

1803:
1804: -- First Try to Update the Row in the Interface Table
1805:
1806: UPDATE
1807: PA_RES_LISTS_IT
1808: SET
1809: NAME = RESOURCE_LISTS_R.NAME,
1810: LAST_UPDATE_DATE = TRUNC(SYSDATE),
1811: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 1838: INSERT INTO PA_RES_LISTS_IT

1834: -- Check If Any row was updated
1835:
1836: IF (SQL%ROWCOUNT = 0) THEN
1837: -- No row was updated, So Insert a new row into the interface table
1838: INSERT INTO PA_RES_LISTS_IT
1839: (
1840: RESOURCE_LIST_ID,
1841: LAST_UPDATE_DATE,
1842: LAST_UPDATED_BY,