APPS.OE_PURCHASE_RELEASE_PVT dependencies on FND_PROFILE

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

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

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

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

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

806: END;
807:
808: -- added for bug 2201362
809: if nvl(l_revision_control_code,1)=2 then
810: IF NVL(FND_PROFILE.VALUE('INV_PURCHASING_BY_REVISION'),2) = 1 THEN
811: BEGIN
812: select MAX(revision)
813: into l_item_revision
814: from mtl_item_revisions mir,

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

868: oe_debug_pub.add( '----------------------' , 1 ) ;
869: END IF;
870:
871: -- Fix for bug2058542
872: l_source_code :=fnd_profile.value('ONT_SOURCE_CODE');
873: l_prof_value :=fnd_profile.value('ONT_POPULATE_BUYER'); --Fix for bug#2172019
874:
875: IF PO_CODE_RELEASE_GRP.Current_Release >= PO_CODE_RELEASE_GRP.PRC_11i_Family_Pack_J THEN
876: -- SQL Performance ID 14882656

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

869: END IF;
870:
871: -- Fix for bug2058542
872: l_source_code :=fnd_profile.value('ONT_SOURCE_CODE');
873: l_prof_value :=fnd_profile.value('ONT_POPULATE_BUYER'); --Fix for bug#2172019
874:
875: IF PO_CODE_RELEASE_GRP.Current_Release >= PO_CODE_RELEASE_GRP.PRC_11i_Family_Pack_J THEN
876: -- SQL Performance ID 14882656
877: -- Replaced org_organization_definitions with inv_organization_info_v which

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

1306: l_process_flag VARCHAR2(30);
1307: l_line_num VARCHAR2(30);
1308:
1309: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1310: l_source_code VARCHAR2(30) := FND_PROFILE.Value('ONT_SOURCE_CODE');
1311: --bug 4411054
1312: l_po_status_rec PO_STATUS_REC_TYPE;
1313: l_autorization_status VARCHAR2(30);
1314: