APPS.PNP_UTIL_FUNC dependencies on PN_LOCATIONS

Line 50: office_location_code PN_LOCATIONS.location_code%TYPE,

46: task_name PA_TASKS.task_name%TYPE
47: );
48:
49: TYPE location_name_rec IS RECORD (
50: office_location_code PN_LOCATIONS.location_code%TYPE,
51: office PN_LOCATIONS.office%TYPE,
52: floor_location_code PN_LOCATIONS.location_code%TYPE,
53: floor PN_LOCATIONS.floor%TYPE,
54: building_location_code PN_LOCATIONS.location_code%TYPE,

Line 51: office PN_LOCATIONS.office%TYPE,

47: );
48:
49: TYPE location_name_rec IS RECORD (
50: office_location_code PN_LOCATIONS.location_code%TYPE,
51: office PN_LOCATIONS.office%TYPE,
52: floor_location_code PN_LOCATIONS.location_code%TYPE,
53: floor PN_LOCATIONS.floor%TYPE,
54: building_location_code PN_LOCATIONS.location_code%TYPE,
55: building PN_LOCATIONS.building%TYPE,

Line 52: floor_location_code PN_LOCATIONS.location_code%TYPE,

48:
49: TYPE location_name_rec IS RECORD (
50: office_location_code PN_LOCATIONS.location_code%TYPE,
51: office PN_LOCATIONS.office%TYPE,
52: floor_location_code PN_LOCATIONS.location_code%TYPE,
53: floor PN_LOCATIONS.floor%TYPE,
54: building_location_code PN_LOCATIONS.location_code%TYPE,
55: building PN_LOCATIONS.building%TYPE,
56: property_code PN_PROPERTIES.property_code%TYPE,

Line 53: floor PN_LOCATIONS.floor%TYPE,

49: TYPE location_name_rec IS RECORD (
50: office_location_code PN_LOCATIONS.location_code%TYPE,
51: office PN_LOCATIONS.office%TYPE,
52: floor_location_code PN_LOCATIONS.location_code%TYPE,
53: floor PN_LOCATIONS.floor%TYPE,
54: building_location_code PN_LOCATIONS.location_code%TYPE,
55: building PN_LOCATIONS.building%TYPE,
56: property_code PN_PROPERTIES.property_code%TYPE,
57: property_name PN_PROPERTIES.property_name%TYPE,

Line 54: building_location_code PN_LOCATIONS.location_code%TYPE,

50: office_location_code PN_LOCATIONS.location_code%TYPE,
51: office PN_LOCATIONS.office%TYPE,
52: floor_location_code PN_LOCATIONS.location_code%TYPE,
53: floor PN_LOCATIONS.floor%TYPE,
54: building_location_code PN_LOCATIONS.location_code%TYPE,
55: building PN_LOCATIONS.building%TYPE,
56: property_code PN_PROPERTIES.property_code%TYPE,
57: property_name PN_PROPERTIES.property_name%TYPE,
58: office_park_name PN_LOCATION_PARKS.name%TYPE,

Line 55: building PN_LOCATIONS.building%TYPE,

51: office PN_LOCATIONS.office%TYPE,
52: floor_location_code PN_LOCATIONS.location_code%TYPE,
53: floor PN_LOCATIONS.floor%TYPE,
54: building_location_code PN_LOCATIONS.location_code%TYPE,
55: building PN_LOCATIONS.building%TYPE,
56: property_code PN_PROPERTIES.property_code%TYPE,
57: property_name PN_PROPERTIES.property_name%TYPE,
58: office_park_name PN_LOCATION_PARKS.name%TYPE,
59: region_name PN_LOCATION_PARKS.name%TYPE

Line 90: location_id PN_LOCATIONS_ALL.location_id%type,

86:
87:
88: TYPE space_assignment_rec IS RECORD (
89:
90: location_id PN_LOCATIONS_ALL.location_id%type,
91: assignment_id PN_SPACE_ASSIGN_CUST_ALL.cust_space_assign_id%type,
92: assign_start_date PN_SPACE_ASSIGN_CUST_ALL.cust_assign_start_date%type,
93: assign_end_date PN_SPACE_ASSIGN_CUST_ALL.cust_assign_start_date%type,
94: allocated_area_pct PN_SPACE_ASSIGN_CUST_ALL.allocated_area_pct%type,

Line 1139: G_location_code pn_locations_all.location_code%TYPE;

1135:
1136: /* Added following three variables for bug 6514984*/
1137: G_location_id NUMBER;
1138: G_as_of_dt DATE;
1139: G_location_code pn_locations_all.location_code%TYPE;
1140: --------------------------------------
1141: -- End of Package Spec --
1142: --------------------------------------
1143: END pnp_util_func;