APPS.OE_PURCHASE_RELEASE_PVT dependencies on FND_PROFILE

Line 143: l_org_id2 := FND_PROFILE.VALUE('OE_ORGANIZATION_ID');

139: -- l_application_id := FND_GLOBAL.RESP_APPL_ID; -- Commented for bug 6118936
140: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
141: -- l_resp_id := FND_GLOBAL.RESP_ID; -- Commented for bug 6118936
142: -- This change is required since we are dropping the profile OE_ORGANIZATION -- _ID. Change made by Esha.
143: l_org_id2 := FND_PROFILE.VALUE('OE_ORGANIZATION_ID');
144: l_org_id := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
145:
146: IF l_debug_level > 0 THEN
147: oe_debug_pub.add('User id => ' ||l_user_id,1);

Line 181: IF FND_PROFILE.VALUE('ONT_INCLUDED_ITEM_FREEZE_METHOD') = OE_GLOBALS.G_IIFM_PICK_RELEASE THEN

177:
178: /* End of bug 6118936 */
179:
180:
181: IF FND_PROFILE.VALUE('ONT_INCLUDED_ITEM_FREEZE_METHOD') = OE_GLOBALS.G_IIFM_PICK_RELEASE THEN
182: IF l_debug_level > 0 THEN
183: oe_debug_pub.add('may need to freeze inc items',5);
184: END IF;
185:

Line 359: -- changed call from fnd_profile.value to oe_profile.value to retrieve profile in created_by context

355: l_source_document_type_id between 11 and 19 THEN -- 11 and 19 for self service orders
356: --R12.MOAC Start
357: -- Call to Oe_Sys_Parameters.Value as profile moved to system parameter
358: /*
359: -- changed call from fnd_profile.value to oe_profile.value to retrieve profile in created_by context
360: l_temp_employee_id := oe_profile.value(p_header_id => null,
361: p_line_id => l_drop_ship_line_rec.line_id,
362: p_profile_option_name => 'ONT_EMP_ID_FOR_SS_ORDERS');
363: */

Line 775: IF NVL(FND_PROFILE.VALUE('INV_PURCHASING_BY_REVISION'),2) = 1 THEN

771: END;
772:
773: -- added for bug 2201362
774: if nvl(l_revision_control_code,1)=2 then
775: IF NVL(FND_PROFILE.VALUE('INV_PURCHASING_BY_REVISION'),2) = 1 THEN
776: BEGIN
777: select MAX(revision)
778: into l_item_revision
779: from mtl_item_revisions mir,

Line 837: l_source_code :=fnd_profile.value('ONT_SOURCE_CODE');

833: oe_debug_pub.add( '----------------------' , 1 ) ;
834: END IF;
835:
836: -- Fix for bug2058542
837: l_source_code :=fnd_profile.value('ONT_SOURCE_CODE');
838: l_prof_value :=fnd_profile.value('ONT_POPULATE_BUYER'); --Fix for bug#2172019
839:
840: IF PO_CODE_RELEASE_GRP.Current_Release >= PO_CODE_RELEASE_GRP.PRC_11i_Family_Pack_J THEN
841: -- SQL Performance ID 14882656

Line 838: l_prof_value :=fnd_profile.value('ONT_POPULATE_BUYER'); --Fix for bug#2172019

834: END IF;
835:
836: -- Fix for bug2058542
837: l_source_code :=fnd_profile.value('ONT_SOURCE_CODE');
838: l_prof_value :=fnd_profile.value('ONT_POPULATE_BUYER'); --Fix for bug#2172019
839:
840: IF PO_CODE_RELEASE_GRP.Current_Release >= PO_CODE_RELEASE_GRP.PRC_11i_Family_Pack_J THEN
841: -- SQL Performance ID 14882656
842: -- Replaced org_organization_definitions with inv_organization_info_v which

Line 1275: l_source_code VARCHAR2(30) := FND_PROFILE.Value('ONT_SOURCE_CODE');

1271: l_process_flag VARCHAR2(30);
1272: l_line_num VARCHAR2(30);
1273:
1274: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1275: l_source_code VARCHAR2(30) := FND_PROFILE.Value('ONT_SOURCE_CODE');
1276: --bug 4411054
1277: l_po_status_rec PO_STATUS_REC_TYPE;
1278: l_autorization_status VARCHAR2(30);
1279: