DBA Data[Home] [Help]

APPS.PO_MOAC_UTILS_PVT dependencies on MO_GLOBAL

Line 65: l_is_mo_init_done := MO_GLOBAL.is_mo_init_done;

61: -- bug5562486
62: -- Rewrote the whole procedure to call expensive MO init procedure only when
63: -- absolutely necessary
64:
65: l_is_mo_init_done := MO_GLOBAL.is_mo_init_done;
66:
67: IF (l_is_mo_init_done <> 'Y') THEN
68: PO_MOAC_UTILS_PVT.initialize;
69: END IF;

Line 75: l_access_mode := MO_GLOBAL.get_access_mode;

71: l_progress := '020';
72:
73: IF (p_org_id IS NOT NULL) THEN
74:
75: l_access_mode := MO_GLOBAL.get_access_mode;
76:
77: IF ( l_access_mode = 'S') THEN
78:
79: l_current_org_id := PO_MOAC_UTILS_PVT.get_current_org_id;

Line 177: -- is a wrapper that makes a call to MO_GLOBAL.GET_CURRENT_ORG_ID.

173: --Function:
174: -- This function would be used to return current org_id. This function would
175: -- return the ORG ID set for the current session if the context is set to
176: -- Single, for Multi-context this function would return NULL. This function
177: -- is a wrapper that makes a call to MO_GLOBAL.GET_CURRENT_ORG_ID.
178: --Parameters:
179: --IN:
180: -- None.
181: --IN OUT:

Line 200: RETURN MO_GLOBAL.GET_CURRENT_ORG_ID();

196: IS
197: l_progress VARCHAR2(3) := NULL;
198: BEGIN
199: l_progress := '010';
200: RETURN MO_GLOBAL.GET_CURRENT_ORG_ID();
201: EXCEPTION
202: WHEN OTHERS THEN
203: po_message_s.sql_error('po_moac_utils_pvt.get_current_org_id', l_progress, sqlcode);
204: RAISE;

Line 230: -- This function is a wrapper that makes call to MO_GLOBAL.GET_OU_NAME.

226: --Returns:
227: -- Returns the Operating Unit name corresponding to the org_id parameter.
228: -- Returns NULL if the ORG_ID is NULL or invalid.
229: --Notes:
230: -- This function is a wrapper that makes call to MO_GLOBAL.GET_OU_NAME.
231: --Testing:
232: --
233: --End of Comments
234: -------------------------------------------------------------------------------

Line 244: -- This function is a wrapper that makes call to MO_GLOBAL.GET_OU_NAME

240: IS
241: --
242: -- This function would return OU Name for the ORG_ID passed.
243: -- If the ORG_ID is NULL or invalid, it would return NULL
244: -- This function is a wrapper that makes call to MO_GLOBAL.GET_OU_NAME
245: --
246: -- OU Name could be NULL in case global temp table is not
247: -- populated, in such cases get the OU name from HR view
248: -- This is needed for CLP

Line 256: l_ou_name := MO_GLOBAL.GET_OU_NAME(p_org_id);

252:
253: BEGIN
254: l_progress := '010';
255:
256: l_ou_name := MO_GLOBAL.GET_OU_NAME(p_org_id);
257:
258: l_progress := '020';
259: IF l_ou_name IS NULL THEN
260: SELECT

Line 301: -- This function is a wrapper that makes call to MO_GLOBAL.GET_OU_COUNT.

297: -- None.
298: --Returns:
299: -- Returns the number of Operating Units the user has access to currently.
300: --Notes:
301: -- This function is a wrapper that makes call to MO_GLOBAL.GET_OU_COUNT.
302: --Testing:
303: --
304: --End of Comments
305: -------------------------------------------------------------------------------

Line 312: RETURN MO_GLOBAL.GET_OU_COUNT ();

308: IS
309: l_progress VARCHAR2(3) := NULL;
310: BEGIN
311: l_progress := '010';
312: RETURN MO_GLOBAL.GET_OU_COUNT ();
313: EXCEPTION
314: WHEN OTHERS THEN
315: po_message_s.sql_error('po_moac_utils_pvt.get_ou_count', l_progress, sqlcode);
316: RAISE;

Line 343: -- This procedure is a wrapper that makes call to MO_GLOBAL.GET_DEFAULT_OU.

339: -- This will contain the default operating unit name.
340: -- x_ou_count
341: -- This will contain the number of operating units the user has access to.
342: --Notes:
343: -- This procedure is a wrapper that makes call to MO_GLOBAL.GET_DEFAULT_OU.
344: --Testing:
345: --
346: --End of Comments
347: -------------------------------------------------------------------------------

Line 396: -- This function is a wrapper that makes call to MO_GLOBAL.GET_VALID_ORG.

392: -- None.
393: --Returns:
394: -- Returns the org_id as per validity. Refer details under function section.
395: --Notes:
396: -- This function is a wrapper that makes call to MO_GLOBAL.GET_VALID_ORG.
397: --Testing:
398: --
399: --End of Comments
400: -------------------------------------------------------------------------------

Line 410: RETURN MO_GLOBAL.GET_VALID_ORG(p_org_id);

406: IS
407: l_progress VARCHAR2(3) := NULL;
408: BEGIN
409: l_progress := '010';
410: RETURN MO_GLOBAL.GET_VALID_ORG(p_org_id);
411: EXCEPTION
412: WHEN OTHERS THEN
413: po_message_s.sql_error('po_moac_utils_pvt.get_valid_org', l_progress, sqlcode);
414: RAISE;

Line 427: -- This procedure invokes MO Global initialization routine by passing PO as

423: -- None.
424: --Locks:
425: -- None.
426: --Function:
427: -- This procedure invokes MO Global initialization routine by passing PO as
428: -- product short code. This procedure would populate the global temporary
429: -- table with the operating units that a user has access to.
430: --Parameters:
431: --IN:

Line 438: -- This procedure is a wrapper that makes call to MO_GLOBAL.INIT.

434: -- None.
435: --OUT:
436: -- None.
437: --Notes:
438: -- This procedure is a wrapper that makes call to MO_GLOBAL.INIT.
439: --Testing:
440: --
441: --End of Comments
442: -------------------------------------------------------------------------------

Line 448: MO_GLOBAL.INIT('PO');

444: IS
445: l_progress VARCHAR2(3) := NULL;
446: BEGIN
447: l_progress := '010';
448: MO_GLOBAL.INIT('PO');
449: EXCEPTION
450: WHEN OTHERS THEN
451: po_message_s.sql_error('po_moac_utils_pvt.initialize', l_progress, sqlcode);
452: RAISE;

Line 481: -- This procedure is a wrapper that makes call to MO_GLOBAL.SET_POLICY_CONTEXT.

477: -- None.
478: --OUT:
479: -- None.
480: --Notes:
481: -- This procedure is a wrapper that makes call to MO_GLOBAL.SET_POLICY_CONTEXT.
482: --Testing:
483: --
484: --End of Comments
485: -------------------------------------------------------------------------------

Line 495: MO_GLOBAL.SET_POLICY_CONTEXT(p_access_mode,p_org_id);

491: IS
492: l_progress VARCHAR2(3) := NULL;
493: BEGIN
494: l_progress := '010';
495: MO_GLOBAL.SET_POLICY_CONTEXT(p_access_mode,p_org_id);
496: EXCEPTION
497: WHEN OTHERS THEN
498: po_message_s.sql_error('po_moac_utils_pvt.set_policy_context', l_progress, sqlcode);
499: RAISE;

Line 528: -- This function is a wrapper that makes call to MO_GLOBAL.CHECK_ACCESS.

524: -- None.
525: --Returns:
526: -- Returns 'Y' or 'N' as per accessibility.
527: --Notes:
528: -- This function is a wrapper that makes call to MO_GLOBAL.CHECK_ACCESS.
529: --Testing:
530: --
531: --End of Comments
532: -------------------------------------------------------------------------------

Line 543: RETURN MO_GLOBAL.CHECK_ACCESS(p_org_id);

539: l_progress VARCHAR2(3) := NULL;
540: l_retval VARCHAR2(1) := 'N';
541: BEGIN
542: l_progress := '010';
543: RETURN MO_GLOBAL.CHECK_ACCESS(p_org_id);
544: /*IF MO_GLOBAL.get_ou_name(p_org_id) IS NOT NULL THEN
545: l_retval := 'Y';
546: END IF;
547: RETURN l_retval;*/

Line 544: /*IF MO_GLOBAL.get_ou_name(p_org_id) IS NOT NULL THEN

540: l_retval VARCHAR2(1) := 'N';
541: BEGIN
542: l_progress := '010';
543: RETURN MO_GLOBAL.CHECK_ACCESS(p_org_id);
544: /*IF MO_GLOBAL.get_ou_name(p_org_id) IS NOT NULL THEN
545: l_retval := 'Y';
546: END IF;
547: RETURN l_retval;*/
548: EXCEPTION

Line 819: -- This procedure is a wrapper on the MO_GLOBAL.validate_orgid_pub_api

815: -- None.
816: --Locks:
817: -- None.
818: --Function:
819: -- This procedure is a wrapper on the MO_GLOBAL.validate_orgid_pub_api
820: --Parameters:
821: --IN:
822: --x_org_id
823: -- Org id which needs to be validated

Line 843: MO_GLOBAL.validate_orgid_pub_api(org_id => x_org_id,

839: PO_LOG.proc_begin(d_module_base);
840: PO_LOG.proc_begin(d_module_base, 'x_org_id', x_org_id);
841: END IF;
842:
843: MO_GLOBAL.validate_orgid_pub_api(org_id => x_org_id,
844: error_mesg_suppr => 'N',
845: status => l_status);
846:
847: IF (PO_LOG.d_proc) THEN