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 16328: l_inv_task_id JTF_TASKS_B.TASK_ID%TYPE;

16324: --Begin bug 7317666 21-Nov-2008 barathsr
16325: l_task_query varchar2(4000);
16326: TYPE c_cur_type IS REF CURSOR;
16327: c_invalid_tasks c_cur_type;
16328: l_inv_task_id JTF_TASKS_B.TASK_ID%TYPE;
16329: l_object_version_number JTF_TASKS_B.OBJECT_VERSION_NUMBER%TYPE;
16330: --End bug 7317666 21-Nov-2008 barathsr
16331:
16332: BEGIN

Line 16329: l_object_version_number JTF_TASKS_B.OBJECT_VERSION_NUMBER%TYPE;

16325: l_task_query varchar2(4000);
16326: TYPE c_cur_type IS REF CURSOR;
16327: c_invalid_tasks c_cur_type;
16328: l_inv_task_id JTF_TASKS_B.TASK_ID%TYPE;
16329: l_object_version_number JTF_TASKS_B.OBJECT_VERSION_NUMBER%TYPE;
16330: --End bug 7317666 21-Nov-2008 barathsr
16331:
16332: BEGIN
16333: -- Standard Start of API savepoint

Line 16564: ||' from jtf_tasks_b tsk,'

16560: --Begin bug 7317666 21-Nov-2008 barathsr
16561: WriteLog(G_PKG_NAME || ' ' || l_api_name || ' Cancelling the Dunning callback tasks correpsonding to current objects...');
16562: l_task_query := 'select tsk.task_id,'
16563: ||'tsk.object_version_number'
16564: ||' from jtf_tasks_b tsk,'
16565: ||' jtf_task_types_tl typ,'
16566: ||' jtf_task_statuses_b st,'
16567: ||' jtf_task_references_b ref,'
16568: ||' iex_dunnings dun'