eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_ELECMSGS_PVT dependencies on MO_GLOBAL

Line 778: mo_global.set_policy_context(p_access_mode => 'S', p_org_id=>l_Org_Id);

774: IF l_debug_level > 0 THEN
775: oe_debug_pub.add('l_org_id =>' || l_org_id);
776: END IF;
777:
778: mo_global.set_policy_context(p_access_mode => 'S', p_org_id=>l_Org_Id);
779: p_x_result := 'COMPLETE';
780:
781: ELSIF (p_funcmode = 'TEST_CTX') THEN
782:

Line 792: IF (NVL(mo_global.get_current_org_id,-99) <> l_Org_Id)

788: IF l_debug_level > 0 THEN
789: oe_debug_pub.add( 'l_org_id (from workflow)=>'|| l_org_id ) ;
790: END IF;
791:
792: IF (NVL(mo_global.get_current_org_id,-99) <> l_Org_Id)
793: THEN
794: p_x_result := 'FALSE';
795: ELSE
796: p_x_result := 'TRUE';

Line 917: l_org_id := MO_GLOBAL.Get_Current_Org_Id;

913: IF l_org_id IS NULL THEN
914: /* MOAC_SQL_CHANGE */
915: -- SELECT TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ',
916: -- NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))) into l_org_id from DUAL;
917: l_org_id := MO_GLOBAL.Get_Current_Org_Id;
918: IF l_debug_level > 0 THEN
919: oe_debug_pub.add('set org to :'||l_org_id);
920: END IF;
921: END IF;

Line 1225: MO_GLOBAL.Set_Policy_Context ('S', p_operating_unit);

1221: -----------------------------------------------------------
1222:
1223: -- Set the policy context
1224: IF p_operating_unit IS NOT NULL THEN
1225: MO_GLOBAL.Set_Policy_Context ('S', p_operating_unit);
1226: END IF;
1227:
1228: /* this code is no longer necessary as the sold_to_org_id will now be passed in (bug 3396735)
1229: IF p_customer_number IS NOT NULL THEN

Line 2934: AND ((p_operating_unit IS NULL AND MO_GLOBAL.Check_Access (org_id) = l_yes) OR org_id = p_operating_unit);

2930: AND orig_sys_document_ref BETWEEN p_orig_sys_document_ref_from
2931: AND p_orig_sys_document_ref_to
2932: AND sold_to_org_id = nvl(l_sold_to_org_id, sold_to_org_id)
2933: AND nvl(acknowledgment_flag, 'N') = 'Y'
2934: AND ((p_operating_unit IS NULL AND MO_GLOBAL.Check_Access (org_id) = l_yes) OR org_id = p_operating_unit);
2935: ELSIF p_orig_sys_document_ref_from IS NOT NULL THEN
2936: DELETE
2937: FROM OE_Header_Acks
2938: WHERE order_source_id = nvl(p_order_source_id, order_source_id)

Line 2942: AND ((p_operating_unit IS NULL AND MO_GLOBAL.Check_Access (org_id) = l_yes) OR org_id = p_operating_unit);

2938: WHERE order_source_id = nvl(p_order_source_id, order_source_id)
2939: AND orig_sys_document_ref >= p_orig_sys_document_ref_from
2940: AND sold_to_org_id = nvl(l_sold_to_org_id, sold_to_org_id)
2941: AND nvl(acknowledgment_flag, 'N') = 'Y'
2942: AND ((p_operating_unit IS NULL AND MO_GLOBAL.Check_Access (org_id) = l_yes) OR org_id = p_operating_unit);
2943: ELSIF p_orig_sys_document_ref_to IS NOT NULL THEN
2944: DELETE
2945: FROM OE_Header_Acks
2946: WHERE order_source_id = nvl(p_order_source_id, order_source_id)

Line 2950: AND ((p_operating_unit IS NULL AND MO_GLOBAL.Check_Access (org_id) = l_yes) OR org_id = p_operating_unit);

2946: WHERE order_source_id = nvl(p_order_source_id, order_source_id)
2947: AND orig_sys_document_ref <= p_orig_sys_document_ref_to
2948: AND sold_to_org_id = nvl(l_sold_to_org_id, sold_to_org_id)
2949: AND nvl(acknowledgment_flag, 'N') = 'Y'
2950: AND ((p_operating_unit IS NULL AND MO_GLOBAL.Check_Access (org_id) = l_yes) OR org_id = p_operating_unit);
2951: ELSE
2952: DELETE
2953: FROM OE_Header_Acks
2954: WHERE order_source_id = nvl(p_order_source_id, order_source_id)

Line 2958: AND ((p_operating_unit IS NULL AND MO_GLOBAL.Check_Access (org_id) = l_yes) OR org_id = p_operating_unit);

2954: WHERE order_source_id = nvl(p_order_source_id, order_source_id)
2955: AND orig_sys_document_ref >= ' '
2956: AND sold_to_org_id = nvl(l_sold_to_org_id, sold_to_org_id)
2957: AND nvl(acknowledgment_flag, 'N') = 'Y'
2958: AND ((p_operating_unit IS NULL AND MO_GLOBAL.Check_Access (org_id) = l_yes) OR org_id = p_operating_unit);
2959: END IF;
2960: l_count := l_count + SQL%ROWCOUNT;
2961:
2962: IF l_debug_level > 0 THEN

Line 2982: AND ((p_operating_unit IS NULL AND MO_GLOBAL.Check_Access (org_id) = l_yes) OR org_id = p_operating_unit);

2978: AND orig_sys_document_ref BETWEEN p_orig_sys_document_ref_from
2979: AND p_orig_sys_document_ref_to
2980: AND sold_to_org_id = nvl(l_sold_to_org_id, sold_to_org_id)
2981: AND nvl(acknowledgment_flag, 'N') = 'Y'
2982: AND ((p_operating_unit IS NULL AND MO_GLOBAL.Check_Access (org_id) = l_yes) OR org_id = p_operating_unit);
2983: ELSIF p_orig_sys_document_ref_from IS NOT NULL THEN
2984: DELETE
2985: FROM OE_Line_Acks
2986: WHERE order_source_id = nvl(p_order_source_id, order_source_id)

Line 2990: AND ((p_operating_unit IS NULL AND MO_GLOBAL.Check_Access (org_id) = l_yes) OR org_id = p_operating_unit);

2986: WHERE order_source_id = nvl(p_order_source_id, order_source_id)
2987: AND orig_sys_document_ref >= p_orig_sys_document_ref_from
2988: AND sold_to_org_id = nvl(l_sold_to_org_id, sold_to_org_id)
2989: AND nvl(acknowledgment_flag, 'N') = 'Y'
2990: AND ((p_operating_unit IS NULL AND MO_GLOBAL.Check_Access (org_id) = l_yes) OR org_id = p_operating_unit);
2991: ELSIF p_orig_sys_document_ref_to IS NOT NULL THEN
2992: DELETE
2993: FROM OE_Line_Acks
2994: WHERE order_source_id = nvl(p_order_source_id, order_source_id)

Line 2998: AND ((p_operating_unit IS NULL AND MO_GLOBAL.Check_Access (org_id) = l_yes) OR org_id = p_operating_unit);

2994: WHERE order_source_id = nvl(p_order_source_id, order_source_id)
2995: AND orig_sys_document_ref <= p_orig_sys_document_ref_to
2996: AND sold_to_org_id = nvl(l_sold_to_org_id, sold_to_org_id)
2997: AND nvl(acknowledgment_flag, 'N') = 'Y'
2998: AND ((p_operating_unit IS NULL AND MO_GLOBAL.Check_Access (org_id) = l_yes) OR org_id = p_operating_unit);
2999: ELSE
3000: DELETE
3001: FROM OE_Line_Acks
3002: WHERE order_source_id = nvl(p_order_source_id, order_source_id)

Line 3006: AND ((p_operating_unit IS NULL AND MO_GLOBAL.Check_Access (org_id) = l_yes) OR org_id = p_operating_unit);

3002: WHERE order_source_id = nvl(p_order_source_id, order_source_id)
3003: AND orig_sys_document_ref >= ' '
3004: AND sold_to_org_id = nvl(l_sold_to_org_id, sold_to_org_id)
3005: AND nvl(acknowledgment_flag, 'N') = 'Y'
3006: AND ((p_operating_unit IS NULL AND MO_GLOBAL.Check_Access (org_id) = l_yes) OR org_id = p_operating_unit);
3007: END IF;
3008:
3009: l_count := l_count + SQL%ROWCOUNT;
3010: IF l_debug_level > 0 THEN