APPS.JTF_RS_WF_EVENTS_PUB dependencies on JTF_RS_RESOURCE_EXTNS_VL

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 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 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: