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

Line 30: g_notif_person_id JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE;

26: -- Attributes set by this package before returning to WF
27: ----------------------------------------------------------------------------
28:
29: -- WF user id of person to receive notification
30: g_notif_person_id JTF_RS_RESOURCE_EXTNS.USER_ID%TYPE;
31:
32: -- user-visible object name
33: g_object_name AK_OBJECTS_VL.NAME%TYPE;
34:

Line 236: FROM JTF_RS_RESOURCE_EXTNS

232: -- Cursor for Resources query
233: -------------------------------------------------------------------------
234: CURSOR c_query_emp (b_resource_id JTF_RS_EMP_DTLS_VL.RESOURCE_ID%TYPE)
235: IS SELECT source_id
236: FROM JTF_RS_RESOURCE_EXTNS
237: WHERE resource_id = b_resource_id;
238:
239: l_person_id JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE;
240:

Line 239: l_person_id JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE;

235: IS SELECT source_id
236: FROM JTF_RS_RESOURCE_EXTNS
237: WHERE resource_id = b_resource_id;
238:
239: l_person_id JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE;
240:
241: BEGIN
242: x_resultout := FND_API.G_Ret_Sts_Success;
243:

Line 377: CURSOR c_query_resource (b_source_id JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE)

373: IS
374: -------------------------------------------------------------------------
375: -- Cursor for Resources query
376: -------------------------------------------------------------------------
377: CURSOR c_query_resource (b_source_id JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE)
378: IS SELECT resource_id
379: FROM JTF_RS_RESOURCE_EXTNS
380: WHERE source_id = b_source_id;
381:

Line 379: FROM JTF_RS_RESOURCE_EXTNS

375: -- Cursor for Resources query
376: -------------------------------------------------------------------------
377: CURSOR c_query_resource (b_source_id JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE)
378: IS SELECT resource_id
379: FROM JTF_RS_RESOURCE_EXTNS
380: WHERE source_id = b_source_id;
381:
382: l_owner_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
383:

Line 382: l_owner_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;

378: IS SELECT resource_id
379: FROM JTF_RS_RESOURCE_EXTNS
380: WHERE source_id = b_source_id;
381:
382: l_owner_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
383:
384: BEGIN
385: IF (p_id_type = 'RESOURCE')
386: THEN

Line 481: l_contact_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;

477: l_terr_values_table jtf_territory_get_pub.Terr_Values_Tbl_Type;
478: l_terr_rsc_table jtf_territory_get_pub.Terr_Rsc_Tbl_Type;
479: l_index BINARY_INTEGER;
480: l_esc_territory NUMBER;
481: l_contact_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
482: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
483: l_resultout VARCHAR2(80);
484:
485: Begin

Line 482: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;

478: l_terr_rsc_table jtf_territory_get_pub.Terr_Rsc_Tbl_Type;
479: l_index BINARY_INTEGER;
480: l_esc_territory NUMBER;
481: l_contact_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
482: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
483: l_resultout VARCHAR2(80);
484:
485: Begin
486: x_resultout := FND_API.G_Ret_Sts_Success;

Line 672: CURSOR c_query_hr_manager(b_owner_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE)

668:
669: -------------------------------------------------------------------------
670: -- Cursor for HR Manager query
671: -------------------------------------------------------------------------
672: CURSOR c_query_hr_manager(b_owner_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE)
673: IS SELECT manager_person_id
674: FROM JTF_RS_EMP_DTLS_VL
675: WHERE resource_id = b_owner_id;
676:

Line 704: l_person_id JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE;

700:
701: l_now DATE := SYSDATE;
702: l_index BINARY_INTEGER;
703: l_esc_territory JTF_TASKS_VL.OWNER_TERRITORY_ID%TYPE;
704: l_person_id JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE;
705: l_resultout VARCHAR2(80);
706: l_source_id JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE;
707: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
708:

Line 706: l_source_id JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE;

702: l_index BINARY_INTEGER;
703: l_esc_territory JTF_TASKS_VL.OWNER_TERRITORY_ID%TYPE;
704: l_person_id JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE;
705: l_resultout VARCHAR2(80);
706: l_source_id JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE;
707: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
708:
709: BEGIN
710: x_resultout := FND_API.G_Ret_Sts_Success;

Line 707: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;

703: l_esc_territory JTF_TASKS_VL.OWNER_TERRITORY_ID%TYPE;
704: l_person_id JTF_RS_RESOURCE_EXTNS.MANAGING_EMPLOYEE_ID%TYPE;
705: l_resultout VARCHAR2(80);
706: l_source_id JTF_RS_RESOURCE_EXTNS.SOURCE_ID%TYPE;
707: l_resource_id JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE;
708:
709: BEGIN
710: x_resultout := FND_API.G_Ret_Sts_Success;
711: x_res_type := jtf_ec_pub.g_escalation_owner_type_code;

Line 1379: l_resource_type JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE;

1375: l_assign_id NUMBER;
1376: l_assign_role VARCHAR2(80);
1377: l_owner_id NUMBER;
1378: l_owner_role VARCHAR2(80);
1379: l_resource_type JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE;
1380: l_status_id VARCHAR2(80);
1381: l_resultout VARCHAR2(80);
1382:
1383: -------------------------------------------------------------------------

Line 1829: l_resource_type JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE;

1825: l_wf_process_id NUMBER;
1826: l_owner_role VARCHAR2(80);
1827: l_owner_id JTF_TASKS_VL.OWNER_ID%TYPE;
1828: l_wf_role FND_USER.USER_NAME%TYPE;
1829: l_resource_type JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE;
1830: l_object_name JTF_OBJECTS_VL.NAME%TYPE;
1831: l_task_reference_id JTF_TASK_REFERENCES_VL.TASK_REFERENCE_ID%TYPE;
1832: l_requester_id NUMBER;
1833: l_esc_status VARCHAR2(80);

Line 2101: l_resource_type JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE;

2097: )
2098: IS
2099: l_notif_role VARCHAR2(80);
2100: l_wf_role FND_USER.USER_NAME%TYPE;
2101: l_resource_type JTF_RS_RESOURCE_EXTNS.CATEGORY%TYPE;
2102: l_resultout VARCHAR2(80);
2103: l_api_name CONSTANT VARCHAR2(30) := 'Get_NotifPerson';
2104:
2105: BEGIN