5: PROCEDURE restore_context(p_acc_mode VARCHAR2,
6: p_org_id NUMBER) IS
7: BEGIN
8: IF p_acc_mode IS NOT NULL then
9: mo_global.set_policy_context(p_acc_mode, p_org_id);
10: END IF;
11: END restore_context;
12:
13:
78: RETURN;
79: END IF;
80:
81: -- store MOAC session info in local variables
82: l_orig_org_id := mo_global.get_current_org_id;
83: l_orig_acc_mode := mo_global.get_access_mode;
84:
85: -- loop through orgs
86: FOR o IN get_orgs LOOP
79: END IF;
80:
81: -- store MOAC session info in local variables
82: l_orig_org_id := mo_global.get_current_org_id;
83: l_orig_acc_mode := mo_global.get_access_mode;
84:
85: -- loop through orgs
86: FOR o IN get_orgs LOOP
87: mo_global.set_policy_context('S', o.org_id);
83: l_orig_acc_mode := mo_global.get_access_mode;
84:
85: -- loop through orgs
86: FOR o IN get_orgs LOOP
87: mo_global.set_policy_context('S', o.org_id);
88:
89: select start_date_active, end_date_active
90: into l_old_start_date_active, l_old_end_date_active
91: from jtf_rs_teams_vl