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_VL

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 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: