APPS.OE_HOLDS_PUB dependencies on OE_SYS_PARAMETERS

Line 412: AND ic.organization_id = oe_sys_parameters.Value('MASTER_ORGANIZATION_ID') --13653352

408: mtl_item_categories ic
409: WHERE l.LINE_ID = p_line_id
410: AND ic.category_id = p_hold_entity_id
411: AND l.INVENTORY_ITEM_ID = ic.inventory_item_id
412: AND ic.organization_id = oe_sys_parameters.Value('MASTER_ORGANIZATION_ID') --13653352
413: AND nvl(l.TRANSACTION_PHASE_CODE,'F') = 'F';
414: EXCEPTION
415: WHEN NO_DATA_FOUND THEN
416: oe_debug_pub.add('In No Data Found for 13331078 HEI= '||p_hold_entity_id||' LineId= '||p_line_id);

Line 1836: --7832836 l_cascade_hold_non_smc VARCHAR2(1) := NVL(OE_SYS_PARAMETERS.VALUE('ONT_CASCADE_HOLD_NONSMC_PTO'),'N'); --ER#7479609

1832: where top_model_line_id = l_top_model_line_id;
1833: --
1834: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1835: --
1836: --7832836 l_cascade_hold_non_smc VARCHAR2(1) := NVL(OE_SYS_PARAMETERS.VALUE('ONT_CASCADE_HOLD_NONSMC_PTO'),'N'); --ER#7479609
1837: l_cascade_hold_non_smc VARCHAR2(1); -- 7832836
1838: l_org_id NUMBER; -- 7832836
1839: BEGIN
1840: IF l_debug_level > 0 THEN

Line 1902: l_cascade_hold_non_smc := NVL(OE_SYS_PARAMETERS.VALUE('ONT_CASCADE_HOLD_NONSMC_PTO',l_org_id),'N');

1898: x_result_out := FND_API.G_FALSE;
1899: END;
1900: END IF;
1901:
1902: l_cascade_hold_non_smc := NVL(OE_SYS_PARAMETERS.VALUE('ONT_CASCADE_HOLD_NONSMC_PTO',l_org_id),'N');
1903: --7832836 end
1904:
1905: /*
1906: ** Checking for HEADER level generic holds and activity specific holds

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

3929: select 'Y' into l_valid_itemcat
3930: from mtl_item_categories mic,
3931: mtl_default_category_sets mdc
3932: where mic.inventory_item_id = l_line_rec.inventory_item_id
3933: and mic.organization_id = oe_sys_parameters.Value('MASTER_ORGANIZATION_ID') --13653352
3934: and mic.category_id = l_hold_entity_id
3935: AND mdc.functional_area_id=7
3936: AND mdc.category_set_id = mic.category_set_id;
3937: EXCEPTION WHEN OTHERS THEN

Line 4581: l_credithold_cust VARCHAR2(10) := NVL(OE_SYS_PARAMETERS.value('ONT_CREDITHOLD_TYPE'),'S') ;

4577: --
4578: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4579: --
4580: -- ER#3667551 START to hold System Parameter value
4581: l_credithold_cust VARCHAR2(10) := NVL(OE_SYS_PARAMETERS.value('ONT_CREDITHOLD_TYPE'),'S') ;
4582: l_new_tbl_entry CHAR:='';
4583: l_bill_to_orgid NUMBER := 0;
4584: l_ch_level varchar2(10) := '';
4585: --ER# 3667551 END

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

4826: into l_entity_tab(m_counter).entity_id
4827: from mtl_item_categories mic,
4828: mtl_default_category_sets mdc
4829: where mic.inventory_item_id = l_line_rec.inventory_item_id
4830: AND mic.organization_id = oe_sys_parameters.Value('MASTER_ORGANIZATION_ID') --13653352
4831: AND mdc.functional_area_id=7
4832: AND mdc.category_set_id = mic.category_set_id;
4833: EXCEPTION
4834: WHEN NO_DATA_FOUND THEN