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

Line 305: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;

301: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_EMPLOYEE';
302: l_return_status VARCHAR2(2);
303: l_msg_count NUMBER;
304: l_msg_data VARCHAR2(2000);
305: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;
306: l_resource_number jtf_rs_resource_extns.resource_number%TYPE;
307: l_source_number jtf_rs_resource_extns.source_number%TYPE;
308: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
309: -- l_msg_index_out number;

Line 306: l_resource_number jtf_rs_resource_extns.resource_number%TYPE;

302: l_return_status VARCHAR2(2);
303: l_msg_count NUMBER;
304: l_msg_data VARCHAR2(2000);
305: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;
306: l_resource_number jtf_rs_resource_extns.resource_number%TYPE;
307: l_source_number jtf_rs_resource_extns.source_number%TYPE;
308: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
309: -- l_msg_index_out number;
310: -- l_msg_data1 varchar2(5000);

Line 307: l_source_number jtf_rs_resource_extns.source_number%TYPE;

303: l_msg_count NUMBER;
304: l_msg_data VARCHAR2(2000);
305: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;
306: l_resource_number jtf_rs_resource_extns.resource_number%TYPE;
307: l_source_number jtf_rs_resource_extns.source_number%TYPE;
308: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
309: -- l_msg_index_out number;
310: -- l_msg_data1 varchar2(5000);
311:

Line 414: from jtf_rs_resource_extns rsc

410: --, per_employees_current_x emp
411: , per_all_people_f emp
412: -- WHERE NOT EXISTS (select source_id
413: WHERE NOT EXISTS (select 1
414: from jtf_rs_resource_extns rsc
415: where category = 'EMPLOYEE'
416: and ppl.person_id = rsc.source_id)
417: and ppl.business_group_id = org.organization_id
418: and ppl.person_id = asg.person_id

Line 479: from jtf_rs_resource_extns rsc

475: --, per_employees_current_x emp
476: , per_all_people_f emp
477: -- WHERE NOT EXISTS (select source_id
478: WHERE NOT EXISTS (select 1
479: from jtf_rs_resource_extns rsc
480: where category = 'EMPLOYEE'
481: and ppl.person_id = rsc.source_id)
482: and ppl.business_group_id = org.organization_id
483: and ppl.person_id = asg.person_id

Line 1302: FROM jtf_rs_resource_extns_vl rsc

1298: , rsc.source_id
1299: , rsc.object_version_number
1300: -- , rsc.start_date_active
1301: -- , rsc.end_date_active
1302: FROM jtf_rs_resource_extns_vl rsc
1303: WHERE rsc.category = 'EMPLOYEE'
1304: /* AND not exists (select employee_id
1305: from per_employees_current_x emp
1306: where emp.employee_id = rsc.source_id

Line 1529: FROM jtf_rs_resource_extns

1525: source_number,
1526: source_job_id,
1527: start_date_active,
1528: end_date_active
1529: FROM jtf_rs_resource_extns
1530: WHERE category = 'EMPLOYEE';
1531:
1532: CURSOR c_check_rehire_rev_emp(p_person_id IN NUMBER) IS
1533: SELECT 'Y'

Line 1534: FROM jtf_rs_resource_extns rsc

1530: WHERE category = 'EMPLOYEE';
1531:
1532: CURSOR c_check_rehire_rev_emp(p_person_id IN NUMBER) IS
1533: SELECT 'Y'
1534: FROM jtf_rs_resource_extns rsc
1535: WHERE rsc.category = 'EMPLOYEE'
1536: AND rsc.source_id = p_person_id
1537: AND l_sysdate not between trunc(rsc.start_date_active) and trunc(nvl(rsc.end_date_active,sysdate))
1538: -- AND exists ( select cur.employee_id from PER_EMPLOYEES_CURRENT_X cur where cur.employee_id = rsc.source_id);

Line 1545: CURSOR c_salesreps (c_resource_id jtf_rs_resource_extns.resource_id%TYPE) IS

1541: where ppl.person_id = p_person_id
1542: and trunc(sysdate) between ppl.effective_start_date and ppl.effective_end_date
1543: and (ppl.current_employee_flag = 'Y' OR ppl.current_npw_flag = 'Y'));
1544:
1545: CURSOR c_salesreps (c_resource_id jtf_rs_resource_extns.resource_id%TYPE) IS
1546: SELECT salesrep_id
1547: FROM jtf_rs_salesreps
1548: WHERE resource_id = c_resource_id;
1549:

Line 1582: l_source_number jtf_rs_resource_extns.source_number%TYPE;

1578: AND (current_employee_flag = 'Y' OR
1579: current_npw_flag = 'Y');
1580:
1581: l_ppf_rec c_ppf%ROWTYPE;
1582: l_source_number jtf_rs_resource_extns.source_number%TYPE;
1583: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
1584:
1585: CURSOR c_org(p_org_id IN NUMBER) IS
1586: SELECT name

Line 1653: --ER # 2669284. This cursor selects old values from jtf_rs_resource_extns table.

1649: AND phone_type = 'P'
1650: AND g_run_date between date_from and nvl(date_to, to_date('31/12/4712', 'DD/MM/YYYY'));
1651:
1652: --Mugsrin
1653: --ER # 2669284. This cursor selects old values from jtf_rs_resource_extns table.
1654: --Then old values are compared with new values to find out
1655: --whether a row has to be updated and also to insert null for unmodified columns.
1656: CURSOR rr_old_cur(l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE)
1657: IS

Line 1656: CURSOR rr_old_cur(l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE)

1652: --Mugsrin
1653: --ER # 2669284. This cursor selects old values from jtf_rs_resource_extns table.
1654: --Then old values are compared with new values to find out
1655: --whether a row has to be updated and also to insert null for unmodified columns.
1656: CURSOR rr_old_cur(l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE)
1657: IS
1658: SELECT
1659: source_number,
1660: source_name,

Line 1687: FROM jtf_rs_resource_extns_vl

1683: source_pager,
1684: resource_name,
1685: end_date_active,
1686: person_party_id
1687: FROM jtf_rs_resource_extns_vl
1688: WHERE resource_id = l_resource_id;
1689:
1690: rr_old_rec rr_old_cur%rowtype;
1691:

Line 1693: l_source_number_o jtf_rs_resource_extns.source_number%type;

1689:
1690: rr_old_rec rr_old_cur%rowtype;
1691:
1692: --ER # 2669284. Resource old values
1693: l_source_number_o jtf_rs_resource_extns.source_number%type;
1694: l_source_name_o jtf_rs_resource_extns.source_name%type;
1695: l_source_first_name_o jtf_rs_resource_extns.source_first_name%type;
1696: l_source_middle_name_o jtf_rs_resource_extns.source_middle_name%type;
1697: l_source_last_name_o jtf_rs_resource_extns.source_last_name%type;

Line 1694: l_source_name_o jtf_rs_resource_extns.source_name%type;

1690: rr_old_rec rr_old_cur%rowtype;
1691:
1692: --ER # 2669284. Resource old values
1693: l_source_number_o jtf_rs_resource_extns.source_number%type;
1694: l_source_name_o jtf_rs_resource_extns.source_name%type;
1695: l_source_first_name_o jtf_rs_resource_extns.source_first_name%type;
1696: l_source_middle_name_o jtf_rs_resource_extns.source_middle_name%type;
1697: l_source_last_name_o jtf_rs_resource_extns.source_last_name%type;
1698: l_source_phone_o jtf_rs_resource_extns.source_phone%type;

Line 1695: l_source_first_name_o jtf_rs_resource_extns.source_first_name%type;

1691:
1692: --ER # 2669284. Resource old values
1693: l_source_number_o jtf_rs_resource_extns.source_number%type;
1694: l_source_name_o jtf_rs_resource_extns.source_name%type;
1695: l_source_first_name_o jtf_rs_resource_extns.source_first_name%type;
1696: l_source_middle_name_o jtf_rs_resource_extns.source_middle_name%type;
1697: l_source_last_name_o jtf_rs_resource_extns.source_last_name%type;
1698: l_source_phone_o jtf_rs_resource_extns.source_phone%type;
1699: l_source_email_o jtf_rs_resource_extns.source_email%type;

Line 1696: l_source_middle_name_o jtf_rs_resource_extns.source_middle_name%type;

1692: --ER # 2669284. Resource old values
1693: l_source_number_o jtf_rs_resource_extns.source_number%type;
1694: l_source_name_o jtf_rs_resource_extns.source_name%type;
1695: l_source_first_name_o jtf_rs_resource_extns.source_first_name%type;
1696: l_source_middle_name_o jtf_rs_resource_extns.source_middle_name%type;
1697: l_source_last_name_o jtf_rs_resource_extns.source_last_name%type;
1698: l_source_phone_o jtf_rs_resource_extns.source_phone%type;
1699: l_source_email_o jtf_rs_resource_extns.source_email%type;
1700: l_source_job_id_o jtf_rs_resource_extns.source_job_id%type;

Line 1697: l_source_last_name_o jtf_rs_resource_extns.source_last_name%type;

1693: l_source_number_o jtf_rs_resource_extns.source_number%type;
1694: l_source_name_o jtf_rs_resource_extns.source_name%type;
1695: l_source_first_name_o jtf_rs_resource_extns.source_first_name%type;
1696: l_source_middle_name_o jtf_rs_resource_extns.source_middle_name%type;
1697: l_source_last_name_o jtf_rs_resource_extns.source_last_name%type;
1698: l_source_phone_o jtf_rs_resource_extns.source_phone%type;
1699: l_source_email_o jtf_rs_resource_extns.source_email%type;
1700: l_source_job_id_o jtf_rs_resource_extns.source_job_id%type;
1701: l_source_job_title_o jtf_rs_resource_extns.source_job_title%type;

Line 1698: l_source_phone_o jtf_rs_resource_extns.source_phone%type;

1694: l_source_name_o jtf_rs_resource_extns.source_name%type;
1695: l_source_first_name_o jtf_rs_resource_extns.source_first_name%type;
1696: l_source_middle_name_o jtf_rs_resource_extns.source_middle_name%type;
1697: l_source_last_name_o jtf_rs_resource_extns.source_last_name%type;
1698: l_source_phone_o jtf_rs_resource_extns.source_phone%type;
1699: l_source_email_o jtf_rs_resource_extns.source_email%type;
1700: l_source_job_id_o jtf_rs_resource_extns.source_job_id%type;
1701: l_source_job_title_o jtf_rs_resource_extns.source_job_title%type;
1702: l_address_id_o jtf_rs_resource_extns.address_id%type ;

Line 1699: l_source_email_o jtf_rs_resource_extns.source_email%type;

1695: l_source_first_name_o jtf_rs_resource_extns.source_first_name%type;
1696: l_source_middle_name_o jtf_rs_resource_extns.source_middle_name%type;
1697: l_source_last_name_o jtf_rs_resource_extns.source_last_name%type;
1698: l_source_phone_o jtf_rs_resource_extns.source_phone%type;
1699: l_source_email_o jtf_rs_resource_extns.source_email%type;
1700: l_source_job_id_o jtf_rs_resource_extns.source_job_id%type;
1701: l_source_job_title_o jtf_rs_resource_extns.source_job_title%type;
1702: l_address_id_o jtf_rs_resource_extns.address_id%type ;
1703: l_source_address1_o jtf_rs_resource_extns.source_address1%type;

Line 1700: l_source_job_id_o jtf_rs_resource_extns.source_job_id%type;

1696: l_source_middle_name_o jtf_rs_resource_extns.source_middle_name%type;
1697: l_source_last_name_o jtf_rs_resource_extns.source_last_name%type;
1698: l_source_phone_o jtf_rs_resource_extns.source_phone%type;
1699: l_source_email_o jtf_rs_resource_extns.source_email%type;
1700: l_source_job_id_o jtf_rs_resource_extns.source_job_id%type;
1701: l_source_job_title_o jtf_rs_resource_extns.source_job_title%type;
1702: l_address_id_o jtf_rs_resource_extns.address_id%type ;
1703: l_source_address1_o jtf_rs_resource_extns.source_address1%type;
1704: l_source_address2_o jtf_rs_resource_extns.source_address2%type;

Line 1701: l_source_job_title_o jtf_rs_resource_extns.source_job_title%type;

1697: l_source_last_name_o jtf_rs_resource_extns.source_last_name%type;
1698: l_source_phone_o jtf_rs_resource_extns.source_phone%type;
1699: l_source_email_o jtf_rs_resource_extns.source_email%type;
1700: l_source_job_id_o jtf_rs_resource_extns.source_job_id%type;
1701: l_source_job_title_o jtf_rs_resource_extns.source_job_title%type;
1702: l_address_id_o jtf_rs_resource_extns.address_id%type ;
1703: l_source_address1_o jtf_rs_resource_extns.source_address1%type;
1704: l_source_address2_o jtf_rs_resource_extns.source_address2%type;
1705: l_source_address3_o jtf_rs_resource_extns.source_address3%type;

Line 1702: l_address_id_o jtf_rs_resource_extns.address_id%type ;

1698: l_source_phone_o jtf_rs_resource_extns.source_phone%type;
1699: l_source_email_o jtf_rs_resource_extns.source_email%type;
1700: l_source_job_id_o jtf_rs_resource_extns.source_job_id%type;
1701: l_source_job_title_o jtf_rs_resource_extns.source_job_title%type;
1702: l_address_id_o jtf_rs_resource_extns.address_id%type ;
1703: l_source_address1_o jtf_rs_resource_extns.source_address1%type;
1704: l_source_address2_o jtf_rs_resource_extns.source_address2%type;
1705: l_source_address3_o jtf_rs_resource_extns.source_address3%type;
1706: l_source_city_o jtf_rs_resource_extns.source_city%type;

Line 1703: l_source_address1_o jtf_rs_resource_extns.source_address1%type;

1699: l_source_email_o jtf_rs_resource_extns.source_email%type;
1700: l_source_job_id_o jtf_rs_resource_extns.source_job_id%type;
1701: l_source_job_title_o jtf_rs_resource_extns.source_job_title%type;
1702: l_address_id_o jtf_rs_resource_extns.address_id%type ;
1703: l_source_address1_o jtf_rs_resource_extns.source_address1%type;
1704: l_source_address2_o jtf_rs_resource_extns.source_address2%type;
1705: l_source_address3_o jtf_rs_resource_extns.source_address3%type;
1706: l_source_city_o jtf_rs_resource_extns.source_city%type;
1707: l_source_country_o jtf_rs_resource_extns.source_country%type;

Line 1704: l_source_address2_o jtf_rs_resource_extns.source_address2%type;

1700: l_source_job_id_o jtf_rs_resource_extns.source_job_id%type;
1701: l_source_job_title_o jtf_rs_resource_extns.source_job_title%type;
1702: l_address_id_o jtf_rs_resource_extns.address_id%type ;
1703: l_source_address1_o jtf_rs_resource_extns.source_address1%type;
1704: l_source_address2_o jtf_rs_resource_extns.source_address2%type;
1705: l_source_address3_o jtf_rs_resource_extns.source_address3%type;
1706: l_source_city_o jtf_rs_resource_extns.source_city%type;
1707: l_source_country_o jtf_rs_resource_extns.source_country%type;
1708: l_source_postal_code_o jtf_rs_resource_extns.source_postal_code%type;

Line 1705: l_source_address3_o jtf_rs_resource_extns.source_address3%type;

1701: l_source_job_title_o jtf_rs_resource_extns.source_job_title%type;
1702: l_address_id_o jtf_rs_resource_extns.address_id%type ;
1703: l_source_address1_o jtf_rs_resource_extns.source_address1%type;
1704: l_source_address2_o jtf_rs_resource_extns.source_address2%type;
1705: l_source_address3_o jtf_rs_resource_extns.source_address3%type;
1706: l_source_city_o jtf_rs_resource_extns.source_city%type;
1707: l_source_country_o jtf_rs_resource_extns.source_country%type;
1708: l_source_postal_code_o jtf_rs_resource_extns.source_postal_code%type;
1709: l_source_mgr_id_o jtf_rs_resource_extns.source_mgr_id%type;

Line 1706: l_source_city_o jtf_rs_resource_extns.source_city%type;

1702: l_address_id_o jtf_rs_resource_extns.address_id%type ;
1703: l_source_address1_o jtf_rs_resource_extns.source_address1%type;
1704: l_source_address2_o jtf_rs_resource_extns.source_address2%type;
1705: l_source_address3_o jtf_rs_resource_extns.source_address3%type;
1706: l_source_city_o jtf_rs_resource_extns.source_city%type;
1707: l_source_country_o jtf_rs_resource_extns.source_country%type;
1708: l_source_postal_code_o jtf_rs_resource_extns.source_postal_code%type;
1709: l_source_mgr_id_o jtf_rs_resource_extns.source_mgr_id%type;
1710: l_source_mgr_name_o jtf_rs_resource_extns.source_mgr_name%type;

Line 1707: l_source_country_o jtf_rs_resource_extns.source_country%type;

1703: l_source_address1_o jtf_rs_resource_extns.source_address1%type;
1704: l_source_address2_o jtf_rs_resource_extns.source_address2%type;
1705: l_source_address3_o jtf_rs_resource_extns.source_address3%type;
1706: l_source_city_o jtf_rs_resource_extns.source_city%type;
1707: l_source_country_o jtf_rs_resource_extns.source_country%type;
1708: l_source_postal_code_o jtf_rs_resource_extns.source_postal_code%type;
1709: l_source_mgr_id_o jtf_rs_resource_extns.source_mgr_id%type;
1710: l_source_mgr_name_o jtf_rs_resource_extns.source_mgr_name%type;
1711: l_source_business_grp_id_o jtf_rs_resource_extns.source_business_grp_id%type;

Line 1708: l_source_postal_code_o jtf_rs_resource_extns.source_postal_code%type;

1704: l_source_address2_o jtf_rs_resource_extns.source_address2%type;
1705: l_source_address3_o jtf_rs_resource_extns.source_address3%type;
1706: l_source_city_o jtf_rs_resource_extns.source_city%type;
1707: l_source_country_o jtf_rs_resource_extns.source_country%type;
1708: l_source_postal_code_o jtf_rs_resource_extns.source_postal_code%type;
1709: l_source_mgr_id_o jtf_rs_resource_extns.source_mgr_id%type;
1710: l_source_mgr_name_o jtf_rs_resource_extns.source_mgr_name%type;
1711: l_source_business_grp_id_o jtf_rs_resource_extns.source_business_grp_id%type;
1712: l_source_business_grp_name_o jtf_rs_resource_extns.source_business_grp_name%type;

Line 1709: l_source_mgr_id_o jtf_rs_resource_extns.source_mgr_id%type;

1705: l_source_address3_o jtf_rs_resource_extns.source_address3%type;
1706: l_source_city_o jtf_rs_resource_extns.source_city%type;
1707: l_source_country_o jtf_rs_resource_extns.source_country%type;
1708: l_source_postal_code_o jtf_rs_resource_extns.source_postal_code%type;
1709: l_source_mgr_id_o jtf_rs_resource_extns.source_mgr_id%type;
1710: l_source_mgr_name_o jtf_rs_resource_extns.source_mgr_name%type;
1711: l_source_business_grp_id_o jtf_rs_resource_extns.source_business_grp_id%type;
1712: l_source_business_grp_name_o jtf_rs_resource_extns.source_business_grp_name%type;
1713: l_source_office_o jtf_rs_resource_extns.source_office%type;

Line 1710: l_source_mgr_name_o jtf_rs_resource_extns.source_mgr_name%type;

1706: l_source_city_o jtf_rs_resource_extns.source_city%type;
1707: l_source_country_o jtf_rs_resource_extns.source_country%type;
1708: l_source_postal_code_o jtf_rs_resource_extns.source_postal_code%type;
1709: l_source_mgr_id_o jtf_rs_resource_extns.source_mgr_id%type;
1710: l_source_mgr_name_o jtf_rs_resource_extns.source_mgr_name%type;
1711: l_source_business_grp_id_o jtf_rs_resource_extns.source_business_grp_id%type;
1712: l_source_business_grp_name_o jtf_rs_resource_extns.source_business_grp_name%type;
1713: l_source_office_o jtf_rs_resource_extns.source_office%type;
1714: l_source_location_o jtf_rs_resource_extns.source_location%type;

Line 1711: l_source_business_grp_id_o jtf_rs_resource_extns.source_business_grp_id%type;

1707: l_source_country_o jtf_rs_resource_extns.source_country%type;
1708: l_source_postal_code_o jtf_rs_resource_extns.source_postal_code%type;
1709: l_source_mgr_id_o jtf_rs_resource_extns.source_mgr_id%type;
1710: l_source_mgr_name_o jtf_rs_resource_extns.source_mgr_name%type;
1711: l_source_business_grp_id_o jtf_rs_resource_extns.source_business_grp_id%type;
1712: l_source_business_grp_name_o jtf_rs_resource_extns.source_business_grp_name%type;
1713: l_source_office_o jtf_rs_resource_extns.source_office%type;
1714: l_source_location_o jtf_rs_resource_extns.source_location%type;
1715: l_source_mailstop_o jtf_rs_resource_extns.source_mailstop%type;

Line 1712: l_source_business_grp_name_o jtf_rs_resource_extns.source_business_grp_name%type;

1708: l_source_postal_code_o jtf_rs_resource_extns.source_postal_code%type;
1709: l_source_mgr_id_o jtf_rs_resource_extns.source_mgr_id%type;
1710: l_source_mgr_name_o jtf_rs_resource_extns.source_mgr_name%type;
1711: l_source_business_grp_id_o jtf_rs_resource_extns.source_business_grp_id%type;
1712: l_source_business_grp_name_o jtf_rs_resource_extns.source_business_grp_name%type;
1713: l_source_office_o jtf_rs_resource_extns.source_office%type;
1714: l_source_location_o jtf_rs_resource_extns.source_location%type;
1715: l_source_mailstop_o jtf_rs_resource_extns.source_mailstop%type;
1716: l_source_mobile_phone_o jtf_rs_resource_extns.source_mobile_phone%type;

Line 1713: l_source_office_o jtf_rs_resource_extns.source_office%type;

1709: l_source_mgr_id_o jtf_rs_resource_extns.source_mgr_id%type;
1710: l_source_mgr_name_o jtf_rs_resource_extns.source_mgr_name%type;
1711: l_source_business_grp_id_o jtf_rs_resource_extns.source_business_grp_id%type;
1712: l_source_business_grp_name_o jtf_rs_resource_extns.source_business_grp_name%type;
1713: l_source_office_o jtf_rs_resource_extns.source_office%type;
1714: l_source_location_o jtf_rs_resource_extns.source_location%type;
1715: l_source_mailstop_o jtf_rs_resource_extns.source_mailstop%type;
1716: l_source_mobile_phone_o jtf_rs_resource_extns.source_mobile_phone%type;
1717: l_source_pager_o jtf_rs_resource_extns.source_pager%type;

Line 1714: l_source_location_o jtf_rs_resource_extns.source_location%type;

1710: l_source_mgr_name_o jtf_rs_resource_extns.source_mgr_name%type;
1711: l_source_business_grp_id_o jtf_rs_resource_extns.source_business_grp_id%type;
1712: l_source_business_grp_name_o jtf_rs_resource_extns.source_business_grp_name%type;
1713: l_source_office_o jtf_rs_resource_extns.source_office%type;
1714: l_source_location_o jtf_rs_resource_extns.source_location%type;
1715: l_source_mailstop_o jtf_rs_resource_extns.source_mailstop%type;
1716: l_source_mobile_phone_o jtf_rs_resource_extns.source_mobile_phone%type;
1717: l_source_pager_o jtf_rs_resource_extns.source_pager%type;
1718: l_resource_name_o jtf_rs_resource_extns_vl.resource_name%type;

Line 1715: l_source_mailstop_o jtf_rs_resource_extns.source_mailstop%type;

1711: l_source_business_grp_id_o jtf_rs_resource_extns.source_business_grp_id%type;
1712: l_source_business_grp_name_o jtf_rs_resource_extns.source_business_grp_name%type;
1713: l_source_office_o jtf_rs_resource_extns.source_office%type;
1714: l_source_location_o jtf_rs_resource_extns.source_location%type;
1715: l_source_mailstop_o jtf_rs_resource_extns.source_mailstop%type;
1716: l_source_mobile_phone_o jtf_rs_resource_extns.source_mobile_phone%type;
1717: l_source_pager_o jtf_rs_resource_extns.source_pager%type;
1718: l_resource_name_o jtf_rs_resource_extns_vl.resource_name%type;
1719: l_end_date_active_o jtf_rs_resource_extns_vl.end_date_active%type;

Line 1716: l_source_mobile_phone_o jtf_rs_resource_extns.source_mobile_phone%type;

1712: l_source_business_grp_name_o jtf_rs_resource_extns.source_business_grp_name%type;
1713: l_source_office_o jtf_rs_resource_extns.source_office%type;
1714: l_source_location_o jtf_rs_resource_extns.source_location%type;
1715: l_source_mailstop_o jtf_rs_resource_extns.source_mailstop%type;
1716: l_source_mobile_phone_o jtf_rs_resource_extns.source_mobile_phone%type;
1717: l_source_pager_o jtf_rs_resource_extns.source_pager%type;
1718: l_resource_name_o jtf_rs_resource_extns_vl.resource_name%type;
1719: l_end_date_active_o jtf_rs_resource_extns_vl.end_date_active%type;
1720: l_party_id_o jtf_rs_resource_extns_vl.person_party_id%type;

Line 1717: l_source_pager_o jtf_rs_resource_extns.source_pager%type;

1713: l_source_office_o jtf_rs_resource_extns.source_office%type;
1714: l_source_location_o jtf_rs_resource_extns.source_location%type;
1715: l_source_mailstop_o jtf_rs_resource_extns.source_mailstop%type;
1716: l_source_mobile_phone_o jtf_rs_resource_extns.source_mobile_phone%type;
1717: l_source_pager_o jtf_rs_resource_extns.source_pager%type;
1718: l_resource_name_o jtf_rs_resource_extns_vl.resource_name%type;
1719: l_end_date_active_o jtf_rs_resource_extns_vl.end_date_active%type;
1720: l_party_id_o jtf_rs_resource_extns_vl.person_party_id%type;
1721:

Line 1718: l_resource_name_o jtf_rs_resource_extns_vl.resource_name%type;

1714: l_source_location_o jtf_rs_resource_extns.source_location%type;
1715: l_source_mailstop_o jtf_rs_resource_extns.source_mailstop%type;
1716: l_source_mobile_phone_o jtf_rs_resource_extns.source_mobile_phone%type;
1717: l_source_pager_o jtf_rs_resource_extns.source_pager%type;
1718: l_resource_name_o jtf_rs_resource_extns_vl.resource_name%type;
1719: l_end_date_active_o jtf_rs_resource_extns_vl.end_date_active%type;
1720: l_party_id_o jtf_rs_resource_extns_vl.person_party_id%type;
1721:
1722: --ER # 2669284. Resource new values

Line 1719: l_end_date_active_o jtf_rs_resource_extns_vl.end_date_active%type;

1715: l_source_mailstop_o jtf_rs_resource_extns.source_mailstop%type;
1716: l_source_mobile_phone_o jtf_rs_resource_extns.source_mobile_phone%type;
1717: l_source_pager_o jtf_rs_resource_extns.source_pager%type;
1718: l_resource_name_o jtf_rs_resource_extns_vl.resource_name%type;
1719: l_end_date_active_o jtf_rs_resource_extns_vl.end_date_active%type;
1720: l_party_id_o jtf_rs_resource_extns_vl.person_party_id%type;
1721:
1722: --ER # 2669284. Resource new values
1723: l_source_number_n jtf_rs_resource_extns.source_number%type;

Line 1720: l_party_id_o jtf_rs_resource_extns_vl.person_party_id%type;

1716: l_source_mobile_phone_o jtf_rs_resource_extns.source_mobile_phone%type;
1717: l_source_pager_o jtf_rs_resource_extns.source_pager%type;
1718: l_resource_name_o jtf_rs_resource_extns_vl.resource_name%type;
1719: l_end_date_active_o jtf_rs_resource_extns_vl.end_date_active%type;
1720: l_party_id_o jtf_rs_resource_extns_vl.person_party_id%type;
1721:
1722: --ER # 2669284. Resource new values
1723: l_source_number_n jtf_rs_resource_extns.source_number%type;
1724: l_source_name_n jtf_rs_resource_extns.source_name%type;

Line 1723: l_source_number_n jtf_rs_resource_extns.source_number%type;

1719: l_end_date_active_o jtf_rs_resource_extns_vl.end_date_active%type;
1720: l_party_id_o jtf_rs_resource_extns_vl.person_party_id%type;
1721:
1722: --ER # 2669284. Resource new values
1723: l_source_number_n jtf_rs_resource_extns.source_number%type;
1724: l_source_name_n jtf_rs_resource_extns.source_name%type;
1725: l_source_first_name_n jtf_rs_resource_extns.source_first_name%type;
1726: l_source_middle_name_n jtf_rs_resource_extns.source_middle_name%type;
1727: l_source_last_name_n jtf_rs_resource_extns.source_last_name%type;

Line 1724: l_source_name_n jtf_rs_resource_extns.source_name%type;

1720: l_party_id_o jtf_rs_resource_extns_vl.person_party_id%type;
1721:
1722: --ER # 2669284. Resource new values
1723: l_source_number_n jtf_rs_resource_extns.source_number%type;
1724: l_source_name_n jtf_rs_resource_extns.source_name%type;
1725: l_source_first_name_n jtf_rs_resource_extns.source_first_name%type;
1726: l_source_middle_name_n jtf_rs_resource_extns.source_middle_name%type;
1727: l_source_last_name_n jtf_rs_resource_extns.source_last_name%type;
1728: l_source_phone_n jtf_rs_resource_extns.source_phone%type;

Line 1725: l_source_first_name_n jtf_rs_resource_extns.source_first_name%type;

1721:
1722: --ER # 2669284. Resource new values
1723: l_source_number_n jtf_rs_resource_extns.source_number%type;
1724: l_source_name_n jtf_rs_resource_extns.source_name%type;
1725: l_source_first_name_n jtf_rs_resource_extns.source_first_name%type;
1726: l_source_middle_name_n jtf_rs_resource_extns.source_middle_name%type;
1727: l_source_last_name_n jtf_rs_resource_extns.source_last_name%type;
1728: l_source_phone_n jtf_rs_resource_extns.source_phone%type;
1729: l_source_email_n jtf_rs_resource_extns.source_email%type;

Line 1726: l_source_middle_name_n jtf_rs_resource_extns.source_middle_name%type;

1722: --ER # 2669284. Resource new values
1723: l_source_number_n jtf_rs_resource_extns.source_number%type;
1724: l_source_name_n jtf_rs_resource_extns.source_name%type;
1725: l_source_first_name_n jtf_rs_resource_extns.source_first_name%type;
1726: l_source_middle_name_n jtf_rs_resource_extns.source_middle_name%type;
1727: l_source_last_name_n jtf_rs_resource_extns.source_last_name%type;
1728: l_source_phone_n jtf_rs_resource_extns.source_phone%type;
1729: l_source_email_n jtf_rs_resource_extns.source_email%type;
1730: l_source_job_id_n jtf_rs_resource_extns.source_job_id%type;

Line 1727: l_source_last_name_n jtf_rs_resource_extns.source_last_name%type;

1723: l_source_number_n jtf_rs_resource_extns.source_number%type;
1724: l_source_name_n jtf_rs_resource_extns.source_name%type;
1725: l_source_first_name_n jtf_rs_resource_extns.source_first_name%type;
1726: l_source_middle_name_n jtf_rs_resource_extns.source_middle_name%type;
1727: l_source_last_name_n jtf_rs_resource_extns.source_last_name%type;
1728: l_source_phone_n jtf_rs_resource_extns.source_phone%type;
1729: l_source_email_n jtf_rs_resource_extns.source_email%type;
1730: l_source_job_id_n jtf_rs_resource_extns.source_job_id%type;
1731: l_source_job_title_n jtf_rs_resource_extns.source_job_title%type;

Line 1728: l_source_phone_n jtf_rs_resource_extns.source_phone%type;

1724: l_source_name_n jtf_rs_resource_extns.source_name%type;
1725: l_source_first_name_n jtf_rs_resource_extns.source_first_name%type;
1726: l_source_middle_name_n jtf_rs_resource_extns.source_middle_name%type;
1727: l_source_last_name_n jtf_rs_resource_extns.source_last_name%type;
1728: l_source_phone_n jtf_rs_resource_extns.source_phone%type;
1729: l_source_email_n jtf_rs_resource_extns.source_email%type;
1730: l_source_job_id_n jtf_rs_resource_extns.source_job_id%type;
1731: l_source_job_title_n jtf_rs_resource_extns.source_job_title%type;
1732: l_address_id_n jtf_rs_resource_extns.address_id%type ;

Line 1729: l_source_email_n jtf_rs_resource_extns.source_email%type;

1725: l_source_first_name_n jtf_rs_resource_extns.source_first_name%type;
1726: l_source_middle_name_n jtf_rs_resource_extns.source_middle_name%type;
1727: l_source_last_name_n jtf_rs_resource_extns.source_last_name%type;
1728: l_source_phone_n jtf_rs_resource_extns.source_phone%type;
1729: l_source_email_n jtf_rs_resource_extns.source_email%type;
1730: l_source_job_id_n jtf_rs_resource_extns.source_job_id%type;
1731: l_source_job_title_n jtf_rs_resource_extns.source_job_title%type;
1732: l_address_id_n jtf_rs_resource_extns.address_id%type ;
1733: l_source_address1_n jtf_rs_resource_extns.source_address1%type;

Line 1730: l_source_job_id_n jtf_rs_resource_extns.source_job_id%type;

1726: l_source_middle_name_n jtf_rs_resource_extns.source_middle_name%type;
1727: l_source_last_name_n jtf_rs_resource_extns.source_last_name%type;
1728: l_source_phone_n jtf_rs_resource_extns.source_phone%type;
1729: l_source_email_n jtf_rs_resource_extns.source_email%type;
1730: l_source_job_id_n jtf_rs_resource_extns.source_job_id%type;
1731: l_source_job_title_n jtf_rs_resource_extns.source_job_title%type;
1732: l_address_id_n jtf_rs_resource_extns.address_id%type ;
1733: l_source_address1_n jtf_rs_resource_extns.source_address1%type;
1734: l_source_address2_n jtf_rs_resource_extns.source_address2%type;

Line 1731: l_source_job_title_n jtf_rs_resource_extns.source_job_title%type;

1727: l_source_last_name_n jtf_rs_resource_extns.source_last_name%type;
1728: l_source_phone_n jtf_rs_resource_extns.source_phone%type;
1729: l_source_email_n jtf_rs_resource_extns.source_email%type;
1730: l_source_job_id_n jtf_rs_resource_extns.source_job_id%type;
1731: l_source_job_title_n jtf_rs_resource_extns.source_job_title%type;
1732: l_address_id_n jtf_rs_resource_extns.address_id%type ;
1733: l_source_address1_n jtf_rs_resource_extns.source_address1%type;
1734: l_source_address2_n jtf_rs_resource_extns.source_address2%type;
1735: l_source_address3_n jtf_rs_resource_extns.source_address3%type;

Line 1732: l_address_id_n jtf_rs_resource_extns.address_id%type ;

1728: l_source_phone_n jtf_rs_resource_extns.source_phone%type;
1729: l_source_email_n jtf_rs_resource_extns.source_email%type;
1730: l_source_job_id_n jtf_rs_resource_extns.source_job_id%type;
1731: l_source_job_title_n jtf_rs_resource_extns.source_job_title%type;
1732: l_address_id_n jtf_rs_resource_extns.address_id%type ;
1733: l_source_address1_n jtf_rs_resource_extns.source_address1%type;
1734: l_source_address2_n jtf_rs_resource_extns.source_address2%type;
1735: l_source_address3_n jtf_rs_resource_extns.source_address3%type;
1736: l_source_city_n jtf_rs_resource_extns.source_city%type;

Line 1733: l_source_address1_n jtf_rs_resource_extns.source_address1%type;

1729: l_source_email_n jtf_rs_resource_extns.source_email%type;
1730: l_source_job_id_n jtf_rs_resource_extns.source_job_id%type;
1731: l_source_job_title_n jtf_rs_resource_extns.source_job_title%type;
1732: l_address_id_n jtf_rs_resource_extns.address_id%type ;
1733: l_source_address1_n jtf_rs_resource_extns.source_address1%type;
1734: l_source_address2_n jtf_rs_resource_extns.source_address2%type;
1735: l_source_address3_n jtf_rs_resource_extns.source_address3%type;
1736: l_source_city_n jtf_rs_resource_extns.source_city%type;
1737: l_source_country_n jtf_rs_resource_extns.source_country%type;

Line 1734: l_source_address2_n jtf_rs_resource_extns.source_address2%type;

1730: l_source_job_id_n jtf_rs_resource_extns.source_job_id%type;
1731: l_source_job_title_n jtf_rs_resource_extns.source_job_title%type;
1732: l_address_id_n jtf_rs_resource_extns.address_id%type ;
1733: l_source_address1_n jtf_rs_resource_extns.source_address1%type;
1734: l_source_address2_n jtf_rs_resource_extns.source_address2%type;
1735: l_source_address3_n jtf_rs_resource_extns.source_address3%type;
1736: l_source_city_n jtf_rs_resource_extns.source_city%type;
1737: l_source_country_n jtf_rs_resource_extns.source_country%type;
1738: l_source_postal_code_n jtf_rs_resource_extns.source_postal_code%type;

Line 1735: l_source_address3_n jtf_rs_resource_extns.source_address3%type;

1731: l_source_job_title_n jtf_rs_resource_extns.source_job_title%type;
1732: l_address_id_n jtf_rs_resource_extns.address_id%type ;
1733: l_source_address1_n jtf_rs_resource_extns.source_address1%type;
1734: l_source_address2_n jtf_rs_resource_extns.source_address2%type;
1735: l_source_address3_n jtf_rs_resource_extns.source_address3%type;
1736: l_source_city_n jtf_rs_resource_extns.source_city%type;
1737: l_source_country_n jtf_rs_resource_extns.source_country%type;
1738: l_source_postal_code_n jtf_rs_resource_extns.source_postal_code%type;
1739: l_source_mgr_id_n jtf_rs_resource_extns.source_mgr_id%type;

Line 1736: l_source_city_n jtf_rs_resource_extns.source_city%type;

1732: l_address_id_n jtf_rs_resource_extns.address_id%type ;
1733: l_source_address1_n jtf_rs_resource_extns.source_address1%type;
1734: l_source_address2_n jtf_rs_resource_extns.source_address2%type;
1735: l_source_address3_n jtf_rs_resource_extns.source_address3%type;
1736: l_source_city_n jtf_rs_resource_extns.source_city%type;
1737: l_source_country_n jtf_rs_resource_extns.source_country%type;
1738: l_source_postal_code_n jtf_rs_resource_extns.source_postal_code%type;
1739: l_source_mgr_id_n jtf_rs_resource_extns.source_mgr_id%type;
1740: l_source_mgr_name_n jtf_rs_resource_extns.source_mgr_name%type;

Line 1737: l_source_country_n jtf_rs_resource_extns.source_country%type;

1733: l_source_address1_n jtf_rs_resource_extns.source_address1%type;
1734: l_source_address2_n jtf_rs_resource_extns.source_address2%type;
1735: l_source_address3_n jtf_rs_resource_extns.source_address3%type;
1736: l_source_city_n jtf_rs_resource_extns.source_city%type;
1737: l_source_country_n jtf_rs_resource_extns.source_country%type;
1738: l_source_postal_code_n jtf_rs_resource_extns.source_postal_code%type;
1739: l_source_mgr_id_n jtf_rs_resource_extns.source_mgr_id%type;
1740: l_source_mgr_name_n jtf_rs_resource_extns.source_mgr_name%type;
1741: l_source_business_grp_id_n jtf_rs_resource_extns.source_business_grp_id%type;

Line 1738: l_source_postal_code_n jtf_rs_resource_extns.source_postal_code%type;

1734: l_source_address2_n jtf_rs_resource_extns.source_address2%type;
1735: l_source_address3_n jtf_rs_resource_extns.source_address3%type;
1736: l_source_city_n jtf_rs_resource_extns.source_city%type;
1737: l_source_country_n jtf_rs_resource_extns.source_country%type;
1738: l_source_postal_code_n jtf_rs_resource_extns.source_postal_code%type;
1739: l_source_mgr_id_n jtf_rs_resource_extns.source_mgr_id%type;
1740: l_source_mgr_name_n jtf_rs_resource_extns.source_mgr_name%type;
1741: l_source_business_grp_id_n jtf_rs_resource_extns.source_business_grp_id%type;
1742: l_source_business_grp_name_n jtf_rs_resource_extns.source_business_grp_name%type;

Line 1739: l_source_mgr_id_n jtf_rs_resource_extns.source_mgr_id%type;

1735: l_source_address3_n jtf_rs_resource_extns.source_address3%type;
1736: l_source_city_n jtf_rs_resource_extns.source_city%type;
1737: l_source_country_n jtf_rs_resource_extns.source_country%type;
1738: l_source_postal_code_n jtf_rs_resource_extns.source_postal_code%type;
1739: l_source_mgr_id_n jtf_rs_resource_extns.source_mgr_id%type;
1740: l_source_mgr_name_n jtf_rs_resource_extns.source_mgr_name%type;
1741: l_source_business_grp_id_n jtf_rs_resource_extns.source_business_grp_id%type;
1742: l_source_business_grp_name_n jtf_rs_resource_extns.source_business_grp_name%type;
1743: l_source_office_n jtf_rs_resource_extns.source_office%type;

Line 1740: l_source_mgr_name_n jtf_rs_resource_extns.source_mgr_name%type;

1736: l_source_city_n jtf_rs_resource_extns.source_city%type;
1737: l_source_country_n jtf_rs_resource_extns.source_country%type;
1738: l_source_postal_code_n jtf_rs_resource_extns.source_postal_code%type;
1739: l_source_mgr_id_n jtf_rs_resource_extns.source_mgr_id%type;
1740: l_source_mgr_name_n jtf_rs_resource_extns.source_mgr_name%type;
1741: l_source_business_grp_id_n jtf_rs_resource_extns.source_business_grp_id%type;
1742: l_source_business_grp_name_n jtf_rs_resource_extns.source_business_grp_name%type;
1743: l_source_office_n jtf_rs_resource_extns.source_office%type;
1744: l_source_location_n jtf_rs_resource_extns.source_location%type;

Line 1741: l_source_business_grp_id_n jtf_rs_resource_extns.source_business_grp_id%type;

1737: l_source_country_n jtf_rs_resource_extns.source_country%type;
1738: l_source_postal_code_n jtf_rs_resource_extns.source_postal_code%type;
1739: l_source_mgr_id_n jtf_rs_resource_extns.source_mgr_id%type;
1740: l_source_mgr_name_n jtf_rs_resource_extns.source_mgr_name%type;
1741: l_source_business_grp_id_n jtf_rs_resource_extns.source_business_grp_id%type;
1742: l_source_business_grp_name_n jtf_rs_resource_extns.source_business_grp_name%type;
1743: l_source_office_n jtf_rs_resource_extns.source_office%type;
1744: l_source_location_n jtf_rs_resource_extns.source_location%type;
1745: l_source_mailstop_n jtf_rs_resource_extns.source_mailstop%type;

Line 1742: l_source_business_grp_name_n jtf_rs_resource_extns.source_business_grp_name%type;

1738: l_source_postal_code_n jtf_rs_resource_extns.source_postal_code%type;
1739: l_source_mgr_id_n jtf_rs_resource_extns.source_mgr_id%type;
1740: l_source_mgr_name_n jtf_rs_resource_extns.source_mgr_name%type;
1741: l_source_business_grp_id_n jtf_rs_resource_extns.source_business_grp_id%type;
1742: l_source_business_grp_name_n jtf_rs_resource_extns.source_business_grp_name%type;
1743: l_source_office_n jtf_rs_resource_extns.source_office%type;
1744: l_source_location_n jtf_rs_resource_extns.source_location%type;
1745: l_source_mailstop_n jtf_rs_resource_extns.source_mailstop%type;
1746: l_source_mobile_phone_n jtf_rs_resource_extns.source_mobile_phone%type;

Line 1743: l_source_office_n jtf_rs_resource_extns.source_office%type;

1739: l_source_mgr_id_n jtf_rs_resource_extns.source_mgr_id%type;
1740: l_source_mgr_name_n jtf_rs_resource_extns.source_mgr_name%type;
1741: l_source_business_grp_id_n jtf_rs_resource_extns.source_business_grp_id%type;
1742: l_source_business_grp_name_n jtf_rs_resource_extns.source_business_grp_name%type;
1743: l_source_office_n jtf_rs_resource_extns.source_office%type;
1744: l_source_location_n jtf_rs_resource_extns.source_location%type;
1745: l_source_mailstop_n jtf_rs_resource_extns.source_mailstop%type;
1746: l_source_mobile_phone_n jtf_rs_resource_extns.source_mobile_phone%type;
1747: l_source_pager_n jtf_rs_resource_extns.source_pager%type;

Line 1744: l_source_location_n jtf_rs_resource_extns.source_location%type;

1740: l_source_mgr_name_n jtf_rs_resource_extns.source_mgr_name%type;
1741: l_source_business_grp_id_n jtf_rs_resource_extns.source_business_grp_id%type;
1742: l_source_business_grp_name_n jtf_rs_resource_extns.source_business_grp_name%type;
1743: l_source_office_n jtf_rs_resource_extns.source_office%type;
1744: l_source_location_n jtf_rs_resource_extns.source_location%type;
1745: l_source_mailstop_n jtf_rs_resource_extns.source_mailstop%type;
1746: l_source_mobile_phone_n jtf_rs_resource_extns.source_mobile_phone%type;
1747: l_source_pager_n jtf_rs_resource_extns.source_pager%type;
1748: l_resource_name_n jtf_rs_resource_extns_vl.resource_name%type;

Line 1745: l_source_mailstop_n jtf_rs_resource_extns.source_mailstop%type;

1741: l_source_business_grp_id_n jtf_rs_resource_extns.source_business_grp_id%type;
1742: l_source_business_grp_name_n jtf_rs_resource_extns.source_business_grp_name%type;
1743: l_source_office_n jtf_rs_resource_extns.source_office%type;
1744: l_source_location_n jtf_rs_resource_extns.source_location%type;
1745: l_source_mailstop_n jtf_rs_resource_extns.source_mailstop%type;
1746: l_source_mobile_phone_n jtf_rs_resource_extns.source_mobile_phone%type;
1747: l_source_pager_n jtf_rs_resource_extns.source_pager%type;
1748: l_resource_name_n jtf_rs_resource_extns_vl.resource_name%type;
1749: l_end_date_active_n jtf_rs_resource_extns_vl.end_date_active%type;

Line 1746: l_source_mobile_phone_n jtf_rs_resource_extns.source_mobile_phone%type;

1742: l_source_business_grp_name_n jtf_rs_resource_extns.source_business_grp_name%type;
1743: l_source_office_n jtf_rs_resource_extns.source_office%type;
1744: l_source_location_n jtf_rs_resource_extns.source_location%type;
1745: l_source_mailstop_n jtf_rs_resource_extns.source_mailstop%type;
1746: l_source_mobile_phone_n jtf_rs_resource_extns.source_mobile_phone%type;
1747: l_source_pager_n jtf_rs_resource_extns.source_pager%type;
1748: l_resource_name_n jtf_rs_resource_extns_vl.resource_name%type;
1749: l_end_date_active_n jtf_rs_resource_extns_vl.end_date_active%type;
1750: l_party_id_n jtf_rs_resource_extns_vl.person_party_id%type;

Line 1747: l_source_pager_n jtf_rs_resource_extns.source_pager%type;

1743: l_source_office_n jtf_rs_resource_extns.source_office%type;
1744: l_source_location_n jtf_rs_resource_extns.source_location%type;
1745: l_source_mailstop_n jtf_rs_resource_extns.source_mailstop%type;
1746: l_source_mobile_phone_n jtf_rs_resource_extns.source_mobile_phone%type;
1747: l_source_pager_n jtf_rs_resource_extns.source_pager%type;
1748: l_resource_name_n jtf_rs_resource_extns_vl.resource_name%type;
1749: l_end_date_active_n jtf_rs_resource_extns_vl.end_date_active%type;
1750: l_party_id_n jtf_rs_resource_extns_vl.person_party_id%type;
1751:

Line 1748: l_resource_name_n jtf_rs_resource_extns_vl.resource_name%type;

1744: l_source_location_n jtf_rs_resource_extns.source_location%type;
1745: l_source_mailstop_n jtf_rs_resource_extns.source_mailstop%type;
1746: l_source_mobile_phone_n jtf_rs_resource_extns.source_mobile_phone%type;
1747: l_source_pager_n jtf_rs_resource_extns.source_pager%type;
1748: l_resource_name_n jtf_rs_resource_extns_vl.resource_name%type;
1749: l_end_date_active_n jtf_rs_resource_extns_vl.end_date_active%type;
1750: l_party_id_n jtf_rs_resource_extns_vl.person_party_id%type;
1751:
1752: l_resource_extn_aud_id jtf_rs_resource_extn_aud.resource_audit_id%type;

Line 1749: l_end_date_active_n jtf_rs_resource_extns_vl.end_date_active%type;

1745: l_source_mailstop_n jtf_rs_resource_extns.source_mailstop%type;
1746: l_source_mobile_phone_n jtf_rs_resource_extns.source_mobile_phone%type;
1747: l_source_pager_n jtf_rs_resource_extns.source_pager%type;
1748: l_resource_name_n jtf_rs_resource_extns_vl.resource_name%type;
1749: l_end_date_active_n jtf_rs_resource_extns_vl.end_date_active%type;
1750: l_party_id_n jtf_rs_resource_extns_vl.person_party_id%type;
1751:
1752: l_resource_extn_aud_id jtf_rs_resource_extn_aud.resource_audit_id%type;
1753: l_row_id varchar2(24) := null;

Line 1750: l_party_id_n jtf_rs_resource_extns_vl.person_party_id%type;

1746: l_source_mobile_phone_n jtf_rs_resource_extns.source_mobile_phone%type;
1747: l_source_pager_n jtf_rs_resource_extns.source_pager%type;
1748: l_resource_name_n jtf_rs_resource_extns_vl.resource_name%type;
1749: l_end_date_active_n jtf_rs_resource_extns_vl.end_date_active%type;
1750: l_party_id_n jtf_rs_resource_extns_vl.person_party_id%type;
1751:
1752: l_resource_extn_aud_id jtf_rs_resource_extn_aud.resource_audit_id%type;
1753: l_row_id varchar2(24) := null;
1754: /* Moved the initial assignment of below variables to inside begin */

Line 1768: l_end_date_active jtf_rs_resource_extns_vl.end_date_active%type;

1764: l_pager VARCHAR2(240);
1765: l_mgr_name VARCHAR2(240);
1766: l_job_name VARCHAR2(240);
1767: l_org_name VARCHAR2(240);
1768: l_end_date_active jtf_rs_resource_extns_vl.end_date_active%type;
1769: -- l_sysdate DATE := SYSDATE;
1770: /* Moved the initial assignment of below variables to inside begin */
1771: l_user_id NUMBER;
1772: l_login NUMBER;

Line 3064: --update the jtf_rs_resource_extns.

3060: end if;
3061: end if;
3062:
3063: --ER # 2669284 . If any change has ben encountered, then audit that resource record and also
3064: --update the jtf_rs_resource_extns.
3065: if (l_is_to_be_updated = 'Y') then
3066:
3067: ---fnd_file.put_line(fnd_file.log,'resource id:' || l_c_resource.resource_id);
3068: select jtf_rs_resource_extn_aud_s.nextval

Line 3207: UPDATE jtf_rs_resource_extns

3203: x_last_update_login => l_login );
3204:
3205: if (l_update_extn = 'Y') then
3206:
3207: UPDATE jtf_rs_resource_extns
3208: SET last_update_date = l_sysdate,
3209: last_update_login = l_login,
3210: last_updated_by = l_user_id,
3211: source_number = l_source_number,

Line 3243: update jtf_rs_resource_extns_tl

3239: end if;
3240:
3241: IF (p_overwrite_name = 'ALIAS') THEN
3242: IF l_resource_name_n IS NOT NULL THEN
3243: update jtf_rs_resource_extns_tl
3244: SET last_update_date = l_sysdate,
3245: last_update_login = l_login,
3246: last_updated_by = l_user_id,
3247: resource_name = l_resource_name_n,

Line 3255: update jtf_rs_resource_extns_tl

3251:
3252: END IF;
3253: ELSIF (p_overwrite_name = 'FULL_NAME') THEN
3254: IF (l_resource_name_n IS NOT NULL) THEN
3255: update jtf_rs_resource_extns_tl
3256: SET last_update_date = l_sysdate,
3257: last_update_login = l_login,
3258: last_updated_by = l_user_id,
3259: resource_name = l_resource_name_n,

Line 3377: FROM JTF_RS_RESOURCE_EXTNS RES

3373: IS
3374: cursor term_res_cur
3375: is
3376: SELECT RESOURCE_ID, SOURCE_ID
3377: FROM JTF_RS_RESOURCE_EXTNS RES
3378: WHERE res.category = 'EMPLOYEE'
3379: AND not exists (select ppl.person_id
3380: from per_all_people_f ppl,
3381: per_all_assignments_f asg

Line 3394: FROM JTF_RS_RESOURCE_EXTNS RES

3390: FROM PER_EMPLOYEES_CURRENT_X
3391: WHERE EMPLOYEE_ID = RES.SOURCE_ID)*/
3392: union
3393: SELECT RESOURCE_ID, SOURCE_ID
3394: FROM JTF_RS_RESOURCE_EXTNS RES
3395: WHERE res.category = 'EMPLOYEE'
3396: AND (res.end_date_active IS NOT NULL AND res.end_date_active < sysdate);
3397:
3398: term_res_rec term_res_cur%rowtype;

Line 3424: FROM jtf_rs_resource_extns res

3420: , ppl.office_number office
3421: , ppl.internal_location location
3422: , ppl.mailstop mailstop
3423: , ppl.party_id party_id
3424: FROM jtf_rs_resource_extns res
3425: , per_all_people_f ppl
3426: , hr_all_organization_units org
3427: WHERE res.resource_id = l_resource_id
3428: AND res.source_id = ppl.person_id

Line 3445: UPDATE jtf_rs_resource_extns RES

3441: while(term_res_cur%found)
3442: loop
3443:
3444: begin
3445: UPDATE jtf_rs_resource_extns RES
3446: SET RES.LAST_UPDATE_DATE = sysdate,
3447: RES.LAST_UPDATED_BY = fnd_global.user_id,
3448: (RES.SOURCE_NUMBER ,
3449: RES.SOURCE_NAME ,

Line 3539: UPDATE jtf_rs_resource_extns RES

3535: when l_too_many_rows_query then
3536: open fetch_emp_cur(term_res_rec.resource_id);
3537: fetch fetch_emp_cur into emp_rec;
3538: close fetch_emp_cur;
3539: UPDATE jtf_rs_resource_extns RES
3540: SET RES.LAST_UPDATE_DATE = sysdate,
3541: RES.LAST_UPDATED_BY = fnd_global.user_id,
3542: RES.SOURCE_NUMBER = emp_rec.employee_number ,
3543: RES.SOURCE_NAME = emp_rec.full_name,

Line 3585: update jtf_rs_resource_extns res

3581: PROCEDURE update_emp_phone
3582: IS
3583: BEGIN
3584:
3585: update jtf_rs_resource_extns res
3586: SET RES.LAST_UPDATE_DATE = sysdate,
3587: RES.LAST_UPDATED_BY = fnd_global.user_id,
3588: RES.SOURCE_PHONE
3589: = (select per.phone_number

Line 3650: FROM jtf_rs_resource_extns rsc

3646: SELECT rsc.resource_id
3647: , rsc.object_version_number
3648: , hpr.end_date
3649: , hpr.status
3650: FROM jtf_rs_resource_extns rsc
3651: ,hz_relationships hpr
3652: WHERE rsc.category = 'PARTNER'
3653: AND rsc.source_id = hpr.party_id
3654: AND hpr.directional_flag = 'F'

Line 3751: FROM jtf_rs_resource_extns

3747: SELECT resource_id
3748: , source_id
3749: , address_id
3750: , category
3751: FROM jtf_rs_resource_extns
3752: WHERE category in ('PARTY', 'PARTNER');
3753:
3754:
3755: CURSOR c_party(l_party_id in number)

Line 3865: UPDATE JTF_RS_RESOURCE_EXTNS RES

3861: l_login := nvl(FND_GLOBAL.LOGIN_ID,-1);
3862:
3863: -- first populate the address id where address id is null
3864: BEGIN
3865: UPDATE JTF_RS_RESOURCE_EXTNS RES
3866: SET RES.LAST_UPDATE_DATE = l_sysdate,
3867: RES.LAST_UPDATED_BY = l_user_id,
3868: RES.LAST_UPDATE_LOGIN = l_login,
3869: (RES.ADDRESS_ID)

Line 3894: UPDATE JTF_RS_RESOURCE_EXTNS RES

3890:
3891:
3892: -- first populate the address id with primary address id for PARTNER
3893: BEGIN
3894: UPDATE JTF_RS_RESOURCE_EXTNS RES
3895: SET RES.LAST_UPDATE_DATE = l_sysdate,
3896: RES.LAST_UPDATED_BY = l_user_id,
3897: RES.LAST_UPDATE_LOGIN = l_login,
3898: (RES.ADDRESS_ID)

Line 3941: UPDATE JTF_RS_RESOURCE_EXTNS RES

3937: open c_address(r_res.address_id);
3938: fetch c_address into r_address;
3939: close c_address;
3940:
3941: UPDATE JTF_RS_RESOURCE_EXTNS RES
3942: SET RES.LAST_UPDATE_DATE = l_sysdate,
3943: RES.LAST_UPDATED_BY = l_user_id,
3944: RES.LAST_UPDATE_LOGIN = l_login,
3945: RES.SOURCE_NUMBER = r_party.party_number,

Line 3969: update jtf_rs_resource_extns_tl res

3965:
3966:
3967: IF(p_overwrite_name = 'Y')
3968: THEN
3969: update jtf_rs_resource_extns_tl res
3970: SET RES.LAST_UPDATE_DATE = l_sysdate,
3971: RES.LAST_UPDATED_BY = l_user_id,
3972: RES.LAST_UPDATE_LOGIN = l_login,
3973: resource_name = r_party.party_name,

Line 4029: FROM jtf_rs_resource_extns res

4025: CURSOR c_res
4026: IS
4027: SELECT resource_id,
4028: source_id
4029: FROM jtf_rs_resource_extns res
4030: WHERE res.category = 'SUPPLIER_CONTACT';
4031:
4032:
4033: --Bug14000288

Line 4104: UPDATE JTF_RS_RESOURCE_EXTNS RES

4100: FETCH c_org_name into l_org_name;
4101: CLOSE c_org_name;
4102: END IF;
4103:
4104: UPDATE JTF_RS_RESOURCE_EXTNS RES
4105: SET RES.LAST_UPDATE_DATE = l_sysdate,
4106: RES.LAST_UPDATED_BY = l_user_id,
4107: RES.LAST_UPDATE_LOGIN = l_login,
4108: RES.SOURCE_NUMBER = r_supp.source_number,

Line 4132: update jtf_rs_resource_extns_tl res

4128:
4129:
4130: IF(p_overwrite_name = 'Y')
4131: THEN
4132: update jtf_rs_resource_extns_tl res
4133: SET RES.LAST_UPDATE_DATE = l_sysdate,
4134: RES.LAST_UPDATED_BY = l_user_id,
4135: RES.LAST_UPDATE_LOGIN = l_login,
4136: SOURCE_LANG = userenv('LANG'),

Line 4169: FROM jtf_rs_resource_extns rsc

4165: CURSOR term_supp_cont_cur (l_active_days IN NUMBER) IS
4166: SELECT rsc.resource_id
4167: , rsc.object_version_number
4168: , pvc.inactive_date
4169: FROM jtf_rs_resource_extns rsc
4170: ,po_vendor_contacts pvc
4171: WHERE rsc.category = 'SUPPLIER_CONTACT'
4172: AND rsc.source_id = pvc.vendor_contact_id
4173: AND trunc(nvl(inactive_date, sysdate)) < trunc(sysdate)

Line 4238: UPDATE jtf_rs_resource_extns res

4234:
4235: PROCEDURE update_username
4236: IS
4237: BEGIN
4238: UPDATE jtf_rs_resource_extns res
4239: SET user_name = (SELECT user_name
4240: FROM fnd_user fu
4241: WHERE res.user_id = fu.user_id)
4242: WHERE user_id IS NOT NULL;

Line 4273: FROM JTF_RS_RESOURCE_EXTNS_VL jres

4269: OBJECT_VERSION_NUMBER,
4270: USER_ID,
4271: SOURCE_NAME,
4272: USER_NAME
4273: FROM JTF_RS_RESOURCE_EXTNS_VL jres
4274: WHERE CATEGORY in ('EMPLOYEE','PARTY','PARTNER','SUPPLIER_CONTACT')
4275: AND jres.USER_ID is not null
4276: AND NOT EXISTS
4277: ( SELECT 'x'

Line 4294: FROM JTF_RS_RESOURCE_EXTNS_VL jres

4290: OBJECT_VERSION_NUMBER,
4291: USER_ID,
4292: SOURCE_NAME,
4293: USER_NAME
4294: FROM JTF_RS_RESOURCE_EXTNS_VL jres
4295: WHERE CATEGORY in ('EMPLOYEE','PARTY','PARTNER','SUPPLIER_CONTACT')
4296: AND USER_ID is not null
4297: AND trunc(nvl(END_DATE_ACTIVE,SYSDATE)) >= trunc(SYSDATE)
4298: AND NOT EXISTS

Line 4318: FROM JTF_RS_RESOURCE_EXTNS_VL jres

4314: OBJECT_VERSION_NUMBER,
4315: USER_ID,
4316: SOURCE_NAME,
4317: USER_NAME
4318: FROM JTF_RS_RESOURCE_EXTNS_VL jres
4319: WHERE CATEGORY in ('EMPLOYEE','PARTY','PARTNER','SUPPLIER_CONTACT')
4320: AND trunc(nvl(END_DATE_ACTIVE,SYSDATE)) >= trunc(SYSDATE)
4321: AND jres.USER_ID is null
4322: AND exists (select 'x'

Line 4338: FROM JTF_RS_RESOURCE_EXTNS_VL jres

4334: OBJECT_VERSION_NUMBER,
4335: USER_ID,
4336: SOURCE_NAME,
4337: USER_NAME
4338: FROM JTF_RS_RESOURCE_EXTNS_VL jres
4339: WHERE CATEGORY = 'EMPLOYEE'
4340: AND trunc(nvl(END_DATE_ACTIVE,SYSDATE)) >= trunc(SYSDATE)
4341: AND jres.USER_ID is null
4342: AND exists (select 'x'

Line 4355: FROM JTF_RS_RESOURCE_EXTNS_VL jres

4351: OBJECT_VERSION_NUMBER,
4352: USER_ID,
4353: SOURCE_NAME,
4354: USER_NAME
4355: FROM JTF_RS_RESOURCE_EXTNS_VL jres
4356: WHERE CATEGORY = 'SUPPLIER_CONTACT'
4357: AND trunc(nvl(END_DATE_ACTIVE,SYSDATE)) >= trunc(SYSDATE)
4358: AND jres.USER_ID is null
4359: AND exists (select 'x'

Line 4372: FROM JTF_RS_RESOURCE_EXTNS_VL jres

4368: OBJECT_VERSION_NUMBER,
4369: USER_ID,
4370: SOURCE_NAME,
4371: USER_NAME
4372: FROM JTF_RS_RESOURCE_EXTNS_VL jres
4373: WHERE CATEGORY in ('PARTY','PARTNER')
4374: AND trunc(nvl(END_DATE_ACTIVE,SYSDATE)) >= trunc(SYSDATE)
4375: AND jres.USER_ID is null
4376: AND exists (select 'x'

Line 4380: CURSOR c_party_partner(p_source_id IN jtf_rs_resource_extns.source_id%TYPE) IS

4376: AND exists (select 'x'
4377: from fnd_user f
4378: where jres.source_id = customer_id);
4379:
4380: CURSOR c_party_partner(p_source_id IN jtf_rs_resource_extns.source_id%TYPE) IS
4381: SELECT user_id,
4382: user_name
4383: FROM fnd_user
4384: WHERE customer_id = p_source_id

Line 4387: CURSOR c_supp_contact(p_source_id IN jtf_rs_resource_extns.source_id%TYPE) is

4383: FROM fnd_user
4384: WHERE customer_id = p_source_id
4385: AND trunc(sysdate) BETWEEN trunc(start_date) AND trunc(nvl(end_date,sysdate));
4386:
4387: CURSOR c_supp_contact(p_source_id IN jtf_rs_resource_extns.source_id%TYPE) is
4388: SELECT user_id,
4389: user_name
4390: FROM fnd_user
4391: WHERE supplier_id = p_source_id

Line 4394: CURSOR c_emp(p_source_id IN jtf_rs_resource_extns.source_id%TYPE) is

4390: FROM fnd_user
4391: WHERE supplier_id = p_source_id
4392: AND trunc(sysdate) BETWEEN trunc(start_date) AND trunc(nvl(end_date,sysdate));
4393:
4394: CURSOR c_emp(p_source_id IN jtf_rs_resource_extns.source_id%TYPE) is
4395: SELECT user_id,
4396: user_name
4397: FROM fnd_user
4398: WHERE employee_id = p_source_id