248: BEGIN
249:
250: --MOAC set policy context for single Org
251: IF p_operating_unit IS NOT NULL THEN
252: MO_GLOBAL.set_policy_context('S',p_operating_unit);
253: END IF;
254:
255: fnd_profile.get('ONT_IMP_MULTIPLE_SHIPMENTS', G_IMPORT_SHIPMENTS);
256: G_IMPORT_SHIPMENTS := nvl(G_IMPORT_SHIPMENTS, 'NO');
969: END IF;
970:
971: -- MOAC set the policy context based on the org_id
972: If G_ORG_ID IS NULL THEN
973: MO_GLOBAL.SET_POLICY_CONTEXT('S',l_org_id);
974: G_ORG_ID := l_org_id;
975: ELSIF G_ORG_ID IS NOT NULL AND
976: G_ORG_ID <> l_org_id THEN
977: MO_GLOBAL.SET_POLICY_CONTEXT('S',l_org_id);
973: MO_GLOBAL.SET_POLICY_CONTEXT('S',l_org_id);
974: G_ORG_ID := l_org_id;
975: ELSIF G_ORG_ID IS NOT NULL AND
976: G_ORG_ID <> l_org_id THEN
977: MO_GLOBAL.SET_POLICY_CONTEXT('S',l_org_id);
978: G_ORG_ID := l_org_id;
979: END IF;
980:
981:
1231: IF p_org_id IS NOT NULL THEN
1232: IF l_debug_level > 0 THEN
1233: oe_debug_pub.add( 'Setting policy context to single-org' ) ;
1234: END IF;
1235: MO_GLOBAL.set_policy_context('S',p_org_id);
1236: END IF;
1237:
1238:
1239: SELECT closed_flag