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_LEASE dependencies on PN_SPACE_ASSIGN_LEASE_ITF

Line 15: FROM pn_space_assign_lease_itf

11: BEGIN
12:
13: SELECT 'X'
14: INTO v_var1
15: FROM pn_space_assign_lease_itf
16: WHERE location_id = P_LOCATION_ID
17: AND person_id(+) = P_PERSON_ID
18: AND cost_center = P_COST_CENTER
19: AND request_id = P_REQUEST_ID;

Line 41: FROM pn_space_assign_lease_itf

37: BEGIN
38:
39: SELECT 'Y'
40: INTO v_var2
41: FROM pn_space_assign_lease_itf
42: WHERE location_id = P_LOCATION_ID
43: AND customer_account = P_ACCOUNT_ID
44: AND request_id = P_REQUEST_ID;
45:

Line 93: V_LEASE_ID pn_space_assign_lease_itf.LEASE_ID%TYPE;

89: l_one NUMBER default 1;
90: l_two NUMBER default 2;
91: l_three NUMBER default 3;
92: --declare all columns as variables here
93: V_LEASE_ID pn_space_assign_lease_itf.LEASE_ID%TYPE;
94: V_LEASE_NAME pn_space_assign_lease_itf.LEASE_NAME%TYPE;
95: V_LEASE_NUMBER pn_space_assign_lease_itf.LEASE_NUMBER%TYPE;
96: V_LEASE_COM_DATE pn_space_assign_lease_itf.LEASE_COMMENCEMENT_DATE%TYPE;
97: V_LEASE_TERM_DATE pn_space_assign_lease_itf.LEASE_TERMINATION_DATE%TYPE;

Line 94: V_LEASE_NAME pn_space_assign_lease_itf.LEASE_NAME%TYPE;

90: l_two NUMBER default 2;
91: l_three NUMBER default 3;
92: --declare all columns as variables here
93: V_LEASE_ID pn_space_assign_lease_itf.LEASE_ID%TYPE;
94: V_LEASE_NAME pn_space_assign_lease_itf.LEASE_NAME%TYPE;
95: V_LEASE_NUMBER pn_space_assign_lease_itf.LEASE_NUMBER%TYPE;
96: V_LEASE_COM_DATE pn_space_assign_lease_itf.LEASE_COMMENCEMENT_DATE%TYPE;
97: V_LEASE_TERM_DATE pn_space_assign_lease_itf.LEASE_TERMINATION_DATE%TYPE;
98: V_LOCATION_ID pn_space_assign_lease_itf.LOCATION_ID%TYPE;

Line 95: V_LEASE_NUMBER pn_space_assign_lease_itf.LEASE_NUMBER%TYPE;

91: l_three NUMBER default 3;
92: --declare all columns as variables here
93: V_LEASE_ID pn_space_assign_lease_itf.LEASE_ID%TYPE;
94: V_LEASE_NAME pn_space_assign_lease_itf.LEASE_NAME%TYPE;
95: V_LEASE_NUMBER pn_space_assign_lease_itf.LEASE_NUMBER%TYPE;
96: V_LEASE_COM_DATE pn_space_assign_lease_itf.LEASE_COMMENCEMENT_DATE%TYPE;
97: V_LEASE_TERM_DATE pn_space_assign_lease_itf.LEASE_TERMINATION_DATE%TYPE;
98: V_LOCATION_ID pn_space_assign_lease_itf.LOCATION_ID%TYPE;
99: V_LOCATION_ID_1 pn_space_assign_lease_itf.LOCATION_ID%TYPE;

Line 96: V_LEASE_COM_DATE pn_space_assign_lease_itf.LEASE_COMMENCEMENT_DATE%TYPE;

92: --declare all columns as variables here
93: V_LEASE_ID pn_space_assign_lease_itf.LEASE_ID%TYPE;
94: V_LEASE_NAME pn_space_assign_lease_itf.LEASE_NAME%TYPE;
95: V_LEASE_NUMBER pn_space_assign_lease_itf.LEASE_NUMBER%TYPE;
96: V_LEASE_COM_DATE pn_space_assign_lease_itf.LEASE_COMMENCEMENT_DATE%TYPE;
97: V_LEASE_TERM_DATE pn_space_assign_lease_itf.LEASE_TERMINATION_DATE%TYPE;
98: V_LOCATION_ID pn_space_assign_lease_itf.LOCATION_ID%TYPE;
99: V_LOCATION_ID_1 pn_space_assign_lease_itf.LOCATION_ID%TYPE;
100: V_LOCATION_ID_2 pn_space_assign_lease_itf.LOCATION_ID%TYPE;

Line 97: V_LEASE_TERM_DATE pn_space_assign_lease_itf.LEASE_TERMINATION_DATE%TYPE;

93: V_LEASE_ID pn_space_assign_lease_itf.LEASE_ID%TYPE;
94: V_LEASE_NAME pn_space_assign_lease_itf.LEASE_NAME%TYPE;
95: V_LEASE_NUMBER pn_space_assign_lease_itf.LEASE_NUMBER%TYPE;
96: V_LEASE_COM_DATE pn_space_assign_lease_itf.LEASE_COMMENCEMENT_DATE%TYPE;
97: V_LEASE_TERM_DATE pn_space_assign_lease_itf.LEASE_TERMINATION_DATE%TYPE;
98: V_LOCATION_ID pn_space_assign_lease_itf.LOCATION_ID%TYPE;
99: V_LOCATION_ID_1 pn_space_assign_lease_itf.LOCATION_ID%TYPE;
100: V_LOCATION_ID_2 pn_space_assign_lease_itf.LOCATION_ID%TYPE;
101: V_LOCATION_TYPE pn_space_assign_lease_itf.LOCATION_TYPE%TYPE;

Line 98: V_LOCATION_ID pn_space_assign_lease_itf.LOCATION_ID%TYPE;

94: V_LEASE_NAME pn_space_assign_lease_itf.LEASE_NAME%TYPE;
95: V_LEASE_NUMBER pn_space_assign_lease_itf.LEASE_NUMBER%TYPE;
96: V_LEASE_COM_DATE pn_space_assign_lease_itf.LEASE_COMMENCEMENT_DATE%TYPE;
97: V_LEASE_TERM_DATE pn_space_assign_lease_itf.LEASE_TERMINATION_DATE%TYPE;
98: V_LOCATION_ID pn_space_assign_lease_itf.LOCATION_ID%TYPE;
99: V_LOCATION_ID_1 pn_space_assign_lease_itf.LOCATION_ID%TYPE;
100: V_LOCATION_ID_2 pn_space_assign_lease_itf.LOCATION_ID%TYPE;
101: V_LOCATION_TYPE pn_space_assign_lease_itf.LOCATION_TYPE%TYPE;
102: V_LOCATION_NAME pn_space_assign_lease_itf.LOCATION_NAME%TYPE;

Line 99: V_LOCATION_ID_1 pn_space_assign_lease_itf.LOCATION_ID%TYPE;

95: V_LEASE_NUMBER pn_space_assign_lease_itf.LEASE_NUMBER%TYPE;
96: V_LEASE_COM_DATE pn_space_assign_lease_itf.LEASE_COMMENCEMENT_DATE%TYPE;
97: V_LEASE_TERM_DATE pn_space_assign_lease_itf.LEASE_TERMINATION_DATE%TYPE;
98: V_LOCATION_ID pn_space_assign_lease_itf.LOCATION_ID%TYPE;
99: V_LOCATION_ID_1 pn_space_assign_lease_itf.LOCATION_ID%TYPE;
100: V_LOCATION_ID_2 pn_space_assign_lease_itf.LOCATION_ID%TYPE;
101: V_LOCATION_TYPE pn_space_assign_lease_itf.LOCATION_TYPE%TYPE;
102: V_LOCATION_NAME pn_space_assign_lease_itf.LOCATION_NAME%TYPE;
103: V_LOCATION_CODE pn_space_assign_lease_itf.LOCATION_CODE%TYPE;

Line 100: V_LOCATION_ID_2 pn_space_assign_lease_itf.LOCATION_ID%TYPE;

96: V_LEASE_COM_DATE pn_space_assign_lease_itf.LEASE_COMMENCEMENT_DATE%TYPE;
97: V_LEASE_TERM_DATE pn_space_assign_lease_itf.LEASE_TERMINATION_DATE%TYPE;
98: V_LOCATION_ID pn_space_assign_lease_itf.LOCATION_ID%TYPE;
99: V_LOCATION_ID_1 pn_space_assign_lease_itf.LOCATION_ID%TYPE;
100: V_LOCATION_ID_2 pn_space_assign_lease_itf.LOCATION_ID%TYPE;
101: V_LOCATION_TYPE pn_space_assign_lease_itf.LOCATION_TYPE%TYPE;
102: V_LOCATION_NAME pn_space_assign_lease_itf.LOCATION_NAME%TYPE;
103: V_LOCATION_CODE pn_space_assign_lease_itf.LOCATION_CODE%TYPE;
104: V_SPACE_TYPE pn_space_assign_lease_itf.SPACE_TYPE%TYPE;

Line 101: V_LOCATION_TYPE pn_space_assign_lease_itf.LOCATION_TYPE%TYPE;

97: V_LEASE_TERM_DATE pn_space_assign_lease_itf.LEASE_TERMINATION_DATE%TYPE;
98: V_LOCATION_ID pn_space_assign_lease_itf.LOCATION_ID%TYPE;
99: V_LOCATION_ID_1 pn_space_assign_lease_itf.LOCATION_ID%TYPE;
100: V_LOCATION_ID_2 pn_space_assign_lease_itf.LOCATION_ID%TYPE;
101: V_LOCATION_TYPE pn_space_assign_lease_itf.LOCATION_TYPE%TYPE;
102: V_LOCATION_NAME pn_space_assign_lease_itf.LOCATION_NAME%TYPE;
103: V_LOCATION_CODE pn_space_assign_lease_itf.LOCATION_CODE%TYPE;
104: V_SPACE_TYPE pn_space_assign_lease_itf.SPACE_TYPE%TYPE;
105: V_PROPERTY_CODE pn_space_assign_lease_itf.PROPERTY_CODE%TYPE;

Line 102: V_LOCATION_NAME pn_space_assign_lease_itf.LOCATION_NAME%TYPE;

98: V_LOCATION_ID pn_space_assign_lease_itf.LOCATION_ID%TYPE;
99: V_LOCATION_ID_1 pn_space_assign_lease_itf.LOCATION_ID%TYPE;
100: V_LOCATION_ID_2 pn_space_assign_lease_itf.LOCATION_ID%TYPE;
101: V_LOCATION_TYPE pn_space_assign_lease_itf.LOCATION_TYPE%TYPE;
102: V_LOCATION_NAME pn_space_assign_lease_itf.LOCATION_NAME%TYPE;
103: V_LOCATION_CODE pn_space_assign_lease_itf.LOCATION_CODE%TYPE;
104: V_SPACE_TYPE pn_space_assign_lease_itf.SPACE_TYPE%TYPE;
105: V_PROPERTY_CODE pn_space_assign_lease_itf.PROPERTY_CODE%TYPE;
106: V_PERSON_ID pn_space_assign_lease_itf.PERSON_ID%TYPE;

Line 103: V_LOCATION_CODE pn_space_assign_lease_itf.LOCATION_CODE%TYPE;

99: V_LOCATION_ID_1 pn_space_assign_lease_itf.LOCATION_ID%TYPE;
100: V_LOCATION_ID_2 pn_space_assign_lease_itf.LOCATION_ID%TYPE;
101: V_LOCATION_TYPE pn_space_assign_lease_itf.LOCATION_TYPE%TYPE;
102: V_LOCATION_NAME pn_space_assign_lease_itf.LOCATION_NAME%TYPE;
103: V_LOCATION_CODE pn_space_assign_lease_itf.LOCATION_CODE%TYPE;
104: V_SPACE_TYPE pn_space_assign_lease_itf.SPACE_TYPE%TYPE;
105: V_PROPERTY_CODE pn_space_assign_lease_itf.PROPERTY_CODE%TYPE;
106: V_PERSON_ID pn_space_assign_lease_itf.PERSON_ID%TYPE;
107: V_COST_CENTER pn_space_assign_lease_itf.COST_CENTER%TYPE;

Line 104: V_SPACE_TYPE pn_space_assign_lease_itf.SPACE_TYPE%TYPE;

100: V_LOCATION_ID_2 pn_space_assign_lease_itf.LOCATION_ID%TYPE;
101: V_LOCATION_TYPE pn_space_assign_lease_itf.LOCATION_TYPE%TYPE;
102: V_LOCATION_NAME pn_space_assign_lease_itf.LOCATION_NAME%TYPE;
103: V_LOCATION_CODE pn_space_assign_lease_itf.LOCATION_CODE%TYPE;
104: V_SPACE_TYPE pn_space_assign_lease_itf.SPACE_TYPE%TYPE;
105: V_PROPERTY_CODE pn_space_assign_lease_itf.PROPERTY_CODE%TYPE;
106: V_PERSON_ID pn_space_assign_lease_itf.PERSON_ID%TYPE;
107: V_COST_CENTER pn_space_assign_lease_itf.COST_CENTER%TYPE;
108: V_EMPLOYEE_PROJECT_NUMBER pn_space_assign_lease_itf.EMPLOYEE_PROJECT_NUMBER%TYPE;

Line 105: V_PROPERTY_CODE pn_space_assign_lease_itf.PROPERTY_CODE%TYPE;

101: V_LOCATION_TYPE pn_space_assign_lease_itf.LOCATION_TYPE%TYPE;
102: V_LOCATION_NAME pn_space_assign_lease_itf.LOCATION_NAME%TYPE;
103: V_LOCATION_CODE pn_space_assign_lease_itf.LOCATION_CODE%TYPE;
104: V_SPACE_TYPE pn_space_assign_lease_itf.SPACE_TYPE%TYPE;
105: V_PROPERTY_CODE pn_space_assign_lease_itf.PROPERTY_CODE%TYPE;
106: V_PERSON_ID pn_space_assign_lease_itf.PERSON_ID%TYPE;
107: V_COST_CENTER pn_space_assign_lease_itf.COST_CENTER%TYPE;
108: V_EMPLOYEE_PROJECT_NUMBER pn_space_assign_lease_itf.EMPLOYEE_PROJECT_NUMBER%TYPE;
109: V_EMPLOYEE_TASK_NUMBER pn_space_assign_lease_itf.EMPLOYEE_TASK_NUMBER%TYPE;

Line 106: V_PERSON_ID pn_space_assign_lease_itf.PERSON_ID%TYPE;

102: V_LOCATION_NAME pn_space_assign_lease_itf.LOCATION_NAME%TYPE;
103: V_LOCATION_CODE pn_space_assign_lease_itf.LOCATION_CODE%TYPE;
104: V_SPACE_TYPE pn_space_assign_lease_itf.SPACE_TYPE%TYPE;
105: V_PROPERTY_CODE pn_space_assign_lease_itf.PROPERTY_CODE%TYPE;
106: V_PERSON_ID pn_space_assign_lease_itf.PERSON_ID%TYPE;
107: V_COST_CENTER pn_space_assign_lease_itf.COST_CENTER%TYPE;
108: V_EMPLOYEE_PROJECT_NUMBER pn_space_assign_lease_itf.EMPLOYEE_PROJECT_NUMBER%TYPE;
109: V_EMPLOYEE_TASK_NUMBER pn_space_assign_lease_itf.EMPLOYEE_TASK_NUMBER%TYPE;
110: V_EMPLOYEE_ASSIGNED_FROM pn_space_assign_lease_itf.EMPLOYEE_ASSIGNED_FROM%TYPE;

Line 107: V_COST_CENTER pn_space_assign_lease_itf.COST_CENTER%TYPE;

103: V_LOCATION_CODE pn_space_assign_lease_itf.LOCATION_CODE%TYPE;
104: V_SPACE_TYPE pn_space_assign_lease_itf.SPACE_TYPE%TYPE;
105: V_PROPERTY_CODE pn_space_assign_lease_itf.PROPERTY_CODE%TYPE;
106: V_PERSON_ID pn_space_assign_lease_itf.PERSON_ID%TYPE;
107: V_COST_CENTER pn_space_assign_lease_itf.COST_CENTER%TYPE;
108: V_EMPLOYEE_PROJECT_NUMBER pn_space_assign_lease_itf.EMPLOYEE_PROJECT_NUMBER%TYPE;
109: V_EMPLOYEE_TASK_NUMBER pn_space_assign_lease_itf.EMPLOYEE_TASK_NUMBER%TYPE;
110: V_EMPLOYEE_ASSIGNED_FROM pn_space_assign_lease_itf.EMPLOYEE_ASSIGNED_FROM%TYPE;
111: V_EMPLOYEE_ASSIGNED_TO pn_space_assign_lease_itf.EMPLOYEE_ASSIGNED_TO%TYPE;

Line 108: V_EMPLOYEE_PROJECT_NUMBER pn_space_assign_lease_itf.EMPLOYEE_PROJECT_NUMBER%TYPE;

104: V_SPACE_TYPE pn_space_assign_lease_itf.SPACE_TYPE%TYPE;
105: V_PROPERTY_CODE pn_space_assign_lease_itf.PROPERTY_CODE%TYPE;
106: V_PERSON_ID pn_space_assign_lease_itf.PERSON_ID%TYPE;
107: V_COST_CENTER pn_space_assign_lease_itf.COST_CENTER%TYPE;
108: V_EMPLOYEE_PROJECT_NUMBER pn_space_assign_lease_itf.EMPLOYEE_PROJECT_NUMBER%TYPE;
109: V_EMPLOYEE_TASK_NUMBER pn_space_assign_lease_itf.EMPLOYEE_TASK_NUMBER%TYPE;
110: V_EMPLOYEE_ASSIGNED_FROM pn_space_assign_lease_itf.EMPLOYEE_ASSIGNED_FROM%TYPE;
111: V_EMPLOYEE_ASSIGNED_TO pn_space_assign_lease_itf.EMPLOYEE_ASSIGNED_TO%TYPE;
112: V_CUSTOMER_ACCOUNT pn_space_assign_lease_itf.CUSTOMER_ACCOUNT%TYPE;

Line 109: V_EMPLOYEE_TASK_NUMBER pn_space_assign_lease_itf.EMPLOYEE_TASK_NUMBER%TYPE;

105: V_PROPERTY_CODE pn_space_assign_lease_itf.PROPERTY_CODE%TYPE;
106: V_PERSON_ID pn_space_assign_lease_itf.PERSON_ID%TYPE;
107: V_COST_CENTER pn_space_assign_lease_itf.COST_CENTER%TYPE;
108: V_EMPLOYEE_PROJECT_NUMBER pn_space_assign_lease_itf.EMPLOYEE_PROJECT_NUMBER%TYPE;
109: V_EMPLOYEE_TASK_NUMBER pn_space_assign_lease_itf.EMPLOYEE_TASK_NUMBER%TYPE;
110: V_EMPLOYEE_ASSIGNED_FROM pn_space_assign_lease_itf.EMPLOYEE_ASSIGNED_FROM%TYPE;
111: V_EMPLOYEE_ASSIGNED_TO pn_space_assign_lease_itf.EMPLOYEE_ASSIGNED_TO%TYPE;
112: V_CUSTOMER_ACCOUNT pn_space_assign_lease_itf.CUSTOMER_ACCOUNT%TYPE;
113: V_EXP_ACCOUNT NUMBER;

Line 110: V_EMPLOYEE_ASSIGNED_FROM pn_space_assign_lease_itf.EMPLOYEE_ASSIGNED_FROM%TYPE;

106: V_PERSON_ID pn_space_assign_lease_itf.PERSON_ID%TYPE;
107: V_COST_CENTER pn_space_assign_lease_itf.COST_CENTER%TYPE;
108: V_EMPLOYEE_PROJECT_NUMBER pn_space_assign_lease_itf.EMPLOYEE_PROJECT_NUMBER%TYPE;
109: V_EMPLOYEE_TASK_NUMBER pn_space_assign_lease_itf.EMPLOYEE_TASK_NUMBER%TYPE;
110: V_EMPLOYEE_ASSIGNED_FROM pn_space_assign_lease_itf.EMPLOYEE_ASSIGNED_FROM%TYPE;
111: V_EMPLOYEE_ASSIGNED_TO pn_space_assign_lease_itf.EMPLOYEE_ASSIGNED_TO%TYPE;
112: V_CUSTOMER_ACCOUNT pn_space_assign_lease_itf.CUSTOMER_ACCOUNT%TYPE;
113: V_EXP_ACCOUNT NUMBER;
114: V_CUSTOMER_ACCOUNT_ID NUMBER;

Line 111: V_EMPLOYEE_ASSIGNED_TO pn_space_assign_lease_itf.EMPLOYEE_ASSIGNED_TO%TYPE;

107: V_COST_CENTER pn_space_assign_lease_itf.COST_CENTER%TYPE;
108: V_EMPLOYEE_PROJECT_NUMBER pn_space_assign_lease_itf.EMPLOYEE_PROJECT_NUMBER%TYPE;
109: V_EMPLOYEE_TASK_NUMBER pn_space_assign_lease_itf.EMPLOYEE_TASK_NUMBER%TYPE;
110: V_EMPLOYEE_ASSIGNED_FROM pn_space_assign_lease_itf.EMPLOYEE_ASSIGNED_FROM%TYPE;
111: V_EMPLOYEE_ASSIGNED_TO pn_space_assign_lease_itf.EMPLOYEE_ASSIGNED_TO%TYPE;
112: V_CUSTOMER_ACCOUNT pn_space_assign_lease_itf.CUSTOMER_ACCOUNT%TYPE;
113: V_EXP_ACCOUNT NUMBER;
114: V_CUSTOMER_ACCOUNT_ID NUMBER;
115: V_CUSTOMER_PROJECT_NUMBER pn_space_assign_lease_itf.CUSTOMER_PROJECT_NUMBER%TYPE;

Line 112: V_CUSTOMER_ACCOUNT pn_space_assign_lease_itf.CUSTOMER_ACCOUNT%TYPE;

108: V_EMPLOYEE_PROJECT_NUMBER pn_space_assign_lease_itf.EMPLOYEE_PROJECT_NUMBER%TYPE;
109: V_EMPLOYEE_TASK_NUMBER pn_space_assign_lease_itf.EMPLOYEE_TASK_NUMBER%TYPE;
110: V_EMPLOYEE_ASSIGNED_FROM pn_space_assign_lease_itf.EMPLOYEE_ASSIGNED_FROM%TYPE;
111: V_EMPLOYEE_ASSIGNED_TO pn_space_assign_lease_itf.EMPLOYEE_ASSIGNED_TO%TYPE;
112: V_CUSTOMER_ACCOUNT pn_space_assign_lease_itf.CUSTOMER_ACCOUNT%TYPE;
113: V_EXP_ACCOUNT NUMBER;
114: V_CUSTOMER_ACCOUNT_ID NUMBER;
115: V_CUSTOMER_PROJECT_NUMBER pn_space_assign_lease_itf.CUSTOMER_PROJECT_NUMBER%TYPE;
116: V_CUSTOMER_TASK_NUMBER pn_space_assign_lease_itf.CUSTOMER_TASK_NUMBER%TYPE;

Line 115: V_CUSTOMER_PROJECT_NUMBER pn_space_assign_lease_itf.CUSTOMER_PROJECT_NUMBER%TYPE;

111: V_EMPLOYEE_ASSIGNED_TO pn_space_assign_lease_itf.EMPLOYEE_ASSIGNED_TO%TYPE;
112: V_CUSTOMER_ACCOUNT pn_space_assign_lease_itf.CUSTOMER_ACCOUNT%TYPE;
113: V_EXP_ACCOUNT NUMBER;
114: V_CUSTOMER_ACCOUNT_ID NUMBER;
115: V_CUSTOMER_PROJECT_NUMBER pn_space_assign_lease_itf.CUSTOMER_PROJECT_NUMBER%TYPE;
116: V_CUSTOMER_TASK_NUMBER pn_space_assign_lease_itf.CUSTOMER_TASK_NUMBER%TYPE;
117: V_CUSTOMER_ASSIGNED_FROM pn_space_assign_lease_itf.CUSTOMER_ASSIGNED_FROM%TYPE;
118: V_CUSTOMER_ASSIGNED_TO pn_space_assign_lease_itf.CUSTOMER_ASSIGNED_TO%TYPE;
119: V_CUSTOMER_NAME pn_space_assign_lease_itf.CUSTOMER_NAME%TYPE;

Line 116: V_CUSTOMER_TASK_NUMBER pn_space_assign_lease_itf.CUSTOMER_TASK_NUMBER%TYPE;

112: V_CUSTOMER_ACCOUNT pn_space_assign_lease_itf.CUSTOMER_ACCOUNT%TYPE;
113: V_EXP_ACCOUNT NUMBER;
114: V_CUSTOMER_ACCOUNT_ID NUMBER;
115: V_CUSTOMER_PROJECT_NUMBER pn_space_assign_lease_itf.CUSTOMER_PROJECT_NUMBER%TYPE;
116: V_CUSTOMER_TASK_NUMBER pn_space_assign_lease_itf.CUSTOMER_TASK_NUMBER%TYPE;
117: V_CUSTOMER_ASSIGNED_FROM pn_space_assign_lease_itf.CUSTOMER_ASSIGNED_FROM%TYPE;
118: V_CUSTOMER_ASSIGNED_TO pn_space_assign_lease_itf.CUSTOMER_ASSIGNED_TO%TYPE;
119: V_CUSTOMER_NAME pn_space_assign_lease_itf.CUSTOMER_NAME%TYPE;
120: V_CUSTOMER_SITE pn_space_assign_lease_itf.CUSTOMER_SITE%TYPE;

Line 117: V_CUSTOMER_ASSIGNED_FROM pn_space_assign_lease_itf.CUSTOMER_ASSIGNED_FROM%TYPE;

113: V_EXP_ACCOUNT NUMBER;
114: V_CUSTOMER_ACCOUNT_ID NUMBER;
115: V_CUSTOMER_PROJECT_NUMBER pn_space_assign_lease_itf.CUSTOMER_PROJECT_NUMBER%TYPE;
116: V_CUSTOMER_TASK_NUMBER pn_space_assign_lease_itf.CUSTOMER_TASK_NUMBER%TYPE;
117: V_CUSTOMER_ASSIGNED_FROM pn_space_assign_lease_itf.CUSTOMER_ASSIGNED_FROM%TYPE;
118: V_CUSTOMER_ASSIGNED_TO pn_space_assign_lease_itf.CUSTOMER_ASSIGNED_TO%TYPE;
119: V_CUSTOMER_NAME pn_space_assign_lease_itf.CUSTOMER_NAME%TYPE;
120: V_CUSTOMER_SITE pn_space_assign_lease_itf.CUSTOMER_SITE%TYPE;
121: V_CUSTOMER_CATEGORY pn_space_assign_lease_itf.CUSTOMER_CATEGORY%TYPE;

Line 118: V_CUSTOMER_ASSIGNED_TO pn_space_assign_lease_itf.CUSTOMER_ASSIGNED_TO%TYPE;

114: V_CUSTOMER_ACCOUNT_ID NUMBER;
115: V_CUSTOMER_PROJECT_NUMBER pn_space_assign_lease_itf.CUSTOMER_PROJECT_NUMBER%TYPE;
116: V_CUSTOMER_TASK_NUMBER pn_space_assign_lease_itf.CUSTOMER_TASK_NUMBER%TYPE;
117: V_CUSTOMER_ASSIGNED_FROM pn_space_assign_lease_itf.CUSTOMER_ASSIGNED_FROM%TYPE;
118: V_CUSTOMER_ASSIGNED_TO pn_space_assign_lease_itf.CUSTOMER_ASSIGNED_TO%TYPE;
119: V_CUSTOMER_NAME pn_space_assign_lease_itf.CUSTOMER_NAME%TYPE;
120: V_CUSTOMER_SITE pn_space_assign_lease_itf.CUSTOMER_SITE%TYPE;
121: V_CUSTOMER_CATEGORY pn_space_assign_lease_itf.CUSTOMER_CATEGORY%TYPE;
122: V_RENTABLE_AREA pn_space_assign_lease_itf.RENTABLE_AREA%TYPE;

Line 119: V_CUSTOMER_NAME pn_space_assign_lease_itf.CUSTOMER_NAME%TYPE;

115: V_CUSTOMER_PROJECT_NUMBER pn_space_assign_lease_itf.CUSTOMER_PROJECT_NUMBER%TYPE;
116: V_CUSTOMER_TASK_NUMBER pn_space_assign_lease_itf.CUSTOMER_TASK_NUMBER%TYPE;
117: V_CUSTOMER_ASSIGNED_FROM pn_space_assign_lease_itf.CUSTOMER_ASSIGNED_FROM%TYPE;
118: V_CUSTOMER_ASSIGNED_TO pn_space_assign_lease_itf.CUSTOMER_ASSIGNED_TO%TYPE;
119: V_CUSTOMER_NAME pn_space_assign_lease_itf.CUSTOMER_NAME%TYPE;
120: V_CUSTOMER_SITE pn_space_assign_lease_itf.CUSTOMER_SITE%TYPE;
121: V_CUSTOMER_CATEGORY pn_space_assign_lease_itf.CUSTOMER_CATEGORY%TYPE;
122: V_RENTABLE_AREA pn_space_assign_lease_itf.RENTABLE_AREA%TYPE;
123: V_USABLE_AREA pn_space_assign_lease_itf.USABLE_AREA%TYPE;

Line 120: V_CUSTOMER_SITE pn_space_assign_lease_itf.CUSTOMER_SITE%TYPE;

116: V_CUSTOMER_TASK_NUMBER pn_space_assign_lease_itf.CUSTOMER_TASK_NUMBER%TYPE;
117: V_CUSTOMER_ASSIGNED_FROM pn_space_assign_lease_itf.CUSTOMER_ASSIGNED_FROM%TYPE;
118: V_CUSTOMER_ASSIGNED_TO pn_space_assign_lease_itf.CUSTOMER_ASSIGNED_TO%TYPE;
119: V_CUSTOMER_NAME pn_space_assign_lease_itf.CUSTOMER_NAME%TYPE;
120: V_CUSTOMER_SITE pn_space_assign_lease_itf.CUSTOMER_SITE%TYPE;
121: V_CUSTOMER_CATEGORY pn_space_assign_lease_itf.CUSTOMER_CATEGORY%TYPE;
122: V_RENTABLE_AREA pn_space_assign_lease_itf.RENTABLE_AREA%TYPE;
123: V_USABLE_AREA pn_space_assign_lease_itf.USABLE_AREA%TYPE;
124: V_ASSIGNABLE_AREA pn_space_assign_lease_itf.ASSIGNABLE_AREA%TYPE;

Line 121: V_CUSTOMER_CATEGORY pn_space_assign_lease_itf.CUSTOMER_CATEGORY%TYPE;

117: V_CUSTOMER_ASSIGNED_FROM pn_space_assign_lease_itf.CUSTOMER_ASSIGNED_FROM%TYPE;
118: V_CUSTOMER_ASSIGNED_TO pn_space_assign_lease_itf.CUSTOMER_ASSIGNED_TO%TYPE;
119: V_CUSTOMER_NAME pn_space_assign_lease_itf.CUSTOMER_NAME%TYPE;
120: V_CUSTOMER_SITE pn_space_assign_lease_itf.CUSTOMER_SITE%TYPE;
121: V_CUSTOMER_CATEGORY pn_space_assign_lease_itf.CUSTOMER_CATEGORY%TYPE;
122: V_RENTABLE_AREA pn_space_assign_lease_itf.RENTABLE_AREA%TYPE;
123: V_USABLE_AREA pn_space_assign_lease_itf.USABLE_AREA%TYPE;
124: V_ASSIGNABLE_AREA pn_space_assign_lease_itf.ASSIGNABLE_AREA%TYPE;
125: V_COMMON_AREA pn_space_assign_lease_itf.COMMON_AREA%TYPE;

Line 122: V_RENTABLE_AREA pn_space_assign_lease_itf.RENTABLE_AREA%TYPE;

118: V_CUSTOMER_ASSIGNED_TO pn_space_assign_lease_itf.CUSTOMER_ASSIGNED_TO%TYPE;
119: V_CUSTOMER_NAME pn_space_assign_lease_itf.CUSTOMER_NAME%TYPE;
120: V_CUSTOMER_SITE pn_space_assign_lease_itf.CUSTOMER_SITE%TYPE;
121: V_CUSTOMER_CATEGORY pn_space_assign_lease_itf.CUSTOMER_CATEGORY%TYPE;
122: V_RENTABLE_AREA pn_space_assign_lease_itf.RENTABLE_AREA%TYPE;
123: V_USABLE_AREA pn_space_assign_lease_itf.USABLE_AREA%TYPE;
124: V_ASSIGNABLE_AREA pn_space_assign_lease_itf.ASSIGNABLE_AREA%TYPE;
125: V_COMMON_AREA pn_space_assign_lease_itf.COMMON_AREA%TYPE;
126: V_EMPLOYEE_ASSIGNED_AREA pn_space_assign_lease_itf.EMPLOYEE_ASSIGNED_AREA%TYPE;

Line 123: V_USABLE_AREA pn_space_assign_lease_itf.USABLE_AREA%TYPE;

119: V_CUSTOMER_NAME pn_space_assign_lease_itf.CUSTOMER_NAME%TYPE;
120: V_CUSTOMER_SITE pn_space_assign_lease_itf.CUSTOMER_SITE%TYPE;
121: V_CUSTOMER_CATEGORY pn_space_assign_lease_itf.CUSTOMER_CATEGORY%TYPE;
122: V_RENTABLE_AREA pn_space_assign_lease_itf.RENTABLE_AREA%TYPE;
123: V_USABLE_AREA pn_space_assign_lease_itf.USABLE_AREA%TYPE;
124: V_ASSIGNABLE_AREA pn_space_assign_lease_itf.ASSIGNABLE_AREA%TYPE;
125: V_COMMON_AREA pn_space_assign_lease_itf.COMMON_AREA%TYPE;
126: V_EMPLOYEE_ASSIGNED_AREA pn_space_assign_lease_itf.EMPLOYEE_ASSIGNED_AREA%TYPE;
127: V_CUSTOMER_ASSIGNED_AREA pn_space_assign_lease_itf.CUSTOMER_ASSIGNED_AREA%TYPE;

Line 124: V_ASSIGNABLE_AREA pn_space_assign_lease_itf.ASSIGNABLE_AREA%TYPE;

120: V_CUSTOMER_SITE pn_space_assign_lease_itf.CUSTOMER_SITE%TYPE;
121: V_CUSTOMER_CATEGORY pn_space_assign_lease_itf.CUSTOMER_CATEGORY%TYPE;
122: V_RENTABLE_AREA pn_space_assign_lease_itf.RENTABLE_AREA%TYPE;
123: V_USABLE_AREA pn_space_assign_lease_itf.USABLE_AREA%TYPE;
124: V_ASSIGNABLE_AREA pn_space_assign_lease_itf.ASSIGNABLE_AREA%TYPE;
125: V_COMMON_AREA pn_space_assign_lease_itf.COMMON_AREA%TYPE;
126: V_EMPLOYEE_ASSIGNED_AREA pn_space_assign_lease_itf.EMPLOYEE_ASSIGNED_AREA%TYPE;
127: V_CUSTOMER_ASSIGNED_AREA pn_space_assign_lease_itf.CUSTOMER_ASSIGNED_AREA%TYPE;
128: V_VACANT_AREA NUMBER;

Line 125: V_COMMON_AREA pn_space_assign_lease_itf.COMMON_AREA%TYPE;

121: V_CUSTOMER_CATEGORY pn_space_assign_lease_itf.CUSTOMER_CATEGORY%TYPE;
122: V_RENTABLE_AREA pn_space_assign_lease_itf.RENTABLE_AREA%TYPE;
123: V_USABLE_AREA pn_space_assign_lease_itf.USABLE_AREA%TYPE;
124: V_ASSIGNABLE_AREA pn_space_assign_lease_itf.ASSIGNABLE_AREA%TYPE;
125: V_COMMON_AREA pn_space_assign_lease_itf.COMMON_AREA%TYPE;
126: V_EMPLOYEE_ASSIGNED_AREA pn_space_assign_lease_itf.EMPLOYEE_ASSIGNED_AREA%TYPE;
127: V_CUSTOMER_ASSIGNED_AREA pn_space_assign_lease_itf.CUSTOMER_ASSIGNED_AREA%TYPE;
128: V_VACANT_AREA NUMBER;
129: V_ATTRIBUTE_CATEGORY pn_space_assign_lease_itf.TEN_ATTRIBUTE_CATEGORY%TYPE;

Line 126: V_EMPLOYEE_ASSIGNED_AREA pn_space_assign_lease_itf.EMPLOYEE_ASSIGNED_AREA%TYPE;

122: V_RENTABLE_AREA pn_space_assign_lease_itf.RENTABLE_AREA%TYPE;
123: V_USABLE_AREA pn_space_assign_lease_itf.USABLE_AREA%TYPE;
124: V_ASSIGNABLE_AREA pn_space_assign_lease_itf.ASSIGNABLE_AREA%TYPE;
125: V_COMMON_AREA pn_space_assign_lease_itf.COMMON_AREA%TYPE;
126: V_EMPLOYEE_ASSIGNED_AREA pn_space_assign_lease_itf.EMPLOYEE_ASSIGNED_AREA%TYPE;
127: V_CUSTOMER_ASSIGNED_AREA pn_space_assign_lease_itf.CUSTOMER_ASSIGNED_AREA%TYPE;
128: V_VACANT_AREA NUMBER;
129: V_ATTRIBUTE_CATEGORY pn_space_assign_lease_itf.TEN_ATTRIBUTE_CATEGORY%TYPE;
130: V_ATTRIBUTE1 pn_space_assign_lease_itf.TEN_ATTRIBUTE1%TYPE;

Line 127: V_CUSTOMER_ASSIGNED_AREA pn_space_assign_lease_itf.CUSTOMER_ASSIGNED_AREA%TYPE;

123: V_USABLE_AREA pn_space_assign_lease_itf.USABLE_AREA%TYPE;
124: V_ASSIGNABLE_AREA pn_space_assign_lease_itf.ASSIGNABLE_AREA%TYPE;
125: V_COMMON_AREA pn_space_assign_lease_itf.COMMON_AREA%TYPE;
126: V_EMPLOYEE_ASSIGNED_AREA pn_space_assign_lease_itf.EMPLOYEE_ASSIGNED_AREA%TYPE;
127: V_CUSTOMER_ASSIGNED_AREA pn_space_assign_lease_itf.CUSTOMER_ASSIGNED_AREA%TYPE;
128: V_VACANT_AREA NUMBER;
129: V_ATTRIBUTE_CATEGORY pn_space_assign_lease_itf.TEN_ATTRIBUTE_CATEGORY%TYPE;
130: V_ATTRIBUTE1 pn_space_assign_lease_itf.TEN_ATTRIBUTE1%TYPE;
131: V_ATTRIBUTE2 pn_space_assign_lease_itf.TEN_ATTRIBUTE2%TYPE;

Line 129: V_ATTRIBUTE_CATEGORY pn_space_assign_lease_itf.TEN_ATTRIBUTE_CATEGORY%TYPE;

125: V_COMMON_AREA pn_space_assign_lease_itf.COMMON_AREA%TYPE;
126: V_EMPLOYEE_ASSIGNED_AREA pn_space_assign_lease_itf.EMPLOYEE_ASSIGNED_AREA%TYPE;
127: V_CUSTOMER_ASSIGNED_AREA pn_space_assign_lease_itf.CUSTOMER_ASSIGNED_AREA%TYPE;
128: V_VACANT_AREA NUMBER;
129: V_ATTRIBUTE_CATEGORY pn_space_assign_lease_itf.TEN_ATTRIBUTE_CATEGORY%TYPE;
130: V_ATTRIBUTE1 pn_space_assign_lease_itf.TEN_ATTRIBUTE1%TYPE;
131: V_ATTRIBUTE2 pn_space_assign_lease_itf.TEN_ATTRIBUTE2%TYPE;
132: V_ATTRIBUTE3 pn_space_assign_lease_itf.TEN_ATTRIBUTE3%TYPE;
133: V_ATTRIBUTE4 pn_space_assign_lease_itf.TEN_ATTRIBUTE4%TYPE;

Line 130: V_ATTRIBUTE1 pn_space_assign_lease_itf.TEN_ATTRIBUTE1%TYPE;

126: V_EMPLOYEE_ASSIGNED_AREA pn_space_assign_lease_itf.EMPLOYEE_ASSIGNED_AREA%TYPE;
127: V_CUSTOMER_ASSIGNED_AREA pn_space_assign_lease_itf.CUSTOMER_ASSIGNED_AREA%TYPE;
128: V_VACANT_AREA NUMBER;
129: V_ATTRIBUTE_CATEGORY pn_space_assign_lease_itf.TEN_ATTRIBUTE_CATEGORY%TYPE;
130: V_ATTRIBUTE1 pn_space_assign_lease_itf.TEN_ATTRIBUTE1%TYPE;
131: V_ATTRIBUTE2 pn_space_assign_lease_itf.TEN_ATTRIBUTE2%TYPE;
132: V_ATTRIBUTE3 pn_space_assign_lease_itf.TEN_ATTRIBUTE3%TYPE;
133: V_ATTRIBUTE4 pn_space_assign_lease_itf.TEN_ATTRIBUTE4%TYPE;
134: V_ATTRIBUTE5 pn_space_assign_lease_itf.TEN_ATTRIBUTE5%TYPE;

Line 131: V_ATTRIBUTE2 pn_space_assign_lease_itf.TEN_ATTRIBUTE2%TYPE;

127: V_CUSTOMER_ASSIGNED_AREA pn_space_assign_lease_itf.CUSTOMER_ASSIGNED_AREA%TYPE;
128: V_VACANT_AREA NUMBER;
129: V_ATTRIBUTE_CATEGORY pn_space_assign_lease_itf.TEN_ATTRIBUTE_CATEGORY%TYPE;
130: V_ATTRIBUTE1 pn_space_assign_lease_itf.TEN_ATTRIBUTE1%TYPE;
131: V_ATTRIBUTE2 pn_space_assign_lease_itf.TEN_ATTRIBUTE2%TYPE;
132: V_ATTRIBUTE3 pn_space_assign_lease_itf.TEN_ATTRIBUTE3%TYPE;
133: V_ATTRIBUTE4 pn_space_assign_lease_itf.TEN_ATTRIBUTE4%TYPE;
134: V_ATTRIBUTE5 pn_space_assign_lease_itf.TEN_ATTRIBUTE5%TYPE;
135: V_ATTRIBUTE6 pn_space_assign_lease_itf.TEN_ATTRIBUTE6%TYPE;

Line 132: V_ATTRIBUTE3 pn_space_assign_lease_itf.TEN_ATTRIBUTE3%TYPE;

128: V_VACANT_AREA NUMBER;
129: V_ATTRIBUTE_CATEGORY pn_space_assign_lease_itf.TEN_ATTRIBUTE_CATEGORY%TYPE;
130: V_ATTRIBUTE1 pn_space_assign_lease_itf.TEN_ATTRIBUTE1%TYPE;
131: V_ATTRIBUTE2 pn_space_assign_lease_itf.TEN_ATTRIBUTE2%TYPE;
132: V_ATTRIBUTE3 pn_space_assign_lease_itf.TEN_ATTRIBUTE3%TYPE;
133: V_ATTRIBUTE4 pn_space_assign_lease_itf.TEN_ATTRIBUTE4%TYPE;
134: V_ATTRIBUTE5 pn_space_assign_lease_itf.TEN_ATTRIBUTE5%TYPE;
135: V_ATTRIBUTE6 pn_space_assign_lease_itf.TEN_ATTRIBUTE6%TYPE;
136: V_ATTRIBUTE7 pn_space_assign_lease_itf.TEN_ATTRIBUTE7%TYPE;

Line 133: V_ATTRIBUTE4 pn_space_assign_lease_itf.TEN_ATTRIBUTE4%TYPE;

129: V_ATTRIBUTE_CATEGORY pn_space_assign_lease_itf.TEN_ATTRIBUTE_CATEGORY%TYPE;
130: V_ATTRIBUTE1 pn_space_assign_lease_itf.TEN_ATTRIBUTE1%TYPE;
131: V_ATTRIBUTE2 pn_space_assign_lease_itf.TEN_ATTRIBUTE2%TYPE;
132: V_ATTRIBUTE3 pn_space_assign_lease_itf.TEN_ATTRIBUTE3%TYPE;
133: V_ATTRIBUTE4 pn_space_assign_lease_itf.TEN_ATTRIBUTE4%TYPE;
134: V_ATTRIBUTE5 pn_space_assign_lease_itf.TEN_ATTRIBUTE5%TYPE;
135: V_ATTRIBUTE6 pn_space_assign_lease_itf.TEN_ATTRIBUTE6%TYPE;
136: V_ATTRIBUTE7 pn_space_assign_lease_itf.TEN_ATTRIBUTE7%TYPE;
137: V_ATTRIBUTE8 pn_space_assign_lease_itf.TEN_ATTRIBUTE8%TYPE;

Line 134: V_ATTRIBUTE5 pn_space_assign_lease_itf.TEN_ATTRIBUTE5%TYPE;

130: V_ATTRIBUTE1 pn_space_assign_lease_itf.TEN_ATTRIBUTE1%TYPE;
131: V_ATTRIBUTE2 pn_space_assign_lease_itf.TEN_ATTRIBUTE2%TYPE;
132: V_ATTRIBUTE3 pn_space_assign_lease_itf.TEN_ATTRIBUTE3%TYPE;
133: V_ATTRIBUTE4 pn_space_assign_lease_itf.TEN_ATTRIBUTE4%TYPE;
134: V_ATTRIBUTE5 pn_space_assign_lease_itf.TEN_ATTRIBUTE5%TYPE;
135: V_ATTRIBUTE6 pn_space_assign_lease_itf.TEN_ATTRIBUTE6%TYPE;
136: V_ATTRIBUTE7 pn_space_assign_lease_itf.TEN_ATTRIBUTE7%TYPE;
137: V_ATTRIBUTE8 pn_space_assign_lease_itf.TEN_ATTRIBUTE8%TYPE;
138: V_ATTRIBUTE9 pn_space_assign_lease_itf.TEN_ATTRIBUTE9%TYPE;

Line 135: V_ATTRIBUTE6 pn_space_assign_lease_itf.TEN_ATTRIBUTE6%TYPE;

131: V_ATTRIBUTE2 pn_space_assign_lease_itf.TEN_ATTRIBUTE2%TYPE;
132: V_ATTRIBUTE3 pn_space_assign_lease_itf.TEN_ATTRIBUTE3%TYPE;
133: V_ATTRIBUTE4 pn_space_assign_lease_itf.TEN_ATTRIBUTE4%TYPE;
134: V_ATTRIBUTE5 pn_space_assign_lease_itf.TEN_ATTRIBUTE5%TYPE;
135: V_ATTRIBUTE6 pn_space_assign_lease_itf.TEN_ATTRIBUTE6%TYPE;
136: V_ATTRIBUTE7 pn_space_assign_lease_itf.TEN_ATTRIBUTE7%TYPE;
137: V_ATTRIBUTE8 pn_space_assign_lease_itf.TEN_ATTRIBUTE8%TYPE;
138: V_ATTRIBUTE9 pn_space_assign_lease_itf.TEN_ATTRIBUTE9%TYPE;
139: V_ATTRIBUTE10 pn_space_assign_lease_itf.TEN_ATTRIBUTE10%TYPE;

Line 136: V_ATTRIBUTE7 pn_space_assign_lease_itf.TEN_ATTRIBUTE7%TYPE;

132: V_ATTRIBUTE3 pn_space_assign_lease_itf.TEN_ATTRIBUTE3%TYPE;
133: V_ATTRIBUTE4 pn_space_assign_lease_itf.TEN_ATTRIBUTE4%TYPE;
134: V_ATTRIBUTE5 pn_space_assign_lease_itf.TEN_ATTRIBUTE5%TYPE;
135: V_ATTRIBUTE6 pn_space_assign_lease_itf.TEN_ATTRIBUTE6%TYPE;
136: V_ATTRIBUTE7 pn_space_assign_lease_itf.TEN_ATTRIBUTE7%TYPE;
137: V_ATTRIBUTE8 pn_space_assign_lease_itf.TEN_ATTRIBUTE8%TYPE;
138: V_ATTRIBUTE9 pn_space_assign_lease_itf.TEN_ATTRIBUTE9%TYPE;
139: V_ATTRIBUTE10 pn_space_assign_lease_itf.TEN_ATTRIBUTE10%TYPE;
140: V_ATTRIBUTE11 pn_space_assign_lease_itf.TEN_ATTRIBUTE11%TYPE;

Line 137: V_ATTRIBUTE8 pn_space_assign_lease_itf.TEN_ATTRIBUTE8%TYPE;

133: V_ATTRIBUTE4 pn_space_assign_lease_itf.TEN_ATTRIBUTE4%TYPE;
134: V_ATTRIBUTE5 pn_space_assign_lease_itf.TEN_ATTRIBUTE5%TYPE;
135: V_ATTRIBUTE6 pn_space_assign_lease_itf.TEN_ATTRIBUTE6%TYPE;
136: V_ATTRIBUTE7 pn_space_assign_lease_itf.TEN_ATTRIBUTE7%TYPE;
137: V_ATTRIBUTE8 pn_space_assign_lease_itf.TEN_ATTRIBUTE8%TYPE;
138: V_ATTRIBUTE9 pn_space_assign_lease_itf.TEN_ATTRIBUTE9%TYPE;
139: V_ATTRIBUTE10 pn_space_assign_lease_itf.TEN_ATTRIBUTE10%TYPE;
140: V_ATTRIBUTE11 pn_space_assign_lease_itf.TEN_ATTRIBUTE11%TYPE;
141: V_ATTRIBUTE12 pn_space_assign_lease_itf.TEN_ATTRIBUTE12%TYPE;

Line 138: V_ATTRIBUTE9 pn_space_assign_lease_itf.TEN_ATTRIBUTE9%TYPE;

134: V_ATTRIBUTE5 pn_space_assign_lease_itf.TEN_ATTRIBUTE5%TYPE;
135: V_ATTRIBUTE6 pn_space_assign_lease_itf.TEN_ATTRIBUTE6%TYPE;
136: V_ATTRIBUTE7 pn_space_assign_lease_itf.TEN_ATTRIBUTE7%TYPE;
137: V_ATTRIBUTE8 pn_space_assign_lease_itf.TEN_ATTRIBUTE8%TYPE;
138: V_ATTRIBUTE9 pn_space_assign_lease_itf.TEN_ATTRIBUTE9%TYPE;
139: V_ATTRIBUTE10 pn_space_assign_lease_itf.TEN_ATTRIBUTE10%TYPE;
140: V_ATTRIBUTE11 pn_space_assign_lease_itf.TEN_ATTRIBUTE11%TYPE;
141: V_ATTRIBUTE12 pn_space_assign_lease_itf.TEN_ATTRIBUTE12%TYPE;
142: V_ATTRIBUTE13 pn_space_assign_lease_itf.TEN_ATTRIBUTE13%TYPE;

Line 139: V_ATTRIBUTE10 pn_space_assign_lease_itf.TEN_ATTRIBUTE10%TYPE;

135: V_ATTRIBUTE6 pn_space_assign_lease_itf.TEN_ATTRIBUTE6%TYPE;
136: V_ATTRIBUTE7 pn_space_assign_lease_itf.TEN_ATTRIBUTE7%TYPE;
137: V_ATTRIBUTE8 pn_space_assign_lease_itf.TEN_ATTRIBUTE8%TYPE;
138: V_ATTRIBUTE9 pn_space_assign_lease_itf.TEN_ATTRIBUTE9%TYPE;
139: V_ATTRIBUTE10 pn_space_assign_lease_itf.TEN_ATTRIBUTE10%TYPE;
140: V_ATTRIBUTE11 pn_space_assign_lease_itf.TEN_ATTRIBUTE11%TYPE;
141: V_ATTRIBUTE12 pn_space_assign_lease_itf.TEN_ATTRIBUTE12%TYPE;
142: V_ATTRIBUTE13 pn_space_assign_lease_itf.TEN_ATTRIBUTE13%TYPE;
143: V_ATTRIBUTE14 pn_space_assign_lease_itf.TEN_ATTRIBUTE14%TYPE;

Line 140: V_ATTRIBUTE11 pn_space_assign_lease_itf.TEN_ATTRIBUTE11%TYPE;

136: V_ATTRIBUTE7 pn_space_assign_lease_itf.TEN_ATTRIBUTE7%TYPE;
137: V_ATTRIBUTE8 pn_space_assign_lease_itf.TEN_ATTRIBUTE8%TYPE;
138: V_ATTRIBUTE9 pn_space_assign_lease_itf.TEN_ATTRIBUTE9%TYPE;
139: V_ATTRIBUTE10 pn_space_assign_lease_itf.TEN_ATTRIBUTE10%TYPE;
140: V_ATTRIBUTE11 pn_space_assign_lease_itf.TEN_ATTRIBUTE11%TYPE;
141: V_ATTRIBUTE12 pn_space_assign_lease_itf.TEN_ATTRIBUTE12%TYPE;
142: V_ATTRIBUTE13 pn_space_assign_lease_itf.TEN_ATTRIBUTE13%TYPE;
143: V_ATTRIBUTE14 pn_space_assign_lease_itf.TEN_ATTRIBUTE14%TYPE;
144: V_ATTRIBUTE15 pn_space_assign_lease_itf.TEN_ATTRIBUTE15%TYPE;

Line 141: V_ATTRIBUTE12 pn_space_assign_lease_itf.TEN_ATTRIBUTE12%TYPE;

137: V_ATTRIBUTE8 pn_space_assign_lease_itf.TEN_ATTRIBUTE8%TYPE;
138: V_ATTRIBUTE9 pn_space_assign_lease_itf.TEN_ATTRIBUTE9%TYPE;
139: V_ATTRIBUTE10 pn_space_assign_lease_itf.TEN_ATTRIBUTE10%TYPE;
140: V_ATTRIBUTE11 pn_space_assign_lease_itf.TEN_ATTRIBUTE11%TYPE;
141: V_ATTRIBUTE12 pn_space_assign_lease_itf.TEN_ATTRIBUTE12%TYPE;
142: V_ATTRIBUTE13 pn_space_assign_lease_itf.TEN_ATTRIBUTE13%TYPE;
143: V_ATTRIBUTE14 pn_space_assign_lease_itf.TEN_ATTRIBUTE14%TYPE;
144: V_ATTRIBUTE15 pn_space_assign_lease_itf.TEN_ATTRIBUTE15%TYPE;
145: V_LAST_UPDATE_DATE pn_space_assign_lease_itf.LAST_UPDATE_DATE%TYPE;

Line 142: V_ATTRIBUTE13 pn_space_assign_lease_itf.TEN_ATTRIBUTE13%TYPE;

138: V_ATTRIBUTE9 pn_space_assign_lease_itf.TEN_ATTRIBUTE9%TYPE;
139: V_ATTRIBUTE10 pn_space_assign_lease_itf.TEN_ATTRIBUTE10%TYPE;
140: V_ATTRIBUTE11 pn_space_assign_lease_itf.TEN_ATTRIBUTE11%TYPE;
141: V_ATTRIBUTE12 pn_space_assign_lease_itf.TEN_ATTRIBUTE12%TYPE;
142: V_ATTRIBUTE13 pn_space_assign_lease_itf.TEN_ATTRIBUTE13%TYPE;
143: V_ATTRIBUTE14 pn_space_assign_lease_itf.TEN_ATTRIBUTE14%TYPE;
144: V_ATTRIBUTE15 pn_space_assign_lease_itf.TEN_ATTRIBUTE15%TYPE;
145: V_LAST_UPDATE_DATE pn_space_assign_lease_itf.LAST_UPDATE_DATE%TYPE;
146: V_LAST_UPDATED_BY pn_space_assign_lease_itf.LAST_UPDATED_BY%TYPE;

Line 143: V_ATTRIBUTE14 pn_space_assign_lease_itf.TEN_ATTRIBUTE14%TYPE;

139: V_ATTRIBUTE10 pn_space_assign_lease_itf.TEN_ATTRIBUTE10%TYPE;
140: V_ATTRIBUTE11 pn_space_assign_lease_itf.TEN_ATTRIBUTE11%TYPE;
141: V_ATTRIBUTE12 pn_space_assign_lease_itf.TEN_ATTRIBUTE12%TYPE;
142: V_ATTRIBUTE13 pn_space_assign_lease_itf.TEN_ATTRIBUTE13%TYPE;
143: V_ATTRIBUTE14 pn_space_assign_lease_itf.TEN_ATTRIBUTE14%TYPE;
144: V_ATTRIBUTE15 pn_space_assign_lease_itf.TEN_ATTRIBUTE15%TYPE;
145: V_LAST_UPDATE_DATE pn_space_assign_lease_itf.LAST_UPDATE_DATE%TYPE;
146: V_LAST_UPDATED_BY pn_space_assign_lease_itf.LAST_UPDATED_BY%TYPE;
147: V_LAST_UPDATE_LOGIN pn_space_assign_lease_itf.LAST_UPDATE_LOGIN%TYPE;

Line 144: V_ATTRIBUTE15 pn_space_assign_lease_itf.TEN_ATTRIBUTE15%TYPE;

140: V_ATTRIBUTE11 pn_space_assign_lease_itf.TEN_ATTRIBUTE11%TYPE;
141: V_ATTRIBUTE12 pn_space_assign_lease_itf.TEN_ATTRIBUTE12%TYPE;
142: V_ATTRIBUTE13 pn_space_assign_lease_itf.TEN_ATTRIBUTE13%TYPE;
143: V_ATTRIBUTE14 pn_space_assign_lease_itf.TEN_ATTRIBUTE14%TYPE;
144: V_ATTRIBUTE15 pn_space_assign_lease_itf.TEN_ATTRIBUTE15%TYPE;
145: V_LAST_UPDATE_DATE pn_space_assign_lease_itf.LAST_UPDATE_DATE%TYPE;
146: V_LAST_UPDATED_BY pn_space_assign_lease_itf.LAST_UPDATED_BY%TYPE;
147: V_LAST_UPDATE_LOGIN pn_space_assign_lease_itf.LAST_UPDATE_LOGIN%TYPE;
148: V_CREATION_DATE pn_space_assign_lease_itf.CREATION_DATE%TYPE;

Line 145: V_LAST_UPDATE_DATE pn_space_assign_lease_itf.LAST_UPDATE_DATE%TYPE;

141: V_ATTRIBUTE12 pn_space_assign_lease_itf.TEN_ATTRIBUTE12%TYPE;
142: V_ATTRIBUTE13 pn_space_assign_lease_itf.TEN_ATTRIBUTE13%TYPE;
143: V_ATTRIBUTE14 pn_space_assign_lease_itf.TEN_ATTRIBUTE14%TYPE;
144: V_ATTRIBUTE15 pn_space_assign_lease_itf.TEN_ATTRIBUTE15%TYPE;
145: V_LAST_UPDATE_DATE pn_space_assign_lease_itf.LAST_UPDATE_DATE%TYPE;
146: V_LAST_UPDATED_BY pn_space_assign_lease_itf.LAST_UPDATED_BY%TYPE;
147: V_LAST_UPDATE_LOGIN pn_space_assign_lease_itf.LAST_UPDATE_LOGIN%TYPE;
148: V_CREATION_DATE pn_space_assign_lease_itf.CREATION_DATE%TYPE;
149: V_CREATED_BY pn_space_assign_lease_itf.CREATED_BY%TYPE;

Line 146: V_LAST_UPDATED_BY pn_space_assign_lease_itf.LAST_UPDATED_BY%TYPE;

142: V_ATTRIBUTE13 pn_space_assign_lease_itf.TEN_ATTRIBUTE13%TYPE;
143: V_ATTRIBUTE14 pn_space_assign_lease_itf.TEN_ATTRIBUTE14%TYPE;
144: V_ATTRIBUTE15 pn_space_assign_lease_itf.TEN_ATTRIBUTE15%TYPE;
145: V_LAST_UPDATE_DATE pn_space_assign_lease_itf.LAST_UPDATE_DATE%TYPE;
146: V_LAST_UPDATED_BY pn_space_assign_lease_itf.LAST_UPDATED_BY%TYPE;
147: V_LAST_UPDATE_LOGIN pn_space_assign_lease_itf.LAST_UPDATE_LOGIN%TYPE;
148: V_CREATION_DATE pn_space_assign_lease_itf.CREATION_DATE%TYPE;
149: V_CREATED_BY pn_space_assign_lease_itf.CREATED_BY%TYPE;
150: --declare the record type for the function here.........

Line 147: V_LAST_UPDATE_LOGIN pn_space_assign_lease_itf.LAST_UPDATE_LOGIN%TYPE;

143: V_ATTRIBUTE14 pn_space_assign_lease_itf.TEN_ATTRIBUTE14%TYPE;
144: V_ATTRIBUTE15 pn_space_assign_lease_itf.TEN_ATTRIBUTE15%TYPE;
145: V_LAST_UPDATE_DATE pn_space_assign_lease_itf.LAST_UPDATE_DATE%TYPE;
146: V_LAST_UPDATED_BY pn_space_assign_lease_itf.LAST_UPDATED_BY%TYPE;
147: V_LAST_UPDATE_LOGIN pn_space_assign_lease_itf.LAST_UPDATE_LOGIN%TYPE;
148: V_CREATION_DATE pn_space_assign_lease_itf.CREATION_DATE%TYPE;
149: V_CREATED_BY pn_space_assign_lease_itf.CREATED_BY%TYPE;
150: --declare the record type for the function here.........
151: v_emp_data PNP_UTIL_FUNC.emp_hr_data_rec := NULL;

Line 148: V_CREATION_DATE pn_space_assign_lease_itf.CREATION_DATE%TYPE;

144: V_ATTRIBUTE15 pn_space_assign_lease_itf.TEN_ATTRIBUTE15%TYPE;
145: V_LAST_UPDATE_DATE pn_space_assign_lease_itf.LAST_UPDATE_DATE%TYPE;
146: V_LAST_UPDATED_BY pn_space_assign_lease_itf.LAST_UPDATED_BY%TYPE;
147: V_LAST_UPDATE_LOGIN pn_space_assign_lease_itf.LAST_UPDATE_LOGIN%TYPE;
148: V_CREATION_DATE pn_space_assign_lease_itf.CREATION_DATE%TYPE;
149: V_CREATED_BY pn_space_assign_lease_itf.CREATED_BY%TYPE;
150: --declare the record type for the function here.........
151: v_emp_data PNP_UTIL_FUNC.emp_hr_data_rec := NULL;
152: v_code_data PNP_UTIL_FUNC.location_name_rec := NULL;

Line 149: V_CREATED_BY pn_space_assign_lease_itf.CREATED_BY%TYPE;

145: V_LAST_UPDATE_DATE pn_space_assign_lease_itf.LAST_UPDATE_DATE%TYPE;
146: V_LAST_UPDATED_BY pn_space_assign_lease_itf.LAST_UPDATED_BY%TYPE;
147: V_LAST_UPDATE_LOGIN pn_space_assign_lease_itf.LAST_UPDATE_LOGIN%TYPE;
148: V_CREATION_DATE pn_space_assign_lease_itf.CREATION_DATE%TYPE;
149: V_CREATED_BY pn_space_assign_lease_itf.CREATED_BY%TYPE;
150: --declare the record type for the function here.........
151: v_emp_data PNP_UTIL_FUNC.emp_hr_data_rec := NULL;
152: v_code_data PNP_UTIL_FUNC.location_name_rec := NULL;
153: l_date DATE:=fnd_date.canonical_to_date(

Line 411: INSERT INTO pn_space_assign_lease_itf

407: IF V_LOC_TYPE in ('BUILDING' ,'LAND','FLOOR','PARCEL') THEN
408: PNP_UTIL_FUNC.get_area(v_location_id , v_loc_type ,NULL,AS_OF_DATE,V_LOC_AREA,V_SPACE_AREA);
409: END IF;
410: -----------bug#2226865--------
411: INSERT INTO pn_space_assign_lease_itf
412: (LEASE_ID ,
413: LEASE_NAME ,
414: LEASE_NUMBER ,
415: LEASE_COMMENCEMENT_DATE ,

Line 799: INSERT INTO pn_space_assign_lease_itf

795: IF V_LOC_TYPE in ('BUILDING' ,'LAND','FLOOR','PARCEL') THEN
796: PNP_UTIL_FUNC.get_area(v_location_id , v_loc_type ,NULL,AS_OF_DATE,V_LOC_AREA,V_SPACE_AREA);
797: END IF;
798: -----------bug#2226865--------
799: INSERT INTO pn_space_assign_lease_itf
800: (LEASE_ID ,
801: LEASE_NAME ,
802: LEASE_NUMBER ,
803: LEASE_COMMENCEMENT_DATE ,