DBA Data[Home] [Help]

APPS.OE_PURCHASE_RELEASE_PVT dependencies on OE_SYS_PARAMETERS

Line 144: l_org_id := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');

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);
148: oe_debug_pub.add('Responsibility id => ' ||l_resp_id,1);

Line 357: -- Call to Oe_Sys_Parameters.Value as profile moved to system parameter

353: END IF;
354: IF l_order_source_id between 11 and 19 OR
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,

Line 364: l_temp_employee_id := Oe_Sys_Parameters.Value('ONT_EMP_ID_FOR_SS_ORDERS',l_ou_id);

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: */
364: l_temp_employee_id := Oe_Sys_Parameters.Value('ONT_EMP_ID_FOR_SS_ORDERS',l_ou_id);
365: --R12.MOAC End
366: IF l_debug_level > 0 THEN
367: oe_debug_pub.add('Assigning employee id to this order as -> '||to_char ( l_temp_employee_id ),5);
368: END IF;