APPS.OE_BULK_PROCESS_LINE dependencies on OE_SYS_PARAMETERS

Line 58: AND mic.organization_id = oe_sys_parameters.Value('MASTER_ORGANIZATION_ID') --13653352

54: INTO l_category_id
55: FROM mtl_item_categories mic,
56: mtl_default_category_sets mdc
57: WHERE mic.inventory_item_id = p_item_id
58: AND mic.organization_id = oe_sys_parameters.Value('MASTER_ORGANIZATION_ID') --13653352
59: AND mdc.functional_area_id =7
60: AND mdc.category_set_id = mic.category_set_id;
61: RETURN l_category_id;
62: EXCEPTION

Line 3499: l_AR_Sys_Param_Rec := OE_Sys_Parameters_Pvt.Get_AR_Sys_Params(OE_GLOBALS.G_ORG_ID);

3495: -- EBTax Changes
3496: /*
3497: IF oe_code_control.code_release_level >= '110510' THEN
3498:
3499: l_AR_Sys_Param_Rec := OE_Sys_Parameters_Pvt.Get_AR_Sys_Params(OE_GLOBALS.G_ORG_ID);
3500: l_sob_id := l_AR_Sys_Param_Rec.set_of_books_id;
3501:
3502: SELECT 'VALID'
3503: INTO l_dummy

Line 4318: AND OE_SYS_PARAMETERS.value('LATEST_ACCEPTABLE_DATE_FLAG') ='H' THEN

4314: -- Pack J
4315: -- Latest Acceptable date violation check when flag is set to 'Honor'
4316: -- 3940632 : dates truncated before comparison.
4317: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510'
4318: AND OE_SYS_PARAMETERS.value('LATEST_ACCEPTABLE_DATE_FLAG') ='H' THEN
4319: l_order_date_type_code :=
4320: NVL(OE_BULK_SCHEDULE_UTIL.Get_Date_Type(p_line_rec.header_id(l_index)),'SHIP');
4321: IF trunc(NVL(p_line_rec.latest_acceptable_date(l_index),p_line_rec.request_date(l_index)))
4322: < trunc(p_line_rec.request_date(l_index)) THEN -- LAD less than request date