DBA Data[Home] [Help]

APPS.PA_ADW_COLLECT_DIMENSIONS dependencies on PA_TOP_RLMEM_IT

Line 1632: PA_TOP_RLMEM_IT

1628: FOR top_res_members_r IN sel_top_res_members LOOP
1629:
1630: -- First Try to Update the Row in the Interface Table
1631: UPDATE
1632: PA_TOP_RLMEM_IT
1633: SET
1634: RESOURCE_LIST_ID = TOP_RES_MEMBERS_R.RESOURCE_LIST_ID,
1635: NAME = TOP_RES_MEMBERS_R.NAME,
1636: ALIAS = TOP_RES_MEMBERS_R.ALIAS,

Line 1664: INSERT INTO PA_TOP_RLMEM_IT

1660: -- Check If Any row was updated
1661:
1662: IF (SQL%ROWCOUNT = 0) THEN
1663: -- No row was updated, So Insert a new row into the interface table
1664: INSERT INTO PA_TOP_RLMEM_IT
1665: (
1666: RESOURCE_LIST_MEMBER_ID,
1667: RESOURCE_LIST_ID,
1668: NAME,