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.PNRX_SP_ASSIGN_BY_LOC dependencies on PN_SPACE_ASSIGN_LOC_ITF

Line 19: FROM pn_space_assign_loc_itf

15: v_var1 VARCHAR2(1);
16: BEGIN
17: SELECT 'X'
18: INTO v_var1
19: FROM pn_space_assign_loc_itf
20: WHERE location_id = p_location_id
21: AND person_id(+) = p_person_id
22: AND cost_center = p_cost_center
23: AND request_id = P_request_id;

Line 52: FROM pn_space_assign_loc_itf

48: v_var2 VARCHAR2(1);
49: BEGIN
50: SELECT 'Y'
51: INTO v_var2
52: FROM pn_space_assign_loc_itf
53: WHERE location_id = p_location_id
54: AND customer_account = p_account_id
55: AND request_id = p_request_id;
56: RETURN TRUE;

Line 99: v_location_id pn_space_assign_loc_itf.location_id%TYPE;

95: l_two NUMBER := 2;
96: l_three NUMBER := 3;
97:
98: --declare all columns as variables here
99: v_location_id pn_space_assign_loc_itf.location_id%TYPE;
100: v_location_id_1 pn_space_assign_loc_itf.location_id%TYPE;
101: v_location_id_2 pn_space_assign_loc_itf.location_id%TYPE;
102: v_location_id_3 pn_space_assign_loc_itf.location_id%TYPE;
103: v_location_type pn_space_assign_loc_itf.location_type%TYPE;

Line 100: v_location_id_1 pn_space_assign_loc_itf.location_id%TYPE;

96: l_three NUMBER := 3;
97:
98: --declare all columns as variables here
99: v_location_id pn_space_assign_loc_itf.location_id%TYPE;
100: v_location_id_1 pn_space_assign_loc_itf.location_id%TYPE;
101: v_location_id_2 pn_space_assign_loc_itf.location_id%TYPE;
102: v_location_id_3 pn_space_assign_loc_itf.location_id%TYPE;
103: v_location_type pn_space_assign_loc_itf.location_type%TYPE;
104: v_location_name pn_space_assign_loc_itf.location_name%TYPE;

Line 101: v_location_id_2 pn_space_assign_loc_itf.location_id%TYPE;

97:
98: --declare all columns as variables here
99: v_location_id pn_space_assign_loc_itf.location_id%TYPE;
100: v_location_id_1 pn_space_assign_loc_itf.location_id%TYPE;
101: v_location_id_2 pn_space_assign_loc_itf.location_id%TYPE;
102: v_location_id_3 pn_space_assign_loc_itf.location_id%TYPE;
103: v_location_type pn_space_assign_loc_itf.location_type%TYPE;
104: v_location_name pn_space_assign_loc_itf.location_name%TYPE;
105: v_location_code pn_space_assign_loc_itf.location_code%TYPE;

Line 102: v_location_id_3 pn_space_assign_loc_itf.location_id%TYPE;

98: --declare all columns as variables here
99: v_location_id pn_space_assign_loc_itf.location_id%TYPE;
100: v_location_id_1 pn_space_assign_loc_itf.location_id%TYPE;
101: v_location_id_2 pn_space_assign_loc_itf.location_id%TYPE;
102: v_location_id_3 pn_space_assign_loc_itf.location_id%TYPE;
103: v_location_type pn_space_assign_loc_itf.location_type%TYPE;
104: v_location_name pn_space_assign_loc_itf.location_name%TYPE;
105: v_location_code pn_space_assign_loc_itf.location_code%TYPE;
106: v_space_type pn_space_assign_loc_itf.space_type%TYPE;

Line 103: v_location_type pn_space_assign_loc_itf.location_type%TYPE;

99: v_location_id pn_space_assign_loc_itf.location_id%TYPE;
100: v_location_id_1 pn_space_assign_loc_itf.location_id%TYPE;
101: v_location_id_2 pn_space_assign_loc_itf.location_id%TYPE;
102: v_location_id_3 pn_space_assign_loc_itf.location_id%TYPE;
103: v_location_type pn_space_assign_loc_itf.location_type%TYPE;
104: v_location_name pn_space_assign_loc_itf.location_name%TYPE;
105: v_location_code pn_space_assign_loc_itf.location_code%TYPE;
106: v_space_type pn_space_assign_loc_itf.space_type%TYPE;
107: v_property_code pn_space_assign_loc_itf.property_code%TYPE;

Line 104: v_location_name pn_space_assign_loc_itf.location_name%TYPE;

100: v_location_id_1 pn_space_assign_loc_itf.location_id%TYPE;
101: v_location_id_2 pn_space_assign_loc_itf.location_id%TYPE;
102: v_location_id_3 pn_space_assign_loc_itf.location_id%TYPE;
103: v_location_type pn_space_assign_loc_itf.location_type%TYPE;
104: v_location_name pn_space_assign_loc_itf.location_name%TYPE;
105: v_location_code pn_space_assign_loc_itf.location_code%TYPE;
106: v_space_type pn_space_assign_loc_itf.space_type%TYPE;
107: v_property_code pn_space_assign_loc_itf.property_code%TYPE;
108: v_person_id pn_space_assign_loc_itf.person_id%TYPE;

Line 105: v_location_code pn_space_assign_loc_itf.location_code%TYPE;

101: v_location_id_2 pn_space_assign_loc_itf.location_id%TYPE;
102: v_location_id_3 pn_space_assign_loc_itf.location_id%TYPE;
103: v_location_type pn_space_assign_loc_itf.location_type%TYPE;
104: v_location_name pn_space_assign_loc_itf.location_name%TYPE;
105: v_location_code pn_space_assign_loc_itf.location_code%TYPE;
106: v_space_type pn_space_assign_loc_itf.space_type%TYPE;
107: v_property_code pn_space_assign_loc_itf.property_code%TYPE;
108: v_person_id pn_space_assign_loc_itf.person_id%TYPE;
109: v_person_id_3 pn_space_assign_loc_itf.person_id%TYPE;

Line 106: v_space_type pn_space_assign_loc_itf.space_type%TYPE;

102: v_location_id_3 pn_space_assign_loc_itf.location_id%TYPE;
103: v_location_type pn_space_assign_loc_itf.location_type%TYPE;
104: v_location_name pn_space_assign_loc_itf.location_name%TYPE;
105: v_location_code pn_space_assign_loc_itf.location_code%TYPE;
106: v_space_type pn_space_assign_loc_itf.space_type%TYPE;
107: v_property_code pn_space_assign_loc_itf.property_code%TYPE;
108: v_person_id pn_space_assign_loc_itf.person_id%TYPE;
109: v_person_id_3 pn_space_assign_loc_itf.person_id%TYPE;
110: v_cost_center pn_space_assign_loc_itf.cost_center%TYPE;

Line 107: v_property_code pn_space_assign_loc_itf.property_code%TYPE;

103: v_location_type pn_space_assign_loc_itf.location_type%TYPE;
104: v_location_name pn_space_assign_loc_itf.location_name%TYPE;
105: v_location_code pn_space_assign_loc_itf.location_code%TYPE;
106: v_space_type pn_space_assign_loc_itf.space_type%TYPE;
107: v_property_code pn_space_assign_loc_itf.property_code%TYPE;
108: v_person_id pn_space_assign_loc_itf.person_id%TYPE;
109: v_person_id_3 pn_space_assign_loc_itf.person_id%TYPE;
110: v_cost_center pn_space_assign_loc_itf.cost_center%TYPE;
111: v_employee_project_number pn_space_assign_loc_itf.employee_project_number%TYPE;

Line 108: v_person_id pn_space_assign_loc_itf.person_id%TYPE;

104: v_location_name pn_space_assign_loc_itf.location_name%TYPE;
105: v_location_code pn_space_assign_loc_itf.location_code%TYPE;
106: v_space_type pn_space_assign_loc_itf.space_type%TYPE;
107: v_property_code pn_space_assign_loc_itf.property_code%TYPE;
108: v_person_id pn_space_assign_loc_itf.person_id%TYPE;
109: v_person_id_3 pn_space_assign_loc_itf.person_id%TYPE;
110: v_cost_center pn_space_assign_loc_itf.cost_center%TYPE;
111: v_employee_project_number pn_space_assign_loc_itf.employee_project_number%TYPE;
112: v_employee_task_number pn_space_assign_loc_itf.employee_task_number%TYPE;

Line 109: v_person_id_3 pn_space_assign_loc_itf.person_id%TYPE;

105: v_location_code pn_space_assign_loc_itf.location_code%TYPE;
106: v_space_type pn_space_assign_loc_itf.space_type%TYPE;
107: v_property_code pn_space_assign_loc_itf.property_code%TYPE;
108: v_person_id pn_space_assign_loc_itf.person_id%TYPE;
109: v_person_id_3 pn_space_assign_loc_itf.person_id%TYPE;
110: v_cost_center pn_space_assign_loc_itf.cost_center%TYPE;
111: v_employee_project_number pn_space_assign_loc_itf.employee_project_number%TYPE;
112: v_employee_task_number pn_space_assign_loc_itf.employee_task_number%TYPE;
113: v_employee_assigned_from pn_space_assign_loc_itf.employee_assigned_from%TYPE;

Line 110: v_cost_center pn_space_assign_loc_itf.cost_center%TYPE;

106: v_space_type pn_space_assign_loc_itf.space_type%TYPE;
107: v_property_code pn_space_assign_loc_itf.property_code%TYPE;
108: v_person_id pn_space_assign_loc_itf.person_id%TYPE;
109: v_person_id_3 pn_space_assign_loc_itf.person_id%TYPE;
110: v_cost_center pn_space_assign_loc_itf.cost_center%TYPE;
111: v_employee_project_number pn_space_assign_loc_itf.employee_project_number%TYPE;
112: v_employee_task_number pn_space_assign_loc_itf.employee_task_number%TYPE;
113: v_employee_assigned_from pn_space_assign_loc_itf.employee_assigned_from%TYPE;
114: v_employee_assigned_to pn_space_assign_loc_itf.employee_assigned_to%TYPE;

Line 111: v_employee_project_number pn_space_assign_loc_itf.employee_project_number%TYPE;

107: v_property_code pn_space_assign_loc_itf.property_code%TYPE;
108: v_person_id pn_space_assign_loc_itf.person_id%TYPE;
109: v_person_id_3 pn_space_assign_loc_itf.person_id%TYPE;
110: v_cost_center pn_space_assign_loc_itf.cost_center%TYPE;
111: v_employee_project_number pn_space_assign_loc_itf.employee_project_number%TYPE;
112: v_employee_task_number pn_space_assign_loc_itf.employee_task_number%TYPE;
113: v_employee_assigned_from pn_space_assign_loc_itf.employee_assigned_from%TYPE;
114: v_employee_assigned_to pn_space_assign_loc_itf.employee_assigned_to%TYPE;
115: v_customer_account pn_space_assign_loc_itf.customer_account%TYPE;

Line 112: v_employee_task_number pn_space_assign_loc_itf.employee_task_number%TYPE;

108: v_person_id pn_space_assign_loc_itf.person_id%TYPE;
109: v_person_id_3 pn_space_assign_loc_itf.person_id%TYPE;
110: v_cost_center pn_space_assign_loc_itf.cost_center%TYPE;
111: v_employee_project_number pn_space_assign_loc_itf.employee_project_number%TYPE;
112: v_employee_task_number pn_space_assign_loc_itf.employee_task_number%TYPE;
113: v_employee_assigned_from pn_space_assign_loc_itf.employee_assigned_from%TYPE;
114: v_employee_assigned_to pn_space_assign_loc_itf.employee_assigned_to%TYPE;
115: v_customer_account pn_space_assign_loc_itf.customer_account%TYPE;
116: v_exp_account NUMBER;

Line 113: v_employee_assigned_from pn_space_assign_loc_itf.employee_assigned_from%TYPE;

109: v_person_id_3 pn_space_assign_loc_itf.person_id%TYPE;
110: v_cost_center pn_space_assign_loc_itf.cost_center%TYPE;
111: v_employee_project_number pn_space_assign_loc_itf.employee_project_number%TYPE;
112: v_employee_task_number pn_space_assign_loc_itf.employee_task_number%TYPE;
113: v_employee_assigned_from pn_space_assign_loc_itf.employee_assigned_from%TYPE;
114: v_employee_assigned_to pn_space_assign_loc_itf.employee_assigned_to%TYPE;
115: v_customer_account pn_space_assign_loc_itf.customer_account%TYPE;
116: v_exp_account NUMBER;
117: v_customer_account_id NUMBER;

Line 114: v_employee_assigned_to pn_space_assign_loc_itf.employee_assigned_to%TYPE;

110: v_cost_center pn_space_assign_loc_itf.cost_center%TYPE;
111: v_employee_project_number pn_space_assign_loc_itf.employee_project_number%TYPE;
112: v_employee_task_number pn_space_assign_loc_itf.employee_task_number%TYPE;
113: v_employee_assigned_from pn_space_assign_loc_itf.employee_assigned_from%TYPE;
114: v_employee_assigned_to pn_space_assign_loc_itf.employee_assigned_to%TYPE;
115: v_customer_account pn_space_assign_loc_itf.customer_account%TYPE;
116: v_exp_account NUMBER;
117: v_customer_account_id NUMBER;
118: v_customer_project_number pn_space_assign_loc_itf.customer_project_number%TYPE;

Line 115: v_customer_account pn_space_assign_loc_itf.customer_account%TYPE;

111: v_employee_project_number pn_space_assign_loc_itf.employee_project_number%TYPE;
112: v_employee_task_number pn_space_assign_loc_itf.employee_task_number%TYPE;
113: v_employee_assigned_from pn_space_assign_loc_itf.employee_assigned_from%TYPE;
114: v_employee_assigned_to pn_space_assign_loc_itf.employee_assigned_to%TYPE;
115: v_customer_account pn_space_assign_loc_itf.customer_account%TYPE;
116: v_exp_account NUMBER;
117: v_customer_account_id NUMBER;
118: v_customer_project_number pn_space_assign_loc_itf.customer_project_number%TYPE;
119: v_customer_task_number pn_space_assign_loc_itf.customer_task_number%TYPE;

Line 118: v_customer_project_number pn_space_assign_loc_itf.customer_project_number%TYPE;

114: v_employee_assigned_to pn_space_assign_loc_itf.employee_assigned_to%TYPE;
115: v_customer_account pn_space_assign_loc_itf.customer_account%TYPE;
116: v_exp_account NUMBER;
117: v_customer_account_id NUMBER;
118: v_customer_project_number pn_space_assign_loc_itf.customer_project_number%TYPE;
119: v_customer_task_number pn_space_assign_loc_itf.customer_task_number%TYPE;
120: v_customer_assigned_from pn_space_assign_loc_itf.customer_assigned_from%TYPE;
121: v_customer_assigned_to pn_space_assign_loc_itf.customer_assigned_to%TYPE;
122: v_customer_name pn_space_assign_loc_itf.customer_name%TYPE;

Line 119: v_customer_task_number pn_space_assign_loc_itf.customer_task_number%TYPE;

115: v_customer_account pn_space_assign_loc_itf.customer_account%TYPE;
116: v_exp_account NUMBER;
117: v_customer_account_id NUMBER;
118: v_customer_project_number pn_space_assign_loc_itf.customer_project_number%TYPE;
119: v_customer_task_number pn_space_assign_loc_itf.customer_task_number%TYPE;
120: v_customer_assigned_from pn_space_assign_loc_itf.customer_assigned_from%TYPE;
121: v_customer_assigned_to pn_space_assign_loc_itf.customer_assigned_to%TYPE;
122: v_customer_name pn_space_assign_loc_itf.customer_name%TYPE;
123: v_customer_site pn_space_assign_loc_itf.customer_site%TYPE;

Line 120: v_customer_assigned_from pn_space_assign_loc_itf.customer_assigned_from%TYPE;

116: v_exp_account NUMBER;
117: v_customer_account_id NUMBER;
118: v_customer_project_number pn_space_assign_loc_itf.customer_project_number%TYPE;
119: v_customer_task_number pn_space_assign_loc_itf.customer_task_number%TYPE;
120: v_customer_assigned_from pn_space_assign_loc_itf.customer_assigned_from%TYPE;
121: v_customer_assigned_to pn_space_assign_loc_itf.customer_assigned_to%TYPE;
122: v_customer_name pn_space_assign_loc_itf.customer_name%TYPE;
123: v_customer_site pn_space_assign_loc_itf.customer_site%TYPE;
124: v_customer_category pn_space_assign_loc_itf.customer_category%TYPE;

Line 121: v_customer_assigned_to pn_space_assign_loc_itf.customer_assigned_to%TYPE;

117: v_customer_account_id NUMBER;
118: v_customer_project_number pn_space_assign_loc_itf.customer_project_number%TYPE;
119: v_customer_task_number pn_space_assign_loc_itf.customer_task_number%TYPE;
120: v_customer_assigned_from pn_space_assign_loc_itf.customer_assigned_from%TYPE;
121: v_customer_assigned_to pn_space_assign_loc_itf.customer_assigned_to%TYPE;
122: v_customer_name pn_space_assign_loc_itf.customer_name%TYPE;
123: v_customer_site pn_space_assign_loc_itf.customer_site%TYPE;
124: v_customer_category pn_space_assign_loc_itf.customer_category%TYPE;
125: v_rentable_area pn_space_assign_loc_itf.rentable_area%TYPE;

Line 122: v_customer_name pn_space_assign_loc_itf.customer_name%TYPE;

118: v_customer_project_number pn_space_assign_loc_itf.customer_project_number%TYPE;
119: v_customer_task_number pn_space_assign_loc_itf.customer_task_number%TYPE;
120: v_customer_assigned_from pn_space_assign_loc_itf.customer_assigned_from%TYPE;
121: v_customer_assigned_to pn_space_assign_loc_itf.customer_assigned_to%TYPE;
122: v_customer_name pn_space_assign_loc_itf.customer_name%TYPE;
123: v_customer_site pn_space_assign_loc_itf.customer_site%TYPE;
124: v_customer_category pn_space_assign_loc_itf.customer_category%TYPE;
125: v_rentable_area pn_space_assign_loc_itf.rentable_area%TYPE;
126: v_usable_area pn_space_assign_loc_itf.usable_area%TYPE;

Line 123: v_customer_site pn_space_assign_loc_itf.customer_site%TYPE;

119: v_customer_task_number pn_space_assign_loc_itf.customer_task_number%TYPE;
120: v_customer_assigned_from pn_space_assign_loc_itf.customer_assigned_from%TYPE;
121: v_customer_assigned_to pn_space_assign_loc_itf.customer_assigned_to%TYPE;
122: v_customer_name pn_space_assign_loc_itf.customer_name%TYPE;
123: v_customer_site pn_space_assign_loc_itf.customer_site%TYPE;
124: v_customer_category pn_space_assign_loc_itf.customer_category%TYPE;
125: v_rentable_area pn_space_assign_loc_itf.rentable_area%TYPE;
126: v_usable_area pn_space_assign_loc_itf.usable_area%TYPE;
127: v_assignable_area pn_space_assign_loc_itf.assignable_area%TYPE;

Line 124: v_customer_category pn_space_assign_loc_itf.customer_category%TYPE;

120: v_customer_assigned_from pn_space_assign_loc_itf.customer_assigned_from%TYPE;
121: v_customer_assigned_to pn_space_assign_loc_itf.customer_assigned_to%TYPE;
122: v_customer_name pn_space_assign_loc_itf.customer_name%TYPE;
123: v_customer_site pn_space_assign_loc_itf.customer_site%TYPE;
124: v_customer_category pn_space_assign_loc_itf.customer_category%TYPE;
125: v_rentable_area pn_space_assign_loc_itf.rentable_area%TYPE;
126: v_usable_area pn_space_assign_loc_itf.usable_area%TYPE;
127: v_assignable_area pn_space_assign_loc_itf.assignable_area%TYPE;
128: v_common_area pn_space_assign_loc_itf.common_area%TYPE;

Line 125: v_rentable_area pn_space_assign_loc_itf.rentable_area%TYPE;

121: v_customer_assigned_to pn_space_assign_loc_itf.customer_assigned_to%TYPE;
122: v_customer_name pn_space_assign_loc_itf.customer_name%TYPE;
123: v_customer_site pn_space_assign_loc_itf.customer_site%TYPE;
124: v_customer_category pn_space_assign_loc_itf.customer_category%TYPE;
125: v_rentable_area pn_space_assign_loc_itf.rentable_area%TYPE;
126: v_usable_area pn_space_assign_loc_itf.usable_area%TYPE;
127: v_assignable_area pn_space_assign_loc_itf.assignable_area%TYPE;
128: v_common_area pn_space_assign_loc_itf.common_area%TYPE;
129: v_employee_assigned_area pn_space_assign_loc_itf.employee_assigned_area%TYPE;

Line 126: v_usable_area pn_space_assign_loc_itf.usable_area%TYPE;

122: v_customer_name pn_space_assign_loc_itf.customer_name%TYPE;
123: v_customer_site pn_space_assign_loc_itf.customer_site%TYPE;
124: v_customer_category pn_space_assign_loc_itf.customer_category%TYPE;
125: v_rentable_area pn_space_assign_loc_itf.rentable_area%TYPE;
126: v_usable_area pn_space_assign_loc_itf.usable_area%TYPE;
127: v_assignable_area pn_space_assign_loc_itf.assignable_area%TYPE;
128: v_common_area pn_space_assign_loc_itf.common_area%TYPE;
129: v_employee_assigned_area pn_space_assign_loc_itf.employee_assigned_area%TYPE;
130: v_customer_assigned_area pn_space_assign_loc_itf.customer_assigned_area%TYPE;

Line 127: v_assignable_area pn_space_assign_loc_itf.assignable_area%TYPE;

123: v_customer_site pn_space_assign_loc_itf.customer_site%TYPE;
124: v_customer_category pn_space_assign_loc_itf.customer_category%TYPE;
125: v_rentable_area pn_space_assign_loc_itf.rentable_area%TYPE;
126: v_usable_area pn_space_assign_loc_itf.usable_area%TYPE;
127: v_assignable_area pn_space_assign_loc_itf.assignable_area%TYPE;
128: v_common_area pn_space_assign_loc_itf.common_area%TYPE;
129: v_employee_assigned_area pn_space_assign_loc_itf.employee_assigned_area%TYPE;
130: v_customer_assigned_area pn_space_assign_loc_itf.customer_assigned_area%TYPE;
131: v_vacant_area NUMBER;

Line 128: v_common_area pn_space_assign_loc_itf.common_area%TYPE;

124: v_customer_category pn_space_assign_loc_itf.customer_category%TYPE;
125: v_rentable_area pn_space_assign_loc_itf.rentable_area%TYPE;
126: v_usable_area pn_space_assign_loc_itf.usable_area%TYPE;
127: v_assignable_area pn_space_assign_loc_itf.assignable_area%TYPE;
128: v_common_area pn_space_assign_loc_itf.common_area%TYPE;
129: v_employee_assigned_area pn_space_assign_loc_itf.employee_assigned_area%TYPE;
130: v_customer_assigned_area pn_space_assign_loc_itf.customer_assigned_area%TYPE;
131: v_vacant_area NUMBER;
132: v_attribute_category pn_space_assign_loc_itf.loc_attribute_category%TYPE;

Line 129: v_employee_assigned_area pn_space_assign_loc_itf.employee_assigned_area%TYPE;

125: v_rentable_area pn_space_assign_loc_itf.rentable_area%TYPE;
126: v_usable_area pn_space_assign_loc_itf.usable_area%TYPE;
127: v_assignable_area pn_space_assign_loc_itf.assignable_area%TYPE;
128: v_common_area pn_space_assign_loc_itf.common_area%TYPE;
129: v_employee_assigned_area pn_space_assign_loc_itf.employee_assigned_area%TYPE;
130: v_customer_assigned_area pn_space_assign_loc_itf.customer_assigned_area%TYPE;
131: v_vacant_area NUMBER;
132: v_attribute_category pn_space_assign_loc_itf.loc_attribute_category%TYPE;
133: v_attribute1 pn_space_assign_loc_itf.loc_attribute1%TYPE;

Line 130: v_customer_assigned_area pn_space_assign_loc_itf.customer_assigned_area%TYPE;

126: v_usable_area pn_space_assign_loc_itf.usable_area%TYPE;
127: v_assignable_area pn_space_assign_loc_itf.assignable_area%TYPE;
128: v_common_area pn_space_assign_loc_itf.common_area%TYPE;
129: v_employee_assigned_area pn_space_assign_loc_itf.employee_assigned_area%TYPE;
130: v_customer_assigned_area pn_space_assign_loc_itf.customer_assigned_area%TYPE;
131: v_vacant_area NUMBER;
132: v_attribute_category pn_space_assign_loc_itf.loc_attribute_category%TYPE;
133: v_attribute1 pn_space_assign_loc_itf.loc_attribute1%TYPE;
134: v_attribute2 pn_space_assign_loc_itf.loc_attribute2%TYPE;

Line 132: v_attribute_category pn_space_assign_loc_itf.loc_attribute_category%TYPE;

128: v_common_area pn_space_assign_loc_itf.common_area%TYPE;
129: v_employee_assigned_area pn_space_assign_loc_itf.employee_assigned_area%TYPE;
130: v_customer_assigned_area pn_space_assign_loc_itf.customer_assigned_area%TYPE;
131: v_vacant_area NUMBER;
132: v_attribute_category pn_space_assign_loc_itf.loc_attribute_category%TYPE;
133: v_attribute1 pn_space_assign_loc_itf.loc_attribute1%TYPE;
134: v_attribute2 pn_space_assign_loc_itf.loc_attribute2%TYPE;
135: v_attribute3 pn_space_assign_loc_itf.loc_attribute3%TYPE;
136: v_attribute4 pn_space_assign_loc_itf.loc_attribute4%TYPE;

Line 133: v_attribute1 pn_space_assign_loc_itf.loc_attribute1%TYPE;

129: v_employee_assigned_area pn_space_assign_loc_itf.employee_assigned_area%TYPE;
130: v_customer_assigned_area pn_space_assign_loc_itf.customer_assigned_area%TYPE;
131: v_vacant_area NUMBER;
132: v_attribute_category pn_space_assign_loc_itf.loc_attribute_category%TYPE;
133: v_attribute1 pn_space_assign_loc_itf.loc_attribute1%TYPE;
134: v_attribute2 pn_space_assign_loc_itf.loc_attribute2%TYPE;
135: v_attribute3 pn_space_assign_loc_itf.loc_attribute3%TYPE;
136: v_attribute4 pn_space_assign_loc_itf.loc_attribute4%TYPE;
137: v_attribute5 pn_space_assign_loc_itf.loc_attribute5%TYPE;

Line 134: v_attribute2 pn_space_assign_loc_itf.loc_attribute2%TYPE;

130: v_customer_assigned_area pn_space_assign_loc_itf.customer_assigned_area%TYPE;
131: v_vacant_area NUMBER;
132: v_attribute_category pn_space_assign_loc_itf.loc_attribute_category%TYPE;
133: v_attribute1 pn_space_assign_loc_itf.loc_attribute1%TYPE;
134: v_attribute2 pn_space_assign_loc_itf.loc_attribute2%TYPE;
135: v_attribute3 pn_space_assign_loc_itf.loc_attribute3%TYPE;
136: v_attribute4 pn_space_assign_loc_itf.loc_attribute4%TYPE;
137: v_attribute5 pn_space_assign_loc_itf.loc_attribute5%TYPE;
138: v_attribute6 pn_space_assign_loc_itf.loc_attribute6%TYPE;

Line 135: v_attribute3 pn_space_assign_loc_itf.loc_attribute3%TYPE;

131: v_vacant_area NUMBER;
132: v_attribute_category pn_space_assign_loc_itf.loc_attribute_category%TYPE;
133: v_attribute1 pn_space_assign_loc_itf.loc_attribute1%TYPE;
134: v_attribute2 pn_space_assign_loc_itf.loc_attribute2%TYPE;
135: v_attribute3 pn_space_assign_loc_itf.loc_attribute3%TYPE;
136: v_attribute4 pn_space_assign_loc_itf.loc_attribute4%TYPE;
137: v_attribute5 pn_space_assign_loc_itf.loc_attribute5%TYPE;
138: v_attribute6 pn_space_assign_loc_itf.loc_attribute6%TYPE;
139: v_attribute7 pn_space_assign_loc_itf.loc_attribute7%TYPE;

Line 136: v_attribute4 pn_space_assign_loc_itf.loc_attribute4%TYPE;

132: v_attribute_category pn_space_assign_loc_itf.loc_attribute_category%TYPE;
133: v_attribute1 pn_space_assign_loc_itf.loc_attribute1%TYPE;
134: v_attribute2 pn_space_assign_loc_itf.loc_attribute2%TYPE;
135: v_attribute3 pn_space_assign_loc_itf.loc_attribute3%TYPE;
136: v_attribute4 pn_space_assign_loc_itf.loc_attribute4%TYPE;
137: v_attribute5 pn_space_assign_loc_itf.loc_attribute5%TYPE;
138: v_attribute6 pn_space_assign_loc_itf.loc_attribute6%TYPE;
139: v_attribute7 pn_space_assign_loc_itf.loc_attribute7%TYPE;
140: v_attribute8 pn_space_assign_loc_itf.loc_attribute8%TYPE;

Line 137: v_attribute5 pn_space_assign_loc_itf.loc_attribute5%TYPE;

133: v_attribute1 pn_space_assign_loc_itf.loc_attribute1%TYPE;
134: v_attribute2 pn_space_assign_loc_itf.loc_attribute2%TYPE;
135: v_attribute3 pn_space_assign_loc_itf.loc_attribute3%TYPE;
136: v_attribute4 pn_space_assign_loc_itf.loc_attribute4%TYPE;
137: v_attribute5 pn_space_assign_loc_itf.loc_attribute5%TYPE;
138: v_attribute6 pn_space_assign_loc_itf.loc_attribute6%TYPE;
139: v_attribute7 pn_space_assign_loc_itf.loc_attribute7%TYPE;
140: v_attribute8 pn_space_assign_loc_itf.loc_attribute8%TYPE;
141: v_attribute9 pn_space_assign_loc_itf.loc_attribute9%TYPE;

Line 138: v_attribute6 pn_space_assign_loc_itf.loc_attribute6%TYPE;

134: v_attribute2 pn_space_assign_loc_itf.loc_attribute2%TYPE;
135: v_attribute3 pn_space_assign_loc_itf.loc_attribute3%TYPE;
136: v_attribute4 pn_space_assign_loc_itf.loc_attribute4%TYPE;
137: v_attribute5 pn_space_assign_loc_itf.loc_attribute5%TYPE;
138: v_attribute6 pn_space_assign_loc_itf.loc_attribute6%TYPE;
139: v_attribute7 pn_space_assign_loc_itf.loc_attribute7%TYPE;
140: v_attribute8 pn_space_assign_loc_itf.loc_attribute8%TYPE;
141: v_attribute9 pn_space_assign_loc_itf.loc_attribute9%TYPE;
142: v_attribute10 pn_space_assign_loc_itf.loc_attribute10%TYPE;

Line 139: v_attribute7 pn_space_assign_loc_itf.loc_attribute7%TYPE;

135: v_attribute3 pn_space_assign_loc_itf.loc_attribute3%TYPE;
136: v_attribute4 pn_space_assign_loc_itf.loc_attribute4%TYPE;
137: v_attribute5 pn_space_assign_loc_itf.loc_attribute5%TYPE;
138: v_attribute6 pn_space_assign_loc_itf.loc_attribute6%TYPE;
139: v_attribute7 pn_space_assign_loc_itf.loc_attribute7%TYPE;
140: v_attribute8 pn_space_assign_loc_itf.loc_attribute8%TYPE;
141: v_attribute9 pn_space_assign_loc_itf.loc_attribute9%TYPE;
142: v_attribute10 pn_space_assign_loc_itf.loc_attribute10%TYPE;
143: v_attribute11 pn_space_assign_loc_itf.loc_attribute11%TYPE;

Line 140: v_attribute8 pn_space_assign_loc_itf.loc_attribute8%TYPE;

136: v_attribute4 pn_space_assign_loc_itf.loc_attribute4%TYPE;
137: v_attribute5 pn_space_assign_loc_itf.loc_attribute5%TYPE;
138: v_attribute6 pn_space_assign_loc_itf.loc_attribute6%TYPE;
139: v_attribute7 pn_space_assign_loc_itf.loc_attribute7%TYPE;
140: v_attribute8 pn_space_assign_loc_itf.loc_attribute8%TYPE;
141: v_attribute9 pn_space_assign_loc_itf.loc_attribute9%TYPE;
142: v_attribute10 pn_space_assign_loc_itf.loc_attribute10%TYPE;
143: v_attribute11 pn_space_assign_loc_itf.loc_attribute11%TYPE;
144: v_attribute12 pn_space_assign_loc_itf.loc_attribute12%TYPE;

Line 141: v_attribute9 pn_space_assign_loc_itf.loc_attribute9%TYPE;

137: v_attribute5 pn_space_assign_loc_itf.loc_attribute5%TYPE;
138: v_attribute6 pn_space_assign_loc_itf.loc_attribute6%TYPE;
139: v_attribute7 pn_space_assign_loc_itf.loc_attribute7%TYPE;
140: v_attribute8 pn_space_assign_loc_itf.loc_attribute8%TYPE;
141: v_attribute9 pn_space_assign_loc_itf.loc_attribute9%TYPE;
142: v_attribute10 pn_space_assign_loc_itf.loc_attribute10%TYPE;
143: v_attribute11 pn_space_assign_loc_itf.loc_attribute11%TYPE;
144: v_attribute12 pn_space_assign_loc_itf.loc_attribute12%TYPE;
145: v_attribute13 pn_space_assign_loc_itf.loc_attribute13%TYPE;

Line 142: v_attribute10 pn_space_assign_loc_itf.loc_attribute10%TYPE;

138: v_attribute6 pn_space_assign_loc_itf.loc_attribute6%TYPE;
139: v_attribute7 pn_space_assign_loc_itf.loc_attribute7%TYPE;
140: v_attribute8 pn_space_assign_loc_itf.loc_attribute8%TYPE;
141: v_attribute9 pn_space_assign_loc_itf.loc_attribute9%TYPE;
142: v_attribute10 pn_space_assign_loc_itf.loc_attribute10%TYPE;
143: v_attribute11 pn_space_assign_loc_itf.loc_attribute11%TYPE;
144: v_attribute12 pn_space_assign_loc_itf.loc_attribute12%TYPE;
145: v_attribute13 pn_space_assign_loc_itf.loc_attribute13%TYPE;
146: v_attribute14 pn_space_assign_loc_itf.loc_attribute14%TYPE;

Line 143: v_attribute11 pn_space_assign_loc_itf.loc_attribute11%TYPE;

139: v_attribute7 pn_space_assign_loc_itf.loc_attribute7%TYPE;
140: v_attribute8 pn_space_assign_loc_itf.loc_attribute8%TYPE;
141: v_attribute9 pn_space_assign_loc_itf.loc_attribute9%TYPE;
142: v_attribute10 pn_space_assign_loc_itf.loc_attribute10%TYPE;
143: v_attribute11 pn_space_assign_loc_itf.loc_attribute11%TYPE;
144: v_attribute12 pn_space_assign_loc_itf.loc_attribute12%TYPE;
145: v_attribute13 pn_space_assign_loc_itf.loc_attribute13%TYPE;
146: v_attribute14 pn_space_assign_loc_itf.loc_attribute14%TYPE;
147: v_attribute15 pn_space_assign_loc_itf.loc_attribute15%TYPE;

Line 144: v_attribute12 pn_space_assign_loc_itf.loc_attribute12%TYPE;

140: v_attribute8 pn_space_assign_loc_itf.loc_attribute8%TYPE;
141: v_attribute9 pn_space_assign_loc_itf.loc_attribute9%TYPE;
142: v_attribute10 pn_space_assign_loc_itf.loc_attribute10%TYPE;
143: v_attribute11 pn_space_assign_loc_itf.loc_attribute11%TYPE;
144: v_attribute12 pn_space_assign_loc_itf.loc_attribute12%TYPE;
145: v_attribute13 pn_space_assign_loc_itf.loc_attribute13%TYPE;
146: v_attribute14 pn_space_assign_loc_itf.loc_attribute14%TYPE;
147: v_attribute15 pn_space_assign_loc_itf.loc_attribute15%TYPE;
148: v_last_update_date pn_space_assign_loc_itf.last_update_date%TYPE;

Line 145: v_attribute13 pn_space_assign_loc_itf.loc_attribute13%TYPE;

141: v_attribute9 pn_space_assign_loc_itf.loc_attribute9%TYPE;
142: v_attribute10 pn_space_assign_loc_itf.loc_attribute10%TYPE;
143: v_attribute11 pn_space_assign_loc_itf.loc_attribute11%TYPE;
144: v_attribute12 pn_space_assign_loc_itf.loc_attribute12%TYPE;
145: v_attribute13 pn_space_assign_loc_itf.loc_attribute13%TYPE;
146: v_attribute14 pn_space_assign_loc_itf.loc_attribute14%TYPE;
147: v_attribute15 pn_space_assign_loc_itf.loc_attribute15%TYPE;
148: v_last_update_date pn_space_assign_loc_itf.last_update_date%TYPE;
149: v_last_updated_by pn_space_assign_loc_itf.last_updated_by%TYPE;

Line 146: v_attribute14 pn_space_assign_loc_itf.loc_attribute14%TYPE;

142: v_attribute10 pn_space_assign_loc_itf.loc_attribute10%TYPE;
143: v_attribute11 pn_space_assign_loc_itf.loc_attribute11%TYPE;
144: v_attribute12 pn_space_assign_loc_itf.loc_attribute12%TYPE;
145: v_attribute13 pn_space_assign_loc_itf.loc_attribute13%TYPE;
146: v_attribute14 pn_space_assign_loc_itf.loc_attribute14%TYPE;
147: v_attribute15 pn_space_assign_loc_itf.loc_attribute15%TYPE;
148: v_last_update_date pn_space_assign_loc_itf.last_update_date%TYPE;
149: v_last_updated_by pn_space_assign_loc_itf.last_updated_by%TYPE;
150: v_last_update_login pn_space_assign_loc_itf.last_update_login%TYPE;

Line 147: v_attribute15 pn_space_assign_loc_itf.loc_attribute15%TYPE;

143: v_attribute11 pn_space_assign_loc_itf.loc_attribute11%TYPE;
144: v_attribute12 pn_space_assign_loc_itf.loc_attribute12%TYPE;
145: v_attribute13 pn_space_assign_loc_itf.loc_attribute13%TYPE;
146: v_attribute14 pn_space_assign_loc_itf.loc_attribute14%TYPE;
147: v_attribute15 pn_space_assign_loc_itf.loc_attribute15%TYPE;
148: v_last_update_date pn_space_assign_loc_itf.last_update_date%TYPE;
149: v_last_updated_by pn_space_assign_loc_itf.last_updated_by%TYPE;
150: v_last_update_login pn_space_assign_loc_itf.last_update_login%TYPE;
151: v_creation_date pn_space_assign_loc_itf.creation_date%TYPE;

Line 148: v_last_update_date pn_space_assign_loc_itf.last_update_date%TYPE;

144: v_attribute12 pn_space_assign_loc_itf.loc_attribute12%TYPE;
145: v_attribute13 pn_space_assign_loc_itf.loc_attribute13%TYPE;
146: v_attribute14 pn_space_assign_loc_itf.loc_attribute14%TYPE;
147: v_attribute15 pn_space_assign_loc_itf.loc_attribute15%TYPE;
148: v_last_update_date pn_space_assign_loc_itf.last_update_date%TYPE;
149: v_last_updated_by pn_space_assign_loc_itf.last_updated_by%TYPE;
150: v_last_update_login pn_space_assign_loc_itf.last_update_login%TYPE;
151: v_creation_date pn_space_assign_loc_itf.creation_date%TYPE;
152: v_created_by pn_space_assign_loc_itf.created_by%TYPE;

Line 149: v_last_updated_by pn_space_assign_loc_itf.last_updated_by%TYPE;

145: v_attribute13 pn_space_assign_loc_itf.loc_attribute13%TYPE;
146: v_attribute14 pn_space_assign_loc_itf.loc_attribute14%TYPE;
147: v_attribute15 pn_space_assign_loc_itf.loc_attribute15%TYPE;
148: v_last_update_date pn_space_assign_loc_itf.last_update_date%TYPE;
149: v_last_updated_by pn_space_assign_loc_itf.last_updated_by%TYPE;
150: v_last_update_login pn_space_assign_loc_itf.last_update_login%TYPE;
151: v_creation_date pn_space_assign_loc_itf.creation_date%TYPE;
152: v_created_by pn_space_assign_loc_itf.created_by%TYPE;
153:

Line 150: v_last_update_login pn_space_assign_loc_itf.last_update_login%TYPE;

146: v_attribute14 pn_space_assign_loc_itf.loc_attribute14%TYPE;
147: v_attribute15 pn_space_assign_loc_itf.loc_attribute15%TYPE;
148: v_last_update_date pn_space_assign_loc_itf.last_update_date%TYPE;
149: v_last_updated_by pn_space_assign_loc_itf.last_updated_by%TYPE;
150: v_last_update_login pn_space_assign_loc_itf.last_update_login%TYPE;
151: v_creation_date pn_space_assign_loc_itf.creation_date%TYPE;
152: v_created_by pn_space_assign_loc_itf.created_by%TYPE;
153:
154: --declare the record type for the function here.........

Line 151: v_creation_date pn_space_assign_loc_itf.creation_date%TYPE;

147: v_attribute15 pn_space_assign_loc_itf.loc_attribute15%TYPE;
148: v_last_update_date pn_space_assign_loc_itf.last_update_date%TYPE;
149: v_last_updated_by pn_space_assign_loc_itf.last_updated_by%TYPE;
150: v_last_update_login pn_space_assign_loc_itf.last_update_login%TYPE;
151: v_creation_date pn_space_assign_loc_itf.creation_date%TYPE;
152: v_created_by pn_space_assign_loc_itf.created_by%TYPE;
153:
154: --declare the record type for the function here.........
155: v_emp_data pnp_util_func.emp_hr_data_rec := NULL;

Line 152: v_created_by pn_space_assign_loc_itf.created_by%TYPE;

148: v_last_update_date pn_space_assign_loc_itf.last_update_date%TYPE;
149: v_last_updated_by pn_space_assign_loc_itf.last_updated_by%TYPE;
150: v_last_update_login pn_space_assign_loc_itf.last_update_login%TYPE;
151: v_creation_date pn_space_assign_loc_itf.creation_date%TYPE;
152: v_created_by pn_space_assign_loc_itf.created_by%TYPE;
153:
154: --declare the record type for the function here.........
155: v_emp_data pnp_util_func.emp_hr_data_rec := NULL;
156: v_code_data pnp_util_func.location_name_rec := NULL;

Line 445: INSERT INTO pn_space_assign_loc_itf

441: END IF;
442: -----------bug#2226865--------
443:
444:
445: INSERT INTO pn_space_assign_loc_itf
446: (location_id ,
447: location_type ,
448: location_name ,
449: location_code ,

Line 787: INSERT INTO pn_space_assign_loc_itf

783: END IF;
784: -----------bug#2226865--------
785:
786:
787: INSERT INTO pn_space_assign_loc_itf
788: (
789: location_id ,
790: location_type ,
791: location_name ,