APPS.OE_BULK_HOLDS_PVT dependencies on OE_SYS_PARAMETERS

Line 1409: l_credithold_syspar varchar2(10) := NVL(OE_SYS_PARAMETERS.value('ONT_CREDITHOLD_TYPE'),'S') ;

1405:
1406: l_itemcategory_id NUMBER :=''; --ER# 13331078
1407:
1408: --ER# 3667551 start
1409: l_credithold_syspar varchar2(10) := NVL(OE_SYS_PARAMETERS.value('ONT_CREDITHOLD_TYPE'),'S') ;
1410: l_custlin_hold CHAR := 'N';
1411: l_invoice_Custid NUMBER := 0;
1412: --ER# 3667551 end;
1413:

Line 1733: and mic.organization_id = oe_sys_parameters.Value('MASTER_ORGANIZATION_ID') --13653352

1729: into l_itemcategory_id
1730: from mtl_item_categories mic,
1731: mtl_default_category_sets mdc
1732: where mic.inventory_item_id = p_line_rec.inventory_item_id
1733: and mic.organization_id = oe_sys_parameters.Value('MASTER_ORGANIZATION_ID') --13653352
1734: AND mdc.functional_area_id=7
1735: AND mdc.category_set_id = mic.category_set_id;
1736: EXCEPTION WHEN OTHERS THEN
1737: l_itemcategory_id := '';