APPS.JTF_RS_RESOURCE_WF_PUB dependencies on JTF_RS_RESOURCE_EXTNS_VL

Line 15: p_resource_name IN jtf_rs_resource_extns_vl.resource_name%type default fnd_api.g_miss_char,

11: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
12: p_resource_id IN jtf_rs_resource_extns.resource_id%type,
13: p_category IN jtf_rs_resource_extns.category%type,
14: p_resource_number IN jtf_rs_resource_extns.resource_number%type,
15: p_resource_name IN jtf_rs_resource_extns_vl.resource_name%type default fnd_api.g_miss_char,
16: p_address_id IN jtf_rs_resource_extns.address_id%type default fnd_api.g_miss_num,
17: p_source_email IN jtf_rs_resource_extns.source_email%type default fnd_api.g_miss_char,
18: p_source_phone IN jtf_rs_resource_extns.source_phone%type default fnd_api.g_miss_char,
19: p_source_office IN jtf_rs_resource_extns.source_office%type default fnd_api.g_miss_char,

Line 52: l_new_resource_name jtf_rs_resource_extns_vl.resource_name%type;

48: l_attr_access_level jtf_rs_table_attributes_b.attribute_access_level%type := p_attribute_access_level;
49: l_object_version_number jtf_rs_resource_extns.object_version_number%type := p_object_version_number;
50:
51: l_new_address_id jtf_rs_resource_extns.address_id%type;
52: l_new_resource_name jtf_rs_resource_extns_vl.resource_name%type;
53: l_new_phone_number jtf_rs_resource_extns.source_phone%type;
54: l_new_email_address jtf_rs_resource_extns.source_email%type;
55: l_new_source_office jtf_rs_resource_extns.source_office%type;
56: l_new_source_location jtf_rs_resource_extns.source_location%type;

Line 69: l_old_resource_name jtf_rs_resource_extns_vl.resource_name%type;

65:
66: l_category jtf_rs_resource_extns.category%type;
67: l_resource_number jtf_rs_resource_extns.resource_number%type;
68: l_source_name jtf_rs_resource_extns.source_name%type;
69: l_old_resource_name jtf_rs_resource_extns_vl.resource_name%type;
70: l_old_address_id jtf_rs_resource_extns.address_id%type;
71: l_old_phone_number jtf_rs_resource_extns.source_phone%type;
72: l_old_email_address jtf_rs_resource_extns.source_email%type;
73: l_old_source_office jtf_rs_resource_extns.source_office%type;

Line 121: FROM jtf_rs_resource_extns_vl

117: source_phone, source_email, source_office, source_location,
118: source_mailstop, source_mobile_phone, source_pager, time_zone,
119: support_site_id, primary_language, secondary_language, cost_per_hr,
120: address_id, user_id, source_id, source_mgr_id
121: FROM jtf_rs_resource_extns_vl
122: WHERE resource_id = l_resource_id;
123:
124: CURSOR c_address (l_address_id number) IS
125: SELECT description

Line 158: FROM jtf_rs_resource_extns_vl

154: DECODE (p_primary_language, fnd_api.g_miss_char, primary_language, p_primary_language) primary_language,
155: DECODE (p_secondary_language, fnd_api.g_miss_char, secondary_language, p_secondary_language) secondary_language,
156: DECODE (p_cost_per_hr, fnd_api.g_miss_num, cost_per_hr, p_cost_per_hr) cost_per_hr,
157: DECODE (p_address_id, fnd_api.g_miss_num, address_id, p_address_id) address_id
158: FROM jtf_rs_resource_extns_vl
159: WHERE resource_id = l_resource_id;
160:
161: resource_rec c_resource_update%ROWTYPE;
162:

Line 801: l_resource_name jtf_rs_resource_extns_vl.resource_name%type;

797:
798: l_resource_id jtf_rs_resource_extns.resource_id%type;
799: l_address_id jtf_rs_resource_extns.address_id%type;
800: l_resource_number jtf_rs_resource_extns.resource_number%type;
801: l_resource_name jtf_rs_resource_extns_vl.resource_name%type;
802: l_source_name jtf_rs_resource_extns.source_name%type;
803: l_source_phone jtf_rs_resource_extns.source_phone%type;
804: l_source_email jtf_rs_resource_extns.source_email%type;
805: l_source_office jtf_rs_resource_extns.source_office%type;