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_VL

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