APPS.CSL_LOBS_ACC_PKG dependencies on JTF_TASK_ASSIGNMENTS

Line 15: l_task_assignment_id jtf_task_assignments.task_assignment_id%type;

11:
12: PROCEDURE INSERT_ACC_RECORD ( p_task_assignment_id IN NUMBER,
13: p_resource_id IN NUMBER)
14: IS
15: l_task_assignment_id jtf_task_assignments.task_assignment_id%type;
16: l_resource_id jtf_task_assignments.resource_id%type;
17: l_user_id fnd_user.user_id%TYPE;
18: l_item_key varchar2(50);
19: l_seq_val number(15);

Line 16: l_resource_id jtf_task_assignments.resource_id%type;

12: PROCEDURE INSERT_ACC_RECORD ( p_task_assignment_id IN NUMBER,
13: p_resource_id IN NUMBER)
14: IS
15: l_task_assignment_id jtf_task_assignments.task_assignment_id%type;
16: l_resource_id jtf_task_assignments.resource_id%type;
17: l_user_id fnd_user.user_id%TYPE;
18: l_item_key varchar2(50);
19: l_seq_val number(15);
20: l_pkvalueslist asg_download.pk_list;

Line 35: FROM jtf_task_assignments jtf, csf_debrief_headers dbfhdr,

31:
32: CURSOR l_signature_csr(p_task_assignment_id IN number,
33: p_resource_id IN number) IS
34: SELECT distinct lob.file_id, jtrs.user_id
35: FROM jtf_task_assignments jtf, csf_debrief_headers dbfhdr,
36: jtf_rs_resource_extns jtrs, asg_user, fnd_attached_documents fndatt,
37: fnd_documents_tl fnddoc_tl, fnd_documents fnddoc, fnd_lobs lob,
38: fnd_document_categories_tl fnddoccat_tl
39: WHERE jtf.task_assignment_id = p_task_assignment_id

Line 126: l_task_assignment_id jtf_task_assignments.task_assignment_id%type;

122: PROCEDURE DELETE_ACC_RECORD ( p_task_assignment_id IN NUMBER,
123: p_resource_id IN NUMBER)
124:
125: IS
126: l_task_assignment_id jtf_task_assignments.task_assignment_id%type;
127: l_resource_id jtf_task_assignments.resource_id%type;
128: l_user_id fnd_user.user_id%TYPE;
129: l_item_key varchar2(50);
130: l_seq_val number(15);

Line 127: l_resource_id jtf_task_assignments.resource_id%type;

123: p_resource_id IN NUMBER)
124:
125: IS
126: l_task_assignment_id jtf_task_assignments.task_assignment_id%type;
127: l_resource_id jtf_task_assignments.resource_id%type;
128: l_user_id fnd_user.user_id%TYPE;
129: l_item_key varchar2(50);
130: l_seq_val number(15);
131: l_pkvalueslist asg_download.pk_list;