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_TASK_REFERENCES_PVT dependencies on JTF_TASK_REFERENCES_B

Line 40: l_task_reference_id jtf_task_references_b.task_reference_id%TYPE;

36:
37: )
38: IS
39: l_api_version CONSTANT NUMBER := 1.0;
40: l_task_reference_id jtf_task_references_b.task_reference_id%TYPE;
41: l_rowid ROWID;
42: l_api_name VARCHAR2(30) := 'CREATE_REFERENCES';
43:
44: CURSOR c_jtf_task_references (

Line 49: FROM jtf_task_references_b

45: l_rowid IN ROWID
46: )
47: IS
48: SELECT 1
49: FROM jtf_task_references_b
50: WHERE ROWID = l_rowid;
51:
52: x CHAR;
53:

Line 204: l_task_reference_id jtf_task_references_b.task_reference_id%TYPE := p_task_reference_id;

200: l_api_name VARCHAR2(30) := 'UPDATE_REFERENCES';
201: l_api_version CONSTANT NUMBER := 1.0;
202: l_task_id jtf_tasks_b.task_id%TYPE;
203: l_object_type_code jtf_objects_b.object_code%TYPE;
204: l_task_reference_id jtf_task_references_b.task_reference_id%TYPE := p_task_reference_id;
205: l_reference_code jtf_task_references_b.reference_code%TYPE;
206: l_usage jtf_task_references_tl.usage%TYPE;
207: l_object_name jtf_task_references_b.object_name%TYPE;
208: l_object_id jtf_task_references_b.object_id%TYPE;

Line 205: l_reference_code jtf_task_references_b.reference_code%TYPE;

201: l_api_version CONSTANT NUMBER := 1.0;
202: l_task_id jtf_tasks_b.task_id%TYPE;
203: l_object_type_code jtf_objects_b.object_code%TYPE;
204: l_task_reference_id jtf_task_references_b.task_reference_id%TYPE := p_task_reference_id;
205: l_reference_code jtf_task_references_b.reference_code%TYPE;
206: l_usage jtf_task_references_tl.usage%TYPE;
207: l_object_name jtf_task_references_b.object_name%TYPE;
208: l_object_id jtf_task_references_b.object_id%TYPE;
209: l_object_details jtf_task_references_b.object_details%TYPE;

Line 207: l_object_name jtf_task_references_b.object_name%TYPE;

203: l_object_type_code jtf_objects_b.object_code%TYPE;
204: l_task_reference_id jtf_task_references_b.task_reference_id%TYPE := p_task_reference_id;
205: l_reference_code jtf_task_references_b.reference_code%TYPE;
206: l_usage jtf_task_references_tl.usage%TYPE;
207: l_object_name jtf_task_references_b.object_name%TYPE;
208: l_object_id jtf_task_references_b.object_id%TYPE;
209: l_object_details jtf_task_references_b.object_details%TYPE;
210:
211: CURSOR c_task_reference

Line 208: l_object_id jtf_task_references_b.object_id%TYPE;

204: l_task_reference_id jtf_task_references_b.task_reference_id%TYPE := p_task_reference_id;
205: l_reference_code jtf_task_references_b.reference_code%TYPE;
206: l_usage jtf_task_references_tl.usage%TYPE;
207: l_object_name jtf_task_references_b.object_name%TYPE;
208: l_object_id jtf_task_references_b.object_id%TYPE;
209: l_object_details jtf_task_references_b.object_details%TYPE;
210:
211: CURSOR c_task_reference
212: IS

Line 209: l_object_details jtf_task_references_b.object_details%TYPE;

205: l_reference_code jtf_task_references_b.reference_code%TYPE;
206: l_usage jtf_task_references_tl.usage%TYPE;
207: l_object_name jtf_task_references_b.object_name%TYPE;
208: l_object_id jtf_task_references_b.object_id%TYPE;
209: l_object_details jtf_task_references_b.object_details%TYPE;
210:
211: CURSOR c_task_reference
212: IS
213: SELECT task_id,

Line 400: FROM jtf_task_references_b

396:
397: CURSOR c_jtf_task_ref_delete
398: IS
399: SELECT task_id, object_id
400: FROM jtf_task_references_b
401: where task_reference_id = p_task_reference_id ;
402:
403: l_task_id jtf_task_references_b.task_id%type;
404: l_object_id jtf_task_references_b.object_id%type;

Line 403: l_task_id jtf_task_references_b.task_id%type;

399: SELECT task_id, object_id
400: FROM jtf_task_references_b
401: where task_reference_id = p_task_reference_id ;
402:
403: l_task_id jtf_task_references_b.task_id%type;
404: l_object_id jtf_task_references_b.object_id%type;
405:
406: BEGIN
407:

Line 404: l_object_id jtf_task_references_b.object_id%type;

400: FROM jtf_task_references_b
401: where task_reference_id = p_task_reference_id ;
402:
403: l_task_id jtf_task_references_b.task_id%type;
404: l_object_id jtf_task_references_b.object_id%type;
405:
406: BEGIN
407:
408: SAVEPOINT delete_task_reference_pvt;