APPS.ONT_OEXOEUBK_XMLP_PKG dependencies on MO_GLOBAL

Line 22: and nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)

18: into v_item,v_description
19: from mtl_system_items_vl sitems
20: where sitems.customer_order_enabled_flag = 'Y'
21:
22: and nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)
23: and sitems.inventory_item_id = inventory_item_id_L;
24: /*
25: srw.reference (:p_item_flex_code);
26: srw.reference (:Item_dsp);

Line 49: and nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)

45: mtl_system_items_vl sitems
46: where citems.customer_item_id = cxref.customer_item_id
47: and cxref.inventory_item_id = sitems.inventory_item_id
48: and citems.customer_item_id = ordered_item_id_L
49: and nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)
50: and sitems.inventory_item_id = inventory_item_id_L;
51: -- and sitems.customer_order_enabled_flag = 'Y'
52: -- and sitems.bom_item_type in (1,4)
53: elsif (p_print_description in ('C','P','O')) then

Line 65: and nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)

61: where xtypes.cross_reference_type = items.cross_reference_type
62: and items.inventory_item_id = sitems.inventory_item_id
63: and items.cross_reference = ordered_item_L
64: and items.cross_reference_type = item_identifier_type_L
65: and nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)
66: and sitems.inventory_item_id = inventory_item_id_L
67: --Bug 3433353 Being
68: and items.org_independent_flag = 'N'
69: and items.organization_id = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0);

Line 69: and items.organization_id = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0);

65: and nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)
66: and sitems.inventory_item_id = inventory_item_id_L
67: --Bug 3433353 Being
68: and items.org_independent_flag = 'N'
69: and items.organization_id = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0);
70: -- and sitems.customer_order_enabled_flag = 'Y'
71: -- and sitems.bom_item_type in (1,4)
72: Exception When NO_DATA_FOUND Then
73: select items.cross_reference item,

Line 85: and nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)

81: and items.inventory_item_id =
82: sitems.inventory_item_id
83: and items.cross_reference = ordered_item_L
84: and items.cross_reference_type = item_identifier_type_L
85: and nvl(sitems.organization_id,0) = nvl(oe_sys_parameters.value('MASTER_ORGANIZATION_ID',mo_global.get_current_org_id()),0)
86: and sitems.inventory_item_id = inventory_item_id_L
87: and items.org_independent_flag = 'Y';
88: End;
89: --Bug 3433353 End

Line 122: --P_ORGANIZATION_ID:= MO_GLOBAL.GET_CURRENT_ORG_ID();

118: END;
119:
120: BEGIN /*MOAC*/
121:
122: --P_ORGANIZATION_ID:= MO_GLOBAL.GET_CURRENT_ORG_ID();
123: P_ORGANIZATION_ID1:= MO_GLOBAL.GET_CURRENT_ORG_ID();
124:
125: END;
126:

Line 123: P_ORGANIZATION_ID1:= MO_GLOBAL.GET_CURRENT_ORG_ID();

119:
120: BEGIN /*MOAC*/
121:
122: --P_ORGANIZATION_ID:= MO_GLOBAL.GET_CURRENT_ORG_ID();
123: P_ORGANIZATION_ID1:= MO_GLOBAL.GET_CURRENT_ORG_ID();
124:
125: END;
126:
127: /*------------------------------------------------------------------------------

Line 241: IF Oe_Sys_Parameters.Value('RECURRING_CHARGES',mo_global.get_current_org_id())='Y' Then

237: || ' To ' ||nvl(to_char(P_Order_date_high, 'DD-MON-RRRR'), ' ');
238: end if;
239: END;
240: END ;
241: IF Oe_Sys_Parameters.Value('RECURRING_CHARGES',mo_global.get_current_org_id())='Y' Then
242: C_PERIODICITY_DSP_FLAG := 'Y';
243: ELSE
244: C_PERIODICITY_DSP_FLAG := 'N';
245: END IF;

Line 397: ,MO_GLOBAL.GET_CURRENT_ORG_ID)

393: V_MASTER_ORG VARCHAR2(20);
394: BEGIN
395: SELECT
396: NVL(OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID'
397: ,MO_GLOBAL.GET_CURRENT_ORG_ID)
398: ,0)
399: INTO V_MASTER_ORG
400: FROM
401: DUAL;