153: IF p_organization_id IS NOT NULL THEN
154:
155: -- Setting a Single Org access.
156:
157: MO_GLOBAL.set_policy_context ('S', p_organization_id);
158:
159: ELSIF p_organization_id IS NULL THEN
160:
161: --
172: CLOSE cur_get_org_for_ord_type;
173:
174: -- Setting a Single Org access.
175:
176: MO_GLOBAL.set_policy_context ('S', l_org_id);
177:
178: ELSE
179: -- Setting a Multiple Org access.
180:
177:
178: ELSE
179: -- Setting a Multiple Org access.
180:
181: MO_GLOBAL.set_policy_context('M','');
182:
183: END IF;
184: END IF;
185:
654: IF p_organization_id IS NOT NULL THEN
655:
656: -- Setting a Single Org access.
657:
658: MO_GLOBAL.set_policy_context ('S', p_organization_id);
659:
660: ELSIF p_organization_id IS NULL THEN
661:
662: --
672: CLOSE cur_get_org_for_ord_type;
673:
674: -- Setting a Single Org access.
675:
676: MO_GLOBAL.set_policy_context ('S', l_org_id);
677:
678: ELSE
679: -- Setting a Multiple Org access.
680:
677:
678: ELSE
679: -- Setting a Multiple Org access.
680:
681: MO_GLOBAL.set_policy_context('M','');
682:
683: END IF;
684: END IF;
685:
1593: -- We are purging the data based on the crested_by of the Purge Set and
1594: -- Orders in the purge set, so we are not restricting on a Single Org.
1595: --
1596:
1597: MO_GLOBAL.set_policy_context('M','');
1598:
1599:
1600: --added for bug 3680441
1601: SELECT count(*)
3725:
3726: BEGIN
3727:
3728: -- Setting a Multiple Org access.
3729: mo_global.init('ONT');
3730:
3731: --Quote purge changes.To Select Transaction Phase code
3732:
3733: OPEN cur_transaction_code ;