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.CSM_TASK_ASSIGNMENT_EVENT_PKG dependencies on JTF_TASK_ASSIGNMENTS

Line 6: g_table_name CONSTANT VARCHAR2(30) := 'JTF_TASK_ASSIGNMENTS';

2: /* $Header: csmetab.pls 120.8 2006/09/15 13:00:29 trajasek noship $ */
3:
4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_TASK_ASSIGNMENTS_ACC';
6: g_table_name CONSTANT VARCHAR2(30) := 'JTF_TASK_ASSIGNMENTS';
7: g_acc_seq_name CONSTANT VARCHAR2(30) := 'CSM_TASK_ASSIGNMENTS_ACC_S' ;
8: g_pk1_name CONSTANT VARCHAR2(30) := 'TASK_ASSIGNMENT_ID';
9: g_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
10: CSM_ACC_PKG.t_publication_item_list('CSM_TASK_ASSIGNMENTS');

Line 19: l_task_assignment_id jtf_task_assignments.task_assignment_id%TYPE;

15: **/
16: PROCEDURE PURGE_TASK_ASSIGNMENTS_CONC(p_status OUT NOCOPY VARCHAR2, p_message OUT NOCOPY VARCHAR2)
17: IS
18: PRAGMA AUTONOMOUS_TRANSACTION;
19: l_task_assignment_id jtf_task_assignments.task_assignment_id%TYPE;
20: l_task_id jtf_task_assignments.task_id%TYPE;
21: l_resource_id jtf_task_assignments.resource_id%TYPE;
22: l_user_id number;
23: l_dummy number;

Line 20: l_task_id jtf_task_assignments.task_id%TYPE;

16: PROCEDURE PURGE_TASK_ASSIGNMENTS_CONC(p_status OUT NOCOPY VARCHAR2, p_message OUT NOCOPY VARCHAR2)
17: IS
18: PRAGMA AUTONOMOUS_TRANSACTION;
19: l_task_assignment_id jtf_task_assignments.task_assignment_id%TYPE;
20: l_task_id jtf_task_assignments.task_id%TYPE;
21: l_resource_id jtf_task_assignments.resource_id%TYPE;
22: l_user_id number;
23: l_dummy number;
24: l_last_run_date date;

Line 21: l_resource_id jtf_task_assignments.resource_id%TYPE;

17: IS
18: PRAGMA AUTONOMOUS_TRANSACTION;
19: l_task_assignment_id jtf_task_assignments.task_assignment_id%TYPE;
20: l_task_id jtf_task_assignments.task_id%TYPE;
21: l_resource_id jtf_task_assignments.resource_id%TYPE;
22: l_user_id number;
23: l_dummy number;
24: l_last_run_date date;
25:

Line 38: jtf_task_assignments jta,

34: acc.task_assignment_id,
35: jt.task_id,
36: jt.source_object_type_code
37: FROM csm_task_assignments_acc acc,
38: jtf_task_assignments jta,
39: jtf_tasks_b jt,
40: jtf_task_statuses_b jts,
41: jtf_task_statuses_b jts_jta
42: WHERE acc.task_assignment_id = jta.task_assignment_id

Line 158: CURSOR l_debrief_header_csr(p_task_assg_id jtf_task_assignments.task_assignment_id%TYPE)

154: l_error_msg VARCHAR2(4000);
155: l_return_status VARCHAR2(2000);
156:
157: -- cursor to get all debrief header id
158: CURSOR l_debrief_header_csr(p_task_assg_id jtf_task_assignments.task_assignment_id%TYPE)
159: IS
160: SELECT dh.debrief_header_id
161: FROM csf_debrief_headers dh
162: WHERE dh.task_assignment_id =p_task_assg_id

Line 202: CURSOR l_debrief_lines_csr(p_task_assg_id jtf_task_assignments.task_assignment_id%TYPE)

198: l_error_msg VARCHAR2(4000);
199: l_return_status VARCHAR2(2000);
200:
201: -- cursor to get all debrief line id
202: CURSOR l_debrief_lines_csr(p_task_assg_id jtf_task_assignments.task_assignment_id%TYPE)
203: IS
204: SELECT dl.debrief_line_id,
205: dh.debrief_header_id
206: FROM csf_debrief_lines dl,

Line 249: CURSOR l_req_headers_csr(p_task_assg_id IN jtf_task_assignments.task_assignment_id%TYPE,

245: l_error_msg VARCHAR2(4000);
246: l_return_status VARCHAR2(2000);
247:
248: -- cursor to get all requirement headers for the task_id
249: CURSOR l_req_headers_csr(p_task_assg_id IN jtf_task_assignments.task_assignment_id%TYPE,
250: p_user_id IN NUMBER)
251: IS
252: SELECT hdr.requirement_header_id,
253: jta.resource_id

Line 254: FROM jtf_task_assignments jta,

250: p_user_id IN NUMBER)
251: IS
252: SELECT hdr.requirement_header_id,
253: jta.resource_id
254: FROM jtf_task_assignments jta,
255: csp_requirement_headers hdr
256: WHERE jta.task_assignment_id = p_task_assg_id
257: AND hdr.task_id = jta.task_id
258: AND NOT EXISTS

Line 299: CURSOR l_req_lines_csr(p_task_assg_id IN jtf_task_assignments.task_assignment_id%TYPE,

295: l_error_msg VARCHAR2(4000);
296: l_return_status VARCHAR2(2000);
297:
298: -- cursor to get all requirement lines for the task_id
299: CURSOR l_req_lines_csr(p_task_assg_id IN jtf_task_assignments.task_assignment_id%TYPE,
300: p_user_id IN NUMBER)
301: IS
302: SELECT line.requirement_line_id,
303: line.requirement_header_id,

Line 305: FROM jtf_task_assignments jta,

301: IS
302: SELECT line.requirement_line_id,
303: line.requirement_header_id,
304: jta.resource_id
305: FROM jtf_task_assignments jta,
306: csp_requirement_headers hdr,
307: csp_requirement_lines line
308: WHERE jta.task_assignment_id = p_task_assg_id
309: AND hdr.task_id = jta.task_id

Line 476: FROM JTF_TASK_ASSIGNMENTS jta,

472: csi.customer_product_id,
473: hz_ps.location_id,
474: jt.source_object_type_code,
475: csi.incident_location_type
476: FROM JTF_TASK_ASSIGNMENTS jta,
477: asg_user au,
478: asg_user_pub_resps aupr,
479: jtf_tasks_b jt,
480: cs_incidents_all_b csi,

Line 507: FROM JTF_TASK_ASSIGNMENTS jta,

503: csi.customer_product_id,
504: lc.location_id,
505: jt.source_object_type_code,
506: csi.incident_location_type
507: FROM JTF_TASK_ASSIGNMENTS jta,
508: asg_user au,
509: asg_user_pub_resps aupr,
510: jtf_tasks_b jt,
511: cs_incidents_all_b csi,

Line 538: FROM JTF_TASK_ASSIGNMENTS jta,

534: to_number(NULL),
535: to_number(NULL),
536: jt.source_object_type_code,
537: to_char(NULL)
538: FROM JTF_TASK_ASSIGNMENTS jta,
539: asg_user au,
540: asg_user_pub_resps aupr,
541: jtf_tasks_b jt
542: WHERE jta.task_assignment_id = p_taskassgid

Line 753: FROM JTF_TASK_ASSIGNMENTS jta,

749: csi.customer_product_id,
750: hz_ps.location_id,
751: jt.source_object_type_code,
752: csi.incident_location_type
753: FROM JTF_TASK_ASSIGNMENTS jta,
754: jtf_tasks_b jt,
755: cs_incidents_all_b csi,
756: hz_party_sites hz_ps
757: WHERE jta.task_assignment_id = p_taskassgid

Line 778: FROM JTF_TASK_ASSIGNMENTS jta,

774: csi.customer_product_id,
775: lc.location_id,
776: jt.source_object_type_code,
777: csi.incident_location_type
778: FROM JTF_TASK_ASSIGNMENTS jta,
779: jtf_tasks_b jt,
780: cs_incidents_all_b csi,
781: hz_locations lc
782: WHERE jta.task_assignment_id = p_taskassgid

Line 906: CURSOR l_task_assg_purge_csr(p_task_assignment_id jtf_task_assignments.task_assignment_id%TYPE)

902: l_error_msg VARCHAR2(4000);
903: l_return_status VARCHAR2(2000);
904: l_organization_id NUMBER;
905:
906: CURSOR l_task_assg_purge_csr(p_task_assignment_id jtf_task_assignments.task_assignment_id%TYPE)
907: IS
908: --Bug 5220635
909: SELECT /*+ INDEX (acc CSM_TASK_ASSIGNMENTS_ACC_U1)*/ au.user_id,
910: au.resource_id,

Line 924: jtf_task_assignments jta,

920: hz_ps.location_id,
921: jt.source_object_type_code,
922: csi.incident_location_type
923: FROM csm_task_assignments_acc acc,
924: jtf_task_assignments jta,
925: asg_user au,
926: asg_user_pub_resps aupr,
927: jtf_tasks_b jt,
928: cs_incidents_all_b csi,

Line 956: jtf_task_assignments jta,

952: lc.location_id,
953: jt.source_object_type_code,
954: csi.incident_location_type
955: FROM csm_task_assignments_acc acc,
956: jtf_task_assignments jta,
957: asg_user au,
958: asg_user_pub_resps aupr,
959: jtf_tasks_b jt,
960: cs_incidents_all_b csi,

Line 988: JTF_TASK_ASSIGNMENTS jta,

984: TO_NUMBER(NULL),
985: jt.source_object_type_code,
986: TO_CHAR(NULL)
987: FROM csm_task_assignments_acc acc,
988: JTF_TASK_ASSIGNMENTS jta,
989: asg_user au,
990: asg_user_pub_resps aupr,
991: jtf_tasks_b jt
992: WHERE acc.task_assignment_id = p_task_assignment_id

Line 1176: CURSOR l_debrief_header_csr(p_task_assg_id jtf_task_assignments.task_assignment_id%TYPE,

1172: l_error_msg VARCHAR2(4000);
1173: l_return_status VARCHAR2(2000);
1174:
1175: -- cursor to get all debrief header id
1176: CURSOR l_debrief_header_csr(p_task_assg_id jtf_task_assignments.task_assignment_id%TYPE,
1177: p_user_id fnd_user.user_id%TYPE)
1178: IS
1179: SELECT hdr.debrief_header_id
1180: FROM csm_debrief_headers_acc acc,

Line 1220: CURSOR l_debrief_lines_csr(p_task_assg_id jtf_task_assignments.task_assignment_id%TYPE,

1216: l_error_msg VARCHAR2(4000);
1217: l_return_status VARCHAR2(2000);
1218:
1219: -- cursor to get all debrief line id
1220: CURSOR l_debrief_lines_csr(p_task_assg_id jtf_task_assignments.task_assignment_id%TYPE,
1221: p_user_id fnd_user.user_id%TYPE)
1222: IS
1223: SELECT dl.debrief_line_id,
1224: dl.debrief_header_id

Line 1268: CURSOR l_req_headers_csr(p_task_assg_id IN jtf_task_assignments.task_assignment_id%TYPE,

1264: l_error_msg VARCHAR2(4000);
1265: l_return_status VARCHAR2(2000);
1266:
1267: -- cursor to get all requirement headers for the task_id
1268: CURSOR l_req_headers_csr(p_task_assg_id IN jtf_task_assignments.task_assignment_id%TYPE,
1269: p_user_id IN NUMBER)
1270: IS
1271: SELECT hdr.requirement_header_id,
1272: jta.resource_id

Line 1273: FROM jtf_task_assignments jta,

1269: p_user_id IN NUMBER)
1270: IS
1271: SELECT hdr.requirement_header_id,
1272: jta.resource_id
1273: FROM jtf_task_assignments jta,
1274: csp_requirement_headers hdr
1275: WHERE jta.task_assignment_id = p_task_assg_id
1276: AND hdr.task_id = jta.task_id
1277: AND EXISTS

Line 1319: CURSOR l_req_lines_csr(p_task_assg_id IN jtf_task_assignments.task_assignment_id%TYPE,

1315: l_return_status VARCHAR2(2000);
1316:
1317: -- cursor to get all requirement lines for the task_id
1318:
1319: CURSOR l_req_lines_csr(p_task_assg_id IN jtf_task_assignments.task_assignment_id%TYPE,
1320: p_user_id IN NUMBER)
1321: IS
1322: SELECT line.requirement_line_id,
1323: line.requirement_header_id,

Line 1325: FROM jtf_task_assignments jta,

1321: IS
1322: SELECT line.requirement_line_id,
1323: line.requirement_header_id,
1324: acc.user_id
1325: FROM jtf_task_assignments jta,
1326: csp_requirement_headers hdr,
1327: csp_requirement_lines line,
1328: csm_req_lines_acc acc
1329: WHERE jta.task_assignment_id = p_task_assg_id

Line 1447: CURSOR l_TaskAssgHistPurge_csr (p_task_assignment_id jtf_task_assignments.task_assignment_id%TYPE)

1443: l_return_status VARCHAR2(2000);
1444: l_organization_id NUMBER;
1445: l_flowtype VARCHAR2(20);
1446:
1447: CURSOR l_TaskAssgHistPurge_csr (p_task_assignment_id jtf_task_assignments.task_assignment_id%TYPE)
1448: IS
1449: --Bug 5220635
1450: SELECT jta.resource_id,
1451: jta.task_id,

Line 1464: FROM JTF_TASK_ASSIGNMENTS jta,

1460: csi.customer_product_id,
1461: hz_ps.location_id,
1462: jt.source_object_type_code,
1463: csi.incident_location_type
1464: FROM JTF_TASK_ASSIGNMENTS jta,
1465: jtf_tasks_b jt,
1466: cs_incidents_all_b csi,
1467: hz_party_sites hz_ps
1468: WHERE jta.task_assignment_id = p_task_assignment_id

Line 1489: FROM JTF_TASK_ASSIGNMENTS jta,

1485: csi.customer_product_id,
1486: lc.location_id,
1487: jt.source_object_type_code,
1488: csi.incident_location_type
1489: FROM JTF_TASK_ASSIGNMENTS jta,
1490: jtf_tasks_b jt,
1491: cs_incidents_all_b csi,
1492: hz_locations lc
1493: WHERE jta.task_assignment_id = p_task_assignment_id