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_WF_EVENTS_PUB dependencies on JTF_RS_RESOURCE_EXTNS

Line 44: l_resource_id jtf_rs_resource_extns.resource_id%type := p_resource_id;

40: l_list WF_PARAMETER_LIST_T;
41: l_key varchar2(240);
42: l_exist varchar2(30);
43: l_event_name varchar2(240) := 'oracle.apps.jtf.jres.resource.create';
44: l_resource_id jtf_rs_resource_extns.resource_id%type := p_resource_id;
45: l_resource_name jtf_rs_resource_extns_vl.resource_name%type := p_resource_name;
46: l_category jtf_rs_resource_extns.category%type := p_category;
47: l_start_date_active jtf_rs_resource_extns.start_date_active%type := trunc(p_start_date_active);
48: l_end_date_active jtf_rs_resource_extns.end_date_active%type := trunc(p_end_date_active);

Line 45: l_resource_name jtf_rs_resource_extns_vl.resource_name%type := p_resource_name;

41: l_key varchar2(240);
42: l_exist varchar2(30);
43: l_event_name varchar2(240) := 'oracle.apps.jtf.jres.resource.create';
44: l_resource_id jtf_rs_resource_extns.resource_id%type := p_resource_id;
45: l_resource_name jtf_rs_resource_extns_vl.resource_name%type := p_resource_name;
46: l_category jtf_rs_resource_extns.category%type := p_category;
47: l_start_date_active jtf_rs_resource_extns.start_date_active%type := trunc(p_start_date_active);
48: l_end_date_active jtf_rs_resource_extns.end_date_active%type := trunc(p_end_date_active);
49: l_user_id jtf_rs_resource_extns.user_id%type := p_user_id;

Line 46: l_category jtf_rs_resource_extns.category%type := p_category;

42: l_exist varchar2(30);
43: l_event_name varchar2(240) := 'oracle.apps.jtf.jres.resource.create';
44: l_resource_id jtf_rs_resource_extns.resource_id%type := p_resource_id;
45: l_resource_name jtf_rs_resource_extns_vl.resource_name%type := p_resource_name;
46: l_category jtf_rs_resource_extns.category%type := p_category;
47: l_start_date_active jtf_rs_resource_extns.start_date_active%type := trunc(p_start_date_active);
48: l_end_date_active jtf_rs_resource_extns.end_date_active%type := trunc(p_end_date_active);
49: l_user_id jtf_rs_resource_extns.user_id%type := p_user_id;
50:

Line 47: l_start_date_active jtf_rs_resource_extns.start_date_active%type := trunc(p_start_date_active);

43: l_event_name varchar2(240) := 'oracle.apps.jtf.jres.resource.create';
44: l_resource_id jtf_rs_resource_extns.resource_id%type := p_resource_id;
45: l_resource_name jtf_rs_resource_extns_vl.resource_name%type := p_resource_name;
46: l_category jtf_rs_resource_extns.category%type := p_category;
47: l_start_date_active jtf_rs_resource_extns.start_date_active%type := trunc(p_start_date_active);
48: l_end_date_active jtf_rs_resource_extns.end_date_active%type := trunc(p_end_date_active);
49: l_user_id jtf_rs_resource_extns.user_id%type := p_user_id;
50:
51: BEGIN

Line 48: l_end_date_active jtf_rs_resource_extns.end_date_active%type := trunc(p_end_date_active);

44: l_resource_id jtf_rs_resource_extns.resource_id%type := p_resource_id;
45: l_resource_name jtf_rs_resource_extns_vl.resource_name%type := p_resource_name;
46: l_category jtf_rs_resource_extns.category%type := p_category;
47: l_start_date_active jtf_rs_resource_extns.start_date_active%type := trunc(p_start_date_active);
48: l_end_date_active jtf_rs_resource_extns.end_date_active%type := trunc(p_end_date_active);
49: l_user_id jtf_rs_resource_extns.user_id%type := p_user_id;
50:
51: BEGIN
52:

Line 49: l_user_id jtf_rs_resource_extns.user_id%type := p_user_id;

45: l_resource_name jtf_rs_resource_extns_vl.resource_name%type := p_resource_name;
46: l_category jtf_rs_resource_extns.category%type := p_category;
47: l_start_date_active jtf_rs_resource_extns.start_date_active%type := trunc(p_start_date_active);
48: l_end_date_active jtf_rs_resource_extns.end_date_active%type := trunc(p_end_date_active);
49: l_user_id jtf_rs_resource_extns.user_id%type := p_user_id;
50:
51: BEGIN
52:
53: x_return_status := fnd_api.g_ret_sts_success;

Line 112: l_resource_id jtf_rs_resource_extns.resource_id%type := p_resource_id;

108: l_list WF_PARAMETER_LIST_T;
109: l_key varchar2(240);
110: l_exist varchar2(30);
111: l_event_name varchar2(240) := 'oracle.apps.jtf.jres.resource.merge';
112: l_resource_id jtf_rs_resource_extns.resource_id%type := p_resource_id;
113: l_repl_resource_id jtf_rs_resource_extns.resource_id%type := p_repl_resource_id;
114: l_end_date_active jtf_rs_resource_extns.end_date_active%type := trunc(p_end_date_active);
115:
116: BEGIN

Line 113: l_repl_resource_id jtf_rs_resource_extns.resource_id%type := p_repl_resource_id;

109: l_key varchar2(240);
110: l_exist varchar2(30);
111: l_event_name varchar2(240) := 'oracle.apps.jtf.jres.resource.merge';
112: l_resource_id jtf_rs_resource_extns.resource_id%type := p_resource_id;
113: l_repl_resource_id jtf_rs_resource_extns.resource_id%type := p_repl_resource_id;
114: l_end_date_active jtf_rs_resource_extns.end_date_active%type := trunc(p_end_date_active);
115:
116: BEGIN
117:

Line 114: l_end_date_active jtf_rs_resource_extns.end_date_active%type := trunc(p_end_date_active);

110: l_exist varchar2(30);
111: l_event_name varchar2(240) := 'oracle.apps.jtf.jres.resource.merge';
112: l_resource_id jtf_rs_resource_extns.resource_id%type := p_resource_id;
113: l_repl_resource_id jtf_rs_resource_extns.resource_id%type := p_repl_resource_id;
114: l_end_date_active jtf_rs_resource_extns.end_date_active%type := trunc(p_end_date_active);
115:
116: BEGIN
117:
118: x_return_status := fnd_api.g_ret_sts_success;

Line 175: l_resource_id jtf_rs_resource_extns.resource_id%type := p_resource_rec.resource_id;

171: l_list WF_PARAMETER_LIST_T;
172: l_key varchar2(240);
173: l_exist varchar2(30);
174: l_event_name varchar2(240);
175: l_resource_id jtf_rs_resource_extns.resource_id%type := p_resource_rec.resource_id;
176: l_category jtf_rs_resource_extns.category%type := p_resource_rec.category;
177: l_new_resource_name jtf_rs_resource_extns_vl.resource_name%type := p_resource_rec.resource_name;
178: l_new_start_date_active jtf_rs_resource_extns.start_date_active%type := trunc(p_resource_rec.start_date_active);
179: l_new_end_date_active jtf_rs_resource_extns.end_date_active%type := trunc(p_resource_rec.end_date_active);

Line 176: l_category jtf_rs_resource_extns.category%type := p_resource_rec.category;

172: l_key varchar2(240);
173: l_exist varchar2(30);
174: l_event_name varchar2(240);
175: l_resource_id jtf_rs_resource_extns.resource_id%type := p_resource_rec.resource_id;
176: l_category jtf_rs_resource_extns.category%type := p_resource_rec.category;
177: l_new_resource_name jtf_rs_resource_extns_vl.resource_name%type := p_resource_rec.resource_name;
178: l_new_start_date_active jtf_rs_resource_extns.start_date_active%type := trunc(p_resource_rec.start_date_active);
179: l_new_end_date_active jtf_rs_resource_extns.end_date_active%type := trunc(p_resource_rec.end_date_active);
180: l_new_user_id jtf_rs_resource_extns.user_id%type := p_resource_rec.user_id;

Line 177: l_new_resource_name jtf_rs_resource_extns_vl.resource_name%type := p_resource_rec.resource_name;

173: l_exist varchar2(30);
174: l_event_name varchar2(240);
175: l_resource_id jtf_rs_resource_extns.resource_id%type := p_resource_rec.resource_id;
176: l_category jtf_rs_resource_extns.category%type := p_resource_rec.category;
177: l_new_resource_name jtf_rs_resource_extns_vl.resource_name%type := p_resource_rec.resource_name;
178: l_new_start_date_active jtf_rs_resource_extns.start_date_active%type := trunc(p_resource_rec.start_date_active);
179: l_new_end_date_active jtf_rs_resource_extns.end_date_active%type := trunc(p_resource_rec.end_date_active);
180: l_new_user_id jtf_rs_resource_extns.user_id%type := p_resource_rec.user_id;
181: l_new_time_zone jtf_rs_resource_extns.time_zone%type := p_resource_rec.time_zone;

Line 178: l_new_start_date_active jtf_rs_resource_extns.start_date_active%type := trunc(p_resource_rec.start_date_active);

174: l_event_name varchar2(240);
175: l_resource_id jtf_rs_resource_extns.resource_id%type := p_resource_rec.resource_id;
176: l_category jtf_rs_resource_extns.category%type := p_resource_rec.category;
177: l_new_resource_name jtf_rs_resource_extns_vl.resource_name%type := p_resource_rec.resource_name;
178: l_new_start_date_active jtf_rs_resource_extns.start_date_active%type := trunc(p_resource_rec.start_date_active);
179: l_new_end_date_active jtf_rs_resource_extns.end_date_active%type := trunc(p_resource_rec.end_date_active);
180: l_new_user_id jtf_rs_resource_extns.user_id%type := p_resource_rec.user_id;
181: l_new_time_zone jtf_rs_resource_extns.time_zone%type := p_resource_rec.time_zone;
182: l_new_cost_per_hr jtf_rs_resource_extns.cost_per_hr%type := p_resource_rec.cost_per_hr;

Line 179: l_new_end_date_active jtf_rs_resource_extns.end_date_active%type := trunc(p_resource_rec.end_date_active);

175: l_resource_id jtf_rs_resource_extns.resource_id%type := p_resource_rec.resource_id;
176: l_category jtf_rs_resource_extns.category%type := p_resource_rec.category;
177: l_new_resource_name jtf_rs_resource_extns_vl.resource_name%type := p_resource_rec.resource_name;
178: l_new_start_date_active jtf_rs_resource_extns.start_date_active%type := trunc(p_resource_rec.start_date_active);
179: l_new_end_date_active jtf_rs_resource_extns.end_date_active%type := trunc(p_resource_rec.end_date_active);
180: l_new_user_id jtf_rs_resource_extns.user_id%type := p_resource_rec.user_id;
181: l_new_time_zone jtf_rs_resource_extns.time_zone%type := p_resource_rec.time_zone;
182: l_new_cost_per_hr jtf_rs_resource_extns.cost_per_hr%type := p_resource_rec.cost_per_hr;
183: l_new_primary_language jtf_rs_resource_extns.primary_language%type := p_resource_rec.primary_language;

Line 180: l_new_user_id jtf_rs_resource_extns.user_id%type := p_resource_rec.user_id;

176: l_category jtf_rs_resource_extns.category%type := p_resource_rec.category;
177: l_new_resource_name jtf_rs_resource_extns_vl.resource_name%type := p_resource_rec.resource_name;
178: l_new_start_date_active jtf_rs_resource_extns.start_date_active%type := trunc(p_resource_rec.start_date_active);
179: l_new_end_date_active jtf_rs_resource_extns.end_date_active%type := trunc(p_resource_rec.end_date_active);
180: l_new_user_id jtf_rs_resource_extns.user_id%type := p_resource_rec.user_id;
181: l_new_time_zone jtf_rs_resource_extns.time_zone%type := p_resource_rec.time_zone;
182: l_new_cost_per_hr jtf_rs_resource_extns.cost_per_hr%type := p_resource_rec.cost_per_hr;
183: l_new_primary_language jtf_rs_resource_extns.primary_language%type := p_resource_rec.primary_language;
184: l_new_secondary_language jtf_rs_resource_extns.secondary_language%type := p_resource_rec.secondary_language;

Line 181: l_new_time_zone jtf_rs_resource_extns.time_zone%type := p_resource_rec.time_zone;

177: l_new_resource_name jtf_rs_resource_extns_vl.resource_name%type := p_resource_rec.resource_name;
178: l_new_start_date_active jtf_rs_resource_extns.start_date_active%type := trunc(p_resource_rec.start_date_active);
179: l_new_end_date_active jtf_rs_resource_extns.end_date_active%type := trunc(p_resource_rec.end_date_active);
180: l_new_user_id jtf_rs_resource_extns.user_id%type := p_resource_rec.user_id;
181: l_new_time_zone jtf_rs_resource_extns.time_zone%type := p_resource_rec.time_zone;
182: l_new_cost_per_hr jtf_rs_resource_extns.cost_per_hr%type := p_resource_rec.cost_per_hr;
183: l_new_primary_language jtf_rs_resource_extns.primary_language%type := p_resource_rec.primary_language;
184: l_new_secondary_language jtf_rs_resource_extns.secondary_language%type := p_resource_rec.secondary_language;
185: l_new_ies_agent_login jtf_rs_resource_extns.ies_agent_login%type := p_resource_rec.ies_agent_login;

Line 182: l_new_cost_per_hr jtf_rs_resource_extns.cost_per_hr%type := p_resource_rec.cost_per_hr;

178: l_new_start_date_active jtf_rs_resource_extns.start_date_active%type := trunc(p_resource_rec.start_date_active);
179: l_new_end_date_active jtf_rs_resource_extns.end_date_active%type := trunc(p_resource_rec.end_date_active);
180: l_new_user_id jtf_rs_resource_extns.user_id%type := p_resource_rec.user_id;
181: l_new_time_zone jtf_rs_resource_extns.time_zone%type := p_resource_rec.time_zone;
182: l_new_cost_per_hr jtf_rs_resource_extns.cost_per_hr%type := p_resource_rec.cost_per_hr;
183: l_new_primary_language jtf_rs_resource_extns.primary_language%type := p_resource_rec.primary_language;
184: l_new_secondary_language jtf_rs_resource_extns.secondary_language%type := p_resource_rec.secondary_language;
185: l_new_ies_agent_login jtf_rs_resource_extns.ies_agent_login%type := p_resource_rec.ies_agent_login;
186: l_new_server_group_id jtf_rs_resource_extns.server_group_id%type := p_resource_rec.server_group_id;

Line 183: l_new_primary_language jtf_rs_resource_extns.primary_language%type := p_resource_rec.primary_language;

179: l_new_end_date_active jtf_rs_resource_extns.end_date_active%type := trunc(p_resource_rec.end_date_active);
180: l_new_user_id jtf_rs_resource_extns.user_id%type := p_resource_rec.user_id;
181: l_new_time_zone jtf_rs_resource_extns.time_zone%type := p_resource_rec.time_zone;
182: l_new_cost_per_hr jtf_rs_resource_extns.cost_per_hr%type := p_resource_rec.cost_per_hr;
183: l_new_primary_language jtf_rs_resource_extns.primary_language%type := p_resource_rec.primary_language;
184: l_new_secondary_language jtf_rs_resource_extns.secondary_language%type := p_resource_rec.secondary_language;
185: l_new_ies_agent_login jtf_rs_resource_extns.ies_agent_login%type := p_resource_rec.ies_agent_login;
186: l_new_server_group_id jtf_rs_resource_extns.server_group_id%type := p_resource_rec.server_group_id;
187: l_new_assigned_to_group_id jtf_rs_resource_extns.assigned_to_group_id%type := p_resource_rec.assigned_to_group_id;

Line 184: l_new_secondary_language jtf_rs_resource_extns.secondary_language%type := p_resource_rec.secondary_language;

180: l_new_user_id jtf_rs_resource_extns.user_id%type := p_resource_rec.user_id;
181: l_new_time_zone jtf_rs_resource_extns.time_zone%type := p_resource_rec.time_zone;
182: l_new_cost_per_hr jtf_rs_resource_extns.cost_per_hr%type := p_resource_rec.cost_per_hr;
183: l_new_primary_language jtf_rs_resource_extns.primary_language%type := p_resource_rec.primary_language;
184: l_new_secondary_language jtf_rs_resource_extns.secondary_language%type := p_resource_rec.secondary_language;
185: l_new_ies_agent_login jtf_rs_resource_extns.ies_agent_login%type := p_resource_rec.ies_agent_login;
186: l_new_server_group_id jtf_rs_resource_extns.server_group_id%type := p_resource_rec.server_group_id;
187: l_new_assigned_to_group_id jtf_rs_resource_extns.assigned_to_group_id%type := p_resource_rec.assigned_to_group_id;
188: l_new_cost_center jtf_rs_resource_extns.cost_center%type := p_resource_rec.cost_center;

Line 185: l_new_ies_agent_login jtf_rs_resource_extns.ies_agent_login%type := p_resource_rec.ies_agent_login;

181: l_new_time_zone jtf_rs_resource_extns.time_zone%type := p_resource_rec.time_zone;
182: l_new_cost_per_hr jtf_rs_resource_extns.cost_per_hr%type := p_resource_rec.cost_per_hr;
183: l_new_primary_language jtf_rs_resource_extns.primary_language%type := p_resource_rec.primary_language;
184: l_new_secondary_language jtf_rs_resource_extns.secondary_language%type := p_resource_rec.secondary_language;
185: l_new_ies_agent_login jtf_rs_resource_extns.ies_agent_login%type := p_resource_rec.ies_agent_login;
186: l_new_server_group_id jtf_rs_resource_extns.server_group_id%type := p_resource_rec.server_group_id;
187: l_new_assigned_to_group_id jtf_rs_resource_extns.assigned_to_group_id%type := p_resource_rec.assigned_to_group_id;
188: l_new_cost_center jtf_rs_resource_extns.cost_center%type := p_resource_rec.cost_center;
189: l_new_charge_to_cost_center jtf_rs_resource_extns.charge_to_cost_center%type := p_resource_rec.charge_to_cost_center;

Line 186: l_new_server_group_id jtf_rs_resource_extns.server_group_id%type := p_resource_rec.server_group_id;

182: l_new_cost_per_hr jtf_rs_resource_extns.cost_per_hr%type := p_resource_rec.cost_per_hr;
183: l_new_primary_language jtf_rs_resource_extns.primary_language%type := p_resource_rec.primary_language;
184: l_new_secondary_language jtf_rs_resource_extns.secondary_language%type := p_resource_rec.secondary_language;
185: l_new_ies_agent_login jtf_rs_resource_extns.ies_agent_login%type := p_resource_rec.ies_agent_login;
186: l_new_server_group_id jtf_rs_resource_extns.server_group_id%type := p_resource_rec.server_group_id;
187: l_new_assigned_to_group_id jtf_rs_resource_extns.assigned_to_group_id%type := p_resource_rec.assigned_to_group_id;
188: l_new_cost_center jtf_rs_resource_extns.cost_center%type := p_resource_rec.cost_center;
189: l_new_charge_to_cost_center jtf_rs_resource_extns.charge_to_cost_center%type := p_resource_rec.charge_to_cost_center;
190: l_new_comp_currency_code jtf_rs_resource_extns.compensation_currency_code%type := p_resource_rec.comp_currency_code;

Line 187: l_new_assigned_to_group_id jtf_rs_resource_extns.assigned_to_group_id%type := p_resource_rec.assigned_to_group_id;

183: l_new_primary_language jtf_rs_resource_extns.primary_language%type := p_resource_rec.primary_language;
184: l_new_secondary_language jtf_rs_resource_extns.secondary_language%type := p_resource_rec.secondary_language;
185: l_new_ies_agent_login jtf_rs_resource_extns.ies_agent_login%type := p_resource_rec.ies_agent_login;
186: l_new_server_group_id jtf_rs_resource_extns.server_group_id%type := p_resource_rec.server_group_id;
187: l_new_assigned_to_group_id jtf_rs_resource_extns.assigned_to_group_id%type := p_resource_rec.assigned_to_group_id;
188: l_new_cost_center jtf_rs_resource_extns.cost_center%type := p_resource_rec.cost_center;
189: l_new_charge_to_cost_center jtf_rs_resource_extns.charge_to_cost_center%type := p_resource_rec.charge_to_cost_center;
190: l_new_comp_currency_code jtf_rs_resource_extns.compensation_currency_code%type := p_resource_rec.comp_currency_code;
191: l_new_commissionable_flag jtf_rs_resource_extns.commissionable_flag%type := p_resource_rec.commissionable_flag;

Line 188: l_new_cost_center jtf_rs_resource_extns.cost_center%type := p_resource_rec.cost_center;

184: l_new_secondary_language jtf_rs_resource_extns.secondary_language%type := p_resource_rec.secondary_language;
185: l_new_ies_agent_login jtf_rs_resource_extns.ies_agent_login%type := p_resource_rec.ies_agent_login;
186: l_new_server_group_id jtf_rs_resource_extns.server_group_id%type := p_resource_rec.server_group_id;
187: l_new_assigned_to_group_id jtf_rs_resource_extns.assigned_to_group_id%type := p_resource_rec.assigned_to_group_id;
188: l_new_cost_center jtf_rs_resource_extns.cost_center%type := p_resource_rec.cost_center;
189: l_new_charge_to_cost_center jtf_rs_resource_extns.charge_to_cost_center%type := p_resource_rec.charge_to_cost_center;
190: l_new_comp_currency_code jtf_rs_resource_extns.compensation_currency_code%type := p_resource_rec.comp_currency_code;
191: l_new_commissionable_flag jtf_rs_resource_extns.commissionable_flag%type := p_resource_rec.commissionable_flag;
192: l_new_hold_reason_code jtf_rs_resource_extns.hold_reason_code%type := p_resource_rec.hold_reason_code;

Line 189: l_new_charge_to_cost_center jtf_rs_resource_extns.charge_to_cost_center%type := p_resource_rec.charge_to_cost_center;

185: l_new_ies_agent_login jtf_rs_resource_extns.ies_agent_login%type := p_resource_rec.ies_agent_login;
186: l_new_server_group_id jtf_rs_resource_extns.server_group_id%type := p_resource_rec.server_group_id;
187: l_new_assigned_to_group_id jtf_rs_resource_extns.assigned_to_group_id%type := p_resource_rec.assigned_to_group_id;
188: l_new_cost_center jtf_rs_resource_extns.cost_center%type := p_resource_rec.cost_center;
189: l_new_charge_to_cost_center jtf_rs_resource_extns.charge_to_cost_center%type := p_resource_rec.charge_to_cost_center;
190: l_new_comp_currency_code jtf_rs_resource_extns.compensation_currency_code%type := p_resource_rec.comp_currency_code;
191: l_new_commissionable_flag jtf_rs_resource_extns.commissionable_flag%type := p_resource_rec.commissionable_flag;
192: l_new_hold_reason_code jtf_rs_resource_extns.hold_reason_code%type := p_resource_rec.hold_reason_code;
193: l_new_hold_payment jtf_rs_resource_extns.hold_payment%type := p_resource_rec.hold_payment;

Line 190: l_new_comp_currency_code jtf_rs_resource_extns.compensation_currency_code%type := p_resource_rec.comp_currency_code;

186: l_new_server_group_id jtf_rs_resource_extns.server_group_id%type := p_resource_rec.server_group_id;
187: l_new_assigned_to_group_id jtf_rs_resource_extns.assigned_to_group_id%type := p_resource_rec.assigned_to_group_id;
188: l_new_cost_center jtf_rs_resource_extns.cost_center%type := p_resource_rec.cost_center;
189: l_new_charge_to_cost_center jtf_rs_resource_extns.charge_to_cost_center%type := p_resource_rec.charge_to_cost_center;
190: l_new_comp_currency_code jtf_rs_resource_extns.compensation_currency_code%type := p_resource_rec.comp_currency_code;
191: l_new_commissionable_flag jtf_rs_resource_extns.commissionable_flag%type := p_resource_rec.commissionable_flag;
192: l_new_hold_reason_code jtf_rs_resource_extns.hold_reason_code%type := p_resource_rec.hold_reason_code;
193: l_new_hold_payment jtf_rs_resource_extns.hold_payment%type := p_resource_rec.hold_payment;
194: l_new_comp_service_team_id jtf_rs_resource_extns.comp_service_team_id%type := p_resource_rec.comp_service_team_id;

Line 191: l_new_commissionable_flag jtf_rs_resource_extns.commissionable_flag%type := p_resource_rec.commissionable_flag;

187: l_new_assigned_to_group_id jtf_rs_resource_extns.assigned_to_group_id%type := p_resource_rec.assigned_to_group_id;
188: l_new_cost_center jtf_rs_resource_extns.cost_center%type := p_resource_rec.cost_center;
189: l_new_charge_to_cost_center jtf_rs_resource_extns.charge_to_cost_center%type := p_resource_rec.charge_to_cost_center;
190: l_new_comp_currency_code jtf_rs_resource_extns.compensation_currency_code%type := p_resource_rec.comp_currency_code;
191: l_new_commissionable_flag jtf_rs_resource_extns.commissionable_flag%type := p_resource_rec.commissionable_flag;
192: l_new_hold_reason_code jtf_rs_resource_extns.hold_reason_code%type := p_resource_rec.hold_reason_code;
193: l_new_hold_payment jtf_rs_resource_extns.hold_payment%type := p_resource_rec.hold_payment;
194: l_new_comp_service_team_id jtf_rs_resource_extns.comp_service_team_id%type := p_resource_rec.comp_service_team_id;
195: l_new_support_site_id jtf_rs_resource_extns.support_site_id%type := p_resource_rec.support_site_id;

Line 192: l_new_hold_reason_code jtf_rs_resource_extns.hold_reason_code%type := p_resource_rec.hold_reason_code;

188: l_new_cost_center jtf_rs_resource_extns.cost_center%type := p_resource_rec.cost_center;
189: l_new_charge_to_cost_center jtf_rs_resource_extns.charge_to_cost_center%type := p_resource_rec.charge_to_cost_center;
190: l_new_comp_currency_code jtf_rs_resource_extns.compensation_currency_code%type := p_resource_rec.comp_currency_code;
191: l_new_commissionable_flag jtf_rs_resource_extns.commissionable_flag%type := p_resource_rec.commissionable_flag;
192: l_new_hold_reason_code jtf_rs_resource_extns.hold_reason_code%type := p_resource_rec.hold_reason_code;
193: l_new_hold_payment jtf_rs_resource_extns.hold_payment%type := p_resource_rec.hold_payment;
194: l_new_comp_service_team_id jtf_rs_resource_extns.comp_service_team_id%type := p_resource_rec.comp_service_team_id;
195: l_new_support_site_id jtf_rs_resource_extns.support_site_id%type := p_resource_rec.support_site_id;
196:

Line 193: l_new_hold_payment jtf_rs_resource_extns.hold_payment%type := p_resource_rec.hold_payment;

189: l_new_charge_to_cost_center jtf_rs_resource_extns.charge_to_cost_center%type := p_resource_rec.charge_to_cost_center;
190: l_new_comp_currency_code jtf_rs_resource_extns.compensation_currency_code%type := p_resource_rec.comp_currency_code;
191: l_new_commissionable_flag jtf_rs_resource_extns.commissionable_flag%type := p_resource_rec.commissionable_flag;
192: l_new_hold_reason_code jtf_rs_resource_extns.hold_reason_code%type := p_resource_rec.hold_reason_code;
193: l_new_hold_payment jtf_rs_resource_extns.hold_payment%type := p_resource_rec.hold_payment;
194: l_new_comp_service_team_id jtf_rs_resource_extns.comp_service_team_id%type := p_resource_rec.comp_service_team_id;
195: l_new_support_site_id jtf_rs_resource_extns.support_site_id%type := p_resource_rec.support_site_id;
196:
197:

Line 194: l_new_comp_service_team_id jtf_rs_resource_extns.comp_service_team_id%type := p_resource_rec.comp_service_team_id;

190: l_new_comp_currency_code jtf_rs_resource_extns.compensation_currency_code%type := p_resource_rec.comp_currency_code;
191: l_new_commissionable_flag jtf_rs_resource_extns.commissionable_flag%type := p_resource_rec.commissionable_flag;
192: l_new_hold_reason_code jtf_rs_resource_extns.hold_reason_code%type := p_resource_rec.hold_reason_code;
193: l_new_hold_payment jtf_rs_resource_extns.hold_payment%type := p_resource_rec.hold_payment;
194: l_new_comp_service_team_id jtf_rs_resource_extns.comp_service_team_id%type := p_resource_rec.comp_service_team_id;
195: l_new_support_site_id jtf_rs_resource_extns.support_site_id%type := p_resource_rec.support_site_id;
196:
197:
198: cursor res_cur IS

Line 195: l_new_support_site_id jtf_rs_resource_extns.support_site_id%type := p_resource_rec.support_site_id;

191: l_new_commissionable_flag jtf_rs_resource_extns.commissionable_flag%type := p_resource_rec.commissionable_flag;
192: l_new_hold_reason_code jtf_rs_resource_extns.hold_reason_code%type := p_resource_rec.hold_reason_code;
193: l_new_hold_payment jtf_rs_resource_extns.hold_payment%type := p_resource_rec.hold_payment;
194: l_new_comp_service_team_id jtf_rs_resource_extns.comp_service_team_id%type := p_resource_rec.comp_service_team_id;
195: l_new_support_site_id jtf_rs_resource_extns.support_site_id%type := p_resource_rec.support_site_id;
196:
197:
198: cursor res_cur IS
199: select user_id,

Line 218: from jtf_rs_resource_extns_vl

214: hold_reason_code,
215: hold_payment,
216: comp_service_team_id,
217: support_site_id
218: from jtf_rs_resource_extns_vl
219: where resource_id = p_resource_rec.resource_id;
220:
221: res_rec res_cur%rowtype;
222:

Line 433: l_resource_id jtf_rs_resource_extns.resource_id%type := p_resource_id;

429: l_list WF_PARAMETER_LIST_T;
430: l_key varchar2(240);
431: l_exist varchar2(30);
432: l_event_name varchar2(240) := 'oracle.apps.jtf.jres.resource.delete';
433: l_resource_id jtf_rs_resource_extns.resource_id%type := p_resource_id;
434:
435: BEGIN
436:
437: x_return_status := fnd_api.g_ret_sts_success;