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_RESOURCE_WF_PUB dependencies on FND_API

Line 10: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

6: /* Procedure to start the update resource workflow */
7:
8: PROCEDURE start_update_resource_wf (
9: p_api_version IN NUMBER,
10: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
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,

Line 11: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

7:
8: PROCEDURE start_update_resource_wf (
9: p_api_version IN NUMBER,
10: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
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,

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 16: p_address_id IN jtf_rs_resource_extns.address_id%type default fnd_api.g_miss_num,

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,
20: p_source_location IN jtf_rs_resource_extns.source_location%type default fnd_api.g_miss_char,

Line 17: p_source_email IN jtf_rs_resource_extns.source_email%type default fnd_api.g_miss_char,

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,
20: p_source_location IN jtf_rs_resource_extns.source_location%type default fnd_api.g_miss_char,
21: p_source_mailstop IN jtf_rs_resource_extns.source_mailstop%type default fnd_api.g_miss_char,

Line 18: p_source_phone IN jtf_rs_resource_extns.source_phone%type default fnd_api.g_miss_char,

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,
20: p_source_location IN jtf_rs_resource_extns.source_location%type default fnd_api.g_miss_char,
21: p_source_mailstop IN jtf_rs_resource_extns.source_mailstop%type default fnd_api.g_miss_char,
22: p_time_zone IN jtf_rs_resource_extns.time_zone%type default fnd_api.g_miss_num,

Line 19: p_source_office IN jtf_rs_resource_extns.source_office%type default fnd_api.g_miss_char,

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,
20: p_source_location IN jtf_rs_resource_extns.source_location%type default fnd_api.g_miss_char,
21: p_source_mailstop IN jtf_rs_resource_extns.source_mailstop%type default fnd_api.g_miss_char,
22: p_time_zone IN jtf_rs_resource_extns.time_zone%type default fnd_api.g_miss_num,
23: p_support_site_id IN jtf_rs_resource_extns.support_site_id%type default fnd_api.g_miss_num,

Line 20: p_source_location IN jtf_rs_resource_extns.source_location%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,
20: p_source_location IN jtf_rs_resource_extns.source_location%type default fnd_api.g_miss_char,
21: p_source_mailstop IN jtf_rs_resource_extns.source_mailstop%type default fnd_api.g_miss_char,
22: p_time_zone IN jtf_rs_resource_extns.time_zone%type default fnd_api.g_miss_num,
23: p_support_site_id IN jtf_rs_resource_extns.support_site_id%type default fnd_api.g_miss_num,
24: p_primary_language IN jtf_rs_resource_extns.primary_language%type default fnd_api.g_miss_char,

Line 21: p_source_mailstop IN jtf_rs_resource_extns.source_mailstop%type default fnd_api.g_miss_char,

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,
20: p_source_location IN jtf_rs_resource_extns.source_location%type default fnd_api.g_miss_char,
21: p_source_mailstop IN jtf_rs_resource_extns.source_mailstop%type default fnd_api.g_miss_char,
22: p_time_zone IN jtf_rs_resource_extns.time_zone%type default fnd_api.g_miss_num,
23: p_support_site_id IN jtf_rs_resource_extns.support_site_id%type default fnd_api.g_miss_num,
24: p_primary_language IN jtf_rs_resource_extns.primary_language%type default fnd_api.g_miss_char,
25: p_secondary_language IN jtf_rs_resource_extns.secondary_language%type default fnd_api.g_miss_char,

Line 22: p_time_zone IN jtf_rs_resource_extns.time_zone%type default fnd_api.g_miss_num,

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,
20: p_source_location IN jtf_rs_resource_extns.source_location%type default fnd_api.g_miss_char,
21: p_source_mailstop IN jtf_rs_resource_extns.source_mailstop%type default fnd_api.g_miss_char,
22: p_time_zone IN jtf_rs_resource_extns.time_zone%type default fnd_api.g_miss_num,
23: p_support_site_id IN jtf_rs_resource_extns.support_site_id%type default fnd_api.g_miss_num,
24: p_primary_language IN jtf_rs_resource_extns.primary_language%type default fnd_api.g_miss_char,
25: p_secondary_language IN jtf_rs_resource_extns.secondary_language%type default fnd_api.g_miss_char,
26: p_cost_per_hr IN jtf_rs_resource_extns.cost_per_hr%type default fnd_api.g_miss_num,

Line 23: p_support_site_id IN jtf_rs_resource_extns.support_site_id%type default fnd_api.g_miss_num,

19: p_source_office IN jtf_rs_resource_extns.source_office%type default fnd_api.g_miss_char,
20: p_source_location IN jtf_rs_resource_extns.source_location%type default fnd_api.g_miss_char,
21: p_source_mailstop IN jtf_rs_resource_extns.source_mailstop%type default fnd_api.g_miss_char,
22: p_time_zone IN jtf_rs_resource_extns.time_zone%type default fnd_api.g_miss_num,
23: p_support_site_id IN jtf_rs_resource_extns.support_site_id%type default fnd_api.g_miss_num,
24: p_primary_language IN jtf_rs_resource_extns.primary_language%type default fnd_api.g_miss_char,
25: p_secondary_language IN jtf_rs_resource_extns.secondary_language%type default fnd_api.g_miss_char,
26: p_cost_per_hr IN jtf_rs_resource_extns.cost_per_hr%type default fnd_api.g_miss_num,
27: p_attribute_access_level IN jtf_rs_table_attributes_b.attribute_access_level%type,

Line 24: p_primary_language IN jtf_rs_resource_extns.primary_language%type default fnd_api.g_miss_char,

20: p_source_location IN jtf_rs_resource_extns.source_location%type default fnd_api.g_miss_char,
21: p_source_mailstop IN jtf_rs_resource_extns.source_mailstop%type default fnd_api.g_miss_char,
22: p_time_zone IN jtf_rs_resource_extns.time_zone%type default fnd_api.g_miss_num,
23: p_support_site_id IN jtf_rs_resource_extns.support_site_id%type default fnd_api.g_miss_num,
24: p_primary_language IN jtf_rs_resource_extns.primary_language%type default fnd_api.g_miss_char,
25: p_secondary_language IN jtf_rs_resource_extns.secondary_language%type default fnd_api.g_miss_char,
26: p_cost_per_hr IN jtf_rs_resource_extns.cost_per_hr%type default fnd_api.g_miss_num,
27: p_attribute_access_level IN jtf_rs_table_attributes_b.attribute_access_level%type,
28: p_object_version_number IN jtf_rs_resource_extns.object_version_number%type,

Line 25: p_secondary_language IN jtf_rs_resource_extns.secondary_language%type default fnd_api.g_miss_char,

21: p_source_mailstop IN jtf_rs_resource_extns.source_mailstop%type default fnd_api.g_miss_char,
22: p_time_zone IN jtf_rs_resource_extns.time_zone%type default fnd_api.g_miss_num,
23: p_support_site_id IN jtf_rs_resource_extns.support_site_id%type default fnd_api.g_miss_num,
24: p_primary_language IN jtf_rs_resource_extns.primary_language%type default fnd_api.g_miss_char,
25: p_secondary_language IN jtf_rs_resource_extns.secondary_language%type default fnd_api.g_miss_char,
26: p_cost_per_hr IN jtf_rs_resource_extns.cost_per_hr%type default fnd_api.g_miss_num,
27: p_attribute_access_level IN jtf_rs_table_attributes_b.attribute_access_level%type,
28: p_object_version_number IN jtf_rs_resource_extns.object_version_number%type,
29: --p_wf_display_name IN VARCHAR2 DEFAULT NULL,

Line 26: p_cost_per_hr IN jtf_rs_resource_extns.cost_per_hr%type default fnd_api.g_miss_num,

22: p_time_zone IN jtf_rs_resource_extns.time_zone%type default fnd_api.g_miss_num,
23: p_support_site_id IN jtf_rs_resource_extns.support_site_id%type default fnd_api.g_miss_num,
24: p_primary_language IN jtf_rs_resource_extns.primary_language%type default fnd_api.g_miss_char,
25: p_secondary_language IN jtf_rs_resource_extns.secondary_language%type default fnd_api.g_miss_char,
26: p_cost_per_hr IN jtf_rs_resource_extns.cost_per_hr%type default fnd_api.g_miss_num,
27: p_attribute_access_level IN jtf_rs_table_attributes_b.attribute_access_level%type,
28: p_object_version_number IN jtf_rs_resource_extns.object_version_number%type,
29: --p_wf_display_name IN VARCHAR2 DEFAULT NULL,
30: p_wf_process IN VARCHAR2 DEFAULT 'EMP_UPDATE_PROCESS',

Line 35: p_source_mobile_phone IN jtf_rs_resource_extns.source_mobile_phone%type default fnd_api.g_miss_char,

31: p_wf_item_type IN VARCHAR2 DEFAULT 'EMP_TYPE',
32: x_return_status OUT NOCOPY VARCHAR2,
33: x_msg_count OUT NOCOPY NUMBER,
34: x_msg_data OUT NOCOPY VARCHAR2,
35: p_source_mobile_phone IN jtf_rs_resource_extns.source_mobile_phone%type default fnd_api.g_miss_char,
36: p_source_pager IN jtf_rs_resource_extns.source_pager%type default fnd_api.g_miss_char
37: )
38:
39: IS

Line 36: p_source_pager IN jtf_rs_resource_extns.source_pager%type default fnd_api.g_miss_char

32: x_return_status OUT NOCOPY VARCHAR2,
33: x_msg_count OUT NOCOPY NUMBER,
34: x_msg_data OUT NOCOPY VARCHAR2,
35: p_source_mobile_phone IN jtf_rs_resource_extns.source_mobile_phone%type default fnd_api.g_miss_char,
36: p_source_pager IN jtf_rs_resource_extns.source_pager%type default fnd_api.g_miss_char
37: )
38:
39: IS
40:

Line 144: DECODE (p_resource_name, fnd_api.g_miss_char, resource_name, p_resource_name) resource_name,

140: AND b.party_site_id = l_support_site_id;
141:
142: CURSOR c_resource_update (l_resource_id number) IS
143: SELECT
144: DECODE (p_resource_name, fnd_api.g_miss_char, resource_name, p_resource_name) resource_name,
145: DECODE (p_source_email, fnd_api.g_miss_char, source_email, p_source_email) source_email,
146: DECODE (p_source_phone, fnd_api.g_miss_char, source_phone, p_source_phone) source_phone,
147: DECODE (p_source_office, fnd_api.g_miss_char, source_office, p_source_office) source_office,
148: DECODE (p_source_location, fnd_api.g_miss_char, source_location, p_source_location) source_location,

Line 145: DECODE (p_source_email, fnd_api.g_miss_char, source_email, p_source_email) source_email,

141:
142: CURSOR c_resource_update (l_resource_id number) IS
143: SELECT
144: DECODE (p_resource_name, fnd_api.g_miss_char, resource_name, p_resource_name) resource_name,
145: DECODE (p_source_email, fnd_api.g_miss_char, source_email, p_source_email) source_email,
146: DECODE (p_source_phone, fnd_api.g_miss_char, source_phone, p_source_phone) source_phone,
147: DECODE (p_source_office, fnd_api.g_miss_char, source_office, p_source_office) source_office,
148: DECODE (p_source_location, fnd_api.g_miss_char, source_location, p_source_location) source_location,
149: DECODE (p_source_mailstop, fnd_api.g_miss_char, source_mailstop, p_source_mailstop) source_mailstop,

Line 146: DECODE (p_source_phone, fnd_api.g_miss_char, source_phone, p_source_phone) source_phone,

142: CURSOR c_resource_update (l_resource_id number) IS
143: SELECT
144: DECODE (p_resource_name, fnd_api.g_miss_char, resource_name, p_resource_name) resource_name,
145: DECODE (p_source_email, fnd_api.g_miss_char, source_email, p_source_email) source_email,
146: DECODE (p_source_phone, fnd_api.g_miss_char, source_phone, p_source_phone) source_phone,
147: DECODE (p_source_office, fnd_api.g_miss_char, source_office, p_source_office) source_office,
148: DECODE (p_source_location, fnd_api.g_miss_char, source_location, p_source_location) source_location,
149: DECODE (p_source_mailstop, fnd_api.g_miss_char, source_mailstop, p_source_mailstop) source_mailstop,
150: DECODE (p_source_mobile_phone, fnd_api.g_miss_char, source_mobile_phone, p_source_mobile_phone) source_mobile_phone,

Line 147: DECODE (p_source_office, fnd_api.g_miss_char, source_office, p_source_office) source_office,

143: SELECT
144: DECODE (p_resource_name, fnd_api.g_miss_char, resource_name, p_resource_name) resource_name,
145: DECODE (p_source_email, fnd_api.g_miss_char, source_email, p_source_email) source_email,
146: DECODE (p_source_phone, fnd_api.g_miss_char, source_phone, p_source_phone) source_phone,
147: DECODE (p_source_office, fnd_api.g_miss_char, source_office, p_source_office) source_office,
148: DECODE (p_source_location, fnd_api.g_miss_char, source_location, p_source_location) source_location,
149: DECODE (p_source_mailstop, fnd_api.g_miss_char, source_mailstop, p_source_mailstop) source_mailstop,
150: DECODE (p_source_mobile_phone, fnd_api.g_miss_char, source_mobile_phone, p_source_mobile_phone) source_mobile_phone,
151: DECODE (p_source_pager, fnd_api.g_miss_char, source_pager, p_source_pager) source_pager,

Line 148: DECODE (p_source_location, fnd_api.g_miss_char, source_location, p_source_location) source_location,

144: DECODE (p_resource_name, fnd_api.g_miss_char, resource_name, p_resource_name) resource_name,
145: DECODE (p_source_email, fnd_api.g_miss_char, source_email, p_source_email) source_email,
146: DECODE (p_source_phone, fnd_api.g_miss_char, source_phone, p_source_phone) source_phone,
147: DECODE (p_source_office, fnd_api.g_miss_char, source_office, p_source_office) source_office,
148: DECODE (p_source_location, fnd_api.g_miss_char, source_location, p_source_location) source_location,
149: DECODE (p_source_mailstop, fnd_api.g_miss_char, source_mailstop, p_source_mailstop) source_mailstop,
150: DECODE (p_source_mobile_phone, fnd_api.g_miss_char, source_mobile_phone, p_source_mobile_phone) source_mobile_phone,
151: DECODE (p_source_pager, fnd_api.g_miss_char, source_pager, p_source_pager) source_pager,
152: DECODE (p_time_zone, fnd_api.g_miss_num, time_zone, p_time_zone) time_zone,

Line 149: DECODE (p_source_mailstop, fnd_api.g_miss_char, source_mailstop, p_source_mailstop) source_mailstop,

145: DECODE (p_source_email, fnd_api.g_miss_char, source_email, p_source_email) source_email,
146: DECODE (p_source_phone, fnd_api.g_miss_char, source_phone, p_source_phone) source_phone,
147: DECODE (p_source_office, fnd_api.g_miss_char, source_office, p_source_office) source_office,
148: DECODE (p_source_location, fnd_api.g_miss_char, source_location, p_source_location) source_location,
149: DECODE (p_source_mailstop, fnd_api.g_miss_char, source_mailstop, p_source_mailstop) source_mailstop,
150: DECODE (p_source_mobile_phone, fnd_api.g_miss_char, source_mobile_phone, p_source_mobile_phone) source_mobile_phone,
151: DECODE (p_source_pager, fnd_api.g_miss_char, source_pager, p_source_pager) source_pager,
152: DECODE (p_time_zone, fnd_api.g_miss_num, time_zone, p_time_zone) time_zone,
153: DECODE (p_support_site_id, fnd_api.g_miss_num, support_site_id, p_support_site_id) support_site_id,

Line 150: DECODE (p_source_mobile_phone, fnd_api.g_miss_char, source_mobile_phone, p_source_mobile_phone) source_mobile_phone,

146: DECODE (p_source_phone, fnd_api.g_miss_char, source_phone, p_source_phone) source_phone,
147: DECODE (p_source_office, fnd_api.g_miss_char, source_office, p_source_office) source_office,
148: DECODE (p_source_location, fnd_api.g_miss_char, source_location, p_source_location) source_location,
149: DECODE (p_source_mailstop, fnd_api.g_miss_char, source_mailstop, p_source_mailstop) source_mailstop,
150: DECODE (p_source_mobile_phone, fnd_api.g_miss_char, source_mobile_phone, p_source_mobile_phone) source_mobile_phone,
151: DECODE (p_source_pager, fnd_api.g_miss_char, source_pager, p_source_pager) source_pager,
152: DECODE (p_time_zone, fnd_api.g_miss_num, time_zone, p_time_zone) time_zone,
153: DECODE (p_support_site_id, fnd_api.g_miss_num, support_site_id, p_support_site_id) support_site_id,
154: DECODE (p_primary_language, fnd_api.g_miss_char, primary_language, p_primary_language) primary_language,

Line 151: DECODE (p_source_pager, fnd_api.g_miss_char, source_pager, p_source_pager) source_pager,

147: DECODE (p_source_office, fnd_api.g_miss_char, source_office, p_source_office) source_office,
148: DECODE (p_source_location, fnd_api.g_miss_char, source_location, p_source_location) source_location,
149: DECODE (p_source_mailstop, fnd_api.g_miss_char, source_mailstop, p_source_mailstop) source_mailstop,
150: DECODE (p_source_mobile_phone, fnd_api.g_miss_char, source_mobile_phone, p_source_mobile_phone) source_mobile_phone,
151: DECODE (p_source_pager, fnd_api.g_miss_char, source_pager, p_source_pager) source_pager,
152: DECODE (p_time_zone, fnd_api.g_miss_num, time_zone, p_time_zone) time_zone,
153: DECODE (p_support_site_id, fnd_api.g_miss_num, support_site_id, p_support_site_id) support_site_id,
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,

Line 152: DECODE (p_time_zone, fnd_api.g_miss_num, time_zone, p_time_zone) time_zone,

148: DECODE (p_source_location, fnd_api.g_miss_char, source_location, p_source_location) source_location,
149: DECODE (p_source_mailstop, fnd_api.g_miss_char, source_mailstop, p_source_mailstop) source_mailstop,
150: DECODE (p_source_mobile_phone, fnd_api.g_miss_char, source_mobile_phone, p_source_mobile_phone) source_mobile_phone,
151: DECODE (p_source_pager, fnd_api.g_miss_char, source_pager, p_source_pager) source_pager,
152: DECODE (p_time_zone, fnd_api.g_miss_num, time_zone, p_time_zone) time_zone,
153: DECODE (p_support_site_id, fnd_api.g_miss_num, support_site_id, p_support_site_id) support_site_id,
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,

Line 153: DECODE (p_support_site_id, fnd_api.g_miss_num, support_site_id, p_support_site_id) support_site_id,

149: DECODE (p_source_mailstop, fnd_api.g_miss_char, source_mailstop, p_source_mailstop) source_mailstop,
150: DECODE (p_source_mobile_phone, fnd_api.g_miss_char, source_mobile_phone, p_source_mobile_phone) source_mobile_phone,
151: DECODE (p_source_pager, fnd_api.g_miss_char, source_pager, p_source_pager) source_pager,
152: DECODE (p_time_zone, fnd_api.g_miss_num, time_zone, p_time_zone) time_zone,
153: DECODE (p_support_site_id, fnd_api.g_miss_num, support_site_id, p_support_site_id) support_site_id,
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

Line 154: DECODE (p_primary_language, fnd_api.g_miss_char, primary_language, p_primary_language) primary_language,

150: DECODE (p_source_mobile_phone, fnd_api.g_miss_char, source_mobile_phone, p_source_mobile_phone) source_mobile_phone,
151: DECODE (p_source_pager, fnd_api.g_miss_char, source_pager, p_source_pager) source_pager,
152: DECODE (p_time_zone, fnd_api.g_miss_num, time_zone, p_time_zone) time_zone,
153: DECODE (p_support_site_id, fnd_api.g_miss_num, support_site_id, p_support_site_id) support_site_id,
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

Line 155: DECODE (p_secondary_language, fnd_api.g_miss_char, secondary_language, p_secondary_language) secondary_language,

151: DECODE (p_source_pager, fnd_api.g_miss_char, source_pager, p_source_pager) source_pager,
152: DECODE (p_time_zone, fnd_api.g_miss_num, time_zone, p_time_zone) time_zone,
153: DECODE (p_support_site_id, fnd_api.g_miss_num, support_site_id, p_support_site_id) support_site_id,
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;

Line 156: DECODE (p_cost_per_hr, fnd_api.g_miss_num, cost_per_hr, p_cost_per_hr) cost_per_hr,

152: DECODE (p_time_zone, fnd_api.g_miss_num, time_zone, p_time_zone) time_zone,
153: DECODE (p_support_site_id, fnd_api.g_miss_num, support_site_id, p_support_site_id) support_site_id,
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:

Line 157: DECODE (p_address_id, fnd_api.g_miss_num, address_id, p_address_id) address_id

153: DECODE (p_support_site_id, fnd_api.g_miss_num, support_site_id, p_support_site_id) support_site_id,
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;

Line 168: x_return_status := fnd_api.g_ret_sts_success;

164:
165: --dbms_output.put_line ('Begin Workflow API');
166:
167: SAVEPOINT start_rs_workflow;
168: x_return_status := fnd_api.g_ret_sts_success;
169:
170: IF NOT fnd_api.compatible_api_call (
171: l_api_version,
172: p_api_version,

Line 170: IF NOT fnd_api.compatible_api_call (

166:
167: SAVEPOINT start_rs_workflow;
168: x_return_status := fnd_api.g_ret_sts_success;
169:
170: IF NOT fnd_api.compatible_api_call (
171: l_api_version,
172: p_api_version,
173: l_api_name,
174: g_pkg_name

Line 177: RAISE fnd_api.g_exc_unexpected_error;

173: l_api_name,
174: g_pkg_name
175: )
176: THEN
177: RAISE fnd_api.g_exc_unexpected_error;
178: END IF;
179:
180: IF fnd_api.to_boolean (p_init_msg_list)
181: THEN

Line 180: IF fnd_api.to_boolean (p_init_msg_list)

176: THEN
177: RAISE fnd_api.g_exc_unexpected_error;
178: END IF;
179:
180: IF fnd_api.to_boolean (p_init_msg_list)
181: THEN
182: fnd_msg_pub.initialize;
183: END IF;
184:

Line 204: x_return_status := fnd_api.g_ret_sts_unexp_error;

200: --dbms_output.put_line('The Resource passed is Invalid');
201: fnd_message.set_name('JTF', 'JTF_RS_INVALID_EMP_RESOURCE_ID');
202: fnd_message.set_token('P_EMP_RESOURCE_ID', l_resource_id);
203: fnd_msg_pub.add;
204: x_return_status := fnd_api.g_ret_sts_unexp_error;
205: RAISE fnd_api.g_exc_unexpected_error;
206: END IF;
207: CLOSE c_resource;
208:

Line 205: RAISE fnd_api.g_exc_unexpected_error;

201: fnd_message.set_name('JTF', 'JTF_RS_INVALID_EMP_RESOURCE_ID');
202: fnd_message.set_token('P_EMP_RESOURCE_ID', l_resource_id);
203: fnd_msg_pub.add;
204: x_return_status := fnd_api.g_ret_sts_unexp_error;
205: RAISE fnd_api.g_exc_unexpected_error;
206: END IF;
207: CLOSE c_resource;
208:
209: OPEN c_resource_update(l_resource_id);

Line 216: x_return_status := fnd_api.g_ret_sts_unexp_error;

212: --dbms_output.put_line('The Resource passed is Invalid');
213: fnd_message.set_name('JTF', 'JTF_RS_INVALID_EMP_RESOURCE_ID');
214: fnd_message.set_token('P_EMP_RESOURCE_ID', l_resource_id);
215: fnd_msg_pub.add;
216: x_return_status := fnd_api.g_ret_sts_unexp_error;
217: RAISE fnd_api.g_exc_unexpected_error;
218: END IF;
219: CLOSE c_resource_update;
220:

Line 217: RAISE fnd_api.g_exc_unexpected_error;

213: fnd_message.set_name('JTF', 'JTF_RS_INVALID_EMP_RESOURCE_ID');
214: fnd_message.set_token('P_EMP_RESOURCE_ID', l_resource_id);
215: fnd_msg_pub.add;
216: x_return_status := fnd_api.g_ret_sts_unexp_error;
217: RAISE fnd_api.g_exc_unexpected_error;
218: END IF;
219: CLOSE c_resource_update;
220:
221: IF l_attr_access_level = 'UWA' THEN

Line 284: IF p_address_id = fnd_api.g_miss_num THEN

280:
281: SELECT jtf_rs_resource_wf_s.nextval INTO l_itemkey FROM dual;
282: SELECT fnd_global.user_name INTO l_requestor FROM dual;
283:
284: IF p_address_id = fnd_api.g_miss_num THEN
285: l_new_address := l_old_address;
286: ELSE
287: IF l_new_address_id IS NOT NULL THEN
288: OPEN c_address (l_new_address_id);

Line 294: IF p_time_zone = fnd_api.g_miss_num THEN

290: CLOSE c_address;
291: END IF;
292: END IF;
293:
294: IF p_time_zone = fnd_api.g_miss_num THEN
295: l_new_timezone_name := l_old_timezone_name;
296: ELSE
297: IF l_new_time_zone IS NOT NULL THEN
298: OPEN c_timezone (l_new_time_zone);

Line 304: IF p_support_site_id = fnd_api.g_miss_num THEN

300: CLOSE c_timezone;
301: END IF;
302: END IF;
303:
304: IF p_support_site_id = fnd_api.g_miss_num THEN
305: l_new_support_site := l_old_support_site;
306: ELSE
307: IF l_new_support_site_id IS NOT NULL THEN
308: OPEN c_support_site (l_new_support_site_id);

Line 619: IF fnd_api.to_boolean (p_commit)

615: itemtype => p_wf_item_type,
616: itemkey => l_itemkey
617: );
618:
619: IF fnd_api.to_boolean (p_commit)
620: THEN
621: COMMIT WORK;
622: END IF;
623:

Line 627: WHEN fnd_api.g_exc_unexpected_error

623:
624: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
625:
626: EXCEPTION
627: WHEN fnd_api.g_exc_unexpected_error
628: THEN
629:
630: ROLLBACK TO start_rs_workflow;
631: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 631: x_return_status := fnd_api.g_ret_sts_unexp_error;

627: WHEN fnd_api.g_exc_unexpected_error
628: THEN
629:
630: ROLLBACK TO start_rs_workflow;
631: x_return_status := fnd_api.g_ret_sts_unexp_error;
632: fnd_msg_pub.count_and_get (
633: p_count => x_msg_count,
634: p_data => x_msg_data
635: );

Line 649: x_return_status := fnd_api.g_ret_sts_unexp_error;

645: fnd_message.set_token('ERROR_STACK', l_errstack);
646: fnd_msg_pub.add;
647: end if;
648:
649: x_return_status := fnd_api.g_ret_sts_unexp_error;
650: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
651:
652: END start_update_resource_wf;
653: