APPS.PA_CLIENT_EXTN_GEN_ASSET_LINES dependencies on IPA_ASSET_MECH_APIS_PKG

Line 33: /* Bug 7524772: Broke this cursor into two cursors based on the condition IPA_ASSET_MECH_APIS_PKG.g_nl_installed to facilitate proper index to be picked up*/

29: x_asset_id IN OUT NOCOPY NUMBER) IS
30:
31: nl_installed VARCHAR2(1); -- bug 7524772
32:
33: /* Bug 7524772: Broke this cursor into two cursors based on the condition IPA_ASSET_MECH_APIS_PKG.g_nl_installed to facilitate proper index to be picked up*/
34: /* cursor get_project_asset_id is
35: select project_asset_id
36: from pa_project_asset_assignments ppaa
37: where ppaa.task_id = p_task_id

Line 43: AND ( (NVL(IPA_ASSET_MECH_APIS_PKG.g_nl_installed,'N') = 'Y'

39: and nvl(ppaa.attribute8,'~!@#') = nvl(p_attribute8,'~!@#')
40: and nvl(ppaa.attribute9,'~!@#') = nvl(p_attribute9,'~!@#')
41: and nvl(ppaa.attribute10,'~!@#') = nvl(p_attribute10,'~!@#')
42: /* Start Bug fix:2956569 : attribute6,7 Should be used only when the nl_installed flag = Y
43: AND ( (NVL(IPA_ASSET_MECH_APIS_PKG.g_nl_installed,'N') = 'Y'
44: AND nvl(ppaa.attribute6,'~!@#') = nvl(p_attribute6, '~!@#') --crl_inventory
45: AND nvl(ppaa.attribute7,'~!@#') = nvl(p_attribute7, '~!@#') --serial_number
46: )
47: OR

Line 48: NVL(IPA_ASSET_MECH_APIS_PKG.g_nl_installed,'N') = 'N'

44: AND nvl(ppaa.attribute6,'~!@#') = nvl(p_attribute6, '~!@#') --crl_inventory
45: AND nvl(ppaa.attribute7,'~!@#') = nvl(p_attribute7, '~!@#') --serial_number
46: )
47: OR
48: NVL(IPA_ASSET_MECH_APIS_PKG.g_nl_installed,'N') = 'N'
49: );
50: End Bug fix:2956569 */
51:
52: cursor get_project_asset_id_nl_ins is

Line 88: nl_installed:= NVL(IPA_ASSET_MECH_APIS_PKG.g_nl_installed,'N');

84: v_project_asset_id number;
85: l_crl_rec ipa_asset_naming_convents_all.asset_name_id%TYPE;
86: BEGIN
87:
88: nl_installed:= NVL(IPA_ASSET_MECH_APIS_PKG.g_nl_installed,'N');
89:
90: /* Adding another check for IPA for bug 5637615 */
91: OPEN get_crl_instal_rec;
92: FETCH get_crl_instal_rec into l_crl_rec;