APPS.EAM_WORKORDER_UTIL_PKG dependencies on FND_PROFILE

Line 299: l_seq_increment := to_number(nvl(fnd_profile.value('BOM:ITEM_SEQUENCE_INCREMENT'),'10'));

295: into l_item_sequence_num
296: from bom_inventory_components
297: where bill_sequence_id=l_bill_sequence_id;
298:
299: l_seq_increment := to_number(nvl(fnd_profile.value('BOM:ITEM_SEQUENCE_INCREMENT'),'10'));
300: l_item_sequence_num := l_item_sequence_num + l_seq_increment;
301:
302: RETURN l_item_sequence_num;
303: EXCEPTION

Line 316: l_seq_increment := to_number(nvl(fnd_profile.value('BOM:ITEM_SEQUENCE_INCREMENT'),'10'));

312: RETURN;
313: end if;
314: -- Bug# 3844669 : Added code to compute current starting item sequence number in assembly item BOM.
315: l_start_item_seq_number := get_item_sequence_num(i_organization_id, i_asset_group_id);
316: l_seq_increment := to_number(nvl(fnd_profile.value('BOM:ITEM_SEQUENCE_INCREMENT'),'10'));
317: -- Construct the Components Table
318: l_index1 := i_component_table.FIRST;
319: l_index2 := 1;
320: select concatenated_segments

Line 683: and NVL(l_org_id, fnd_profile.value_specific('ORG_ID', NULL,

679: and nvl(furg.start_date, sysdate) <= sysdate
680: and nvl(furg.end_date, sysdate) >= sysdate
681: and nvl(p_resp_app_id, fr.application_id) = fr.application_id
682: and eam_workorder_util_pkg.menu_has_function(fr.menu_id, p_function_id) > 0
683: and NVL(l_org_id, fnd_profile.value_specific('ORG_ID', NULL,
684: fr.responsibility_id, furg.responsibility_application_id)) =
685: fnd_profile.value_specific('ORG_ID', NULL,
686: fr.responsibility_id, furg.responsibility_application_id)
687: and ROWNUM=1;

Line 685: fnd_profile.value_specific('ORG_ID', NULL,

681: and nvl(p_resp_app_id, fr.application_id) = fr.application_id
682: and eam_workorder_util_pkg.menu_has_function(fr.menu_id, p_function_id) > 0
683: and NVL(l_org_id, fnd_profile.value_specific('ORG_ID', NULL,
684: fr.responsibility_id, furg.responsibility_application_id)) =
685: fnd_profile.value_specific('ORG_ID', NULL,
686: fr.responsibility_id, furg.responsibility_application_id)
687: and ROWNUM=1;
688:
689: BEGIN

Line 690: fnd_profile.get('ORG_ID', l_org_id);

686: fr.responsibility_id, furg.responsibility_application_id)
687: and ROWNUM=1;
688:
689: BEGIN
690: fnd_profile.get('ORG_ID', l_org_id);
691: open C_RESPS ;
692: fetch C_RESPS into l_resp_key, l_resp_id, l_resp_app_id, l_menu_id;
693: if( C_RESPS%NOTFOUND ) then
694: l_resp_id:=-1;

Line 736: fnd_profile.get('MFG_ORGANIZATION_ID', l_organization_id);

732: and oav.resp_application_id=426
733: and ROWNUM=1;
734:
735: BEGIN
736: fnd_profile.get('MFG_ORGANIZATION_ID', l_organization_id);
737: open C_RESPS ;
738: fetch C_RESPS into l_resp_key, l_resp_id, l_resp_app_id, l_menu_id;
739: if( C_RESPS%NOTFOUND ) then
740: FND_MESSAGE.SET_NAME('EAM', 'EAM_ORG_ACCESS_VIOLATION');