APPS.AP_VENDOR_PUB_PKG dependencies on HR_LOCATIONS_ALL

Line 1571: l_ship_locn_id HR_LOCATIONS_ALL.ship_to_location_id%TYPE;

1567: p_default_ship_to_loc_id IN NUMBER,
1568: x_valid OUT NOCOPY BOOLEAN
1569: ) IS
1570:
1571: l_ship_locn_id HR_LOCATIONS_ALL.ship_to_location_id%TYPE;
1572: l_ship_locn_code HR_LOCATIONS_ALL.location_code%TYPE;
1573:
1574: BEGIN
1575: x_valid := TRUE;

Line 1572: l_ship_locn_code HR_LOCATIONS_ALL.location_code%TYPE;

1568: x_valid OUT NOCOPY BOOLEAN
1569: ) IS
1570:
1571: l_ship_locn_id HR_LOCATIONS_ALL.ship_to_location_id%TYPE;
1572: l_ship_locn_code HR_LOCATIONS_ALL.location_code%TYPE;
1573:
1574: BEGIN
1575: x_valid := TRUE;
1576:

Line 1586: FROM HR_LOCATIONS_ALL loc, HR_LOCATIONS_ALL_TL lot

1582:
1583: BEGIN
1584: SELECT lot.location_code
1585: INTO l_ship_locn_code
1586: FROM HR_LOCATIONS_ALL loc, HR_LOCATIONS_ALL_TL lot
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')

Line 1609: FROM HR_LOCATIONS_ALL loc, HR_LOCATIONS_ALL_TL lot

1605: ELSIF (p_ship_location_id is NOT NULL and p_ship_location_code is NOT NULL) THEN
1606: BEGIN
1607: SELECT loc.location_id
1608: INTO l_ship_locn_id
1609: FROM HR_LOCATIONS_ALL loc, HR_LOCATIONS_ALL_TL lot
1610: WHERE lot.location_code = p_ship_location_code
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

Line 1634: FROM HR_LOCATIONS_ALL loc, HR_LOCATIONS_ALL_TL lot

1630: ELSIF (p_ship_location_id is NULL and p_ship_location_code is NOT NULL) THEN
1631: BEGIN
1632: SELECT loc.location_id
1633: INTO p_ship_location_id
1634: FROM HR_LOCATIONS_ALL loc, HR_LOCATIONS_ALL_TL lot
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')

Line 1667: l_bill_locn_id HR_LOCATIONS_ALL.location_id%TYPE;

1663: p_default_bill_to_loc_id IN NUMBER,
1664: x_valid OUT NOCOPY BOOLEAN
1665: ) IS
1666:
1667: l_bill_locn_id HR_LOCATIONS_ALL.location_id%TYPE;
1668: l_bill_locn_code HR_LOCATIONS_ALL.location_code%TYPE;
1669:
1670: BEGIN
1671: x_valid := TRUE;

Line 1668: l_bill_locn_code HR_LOCATIONS_ALL.location_code%TYPE;

1664: x_valid OUT NOCOPY BOOLEAN
1665: ) IS
1666:
1667: l_bill_locn_id HR_LOCATIONS_ALL.location_id%TYPE;
1668: l_bill_locn_code HR_LOCATIONS_ALL.location_code%TYPE;
1669:
1670: BEGIN
1671: x_valid := TRUE;
1672:

Line 1680: FROM HR_LOCATIONS_ALL loc, HR_LOCATIONS_ALL_TL lot

1676: ELSIF (p_bill_location_id is NOT NULL and p_bill_location_code is NULL) THEN
1677: BEGIN
1678: SELECT lot.location_code
1679: INTO l_bill_locn_code
1680: FROM HR_LOCATIONS_ALL loc, HR_LOCATIONS_ALL_TL lot
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')

Line 1704: FROM HR_LOCATIONS_ALL loc, HR_LOCATIONS_ALL_TL lot

1700:
1701: BEGIN
1702: SELECT loc.location_id
1703: INTO l_bill_locn_id
1704: FROM HR_LOCATIONS_ALL loc, HR_LOCATIONS_ALL_TL lot
1705: WHERE loc.location_id = p_bill_location_id
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

Line 1730: FROM HR_LOCATIONS_ALL loc, HR_LOCATIONS_ALL_TL lot

1726:
1727: BEGIN
1728: SELECT loc.location_id
1729: INTO p_bill_location_id
1730: FROM HR_LOCATIONS_ALL loc, HR_LOCATIONS_ALL_TL lot
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')