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.JTF_RS_INTERFACE_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 138: jtf_rs_resource_extns_int

134: attribute5, attribute6, attribute7, attribute8,
135: attribute9, attribute10, attribute11, attribute12,
136: attribute13, attribute14, attribute15, category
137: FROM
138: jtf_rs_resource_extns_int
139: WHERE
140: batch_id = p_batch_id AND
141: category = 'OTHER' AND
142: operation = 'CREATE' AND

Line 152: l_interface_id JTF_RS_RESOURCE_EXTNS_INT.INTERFACE_ID%TYPE;

148: /*=================Variables for Resource Import========================*/
149: l_api_name VARCHAR2(30);
150: l_init_msg_list VARCHAR2(1);
151: l_commit VARCHAR2(1);
152: l_interface_id JTF_RS_RESOURCE_EXTNS_INT.INTERFACE_ID%TYPE;
153: l_source_id JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE;
154: l_address_id JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE;
155: l_contact_id JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE;
156: l_managing_emp_id JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE;

Line 153: l_source_id JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE;

149: l_api_name VARCHAR2(30);
150: l_init_msg_list VARCHAR2(1);
151: l_commit VARCHAR2(1);
152: l_interface_id JTF_RS_RESOURCE_EXTNS_INT.INTERFACE_ID%TYPE;
153: l_source_id JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE;
154: l_address_id JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE;
155: l_contact_id JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE;
156: l_managing_emp_id JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE;
157: l_start_date_active JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE;

Line 154: l_address_id JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE;

150: l_init_msg_list VARCHAR2(1);
151: l_commit VARCHAR2(1);
152: l_interface_id JTF_RS_RESOURCE_EXTNS_INT.INTERFACE_ID%TYPE;
153: l_source_id JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE;
154: l_address_id JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE;
155: l_contact_id JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE;
156: l_managing_emp_id JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE;
157: l_start_date_active JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE;
158: l_end_date_active JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE;

Line 155: l_contact_id JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE;

151: l_commit VARCHAR2(1);
152: l_interface_id JTF_RS_RESOURCE_EXTNS_INT.INTERFACE_ID%TYPE;
153: l_source_id JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE;
154: l_address_id JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE;
155: l_contact_id JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE;
156: l_managing_emp_id JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE;
157: l_start_date_active JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE;
158: l_end_date_active JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE;
159: l_time_zone JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE;

Line 156: l_managing_emp_id JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE;

152: l_interface_id JTF_RS_RESOURCE_EXTNS_INT.INTERFACE_ID%TYPE;
153: l_source_id JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE;
154: l_address_id JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE;
155: l_contact_id JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE;
156: l_managing_emp_id JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE;
157: l_start_date_active JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE;
158: l_end_date_active JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE;
159: l_time_zone JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE;
160: l_cost_per_hr JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE;

Line 157: l_start_date_active JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE;

153: l_source_id JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE;
154: l_address_id JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE;
155: l_contact_id JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE;
156: l_managing_emp_id JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE;
157: l_start_date_active JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE;
158: l_end_date_active JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE;
159: l_time_zone JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE;
160: l_cost_per_hr JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE;
161: l_primary_language JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE;

Line 158: l_end_date_active JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE;

154: l_address_id JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE;
155: l_contact_id JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE;
156: l_managing_emp_id JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE;
157: l_start_date_active JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE;
158: l_end_date_active JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE;
159: l_time_zone JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE;
160: l_cost_per_hr JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE;
161: l_primary_language JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE;
162: l_secondary_language JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE;

Line 159: l_time_zone JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE;

155: l_contact_id JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE;
156: l_managing_emp_id JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE;
157: l_start_date_active JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE;
158: l_end_date_active JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE;
159: l_time_zone JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE;
160: l_cost_per_hr JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE;
161: l_primary_language JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE;
162: l_secondary_language JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE;
163: l_support_site_id JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE;

Line 160: l_cost_per_hr JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE;

156: l_managing_emp_id JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE;
157: l_start_date_active JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE;
158: l_end_date_active JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE;
159: l_time_zone JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE;
160: l_cost_per_hr JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE;
161: l_primary_language JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE;
162: l_secondary_language JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE;
163: l_support_site_id JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE;
164: l_ies_agent_login JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE;

Line 161: l_primary_language JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE;

157: l_start_date_active JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE;
158: l_end_date_active JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE;
159: l_time_zone JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE;
160: l_cost_per_hr JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE;
161: l_primary_language JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE;
162: l_secondary_language JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE;
163: l_support_site_id JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE;
164: l_ies_agent_login JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE;
165: l_server_group_id JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE;

Line 162: l_secondary_language JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE;

158: l_end_date_active JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE;
159: l_time_zone JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE;
160: l_cost_per_hr JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE;
161: l_primary_language JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE;
162: l_secondary_language JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE;
163: l_support_site_id JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE;
164: l_ies_agent_login JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE;
165: l_server_group_id JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE;
166: l_interaction_center_name VARCHAR2(256);

Line 163: l_support_site_id JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE;

159: l_time_zone JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE;
160: l_cost_per_hr JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE;
161: l_primary_language JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE;
162: l_secondary_language JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE;
163: l_support_site_id JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE;
164: l_ies_agent_login JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE;
165: l_server_group_id JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE;
166: l_interaction_center_name VARCHAR2(256);
167: l_assigned_to_group_id JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE;

Line 164: l_ies_agent_login JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE;

160: l_cost_per_hr JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE;
161: l_primary_language JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE;
162: l_secondary_language JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE;
163: l_support_site_id JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE;
164: l_ies_agent_login JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE;
165: l_server_group_id JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE;
166: l_interaction_center_name VARCHAR2(256);
167: l_assigned_to_group_id JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE;
168: l_cost_center JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE;

Line 165: l_server_group_id JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE;

161: l_primary_language JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE;
162: l_secondary_language JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE;
163: l_support_site_id JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE;
164: l_ies_agent_login JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE;
165: l_server_group_id JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE;
166: l_interaction_center_name VARCHAR2(256);
167: l_assigned_to_group_id JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE;
168: l_cost_center JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE;
169: l_charge_to_cost_center JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE;

Line 167: l_assigned_to_group_id JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE;

163: l_support_site_id JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE;
164: l_ies_agent_login JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE;
165: l_server_group_id JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE;
166: l_interaction_center_name VARCHAR2(256);
167: l_assigned_to_group_id JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE;
168: l_cost_center JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE;
169: l_charge_to_cost_center JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE;
170: l_comp_currency_code JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE;
171: l_commissionable_flag JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE;

Line 168: l_cost_center JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE;

164: l_ies_agent_login JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE;
165: l_server_group_id JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE;
166: l_interaction_center_name VARCHAR2(256);
167: l_assigned_to_group_id JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE;
168: l_cost_center JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE;
169: l_charge_to_cost_center JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE;
170: l_comp_currency_code JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE;
171: l_commissionable_flag JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE;
172: l_hold_reason_code JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE;

Line 169: l_charge_to_cost_center JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE;

165: l_server_group_id JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE;
166: l_interaction_center_name VARCHAR2(256);
167: l_assigned_to_group_id JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE;
168: l_cost_center JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE;
169: l_charge_to_cost_center JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE;
170: l_comp_currency_code JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE;
171: l_commissionable_flag JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE;
172: l_hold_reason_code JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE;
173: l_hold_payment JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE;

Line 170: l_comp_currency_code JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE;

166: l_interaction_center_name VARCHAR2(256);
167: l_assigned_to_group_id JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE;
168: l_cost_center JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE;
169: l_charge_to_cost_center JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE;
170: l_comp_currency_code JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE;
171: l_commissionable_flag JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE;
172: l_hold_reason_code JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE;
173: l_hold_payment JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE;
174: l_comp_service_team_id JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE;

Line 171: l_commissionable_flag JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE;

167: l_assigned_to_group_id JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE;
168: l_cost_center JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE;
169: l_charge_to_cost_center JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE;
170: l_comp_currency_code JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE;
171: l_commissionable_flag JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE;
172: l_hold_reason_code JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE;
173: l_hold_payment JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE;
174: l_comp_service_team_id JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE;
175: l_user_id JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE;

Line 172: l_hold_reason_code JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE;

168: l_cost_center JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE;
169: l_charge_to_cost_center JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE;
170: l_comp_currency_code JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE;
171: l_commissionable_flag JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE;
172: l_hold_reason_code JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE;
173: l_hold_payment JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE;
174: l_comp_service_team_id JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE;
175: l_user_id JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE;
176: l_transaction_number JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE;

Line 173: l_hold_payment JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE;

169: l_charge_to_cost_center JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE;
170: l_comp_currency_code JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE;
171: l_commissionable_flag JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE;
172: l_hold_reason_code JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE;
173: l_hold_payment JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE;
174: l_comp_service_team_id JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE;
175: l_user_id JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE;
176: l_transaction_number JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE;
177: x_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;

Line 174: l_comp_service_team_id JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE;

170: l_comp_currency_code JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE;
171: l_commissionable_flag JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE;
172: l_hold_reason_code JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE;
173: l_hold_payment JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE;
174: l_comp_service_team_id JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE;
175: l_user_id JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE;
176: l_transaction_number JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE;
177: x_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
178: x_resource_number JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE;

Line 175: l_user_id JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE;

171: l_commissionable_flag JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE;
172: l_hold_reason_code JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE;
173: l_hold_payment JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE;
174: l_comp_service_team_id JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE;
175: l_user_id JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE;
176: l_transaction_number JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE;
177: x_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
178: x_resource_number JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE;
179: l_resource_name JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE;

Line 176: l_transaction_number JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE;

172: l_hold_reason_code JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE;
173: l_hold_payment JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE;
174: l_comp_service_team_id JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE;
175: l_user_id JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE;
176: l_transaction_number JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE;
177: x_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
178: x_resource_number JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE;
179: l_resource_name JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE;
180: l_user_name JTF_RS_RESOURCE_EXTNS.USER_NAME%TYPE;

Line 177: x_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;

173: l_hold_payment JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE;
174: l_comp_service_team_id JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE;
175: l_user_id JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE;
176: l_transaction_number JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE;
177: x_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
178: x_resource_number JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE;
179: l_resource_name JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE;
180: l_user_name JTF_RS_RESOURCE_EXTNS.USER_NAME%TYPE;
181: l_attribute1 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE;

Line 178: x_resource_number JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE;

174: l_comp_service_team_id JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE;
175: l_user_id JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE;
176: l_transaction_number JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE;
177: x_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
178: x_resource_number JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE;
179: l_resource_name JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE;
180: l_user_name JTF_RS_RESOURCE_EXTNS.USER_NAME%TYPE;
181: l_attribute1 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE;
182: l_attribute2 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE;

Line 179: l_resource_name JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE;

175: l_user_id JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE;
176: l_transaction_number JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE;
177: x_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
178: x_resource_number JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE;
179: l_resource_name JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE;
180: l_user_name JTF_RS_RESOURCE_EXTNS.USER_NAME%TYPE;
181: l_attribute1 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE;
182: l_attribute2 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE;
183: l_attribute3 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE;

Line 180: l_user_name JTF_RS_RESOURCE_EXTNS.USER_NAME%TYPE;

176: l_transaction_number JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE;
177: x_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
178: x_resource_number JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE;
179: l_resource_name JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE;
180: l_user_name JTF_RS_RESOURCE_EXTNS.USER_NAME%TYPE;
181: l_attribute1 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE;
182: l_attribute2 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE;
183: l_attribute3 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE;
184: l_attribute4 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE;

Line 181: l_attribute1 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE;

177: x_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
178: x_resource_number JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE;
179: l_resource_name JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE;
180: l_user_name JTF_RS_RESOURCE_EXTNS.USER_NAME%TYPE;
181: l_attribute1 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE;
182: l_attribute2 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE;
183: l_attribute3 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE;
184: l_attribute4 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE;
185: l_attribute5 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE;

Line 182: l_attribute2 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE;

178: x_resource_number JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE;
179: l_resource_name JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE;
180: l_user_name JTF_RS_RESOURCE_EXTNS.USER_NAME%TYPE;
181: l_attribute1 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE;
182: l_attribute2 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE;
183: l_attribute3 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE;
184: l_attribute4 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE;
185: l_attribute5 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE;
186: l_attribute6 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE;

Line 183: l_attribute3 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE;

179: l_resource_name JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE;
180: l_user_name JTF_RS_RESOURCE_EXTNS.USER_NAME%TYPE;
181: l_attribute1 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE;
182: l_attribute2 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE;
183: l_attribute3 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE;
184: l_attribute4 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE;
185: l_attribute5 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE;
186: l_attribute6 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE;
187: l_attribute7 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE;

Line 184: l_attribute4 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE;

180: l_user_name JTF_RS_RESOURCE_EXTNS.USER_NAME%TYPE;
181: l_attribute1 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE;
182: l_attribute2 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE;
183: l_attribute3 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE;
184: l_attribute4 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE;
185: l_attribute5 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE;
186: l_attribute6 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE;
187: l_attribute7 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE;
188: l_attribute8 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE;

Line 185: l_attribute5 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE;

181: l_attribute1 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE;
182: l_attribute2 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE;
183: l_attribute3 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE;
184: l_attribute4 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE;
185: l_attribute5 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE;
186: l_attribute6 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE;
187: l_attribute7 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE;
188: l_attribute8 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE;
189: l_attribute9 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE;

Line 186: l_attribute6 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE;

182: l_attribute2 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE;
183: l_attribute3 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE;
184: l_attribute4 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE;
185: l_attribute5 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE;
186: l_attribute6 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE;
187: l_attribute7 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE;
188: l_attribute8 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE;
189: l_attribute9 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE;
190: l_attribute10 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE;

Line 187: l_attribute7 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE;

183: l_attribute3 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE;
184: l_attribute4 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE;
185: l_attribute5 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE;
186: l_attribute6 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE;
187: l_attribute7 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE;
188: l_attribute8 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE;
189: l_attribute9 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE;
190: l_attribute10 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE;
191: l_attribute11 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE;

Line 188: l_attribute8 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE;

184: l_attribute4 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE;
185: l_attribute5 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE;
186: l_attribute6 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE;
187: l_attribute7 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE;
188: l_attribute8 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE;
189: l_attribute9 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE;
190: l_attribute10 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE;
191: l_attribute11 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE;
192: l_attribute12 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE;

Line 189: l_attribute9 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE;

185: l_attribute5 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE;
186: l_attribute6 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE;
187: l_attribute7 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE;
188: l_attribute8 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE;
189: l_attribute9 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE;
190: l_attribute10 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE;
191: l_attribute11 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE;
192: l_attribute12 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE;
193: l_attribute13 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE;

Line 190: l_attribute10 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE;

186: l_attribute6 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE;
187: l_attribute7 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE;
188: l_attribute8 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE;
189: l_attribute9 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE;
190: l_attribute10 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE;
191: l_attribute11 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE;
192: l_attribute12 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE;
193: l_attribute13 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE;
194: l_attribute14 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE;

Line 191: l_attribute11 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE;

187: l_attribute7 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE;
188: l_attribute8 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE;
189: l_attribute9 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE;
190: l_attribute10 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE;
191: l_attribute11 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE;
192: l_attribute12 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE;
193: l_attribute13 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE;
194: l_attribute14 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE;
195: l_attribute15 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE;

Line 192: l_attribute12 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE;

188: l_attribute8 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE;
189: l_attribute9 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE;
190: l_attribute10 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE;
191: l_attribute11 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE;
192: l_attribute12 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE;
193: l_attribute13 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE;
194: l_attribute14 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE;
195: l_attribute15 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE;
196: l_attribute_category JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE;

Line 193: l_attribute13 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE;

189: l_attribute9 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE;
190: l_attribute10 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE;
191: l_attribute11 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE;
192: l_attribute12 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE;
193: l_attribute13 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE;
194: l_attribute14 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE;
195: l_attribute15 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE;
196: l_attribute_category JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE;
197: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;

Line 194: l_attribute14 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE;

190: l_attribute10 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE;
191: l_attribute11 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE;
192: l_attribute12 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE;
193: l_attribute13 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE;
194: l_attribute14 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE;
195: l_attribute15 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE;
196: l_attribute_category JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE;
197: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
198: l_resource_number JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE;

Line 195: l_attribute15 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE;

191: l_attribute11 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE;
192: l_attribute12 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE;
193: l_attribute13 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE;
194: l_attribute14 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE;
195: l_attribute15 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE;
196: l_attribute_category JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE;
197: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
198: l_resource_number JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE;
199: l_source_name JTF_RS_RESOURCE_EXTNS.source_name%TYPE;

Line 196: l_attribute_category JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE;

192: l_attribute12 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE;
193: l_attribute13 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE;
194: l_attribute14 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE;
195: l_attribute15 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE;
196: l_attribute_category JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE;
197: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
198: l_resource_number JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE;
199: l_source_name JTF_RS_RESOURCE_EXTNS.source_name%TYPE;
200: l_category JTF_RS_RESOURCE_EXTNS.category%TYPE;

Line 197: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;

193: l_attribute13 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE;
194: l_attribute14 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE;
195: l_attribute15 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE;
196: l_attribute_category JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE;
197: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
198: l_resource_number JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE;
199: l_source_name JTF_RS_RESOURCE_EXTNS.source_name%TYPE;
200: l_category JTF_RS_RESOURCE_EXTNS.category%TYPE;
201: l_debug_prefix VARCHAR2(30) := '';

Line 198: l_resource_number JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE;

194: l_attribute14 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE;
195: l_attribute15 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE;
196: l_attribute_category JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE;
197: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
198: l_resource_number JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE;
199: l_source_name JTF_RS_RESOURCE_EXTNS.source_name%TYPE;
200: l_category JTF_RS_RESOURCE_EXTNS.category%TYPE;
201: l_debug_prefix VARCHAR2(30) := '';
202: l_batch_id NUMBER;

Line 199: l_source_name JTF_RS_RESOURCE_EXTNS.source_name%TYPE;

195: l_attribute15 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE;
196: l_attribute_category JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE;
197: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
198: l_resource_number JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE;
199: l_source_name JTF_RS_RESOURCE_EXTNS.source_name%TYPE;
200: l_category JTF_RS_RESOURCE_EXTNS.category%TYPE;
201: l_debug_prefix VARCHAR2(30) := '';
202: l_batch_id NUMBER;
203:

Line 200: l_category JTF_RS_RESOURCE_EXTNS.category%TYPE;

196: l_attribute_category JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE;
197: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
198: l_resource_number JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE;
199: l_source_name JTF_RS_RESOURCE_EXTNS.source_name%TYPE;
200: l_category JTF_RS_RESOURCE_EXTNS.category%TYPE;
201: l_debug_prefix VARCHAR2(30) := '';
202: l_batch_id NUMBER;
203:
204: l_return_status VARCHAR2(1);

Line 249: UPDATE jtf_rs_resource_extns_int

245: --validate Start Date Active value.
246: -- Get translated value for 'Start Date Active cannot be null'
247: l_trans_message := fnd_message.get_string('JTF','JTF_RS_START_DATE_NULL');
248:
249: UPDATE jtf_rs_resource_extns_int
250: SET OPERATION_STATUS = l_status_error,
251: OPERATION_MESSAGE = l_trans_message,
252: OPERATION_PROCESS_DATE = SYSDATE
253: WHERE batch_id = p_batch_id AND

Line 293: UPDATE jtf_rs_resource_extns_int

289: fnd_msg_pub.add;
290:
291: l_trans_message := FND_MSG_PUB.Get( p_encoded => FND_API.G_FALSE);
292:
293: UPDATE jtf_rs_resource_extns_int
294: SET OPERATION_STATUS = l_status_error,
295: OPERATION_MESSAGE = l_trans_message,
296: OPERATION_PROCESS_DATE = SYSDATE
297: WHERE batch_id = p_batch_id AND

Line 437: UPDATE jtf_rs_resource_extns_int

433: ---- End of Message data reading logic
434:
435: --When return status is success then update Resource Id to Intf Table.
436: IF l_return_status = l_status_success THEN
437: UPDATE jtf_rs_resource_extns_int
438: SET operation_status = l_status_success,
439: operation_process_date = SYSDATE,
440: resource_id = x_resource_id
441: WHERE interface_id = l_interface_id;

Line 444: UPDATE jtf_rs_resource_extns_int

440: resource_id = x_resource_id
441: WHERE interface_id = l_interface_id;
442: ELSE
443: -- When return status is NOT success,update Error details to Intf Table.
444: UPDATE jtf_rs_resource_extns_int
445: SET operation_status = l_return_status,
446: operation_message = l_msg_data1,
447: operation_process_date = SYSDATE
448: WHERE interface_id = l_interface_id;

Line 477: UPDATE jtf_rs_resource_extns_int

473: END IF;
474:
475: ROLLBACK TO do_create_resource_loop;
476:
477: UPDATE jtf_rs_resource_extns_int
478: SET operation_status = l_return_status,
479: operation_message = l_msg_data1,
480: operation_process_date = SYSDATE
481: WHERE interface_id = l_interface_id;

Line 618: jtf_rs_resource_extns_int

614: resource_id,
615: DECODE(start_date_active,to_char(l_null_date,'dd/mm/yyyy hh24:mi:ss'),NULL,NULL,to_char(l_miss_date,'dd/mm/yyyy hh24:mi:ss'),to_char(start_date_active,'dd/mm/yyyy hh24:mi:ss')) start_date_active_char
616: --Character converted date To compare with l_miss_date.
617: FROM
618: jtf_rs_resource_extns_int
619: WHERE
620: batch_id = p_batch_id AND
621: category = 'OTHER' AND
622: operation = 'UPDATE' AND

Line 627: l_category JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE;

623: operation_status IS NULL
624: ORDER BY interface_id;
625:
626:
627: l_category JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE;
628: l_object_version_number JTF_RS_RESOURCE_EXTNS.OBJECT_VERSION_NUMBER%TYPE;
629: l_end_date_active_db JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE;
630: l_start_date_active_db JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE;
631:

Line 628: l_object_version_number JTF_RS_RESOURCE_EXTNS.OBJECT_VERSION_NUMBER%TYPE;

624: ORDER BY interface_id;
625:
626:
627: l_category JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE;
628: l_object_version_number JTF_RS_RESOURCE_EXTNS.OBJECT_VERSION_NUMBER%TYPE;
629: l_end_date_active_db JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE;
630: l_start_date_active_db JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE;
631:
632: x_object_version_num_res NUMBER;

Line 629: l_end_date_active_db JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE;

625:
626:
627: l_category JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE;
628: l_object_version_number JTF_RS_RESOURCE_EXTNS.OBJECT_VERSION_NUMBER%TYPE;
629: l_end_date_active_db JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE;
630: l_start_date_active_db JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE;
631:
632: x_object_version_num_res NUMBER;
633: l_commit_count NUMBER;

Line 630: l_start_date_active_db JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE;

626:
627: l_category JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE;
628: l_object_version_number JTF_RS_RESOURCE_EXTNS.OBJECT_VERSION_NUMBER%TYPE;
629: l_end_date_active_db JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE;
630: l_start_date_active_db JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE;
631:
632: x_object_version_num_res NUMBER;
633: l_commit_count NUMBER;
634:

Line 639: l_interface_id JTF_RS_RESOURCE_EXTNS_INT.INTERFACE_ID%TYPE;

635: /*=================Variables for Resource Import========================*/
636: l_api_name VARCHAR2(30);
637: l_init_msg_list VARCHAR2(1);
638: l_commit VARCHAR2(1);
639: l_interface_id JTF_RS_RESOURCE_EXTNS_INT.INTERFACE_ID%TYPE;
640: l_source_id JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE;
641: l_address_id JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE;
642: l_contact_id JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE;
643: l_managing_emp_id JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE;

Line 640: l_source_id JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE;

636: l_api_name VARCHAR2(30);
637: l_init_msg_list VARCHAR2(1);
638: l_commit VARCHAR2(1);
639: l_interface_id JTF_RS_RESOURCE_EXTNS_INT.INTERFACE_ID%TYPE;
640: l_source_id JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE;
641: l_address_id JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE;
642: l_contact_id JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE;
643: l_managing_emp_id JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE;
644: l_start_date_active JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE;

Line 641: l_address_id JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE;

637: l_init_msg_list VARCHAR2(1);
638: l_commit VARCHAR2(1);
639: l_interface_id JTF_RS_RESOURCE_EXTNS_INT.INTERFACE_ID%TYPE;
640: l_source_id JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE;
641: l_address_id JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE;
642: l_contact_id JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE;
643: l_managing_emp_id JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE;
644: l_start_date_active JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE;
645: l_end_date_active JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE;

Line 642: l_contact_id JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE;

638: l_commit VARCHAR2(1);
639: l_interface_id JTF_RS_RESOURCE_EXTNS_INT.INTERFACE_ID%TYPE;
640: l_source_id JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE;
641: l_address_id JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE;
642: l_contact_id JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE;
643: l_managing_emp_id JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE;
644: l_start_date_active JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE;
645: l_end_date_active JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE;
646: l_time_zone JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE;

Line 643: l_managing_emp_id JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE;

639: l_interface_id JTF_RS_RESOURCE_EXTNS_INT.INTERFACE_ID%TYPE;
640: l_source_id JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE;
641: l_address_id JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE;
642: l_contact_id JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE;
643: l_managing_emp_id JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE;
644: l_start_date_active JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE;
645: l_end_date_active JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE;
646: l_time_zone JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE;
647: l_cost_per_hr JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE;

Line 644: l_start_date_active JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE;

640: l_source_id JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE;
641: l_address_id JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE;
642: l_contact_id JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE;
643: l_managing_emp_id JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE;
644: l_start_date_active JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE;
645: l_end_date_active JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE;
646: l_time_zone JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE;
647: l_cost_per_hr JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE;
648: l_primary_language JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE;

Line 645: l_end_date_active JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE;

641: l_address_id JTF_RS_RESOURCE_EXTNS.ADDRESS_ID%TYPE;
642: l_contact_id JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE;
643: l_managing_emp_id JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE;
644: l_start_date_active JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE;
645: l_end_date_active JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE;
646: l_time_zone JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE;
647: l_cost_per_hr JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE;
648: l_primary_language JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE;
649: l_secondary_language JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE;

Line 646: l_time_zone JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE;

642: l_contact_id JTF_RS_RESOURCE_EXTNS.CONTACT_ID%TYPE;
643: l_managing_emp_id JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE;
644: l_start_date_active JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE;
645: l_end_date_active JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE;
646: l_time_zone JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE;
647: l_cost_per_hr JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE;
648: l_primary_language JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE;
649: l_secondary_language JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE;
650: l_support_site_id JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE;

Line 647: l_cost_per_hr JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE;

643: l_managing_emp_id JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE;
644: l_start_date_active JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE;
645: l_end_date_active JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE;
646: l_time_zone JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE;
647: l_cost_per_hr JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE;
648: l_primary_language JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE;
649: l_secondary_language JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE;
650: l_support_site_id JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE;
651: l_ies_agent_login JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE;

Line 648: l_primary_language JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE;

644: l_start_date_active JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE;
645: l_end_date_active JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE;
646: l_time_zone JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE;
647: l_cost_per_hr JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE;
648: l_primary_language JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE;
649: l_secondary_language JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE;
650: l_support_site_id JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE;
651: l_ies_agent_login JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE;
652: l_server_group_id JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE;

Line 649: l_secondary_language JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE;

645: l_end_date_active JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE;
646: l_time_zone JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE;
647: l_cost_per_hr JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE;
648: l_primary_language JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE;
649: l_secondary_language JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE;
650: l_support_site_id JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE;
651: l_ies_agent_login JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE;
652: l_server_group_id JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE;
653: l_interaction_center_name VARCHAR2(256);

Line 650: l_support_site_id JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE;

646: l_time_zone JTF_RS_RESOURCE_EXTNS.TIME_ZONE%TYPE;
647: l_cost_per_hr JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE;
648: l_primary_language JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE;
649: l_secondary_language JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE;
650: l_support_site_id JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE;
651: l_ies_agent_login JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE;
652: l_server_group_id JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE;
653: l_interaction_center_name VARCHAR2(256);
654: l_assigned_to_group_id JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE;

Line 651: l_ies_agent_login JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE;

647: l_cost_per_hr JTF_RS_RESOURCE_EXTNS.COST_PER_HR%TYPE;
648: l_primary_language JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE;
649: l_secondary_language JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE;
650: l_support_site_id JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE;
651: l_ies_agent_login JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE;
652: l_server_group_id JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE;
653: l_interaction_center_name VARCHAR2(256);
654: l_assigned_to_group_id JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE;
655: l_cost_center JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE;

Line 652: l_server_group_id JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE;

648: l_primary_language JTF_RS_RESOURCE_EXTNS.PRIMARY_LANGUAGE%TYPE;
649: l_secondary_language JTF_RS_RESOURCE_EXTNS.SECONDARY_LANGUAGE%TYPE;
650: l_support_site_id JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE;
651: l_ies_agent_login JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE;
652: l_server_group_id JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE;
653: l_interaction_center_name VARCHAR2(256);
654: l_assigned_to_group_id JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE;
655: l_cost_center JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE;
656: l_charge_to_cost_center JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE;

Line 654: l_assigned_to_group_id JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE;

650: l_support_site_id JTF_RS_RESOURCE_EXTNS.SUPPORT_SITE_ID%TYPE;
651: l_ies_agent_login JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE;
652: l_server_group_id JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE;
653: l_interaction_center_name VARCHAR2(256);
654: l_assigned_to_group_id JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE;
655: l_cost_center JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE;
656: l_charge_to_cost_center JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE;
657: l_comp_currency_code JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE;
658: l_commissionable_flag JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE;

Line 655: l_cost_center JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE;

651: l_ies_agent_login JTF_RS_RESOURCE_EXTNS.IES_AGENT_LOGIN%TYPE;
652: l_server_group_id JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE;
653: l_interaction_center_name VARCHAR2(256);
654: l_assigned_to_group_id JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE;
655: l_cost_center JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE;
656: l_charge_to_cost_center JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE;
657: l_comp_currency_code JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE;
658: l_commissionable_flag JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE;
659: l_hold_reason_code JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE;

Line 656: l_charge_to_cost_center JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE;

652: l_server_group_id JTF_RS_RESOURCE_EXTNS.SERVER_GROUP_ID%TYPE;
653: l_interaction_center_name VARCHAR2(256);
654: l_assigned_to_group_id JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE;
655: l_cost_center JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE;
656: l_charge_to_cost_center JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE;
657: l_comp_currency_code JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE;
658: l_commissionable_flag JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE;
659: l_hold_reason_code JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE;
660: l_hold_payment JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE;

Line 657: l_comp_currency_code JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE;

653: l_interaction_center_name VARCHAR2(256);
654: l_assigned_to_group_id JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE;
655: l_cost_center JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE;
656: l_charge_to_cost_center JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE;
657: l_comp_currency_code JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE;
658: l_commissionable_flag JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE;
659: l_hold_reason_code JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE;
660: l_hold_payment JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE;
661: l_comp_service_team_id JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE;

Line 658: l_commissionable_flag JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE;

654: l_assigned_to_group_id JTF_RS_RESOURCE_EXTNS.ASSIGNED_TO_GROUP_ID%TYPE;
655: l_cost_center JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE;
656: l_charge_to_cost_center JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE;
657: l_comp_currency_code JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE;
658: l_commissionable_flag JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE;
659: l_hold_reason_code JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE;
660: l_hold_payment JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE;
661: l_comp_service_team_id JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE;
662: l_user_id JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE;

Line 659: l_hold_reason_code JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE;

655: l_cost_center JTF_RS_RESOURCE_EXTNS.COST_CENTER%TYPE;
656: l_charge_to_cost_center JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE;
657: l_comp_currency_code JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE;
658: l_commissionable_flag JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE;
659: l_hold_reason_code JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE;
660: l_hold_payment JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE;
661: l_comp_service_team_id JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE;
662: l_user_id JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE;
663: l_transaction_number JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE;

Line 660: l_hold_payment JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE;

656: l_charge_to_cost_center JTF_RS_RESOURCE_EXTNS.CHARGE_TO_COST_CENTER%TYPE;
657: l_comp_currency_code JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE;
658: l_commissionable_flag JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE;
659: l_hold_reason_code JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE;
660: l_hold_payment JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE;
661: l_comp_service_team_id JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE;
662: l_user_id JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE;
663: l_transaction_number JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE;
664: x_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;

Line 661: l_comp_service_team_id JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE;

657: l_comp_currency_code JTF_RS_RESOURCE_EXTNS.COMPENSATION_CURRENCY_CODE%TYPE;
658: l_commissionable_flag JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE;
659: l_hold_reason_code JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE;
660: l_hold_payment JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE;
661: l_comp_service_team_id JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE;
662: l_user_id JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE;
663: l_transaction_number JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE;
664: x_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
665: x_resource_number JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE;

Line 662: l_user_id JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE;

658: l_commissionable_flag JTF_RS_RESOURCE_EXTNS.COMMISSIONABLE_FLAG%TYPE;
659: l_hold_reason_code JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE;
660: l_hold_payment JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE;
661: l_comp_service_team_id JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE;
662: l_user_id JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE;
663: l_transaction_number JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE;
664: x_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
665: x_resource_number JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE;
666: l_resource_name JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE;

Line 663: l_transaction_number JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE;

659: l_hold_reason_code JTF_RS_RESOURCE_EXTNS.HOLD_REASON_CODE%TYPE;
660: l_hold_payment JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE;
661: l_comp_service_team_id JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE;
662: l_user_id JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE;
663: l_transaction_number JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE;
664: x_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
665: x_resource_number JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE;
666: l_resource_name JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE;
667: l_user_name JTF_RS_RESOURCE_EXTNS.USER_NAME%TYPE;

Line 664: x_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;

660: l_hold_payment JTF_RS_RESOURCE_EXTNS.HOLD_PAYMENT%TYPE;
661: l_comp_service_team_id JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE;
662: l_user_id JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE;
663: l_transaction_number JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE;
664: x_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
665: x_resource_number JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE;
666: l_resource_name JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE;
667: l_user_name JTF_RS_RESOURCE_EXTNS.USER_NAME%TYPE;
668: l_attribute1 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE;

Line 665: x_resource_number JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE;

661: l_comp_service_team_id JTF_RS_RESOURCE_EXTNS.COMP_SERVICE_TEAM_ID%TYPE;
662: l_user_id JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE;
663: l_transaction_number JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE;
664: x_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
665: x_resource_number JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE;
666: l_resource_name JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE;
667: l_user_name JTF_RS_RESOURCE_EXTNS.USER_NAME%TYPE;
668: l_attribute1 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE;
669: l_attribute2 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE;

Line 666: l_resource_name JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE;

662: l_user_id JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE;
663: l_transaction_number JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE;
664: x_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
665: x_resource_number JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE;
666: l_resource_name JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE;
667: l_user_name JTF_RS_RESOURCE_EXTNS.USER_NAME%TYPE;
668: l_attribute1 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE;
669: l_attribute2 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE;
670: l_attribute3 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE;

Line 667: l_user_name JTF_RS_RESOURCE_EXTNS.USER_NAME%TYPE;

663: l_transaction_number JTF_RS_RESOURCE_EXTNS.TRANSACTION_NUMBER%TYPE;
664: x_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
665: x_resource_number JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE;
666: l_resource_name JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE;
667: l_user_name JTF_RS_RESOURCE_EXTNS.USER_NAME%TYPE;
668: l_attribute1 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE;
669: l_attribute2 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE;
670: l_attribute3 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE;
671: l_attribute4 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE;

Line 668: l_attribute1 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE;

664: x_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
665: x_resource_number JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE;
666: l_resource_name JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE;
667: l_user_name JTF_RS_RESOURCE_EXTNS.USER_NAME%TYPE;
668: l_attribute1 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE;
669: l_attribute2 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE;
670: l_attribute3 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE;
671: l_attribute4 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE;
672: l_attribute5 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE;

Line 669: l_attribute2 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE;

665: x_resource_number JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE;
666: l_resource_name JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE;
667: l_user_name JTF_RS_RESOURCE_EXTNS.USER_NAME%TYPE;
668: l_attribute1 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE;
669: l_attribute2 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE;
670: l_attribute3 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE;
671: l_attribute4 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE;
672: l_attribute5 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE;
673: l_attribute6 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE;

Line 670: l_attribute3 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE;

666: l_resource_name JTF_RS_RESOURCE_EXTNS_TL.RESOURCE_NAME%TYPE;
667: l_user_name JTF_RS_RESOURCE_EXTNS.USER_NAME%TYPE;
668: l_attribute1 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE;
669: l_attribute2 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE;
670: l_attribute3 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE;
671: l_attribute4 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE;
672: l_attribute5 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE;
673: l_attribute6 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE;
674: l_attribute7 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE;

Line 671: l_attribute4 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE;

667: l_user_name JTF_RS_RESOURCE_EXTNS.USER_NAME%TYPE;
668: l_attribute1 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE;
669: l_attribute2 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE;
670: l_attribute3 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE;
671: l_attribute4 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE;
672: l_attribute5 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE;
673: l_attribute6 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE;
674: l_attribute7 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE;
675: l_attribute8 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE;

Line 672: l_attribute5 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE;

668: l_attribute1 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE1%TYPE;
669: l_attribute2 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE;
670: l_attribute3 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE;
671: l_attribute4 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE;
672: l_attribute5 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE;
673: l_attribute6 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE;
674: l_attribute7 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE;
675: l_attribute8 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE;
676: l_attribute9 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE;

Line 673: l_attribute6 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE;

669: l_attribute2 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE2%TYPE;
670: l_attribute3 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE;
671: l_attribute4 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE;
672: l_attribute5 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE;
673: l_attribute6 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE;
674: l_attribute7 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE;
675: l_attribute8 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE;
676: l_attribute9 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE;
677: l_attribute10 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE;

Line 674: l_attribute7 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE;

670: l_attribute3 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE3%TYPE;
671: l_attribute4 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE;
672: l_attribute5 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE;
673: l_attribute6 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE;
674: l_attribute7 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE;
675: l_attribute8 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE;
676: l_attribute9 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE;
677: l_attribute10 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE;
678: l_attribute11 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE;

Line 675: l_attribute8 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE;

671: l_attribute4 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE4%TYPE;
672: l_attribute5 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE;
673: l_attribute6 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE;
674: l_attribute7 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE;
675: l_attribute8 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE;
676: l_attribute9 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE;
677: l_attribute10 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE;
678: l_attribute11 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE;
679: l_attribute12 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE;

Line 676: l_attribute9 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE;

672: l_attribute5 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE5%TYPE;
673: l_attribute6 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE;
674: l_attribute7 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE;
675: l_attribute8 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE;
676: l_attribute9 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE;
677: l_attribute10 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE;
678: l_attribute11 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE;
679: l_attribute12 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE;
680: l_attribute13 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE;

Line 677: l_attribute10 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE;

673: l_attribute6 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE6%TYPE;
674: l_attribute7 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE;
675: l_attribute8 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE;
676: l_attribute9 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE;
677: l_attribute10 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE;
678: l_attribute11 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE;
679: l_attribute12 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE;
680: l_attribute13 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE;
681: l_attribute14 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE;

Line 678: l_attribute11 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE;

674: l_attribute7 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE7%TYPE;
675: l_attribute8 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE;
676: l_attribute9 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE;
677: l_attribute10 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE;
678: l_attribute11 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE;
679: l_attribute12 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE;
680: l_attribute13 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE;
681: l_attribute14 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE;
682: l_attribute15 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE;

Line 679: l_attribute12 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE;

675: l_attribute8 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE8%TYPE;
676: l_attribute9 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE;
677: l_attribute10 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE;
678: l_attribute11 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE;
679: l_attribute12 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE;
680: l_attribute13 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE;
681: l_attribute14 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE;
682: l_attribute15 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE;
683: l_attribute_category JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE;

Line 680: l_attribute13 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE;

676: l_attribute9 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE9%TYPE;
677: l_attribute10 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE;
678: l_attribute11 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE;
679: l_attribute12 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE;
680: l_attribute13 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE;
681: l_attribute14 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE;
682: l_attribute15 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE;
683: l_attribute_category JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE;
684: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;

Line 681: l_attribute14 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE;

677: l_attribute10 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE10%TYPE;
678: l_attribute11 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE;
679: l_attribute12 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE;
680: l_attribute13 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE;
681: l_attribute14 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE;
682: l_attribute15 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE;
683: l_attribute_category JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE;
684: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
685: l_resource_number JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE;

Line 682: l_attribute15 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE;

678: l_attribute11 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE11%TYPE;
679: l_attribute12 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE;
680: l_attribute13 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE;
681: l_attribute14 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE;
682: l_attribute15 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE;
683: l_attribute_category JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE;
684: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
685: l_resource_number JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE;
686: l_source_name JTF_RS_RESOURCE_EXTNS.source_name%TYPE;

Line 683: l_attribute_category JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE;

679: l_attribute12 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE12%TYPE;
680: l_attribute13 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE;
681: l_attribute14 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE;
682: l_attribute15 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE;
683: l_attribute_category JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE;
684: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
685: l_resource_number JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE;
686: l_source_name JTF_RS_RESOURCE_EXTNS.source_name%TYPE;
687: l_category JTF_RS_RESOURCE_EXTNS.category%TYPE;

Line 684: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;

680: l_attribute13 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE13%TYPE;
681: l_attribute14 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE;
682: l_attribute15 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE;
683: l_attribute_category JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE;
684: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
685: l_resource_number JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE;
686: l_source_name JTF_RS_RESOURCE_EXTNS.source_name%TYPE;
687: l_category JTF_RS_RESOURCE_EXTNS.category%TYPE;
688: l_debug_prefix VARCHAR2(30) := 'RS_UPD:';

Line 685: l_resource_number JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE;

681: l_attribute14 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE14%TYPE;
682: l_attribute15 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE;
683: l_attribute_category JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE;
684: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
685: l_resource_number JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE;
686: l_source_name JTF_RS_RESOURCE_EXTNS.source_name%TYPE;
687: l_category JTF_RS_RESOURCE_EXTNS.category%TYPE;
688: l_debug_prefix VARCHAR2(30) := 'RS_UPD:';
689: l_batch_id NUMBER;

Line 686: l_source_name JTF_RS_RESOURCE_EXTNS.source_name%TYPE;

682: l_attribute15 JTF_RS_RESOURCE_EXTNS.ATTRIBUTE15%TYPE;
683: l_attribute_category JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE;
684: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
685: l_resource_number JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE;
686: l_source_name JTF_RS_RESOURCE_EXTNS.source_name%TYPE;
687: l_category JTF_RS_RESOURCE_EXTNS.category%TYPE;
688: l_debug_prefix VARCHAR2(30) := 'RS_UPD:';
689: l_batch_id NUMBER;
690:

Line 687: l_category JTF_RS_RESOURCE_EXTNS.category%TYPE;

683: l_attribute_category JTF_RS_RESOURCE_EXTNS.ATTRIBUTE_CATEGORY%TYPE;
684: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
685: l_resource_number JTF_RS_RESOURCE_EXTNS.RESOURCE_NUMBER%TYPE;
686: l_source_name JTF_RS_RESOURCE_EXTNS.source_name%TYPE;
687: l_category JTF_RS_RESOURCE_EXTNS.category%TYPE;
688: l_debug_prefix VARCHAR2(30) := 'RS_UPD:';
689: l_batch_id NUMBER;
690:
691: l_return_status VARCHAR2(1);

Line 735: UPDATE jtf_rs_resource_extns_int

731: -- Get translated value for 'Resource Id cannot be null in Update mode.'
732:
733: l_trans_message := fnd_message.get_string('JTF','JTF_RS_RESOURCE_ID_NULL');
734:
735: UPDATE jtf_rs_resource_extns_int
736: SET operation_status = l_status_error,
737: operation_message = l_trans_message,
738: operation_process_date = SYSDATE
739: WHERE batch_id = p_batch_id AND

Line 765: UPDATE jtf_rs_resource_extns_int rs_int

761: -- Get translated value for 'Resource Id is not valid'
762:
763: l_trans_message := fnd_message.get_string('JTF','JTF_RS_RES_ID_INVALID');
764:
765: UPDATE jtf_rs_resource_extns_int rs_int
766: SET operation_status = l_status_error,
767: operation_message = l_trans_message,
768: operation_process_date = SYSDATE
769: WHERE batch_id = p_batch_id AND

Line 774: (SELECT 1 FROM jtf_rs_resource_extns rs

770: operation = 'UPDATE' AND
771: operation_status IS NULL AND
772: resource_id IS NOT NULL
773: AND NOT EXISTS
774: (SELECT 1 FROM jtf_rs_resource_extns rs
775: WHERE rs.resource_id = rs_int.resource_id);
776:
777: -- Get the number of rows updated
778: l_commit_count := l_commit_count + SQL%ROWCOUNT ;

Line 804: UPDATE jtf_rs_resource_extns_int rs_int

800: fnd_msg_pub.add;
801:
802: l_trans_message := FND_MSG_PUB.Get( p_encoded => FND_API.G_FALSE);
803:
804: UPDATE jtf_rs_resource_extns_int rs_int
805: SET operation_status = l_status_error,
806: operation_message = l_trans_message,
807: operation_process_date = SYSDATE
808: WHERE batch_id = p_batch_id AND

Line 813: (SELECT 1 FROM jtf_rs_resource_extns rs

809: operation = 'UPDATE' AND
810: operation_status IS NULL AND
811: resource_id IS NOT NULL
812: AND NOT EXISTS
813: (SELECT 1 FROM jtf_rs_resource_extns rs
814: WHERE rs.resource_id = rs_int.resource_id
815: AND rs.category = 'OTHER' );
816:
817: -- Get the number of rows updated

Line 854: UPDATE jtf_rs_resource_extns_int

850: fnd_msg_pub.add;
851:
852: l_trans_message := FND_MSG_PUB.Get( p_encoded => FND_API.G_FALSE);
853:
854: UPDATE jtf_rs_resource_extns_int
855: SET operation_status = l_status_error,
856: operation_message = l_trans_message,
857: operation_process_date = SYSDATE
858: WHERE batch_id = p_batch_id AND

Line 891: UPDATE jtf_rs_resource_extns_int

887: -- Get translated value for 'Start Date Active cannot be null'
888: l_trans_message := fnd_message.get_string('JTF','JTF_RS_START_DATE_NULL');
889:
890: --'Active Start Date should not be updated to NULL.'
891: UPDATE jtf_rs_resource_extns_int
892: SET operation_status = l_status_error,
893: operation_message = l_trans_message,
894: operation_process_date = SYSDATE
895: WHERE batch_id = p_batch_id AND

Line 948: FROM jtf_rs_resource_extns

944:
945: --Get Object Version Number and End Date Active.
946: SELECT object_version_number,end_date_active,start_date_active
947: INTO l_object_version_number,l_end_date_active_db,l_start_date_active_db
948: FROM jtf_rs_resource_extns
949: WHERE resource_id = l_resource_id;
950:
951: -- If Start Date Active is NULL then we are getting l_miss_date into l_start_date.
952: -- While validating Input dates l_miss_date is always greater than equal to

Line 1005: UPDATE jtf_rs_resource_extns_int

1001:
1002: l_trans_message := fnd_message.get_string('JTF','JTF_RS_ERR_STDT_GREATER_EDDT');
1003:
1004: --'Date values should be valid'
1005: UPDATE jtf_rs_resource_extns_int
1006: SET operation_status = l_return_status,
1007: operation_message = l_trans_message,
1008: operation_process_date = SYSDATE
1009: WHERE interface_id = l_interface_id;

Line 1129: UPDATE jtf_rs_resource_extns_int

1125: ---- End of Message data reading logic
1126:
1127: --When return status is success then update Status to Interface Table.
1128: IF l_return_status = l_status_success THEN
1129: UPDATE jtf_rs_resource_extns_int
1130: SET operation_status = l_status_success,
1131: operation_process_date = SYSDATE
1132: WHERE interface_id = l_interface_id;
1133: ELSE-- When return status is NOT success then update Error details to Interface Table.

Line 1134: UPDATE jtf_rs_resource_extns_int

1130: SET operation_status = l_status_success,
1131: operation_process_date = SYSDATE
1132: WHERE interface_id = l_interface_id;
1133: ELSE-- When return status is NOT success then update Error details to Interface Table.
1134: UPDATE jtf_rs_resource_extns_int
1135: SET operation_status = l_return_status,
1136: operation_message = l_msg_data1,
1137: operation_process_date = SYSDATE
1138: WHERE interface_id = l_interface_id;

Line 1229: UPDATE jtf_rs_resource_extns_int

1225:
1226:
1227: --When return status is success then update Status to Interface Table.
1228: IF l_return_status = l_status_success THEN
1229: UPDATE jtf_rs_resource_extns_int
1230: SET operation_status = l_status_success,
1231: operation_process_date = SYSDATE
1232: WHERE interface_id = l_interface_id;
1233: ELSE-- When return status is NOT success then update Error details to Interface Table.

Line 1240: UPDATE jtf_rs_resource_extns_int

1236: debug(p_message=>'Error in Update Resource loop at Resource Id,Batch Id, Interface Id : '||l_resource_id||' '||l_batch_id||' '||l_interface_id,
1237: p_prefix =>l_debug_prefix,
1238: p_msg_level=>fnd_log.level_statement);
1239: END IF;
1240: UPDATE jtf_rs_resource_extns_int
1241: SET operation_status = l_return_status,
1242: operation_message = l_msg_data1,
1243: operation_process_date = SYSDATE
1244: WHERE interface_id = l_interface_id;

Line 1303: UPDATE jtf_rs_resource_extns_int

1299:
1300:
1301: --When return status is success then update Status to Interface Table.
1302: IF l_return_status = l_status_success THEN
1303: UPDATE jtf_rs_resource_extns_int
1304: SET operation_status = l_status_success,
1305: operation_process_date = SYSDATE
1306: WHERE interface_id = l_interface_id;
1307: ELSE-- When return status is NOT success then update Error details to Interface Table.

Line 1308: UPDATE jtf_rs_resource_extns_int

1304: SET operation_status = l_status_success,
1305: operation_process_date = SYSDATE
1306: WHERE interface_id = l_interface_id;
1307: ELSE-- When return status is NOT success then update Error details to Interface Table.
1308: UPDATE jtf_rs_resource_extns_int
1309: SET operation_status = l_return_status,
1310: operation_message = l_msg_data1,
1311: operation_process_date = SYSDATE
1312: WHERE interface_id = l_interface_id;

Line 1402: UPDATE jtf_rs_resource_extns_int

1398: ---- End of Message data reading logic
1399:
1400: --When return status is success then update Status to Interface Table.
1401: IF l_return_status = l_status_success THEN
1402: UPDATE jtf_rs_resource_extns_int
1403: SET operation_status = l_status_success,
1404: operation_process_date = SYSDATE
1405: WHERE interface_id = l_interface_id;
1406: ELSE-- When return status is NOT success then update Error details to Interface Table.

Line 1407: UPDATE jtf_rs_resource_extns_int

1403: SET operation_status = l_status_success,
1404: operation_process_date = SYSDATE
1405: WHERE interface_id = l_interface_id;
1406: ELSE-- When return status is NOT success then update Error details to Interface Table.
1407: UPDATE jtf_rs_resource_extns_int
1408: SET operation_status = l_return_status,
1409: operation_message = l_msg_data1,
1410: operation_process_date = SYSDATE
1411: WHERE interface_id = l_interface_id;

Line 1442: UPDATE jtf_rs_resource_extns_int

1438: END IF;
1439:
1440: ROLLBACK TO do_create_resource_loop;
1441:
1442: UPDATE jtf_rs_resource_extns_int
1443: SET operation_status = l_return_status,
1444: operation_message = l_msg_data1,
1445: operation_process_date = SYSDATE
1446: WHERE interface_id = l_interface_id;

Line 1555: l_start_date_active DATE;--JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE;

1551: l_set_of_books_id JTF_RS_SALESREPS.set_of_books_id%TYPE;
1552: l_sales_tax_geocode JTF_RS_SALESREPS.sales_tax_geocode%TYPE;
1553: l_sales_tax_inside_city_limits JTF_RS_SALESREPS.sales_tax_inside_city_limits%TYPE;
1554: x_salesrep_id JTF_RS_SALESREPS.salesrep_id%TYPE;
1555: l_start_date_active DATE;--JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE;
1556: l_end_date_active JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE;
1557: l_interface_id JTF_RS_RESOURCE_EXTNS_INT.INTERFACE_ID%TYPE;
1558: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
1559: l_commit_count NUMBER ;

Line 1556: l_end_date_active JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE;

1552: l_sales_tax_geocode JTF_RS_SALESREPS.sales_tax_geocode%TYPE;
1553: l_sales_tax_inside_city_limits JTF_RS_SALESREPS.sales_tax_inside_city_limits%TYPE;
1554: x_salesrep_id JTF_RS_SALESREPS.salesrep_id%TYPE;
1555: l_start_date_active DATE;--JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE;
1556: l_end_date_active JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE;
1557: l_interface_id JTF_RS_RESOURCE_EXTNS_INT.INTERFACE_ID%TYPE;
1558: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
1559: l_commit_count NUMBER ;
1560: l_api_name VARCHAR2(30);

Line 1557: l_interface_id JTF_RS_RESOURCE_EXTNS_INT.INTERFACE_ID%TYPE;

1553: l_sales_tax_inside_city_limits JTF_RS_SALESREPS.sales_tax_inside_city_limits%TYPE;
1554: x_salesrep_id JTF_RS_SALESREPS.salesrep_id%TYPE;
1555: l_start_date_active DATE;--JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE;
1556: l_end_date_active JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE;
1557: l_interface_id JTF_RS_RESOURCE_EXTNS_INT.INTERFACE_ID%TYPE;
1558: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
1559: l_commit_count NUMBER ;
1560: l_api_name VARCHAR2(30);
1561: l_init_msg_list VARCHAR2(1);

Line 1558: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;

1554: x_salesrep_id JTF_RS_SALESREPS.salesrep_id%TYPE;
1555: l_start_date_active DATE;--JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE;
1556: l_end_date_active JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE;
1557: l_interface_id JTF_RS_RESOURCE_EXTNS_INT.INTERFACE_ID%TYPE;
1558: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
1559: l_commit_count NUMBER ;
1560: l_api_name VARCHAR2(30);
1561: l_init_msg_list VARCHAR2(1);
1562: l_commit VARCHAR2(1);

Line 1902: l_object_version_number JTF_RS_RESOURCE_EXTNS.OBJECT_VERSION_NUMBER%TYPE;

1898: l_gl_id_rec JTF_RS_SALESREPS.gl_id_rec%TYPE;
1899: l_set_of_books_id JTF_RS_SALESREPS.set_of_books_id%TYPE;
1900: l_sales_tax_geocode JTF_RS_SALESREPS.sales_tax_geocode%TYPE;
1901: l_sales_tax_inside_city_limits JTF_RS_SALESREPS.sales_tax_inside_city_limits%TYPE;
1902: l_object_version_number JTF_RS_RESOURCE_EXTNS.OBJECT_VERSION_NUMBER%TYPE;
1903: l_start_date_active JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE;
1904: l_end_date_active JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE;
1905: l_interface_id JTF_RS_RESOURCE_EXTNS_INT.INTERFACE_ID%TYPE;
1906: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;

Line 1903: l_start_date_active JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE;

1899: l_set_of_books_id JTF_RS_SALESREPS.set_of_books_id%TYPE;
1900: l_sales_tax_geocode JTF_RS_SALESREPS.sales_tax_geocode%TYPE;
1901: l_sales_tax_inside_city_limits JTF_RS_SALESREPS.sales_tax_inside_city_limits%TYPE;
1902: l_object_version_number JTF_RS_RESOURCE_EXTNS.OBJECT_VERSION_NUMBER%TYPE;
1903: l_start_date_active JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE;
1904: l_end_date_active JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE;
1905: l_interface_id JTF_RS_RESOURCE_EXTNS_INT.INTERFACE_ID%TYPE;
1906: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
1907: l_commit_count NUMBER ;

Line 1904: l_end_date_active JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE;

1900: l_sales_tax_geocode JTF_RS_SALESREPS.sales_tax_geocode%TYPE;
1901: l_sales_tax_inside_city_limits JTF_RS_SALESREPS.sales_tax_inside_city_limits%TYPE;
1902: l_object_version_number JTF_RS_RESOURCE_EXTNS.OBJECT_VERSION_NUMBER%TYPE;
1903: l_start_date_active JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE;
1904: l_end_date_active JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE;
1905: l_interface_id JTF_RS_RESOURCE_EXTNS_INT.INTERFACE_ID%TYPE;
1906: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
1907: l_commit_count NUMBER ;
1908: l_api_name VARCHAR2(30);

Line 1905: l_interface_id JTF_RS_RESOURCE_EXTNS_INT.INTERFACE_ID%TYPE;

1901: l_sales_tax_inside_city_limits JTF_RS_SALESREPS.sales_tax_inside_city_limits%TYPE;
1902: l_object_version_number JTF_RS_RESOURCE_EXTNS.OBJECT_VERSION_NUMBER%TYPE;
1903: l_start_date_active JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE;
1904: l_end_date_active JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE;
1905: l_interface_id JTF_RS_RESOURCE_EXTNS_INT.INTERFACE_ID%TYPE;
1906: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
1907: l_commit_count NUMBER ;
1908: l_api_name VARCHAR2(30);
1909: l_init_msg_list VARCHAR2(1);

Line 1906: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;

1902: l_object_version_number JTF_RS_RESOURCE_EXTNS.OBJECT_VERSION_NUMBER%TYPE;
1903: l_start_date_active JTF_RS_RESOURCE_EXTNS.START_DATE_ACTIVE%TYPE;
1904: l_end_date_active JTF_RS_RESOURCE_EXTNS.END_DATE_ACTIVE%TYPE;
1905: l_interface_id JTF_RS_RESOURCE_EXTNS_INT.INTERFACE_ID%TYPE;
1906: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
1907: l_commit_count NUMBER ;
1908: l_api_name VARCHAR2(30);
1909: l_init_msg_list VARCHAR2(1);
1910: l_commit VARCHAR2(1);