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,
16: p_address_id IN jtf_rs_resource_extns.address_id%type default fnd_api.g_miss_num,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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',
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',
31: p_wf_item_type IN VARCHAR2 DEFAULT 'EMP_TYPE',
32: x_return_status OUT NOCOPY VARCHAR2,
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
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:
43: l_wf_process_id NUMBER;
44: l_itemkey wf_item_activity_statuses.item_key%TYPE;
45: l_userkey varchar2(30);
46:
47: l_resource_id jtf_rs_resource_extns.resource_id%type := p_resource_id;
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;
45: l_userkey varchar2(30);
46:
47: l_resource_id jtf_rs_resource_extns.resource_id%type := p_resource_id;
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;
47: l_resource_id jtf_rs_resource_extns.resource_id%type := p_resource_id;
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;
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;
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;
57: l_new_source_mailstop jtf_rs_resource_extns.source_mailstop%type;
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;
57: l_new_source_mailstop jtf_rs_resource_extns.source_mailstop%type;
58: l_new_source_mobile_phone jtf_rs_resource_extns.source_mobile_phone%type;
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;
57: l_new_source_mailstop jtf_rs_resource_extns.source_mailstop%type;
58: l_new_source_mobile_phone jtf_rs_resource_extns.source_mobile_phone%type;
59: l_new_source_pager jtf_rs_resource_extns.source_pager%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;
57: l_new_source_mailstop jtf_rs_resource_extns.source_mailstop%type;
58: l_new_source_mobile_phone jtf_rs_resource_extns.source_mobile_phone%type;
59: l_new_source_pager jtf_rs_resource_extns.source_pager%type;
60: l_new_time_zone jtf_rs_resource_extns.time_zone%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;
57: l_new_source_mailstop jtf_rs_resource_extns.source_mailstop%type;
58: l_new_source_mobile_phone jtf_rs_resource_extns.source_mobile_phone%type;
59: l_new_source_pager jtf_rs_resource_extns.source_pager%type;
60: l_new_time_zone jtf_rs_resource_extns.time_zone%type;
61: l_new_support_site_id jtf_rs_resource_extns.support_site_id%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;
57: l_new_source_mailstop jtf_rs_resource_extns.source_mailstop%type;
58: l_new_source_mobile_phone jtf_rs_resource_extns.source_mobile_phone%type;
59: l_new_source_pager jtf_rs_resource_extns.source_pager%type;
60: l_new_time_zone jtf_rs_resource_extns.time_zone%type;
61: l_new_support_site_id jtf_rs_resource_extns.support_site_id%type;
62: l_new_primary_language jtf_rs_resource_extns.primary_language%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;
57: l_new_source_mailstop jtf_rs_resource_extns.source_mailstop%type;
58: l_new_source_mobile_phone jtf_rs_resource_extns.source_mobile_phone%type;
59: l_new_source_pager jtf_rs_resource_extns.source_pager%type;
60: l_new_time_zone jtf_rs_resource_extns.time_zone%type;
61: l_new_support_site_id jtf_rs_resource_extns.support_site_id%type;
62: l_new_primary_language jtf_rs_resource_extns.primary_language%type;
63: l_new_secondary_language jtf_rs_resource_extns.secondary_language%type;
56: l_new_source_location jtf_rs_resource_extns.source_location%type;
57: l_new_source_mailstop jtf_rs_resource_extns.source_mailstop%type;
58: l_new_source_mobile_phone jtf_rs_resource_extns.source_mobile_phone%type;
59: l_new_source_pager jtf_rs_resource_extns.source_pager%type;
60: l_new_time_zone jtf_rs_resource_extns.time_zone%type;
61: l_new_support_site_id jtf_rs_resource_extns.support_site_id%type;
62: l_new_primary_language jtf_rs_resource_extns.primary_language%type;
63: l_new_secondary_language jtf_rs_resource_extns.secondary_language%type;
64: l_new_cost_per_hr jtf_rs_resource_extns.cost_per_hr%type;
57: l_new_source_mailstop jtf_rs_resource_extns.source_mailstop%type;
58: l_new_source_mobile_phone jtf_rs_resource_extns.source_mobile_phone%type;
59: l_new_source_pager jtf_rs_resource_extns.source_pager%type;
60: l_new_time_zone jtf_rs_resource_extns.time_zone%type;
61: l_new_support_site_id jtf_rs_resource_extns.support_site_id%type;
62: l_new_primary_language jtf_rs_resource_extns.primary_language%type;
63: l_new_secondary_language jtf_rs_resource_extns.secondary_language%type;
64: l_new_cost_per_hr jtf_rs_resource_extns.cost_per_hr%type;
65:
58: l_new_source_mobile_phone jtf_rs_resource_extns.source_mobile_phone%type;
59: l_new_source_pager jtf_rs_resource_extns.source_pager%type;
60: l_new_time_zone jtf_rs_resource_extns.time_zone%type;
61: l_new_support_site_id jtf_rs_resource_extns.support_site_id%type;
62: l_new_primary_language jtf_rs_resource_extns.primary_language%type;
63: l_new_secondary_language jtf_rs_resource_extns.secondary_language%type;
64: l_new_cost_per_hr jtf_rs_resource_extns.cost_per_hr%type;
65:
66: l_category jtf_rs_resource_extns.category%type;
59: l_new_source_pager jtf_rs_resource_extns.source_pager%type;
60: l_new_time_zone jtf_rs_resource_extns.time_zone%type;
61: l_new_support_site_id jtf_rs_resource_extns.support_site_id%type;
62: l_new_primary_language jtf_rs_resource_extns.primary_language%type;
63: l_new_secondary_language jtf_rs_resource_extns.secondary_language%type;
64: l_new_cost_per_hr jtf_rs_resource_extns.cost_per_hr%type;
65:
66: l_category jtf_rs_resource_extns.category%type;
67: l_resource_number jtf_rs_resource_extns.resource_number%type;
60: l_new_time_zone jtf_rs_resource_extns.time_zone%type;
61: l_new_support_site_id jtf_rs_resource_extns.support_site_id%type;
62: l_new_primary_language jtf_rs_resource_extns.primary_language%type;
63: l_new_secondary_language jtf_rs_resource_extns.secondary_language%type;
64: l_new_cost_per_hr jtf_rs_resource_extns.cost_per_hr%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;
62: l_new_primary_language jtf_rs_resource_extns.primary_language%type;
63: l_new_secondary_language jtf_rs_resource_extns.secondary_language%type;
64: l_new_cost_per_hr jtf_rs_resource_extns.cost_per_hr%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;
63: l_new_secondary_language jtf_rs_resource_extns.secondary_language%type;
64: l_new_cost_per_hr jtf_rs_resource_extns.cost_per_hr%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;
64: l_new_cost_per_hr jtf_rs_resource_extns.cost_per_hr%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;
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;
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;
74: l_old_source_location jtf_rs_resource_extns.source_location%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;
74: l_old_source_location jtf_rs_resource_extns.source_location%type;
75: l_old_source_mailstop jtf_rs_resource_extns.source_mailstop%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;
74: l_old_source_location jtf_rs_resource_extns.source_location%type;
75: l_old_source_mailstop jtf_rs_resource_extns.source_mailstop%type;
76: l_old_source_mobile_phone jtf_rs_resource_extns.source_mobile_phone%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;
74: l_old_source_location jtf_rs_resource_extns.source_location%type;
75: l_old_source_mailstop jtf_rs_resource_extns.source_mailstop%type;
76: l_old_source_mobile_phone jtf_rs_resource_extns.source_mobile_phone%type;
77: l_old_source_pager jtf_rs_resource_extns.source_pager%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;
74: l_old_source_location jtf_rs_resource_extns.source_location%type;
75: l_old_source_mailstop jtf_rs_resource_extns.source_mailstop%type;
76: l_old_source_mobile_phone jtf_rs_resource_extns.source_mobile_phone%type;
77: l_old_source_pager jtf_rs_resource_extns.source_pager%type;
78: l_old_time_zone jtf_rs_resource_extns.time_zone%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;
74: l_old_source_location jtf_rs_resource_extns.source_location%type;
75: l_old_source_mailstop jtf_rs_resource_extns.source_mailstop%type;
76: l_old_source_mobile_phone jtf_rs_resource_extns.source_mobile_phone%type;
77: l_old_source_pager jtf_rs_resource_extns.source_pager%type;
78: l_old_time_zone jtf_rs_resource_extns.time_zone%type;
79: l_old_support_site_id jtf_rs_resource_extns.support_site_id%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;
74: l_old_source_location jtf_rs_resource_extns.source_location%type;
75: l_old_source_mailstop jtf_rs_resource_extns.source_mailstop%type;
76: l_old_source_mobile_phone jtf_rs_resource_extns.source_mobile_phone%type;
77: l_old_source_pager jtf_rs_resource_extns.source_pager%type;
78: l_old_time_zone jtf_rs_resource_extns.time_zone%type;
79: l_old_support_site_id jtf_rs_resource_extns.support_site_id%type;
80: l_old_primary_language jtf_rs_resource_extns.primary_language%type;
73: l_old_source_office jtf_rs_resource_extns.source_office%type;
74: l_old_source_location jtf_rs_resource_extns.source_location%type;
75: l_old_source_mailstop jtf_rs_resource_extns.source_mailstop%type;
76: l_old_source_mobile_phone jtf_rs_resource_extns.source_mobile_phone%type;
77: l_old_source_pager jtf_rs_resource_extns.source_pager%type;
78: l_old_time_zone jtf_rs_resource_extns.time_zone%type;
79: l_old_support_site_id jtf_rs_resource_extns.support_site_id%type;
80: l_old_primary_language jtf_rs_resource_extns.primary_language%type;
81: l_old_secondary_language jtf_rs_resource_extns.secondary_language%type;
74: l_old_source_location jtf_rs_resource_extns.source_location%type;
75: l_old_source_mailstop jtf_rs_resource_extns.source_mailstop%type;
76: l_old_source_mobile_phone jtf_rs_resource_extns.source_mobile_phone%type;
77: l_old_source_pager jtf_rs_resource_extns.source_pager%type;
78: l_old_time_zone jtf_rs_resource_extns.time_zone%type;
79: l_old_support_site_id jtf_rs_resource_extns.support_site_id%type;
80: l_old_primary_language jtf_rs_resource_extns.primary_language%type;
81: l_old_secondary_language jtf_rs_resource_extns.secondary_language%type;
82: l_old_cost_per_hr jtf_rs_resource_extns.cost_per_hr%type;
75: l_old_source_mailstop jtf_rs_resource_extns.source_mailstop%type;
76: l_old_source_mobile_phone jtf_rs_resource_extns.source_mobile_phone%type;
77: l_old_source_pager jtf_rs_resource_extns.source_pager%type;
78: l_old_time_zone jtf_rs_resource_extns.time_zone%type;
79: l_old_support_site_id jtf_rs_resource_extns.support_site_id%type;
80: l_old_primary_language jtf_rs_resource_extns.primary_language%type;
81: l_old_secondary_language jtf_rs_resource_extns.secondary_language%type;
82: l_old_cost_per_hr jtf_rs_resource_extns.cost_per_hr%type;
83:
76: l_old_source_mobile_phone jtf_rs_resource_extns.source_mobile_phone%type;
77: l_old_source_pager jtf_rs_resource_extns.source_pager%type;
78: l_old_time_zone jtf_rs_resource_extns.time_zone%type;
79: l_old_support_site_id jtf_rs_resource_extns.support_site_id%type;
80: l_old_primary_language jtf_rs_resource_extns.primary_language%type;
81: l_old_secondary_language jtf_rs_resource_extns.secondary_language%type;
82: l_old_cost_per_hr jtf_rs_resource_extns.cost_per_hr%type;
83:
84: l_old_address varchar2(2000);
77: l_old_source_pager jtf_rs_resource_extns.source_pager%type;
78: l_old_time_zone jtf_rs_resource_extns.time_zone%type;
79: l_old_support_site_id jtf_rs_resource_extns.support_site_id%type;
80: l_old_primary_language jtf_rs_resource_extns.primary_language%type;
81: l_old_secondary_language jtf_rs_resource_extns.secondary_language%type;
82: l_old_cost_per_hr jtf_rs_resource_extns.cost_per_hr%type;
83:
84: l_old_address varchar2(2000);
85: l_new_address varchar2(2000);
78: l_old_time_zone jtf_rs_resource_extns.time_zone%type;
79: l_old_support_site_id jtf_rs_resource_extns.support_site_id%type;
80: l_old_primary_language jtf_rs_resource_extns.primary_language%type;
81: l_old_secondary_language jtf_rs_resource_extns.secondary_language%type;
82: l_old_cost_per_hr jtf_rs_resource_extns.cost_per_hr%type;
83:
84: l_old_address varchar2(2000);
85: l_new_address varchar2(2000);
86:
89:
90: l_old_support_site varchar2(100);
91: l_new_support_site varchar2(100);
92:
93: l_user_id jtf_rs_resource_extns.user_id%type;
94: l_source_id jtf_rs_resource_extns.source_id%type;
95: l_source_mgr_id jtf_rs_resource_extns.source_mgr_id%type;
96:
97: l_source_number jtf_rs_resource_extns.source_number%type;
90: l_old_support_site varchar2(100);
91: l_new_support_site varchar2(100);
92:
93: l_user_id jtf_rs_resource_extns.user_id%type;
94: l_source_id jtf_rs_resource_extns.source_id%type;
95: l_source_mgr_id jtf_rs_resource_extns.source_mgr_id%type;
96:
97: l_source_number jtf_rs_resource_extns.source_number%type;
98:
91: l_new_support_site varchar2(100);
92:
93: l_user_id jtf_rs_resource_extns.user_id%type;
94: l_source_id jtf_rs_resource_extns.source_id%type;
95: l_source_mgr_id jtf_rs_resource_extns.source_mgr_id%type;
96:
97: l_source_number jtf_rs_resource_extns.source_number%type;
98:
99: l_approver fnd_user.user_name%type;
93: l_user_id jtf_rs_resource_extns.user_id%type;
94: l_source_id jtf_rs_resource_extns.source_id%type;
95: l_source_mgr_id jtf_rs_resource_extns.source_mgr_id%type;
96:
97: l_source_number jtf_rs_resource_extns.source_number%type;
98:
99: l_approver fnd_user.user_name%type;
100: l_requestor fnd_user.user_name%type;
101:
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
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:
794: resultout OUT NOCOPY VARCHAR2
795: )
796: IS
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;
795: )
796: IS
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;
796: IS
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;
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;
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;
806: l_source_location jtf_rs_resource_extns.source_location%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;
806: l_source_location jtf_rs_resource_extns.source_location%type;
807: l_source_mailstop jtf_rs_resource_extns.source_mailstop%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;
806: l_source_location jtf_rs_resource_extns.source_location%type;
807: l_source_mailstop jtf_rs_resource_extns.source_mailstop%type;
808: l_source_mobile_phone jtf_rs_resource_extns.source_mobile_phone%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;
806: l_source_location jtf_rs_resource_extns.source_location%type;
807: l_source_mailstop jtf_rs_resource_extns.source_mailstop%type;
808: l_source_mobile_phone jtf_rs_resource_extns.source_mobile_phone%type;
809: l_source_pager jtf_rs_resource_extns.source_pager%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;
806: l_source_location jtf_rs_resource_extns.source_location%type;
807: l_source_mailstop jtf_rs_resource_extns.source_mailstop%type;
808: l_source_mobile_phone jtf_rs_resource_extns.source_mobile_phone%type;
809: l_source_pager jtf_rs_resource_extns.source_pager%type;
810: l_time_zone jtf_rs_resource_extns.time_zone%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;
806: l_source_location jtf_rs_resource_extns.source_location%type;
807: l_source_mailstop jtf_rs_resource_extns.source_mailstop%type;
808: l_source_mobile_phone jtf_rs_resource_extns.source_mobile_phone%type;
809: l_source_pager jtf_rs_resource_extns.source_pager%type;
810: l_time_zone jtf_rs_resource_extns.time_zone%type;
811: l_support_site_id jtf_rs_resource_extns.support_site_id%type;
804: l_source_email jtf_rs_resource_extns.source_email%type;
805: l_source_office jtf_rs_resource_extns.source_office%type;
806: l_source_location jtf_rs_resource_extns.source_location%type;
807: l_source_mailstop jtf_rs_resource_extns.source_mailstop%type;
808: l_source_mobile_phone jtf_rs_resource_extns.source_mobile_phone%type;
809: l_source_pager jtf_rs_resource_extns.source_pager%type;
810: l_time_zone jtf_rs_resource_extns.time_zone%type;
811: l_support_site_id jtf_rs_resource_extns.support_site_id%type;
812: l_primary_language jtf_rs_resource_extns.primary_language%type;
805: l_source_office jtf_rs_resource_extns.source_office%type;
806: l_source_location jtf_rs_resource_extns.source_location%type;
807: l_source_mailstop jtf_rs_resource_extns.source_mailstop%type;
808: l_source_mobile_phone jtf_rs_resource_extns.source_mobile_phone%type;
809: l_source_pager jtf_rs_resource_extns.source_pager%type;
810: l_time_zone jtf_rs_resource_extns.time_zone%type;
811: l_support_site_id jtf_rs_resource_extns.support_site_id%type;
812: l_primary_language jtf_rs_resource_extns.primary_language%type;
813: l_secondary_language jtf_rs_resource_extns.secondary_language%type;
806: l_source_location jtf_rs_resource_extns.source_location%type;
807: l_source_mailstop jtf_rs_resource_extns.source_mailstop%type;
808: l_source_mobile_phone jtf_rs_resource_extns.source_mobile_phone%type;
809: l_source_pager jtf_rs_resource_extns.source_pager%type;
810: l_time_zone jtf_rs_resource_extns.time_zone%type;
811: l_support_site_id jtf_rs_resource_extns.support_site_id%type;
812: l_primary_language jtf_rs_resource_extns.primary_language%type;
813: l_secondary_language jtf_rs_resource_extns.secondary_language%type;
814: l_cost_per_hr jtf_rs_resource_extns.cost_per_hr%type;
807: l_source_mailstop jtf_rs_resource_extns.source_mailstop%type;
808: l_source_mobile_phone jtf_rs_resource_extns.source_mobile_phone%type;
809: l_source_pager jtf_rs_resource_extns.source_pager%type;
810: l_time_zone jtf_rs_resource_extns.time_zone%type;
811: l_support_site_id jtf_rs_resource_extns.support_site_id%type;
812: l_primary_language jtf_rs_resource_extns.primary_language%type;
813: l_secondary_language jtf_rs_resource_extns.secondary_language%type;
814: l_cost_per_hr jtf_rs_resource_extns.cost_per_hr%type;
815:
808: l_source_mobile_phone jtf_rs_resource_extns.source_mobile_phone%type;
809: l_source_pager jtf_rs_resource_extns.source_pager%type;
810: l_time_zone jtf_rs_resource_extns.time_zone%type;
811: l_support_site_id jtf_rs_resource_extns.support_site_id%type;
812: l_primary_language jtf_rs_resource_extns.primary_language%type;
813: l_secondary_language jtf_rs_resource_extns.secondary_language%type;
814: l_cost_per_hr jtf_rs_resource_extns.cost_per_hr%type;
815:
816: l_object_version_number jtf_rs_resource_extns.object_version_number%type;
809: l_source_pager jtf_rs_resource_extns.source_pager%type;
810: l_time_zone jtf_rs_resource_extns.time_zone%type;
811: l_support_site_id jtf_rs_resource_extns.support_site_id%type;
812: l_primary_language jtf_rs_resource_extns.primary_language%type;
813: l_secondary_language jtf_rs_resource_extns.secondary_language%type;
814: l_cost_per_hr jtf_rs_resource_extns.cost_per_hr%type;
815:
816: l_object_version_number jtf_rs_resource_extns.object_version_number%type;
817: x_msg_count number;
810: l_time_zone jtf_rs_resource_extns.time_zone%type;
811: l_support_site_id jtf_rs_resource_extns.support_site_id%type;
812: l_primary_language jtf_rs_resource_extns.primary_language%type;
813: l_secondary_language jtf_rs_resource_extns.secondary_language%type;
814: l_cost_per_hr jtf_rs_resource_extns.cost_per_hr%type;
815:
816: l_object_version_number jtf_rs_resource_extns.object_version_number%type;
817: x_msg_count number;
818: x_msg_data varchar2(2000);
812: l_primary_language jtf_rs_resource_extns.primary_language%type;
813: l_secondary_language jtf_rs_resource_extns.secondary_language%type;
814: l_cost_per_hr jtf_rs_resource_extns.cost_per_hr%type;
815:
816: l_object_version_number jtf_rs_resource_extns.object_version_number%type;
817: x_msg_count number;
818: x_msg_data varchar2(2000);
819: x_resultout varchar2(200);
820: x_return_status varchar2(1);