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_VENDOR_PUB_PKG dependencies on HR_GENERAL

Line 1323: AND (nvl(loc.business_group_id,nvl(hr_general.get_business_group_id,-99))=

1319: WHERE loc.location_id = p_ship_location_id
1320: AND sysdate < nvl(loc.inactive_date, sysdate + 1)
1321: AND loc.location_id = lot.location_id
1322: AND lot.language = userenv('LANG')
1323: AND (nvl(loc.business_group_id,nvl(hr_general.get_business_group_id,-99))=
1324: nvl(hr_general.get_business_group_id,-99))
1325: AND loc.ship_to_site_flag = 'Y';
1326:
1327: EXCEPTION

Line 1324: nvl(hr_general.get_business_group_id,-99))

1320: AND sysdate < nvl(loc.inactive_date, sysdate + 1)
1321: AND loc.location_id = lot.location_id
1322: AND lot.language = userenv('LANG')
1323: AND (nvl(loc.business_group_id,nvl(hr_general.get_business_group_id,-99))=
1324: nvl(hr_general.get_business_group_id,-99))
1325: AND loc.ship_to_site_flag = 'Y';
1326:
1327: EXCEPTION
1328: -- Trap validation error

Line 1347: AND (nvl(loc.business_group_id,nvl(hr_general.get_business_group_id,-99))=

1343: AND loc.location_id = p_ship_location_id
1344: AND sysdate < nvl(loc.inactive_date, sysdate + 1)
1345: AND loc.location_id = lot.location_id
1346: AND lot.language = userenv('LANG')
1347: AND (nvl(loc.business_group_id,nvl(hr_general.get_business_group_id,-99))=
1348: nvl(hr_general.get_business_group_id,-99))
1349: AND loc.ship_to_site_flag = 'Y';
1350:
1351: EXCEPTION

Line 1348: nvl(hr_general.get_business_group_id,-99))

1344: AND sysdate < nvl(loc.inactive_date, sysdate + 1)
1345: AND loc.location_id = lot.location_id
1346: AND lot.language = userenv('LANG')
1347: AND (nvl(loc.business_group_id,nvl(hr_general.get_business_group_id,-99))=
1348: nvl(hr_general.get_business_group_id,-99))
1349: AND loc.ship_to_site_flag = 'Y';
1350:
1351: EXCEPTION
1352: -- Trap validation error

Line 1371: AND (nvl(loc.business_group_id,nvl(hr_general.get_business_group_id,-99))=

1367: WHERE lot.location_code = p_ship_location_code
1368: AND sysdate < nvl(loc.inactive_date, sysdate + 1)
1369: AND loc.location_id = lot.location_id
1370: AND lot.language = userenv('LANG')
1371: AND (nvl(loc.business_group_id,nvl(hr_general.get_business_group_id,-99))=
1372: nvl(hr_general.get_business_group_id,-99))
1373: AND loc.ship_to_site_flag = 'Y';
1374:
1375: EXCEPTION

Line 1372: nvl(hr_general.get_business_group_id,-99))

1368: AND sysdate < nvl(loc.inactive_date, sysdate + 1)
1369: AND loc.location_id = lot.location_id
1370: AND lot.language = userenv('LANG')
1371: AND (nvl(loc.business_group_id,nvl(hr_general.get_business_group_id,-99))=
1372: nvl(hr_general.get_business_group_id,-99))
1373: AND loc.ship_to_site_flag = 'Y';
1374:
1375: EXCEPTION
1376: -- Trap validation error

Line 1417: AND (nvl(loc.business_group_id,nvl(hr_general.get_business_group_id,-99))=

1413: WHERE loc.location_id = p_bill_location_id
1414: AND sysdate < nvl(loc.inactive_date, sysdate + 1)
1415: AND loc.location_id = lot.location_id
1416: AND lot.language = userenv('LANG')
1417: AND (nvl(loc.business_group_id,nvl(hr_general.get_business_group_id,-99))=
1418: nvl(hr_general.get_business_group_id,-99))
1419: AND loc.bill_to_site_flag = 'Y';
1420:
1421: EXCEPTION

Line 1418: nvl(hr_general.get_business_group_id,-99))

1414: AND sysdate < nvl(loc.inactive_date, sysdate + 1)
1415: AND loc.location_id = lot.location_id
1416: AND lot.language = userenv('LANG')
1417: AND (nvl(loc.business_group_id,nvl(hr_general.get_business_group_id,-99))=
1418: nvl(hr_general.get_business_group_id,-99))
1419: AND loc.bill_to_site_flag = 'Y';
1420:
1421: EXCEPTION
1422: -- Trap validation error

Line 1442: AND (nvl(loc.business_group_id,nvl(hr_general.get_business_group_id,-99))=

1438: AND lot.location_code = p_bill_location_code
1439: AND sysdate < nvl(loc.inactive_date, sysdate + 1)
1440: AND loc.location_id = lot.location_id
1441: AND lot.language = userenv('LANG')
1442: AND (nvl(loc.business_group_id,nvl(hr_general.get_business_group_id,-99))=
1443: nvl(hr_general.get_business_group_id,-99))
1444: AND loc.bill_to_site_flag = 'Y';
1445:
1446: EXCEPTION

Line 1443: nvl(hr_general.get_business_group_id,-99))

1439: AND sysdate < nvl(loc.inactive_date, sysdate + 1)
1440: AND loc.location_id = lot.location_id
1441: AND lot.language = userenv('LANG')
1442: AND (nvl(loc.business_group_id,nvl(hr_general.get_business_group_id,-99))=
1443: nvl(hr_general.get_business_group_id,-99))
1444: AND loc.bill_to_site_flag = 'Y';
1445:
1446: EXCEPTION
1447: -- Trap validation error

Line 1467: AND (nvl(loc.business_group_id,nvl(hr_general.get_business_group_id,-99))=

1463: WHERE lot.location_code = p_bill_location_code
1464: AND sysdate < nvl(loc.inactive_date, sysdate + 1)
1465: AND loc.location_id = lot.location_id
1466: AND lot.language = userenv('LANG')
1467: AND (nvl(loc.business_group_id,nvl(hr_general.get_business_group_id,-99))=
1468: nvl(hr_general.get_business_group_id,-99))
1469: AND loc.bill_to_site_flag = 'Y';
1470:
1471: EXCEPTION

Line 1468: nvl(hr_general.get_business_group_id,-99))

1464: AND sysdate < nvl(loc.inactive_date, sysdate + 1)
1465: AND loc.location_id = lot.location_id
1466: AND lot.language = userenv('LANG')
1467: AND (nvl(loc.business_group_id,nvl(hr_general.get_business_group_id,-99))=
1468: nvl(hr_general.get_business_group_id,-99))
1469: AND loc.bill_to_site_flag = 'Y';
1470:
1471: EXCEPTION
1472: -- Trap validation error