DBA Data[Home] [Help]

APPS.AP_IMPORT_INVOICES_PKG dependencies on MO_GLOBAL

Line 257: (mo_global.check_access(org_id)= 'Y'))

253: p_org_id IS NOT NULL AND
254: org_id = p_org_id)
255: OR (p_org_id IS NULL AND
256: org_id IS NOT NULL AND
257: (mo_global.check_access(org_id)= 'Y'))
258: OR (p_org_id is NOT NULL AND org_id IS NULL)
259: OR (p_org_id is NULL AND org_id IS NULL))
260: ORDER BY org_id,
261: invoice_id,

Line 439: (mo_global.check_access(org_id)= 'Y'))

435: p_org_id IS NOT NULL AND
436: org_id = p_org_id)
437: OR (p_org_id IS NULL AND
438: org_id IS NOT NULL AND
439: (mo_global.check_access(org_id)= 'Y'))
440: OR (p_org_id is NOT NULL AND org_id IS NULL)
441: OR (p_org_id is NULL AND org_id IS NULL))
442: ORDER BY org_id,
443: invoice_id,

Line 803: (mo_global.check_access(org_id)= 'Y'))

799: p_org_id is NOT NULL AND
800: org_id = p_org_id)
801: or (p_org_id is NULL AND
802: org_id is NOT NULL AND
803: (mo_global.check_access(org_id)= 'Y'))
804: or (p_org_id is NOT NULL AND
805: org_id is NULL)
806: or (p_org_id is NULL AND
807: org_id is NULL));

Line 824: (mo_global.check_access(org_id)= 'Y'))

820: p_org_id is NOT NULL AND
821: org_id = p_org_id)
822: or (p_org_id is NULL AND
823: org_id is NOT NULL AND
824: (mo_global.check_access(org_id)= 'Y'))
825: or (p_org_id is NOT NULL AND
826: org_id is NULL)
827: or (p_org_id is NULL AND
828: org_id is NULL));

Line 897: AND mo_global.check_access(hr.organization_id) = 'Y'

893: SET org_id = (SELECT hr.organization_id org_id
894: FROM hr_operating_units hr,
895: per_business_groups per
896: WHERE hr.business_group_id = per.business_group_id
897: AND mo_global.check_access(hr.organization_id) = 'Y'
898: AND hr.name = i.operating_unit)
899: WHERE i.org_id is null
900: AND i.operating_unit is not null
901: AND ((status is NULL) OR (status = 'REJECTED'))

Line 916: AND mo_global.check_access(hr.organization_id) = 'Y'

912: SET org_id = (SELECT hr.organization_id org_id
913: FROM hr_operating_units hr,
914: per_business_groups per
915: WHERE hr.business_group_id = per.business_group_id
916: AND mo_global.check_access(hr.organization_id) = 'Y'
917: AND hr.name = i.operating_unit)
918: WHERE i.org_id is null
919: AND i.operating_unit is not null
920: AND ((status is NULL) OR (status = 'REJECTED'))

Line 971: (mo_global.check_access(org_id)= 'Y'))

967: p_org_id is NOT NULL AND
968: org_id = p_org_id)
969: or (p_org_id is NULL AND
970: org_id is NOT NULL AND
971: (mo_global.check_access(org_id)= 'Y'))
972: or (p_org_id is NOT NULL AND
973: org_id is NULL)
974: or (p_org_id is NULL AND
975: org_id is NULL))

Line 1004: (mo_global.check_access(org_id)= 'Y'))

1000: p_org_id is NOT NULL AND
1001: org_id = p_org_id)
1002: or (p_org_id is NULL AND
1003: org_id is NOT NULL AND
1004: (mo_global.check_access(org_id)= 'Y'))
1005: or (p_org_id is NOT NULL AND
1006: org_id is NULL)
1007: or (p_org_id is NULL AND
1008: org_id is NULL))

Line 1331: -- mo_global.get_ou_name(l_invoice_rec.org_id);

1327:
1328: IF l_invoice_rec.operating_unit is NOT NULL THEN
1329: -- Bug 5448579
1330: -- l_derived_operating_unit :=
1331: -- mo_global.get_ou_name(l_invoice_rec.org_id);
1332: l_derived_operating_unit := l_moac_org_table(l_invoice_rec.org_id).org_name;
1333:
1334: debug_info := ' Derived Operating Unit: '||l_derived_operating_unit;
1335: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') THEN

Line 1390: Mo_Global.set_policy_context('S', l_invoice_rec.org_id);

1386: END IF;
1387:
1388: IF l_invoice_status = 'Y' THEN
1389: IF l_invoice_rec.org_id <> NVL(l_old_org_id, -3115) THEN
1390: Mo_Global.set_policy_context('S', l_invoice_rec.org_id);
1391:
1392: debug_info := '(Import_invoice 9b) Call get_info to get '||
1393: 'required info';
1394: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') THEN

Line 3129: (mo_global.check_access(org_id)= 'Y'))

3125: (ROWNUM <= p_commit_cycles))
3126: AND ((org_id IS NOT NULL and p_org_id IS NOT NULL and
3127: org_id = p_org_id)
3128: OR (p_org_id IS NULL and org_id is NOT NULL and
3129: (mo_global.check_access(org_id)= 'Y'))
3130: OR (p_org_id IS NOT NULL and org_id IS NULL)
3131: OR (p_org_id IS NULL and org_id IS NULL))
3132: ORDER BY vendor_id,
3133: vendor_num,

Line 3150: (mo_global.check_access(org_id)= 'Y'))

3146: (ROWNUM <= p_commit_cycles))
3147: AND ((org_id IS NOT NULL and p_org_id IS NOT NULL and
3148: org_id = p_org_id)
3149: OR (p_org_id IS NULL and org_id is NOT NULL and
3150: (mo_global.check_access(org_id)= 'Y'))
3151: OR (p_org_id IS NOT NULL and org_id IS NULL)
3152: OR (p_org_id IS NULL and org_id IS NULL))
3153: ORDER BY vendor_id,
3154: vendor_num,

Line 3196: (mo_global.check_access(org_id)= 'Y'))

3192: p_org_id IS NOT NULL AND
3193: org_id = p_org_id)
3194: OR (p_org_id IS NULL AND
3195: org_id is NOT NULL and
3196: (mo_global.check_access(org_id)= 'Y'))
3197: OR (p_org_id IS NOT NULL and org_id IS NULL)
3198: OR (p_org_id IS NULL and org_id IS NULL));
3199: EXCEPTION
3200: WHEN NO_DATA_FOUND THEN

Line 3216: (mo_global.check_access(org_id)= 'Y'))

3212: p_org_id IS NOT NULL AND
3213: org_id = p_org_id)
3214: OR (p_org_id IS NULL AND
3215: org_id is NOT NULL and
3216: (mo_global.check_access(org_id)= 'Y'))
3217: OR (p_org_id IS NOT NULL and org_id IS NULL)
3218: OR (p_org_id IS NULL and org_id IS NULL));
3219: EXCEPTION
3220: WHEN NO_DATA_FOUND THEN

Line 3336: (mo_global.check_access(org_id)= 'Y'))

3332: p_org_id IS NOT NULL AND
3333: org_id = p_org_id)
3334: OR (p_org_id IS NULL AND
3335: org_id is NOT NULL AND
3336: (mo_global.check_access(org_id)= 'Y'))
3337: OR (p_org_id IS NOT NULL AND
3338: org_id IS NULL)
3339: OR (p_org_id IS NULL AND
3340: org_id IS NULL));