DBA Data[Home] [Help]

APPS.JTF_RS_GROUP_RELATE_VUHK dependencies on MO_GLOBAL

Line 16: mo_global.set_policy_context(p_acc_mode, p_org_id);

12: PROCEDURE restore_context(p_acc_mode VARCHAR2,
13: p_org_id NUMBER) IS
14: BEGIN
15: IF p_acc_mode IS NOT NULL then
16: mo_global.set_policy_context(p_acc_mode, p_org_id);
17: END IF;
18: END restore_context;
19:
20:

Line 115: l_orig_org_id := mo_global.get_current_org_id;

111: RETURN;
112: END IF;
113:
114: -- store MOAC session info in local variables
115: l_orig_org_id := mo_global.get_current_org_id;
116: l_orig_acc_mode := mo_global.get_access_mode;
117:
118: -- loop through orgs
119: FOR o IN get_orgs LOOP

Line 116: l_orig_acc_mode := mo_global.get_access_mode;

112: END IF;
113:
114: -- store MOAC session info in local variables
115: l_orig_org_id := mo_global.get_current_org_id;
116: l_orig_acc_mode := mo_global.get_access_mode;
117:
118: -- loop through orgs
119: FOR o IN get_orgs LOOP
120: mo_global.set_policy_context('S', o.org_id);

Line 120: mo_global.set_policy_context('S', o.org_id);

116: l_orig_acc_mode := mo_global.get_access_mode;
117:
118: -- loop through orgs
119: FOR o IN get_orgs LOOP
120: mo_global.set_policy_context('S', o.org_id);
121:
122: -- reset g_group_id to null before trying to set it to another value.
123: g_group_id := NULL;
124:

Line 410: l_orig_org_id := mo_global.get_current_org_id;

406: RETURN;
407: END IF;
408:
409: -- store MOAC session info in local variables
410: l_orig_org_id := mo_global.get_current_org_id;
411: l_orig_acc_mode := mo_global.get_access_mode;
412:
413: -- loop through orgs
414: FOR o IN get_orgs LOOP

Line 411: l_orig_acc_mode := mo_global.get_access_mode;

407: END IF;
408:
409: -- store MOAC session info in local variables
410: l_orig_org_id := mo_global.get_current_org_id;
411: l_orig_acc_mode := mo_global.get_access_mode;
412:
413: -- loop through orgs
414: FOR o IN get_orgs LOOP
415: mo_global.set_policy_context('S', o.org_id);

Line 415: mo_global.set_policy_context('S', o.org_id);

411: l_orig_acc_mode := mo_global.get_access_mode;
412:
413: -- loop through orgs
414: FOR o IN get_orgs LOOP
415: mo_global.set_policy_context('S', o.org_id);
416:
417: OPEN group_info;
418: FETCH group_info INTO l_start_date, l_end_date, l_group_id;
419: IF (group_info%notfound) THEN

Line 634: l_orig_org_id := mo_global.get_current_org_id;

630: RETURN;
631: END IF;
632:
633: -- store MOAC session info in local variables
634: l_orig_org_id := mo_global.get_current_org_id;
635: l_orig_acc_mode := mo_global.get_access_mode;
636:
637: -- loop through orgs
638: FOR o IN get_orgs LOOP

Line 635: l_orig_acc_mode := mo_global.get_access_mode;

631: END IF;
632:
633: -- store MOAC session info in local variables
634: l_orig_org_id := mo_global.get_current_org_id;
635: l_orig_acc_mode := mo_global.get_access_mode;
636:
637: -- loop through orgs
638: FOR o IN get_orgs LOOP
639: mo_global.set_policy_context('S', o.org_id);

Line 639: mo_global.set_policy_context('S', o.org_id);

635: l_orig_acc_mode := mo_global.get_access_mode;
636:
637: -- loop through orgs
638: FOR o IN get_orgs LOOP
639: mo_global.set_policy_context('S', o.org_id);
640:
641: OPEN usage;
642: FETCH usage INTO l_dummy;
643: IF (usage%notfound) THEN

Line 846: l_orig_org_id := mo_global.get_current_org_id;

842: RETURN;
843: END IF;
844:
845: -- store MOAC session info in local variables
846: l_orig_org_id := mo_global.get_current_org_id;
847: l_orig_acc_mode := mo_global.get_access_mode;
848:
849: -- loop through orgs
850: FOR o IN get_orgs LOOP

Line 847: l_orig_acc_mode := mo_global.get_access_mode;

843: END IF;
844:
845: -- store MOAC session info in local variables
846: l_orig_org_id := mo_global.get_current_org_id;
847: l_orig_acc_mode := mo_global.get_access_mode;
848:
849: -- loop through orgs
850: FOR o IN get_orgs LOOP
851: mo_global.set_policy_context('S', o.org_id);

Line 851: mo_global.set_policy_context('S', o.org_id);

847: l_orig_acc_mode := mo_global.get_access_mode;
848:
849: -- loop through orgs
850: FOR o IN get_orgs LOOP
851: mo_global.set_policy_context('S', o.org_id);
852:
853: cn_mark_events_pkg.mark_notify_salesreps
854: ( p_salesrep_id => NULL,
855: p_comp_group_id => g_group_id,