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 1591: AND (nvl(loc.business_group_id,nvl(hr_general.get_business_group_id,-99))=

1587: WHERE loc.location_id = p_ship_location_id
1588: AND sysdate < nvl(loc.inactive_date, sysdate + 1)
1589: AND loc.location_id = lot.location_id
1590: AND lot.language = userenv('LANG')
1591: AND (nvl(loc.business_group_id,nvl(hr_general.get_business_group_id,-99))=
1592: nvl(hr_general.get_business_group_id,-99))
1593: AND loc.ship_to_site_flag = 'Y';
1594:
1595: EXCEPTION

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

1588: AND sysdate < nvl(loc.inactive_date, sysdate + 1)
1589: AND loc.location_id = lot.location_id
1590: AND lot.language = userenv('LANG')
1591: AND (nvl(loc.business_group_id,nvl(hr_general.get_business_group_id,-99))=
1592: nvl(hr_general.get_business_group_id,-99))
1593: AND loc.ship_to_site_flag = 'Y';
1594:
1595: EXCEPTION
1596: -- Trap validation error

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

1611: AND loc.location_id = p_ship_location_id
1612: AND sysdate < nvl(loc.inactive_date, sysdate + 1)
1613: AND loc.location_id = lot.location_id
1614: AND lot.language = userenv('LANG')
1615: AND (nvl(loc.business_group_id,nvl(hr_general.get_business_group_id,-99))=
1616: nvl(hr_general.get_business_group_id,-99))
1617: AND loc.ship_to_site_flag = 'Y';
1618:
1619: EXCEPTION

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

1612: AND sysdate < nvl(loc.inactive_date, sysdate + 1)
1613: AND loc.location_id = lot.location_id
1614: AND lot.language = userenv('LANG')
1615: AND (nvl(loc.business_group_id,nvl(hr_general.get_business_group_id,-99))=
1616: nvl(hr_general.get_business_group_id,-99))
1617: AND loc.ship_to_site_flag = 'Y';
1618:
1619: EXCEPTION
1620: -- Trap validation error

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

1635: WHERE lot.location_code = p_ship_location_code
1636: AND sysdate < nvl(loc.inactive_date, sysdate + 1)
1637: AND loc.location_id = lot.location_id
1638: AND lot.language = userenv('LANG')
1639: AND (nvl(loc.business_group_id,nvl(hr_general.get_business_group_id,-99))=
1640: nvl(hr_general.get_business_group_id,-99))
1641: AND loc.ship_to_site_flag = 'Y';
1642:
1643: EXCEPTION

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

1636: AND sysdate < nvl(loc.inactive_date, sysdate + 1)
1637: AND loc.location_id = lot.location_id
1638: AND lot.language = userenv('LANG')
1639: AND (nvl(loc.business_group_id,nvl(hr_general.get_business_group_id,-99))=
1640: nvl(hr_general.get_business_group_id,-99))
1641: AND loc.ship_to_site_flag = 'Y';
1642:
1643: EXCEPTION
1644: -- Trap validation error

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

1681: WHERE loc.location_id = p_bill_location_id
1682: AND sysdate < nvl(loc.inactive_date, sysdate + 1)
1683: AND loc.location_id = lot.location_id
1684: AND lot.language = userenv('LANG')
1685: AND (nvl(loc.business_group_id,nvl(hr_general.get_business_group_id,-99))=
1686: nvl(hr_general.get_business_group_id,-99))
1687: AND loc.bill_to_site_flag = 'Y';
1688:
1689: EXCEPTION

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

1682: AND sysdate < nvl(loc.inactive_date, sysdate + 1)
1683: AND loc.location_id = lot.location_id
1684: AND lot.language = userenv('LANG')
1685: AND (nvl(loc.business_group_id,nvl(hr_general.get_business_group_id,-99))=
1686: nvl(hr_general.get_business_group_id,-99))
1687: AND loc.bill_to_site_flag = 'Y';
1688:
1689: EXCEPTION
1690: -- Trap validation error

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

1706: AND lot.location_code = p_bill_location_code
1707: AND sysdate < nvl(loc.inactive_date, sysdate + 1)
1708: AND loc.location_id = lot.location_id
1709: AND lot.language = userenv('LANG')
1710: AND (nvl(loc.business_group_id,nvl(hr_general.get_business_group_id,-99))=
1711: nvl(hr_general.get_business_group_id,-99))
1712: AND loc.bill_to_site_flag = 'Y';
1713:
1714: EXCEPTION

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

1707: AND sysdate < nvl(loc.inactive_date, sysdate + 1)
1708: AND loc.location_id = lot.location_id
1709: AND lot.language = userenv('LANG')
1710: AND (nvl(loc.business_group_id,nvl(hr_general.get_business_group_id,-99))=
1711: nvl(hr_general.get_business_group_id,-99))
1712: AND loc.bill_to_site_flag = 'Y';
1713:
1714: EXCEPTION
1715: -- Trap validation error

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

1731: WHERE lot.location_code = p_bill_location_code
1732: AND sysdate < nvl(loc.inactive_date, sysdate + 1)
1733: AND loc.location_id = lot.location_id
1734: AND lot.language = userenv('LANG')
1735: AND (nvl(loc.business_group_id,nvl(hr_general.get_business_group_id,-99))=
1736: nvl(hr_general.get_business_group_id,-99))
1737: AND loc.bill_to_site_flag = 'Y';
1738:
1739: EXCEPTION

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

1732: AND sysdate < nvl(loc.inactive_date, sysdate + 1)
1733: AND loc.location_id = lot.location_id
1734: AND lot.language = userenv('LANG')
1735: AND (nvl(loc.business_group_id,nvl(hr_general.get_business_group_id,-99))=
1736: nvl(hr_general.get_business_group_id,-99))
1737: AND loc.bill_to_site_flag = 'Y';
1738:
1739: EXCEPTION
1740: -- Trap validation error