eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_IMPORT_INVOICES_PKG dependencies on MO_GLOBAL

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

281: p_org_id IS NOT NULL AND
282: org_id = p_org_id)
283: OR (p_org_id IS NULL AND
284: org_id IS NOT NULL AND
285: (mo_global.check_access(org_id)= 'Y'))
286: OR (p_org_id is NOT NULL AND org_id IS NULL)
287: OR (p_org_id is NULL AND org_id IS NULL))
288: ORDER BY org_id,
289: invoice_id,

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

486: p_org_id IS NOT NULL AND
487: org_id = p_org_id)
488: OR (p_org_id IS NULL AND
489: org_id IS NOT NULL AND
490: (mo_global.check_access(org_id)= 'Y'))
491: OR (p_org_id is NOT NULL AND org_id IS NULL)
492: OR (p_org_id is NULL AND org_id IS NULL))
493: ORDER BY org_id,
494: invoice_id,

Line 898: l_stmt := l_stmt || ' AND ( (org_id IS NULL) OR (org_id IS NOT NULL AND mo_global.check_access(org_id)= ''Y'' ) ) ';

894: l_stmt := l_stmt || ' AND invoice_id = ' || p_invoice_interface_id || ' ';
895: END IF;
896:
897: IF p_org_id IS NULL THEN
898: l_stmt := l_stmt || ' AND ( (org_id IS NULL) OR (org_id IS NOT NULL AND mo_global.check_access(org_id)= ''Y'' ) ) ';
899: ELSE
900: l_stmt := l_stmt || ' AND ( (org_id IS NULL) OR (org_id IS NOT NULL AND org_id = ' || p_org_id || ') ) ';
901: END IF;
902:

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

918: p_org_id is NOT NULL AND
919: org_id = p_org_id)
920: or (p_org_id is NULL AND
921: org_id is NOT NULL AND
922: (mo_global.check_access(org_id)= 'Y'))
923: or (p_org_id is NOT NULL AND
924: org_id is NULL)
925: or (p_org_id is NULL AND
926: org_id is NULL));

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

939: p_org_id is NOT NULL AND
940: org_id = p_org_id)
941: or (p_org_id is NULL AND
942: org_id is NOT NULL AND
943: (mo_global.check_access(org_id)= 'Y'))
944: or (p_org_id is NOT NULL AND
945: org_id is NULL)
946: or (p_org_id is NULL AND
947: org_id is NULL));

Line 1019: /* ||' AND mo_global.check_access(hr.organization_id) = ''Y'' ' */

1015: ||' SET org_id = (SELECT hr.organization_id org_id '
1016: ||' FROM hr_operating_units hr,per_business_groups per '
1017: ||' WHERE hr.business_group_id = per.business_group_id '
1018: /* Commented for bug 11871938 */
1019: /* ||' AND mo_global.check_access(hr.organization_id) = ''Y'' ' */
1020: ||' AND hr.name = i.operating_unit) '
1021: ||' WHERE i.org_id is null AND i.operating_unit is not null '
1022: ||' AND ((status is NULL) OR (status = ''REJECTED'')) AND source = ''' || p_source || ''' '
1023: ||' AND NVL(workflow_flag,''D'') = ''D'' ';

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

1041: SET org_id = (SELECT hr.organization_id org_id
1042: FROM hr_operating_units hr,
1043: per_business_groups per
1044: WHERE hr.business_group_id = per.business_group_id
1045: AND mo_global.check_access(hr.organization_id) = 'Y'
1046: AND hr.name = i.operating_unit)
1047: WHERE i.org_id is null
1048: AND i.operating_unit is not null
1049: AND ((status is NULL) OR (status = 'REJECTED'))

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

1060: SET org_id = (SELECT hr.organization_id org_id
1061: FROM hr_operating_units hr,
1062: per_business_groups per
1063: WHERE hr.business_group_id = per.business_group_id
1064: AND mo_global.check_access(hr.organization_id) = 'Y'
1065: AND hr.name = i.operating_unit)
1066: WHERE i.org_id is null
1067: AND i.operating_unit is not null
1068: AND ((status is NULL) OR (status = 'REJECTED'))

Line 1127: l_stmt := l_stmt || ' AND ( (org_id IS NULL) OR (org_id IS NOT NULL AND mo_global.check_access(org_id)= ''Y'' ) ) ';

1123: END IF;
1124:
1125: --Bug13616489 - corrected the else part
1126: IF p_org_id IS NULL THEN
1127: l_stmt := l_stmt || ' AND ( (org_id IS NULL) OR (org_id IS NOT NULL AND mo_global.check_access(org_id)= ''Y'' ) ) ';
1128: ELSE
1129: --l_stmt := l_stmt || ' AND ( (org_id IS NULL) OR ( org_id = ' || p_org_id || ') ) ';
1130: l_stmt := l_stmt || ' AND ( (org_id IS NULL) OR (org_id IS NOT NULL AND org_id = ' || p_org_id || ') ) ';
1131: END IF;

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

1182: p_org_id is NOT NULL AND
1183: org_id = p_org_id)
1184: or (p_org_id is NULL AND
1185: org_id is NOT NULL AND
1186: (mo_global.check_access(org_id)= 'Y'))
1187: or (p_org_id is NOT NULL AND
1188: org_id is NULL)
1189: or (p_org_id is NULL AND
1190: org_id is NULL))

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

1215: p_org_id is NOT NULL AND
1216: org_id = p_org_id)
1217: or (p_org_id is NULL AND
1218: org_id is NOT NULL AND
1219: (mo_global.check_access(org_id)= 'Y'))
1220: or (p_org_id is NOT NULL AND
1221: org_id is NULL)
1222: or (p_org_id is NULL AND
1223: org_id is NULL))

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

1611:
1612: IF l_invoice_rec.operating_unit is NOT NULL THEN
1613: -- Bug 5448579
1614: -- l_derived_operating_unit :=
1615: -- mo_global.get_ou_name(l_invoice_rec.org_id);
1616: l_derived_operating_unit := l_moac_org_table(l_invoice_rec.org_id).org_name;
1617:
1618: debug_info := ' Derived Operating Unit: '||l_derived_operating_unit;
1619: IF (AP_IMPORT_INVOICES_PKG.g_debug_switch = 'Y') THEN

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

1674: -- AP_IMPORT_UTILITIES_PKG.get_info needs to be invoked to fetch
1675: -- the setup information even though org exception exists.
1676: --IF l_invoice_status = 'Y' THEN
1677: IF l_invoice_rec.org_id <> NVL(l_old_org_id, -3115) THEN
1678: Mo_Global.set_policy_context('S', l_invoice_rec.org_id);
1679:
1680: -- bug7531219 setting the ledger context to get only
1681: -- valid Balancing and Management segments for the ledger
1682: BEGIN

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

2554:
2555: --added for bulk processing with invoices of different orgs in
2556: -- the second loop
2557: IF l_invoice_rec.org_id <> NVL(l_old_org_id, -3115) THEN
2558: Mo_Global.set_policy_context('S', l_invoice_rec.org_id);
2559: l_old_org_id := l_invoice_rec.org_id;
2560: END IF;
2561:
2562: BEGIN

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

4298: (ROWNUM <= p_commit_cycles))
4299: AND ((org_id IS NOT NULL and p_org_id IS NOT NULL and
4300: org_id = p_org_id)
4301: OR (p_org_id IS NULL and org_id is NOT NULL and
4302: (mo_global.check_access(org_id)= 'Y'))
4303: OR (p_org_id IS NOT NULL and org_id IS NULL)
4304: OR (p_org_id IS NULL and org_id IS NULL))
4305: ORDER BY vendor_id,
4306: vendor_num,

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

4319: (ROWNUM <= p_commit_cycles))
4320: AND ((org_id IS NOT NULL and p_org_id IS NOT NULL and
4321: org_id = p_org_id)
4322: OR (p_org_id IS NULL and org_id is NOT NULL and
4323: (mo_global.check_access(org_id)= 'Y'))
4324: OR (p_org_id IS NOT NULL and org_id IS NULL)
4325: OR (p_org_id IS NULL and org_id IS NULL))
4326: ORDER BY vendor_id,
4327: vendor_num,

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

4365: p_org_id IS NOT NULL AND
4366: org_id = p_org_id)
4367: OR (p_org_id IS NULL AND
4368: org_id is NOT NULL and
4369: (mo_global.check_access(org_id)= 'Y'))
4370: OR (p_org_id IS NOT NULL and org_id IS NULL)
4371: OR (p_org_id IS NULL and org_id IS NULL));
4372: EXCEPTION
4373: WHEN NO_DATA_FOUND THEN

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

4385: p_org_id IS NOT NULL AND
4386: org_id = p_org_id)
4387: OR (p_org_id IS NULL AND
4388: org_id is NOT NULL and
4389: (mo_global.check_access(org_id)= 'Y'))
4390: OR (p_org_id IS NOT NULL and org_id IS NULL)
4391: OR (p_org_id IS NULL and org_id IS NULL));
4392: EXCEPTION
4393: WHEN NO_DATA_FOUND THEN

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

4505: p_org_id IS NOT NULL AND
4506: org_id = p_org_id)
4507: OR (p_org_id IS NULL AND
4508: org_id is NOT NULL AND
4509: (mo_global.check_access(org_id)= 'Y'))
4510: OR (p_org_id IS NOT NULL AND
4511: org_id IS NULL)
4512: OR (p_org_id IS NULL AND
4513: org_id IS NULL));