APPS.OE_ITORD_UTIL dependencies on OE_SYS_PARAMETERS

Line 22: AND ic.organization_id=oe_sys_parameters.Value('MASTER_ORGANIZATION_ID')

18: from mtl_item_categories ic,
19: MTL_DEFAULT_CATEGORY_SETS CS
20: where ic.category_set_id=cs.category_set_id
21: AND CS.functional_area_id = 7
22: AND ic.organization_id=oe_sys_parameters.Value('MASTER_ORGANIZATION_ID')
23: AND IC.INVENTORY_ITEM_ID = p_inventory_item_id ;
24:
25: G_INVENTORY_ITEM_ID := p_inventory_item_id;
26: G_ITEM_CATEGORY_ID := l_item_category_id;

Line 173: and organization_id = oe_sys_parameters.Value('MASTER_ORGANIZATION_ID');

169: select concatenated_segments
170: into l_item
171: from mtl_system_items_kfv
172: where inventory_item_id = p_inventory_item_id
173: and organization_id = oe_sys_parameters.Value('MASTER_ORGANIZATION_ID');
174:
175: return l_item;
176:
177: Exception

Line 234: oe_debug_pub.add(' Set Globals - ITEM_VALIDATION_ORG_ID :'|| OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID'));

230: oe_debug_pub.add(' Set Globals - P_END_CUSTOMER_ID :'||P_END_CUSTOMER_ID );
231: oe_debug_pub.add(' Set Globals - P_INVOICE_TO_ORG_ID :'||P_INVOICE_TO_ORG_ID);
232: oe_debug_pub.add(' Set Globals - P_DELIVER_TO_ORG_ID :'||P_DELIVER_TO_ORG_ID);
233: oe_debug_pub.add(' Set Globals - OPERATING_UNIT_ID :'|| mo_global.get_current_org_id);
234: oe_debug_pub.add(' Set Globals - ITEM_VALIDATION_ORG_ID :'|| OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID'));
235: END IF;
236:
237: G_CUSTOMER_ID := P_CUSTOMER_ID;
238: G_CUSTOMER_CLASS_ID := P_CUSTOMER_CLASS_ID;

Line 250: G_ITEM_VALIDATION_ORG_ID := OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID');

246: G_INVOICE_TO_ORG_ID := P_INVOICE_TO_ORG_ID;
247: G_DELIVER_TO_ORG_ID := P_DELIVER_TO_ORG_ID;
248:
249: G_OPERATING_UNIT_ID := mo_global.get_current_org_id;
250: G_ITEM_VALIDATION_ORG_ID := OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID');
251: Exception
252: when others then
253: null;
254: End set_globals;