DBA Data[Home] [Help]

APPS.ONT_OEXOHHSA_XMLP_PKG dependencies on MO_GLOBAL

Line 36: --P_ORGANIZATION_ID := MO_GLOBAL.GET_CURRENT_ORG_ID;

32: /*RAISE SRW.PROGRAM_ABORT*/RAISE_APPLICATION_ERROR(-20101,null);
33: RETURN (FALSE);
34: END;
35: BEGIN
36: --P_ORGANIZATION_ID := MO_GLOBAL.GET_CURRENT_ORG_ID;
37: P_ORGANIZATION_ID_V := MO_GLOBAL.GET_CURRENT_ORG_ID;
38: END;
39: END BEFOREREPORT;
40:

Line 37: P_ORGANIZATION_ID_V := MO_GLOBAL.GET_CURRENT_ORG_ID;

33: RETURN (FALSE);
34: END;
35: BEGIN
36: --P_ORGANIZATION_ID := MO_GLOBAL.GET_CURRENT_ORG_ID;
37: P_ORGANIZATION_ID_V := MO_GLOBAL.GET_CURRENT_ORG_ID;
38: END;
39: END BEFOREREPORT;
40:
41: FUNCTION AFTERREPORT RETURN BOOLEAN IS

Line 143: ,MO_GLOBAL.GET_CURRENT_ORG_ID)

139: MTL_SYSTEM_ITEMS_VL
140: WHERE INVENTORY_ITEM_ID = OBJECT_ID
141: AND NVL(ORGANIZATION_ID
142: ,0) = NVL(OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID'
143: ,MO_GLOBAL.GET_CURRENT_ORG_ID)
144: ,0);
145: ELSE
146: IF OBJECT_TYPE_CODE = 'S' THEN
147: SELECT

Line 160: AND SU.ORG_ID = MO_GLOBAL.GET_CURRENT_ORG_ID

156: HZ_LOCATIONS LOC,
157: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
158: WHERE SU.SITE_USE_ID = OBJECT_ID
159: AND SU.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
160: AND SU.ORG_ID = MO_GLOBAL.GET_CURRENT_ORG_ID
161: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
162: AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID
163: AND LOC.LOCATION_ID = LOC_ASSIGN.LOCATION_ID
164: AND NVL(ACCT_SITE.ORG_ID

Line 284: ,MO_GLOBAL.GET_CURRENT_ORG_ID)

280: MTL_SYSTEM_ITEMS_VL
281: WHERE INVENTORY_ITEM_ID = OBJECT_ID2
282: AND NVL(ORGANIZATION_ID
283: ,0) = NVL(OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID'
284: ,MO_GLOBAL.GET_CURRENT_ORG_ID)
285: ,0);
286: ELSE
287: IF OBJECT_TYPE_CODE2 = 'S' THEN
288: SELECT

Line 301: AND SU.ORG_ID = MO_GLOBAL.GET_CURRENT_ORG_ID

297: HZ_LOCATIONS LOC,
298: HZ_CUST_ACCT_SITES_ALL ACCT_SITE
299: WHERE SU.SITE_USE_ID = OBJECT_ID2
300: AND SU.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
301: AND SU.ORG_ID = MO_GLOBAL.GET_CURRENT_ORG_ID
302: AND ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID
303: AND LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID
304: AND LOC.LOCATION_ID = LOC_ASSIGN.LOCATION_ID
305: AND NVL(ACCT_SITE.ORG_ID