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_RES_SSWA_PUB dependencies on JTF_RS_RESOURCE_EXTNS

Line 47: l_source_mailstop jtf_rs_resource_extns.source_mailstop%type := p_source_mailstop;

43: l_api_name constant varchar2(30) := 'CREATE_EMP_RESOURCE';
44: l_return_status varchar2(100) := fnd_api.g_ret_sts_success;
45: l_address_id number := to_number(p_source_address_id);
46: l_job_id number := p_source_job_id;
47: l_source_mailstop jtf_rs_resource_extns.source_mailstop%type := p_source_mailstop;
48: l_source_office jtf_rs_resource_extns.source_office%type := p_source_office;
49: l_source_location jtf_rs_resource_extns.source_location%type := p_source_location;
50: l_source_email jtf_rs_resource_extns.source_email%type := p_source_email;
51: l_source_phone jtf_rs_resource_extns.source_phone%type := p_source_phone;

Line 48: l_source_office jtf_rs_resource_extns.source_office%type := p_source_office;

44: l_return_status varchar2(100) := fnd_api.g_ret_sts_success;
45: l_address_id number := to_number(p_source_address_id);
46: l_job_id number := p_source_job_id;
47: l_source_mailstop jtf_rs_resource_extns.source_mailstop%type := p_source_mailstop;
48: l_source_office jtf_rs_resource_extns.source_office%type := p_source_office;
49: l_source_location jtf_rs_resource_extns.source_location%type := p_source_location;
50: l_source_email jtf_rs_resource_extns.source_email%type := p_source_email;
51: l_source_phone jtf_rs_resource_extns.source_phone%type := p_source_phone;
52: l_business_group_id per_all_people_f.business_group_id%type;

Line 49: l_source_location jtf_rs_resource_extns.source_location%type := p_source_location;

45: l_address_id number := to_number(p_source_address_id);
46: l_job_id number := p_source_job_id;
47: l_source_mailstop jtf_rs_resource_extns.source_mailstop%type := p_source_mailstop;
48: l_source_office jtf_rs_resource_extns.source_office%type := p_source_office;
49: l_source_location jtf_rs_resource_extns.source_location%type := p_source_location;
50: l_source_email jtf_rs_resource_extns.source_email%type := p_source_email;
51: l_source_phone jtf_rs_resource_extns.source_phone%type := p_source_phone;
52: l_business_group_id per_all_people_f.business_group_id%type;
53: l_user_name fnd_user.user_name%type := upper(p_user_name);

Line 50: l_source_email jtf_rs_resource_extns.source_email%type := p_source_email;

46: l_job_id number := p_source_job_id;
47: l_source_mailstop jtf_rs_resource_extns.source_mailstop%type := p_source_mailstop;
48: l_source_office jtf_rs_resource_extns.source_office%type := p_source_office;
49: l_source_location jtf_rs_resource_extns.source_location%type := p_source_location;
50: l_source_email jtf_rs_resource_extns.source_email%type := p_source_email;
51: l_source_phone jtf_rs_resource_extns.source_phone%type := p_source_phone;
52: l_business_group_id per_all_people_f.business_group_id%type;
53: l_user_name fnd_user.user_name%type := upper(p_user_name);
54: l_user_password fnd_user.encrypted_user_password%type := p_user_password;

Line 51: l_source_phone jtf_rs_resource_extns.source_phone%type := p_source_phone;

47: l_source_mailstop jtf_rs_resource_extns.source_mailstop%type := p_source_mailstop;
48: l_source_office jtf_rs_resource_extns.source_office%type := p_source_office;
49: l_source_location jtf_rs_resource_extns.source_location%type := p_source_location;
50: l_source_email jtf_rs_resource_extns.source_email%type := p_source_email;
51: l_source_phone jtf_rs_resource_extns.source_phone%type := p_source_phone;
52: l_business_group_id per_all_people_f.business_group_id%type;
53: l_user_name fnd_user.user_name%type := upper(p_user_name);
54: l_user_password fnd_user.encrypted_user_password%type := p_user_password;
55: l_salesrep_number jtf_rs_salesreps.salesrep_number%type := p_salesrep_number;

Line 127: and person_id = (select source_id from jtf_rs_resource_extns

123: is
124: select full_name, person_id
125: from per_all_people_f
126: where trunc(sysdate ) between effective_start_date and effective_end_date
127: and person_id = (select source_id from jtf_rs_resource_extns
128: and resource_id = p_source_mgr_id);
129: */
130: cursor mgr_details(p_source_mgr_id number)
131: is

Line 133: from jtf_rs_resource_extns

129: */
130: cursor mgr_details(p_source_mgr_id number)
131: is
132: select source_name, source_id
133: from jtf_rs_resource_extns
134: where resource_id = p_source_mgr_id;
135:
136: l_source_mgr_name varchar2(2000);
137: l_mgr_source_id number;

Line 641: from jtf_rs_resource_extns_vl

637: , SUPPORT_SITE_ID
638: , SOURCE_MOBILE_PHONE
639: , SOURCE_PAGER
640: , USER_ID
641: from jtf_rs_resource_extns_vl
642: where resource_id = p_resource_id;
643:
644: old_rec old_cur%rowtype;
645:

Line 755: aprvl_resource_name jtf_rs_resource_extns_vl.resource_name%type := fnd_api.g_miss_char;

751: -- Bug # 2186026
752: -- OK_... fields are set for changes for which no approval needed or just the
753: -- noficiations are required. Whereas APPRV_.. fields are set when
754: -- changes requires approval
755: aprvl_resource_name jtf_rs_resource_extns_vl.resource_name%type := fnd_api.g_miss_char;
756: aprvl_source_name jtf_rs_resource_extns_vl.source_name%type := fnd_api.g_miss_char;
757: aprvl_address_id jtf_rs_resource_extns_vl.address_id%type := fnd_api.g_miss_num;
758: aprvl_source_office jtf_rs_resource_extns_vl.source_office%type := fnd_api.g_miss_char;
759: aprvl_source_mailstop jtf_rs_resource_extns_vl.source_mailstop%type := fnd_api.g_miss_char;

Line 756: aprvl_source_name jtf_rs_resource_extns_vl.source_name%type := fnd_api.g_miss_char;

752: -- OK_... fields are set for changes for which no approval needed or just the
753: -- noficiations are required. Whereas APPRV_.. fields are set when
754: -- changes requires approval
755: aprvl_resource_name jtf_rs_resource_extns_vl.resource_name%type := fnd_api.g_miss_char;
756: aprvl_source_name jtf_rs_resource_extns_vl.source_name%type := fnd_api.g_miss_char;
757: aprvl_address_id jtf_rs_resource_extns_vl.address_id%type := fnd_api.g_miss_num;
758: aprvl_source_office jtf_rs_resource_extns_vl.source_office%type := fnd_api.g_miss_char;
759: aprvl_source_mailstop jtf_rs_resource_extns_vl.source_mailstop%type := fnd_api.g_miss_char;
760: aprvl_source_location jtf_rs_resource_extns_vl.source_location%type := fnd_api.g_miss_char;

Line 757: aprvl_address_id jtf_rs_resource_extns_vl.address_id%type := fnd_api.g_miss_num;

753: -- noficiations are required. Whereas APPRV_.. fields are set when
754: -- changes requires approval
755: aprvl_resource_name jtf_rs_resource_extns_vl.resource_name%type := fnd_api.g_miss_char;
756: aprvl_source_name jtf_rs_resource_extns_vl.source_name%type := fnd_api.g_miss_char;
757: aprvl_address_id jtf_rs_resource_extns_vl.address_id%type := fnd_api.g_miss_num;
758: aprvl_source_office jtf_rs_resource_extns_vl.source_office%type := fnd_api.g_miss_char;
759: aprvl_source_mailstop jtf_rs_resource_extns_vl.source_mailstop%type := fnd_api.g_miss_char;
760: aprvl_source_location jtf_rs_resource_extns_vl.source_location%type := fnd_api.g_miss_char;
761: aprvl_source_phone jtf_rs_resource_extns_vl.source_phone%type := fnd_api.g_miss_char;

Line 758: aprvl_source_office jtf_rs_resource_extns_vl.source_office%type := fnd_api.g_miss_char;

754: -- changes requires approval
755: aprvl_resource_name jtf_rs_resource_extns_vl.resource_name%type := fnd_api.g_miss_char;
756: aprvl_source_name jtf_rs_resource_extns_vl.source_name%type := fnd_api.g_miss_char;
757: aprvl_address_id jtf_rs_resource_extns_vl.address_id%type := fnd_api.g_miss_num;
758: aprvl_source_office jtf_rs_resource_extns_vl.source_office%type := fnd_api.g_miss_char;
759: aprvl_source_mailstop jtf_rs_resource_extns_vl.source_mailstop%type := fnd_api.g_miss_char;
760: aprvl_source_location jtf_rs_resource_extns_vl.source_location%type := fnd_api.g_miss_char;
761: aprvl_source_phone jtf_rs_resource_extns_vl.source_phone%type := fnd_api.g_miss_char;
762: aprvl_source_mobile_phone jtf_rs_resource_extns_vl.source_mobile_phone%type := fnd_api.g_miss_char;

Line 759: aprvl_source_mailstop jtf_rs_resource_extns_vl.source_mailstop%type := fnd_api.g_miss_char;

755: aprvl_resource_name jtf_rs_resource_extns_vl.resource_name%type := fnd_api.g_miss_char;
756: aprvl_source_name jtf_rs_resource_extns_vl.source_name%type := fnd_api.g_miss_char;
757: aprvl_address_id jtf_rs_resource_extns_vl.address_id%type := fnd_api.g_miss_num;
758: aprvl_source_office jtf_rs_resource_extns_vl.source_office%type := fnd_api.g_miss_char;
759: aprvl_source_mailstop jtf_rs_resource_extns_vl.source_mailstop%type := fnd_api.g_miss_char;
760: aprvl_source_location jtf_rs_resource_extns_vl.source_location%type := fnd_api.g_miss_char;
761: aprvl_source_phone jtf_rs_resource_extns_vl.source_phone%type := fnd_api.g_miss_char;
762: aprvl_source_mobile_phone jtf_rs_resource_extns_vl.source_mobile_phone%type := fnd_api.g_miss_char;
763: aprvl_source_pager jtf_rs_resource_extns_vl.source_pager%type := fnd_api.g_miss_char;

Line 760: aprvl_source_location jtf_rs_resource_extns_vl.source_location%type := fnd_api.g_miss_char;

756: aprvl_source_name jtf_rs_resource_extns_vl.source_name%type := fnd_api.g_miss_char;
757: aprvl_address_id jtf_rs_resource_extns_vl.address_id%type := fnd_api.g_miss_num;
758: aprvl_source_office jtf_rs_resource_extns_vl.source_office%type := fnd_api.g_miss_char;
759: aprvl_source_mailstop jtf_rs_resource_extns_vl.source_mailstop%type := fnd_api.g_miss_char;
760: aprvl_source_location jtf_rs_resource_extns_vl.source_location%type := fnd_api.g_miss_char;
761: aprvl_source_phone jtf_rs_resource_extns_vl.source_phone%type := fnd_api.g_miss_char;
762: aprvl_source_mobile_phone jtf_rs_resource_extns_vl.source_mobile_phone%type := fnd_api.g_miss_char;
763: aprvl_source_pager jtf_rs_resource_extns_vl.source_pager%type := fnd_api.g_miss_char;
764: aprvl_source_email jtf_rs_resource_extns_vl.source_email%type := fnd_api.g_miss_char;

Line 761: aprvl_source_phone jtf_rs_resource_extns_vl.source_phone%type := fnd_api.g_miss_char;

757: aprvl_address_id jtf_rs_resource_extns_vl.address_id%type := fnd_api.g_miss_num;
758: aprvl_source_office jtf_rs_resource_extns_vl.source_office%type := fnd_api.g_miss_char;
759: aprvl_source_mailstop jtf_rs_resource_extns_vl.source_mailstop%type := fnd_api.g_miss_char;
760: aprvl_source_location jtf_rs_resource_extns_vl.source_location%type := fnd_api.g_miss_char;
761: aprvl_source_phone jtf_rs_resource_extns_vl.source_phone%type := fnd_api.g_miss_char;
762: aprvl_source_mobile_phone jtf_rs_resource_extns_vl.source_mobile_phone%type := fnd_api.g_miss_char;
763: aprvl_source_pager jtf_rs_resource_extns_vl.source_pager%type := fnd_api.g_miss_char;
764: aprvl_source_email jtf_rs_resource_extns_vl.source_email%type := fnd_api.g_miss_char;
765: aprvl_time_zone jtf_rs_resource_extns_vl.time_zone%type := fnd_api.g_miss_num;

Line 762: aprvl_source_mobile_phone jtf_rs_resource_extns_vl.source_mobile_phone%type := fnd_api.g_miss_char;

758: aprvl_source_office jtf_rs_resource_extns_vl.source_office%type := fnd_api.g_miss_char;
759: aprvl_source_mailstop jtf_rs_resource_extns_vl.source_mailstop%type := fnd_api.g_miss_char;
760: aprvl_source_location jtf_rs_resource_extns_vl.source_location%type := fnd_api.g_miss_char;
761: aprvl_source_phone jtf_rs_resource_extns_vl.source_phone%type := fnd_api.g_miss_char;
762: aprvl_source_mobile_phone jtf_rs_resource_extns_vl.source_mobile_phone%type := fnd_api.g_miss_char;
763: aprvl_source_pager jtf_rs_resource_extns_vl.source_pager%type := fnd_api.g_miss_char;
764: aprvl_source_email jtf_rs_resource_extns_vl.source_email%type := fnd_api.g_miss_char;
765: aprvl_time_zone jtf_rs_resource_extns_vl.time_zone%type := fnd_api.g_miss_num;
766: aprvl_support_site_id jtf_rs_resource_extns_vl.support_site_id%type := fnd_api.g_miss_num;

Line 763: aprvl_source_pager jtf_rs_resource_extns_vl.source_pager%type := fnd_api.g_miss_char;

759: aprvl_source_mailstop jtf_rs_resource_extns_vl.source_mailstop%type := fnd_api.g_miss_char;
760: aprvl_source_location jtf_rs_resource_extns_vl.source_location%type := fnd_api.g_miss_char;
761: aprvl_source_phone jtf_rs_resource_extns_vl.source_phone%type := fnd_api.g_miss_char;
762: aprvl_source_mobile_phone jtf_rs_resource_extns_vl.source_mobile_phone%type := fnd_api.g_miss_char;
763: aprvl_source_pager jtf_rs_resource_extns_vl.source_pager%type := fnd_api.g_miss_char;
764: aprvl_source_email jtf_rs_resource_extns_vl.source_email%type := fnd_api.g_miss_char;
765: aprvl_time_zone jtf_rs_resource_extns_vl.time_zone%type := fnd_api.g_miss_num;
766: aprvl_support_site_id jtf_rs_resource_extns_vl.support_site_id%type := fnd_api.g_miss_num;
767: aprvl_primary_language jtf_rs_resource_extns_vl.primary_language%type := fnd_api.g_miss_char;

Line 764: aprvl_source_email jtf_rs_resource_extns_vl.source_email%type := fnd_api.g_miss_char;

760: aprvl_source_location jtf_rs_resource_extns_vl.source_location%type := fnd_api.g_miss_char;
761: aprvl_source_phone jtf_rs_resource_extns_vl.source_phone%type := fnd_api.g_miss_char;
762: aprvl_source_mobile_phone jtf_rs_resource_extns_vl.source_mobile_phone%type := fnd_api.g_miss_char;
763: aprvl_source_pager jtf_rs_resource_extns_vl.source_pager%type := fnd_api.g_miss_char;
764: aprvl_source_email jtf_rs_resource_extns_vl.source_email%type := fnd_api.g_miss_char;
765: aprvl_time_zone jtf_rs_resource_extns_vl.time_zone%type := fnd_api.g_miss_num;
766: aprvl_support_site_id jtf_rs_resource_extns_vl.support_site_id%type := fnd_api.g_miss_num;
767: aprvl_primary_language jtf_rs_resource_extns_vl.primary_language%type := fnd_api.g_miss_char;
768: aprvl_secondary_language jtf_rs_resource_extns_vl.secondary_language%type := fnd_api.g_miss_char;

Line 765: aprvl_time_zone jtf_rs_resource_extns_vl.time_zone%type := fnd_api.g_miss_num;

761: aprvl_source_phone jtf_rs_resource_extns_vl.source_phone%type := fnd_api.g_miss_char;
762: aprvl_source_mobile_phone jtf_rs_resource_extns_vl.source_mobile_phone%type := fnd_api.g_miss_char;
763: aprvl_source_pager jtf_rs_resource_extns_vl.source_pager%type := fnd_api.g_miss_char;
764: aprvl_source_email jtf_rs_resource_extns_vl.source_email%type := fnd_api.g_miss_char;
765: aprvl_time_zone jtf_rs_resource_extns_vl.time_zone%type := fnd_api.g_miss_num;
766: aprvl_support_site_id jtf_rs_resource_extns_vl.support_site_id%type := fnd_api.g_miss_num;
767: aprvl_primary_language jtf_rs_resource_extns_vl.primary_language%type := fnd_api.g_miss_char;
768: aprvl_secondary_language jtf_rs_resource_extns_vl.secondary_language%type := fnd_api.g_miss_char;
769: aprvl_cost_per_hr jtf_rs_resource_extns_vl.cost_per_hr%type := fnd_api.g_miss_num;

Line 766: aprvl_support_site_id jtf_rs_resource_extns_vl.support_site_id%type := fnd_api.g_miss_num;

762: aprvl_source_mobile_phone jtf_rs_resource_extns_vl.source_mobile_phone%type := fnd_api.g_miss_char;
763: aprvl_source_pager jtf_rs_resource_extns_vl.source_pager%type := fnd_api.g_miss_char;
764: aprvl_source_email jtf_rs_resource_extns_vl.source_email%type := fnd_api.g_miss_char;
765: aprvl_time_zone jtf_rs_resource_extns_vl.time_zone%type := fnd_api.g_miss_num;
766: aprvl_support_site_id jtf_rs_resource_extns_vl.support_site_id%type := fnd_api.g_miss_num;
767: aprvl_primary_language jtf_rs_resource_extns_vl.primary_language%type := fnd_api.g_miss_char;
768: aprvl_secondary_language jtf_rs_resource_extns_vl.secondary_language%type := fnd_api.g_miss_char;
769: aprvl_cost_per_hr jtf_rs_resource_extns_vl.cost_per_hr%type := fnd_api.g_miss_num;
770:

Line 767: aprvl_primary_language jtf_rs_resource_extns_vl.primary_language%type := fnd_api.g_miss_char;

763: aprvl_source_pager jtf_rs_resource_extns_vl.source_pager%type := fnd_api.g_miss_char;
764: aprvl_source_email jtf_rs_resource_extns_vl.source_email%type := fnd_api.g_miss_char;
765: aprvl_time_zone jtf_rs_resource_extns_vl.time_zone%type := fnd_api.g_miss_num;
766: aprvl_support_site_id jtf_rs_resource_extns_vl.support_site_id%type := fnd_api.g_miss_num;
767: aprvl_primary_language jtf_rs_resource_extns_vl.primary_language%type := fnd_api.g_miss_char;
768: aprvl_secondary_language jtf_rs_resource_extns_vl.secondary_language%type := fnd_api.g_miss_char;
769: aprvl_cost_per_hr jtf_rs_resource_extns_vl.cost_per_hr%type := fnd_api.g_miss_num;
770:
771: ok_resource_name jtf_rs_resource_extns_vl.resource_name%type := p_resource_name;

Line 768: aprvl_secondary_language jtf_rs_resource_extns_vl.secondary_language%type := fnd_api.g_miss_char;

764: aprvl_source_email jtf_rs_resource_extns_vl.source_email%type := fnd_api.g_miss_char;
765: aprvl_time_zone jtf_rs_resource_extns_vl.time_zone%type := fnd_api.g_miss_num;
766: aprvl_support_site_id jtf_rs_resource_extns_vl.support_site_id%type := fnd_api.g_miss_num;
767: aprvl_primary_language jtf_rs_resource_extns_vl.primary_language%type := fnd_api.g_miss_char;
768: aprvl_secondary_language jtf_rs_resource_extns_vl.secondary_language%type := fnd_api.g_miss_char;
769: aprvl_cost_per_hr jtf_rs_resource_extns_vl.cost_per_hr%type := fnd_api.g_miss_num;
770:
771: ok_resource_name jtf_rs_resource_extns_vl.resource_name%type := p_resource_name;
772: ok_source_name jtf_rs_resource_extns_vl.source_name%type := p_source_name;

Line 769: aprvl_cost_per_hr jtf_rs_resource_extns_vl.cost_per_hr%type := fnd_api.g_miss_num;

765: aprvl_time_zone jtf_rs_resource_extns_vl.time_zone%type := fnd_api.g_miss_num;
766: aprvl_support_site_id jtf_rs_resource_extns_vl.support_site_id%type := fnd_api.g_miss_num;
767: aprvl_primary_language jtf_rs_resource_extns_vl.primary_language%type := fnd_api.g_miss_char;
768: aprvl_secondary_language jtf_rs_resource_extns_vl.secondary_language%type := fnd_api.g_miss_char;
769: aprvl_cost_per_hr jtf_rs_resource_extns_vl.cost_per_hr%type := fnd_api.g_miss_num;
770:
771: ok_resource_name jtf_rs_resource_extns_vl.resource_name%type := p_resource_name;
772: ok_source_name jtf_rs_resource_extns_vl.source_name%type := p_source_name;
773: ok_address_id jtf_rs_resource_extns_vl.address_id%type := to_number(p_address_id);

Line 771: ok_resource_name jtf_rs_resource_extns_vl.resource_name%type := p_resource_name;

767: aprvl_primary_language jtf_rs_resource_extns_vl.primary_language%type := fnd_api.g_miss_char;
768: aprvl_secondary_language jtf_rs_resource_extns_vl.secondary_language%type := fnd_api.g_miss_char;
769: aprvl_cost_per_hr jtf_rs_resource_extns_vl.cost_per_hr%type := fnd_api.g_miss_num;
770:
771: ok_resource_name jtf_rs_resource_extns_vl.resource_name%type := p_resource_name;
772: ok_source_name jtf_rs_resource_extns_vl.source_name%type := p_source_name;
773: ok_address_id jtf_rs_resource_extns_vl.address_id%type := to_number(p_address_id);
774: ok_source_office jtf_rs_resource_extns_vl.source_office%type := p_source_office;
775: ok_source_mailstop jtf_rs_resource_extns_vl.source_mailstop%type := p_source_mailstop;

Line 772: ok_source_name jtf_rs_resource_extns_vl.source_name%type := p_source_name;

768: aprvl_secondary_language jtf_rs_resource_extns_vl.secondary_language%type := fnd_api.g_miss_char;
769: aprvl_cost_per_hr jtf_rs_resource_extns_vl.cost_per_hr%type := fnd_api.g_miss_num;
770:
771: ok_resource_name jtf_rs_resource_extns_vl.resource_name%type := p_resource_name;
772: ok_source_name jtf_rs_resource_extns_vl.source_name%type := p_source_name;
773: ok_address_id jtf_rs_resource_extns_vl.address_id%type := to_number(p_address_id);
774: ok_source_office jtf_rs_resource_extns_vl.source_office%type := p_source_office;
775: ok_source_mailstop jtf_rs_resource_extns_vl.source_mailstop%type := p_source_mailstop;
776: ok_source_location jtf_rs_resource_extns_vl.source_location%type := p_source_location;

Line 773: ok_address_id jtf_rs_resource_extns_vl.address_id%type := to_number(p_address_id);

769: aprvl_cost_per_hr jtf_rs_resource_extns_vl.cost_per_hr%type := fnd_api.g_miss_num;
770:
771: ok_resource_name jtf_rs_resource_extns_vl.resource_name%type := p_resource_name;
772: ok_source_name jtf_rs_resource_extns_vl.source_name%type := p_source_name;
773: ok_address_id jtf_rs_resource_extns_vl.address_id%type := to_number(p_address_id);
774: ok_source_office jtf_rs_resource_extns_vl.source_office%type := p_source_office;
775: ok_source_mailstop jtf_rs_resource_extns_vl.source_mailstop%type := p_source_mailstop;
776: ok_source_location jtf_rs_resource_extns_vl.source_location%type := p_source_location;
777: ok_source_phone jtf_rs_resource_extns_vl.source_phone%type := p_source_phone;

Line 774: ok_source_office jtf_rs_resource_extns_vl.source_office%type := p_source_office;

770:
771: ok_resource_name jtf_rs_resource_extns_vl.resource_name%type := p_resource_name;
772: ok_source_name jtf_rs_resource_extns_vl.source_name%type := p_source_name;
773: ok_address_id jtf_rs_resource_extns_vl.address_id%type := to_number(p_address_id);
774: ok_source_office jtf_rs_resource_extns_vl.source_office%type := p_source_office;
775: ok_source_mailstop jtf_rs_resource_extns_vl.source_mailstop%type := p_source_mailstop;
776: ok_source_location jtf_rs_resource_extns_vl.source_location%type := p_source_location;
777: ok_source_phone jtf_rs_resource_extns_vl.source_phone%type := p_source_phone;
778: ok_source_mobile_phone jtf_rs_resource_extns_vl.source_mobile_phone%type := p_source_mobile_phone;

Line 775: ok_source_mailstop jtf_rs_resource_extns_vl.source_mailstop%type := p_source_mailstop;

771: ok_resource_name jtf_rs_resource_extns_vl.resource_name%type := p_resource_name;
772: ok_source_name jtf_rs_resource_extns_vl.source_name%type := p_source_name;
773: ok_address_id jtf_rs_resource_extns_vl.address_id%type := to_number(p_address_id);
774: ok_source_office jtf_rs_resource_extns_vl.source_office%type := p_source_office;
775: ok_source_mailstop jtf_rs_resource_extns_vl.source_mailstop%type := p_source_mailstop;
776: ok_source_location jtf_rs_resource_extns_vl.source_location%type := p_source_location;
777: ok_source_phone jtf_rs_resource_extns_vl.source_phone%type := p_source_phone;
778: ok_source_mobile_phone jtf_rs_resource_extns_vl.source_mobile_phone%type := p_source_mobile_phone;
779: ok_source_pager jtf_rs_resource_extns_vl.source_pager%type := p_source_pager;

Line 776: ok_source_location jtf_rs_resource_extns_vl.source_location%type := p_source_location;

772: ok_source_name jtf_rs_resource_extns_vl.source_name%type := p_source_name;
773: ok_address_id jtf_rs_resource_extns_vl.address_id%type := to_number(p_address_id);
774: ok_source_office jtf_rs_resource_extns_vl.source_office%type := p_source_office;
775: ok_source_mailstop jtf_rs_resource_extns_vl.source_mailstop%type := p_source_mailstop;
776: ok_source_location jtf_rs_resource_extns_vl.source_location%type := p_source_location;
777: ok_source_phone jtf_rs_resource_extns_vl.source_phone%type := p_source_phone;
778: ok_source_mobile_phone jtf_rs_resource_extns_vl.source_mobile_phone%type := p_source_mobile_phone;
779: ok_source_pager jtf_rs_resource_extns_vl.source_pager%type := p_source_pager;
780: ok_source_email jtf_rs_resource_extns_vl.source_email%type := p_source_email;

Line 777: ok_source_phone jtf_rs_resource_extns_vl.source_phone%type := p_source_phone;

773: ok_address_id jtf_rs_resource_extns_vl.address_id%type := to_number(p_address_id);
774: ok_source_office jtf_rs_resource_extns_vl.source_office%type := p_source_office;
775: ok_source_mailstop jtf_rs_resource_extns_vl.source_mailstop%type := p_source_mailstop;
776: ok_source_location jtf_rs_resource_extns_vl.source_location%type := p_source_location;
777: ok_source_phone jtf_rs_resource_extns_vl.source_phone%type := p_source_phone;
778: ok_source_mobile_phone jtf_rs_resource_extns_vl.source_mobile_phone%type := p_source_mobile_phone;
779: ok_source_pager jtf_rs_resource_extns_vl.source_pager%type := p_source_pager;
780: ok_source_email jtf_rs_resource_extns_vl.source_email%type := p_source_email;
781: ok_time_zone jtf_rs_resource_extns_vl.time_zone%type := p_time_zone;

Line 778: ok_source_mobile_phone jtf_rs_resource_extns_vl.source_mobile_phone%type := p_source_mobile_phone;

774: ok_source_office jtf_rs_resource_extns_vl.source_office%type := p_source_office;
775: ok_source_mailstop jtf_rs_resource_extns_vl.source_mailstop%type := p_source_mailstop;
776: ok_source_location jtf_rs_resource_extns_vl.source_location%type := p_source_location;
777: ok_source_phone jtf_rs_resource_extns_vl.source_phone%type := p_source_phone;
778: ok_source_mobile_phone jtf_rs_resource_extns_vl.source_mobile_phone%type := p_source_mobile_phone;
779: ok_source_pager jtf_rs_resource_extns_vl.source_pager%type := p_source_pager;
780: ok_source_email jtf_rs_resource_extns_vl.source_email%type := p_source_email;
781: ok_time_zone jtf_rs_resource_extns_vl.time_zone%type := p_time_zone;
782: ok_support_site_id jtf_rs_resource_extns_vl.support_site_id%type := p_support_site_id;

Line 779: ok_source_pager jtf_rs_resource_extns_vl.source_pager%type := p_source_pager;

775: ok_source_mailstop jtf_rs_resource_extns_vl.source_mailstop%type := p_source_mailstop;
776: ok_source_location jtf_rs_resource_extns_vl.source_location%type := p_source_location;
777: ok_source_phone jtf_rs_resource_extns_vl.source_phone%type := p_source_phone;
778: ok_source_mobile_phone jtf_rs_resource_extns_vl.source_mobile_phone%type := p_source_mobile_phone;
779: ok_source_pager jtf_rs_resource_extns_vl.source_pager%type := p_source_pager;
780: ok_source_email jtf_rs_resource_extns_vl.source_email%type := p_source_email;
781: ok_time_zone jtf_rs_resource_extns_vl.time_zone%type := p_time_zone;
782: ok_support_site_id jtf_rs_resource_extns_vl.support_site_id%type := p_support_site_id;
783: ok_primary_language jtf_rs_resource_extns_vl.primary_language%type := p_primary_language;

Line 780: ok_source_email jtf_rs_resource_extns_vl.source_email%type := p_source_email;

776: ok_source_location jtf_rs_resource_extns_vl.source_location%type := p_source_location;
777: ok_source_phone jtf_rs_resource_extns_vl.source_phone%type := p_source_phone;
778: ok_source_mobile_phone jtf_rs_resource_extns_vl.source_mobile_phone%type := p_source_mobile_phone;
779: ok_source_pager jtf_rs_resource_extns_vl.source_pager%type := p_source_pager;
780: ok_source_email jtf_rs_resource_extns_vl.source_email%type := p_source_email;
781: ok_time_zone jtf_rs_resource_extns_vl.time_zone%type := p_time_zone;
782: ok_support_site_id jtf_rs_resource_extns_vl.support_site_id%type := p_support_site_id;
783: ok_primary_language jtf_rs_resource_extns_vl.primary_language%type := p_primary_language;
784: ok_secondary_language jtf_rs_resource_extns_vl.secondary_language%type := p_secondary_language;

Line 781: ok_time_zone jtf_rs_resource_extns_vl.time_zone%type := p_time_zone;

777: ok_source_phone jtf_rs_resource_extns_vl.source_phone%type := p_source_phone;
778: ok_source_mobile_phone jtf_rs_resource_extns_vl.source_mobile_phone%type := p_source_mobile_phone;
779: ok_source_pager jtf_rs_resource_extns_vl.source_pager%type := p_source_pager;
780: ok_source_email jtf_rs_resource_extns_vl.source_email%type := p_source_email;
781: ok_time_zone jtf_rs_resource_extns_vl.time_zone%type := p_time_zone;
782: ok_support_site_id jtf_rs_resource_extns_vl.support_site_id%type := p_support_site_id;
783: ok_primary_language jtf_rs_resource_extns_vl.primary_language%type := p_primary_language;
784: ok_secondary_language jtf_rs_resource_extns_vl.secondary_language%type := p_secondary_language;
785: ok_cost_per_hr jtf_rs_resource_extns_vl.cost_per_hr%type := p_cost_per_hr;

Line 782: ok_support_site_id jtf_rs_resource_extns_vl.support_site_id%type := p_support_site_id;

778: ok_source_mobile_phone jtf_rs_resource_extns_vl.source_mobile_phone%type := p_source_mobile_phone;
779: ok_source_pager jtf_rs_resource_extns_vl.source_pager%type := p_source_pager;
780: ok_source_email jtf_rs_resource_extns_vl.source_email%type := p_source_email;
781: ok_time_zone jtf_rs_resource_extns_vl.time_zone%type := p_time_zone;
782: ok_support_site_id jtf_rs_resource_extns_vl.support_site_id%type := p_support_site_id;
783: ok_primary_language jtf_rs_resource_extns_vl.primary_language%type := p_primary_language;
784: ok_secondary_language jtf_rs_resource_extns_vl.secondary_language%type := p_secondary_language;
785: ok_cost_per_hr jtf_rs_resource_extns_vl.cost_per_hr%type := p_cost_per_hr;
786:

Line 783: ok_primary_language jtf_rs_resource_extns_vl.primary_language%type := p_primary_language;

779: ok_source_pager jtf_rs_resource_extns_vl.source_pager%type := p_source_pager;
780: ok_source_email jtf_rs_resource_extns_vl.source_email%type := p_source_email;
781: ok_time_zone jtf_rs_resource_extns_vl.time_zone%type := p_time_zone;
782: ok_support_site_id jtf_rs_resource_extns_vl.support_site_id%type := p_support_site_id;
783: ok_primary_language jtf_rs_resource_extns_vl.primary_language%type := p_primary_language;
784: ok_secondary_language jtf_rs_resource_extns_vl.secondary_language%type := p_secondary_language;
785: ok_cost_per_hr jtf_rs_resource_extns_vl.cost_per_hr%type := p_cost_per_hr;
786:
787: --variables for assg update call

Line 784: ok_secondary_language jtf_rs_resource_extns_vl.secondary_language%type := p_secondary_language;

780: ok_source_email jtf_rs_resource_extns_vl.source_email%type := p_source_email;
781: ok_time_zone jtf_rs_resource_extns_vl.time_zone%type := p_time_zone;
782: ok_support_site_id jtf_rs_resource_extns_vl.support_site_id%type := p_support_site_id;
783: ok_primary_language jtf_rs_resource_extns_vl.primary_language%type := p_primary_language;
784: ok_secondary_language jtf_rs_resource_extns_vl.secondary_language%type := p_secondary_language;
785: ok_cost_per_hr jtf_rs_resource_extns_vl.cost_per_hr%type := p_cost_per_hr;
786:
787: --variables for assg update call
788: l_object_version_number_assg number;

Line 785: ok_cost_per_hr jtf_rs_resource_extns_vl.cost_per_hr%type := p_cost_per_hr;

781: ok_time_zone jtf_rs_resource_extns_vl.time_zone%type := p_time_zone;
782: ok_support_site_id jtf_rs_resource_extns_vl.support_site_id%type := p_support_site_id;
783: ok_primary_language jtf_rs_resource_extns_vl.primary_language%type := p_primary_language;
784: ok_secondary_language jtf_rs_resource_extns_vl.secondary_language%type := p_secondary_language;
785: ok_cost_per_hr jtf_rs_resource_extns_vl.cost_per_hr%type := p_cost_per_hr;
786:
787: --variables for assg update call
788: l_object_version_number_assg number;
789: l_special_ceiling_step_id number;

Line 892: from jtf_rs_resource_extns

888: cursor mgr_res_cur(l_resource_id number)
889: is
890: select source_id,
891: source_name
892: from jtf_rs_resource_extns
893: where resource_id = l_resource_id;
894:
895: l_mgr_source_name jtf_rs_resource_extns.source_name%type := fnd_api.g_miss_char;
896: l_mgr_source_id jtf_rs_resource_extns.source_id%type := fnd_api.g_miss_num;

Line 895: l_mgr_source_name jtf_rs_resource_extns.source_name%type := fnd_api.g_miss_char;

891: source_name
892: from jtf_rs_resource_extns
893: where resource_id = l_resource_id;
894:
895: l_mgr_source_name jtf_rs_resource_extns.source_name%type := fnd_api.g_miss_char;
896: l_mgr_source_id jtf_rs_resource_extns.source_id%type := fnd_api.g_miss_num;
897: l_mgr_name jtf_rs_resource_extns_vl.resource_name%type;
898: mgr_res_rec mgr_res_cur%rowtype;
899:

Line 896: l_mgr_source_id jtf_rs_resource_extns.source_id%type := fnd_api.g_miss_num;

892: from jtf_rs_resource_extns
893: where resource_id = l_resource_id;
894:
895: l_mgr_source_name jtf_rs_resource_extns.source_name%type := fnd_api.g_miss_char;
896: l_mgr_source_id jtf_rs_resource_extns.source_id%type := fnd_api.g_miss_num;
897: l_mgr_name jtf_rs_resource_extns_vl.resource_name%type;
898: mgr_res_rec mgr_res_cur%rowtype;
899:
900: l_fnd_date date := to_date(to_char(fnd_api.g_miss_date, 'DD-MM-RRRR'), 'DD-MM-RRRR');

Line 897: l_mgr_name jtf_rs_resource_extns_vl.resource_name%type;

893: where resource_id = l_resource_id;
894:
895: l_mgr_source_name jtf_rs_resource_extns.source_name%type := fnd_api.g_miss_char;
896: l_mgr_source_id jtf_rs_resource_extns.source_id%type := fnd_api.g_miss_num;
897: l_mgr_name jtf_rs_resource_extns_vl.resource_name%type;
898: mgr_res_rec mgr_res_cur%rowtype;
899:
900: l_fnd_date date := to_date(to_char(fnd_api.g_miss_date, 'DD-MM-RRRR'), 'DD-MM-RRRR');
901: