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.PNT_LOCATIONS_PKG dependencies on STANDARD

Line 1191: ,x_STANDARD_TYPE_LOOKUP_CODE VARCHAR2

1187: ,x_LOCATION_PARK_ID NUMBER
1188: ,x_LOCATION_TYPE_LOOKUP_CODE VARCHAR2
1189: ,x_SPACE_TYPE_LOOKUP_CODE VARCHAR2
1190: ,x_FUNCTION_TYPE_LOOKUP_CODE VARCHAR2
1191: ,x_STANDARD_TYPE_LOOKUP_CODE VARCHAR2
1192: ,x_LOCATION_ALIAS VARCHAR2
1193: ,x_LOCATION_CODE VARCHAR2
1194: ,x_BUILDING VARCHAR2
1195: ,x_LEASE_OR_OWNED VARCHAR2

Line 1486: ,STANDARD_TYPE_LOOKUP_CODE

1482: ,LOCATION_PARK_ID
1483: ,LOCATION_TYPE_LOOKUP_CODE
1484: ,SPACE_TYPE_LOOKUP_CODE
1485: ,FUNCTION_TYPE_LOOKUP_CODE
1486: ,STANDARD_TYPE_LOOKUP_CODE
1487: ,LOCATION_ALIAS
1488: ,LOCATION_CODE
1489: ,BUILDING
1490: ,LEASE_OR_OWNED

Line 1556: ,x_STANDARD_TYPE_LOOKUP_CODE

1552: ,x_LOCATION_PARK_ID
1553: ,x_LOCATION_TYPE_LOOKUP_CODE
1554: ,x_SPACE_TYPE_LOOKUP_CODE
1555: ,x_FUNCTION_TYPE_LOOKUP_CODE
1556: ,x_STANDARD_TYPE_LOOKUP_CODE
1557: ,x_LOCATION_ALIAS
1558: ,x_LOCATION_CODE
1559: ,x_BUILDING
1560: ,x_LEASE_OR_OWNED

Line 1665: ,x_STANDARD_TYPE_LOOKUP_CODE VARCHAR2

1661: ,x_LOCATION_PARK_ID NUMBER
1662: ,x_LOCATION_TYPE_LOOKUP_CODE VARCHAR2
1663: ,x_SPACE_TYPE_LOOKUP_CODE VARCHAR2
1664: ,x_FUNCTION_TYPE_LOOKUP_CODE VARCHAR2
1665: ,x_STANDARD_TYPE_LOOKUP_CODE VARCHAR2
1666: ,x_BUILDING VARCHAR2
1667: ,x_LEASE_OR_OWNED VARCHAR2
1668: ,x_CLASS VARCHAR2
1669: ,x_STATUS_TYPE VARCHAR2

Line 1794: ,STANDARD_TYPE_LOOKUP_CODE = x_STANDARD_TYPE_LOOKUP_CODE

1790: ,LOCATION_PARK_ID = x_LOCATION_PARK_ID
1791: ,LOCATION_TYPE_LOOKUP_CODE = x_LOCATION_TYPE_LOOKUP_CODE
1792: ,SPACE_TYPE_LOOKUP_CODE = x_SPACE_TYPE_LOOKUP_CODE
1793: ,FUNCTION_TYPE_LOOKUP_CODE = x_FUNCTION_TYPE_LOOKUP_CODE
1794: ,STANDARD_TYPE_LOOKUP_CODE = x_STANDARD_TYPE_LOOKUP_CODE
1795: ,BUILDING = x_BUILDING
1796: ,LEASE_OR_OWNED = x_LEASE_OR_OWNED
1797: ,CLASS = x_CLASS -- Added redwin
1798: ,STATUS_TYPE = x_STATUS_TYPE

Line 1931: ,x_STANDARD_TYPE_LOOKUP_CODE VARCHAR2

1927: ,x_LOCATION_PARK_ID NUMBER
1928: ,x_LOCATION_TYPE_LOOKUP_CODE VARCHAR2
1929: ,x_SPACE_TYPE_LOOKUP_CODE VARCHAR2
1930: ,x_FUNCTION_TYPE_LOOKUP_CODE VARCHAR2
1931: ,x_STANDARD_TYPE_LOOKUP_CODE VARCHAR2
1932: ,x_LOCATION_ALIAS VARCHAR2
1933: ,x_LOCATION_CODE VARCHAR2
1934: ,x_BUILDING VARCHAR2
1935: ,x_LEASE_OR_OWNED VARCHAR2

Line 2153: IF NOT ((G_LOC_RECINFO.STANDARD_TYPE_LOOKUP_CODE = X_STANDARD_TYPE_LOOKUP_CODE)

2149: pn_var_rent_pkg.lock_row_exception('SPACE_TYPE_LOOKUP_CODE',G_LOC_RECINFO.SPACE_TYPE_LOOKUP_CODE);
2150: END IF;
2151:
2152:
2153: IF NOT ((G_LOC_RECINFO.STANDARD_TYPE_LOOKUP_CODE = X_STANDARD_TYPE_LOOKUP_CODE)
2154: OR ((G_LOC_RECINFO.STANDARD_TYPE_LOOKUP_CODE is null) AND (X_STANDARD_TYPE_LOOKUP_CODE is null))) THEN
2155: pn_var_rent_pkg.lock_row_exception('STANDARD_TYPE_LOOKUP_CODE',G_LOC_RECINFO.STANDARD_TYPE_LOOKUP_CODE);
2156: END IF;
2157:

Line 2154: OR ((G_LOC_RECINFO.STANDARD_TYPE_LOOKUP_CODE is null) AND (X_STANDARD_TYPE_LOOKUP_CODE is null))) THEN

2150: END IF;
2151:
2152:
2153: IF NOT ((G_LOC_RECINFO.STANDARD_TYPE_LOOKUP_CODE = X_STANDARD_TYPE_LOOKUP_CODE)
2154: OR ((G_LOC_RECINFO.STANDARD_TYPE_LOOKUP_CODE is null) AND (X_STANDARD_TYPE_LOOKUP_CODE is null))) THEN
2155: pn_var_rent_pkg.lock_row_exception('STANDARD_TYPE_LOOKUP_CODE',G_LOC_RECINFO.STANDARD_TYPE_LOOKUP_CODE);
2156: END IF;
2157:
2158: IF NOT (G_LOC_RECINFO.LOCATION_CODE = X_LOCATION_CODE) THEN

Line 2155: pn_var_rent_pkg.lock_row_exception('STANDARD_TYPE_LOOKUP_CODE',G_LOC_RECINFO.STANDARD_TYPE_LOOKUP_CODE);

2151:
2152:
2153: IF NOT ((G_LOC_RECINFO.STANDARD_TYPE_LOOKUP_CODE = X_STANDARD_TYPE_LOOKUP_CODE)
2154: OR ((G_LOC_RECINFO.STANDARD_TYPE_LOOKUP_CODE is null) AND (X_STANDARD_TYPE_LOOKUP_CODE is null))) THEN
2155: pn_var_rent_pkg.lock_row_exception('STANDARD_TYPE_LOOKUP_CODE',G_LOC_RECINFO.STANDARD_TYPE_LOOKUP_CODE);
2156: END IF;
2157:
2158: IF NOT (G_LOC_RECINFO.LOCATION_CODE = X_LOCATION_CODE) THEN
2159: pn_var_rent_pkg.lock_row_exception('LOCATION_CODE',G_LOC_RECINFO.LOCATION_CODE);

Line 2718: IF ((G_LOC_RECINFO.STANDARD_TYPE_LOOKUP_CODE <> p_pn_locations_rec.STANDARD_TYPE_LOOKUP_CODE)

2714: x_flag := 'Y';
2715: return;
2716: END IF;
2717:
2718: IF ((G_LOC_RECINFO.STANDARD_TYPE_LOOKUP_CODE <> p_pn_locations_rec.STANDARD_TYPE_LOOKUP_CODE)
2719: OR ((G_LOC_RECINFO.STANDARD_TYPE_LOOKUP_CODE is NULL) AND (p_pn_locations_rec.STANDARD_TYPE_LOOKUP_CODE is NOT NULL))
2720: OR ((G_LOC_RECINFO.STANDARD_TYPE_LOOKUP_CODE is NOT NULL) AND (p_pn_locations_rec.STANDARD_TYPE_LOOKUP_CODE is NULL))) THEN
2721: x_flag := 'Y';
2722: return;

Line 2719: OR ((G_LOC_RECINFO.STANDARD_TYPE_LOOKUP_CODE is NULL) AND (p_pn_locations_rec.STANDARD_TYPE_LOOKUP_CODE is NOT NULL))

2715: return;
2716: END IF;
2717:
2718: IF ((G_LOC_RECINFO.STANDARD_TYPE_LOOKUP_CODE <> p_pn_locations_rec.STANDARD_TYPE_LOOKUP_CODE)
2719: OR ((G_LOC_RECINFO.STANDARD_TYPE_LOOKUP_CODE is NULL) AND (p_pn_locations_rec.STANDARD_TYPE_LOOKUP_CODE is NOT NULL))
2720: OR ((G_LOC_RECINFO.STANDARD_TYPE_LOOKUP_CODE is NOT NULL) AND (p_pn_locations_rec.STANDARD_TYPE_LOOKUP_CODE is NULL))) THEN
2721: x_flag := 'Y';
2722: return;
2723: END IF;

Line 2720: OR ((G_LOC_RECINFO.STANDARD_TYPE_LOOKUP_CODE is NOT NULL) AND (p_pn_locations_rec.STANDARD_TYPE_LOOKUP_CODE is NULL))) THEN

2716: END IF;
2717:
2718: IF ((G_LOC_RECINFO.STANDARD_TYPE_LOOKUP_CODE <> p_pn_locations_rec.STANDARD_TYPE_LOOKUP_CODE)
2719: OR ((G_LOC_RECINFO.STANDARD_TYPE_LOOKUP_CODE is NULL) AND (p_pn_locations_rec.STANDARD_TYPE_LOOKUP_CODE is NOT NULL))
2720: OR ((G_LOC_RECINFO.STANDARD_TYPE_LOOKUP_CODE is NOT NULL) AND (p_pn_locations_rec.STANDARD_TYPE_LOOKUP_CODE is NULL))) THEN
2721: x_flag := 'Y';
2722: return;
2723: END IF;
2724:

Line 3410: ,x_standard_type_lookup_code => p_loc_recinfo.standard_type_lookup_code

3406: ,x_location_park_id => p_loc_recinfo.location_park_id
3407: ,x_location_type_lookup_code => p_loc_recinfo.location_type_lookup_code
3408: ,x_space_type_lookup_code => p_loc_recinfo.space_type_lookup_code
3409: ,x_function_type_lookup_code => p_loc_recinfo.function_type_lookup_code
3410: ,x_standard_type_lookup_code => p_loc_recinfo.standard_type_lookup_code
3411: ,x_building => p_loc_recinfo.building
3412: ,x_lease_or_owned => p_loc_recinfo.lease_or_owned
3413: ,x_class => p_loc_recinfo.class
3414: ,x_status_type => p_loc_recinfo.status_type

Line 3545: ,x_standard_type_lookup_code => p_loc_recinfo.standard_type_lookup_code

3541: ,x_location_park_id => p_loc_recinfo.location_park_id
3542: ,x_location_type_lookup_code => p_loc_recinfo.location_type_lookup_code
3543: ,x_space_type_lookup_code => p_loc_recinfo.space_type_lookup_code
3544: ,x_function_type_lookup_code => p_loc_recinfo.function_type_lookup_code
3545: ,x_standard_type_lookup_code => p_loc_recinfo.standard_type_lookup_code
3546: ,x_location_alias => p_loc_recinfo.location_alias
3547: ,x_location_code => p_loc_recinfo.location_code
3548: ,x_building => p_loc_recinfo.building
3549: ,x_lease_or_owned => p_loc_recinfo.lease_or_owned