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 JTF_RS_RESOURCE_EXTNS

Line 12: p_resource_id IN jtf_rs_resource_extns.resource_id%type,

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,

Line 13: p_category IN jtf_rs_resource_extns.category%type,

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,

Line 14: p_resource_number IN jtf_rs_resource_extns.resource_number%type,

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,

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 28: p_object_version_number IN jtf_rs_resource_extns.object_version_number%type,

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,

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 47: l_resource_id jtf_rs_resource_extns.resource_id%type := p_resource_id;

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;

Line 49: l_object_version_number jtf_rs_resource_extns.object_version_number%type := p_object_version_number;

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;

Line 51: l_new_address_id jtf_rs_resource_extns.address_id%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;

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 53: l_new_phone_number jtf_rs_resource_extns.source_phone%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;

Line 54: l_new_email_address jtf_rs_resource_extns.source_email%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;

Line 55: l_new_source_office jtf_rs_resource_extns.source_office%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;

Line 56: l_new_source_location jtf_rs_resource_extns.source_location%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;

Line 57: l_new_source_mailstop jtf_rs_resource_extns.source_mailstop%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;

Line 58: l_new_source_mobile_phone jtf_rs_resource_extns.source_mobile_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;
62: l_new_primary_language jtf_rs_resource_extns.primary_language%type;

Line 59: l_new_source_pager jtf_rs_resource_extns.source_pager%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;

Line 60: l_new_time_zone jtf_rs_resource_extns.time_zone%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;

Line 61: l_new_support_site_id jtf_rs_resource_extns.support_site_id%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:

Line 62: l_new_primary_language jtf_rs_resource_extns.primary_language%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:
66: l_category jtf_rs_resource_extns.category%type;

Line 63: l_new_secondary_language jtf_rs_resource_extns.secondary_language%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;

Line 64: l_new_cost_per_hr jtf_rs_resource_extns.cost_per_hr%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;

Line 66: l_category jtf_rs_resource_extns.category%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;

Line 67: l_resource_number jtf_rs_resource_extns.resource_number%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;

Line 68: l_source_name jtf_rs_resource_extns.source_name%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;

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 70: l_old_address_id jtf_rs_resource_extns.address_id%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;

Line 71: l_old_phone_number jtf_rs_resource_extns.source_phone%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;

Line 72: l_old_email_address jtf_rs_resource_extns.source_email%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;

Line 73: l_old_source_office jtf_rs_resource_extns.source_office%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;

Line 74: l_old_source_location jtf_rs_resource_extns.source_location%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;

Line 75: l_old_source_mailstop jtf_rs_resource_extns.source_mailstop%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;

Line 76: l_old_source_mobile_phone jtf_rs_resource_extns.source_mobile_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;
80: l_old_primary_language jtf_rs_resource_extns.primary_language%type;

Line 77: l_old_source_pager jtf_rs_resource_extns.source_pager%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;

Line 78: l_old_time_zone jtf_rs_resource_extns.time_zone%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;

Line 79: l_old_support_site_id jtf_rs_resource_extns.support_site_id%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:

Line 80: l_old_primary_language jtf_rs_resource_extns.primary_language%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:
84: l_old_address varchar2(2000);

Line 81: l_old_secondary_language jtf_rs_resource_extns.secondary_language%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);
85: l_new_address varchar2(2000);

Line 82: l_old_cost_per_hr jtf_rs_resource_extns.cost_per_hr%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);
86:

Line 93: l_user_id jtf_rs_resource_extns.user_id%type;

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;

Line 94: l_source_id jtf_rs_resource_extns.source_id%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:

Line 95: l_source_mgr_id jtf_rs_resource_extns.source_mgr_id%type;

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;

Line 97: l_source_number jtf_rs_resource_extns.source_number%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:

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 798: l_resource_id jtf_rs_resource_extns.resource_id%type;

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;

Line 799: l_address_id jtf_rs_resource_extns.address_id%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;

Line 800: l_resource_number jtf_rs_resource_extns.resource_number%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;

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;

Line 802: l_source_name jtf_rs_resource_extns.source_name%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;

Line 803: l_source_phone jtf_rs_resource_extns.source_phone%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;

Line 804: l_source_email jtf_rs_resource_extns.source_email%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;

Line 805: l_source_office jtf_rs_resource_extns.source_office%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;

Line 806: l_source_location jtf_rs_resource_extns.source_location%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;

Line 807: l_source_mailstop jtf_rs_resource_extns.source_mailstop%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;

Line 808: l_source_mobile_phone jtf_rs_resource_extns.source_mobile_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;
812: l_primary_language jtf_rs_resource_extns.primary_language%type;

Line 809: l_source_pager jtf_rs_resource_extns.source_pager%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;

Line 810: l_time_zone jtf_rs_resource_extns.time_zone%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;

Line 811: l_support_site_id jtf_rs_resource_extns.support_site_id%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:

Line 812: l_primary_language jtf_rs_resource_extns.primary_language%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:
816: l_object_version_number jtf_rs_resource_extns.object_version_number%type;

Line 813: l_secondary_language jtf_rs_resource_extns.secondary_language%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;

Line 814: l_cost_per_hr jtf_rs_resource_extns.cost_per_hr%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;
818: x_msg_data varchar2(2000);

Line 816: l_object_version_number jtf_rs_resource_extns.object_version_number%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);
819: x_resultout varchar2(200);
820: x_return_status varchar2(1);