DBA Data[Home] [Help]

APPS.OE_PURCHASE_RELEASE_PVT dependencies on OE_SYS_PARAMETERS

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

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

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

356: END IF;
357:
358: IF l_order_source_id between 11 and 19 OR
359: l_source_document_type_id between 11 and 19 THEN -- 11 and 19 for self service orders
360: l_temp_employee_id := Oe_Sys_Parameters.Value('ONT_EMP_ID_FOR_SS_ORDERS',l_ou_id);
361: IF l_debug_level > 0 THEN
362: oe_debug_pub.add('Assigning employee id to this order as -> '||to_char ( l_temp_employee_id ),5);
363: END IF;
364: l_drop_ship_line_rec.employee_id := l_temp_employee_id;

Line 373: l_temp_employee_id := Oe_Sys_Parameters.Value('ONT_EMP_ID_DEFAULT', l_ou_id);

369: ELSE
370: IF l_debug_level > 0 THEN
371: Oe_debug_pub.add('Non self service order line with invalid employee...', 5);
372: END IF;
373: l_temp_employee_id := Oe_Sys_Parameters.Value('ONT_EMP_ID_DEFAULT', l_ou_id);
374:
375: IF l_debug_level > 0 THEN
376: oe_debug_pub.add('Assigning employee ID as -> '|| l_temp_employee_id, 5);
377: END IF;