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.IEX_DUNNING_PVT dependencies on JTF_TASKS_B

Line 8637: l_inv_task_id JTF_TASKS_B.TASK_ID%TYPE;

8633: --Begin bug 7317666 21-Nov-2008 barathsr
8634: l_task_query varchar2(4000);
8635: TYPE c_cur_type IS REF CURSOR;
8636: c_invalid_tasks c_cur_type;
8637: l_inv_task_id JTF_TASKS_B.TASK_ID%TYPE;
8638: l_object_version_number JTF_TASKS_B.OBJECT_VERSION_NUMBER%TYPE;
8639: --End bug 7317666 21-Nov-2008 barathsr
8640:
8641: BEGIN

Line 8638: l_object_version_number JTF_TASKS_B.OBJECT_VERSION_NUMBER%TYPE;

8634: l_task_query varchar2(4000);
8635: TYPE c_cur_type IS REF CURSOR;
8636: c_invalid_tasks c_cur_type;
8637: l_inv_task_id JTF_TASKS_B.TASK_ID%TYPE;
8638: l_object_version_number JTF_TASKS_B.OBJECT_VERSION_NUMBER%TYPE;
8639: --End bug 7317666 21-Nov-2008 barathsr
8640:
8641: BEGIN
8642: -- Standard Start of API savepoint

Line 8877: ||' from jtf_tasks_b tsk,'

8873: --Begin bug 7317666 21-Nov-2008 barathsr
8874: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' Cancelling the Dunning callback tasks correpsonding to current objects...');
8875: l_task_query := 'select tsk.task_id,'
8876: ||'tsk.object_version_number'
8877: ||' from jtf_tasks_b tsk,'
8878: ||' jtf_task_types_tl typ,'
8879: ||' jtf_task_statuses_b st,'
8880: ||' jtf_task_references_b ref,'
8881: ||' iex_dunnings dun'