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 247: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;

243: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_EMPLOYEE';
244: l_return_status VARCHAR2(2);
245: l_msg_count NUMBER;
246: l_msg_data VARCHAR2(2000);
247: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;
248: l_resource_number jtf_rs_resource_extns.resource_number%TYPE;
249: l_source_number jtf_rs_resource_extns.source_number%TYPE;
250: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
251: -- l_msg_index_out number;

Line 248: l_resource_number jtf_rs_resource_extns.resource_number%TYPE;

244: l_return_status VARCHAR2(2);
245: l_msg_count NUMBER;
246: l_msg_data VARCHAR2(2000);
247: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;
248: l_resource_number jtf_rs_resource_extns.resource_number%TYPE;
249: l_source_number jtf_rs_resource_extns.source_number%TYPE;
250: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
251: -- l_msg_index_out number;
252: -- l_msg_data1 varchar2(5000);

Line 249: l_source_number jtf_rs_resource_extns.source_number%TYPE;

245: l_msg_count NUMBER;
246: l_msg_data VARCHAR2(2000);
247: l_resource_id jtf_rs_resource_extns.resource_id%TYPE;
248: l_resource_number jtf_rs_resource_extns.resource_number%TYPE;
249: l_source_number jtf_rs_resource_extns.source_number%TYPE;
250: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
251: -- l_msg_index_out number;
252: -- l_msg_data1 varchar2(5000);
253:

Line 356: from jtf_rs_resource_extns rsc

352: --, per_employees_current_x emp
353: , per_all_people_f emp
354: -- WHERE NOT EXISTS (select source_id
355: WHERE NOT EXISTS (select 1
356: from jtf_rs_resource_extns rsc
357: where category = 'EMPLOYEE'
358: and ppl.person_id = rsc.source_id)
359: and ppl.business_group_id = org.organization_id
360: and ppl.person_id = asg.person_id

Line 421: from jtf_rs_resource_extns rsc

417: --, per_employees_current_x emp
418: , per_all_people_f emp
419: -- WHERE NOT EXISTS (select source_id
420: WHERE NOT EXISTS (select 1
421: from jtf_rs_resource_extns rsc
422: where category = 'EMPLOYEE'
423: and ppl.person_id = rsc.source_id)
424: and ppl.business_group_id = org.organization_id
425: and ppl.person_id = asg.person_id

Line 1244: FROM jtf_rs_resource_extns_vl rsc

1240: , rsc.source_id
1241: , rsc.object_version_number
1242: -- , rsc.start_date_active
1243: -- , rsc.end_date_active
1244: FROM jtf_rs_resource_extns_vl rsc
1245: WHERE rsc.category = 'EMPLOYEE'
1246: /* AND not exists (select employee_id
1247: from per_employees_current_x emp
1248: where emp.employee_id = rsc.source_id

Line 1471: FROM jtf_rs_resource_extns

1467: source_number,
1468: source_job_id,
1469: start_date_active,
1470: end_date_active
1471: FROM jtf_rs_resource_extns
1472: WHERE category = 'EMPLOYEE';
1473:
1474: CURSOR c_check_rehire_rev_emp(p_person_id IN NUMBER) IS
1475: SELECT 'Y'

Line 1476: FROM jtf_rs_resource_extns rsc

1472: WHERE category = 'EMPLOYEE';
1473:
1474: CURSOR c_check_rehire_rev_emp(p_person_id IN NUMBER) IS
1475: SELECT 'Y'
1476: FROM jtf_rs_resource_extns rsc
1477: WHERE rsc.category = 'EMPLOYEE'
1478: AND rsc.source_id = p_person_id
1479: AND l_sysdate not between trunc(rsc.start_date_active) and trunc(nvl(rsc.end_date_active,sysdate))
1480: -- AND exists ( select cur.employee_id from PER_EMPLOYEES_CURRENT_X cur where cur.employee_id = rsc.source_id);

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

1483: where ppl.person_id = p_person_id
1484: and trunc(sysdate) between ppl.effective_start_date and ppl.effective_end_date
1485: and (ppl.current_employee_flag = 'Y' OR ppl.current_npw_flag = 'Y'));
1486:
1487: CURSOR c_salesreps (c_resource_id jtf_rs_resource_extns.resource_id%TYPE) IS
1488: SELECT salesrep_id
1489: FROM jtf_rs_salesreps
1490: WHERE resource_id = c_resource_id;
1491:

Line 1514: l_source_number jtf_rs_resource_extns.source_number%TYPE;

1510: WHERE person_id = p_person_id
1511: and g_run_date between effective_start_date and effective_end_date;
1512:
1513: l_ppf_rec c_ppf%ROWTYPE;
1514: l_source_number jtf_rs_resource_extns.source_number%TYPE;
1515: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
1516:
1517: CURSOR c_org(p_org_id IN NUMBER) IS
1518: SELECT name

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

1581: AND phone_type = 'P'
1582: AND g_run_date between date_from and nvl(date_to, to_date('31/12/4712', 'DD/MM/YYYY'));
1583:
1584: --Mugsrin
1585: --ER # 2669284. This cursor selects old values from jtf_rs_resource_extns table.
1586: --Then old values are compared with new values to find out
1587: --whether a row has to be updated and also to insert null for unmodified columns.
1588: CURSOR rr_old_cur(l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE)
1589: IS

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

1584: --Mugsrin
1585: --ER # 2669284. This cursor selects old values from jtf_rs_resource_extns table.
1586: --Then old values are compared with new values to find out
1587: --whether a row has to be updated and also to insert null for unmodified columns.
1588: CURSOR rr_old_cur(l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE)
1589: IS
1590: SELECT
1591: source_number,
1592: source_name,

Line 1619: FROM jtf_rs_resource_extns_vl

1615: source_pager,
1616: resource_name,
1617: end_date_active,
1618: person_party_id
1619: FROM jtf_rs_resource_extns_vl
1620: WHERE resource_id = l_resource_id;
1621:
1622: rr_old_rec rr_old_cur%rowtype;
1623:

Line 1625: l_source_number_o jtf_rs_resource_extns.source_number%type;

1621:
1622: rr_old_rec rr_old_cur%rowtype;
1623:
1624: --ER # 2669284. Resource old values
1625: l_source_number_o jtf_rs_resource_extns.source_number%type;
1626: l_source_name_o jtf_rs_resource_extns.source_name%type;
1627: l_source_first_name_o jtf_rs_resource_extns.source_first_name%type;
1628: l_source_middle_name_o jtf_rs_resource_extns.source_middle_name%type;
1629: l_source_last_name_o jtf_rs_resource_extns.source_last_name%type;

Line 1626: l_source_name_o jtf_rs_resource_extns.source_name%type;

1622: rr_old_rec rr_old_cur%rowtype;
1623:
1624: --ER # 2669284. Resource old values
1625: l_source_number_o jtf_rs_resource_extns.source_number%type;
1626: l_source_name_o jtf_rs_resource_extns.source_name%type;
1627: l_source_first_name_o jtf_rs_resource_extns.source_first_name%type;
1628: l_source_middle_name_o jtf_rs_resource_extns.source_middle_name%type;
1629: l_source_last_name_o jtf_rs_resource_extns.source_last_name%type;
1630: l_source_phone_o jtf_rs_resource_extns.source_phone%type;

Line 1627: l_source_first_name_o jtf_rs_resource_extns.source_first_name%type;

1623:
1624: --ER # 2669284. Resource old values
1625: l_source_number_o jtf_rs_resource_extns.source_number%type;
1626: l_source_name_o jtf_rs_resource_extns.source_name%type;
1627: l_source_first_name_o jtf_rs_resource_extns.source_first_name%type;
1628: l_source_middle_name_o jtf_rs_resource_extns.source_middle_name%type;
1629: l_source_last_name_o jtf_rs_resource_extns.source_last_name%type;
1630: l_source_phone_o jtf_rs_resource_extns.source_phone%type;
1631: l_source_email_o jtf_rs_resource_extns.source_email%type;

Line 1628: l_source_middle_name_o jtf_rs_resource_extns.source_middle_name%type;

1624: --ER # 2669284. Resource old values
1625: l_source_number_o jtf_rs_resource_extns.source_number%type;
1626: l_source_name_o jtf_rs_resource_extns.source_name%type;
1627: l_source_first_name_o jtf_rs_resource_extns.source_first_name%type;
1628: l_source_middle_name_o jtf_rs_resource_extns.source_middle_name%type;
1629: l_source_last_name_o jtf_rs_resource_extns.source_last_name%type;
1630: l_source_phone_o jtf_rs_resource_extns.source_phone%type;
1631: l_source_email_o jtf_rs_resource_extns.source_email%type;
1632: l_source_job_id_o jtf_rs_resource_extns.source_job_id%type;

Line 1629: l_source_last_name_o jtf_rs_resource_extns.source_last_name%type;

1625: l_source_number_o jtf_rs_resource_extns.source_number%type;
1626: l_source_name_o jtf_rs_resource_extns.source_name%type;
1627: l_source_first_name_o jtf_rs_resource_extns.source_first_name%type;
1628: l_source_middle_name_o jtf_rs_resource_extns.source_middle_name%type;
1629: l_source_last_name_o jtf_rs_resource_extns.source_last_name%type;
1630: l_source_phone_o jtf_rs_resource_extns.source_phone%type;
1631: l_source_email_o jtf_rs_resource_extns.source_email%type;
1632: l_source_job_id_o jtf_rs_resource_extns.source_job_id%type;
1633: l_source_job_title_o jtf_rs_resource_extns.source_job_title%type;

Line 1630: l_source_phone_o jtf_rs_resource_extns.source_phone%type;

1626: l_source_name_o jtf_rs_resource_extns.source_name%type;
1627: l_source_first_name_o jtf_rs_resource_extns.source_first_name%type;
1628: l_source_middle_name_o jtf_rs_resource_extns.source_middle_name%type;
1629: l_source_last_name_o jtf_rs_resource_extns.source_last_name%type;
1630: l_source_phone_o jtf_rs_resource_extns.source_phone%type;
1631: l_source_email_o jtf_rs_resource_extns.source_email%type;
1632: l_source_job_id_o jtf_rs_resource_extns.source_job_id%type;
1633: l_source_job_title_o jtf_rs_resource_extns.source_job_title%type;
1634: l_address_id_o jtf_rs_resource_extns.address_id%type ;

Line 1631: l_source_email_o jtf_rs_resource_extns.source_email%type;

1627: l_source_first_name_o jtf_rs_resource_extns.source_first_name%type;
1628: l_source_middle_name_o jtf_rs_resource_extns.source_middle_name%type;
1629: l_source_last_name_o jtf_rs_resource_extns.source_last_name%type;
1630: l_source_phone_o jtf_rs_resource_extns.source_phone%type;
1631: l_source_email_o jtf_rs_resource_extns.source_email%type;
1632: l_source_job_id_o jtf_rs_resource_extns.source_job_id%type;
1633: l_source_job_title_o jtf_rs_resource_extns.source_job_title%type;
1634: l_address_id_o jtf_rs_resource_extns.address_id%type ;
1635: l_source_address1_o jtf_rs_resource_extns.source_address1%type;

Line 1632: l_source_job_id_o jtf_rs_resource_extns.source_job_id%type;

1628: l_source_middle_name_o jtf_rs_resource_extns.source_middle_name%type;
1629: l_source_last_name_o jtf_rs_resource_extns.source_last_name%type;
1630: l_source_phone_o jtf_rs_resource_extns.source_phone%type;
1631: l_source_email_o jtf_rs_resource_extns.source_email%type;
1632: l_source_job_id_o jtf_rs_resource_extns.source_job_id%type;
1633: l_source_job_title_o jtf_rs_resource_extns.source_job_title%type;
1634: l_address_id_o jtf_rs_resource_extns.address_id%type ;
1635: l_source_address1_o jtf_rs_resource_extns.source_address1%type;
1636: l_source_address2_o jtf_rs_resource_extns.source_address2%type;

Line 1633: l_source_job_title_o jtf_rs_resource_extns.source_job_title%type;

1629: l_source_last_name_o jtf_rs_resource_extns.source_last_name%type;
1630: l_source_phone_o jtf_rs_resource_extns.source_phone%type;
1631: l_source_email_o jtf_rs_resource_extns.source_email%type;
1632: l_source_job_id_o jtf_rs_resource_extns.source_job_id%type;
1633: l_source_job_title_o jtf_rs_resource_extns.source_job_title%type;
1634: l_address_id_o jtf_rs_resource_extns.address_id%type ;
1635: l_source_address1_o jtf_rs_resource_extns.source_address1%type;
1636: l_source_address2_o jtf_rs_resource_extns.source_address2%type;
1637: l_source_address3_o jtf_rs_resource_extns.source_address3%type;

Line 1634: l_address_id_o jtf_rs_resource_extns.address_id%type ;

1630: l_source_phone_o jtf_rs_resource_extns.source_phone%type;
1631: l_source_email_o jtf_rs_resource_extns.source_email%type;
1632: l_source_job_id_o jtf_rs_resource_extns.source_job_id%type;
1633: l_source_job_title_o jtf_rs_resource_extns.source_job_title%type;
1634: l_address_id_o jtf_rs_resource_extns.address_id%type ;
1635: l_source_address1_o jtf_rs_resource_extns.source_address1%type;
1636: l_source_address2_o jtf_rs_resource_extns.source_address2%type;
1637: l_source_address3_o jtf_rs_resource_extns.source_address3%type;
1638: l_source_city_o jtf_rs_resource_extns.source_city%type;

Line 1635: l_source_address1_o jtf_rs_resource_extns.source_address1%type;

1631: l_source_email_o jtf_rs_resource_extns.source_email%type;
1632: l_source_job_id_o jtf_rs_resource_extns.source_job_id%type;
1633: l_source_job_title_o jtf_rs_resource_extns.source_job_title%type;
1634: l_address_id_o jtf_rs_resource_extns.address_id%type ;
1635: l_source_address1_o jtf_rs_resource_extns.source_address1%type;
1636: l_source_address2_o jtf_rs_resource_extns.source_address2%type;
1637: l_source_address3_o jtf_rs_resource_extns.source_address3%type;
1638: l_source_city_o jtf_rs_resource_extns.source_city%type;
1639: l_source_country_o jtf_rs_resource_extns.source_country%type;

Line 1636: l_source_address2_o jtf_rs_resource_extns.source_address2%type;

1632: l_source_job_id_o jtf_rs_resource_extns.source_job_id%type;
1633: l_source_job_title_o jtf_rs_resource_extns.source_job_title%type;
1634: l_address_id_o jtf_rs_resource_extns.address_id%type ;
1635: l_source_address1_o jtf_rs_resource_extns.source_address1%type;
1636: l_source_address2_o jtf_rs_resource_extns.source_address2%type;
1637: l_source_address3_o jtf_rs_resource_extns.source_address3%type;
1638: l_source_city_o jtf_rs_resource_extns.source_city%type;
1639: l_source_country_o jtf_rs_resource_extns.source_country%type;
1640: l_source_postal_code_o jtf_rs_resource_extns.source_postal_code%type;

Line 1637: l_source_address3_o jtf_rs_resource_extns.source_address3%type;

1633: l_source_job_title_o jtf_rs_resource_extns.source_job_title%type;
1634: l_address_id_o jtf_rs_resource_extns.address_id%type ;
1635: l_source_address1_o jtf_rs_resource_extns.source_address1%type;
1636: l_source_address2_o jtf_rs_resource_extns.source_address2%type;
1637: l_source_address3_o jtf_rs_resource_extns.source_address3%type;
1638: l_source_city_o jtf_rs_resource_extns.source_city%type;
1639: l_source_country_o jtf_rs_resource_extns.source_country%type;
1640: l_source_postal_code_o jtf_rs_resource_extns.source_postal_code%type;
1641: l_source_mgr_id_o jtf_rs_resource_extns.source_mgr_id%type;

Line 1638: l_source_city_o jtf_rs_resource_extns.source_city%type;

1634: l_address_id_o jtf_rs_resource_extns.address_id%type ;
1635: l_source_address1_o jtf_rs_resource_extns.source_address1%type;
1636: l_source_address2_o jtf_rs_resource_extns.source_address2%type;
1637: l_source_address3_o jtf_rs_resource_extns.source_address3%type;
1638: l_source_city_o jtf_rs_resource_extns.source_city%type;
1639: l_source_country_o jtf_rs_resource_extns.source_country%type;
1640: l_source_postal_code_o jtf_rs_resource_extns.source_postal_code%type;
1641: l_source_mgr_id_o jtf_rs_resource_extns.source_mgr_id%type;
1642: l_source_mgr_name_o jtf_rs_resource_extns.source_mgr_name%type;

Line 1639: l_source_country_o jtf_rs_resource_extns.source_country%type;

1635: l_source_address1_o jtf_rs_resource_extns.source_address1%type;
1636: l_source_address2_o jtf_rs_resource_extns.source_address2%type;
1637: l_source_address3_o jtf_rs_resource_extns.source_address3%type;
1638: l_source_city_o jtf_rs_resource_extns.source_city%type;
1639: l_source_country_o jtf_rs_resource_extns.source_country%type;
1640: l_source_postal_code_o jtf_rs_resource_extns.source_postal_code%type;
1641: l_source_mgr_id_o jtf_rs_resource_extns.source_mgr_id%type;
1642: l_source_mgr_name_o jtf_rs_resource_extns.source_mgr_name%type;
1643: l_source_business_grp_id_o jtf_rs_resource_extns.source_business_grp_id%type;

Line 1640: l_source_postal_code_o jtf_rs_resource_extns.source_postal_code%type;

1636: l_source_address2_o jtf_rs_resource_extns.source_address2%type;
1637: l_source_address3_o jtf_rs_resource_extns.source_address3%type;
1638: l_source_city_o jtf_rs_resource_extns.source_city%type;
1639: l_source_country_o jtf_rs_resource_extns.source_country%type;
1640: l_source_postal_code_o jtf_rs_resource_extns.source_postal_code%type;
1641: l_source_mgr_id_o jtf_rs_resource_extns.source_mgr_id%type;
1642: l_source_mgr_name_o jtf_rs_resource_extns.source_mgr_name%type;
1643: l_source_business_grp_id_o jtf_rs_resource_extns.source_business_grp_id%type;
1644: l_source_business_grp_name_o jtf_rs_resource_extns.source_business_grp_name%type;

Line 1641: l_source_mgr_id_o jtf_rs_resource_extns.source_mgr_id%type;

1637: l_source_address3_o jtf_rs_resource_extns.source_address3%type;
1638: l_source_city_o jtf_rs_resource_extns.source_city%type;
1639: l_source_country_o jtf_rs_resource_extns.source_country%type;
1640: l_source_postal_code_o jtf_rs_resource_extns.source_postal_code%type;
1641: l_source_mgr_id_o jtf_rs_resource_extns.source_mgr_id%type;
1642: l_source_mgr_name_o jtf_rs_resource_extns.source_mgr_name%type;
1643: l_source_business_grp_id_o jtf_rs_resource_extns.source_business_grp_id%type;
1644: l_source_business_grp_name_o jtf_rs_resource_extns.source_business_grp_name%type;
1645: l_source_office_o jtf_rs_resource_extns.source_office%type;

Line 1642: l_source_mgr_name_o jtf_rs_resource_extns.source_mgr_name%type;

1638: l_source_city_o jtf_rs_resource_extns.source_city%type;
1639: l_source_country_o jtf_rs_resource_extns.source_country%type;
1640: l_source_postal_code_o jtf_rs_resource_extns.source_postal_code%type;
1641: l_source_mgr_id_o jtf_rs_resource_extns.source_mgr_id%type;
1642: l_source_mgr_name_o jtf_rs_resource_extns.source_mgr_name%type;
1643: l_source_business_grp_id_o jtf_rs_resource_extns.source_business_grp_id%type;
1644: l_source_business_grp_name_o jtf_rs_resource_extns.source_business_grp_name%type;
1645: l_source_office_o jtf_rs_resource_extns.source_office%type;
1646: l_source_location_o jtf_rs_resource_extns.source_location%type;

Line 1643: l_source_business_grp_id_o jtf_rs_resource_extns.source_business_grp_id%type;

1639: l_source_country_o jtf_rs_resource_extns.source_country%type;
1640: l_source_postal_code_o jtf_rs_resource_extns.source_postal_code%type;
1641: l_source_mgr_id_o jtf_rs_resource_extns.source_mgr_id%type;
1642: l_source_mgr_name_o jtf_rs_resource_extns.source_mgr_name%type;
1643: l_source_business_grp_id_o jtf_rs_resource_extns.source_business_grp_id%type;
1644: l_source_business_grp_name_o jtf_rs_resource_extns.source_business_grp_name%type;
1645: l_source_office_o jtf_rs_resource_extns.source_office%type;
1646: l_source_location_o jtf_rs_resource_extns.source_location%type;
1647: l_source_mailstop_o jtf_rs_resource_extns.source_mailstop%type;

Line 1644: l_source_business_grp_name_o jtf_rs_resource_extns.source_business_grp_name%type;

1640: l_source_postal_code_o jtf_rs_resource_extns.source_postal_code%type;
1641: l_source_mgr_id_o jtf_rs_resource_extns.source_mgr_id%type;
1642: l_source_mgr_name_o jtf_rs_resource_extns.source_mgr_name%type;
1643: l_source_business_grp_id_o jtf_rs_resource_extns.source_business_grp_id%type;
1644: l_source_business_grp_name_o jtf_rs_resource_extns.source_business_grp_name%type;
1645: l_source_office_o jtf_rs_resource_extns.source_office%type;
1646: l_source_location_o jtf_rs_resource_extns.source_location%type;
1647: l_source_mailstop_o jtf_rs_resource_extns.source_mailstop%type;
1648: l_source_mobile_phone_o jtf_rs_resource_extns.source_mobile_phone%type;

Line 1645: l_source_office_o jtf_rs_resource_extns.source_office%type;

1641: l_source_mgr_id_o jtf_rs_resource_extns.source_mgr_id%type;
1642: l_source_mgr_name_o jtf_rs_resource_extns.source_mgr_name%type;
1643: l_source_business_grp_id_o jtf_rs_resource_extns.source_business_grp_id%type;
1644: l_source_business_grp_name_o jtf_rs_resource_extns.source_business_grp_name%type;
1645: l_source_office_o jtf_rs_resource_extns.source_office%type;
1646: l_source_location_o jtf_rs_resource_extns.source_location%type;
1647: l_source_mailstop_o jtf_rs_resource_extns.source_mailstop%type;
1648: l_source_mobile_phone_o jtf_rs_resource_extns.source_mobile_phone%type;
1649: l_source_pager_o jtf_rs_resource_extns.source_pager%type;

Line 1646: l_source_location_o jtf_rs_resource_extns.source_location%type;

1642: l_source_mgr_name_o jtf_rs_resource_extns.source_mgr_name%type;
1643: l_source_business_grp_id_o jtf_rs_resource_extns.source_business_grp_id%type;
1644: l_source_business_grp_name_o jtf_rs_resource_extns.source_business_grp_name%type;
1645: l_source_office_o jtf_rs_resource_extns.source_office%type;
1646: l_source_location_o jtf_rs_resource_extns.source_location%type;
1647: l_source_mailstop_o jtf_rs_resource_extns.source_mailstop%type;
1648: l_source_mobile_phone_o jtf_rs_resource_extns.source_mobile_phone%type;
1649: l_source_pager_o jtf_rs_resource_extns.source_pager%type;
1650: l_resource_name_o jtf_rs_resource_extns_vl.resource_name%type;

Line 1647: l_source_mailstop_o jtf_rs_resource_extns.source_mailstop%type;

1643: l_source_business_grp_id_o jtf_rs_resource_extns.source_business_grp_id%type;
1644: l_source_business_grp_name_o jtf_rs_resource_extns.source_business_grp_name%type;
1645: l_source_office_o jtf_rs_resource_extns.source_office%type;
1646: l_source_location_o jtf_rs_resource_extns.source_location%type;
1647: l_source_mailstop_o jtf_rs_resource_extns.source_mailstop%type;
1648: l_source_mobile_phone_o jtf_rs_resource_extns.source_mobile_phone%type;
1649: l_source_pager_o jtf_rs_resource_extns.source_pager%type;
1650: l_resource_name_o jtf_rs_resource_extns_vl.resource_name%type;
1651: l_end_date_active_o jtf_rs_resource_extns_vl.end_date_active%type;

Line 1648: l_source_mobile_phone_o jtf_rs_resource_extns.source_mobile_phone%type;

1644: l_source_business_grp_name_o jtf_rs_resource_extns.source_business_grp_name%type;
1645: l_source_office_o jtf_rs_resource_extns.source_office%type;
1646: l_source_location_o jtf_rs_resource_extns.source_location%type;
1647: l_source_mailstop_o jtf_rs_resource_extns.source_mailstop%type;
1648: l_source_mobile_phone_o jtf_rs_resource_extns.source_mobile_phone%type;
1649: l_source_pager_o jtf_rs_resource_extns.source_pager%type;
1650: l_resource_name_o jtf_rs_resource_extns_vl.resource_name%type;
1651: l_end_date_active_o jtf_rs_resource_extns_vl.end_date_active%type;
1652: l_party_id_o jtf_rs_resource_extns_vl.person_party_id%type;

Line 1649: l_source_pager_o jtf_rs_resource_extns.source_pager%type;

1645: l_source_office_o jtf_rs_resource_extns.source_office%type;
1646: l_source_location_o jtf_rs_resource_extns.source_location%type;
1647: l_source_mailstop_o jtf_rs_resource_extns.source_mailstop%type;
1648: l_source_mobile_phone_o jtf_rs_resource_extns.source_mobile_phone%type;
1649: l_source_pager_o jtf_rs_resource_extns.source_pager%type;
1650: l_resource_name_o jtf_rs_resource_extns_vl.resource_name%type;
1651: l_end_date_active_o jtf_rs_resource_extns_vl.end_date_active%type;
1652: l_party_id_o jtf_rs_resource_extns_vl.person_party_id%type;
1653:

Line 1650: l_resource_name_o jtf_rs_resource_extns_vl.resource_name%type;

1646: l_source_location_o jtf_rs_resource_extns.source_location%type;
1647: l_source_mailstop_o jtf_rs_resource_extns.source_mailstop%type;
1648: l_source_mobile_phone_o jtf_rs_resource_extns.source_mobile_phone%type;
1649: l_source_pager_o jtf_rs_resource_extns.source_pager%type;
1650: l_resource_name_o jtf_rs_resource_extns_vl.resource_name%type;
1651: l_end_date_active_o jtf_rs_resource_extns_vl.end_date_active%type;
1652: l_party_id_o jtf_rs_resource_extns_vl.person_party_id%type;
1653:
1654: --ER # 2669284. Resource new values

Line 1651: l_end_date_active_o jtf_rs_resource_extns_vl.end_date_active%type;

1647: l_source_mailstop_o jtf_rs_resource_extns.source_mailstop%type;
1648: l_source_mobile_phone_o jtf_rs_resource_extns.source_mobile_phone%type;
1649: l_source_pager_o jtf_rs_resource_extns.source_pager%type;
1650: l_resource_name_o jtf_rs_resource_extns_vl.resource_name%type;
1651: l_end_date_active_o jtf_rs_resource_extns_vl.end_date_active%type;
1652: l_party_id_o jtf_rs_resource_extns_vl.person_party_id%type;
1653:
1654: --ER # 2669284. Resource new values
1655: l_source_number_n jtf_rs_resource_extns.source_number%type;

Line 1652: l_party_id_o jtf_rs_resource_extns_vl.person_party_id%type;

1648: l_source_mobile_phone_o jtf_rs_resource_extns.source_mobile_phone%type;
1649: l_source_pager_o jtf_rs_resource_extns.source_pager%type;
1650: l_resource_name_o jtf_rs_resource_extns_vl.resource_name%type;
1651: l_end_date_active_o jtf_rs_resource_extns_vl.end_date_active%type;
1652: l_party_id_o jtf_rs_resource_extns_vl.person_party_id%type;
1653:
1654: --ER # 2669284. Resource new values
1655: l_source_number_n jtf_rs_resource_extns.source_number%type;
1656: l_source_name_n jtf_rs_resource_extns.source_name%type;

Line 1655: l_source_number_n jtf_rs_resource_extns.source_number%type;

1651: l_end_date_active_o jtf_rs_resource_extns_vl.end_date_active%type;
1652: l_party_id_o jtf_rs_resource_extns_vl.person_party_id%type;
1653:
1654: --ER # 2669284. Resource new values
1655: l_source_number_n jtf_rs_resource_extns.source_number%type;
1656: l_source_name_n jtf_rs_resource_extns.source_name%type;
1657: l_source_first_name_n jtf_rs_resource_extns.source_first_name%type;
1658: l_source_middle_name_n jtf_rs_resource_extns.source_middle_name%type;
1659: l_source_last_name_n jtf_rs_resource_extns.source_last_name%type;

Line 1656: l_source_name_n jtf_rs_resource_extns.source_name%type;

1652: l_party_id_o jtf_rs_resource_extns_vl.person_party_id%type;
1653:
1654: --ER # 2669284. Resource new values
1655: l_source_number_n jtf_rs_resource_extns.source_number%type;
1656: l_source_name_n jtf_rs_resource_extns.source_name%type;
1657: l_source_first_name_n jtf_rs_resource_extns.source_first_name%type;
1658: l_source_middle_name_n jtf_rs_resource_extns.source_middle_name%type;
1659: l_source_last_name_n jtf_rs_resource_extns.source_last_name%type;
1660: l_source_phone_n jtf_rs_resource_extns.source_phone%type;

Line 1657: l_source_first_name_n jtf_rs_resource_extns.source_first_name%type;

1653:
1654: --ER # 2669284. Resource new values
1655: l_source_number_n jtf_rs_resource_extns.source_number%type;
1656: l_source_name_n jtf_rs_resource_extns.source_name%type;
1657: l_source_first_name_n jtf_rs_resource_extns.source_first_name%type;
1658: l_source_middle_name_n jtf_rs_resource_extns.source_middle_name%type;
1659: l_source_last_name_n jtf_rs_resource_extns.source_last_name%type;
1660: l_source_phone_n jtf_rs_resource_extns.source_phone%type;
1661: l_source_email_n jtf_rs_resource_extns.source_email%type;

Line 1658: l_source_middle_name_n jtf_rs_resource_extns.source_middle_name%type;

1654: --ER # 2669284. Resource new values
1655: l_source_number_n jtf_rs_resource_extns.source_number%type;
1656: l_source_name_n jtf_rs_resource_extns.source_name%type;
1657: l_source_first_name_n jtf_rs_resource_extns.source_first_name%type;
1658: l_source_middle_name_n jtf_rs_resource_extns.source_middle_name%type;
1659: l_source_last_name_n jtf_rs_resource_extns.source_last_name%type;
1660: l_source_phone_n jtf_rs_resource_extns.source_phone%type;
1661: l_source_email_n jtf_rs_resource_extns.source_email%type;
1662: l_source_job_id_n jtf_rs_resource_extns.source_job_id%type;

Line 1659: l_source_last_name_n jtf_rs_resource_extns.source_last_name%type;

1655: l_source_number_n jtf_rs_resource_extns.source_number%type;
1656: l_source_name_n jtf_rs_resource_extns.source_name%type;
1657: l_source_first_name_n jtf_rs_resource_extns.source_first_name%type;
1658: l_source_middle_name_n jtf_rs_resource_extns.source_middle_name%type;
1659: l_source_last_name_n jtf_rs_resource_extns.source_last_name%type;
1660: l_source_phone_n jtf_rs_resource_extns.source_phone%type;
1661: l_source_email_n jtf_rs_resource_extns.source_email%type;
1662: l_source_job_id_n jtf_rs_resource_extns.source_job_id%type;
1663: l_source_job_title_n jtf_rs_resource_extns.source_job_title%type;

Line 1660: l_source_phone_n jtf_rs_resource_extns.source_phone%type;

1656: l_source_name_n jtf_rs_resource_extns.source_name%type;
1657: l_source_first_name_n jtf_rs_resource_extns.source_first_name%type;
1658: l_source_middle_name_n jtf_rs_resource_extns.source_middle_name%type;
1659: l_source_last_name_n jtf_rs_resource_extns.source_last_name%type;
1660: l_source_phone_n jtf_rs_resource_extns.source_phone%type;
1661: l_source_email_n jtf_rs_resource_extns.source_email%type;
1662: l_source_job_id_n jtf_rs_resource_extns.source_job_id%type;
1663: l_source_job_title_n jtf_rs_resource_extns.source_job_title%type;
1664: l_address_id_n jtf_rs_resource_extns.address_id%type ;

Line 1661: l_source_email_n jtf_rs_resource_extns.source_email%type;

1657: l_source_first_name_n jtf_rs_resource_extns.source_first_name%type;
1658: l_source_middle_name_n jtf_rs_resource_extns.source_middle_name%type;
1659: l_source_last_name_n jtf_rs_resource_extns.source_last_name%type;
1660: l_source_phone_n jtf_rs_resource_extns.source_phone%type;
1661: l_source_email_n jtf_rs_resource_extns.source_email%type;
1662: l_source_job_id_n jtf_rs_resource_extns.source_job_id%type;
1663: l_source_job_title_n jtf_rs_resource_extns.source_job_title%type;
1664: l_address_id_n jtf_rs_resource_extns.address_id%type ;
1665: l_source_address1_n jtf_rs_resource_extns.source_address1%type;

Line 1662: l_source_job_id_n jtf_rs_resource_extns.source_job_id%type;

1658: l_source_middle_name_n jtf_rs_resource_extns.source_middle_name%type;
1659: l_source_last_name_n jtf_rs_resource_extns.source_last_name%type;
1660: l_source_phone_n jtf_rs_resource_extns.source_phone%type;
1661: l_source_email_n jtf_rs_resource_extns.source_email%type;
1662: l_source_job_id_n jtf_rs_resource_extns.source_job_id%type;
1663: l_source_job_title_n jtf_rs_resource_extns.source_job_title%type;
1664: l_address_id_n jtf_rs_resource_extns.address_id%type ;
1665: l_source_address1_n jtf_rs_resource_extns.source_address1%type;
1666: l_source_address2_n jtf_rs_resource_extns.source_address2%type;

Line 1663: l_source_job_title_n jtf_rs_resource_extns.source_job_title%type;

1659: l_source_last_name_n jtf_rs_resource_extns.source_last_name%type;
1660: l_source_phone_n jtf_rs_resource_extns.source_phone%type;
1661: l_source_email_n jtf_rs_resource_extns.source_email%type;
1662: l_source_job_id_n jtf_rs_resource_extns.source_job_id%type;
1663: l_source_job_title_n jtf_rs_resource_extns.source_job_title%type;
1664: l_address_id_n jtf_rs_resource_extns.address_id%type ;
1665: l_source_address1_n jtf_rs_resource_extns.source_address1%type;
1666: l_source_address2_n jtf_rs_resource_extns.source_address2%type;
1667: l_source_address3_n jtf_rs_resource_extns.source_address3%type;

Line 1664: l_address_id_n jtf_rs_resource_extns.address_id%type ;

1660: l_source_phone_n jtf_rs_resource_extns.source_phone%type;
1661: l_source_email_n jtf_rs_resource_extns.source_email%type;
1662: l_source_job_id_n jtf_rs_resource_extns.source_job_id%type;
1663: l_source_job_title_n jtf_rs_resource_extns.source_job_title%type;
1664: l_address_id_n jtf_rs_resource_extns.address_id%type ;
1665: l_source_address1_n jtf_rs_resource_extns.source_address1%type;
1666: l_source_address2_n jtf_rs_resource_extns.source_address2%type;
1667: l_source_address3_n jtf_rs_resource_extns.source_address3%type;
1668: l_source_city_n jtf_rs_resource_extns.source_city%type;

Line 1665: l_source_address1_n jtf_rs_resource_extns.source_address1%type;

1661: l_source_email_n jtf_rs_resource_extns.source_email%type;
1662: l_source_job_id_n jtf_rs_resource_extns.source_job_id%type;
1663: l_source_job_title_n jtf_rs_resource_extns.source_job_title%type;
1664: l_address_id_n jtf_rs_resource_extns.address_id%type ;
1665: l_source_address1_n jtf_rs_resource_extns.source_address1%type;
1666: l_source_address2_n jtf_rs_resource_extns.source_address2%type;
1667: l_source_address3_n jtf_rs_resource_extns.source_address3%type;
1668: l_source_city_n jtf_rs_resource_extns.source_city%type;
1669: l_source_country_n jtf_rs_resource_extns.source_country%type;

Line 1666: l_source_address2_n jtf_rs_resource_extns.source_address2%type;

1662: l_source_job_id_n jtf_rs_resource_extns.source_job_id%type;
1663: l_source_job_title_n jtf_rs_resource_extns.source_job_title%type;
1664: l_address_id_n jtf_rs_resource_extns.address_id%type ;
1665: l_source_address1_n jtf_rs_resource_extns.source_address1%type;
1666: l_source_address2_n jtf_rs_resource_extns.source_address2%type;
1667: l_source_address3_n jtf_rs_resource_extns.source_address3%type;
1668: l_source_city_n jtf_rs_resource_extns.source_city%type;
1669: l_source_country_n jtf_rs_resource_extns.source_country%type;
1670: l_source_postal_code_n jtf_rs_resource_extns.source_postal_code%type;

Line 1667: l_source_address3_n jtf_rs_resource_extns.source_address3%type;

1663: l_source_job_title_n jtf_rs_resource_extns.source_job_title%type;
1664: l_address_id_n jtf_rs_resource_extns.address_id%type ;
1665: l_source_address1_n jtf_rs_resource_extns.source_address1%type;
1666: l_source_address2_n jtf_rs_resource_extns.source_address2%type;
1667: l_source_address3_n jtf_rs_resource_extns.source_address3%type;
1668: l_source_city_n jtf_rs_resource_extns.source_city%type;
1669: l_source_country_n jtf_rs_resource_extns.source_country%type;
1670: l_source_postal_code_n jtf_rs_resource_extns.source_postal_code%type;
1671: l_source_mgr_id_n jtf_rs_resource_extns.source_mgr_id%type;

Line 1668: l_source_city_n jtf_rs_resource_extns.source_city%type;

1664: l_address_id_n jtf_rs_resource_extns.address_id%type ;
1665: l_source_address1_n jtf_rs_resource_extns.source_address1%type;
1666: l_source_address2_n jtf_rs_resource_extns.source_address2%type;
1667: l_source_address3_n jtf_rs_resource_extns.source_address3%type;
1668: l_source_city_n jtf_rs_resource_extns.source_city%type;
1669: l_source_country_n jtf_rs_resource_extns.source_country%type;
1670: l_source_postal_code_n jtf_rs_resource_extns.source_postal_code%type;
1671: l_source_mgr_id_n jtf_rs_resource_extns.source_mgr_id%type;
1672: l_source_mgr_name_n jtf_rs_resource_extns.source_mgr_name%type;

Line 1669: l_source_country_n jtf_rs_resource_extns.source_country%type;

1665: l_source_address1_n jtf_rs_resource_extns.source_address1%type;
1666: l_source_address2_n jtf_rs_resource_extns.source_address2%type;
1667: l_source_address3_n jtf_rs_resource_extns.source_address3%type;
1668: l_source_city_n jtf_rs_resource_extns.source_city%type;
1669: l_source_country_n jtf_rs_resource_extns.source_country%type;
1670: l_source_postal_code_n jtf_rs_resource_extns.source_postal_code%type;
1671: l_source_mgr_id_n jtf_rs_resource_extns.source_mgr_id%type;
1672: l_source_mgr_name_n jtf_rs_resource_extns.source_mgr_name%type;
1673: l_source_business_grp_id_n jtf_rs_resource_extns.source_business_grp_id%type;

Line 1670: l_source_postal_code_n jtf_rs_resource_extns.source_postal_code%type;

1666: l_source_address2_n jtf_rs_resource_extns.source_address2%type;
1667: l_source_address3_n jtf_rs_resource_extns.source_address3%type;
1668: l_source_city_n jtf_rs_resource_extns.source_city%type;
1669: l_source_country_n jtf_rs_resource_extns.source_country%type;
1670: l_source_postal_code_n jtf_rs_resource_extns.source_postal_code%type;
1671: l_source_mgr_id_n jtf_rs_resource_extns.source_mgr_id%type;
1672: l_source_mgr_name_n jtf_rs_resource_extns.source_mgr_name%type;
1673: l_source_business_grp_id_n jtf_rs_resource_extns.source_business_grp_id%type;
1674: l_source_business_grp_name_n jtf_rs_resource_extns.source_business_grp_name%type;

Line 1671: l_source_mgr_id_n jtf_rs_resource_extns.source_mgr_id%type;

1667: l_source_address3_n jtf_rs_resource_extns.source_address3%type;
1668: l_source_city_n jtf_rs_resource_extns.source_city%type;
1669: l_source_country_n jtf_rs_resource_extns.source_country%type;
1670: l_source_postal_code_n jtf_rs_resource_extns.source_postal_code%type;
1671: l_source_mgr_id_n jtf_rs_resource_extns.source_mgr_id%type;
1672: l_source_mgr_name_n jtf_rs_resource_extns.source_mgr_name%type;
1673: l_source_business_grp_id_n jtf_rs_resource_extns.source_business_grp_id%type;
1674: l_source_business_grp_name_n jtf_rs_resource_extns.source_business_grp_name%type;
1675: l_source_office_n jtf_rs_resource_extns.source_office%type;

Line 1672: l_source_mgr_name_n jtf_rs_resource_extns.source_mgr_name%type;

1668: l_source_city_n jtf_rs_resource_extns.source_city%type;
1669: l_source_country_n jtf_rs_resource_extns.source_country%type;
1670: l_source_postal_code_n jtf_rs_resource_extns.source_postal_code%type;
1671: l_source_mgr_id_n jtf_rs_resource_extns.source_mgr_id%type;
1672: l_source_mgr_name_n jtf_rs_resource_extns.source_mgr_name%type;
1673: l_source_business_grp_id_n jtf_rs_resource_extns.source_business_grp_id%type;
1674: l_source_business_grp_name_n jtf_rs_resource_extns.source_business_grp_name%type;
1675: l_source_office_n jtf_rs_resource_extns.source_office%type;
1676: l_source_location_n jtf_rs_resource_extns.source_location%type;

Line 1673: l_source_business_grp_id_n jtf_rs_resource_extns.source_business_grp_id%type;

1669: l_source_country_n jtf_rs_resource_extns.source_country%type;
1670: l_source_postal_code_n jtf_rs_resource_extns.source_postal_code%type;
1671: l_source_mgr_id_n jtf_rs_resource_extns.source_mgr_id%type;
1672: l_source_mgr_name_n jtf_rs_resource_extns.source_mgr_name%type;
1673: l_source_business_grp_id_n jtf_rs_resource_extns.source_business_grp_id%type;
1674: l_source_business_grp_name_n jtf_rs_resource_extns.source_business_grp_name%type;
1675: l_source_office_n jtf_rs_resource_extns.source_office%type;
1676: l_source_location_n jtf_rs_resource_extns.source_location%type;
1677: l_source_mailstop_n jtf_rs_resource_extns.source_mailstop%type;

Line 1674: l_source_business_grp_name_n jtf_rs_resource_extns.source_business_grp_name%type;

1670: l_source_postal_code_n jtf_rs_resource_extns.source_postal_code%type;
1671: l_source_mgr_id_n jtf_rs_resource_extns.source_mgr_id%type;
1672: l_source_mgr_name_n jtf_rs_resource_extns.source_mgr_name%type;
1673: l_source_business_grp_id_n jtf_rs_resource_extns.source_business_grp_id%type;
1674: l_source_business_grp_name_n jtf_rs_resource_extns.source_business_grp_name%type;
1675: l_source_office_n jtf_rs_resource_extns.source_office%type;
1676: l_source_location_n jtf_rs_resource_extns.source_location%type;
1677: l_source_mailstop_n jtf_rs_resource_extns.source_mailstop%type;
1678: l_source_mobile_phone_n jtf_rs_resource_extns.source_mobile_phone%type;

Line 1675: l_source_office_n jtf_rs_resource_extns.source_office%type;

1671: l_source_mgr_id_n jtf_rs_resource_extns.source_mgr_id%type;
1672: l_source_mgr_name_n jtf_rs_resource_extns.source_mgr_name%type;
1673: l_source_business_grp_id_n jtf_rs_resource_extns.source_business_grp_id%type;
1674: l_source_business_grp_name_n jtf_rs_resource_extns.source_business_grp_name%type;
1675: l_source_office_n jtf_rs_resource_extns.source_office%type;
1676: l_source_location_n jtf_rs_resource_extns.source_location%type;
1677: l_source_mailstop_n jtf_rs_resource_extns.source_mailstop%type;
1678: l_source_mobile_phone_n jtf_rs_resource_extns.source_mobile_phone%type;
1679: l_source_pager_n jtf_rs_resource_extns.source_pager%type;

Line 1676: l_source_location_n jtf_rs_resource_extns.source_location%type;

1672: l_source_mgr_name_n jtf_rs_resource_extns.source_mgr_name%type;
1673: l_source_business_grp_id_n jtf_rs_resource_extns.source_business_grp_id%type;
1674: l_source_business_grp_name_n jtf_rs_resource_extns.source_business_grp_name%type;
1675: l_source_office_n jtf_rs_resource_extns.source_office%type;
1676: l_source_location_n jtf_rs_resource_extns.source_location%type;
1677: l_source_mailstop_n jtf_rs_resource_extns.source_mailstop%type;
1678: l_source_mobile_phone_n jtf_rs_resource_extns.source_mobile_phone%type;
1679: l_source_pager_n jtf_rs_resource_extns.source_pager%type;
1680: l_resource_name_n jtf_rs_resource_extns_vl.resource_name%type;

Line 1677: l_source_mailstop_n jtf_rs_resource_extns.source_mailstop%type;

1673: l_source_business_grp_id_n jtf_rs_resource_extns.source_business_grp_id%type;
1674: l_source_business_grp_name_n jtf_rs_resource_extns.source_business_grp_name%type;
1675: l_source_office_n jtf_rs_resource_extns.source_office%type;
1676: l_source_location_n jtf_rs_resource_extns.source_location%type;
1677: l_source_mailstop_n jtf_rs_resource_extns.source_mailstop%type;
1678: l_source_mobile_phone_n jtf_rs_resource_extns.source_mobile_phone%type;
1679: l_source_pager_n jtf_rs_resource_extns.source_pager%type;
1680: l_resource_name_n jtf_rs_resource_extns_vl.resource_name%type;
1681: l_end_date_active_n jtf_rs_resource_extns_vl.end_date_active%type;

Line 1678: l_source_mobile_phone_n jtf_rs_resource_extns.source_mobile_phone%type;

1674: l_source_business_grp_name_n jtf_rs_resource_extns.source_business_grp_name%type;
1675: l_source_office_n jtf_rs_resource_extns.source_office%type;
1676: l_source_location_n jtf_rs_resource_extns.source_location%type;
1677: l_source_mailstop_n jtf_rs_resource_extns.source_mailstop%type;
1678: l_source_mobile_phone_n jtf_rs_resource_extns.source_mobile_phone%type;
1679: l_source_pager_n jtf_rs_resource_extns.source_pager%type;
1680: l_resource_name_n jtf_rs_resource_extns_vl.resource_name%type;
1681: l_end_date_active_n jtf_rs_resource_extns_vl.end_date_active%type;
1682: l_party_id_n jtf_rs_resource_extns_vl.person_party_id%type;

Line 1679: l_source_pager_n jtf_rs_resource_extns.source_pager%type;

1675: l_source_office_n jtf_rs_resource_extns.source_office%type;
1676: l_source_location_n jtf_rs_resource_extns.source_location%type;
1677: l_source_mailstop_n jtf_rs_resource_extns.source_mailstop%type;
1678: l_source_mobile_phone_n jtf_rs_resource_extns.source_mobile_phone%type;
1679: l_source_pager_n jtf_rs_resource_extns.source_pager%type;
1680: l_resource_name_n jtf_rs_resource_extns_vl.resource_name%type;
1681: l_end_date_active_n jtf_rs_resource_extns_vl.end_date_active%type;
1682: l_party_id_n jtf_rs_resource_extns_vl.person_party_id%type;
1683:

Line 1680: l_resource_name_n jtf_rs_resource_extns_vl.resource_name%type;

1676: l_source_location_n jtf_rs_resource_extns.source_location%type;
1677: l_source_mailstop_n jtf_rs_resource_extns.source_mailstop%type;
1678: l_source_mobile_phone_n jtf_rs_resource_extns.source_mobile_phone%type;
1679: l_source_pager_n jtf_rs_resource_extns.source_pager%type;
1680: l_resource_name_n jtf_rs_resource_extns_vl.resource_name%type;
1681: l_end_date_active_n jtf_rs_resource_extns_vl.end_date_active%type;
1682: l_party_id_n jtf_rs_resource_extns_vl.person_party_id%type;
1683:
1684: l_resource_extn_aud_id jtf_rs_resource_extn_aud.resource_audit_id%type;

Line 1681: l_end_date_active_n jtf_rs_resource_extns_vl.end_date_active%type;

1677: l_source_mailstop_n jtf_rs_resource_extns.source_mailstop%type;
1678: l_source_mobile_phone_n jtf_rs_resource_extns.source_mobile_phone%type;
1679: l_source_pager_n jtf_rs_resource_extns.source_pager%type;
1680: l_resource_name_n jtf_rs_resource_extns_vl.resource_name%type;
1681: l_end_date_active_n jtf_rs_resource_extns_vl.end_date_active%type;
1682: l_party_id_n jtf_rs_resource_extns_vl.person_party_id%type;
1683:
1684: l_resource_extn_aud_id jtf_rs_resource_extn_aud.resource_audit_id%type;
1685: l_row_id varchar2(24) := null;

Line 1682: l_party_id_n jtf_rs_resource_extns_vl.person_party_id%type;

1678: l_source_mobile_phone_n jtf_rs_resource_extns.source_mobile_phone%type;
1679: l_source_pager_n jtf_rs_resource_extns.source_pager%type;
1680: l_resource_name_n jtf_rs_resource_extns_vl.resource_name%type;
1681: l_end_date_active_n jtf_rs_resource_extns_vl.end_date_active%type;
1682: l_party_id_n jtf_rs_resource_extns_vl.person_party_id%type;
1683:
1684: l_resource_extn_aud_id jtf_rs_resource_extn_aud.resource_audit_id%type;
1685: l_row_id varchar2(24) := null;
1686: /* Moved the initial assignment of below variables to inside begin */

Line 1698: l_end_date_active jtf_rs_resource_extns_vl.end_date_active%type;

1694: l_pager VARCHAR2(240);
1695: l_mgr_name VARCHAR2(240);
1696: l_job_name VARCHAR2(240);
1697: l_org_name VARCHAR2(240);
1698: l_end_date_active jtf_rs_resource_extns_vl.end_date_active%type;
1699: -- l_sysdate DATE := SYSDATE;
1700: /* Moved the initial assignment of below variables to inside begin */
1701: l_user_id NUMBER;
1702: l_login NUMBER;

Line 2613: --update the jtf_rs_resource_extns.

2609: end if;
2610: end if;
2611:
2612: --ER # 2669284 . If any change has ben encountered, then audit that resource record and also
2613: --update the jtf_rs_resource_extns.
2614: if (l_is_to_be_updated = 'Y') then
2615:
2616: ---fnd_file.put_line(fnd_file.log,'resource id:' || l_c_resource.resource_id);
2617: select jtf_rs_resource_extn_aud_s.nextval

Line 2756: UPDATE jtf_rs_resource_extns

2752: x_last_update_login => l_login );
2753:
2754: if (l_update_extn = 'Y') then
2755:
2756: UPDATE jtf_rs_resource_extns
2757: SET last_update_date = l_sysdate,
2758: last_update_login = l_login,
2759: last_updated_by = l_user_id,
2760: source_number = l_source_number,

Line 2792: update jtf_rs_resource_extns_tl

2788: end if;
2789:
2790: IF (p_overwrite_name = 'ALIAS') THEN
2791: IF l_resource_name_n IS NOT NULL THEN
2792: update jtf_rs_resource_extns_tl
2793: SET last_update_date = l_sysdate,
2794: last_update_login = l_login,
2795: last_updated_by = l_user_id,
2796: resource_name = l_resource_name_n,

Line 2804: update jtf_rs_resource_extns_tl

2800:
2801: END IF;
2802: ELSIF (p_overwrite_name = 'FULL_NAME') THEN
2803: IF (l_resource_name_n IS NOT NULL) THEN
2804: update jtf_rs_resource_extns_tl
2805: SET last_update_date = l_sysdate,
2806: last_update_login = l_login,
2807: last_updated_by = l_user_id,
2808: resource_name = l_resource_name_n,

Line 2926: FROM JTF_RS_RESOURCE_EXTNS RES

2922: IS
2923: cursor term_res_cur
2924: is
2925: SELECT RESOURCE_ID, SOURCE_ID
2926: FROM JTF_RS_RESOURCE_EXTNS RES
2927: WHERE res.category = 'EMPLOYEE'
2928: AND not exists (select ppl.person_id
2929: from per_all_people_f ppl,
2930: per_all_assignments_f asg

Line 2943: FROM JTF_RS_RESOURCE_EXTNS RES

2939: FROM PER_EMPLOYEES_CURRENT_X
2940: WHERE EMPLOYEE_ID = RES.SOURCE_ID)*/
2941: union
2942: SELECT RESOURCE_ID, SOURCE_ID
2943: FROM JTF_RS_RESOURCE_EXTNS RES
2944: WHERE res.category = 'EMPLOYEE'
2945: AND (res.end_date_active IS NOT NULL AND res.end_date_active < sysdate);
2946:
2947: term_res_rec term_res_cur%rowtype;

Line 2973: FROM jtf_rs_resource_extns res

2969: , ppl.office_number office
2970: , ppl.internal_location location
2971: , ppl.mailstop mailstop
2972: , ppl.party_id party_id
2973: FROM jtf_rs_resource_extns res
2974: , per_all_people_f ppl
2975: , hr_all_organization_units org
2976: WHERE res.resource_id = l_resource_id
2977: AND res.source_id = ppl.person_id

Line 2994: UPDATE jtf_rs_resource_extns RES

2990: while(term_res_cur%found)
2991: loop
2992:
2993: begin
2994: UPDATE jtf_rs_resource_extns RES
2995: SET RES.LAST_UPDATE_DATE = sysdate,
2996: RES.LAST_UPDATED_BY = fnd_global.user_id,
2997: (RES.SOURCE_NUMBER ,
2998: RES.SOURCE_NAME ,

Line 3088: UPDATE jtf_rs_resource_extns RES

3084: when l_too_many_rows_query then
3085: open fetch_emp_cur(term_res_rec.resource_id);
3086: fetch fetch_emp_cur into emp_rec;
3087: close fetch_emp_cur;
3088: UPDATE jtf_rs_resource_extns RES
3089: SET RES.LAST_UPDATE_DATE = sysdate,
3090: RES.LAST_UPDATED_BY = fnd_global.user_id,
3091: RES.SOURCE_NUMBER = emp_rec.employee_number ,
3092: RES.SOURCE_NAME = emp_rec.full_name,

Line 3134: update jtf_rs_resource_extns res

3130: PROCEDURE update_emp_phone
3131: IS
3132: BEGIN
3133:
3134: update jtf_rs_resource_extns res
3135: SET RES.LAST_UPDATE_DATE = sysdate,
3136: RES.LAST_UPDATED_BY = fnd_global.user_id,
3137: RES.SOURCE_PHONE
3138: = (select per.phone_number

Line 3199: FROM jtf_rs_resource_extns rsc

3195: SELECT rsc.resource_id
3196: , rsc.object_version_number
3197: , hpr.end_date
3198: , hpr.status
3199: FROM jtf_rs_resource_extns rsc
3200: ,hz_relationships hpr
3201: WHERE rsc.category = 'PARTNER'
3202: AND rsc.source_id = hpr.party_id
3203: AND hpr.directional_flag = 'F'

Line 3300: FROM jtf_rs_resource_extns

3296: SELECT resource_id
3297: , source_id
3298: , address_id
3299: , category
3300: FROM jtf_rs_resource_extns
3301: WHERE category in ('PARTY', 'PARTNER');
3302:
3303:
3304: CURSOR c_party(l_party_id in number)

Line 3414: UPDATE JTF_RS_RESOURCE_EXTNS RES

3410: l_login := nvl(FND_GLOBAL.LOGIN_ID,-1);
3411:
3412: -- first populate the address id where address id is null
3413: BEGIN
3414: UPDATE JTF_RS_RESOURCE_EXTNS RES
3415: SET RES.LAST_UPDATE_DATE = l_sysdate,
3416: RES.LAST_UPDATED_BY = l_user_id,
3417: RES.LAST_UPDATE_LOGIN = l_login,
3418: (RES.ADDRESS_ID)

Line 3443: UPDATE JTF_RS_RESOURCE_EXTNS RES

3439:
3440:
3441: -- first populate the address id with primary address id for PARTNER
3442: BEGIN
3443: UPDATE JTF_RS_RESOURCE_EXTNS RES
3444: SET RES.LAST_UPDATE_DATE = l_sysdate,
3445: RES.LAST_UPDATED_BY = l_user_id,
3446: RES.LAST_UPDATE_LOGIN = l_login,
3447: (RES.ADDRESS_ID)

Line 3494: UPDATE JTF_RS_RESOURCE_EXTNS RES

3490: open c_address(r_res.address_id);
3491: fetch c_address into r_address;
3492: close c_address;
3493:
3494: UPDATE JTF_RS_RESOURCE_EXTNS RES
3495: SET RES.LAST_UPDATE_DATE = l_sysdate,
3496: RES.LAST_UPDATED_BY = l_user_id,
3497: RES.LAST_UPDATE_LOGIN = l_login,
3498: RES.SOURCE_NUMBER = r_party.party_number,

Line 3522: update jtf_rs_resource_extns_tl res

3518:
3519:
3520: IF(p_overwrite_name = 'Y')
3521: THEN
3522: update jtf_rs_resource_extns_tl res
3523: SET RES.LAST_UPDATE_DATE = l_sysdate,
3524: RES.LAST_UPDATED_BY = l_user_id,
3525: RES.LAST_UPDATE_LOGIN = l_login,
3526: resource_name = r_party.party_name,

Line 3582: FROM jtf_rs_resource_extns res

3578: CURSOR c_res
3579: IS
3580: SELECT resource_id,
3581: source_id
3582: FROM jtf_rs_resource_extns res
3583: WHERE res.category = 'SUPPLIER_CONTACT';
3584:
3585:
3586:

Line 3655: UPDATE JTF_RS_RESOURCE_EXTNS RES

3651: FETCH c_org_name into l_org_name;
3652: CLOSE c_org_name;
3653: END IF;
3654:
3655: UPDATE JTF_RS_RESOURCE_EXTNS RES
3656: SET RES.LAST_UPDATE_DATE = l_sysdate,
3657: RES.LAST_UPDATED_BY = l_user_id,
3658: RES.LAST_UPDATE_LOGIN = l_login,
3659: RES.SOURCE_NUMBER = r_supp.source_number,

Line 3683: update jtf_rs_resource_extns_tl res

3679:
3680:
3681: IF(p_overwrite_name = 'Y')
3682: THEN
3683: update jtf_rs_resource_extns_tl res
3684: SET RES.LAST_UPDATE_DATE = l_sysdate,
3685: RES.LAST_UPDATED_BY = l_user_id,
3686: RES.LAST_UPDATE_LOGIN = l_login,
3687: SOURCE_LANG = userenv('LANG'),

Line 3720: FROM jtf_rs_resource_extns rsc

3716: CURSOR term_supp_cont_cur (l_active_days IN NUMBER) IS
3717: SELECT rsc.resource_id
3718: , rsc.object_version_number
3719: , pvc.inactive_date
3720: FROM jtf_rs_resource_extns rsc
3721: ,po_vendor_contacts pvc
3722: WHERE rsc.category = 'SUPPLIER_CONTACT'
3723: AND rsc.source_id = pvc.vendor_contact_id
3724: AND trunc(nvl(inactive_date, sysdate)) < trunc(sysdate)

Line 3789: UPDATE jtf_rs_resource_extns res

3785:
3786: PROCEDURE update_username
3787: IS
3788: BEGIN
3789: UPDATE jtf_rs_resource_extns res
3790: SET user_name = (SELECT user_name
3791: FROM fnd_user fu
3792: WHERE res.user_id = fu.user_id)
3793: WHERE user_id IS NOT NULL;

Line 3824: FROM JTF_RS_RESOURCE_EXTNS_VL jres

3820: OBJECT_VERSION_NUMBER,
3821: USER_ID,
3822: SOURCE_NAME,
3823: USER_NAME
3824: FROM JTF_RS_RESOURCE_EXTNS_VL jres
3825: WHERE CATEGORY in ('EMPLOYEE','PARTY','PARTNER','SUPPLIER_CONTACT')
3826: AND jres.USER_ID is not null
3827: AND NOT EXISTS
3828: ( SELECT 'x'

Line 3845: FROM JTF_RS_RESOURCE_EXTNS_VL jres

3841: OBJECT_VERSION_NUMBER,
3842: USER_ID,
3843: SOURCE_NAME,
3844: USER_NAME
3845: FROM JTF_RS_RESOURCE_EXTNS_VL jres
3846: WHERE CATEGORY in ('EMPLOYEE','PARTY','PARTNER','SUPPLIER_CONTACT')
3847: AND USER_ID is not null
3848: AND trunc(nvl(END_DATE_ACTIVE,SYSDATE)) >= trunc(SYSDATE)
3849: AND NOT EXISTS

Line 3869: FROM JTF_RS_RESOURCE_EXTNS_VL jres

3865: OBJECT_VERSION_NUMBER,
3866: USER_ID,
3867: SOURCE_NAME,
3868: USER_NAME
3869: FROM JTF_RS_RESOURCE_EXTNS_VL jres
3870: WHERE CATEGORY in ('EMPLOYEE','PARTY','PARTNER','SUPPLIER_CONTACT')
3871: AND trunc(nvl(END_DATE_ACTIVE,SYSDATE)) >= trunc(SYSDATE)
3872: AND jres.USER_ID is null
3873: AND exists (select 'x'

Line 3889: FROM JTF_RS_RESOURCE_EXTNS_VL jres

3885: OBJECT_VERSION_NUMBER,
3886: USER_ID,
3887: SOURCE_NAME,
3888: USER_NAME
3889: FROM JTF_RS_RESOURCE_EXTNS_VL jres
3890: WHERE CATEGORY = 'EMPLOYEE'
3891: AND trunc(nvl(END_DATE_ACTIVE,SYSDATE)) >= trunc(SYSDATE)
3892: AND jres.USER_ID is null
3893: AND exists (select 'x'

Line 3906: FROM JTF_RS_RESOURCE_EXTNS_VL jres

3902: OBJECT_VERSION_NUMBER,
3903: USER_ID,
3904: SOURCE_NAME,
3905: USER_NAME
3906: FROM JTF_RS_RESOURCE_EXTNS_VL jres
3907: WHERE CATEGORY = 'SUPPLIER_CONTACT'
3908: AND trunc(nvl(END_DATE_ACTIVE,SYSDATE)) >= trunc(SYSDATE)
3909: AND jres.USER_ID is null
3910: AND exists (select 'x'

Line 3923: FROM JTF_RS_RESOURCE_EXTNS_VL jres

3919: OBJECT_VERSION_NUMBER,
3920: USER_ID,
3921: SOURCE_NAME,
3922: USER_NAME
3923: FROM JTF_RS_RESOURCE_EXTNS_VL jres
3924: WHERE CATEGORY in ('PARTY','PARTNER')
3925: AND trunc(nvl(END_DATE_ACTIVE,SYSDATE)) >= trunc(SYSDATE)
3926: AND jres.USER_ID is null
3927: AND exists (select 'x'

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

3927: AND exists (select 'x'
3928: from fnd_user f
3929: where jres.source_id = customer_id);
3930:
3931: CURSOR c_party_partner(p_source_id IN jtf_rs_resource_extns.source_id%TYPE) IS
3932: SELECT user_id,
3933: user_name
3934: FROM fnd_user
3935: WHERE customer_id = p_source_id

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

3934: FROM fnd_user
3935: WHERE customer_id = p_source_id
3936: AND trunc(sysdate) BETWEEN trunc(start_date) AND trunc(nvl(end_date,sysdate));
3937:
3938: CURSOR c_supp_contact(p_source_id IN jtf_rs_resource_extns.source_id%TYPE) is
3939: SELECT user_id,
3940: user_name
3941: FROM fnd_user
3942: WHERE supplier_id = p_source_id

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

3941: FROM fnd_user
3942: WHERE supplier_id = p_source_id
3943: AND trunc(sysdate) BETWEEN trunc(start_date) AND trunc(nvl(end_date,sysdate));
3944:
3945: CURSOR c_emp(p_source_id IN jtf_rs_resource_extns.source_id%TYPE) is
3946: SELECT user_id,
3947: user_name
3948: FROM fnd_user
3949: WHERE employee_id = p_source_id