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_OBJECTS_VL

Line 63: g_object_type_code JTF_OBJECTS_VL.OBJECT_CODE%TYPE;

59: -- object owner's resource type
60: g_res_type_code JTF_TASKS_VL.OWNER_TYPE_CODE%TYPE;
61:
62: -- derive this from the object
63: g_object_type_code JTF_OBJECTS_VL.OBJECT_CODE%TYPE;
64:
65: -- object name as held in jtf_objects, used in Task APIs
66: g_jtf_object_name JTF_OBJECTS_VL.SELECT_NAME%TYPE;
67:

Line 66: g_jtf_object_name JTF_OBJECTS_VL.SELECT_NAME%TYPE;

62: -- derive this from the object
63: g_object_type_code JTF_OBJECTS_VL.OBJECT_CODE%TYPE;
64:
65: -- object name as held in jtf_objects, used in Task APIs
66: g_jtf_object_name JTF_OBJECTS_VL.SELECT_NAME%TYPE;
67:
68: --Added by MPADHIAR for Bug#5068840
69:
70: --objects's Customer ID

Line 1014: FROM JTF_OBJECTS_VL

1010: CURSOR c_obj_details(b_obj_code VARCHAR2)
1011: IS SELECT select_id
1012: , select_name
1013: , from_table
1014: FROM JTF_OBJECTS_VL
1015: WHERE object_code = b_obj_code;
1016:
1017: -------------------------------------------------------------------------
1018: -- Task table definition (returned from query_task API)

Line 1032: l_select_id JTF_OBJECTS_VL.SELECT_ID%TYPE;

1028: TYPE cur_type IS REF CURSOR;
1029: c_object cur_type;
1030:
1031: l_query VARCHAR2(1000);
1032: l_select_id JTF_OBJECTS_VL.SELECT_ID%TYPE;
1033: l_select_name JTF_OBJECTS_VL.SELECT_NAME%TYPE;
1034: l_from_table JTF_OBJECTS_VL.FROM_TABLE%TYPE;
1035:
1036: BEGIN

Line 1033: l_select_name JTF_OBJECTS_VL.SELECT_NAME%TYPE;

1029: c_object cur_type;
1030:
1031: l_query VARCHAR2(1000);
1032: l_select_id JTF_OBJECTS_VL.SELECT_ID%TYPE;
1033: l_select_name JTF_OBJECTS_VL.SELECT_NAME%TYPE;
1034: l_from_table JTF_OBJECTS_VL.FROM_TABLE%TYPE;
1035:
1036: BEGIN
1037: resultout := FND_API.G_Ret_Sts_Success;

Line 1034: l_from_table JTF_OBJECTS_VL.FROM_TABLE%TYPE;

1030:
1031: l_query VARCHAR2(1000);
1032: l_select_id JTF_OBJECTS_VL.SELECT_ID%TYPE;
1033: l_select_name JTF_OBJECTS_VL.SELECT_NAME%TYPE;
1034: l_from_table JTF_OBJECTS_VL.FROM_TABLE%TYPE;
1035:
1036: BEGIN
1037: resultout := FND_API.G_Ret_Sts_Success;
1038: -------------------------------------------------------------------------

Line 1373: l_object_name JTF_OBJECTS_VL.NAME%TYPE;

1369: l_template_name JTF_TASK_TEMPLATES_VL.TASK_NAME%TYPE;
1370: l_notif_task_id JTF_TASKS_VL.TASK_ID%TYPE;
1371: l_task_assign_id NUMBER;
1372: l_obj_version JTF_TASKS_VL.OBJECT_VERSION_NUMBER%TYPE;
1373: l_object_name JTF_OBJECTS_VL.NAME%TYPE;
1374: l_task_reference_id JTF_TASK_REFERENCES_VL.TASK_REFERENCE_ID%TYPE;
1375: l_assign_id NUMBER;
1376: l_assign_role VARCHAR2(80);
1377: l_owner_id NUMBER;

Line 1830: l_object_name JTF_OBJECTS_VL.NAME%TYPE;

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);
1834: l_esc_level VARCHAR2(80);