[Home] [Help]
725: If the PK2 is Null, then it means that the Application_Short_name in the
726: interface table is invalid.
727:
728: Populating of the Pk2 will avoid the joining of interface table with
729: FND_APPlication to get the application_id from Application_Short_Name
730: */
731: UPDATE amw_cst_waiver_interface acwi
732: SET acwi.pk2 = ( SELECT application_id
733: FROM fnd_application appl
729: FND_APPlication to get the application_id from Application_Short_Name
730: */
731: UPDATE amw_cst_waiver_interface acwi
732: SET acwi.pk2 = ( SELECT application_id
733: FROM fnd_application appl
734: WHERE appl.Application_short_name = acwi.application_short_name)
735: WHERE acwi.batch_id = p_batch_id
736: AND acwi.object_type = 'RESP'
737: AND acwi.application_short_name IS NOT NULL
1096: If the PK2 is Null, then it means that the Application_Short_name in the
1097: interface table is invalid.
1098:
1099: Populating of the Pk2 will avoid the joining of interface table with
1100: FND_APPlication to get the application_id from Application_Short_Name
1101: */
1102: UPDATE amw_cst_waiver_interface acwi
1103: SET acwi.pk2 = ( SELECT application_id
1104: FROM fnd_application appl
1100: FND_APPlication to get the application_id from Application_Short_Name
1101: */
1102: UPDATE amw_cst_waiver_interface acwi
1103: SET acwi.pk2 = ( SELECT application_id
1104: FROM fnd_application appl
1105: WHERE appl.Application_short_name = acwi.application_short_name)
1106: WHERE acwi.object_type = 'RESP'
1107: AND acwi.application_short_name IS NOT NULL
1108: AND acwi.pk2 IS NULL
1585: BULK COLLECT INTO l_appl_id_list,
1586: l_appl_name_list,
1587: l_resp_name_list
1588: FROM FND_RESPONSIBILITY_VL RESP,
1589: FND_APPLICATION_VL APPL
1590: WHERE RESP.RESPONSIBILITY_ID = l_resp_id_list(i)
1591: AND RESP.START_DATE <= SYSDATE
1592: AND (RESP.END_DATE >= SYSDATE OR RESP.END_DATE IS NULL)
1593: AND RESP.APPLICATION_ID=APPL.APPLICATION_ID;
1649: BULK COLLECT INTO l_appl_id_list,
1650: l_appl_name_list,
1651: l_resp_name_list
1652: FROM FND_RESPONSIBILITY_VL RESP,
1653: FND_APPLICATION_VL APPL
1654: WHERE RESP.RESPONSIBILITY_ID = l_function_id_list(i)
1655: AND RESP.START_DATE <= SYSDATE
1656: AND (RESP.END_DATE >= SYSDATE OR RESP.END_DATE IS NULL)
1657: AND RESP.APPLICATION_ID=APPL.APPLICATION_ID
1681: BULK COLLECT INTO l_appl_id_list,
1682: l_appl_name_list,
1683: l_cp_name_list
1684: FROM FND_CONCURRENT_PROGRAMS_VL conc,
1685: FND_APPLICATION_VL appl
1686: WHERE conc.CONCURRENT_PROGRAM_ID=l_function_id_list(i)
1687: AND conc.APPLICATION_ID=appl.APPLICATION_ID
1688: AND conc.ENABLED_FLAG='Y'
1689: ORDER BY APPLICATION_ID;
1746: BULK COLLECT INTO l_appl_id_list,
1747: l_appl_name_list,
1748: l_cp_name_list
1749: FROM FND_CONCURRENT_PROGRAMS_VL conc,
1750: FND_APPLICATION_VL appl
1751: WHERE conc.CONCURRENT_PROGRAM_ID=l_function_id_list(i)
1752: AND conc.APPLICATION_ID=appl.APPLICATION_ID
1753: AND conc.ENABLED_FLAG='Y';
1754:
1800: BULK COLLECT INTO l_appl_id_list,
1801: l_appl_name_list,
1802: l_cp_name_list
1803: FROM FND_CONCURRENT_PROGRAMS_VL conc,
1804: FND_APPLICATION_VL appl
1805: WHERE conc.CONCURRENT_PROGRAM_ID=l_function_id_list(i)
1806: AND conc.APPLICATION_ID=appl.APPLICATION_ID
1807: AND conc.ENABLED_FLAG='Y';
1808:
1860: BULK COLLECT INTO l_appl_id_list,
1861: l_appl_name_list,
1862: l_resp_name_list
1863: FROM FND_RESPONSIBILITY_VL RESP,
1864: FND_APPLICATION_VL APPL
1865: WHERE RESP.RESPONSIBILITY_ID = l_resp_id_list(i)
1866: AND RESP.START_DATE <= SYSDATE
1867: AND (RESP.END_DATE >= SYSDATE OR RESP.END_DATE IS NULL)
1868: AND RESP.APPLICATION_ID=APPL.APPLICATION_ID