APPS.CSL_LOBS_ACC_PKG dependencies on FND_USER

Line 17: l_user_id fnd_user.user_id%TYPE;

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;
21: l_null_pkvalueslist asg_download.pk_list;

Line 54: CURSOR l_rs_resource_extns_csr (p_user_id fnd_user.user_id%type) IS

50: AND fnddoccat_tl.category_id = fnddoc.category_id
51: AND fnddoccat_tl.language = asg_user.language
52: AND fnddoccat_tl.user_name = 'Signature';
53:
54: CURSOR l_rs_resource_extns_csr (p_user_id fnd_user.user_id%type) IS
55: SELECT resource_id FROM jtf_rs_resource_extns WHERE user_id = p_user_id;
56:
57: BEGIN
58:

Line 128: l_user_id fnd_user.user_id%TYPE;

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;
132: l_null_pkvalueslist asg_download.pk_list;

Line 164: CURSOR l_rs_resource_extns_csr (p_user_id fnd_user.user_id%type) IS

160: AND fnddoccat_tl.category_id = fnddoc.category_id
161: AND fnddoccat_tl.language = asg_user.language
162: AND fnddoccat_tl.user_name = 'Signature';
163:
164: CURSOR l_rs_resource_extns_csr (p_user_id fnd_user.user_id%type) IS
165: SELECT resource_id FROM jtf_rs_resource_extns WHERE user_id = p_user_id;
166:
167: BEGIN
168: