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.12020000.2 2013/04/09 11:00:02 saradhak ship $ */
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: FROM jtf_task_assignments jta,

Line 303: FROM jtf_task_assignments jta,

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: FROM jtf_task_assignments jta,
304: csp_requirement_headers hdr,
305: csp_requirement_lines line,
306: asg_user au
307: WHERE jta.task_assignment_id = p_task_assg_id

Line 481: FROM JTF_TASK_ASSIGNMENTS jta,

477: jt.source_object_type_code,
478: csi.incident_location_type,
479: jt.address_id,
480: csi.org_id
481: FROM JTF_TASK_ASSIGNMENTS jta,
482: asg_user au,
483: asg_user_pub_resps aupr,
484: jtf_tasks_b jt,
485: cs_incidents_all_b csi,

Line 514: FROM JTF_TASK_ASSIGNMENTS jta,

510: jt.source_object_type_code,
511: csi.incident_location_type,
512: jt.address_id,
513: csi.org_id
514: FROM JTF_TASK_ASSIGNMENTS jta,
515: asg_user au,
516: asg_user_pub_resps aupr,
517: jtf_tasks_b jt,
518: cs_incidents_all_b csi,

Line 547: FROM JTF_TASK_ASSIGNMENTS jta,

543: jt.source_object_type_code,
544: to_char(NULL),
545: jt.address_id,
546: to_number(NULL)
547: FROM JTF_TASK_ASSIGNMENTS jta,
548: asg_user au,
549: asg_user_pub_resps aupr,
550: jtf_tasks_b jt
551: WHERE jta.task_assignment_id = p_taskassgid

Line 795: FROM JTF_TASK_ASSIGNMENTS jta,

791: csi.customer_product_id,
792: hz_ps.location_id,
793: jt.source_object_type_code,
794: csi.incident_location_type
795: FROM JTF_TASK_ASSIGNMENTS jta,
796: jtf_tasks_b jt,
797: cs_incidents_all_b csi,
798: hz_party_sites hz_ps
799: WHERE jta.task_assignment_id = p_taskassgid

Line 820: FROM JTF_TASK_ASSIGNMENTS jta,

816: csi.customer_product_id,
817: lc.location_id,
818: jt.source_object_type_code,
819: csi.incident_location_type
820: FROM JTF_TASK_ASSIGNMENTS jta,
821: jtf_tasks_b jt,
822: cs_incidents_all_b csi,
823: hz_locations lc
824: WHERE jta.task_assignment_id = p_taskassgid

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

944: l_error_msg VARCHAR2(4000);
945: l_return_status VARCHAR2(2000);
946: l_organization_id NUMBER;
947:
948: CURSOR l_task_assg_purge_csr(p_task_assignment_id jtf_task_assignments.task_assignment_id%TYPE)
949: IS
950: --Bug 5220635
951: SELECT /*+ INDEX (acc CSM_TASK_ASSIGNMENTS_ACC_U1)*/ au.user_id,
952: au.resource_id,

Line 968: jtf_task_assignments jta,

964: csi.incident_location_type,
965: jt.ADDRESS_ID,
966: csi.org_id
967: FROM csm_task_assignments_acc acc,
968: jtf_task_assignments jta,
969: asg_user au,
970: asg_user_pub_resps aupr,
971: jtf_tasks_b jt,
972: cs_incidents_all_b csi,

Line 1002: jtf_task_assignments jta,

998: csi.incident_location_type,
999: jt.ADDRESS_ID,
1000: csi.org_id
1001: FROM csm_task_assignments_acc acc,
1002: jtf_task_assignments jta,
1003: asg_user au,
1004: asg_user_pub_resps aupr,
1005: jtf_tasks_b jt,
1006: cs_incidents_all_b csi,

Line 1036: JTF_TASK_ASSIGNMENTS jta,

1032: TO_CHAR(NULL),
1033: jt.ADDRESS_ID,
1034: TO_NUMBER(NULL)
1035: FROM csm_task_assignments_acc acc,
1036: JTF_TASK_ASSIGNMENTS jta,
1037: asg_user au,
1038: asg_user_pub_resps aupr,
1039: jtf_tasks_b jt
1040: WHERE acc.task_assignment_id = p_task_assignment_id

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

1240: l_error_msg VARCHAR2(4000);
1241: l_return_status VARCHAR2(2000);
1242:
1243: -- cursor to get all debrief header id
1244: CURSOR l_debrief_header_csr(p_task_assg_id jtf_task_assignments.task_assignment_id%TYPE,
1245: p_user_id fnd_user.user_id%TYPE)
1246: IS
1247: SELECT hdr.debrief_header_id
1248: FROM csm_debrief_headers_acc acc,

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

1284: l_error_msg VARCHAR2(4000);
1285: l_return_status VARCHAR2(2000);
1286:
1287: -- cursor to get all debrief line id
1288: CURSOR l_debrief_lines_csr(p_task_assg_id jtf_task_assignments.task_assignment_id%TYPE,
1289: p_user_id fnd_user.user_id%TYPE)
1290: IS
1291: SELECT dl.debrief_line_id,
1292: dl.debrief_header_id

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

1332: l_error_msg VARCHAR2(4000);
1333: l_return_status VARCHAR2(2000);
1334:
1335: -- cursor to get all requirement headers for the task_id
1336: CURSOR l_req_headers_csr(p_task_assg_id IN jtf_task_assignments.task_assignment_id%TYPE,
1337: p_user_id IN NUMBER)
1338: IS
1339: SELECT hdr.requirement_header_id,
1340: jta.resource_id

Line 1341: FROM jtf_task_assignments jta,

1337: p_user_id IN NUMBER)
1338: IS
1339: SELECT hdr.requirement_header_id,
1340: jta.resource_id
1341: FROM jtf_task_assignments jta,
1342: csp_requirement_headers hdr
1343: WHERE jta.task_assignment_id = p_task_assg_id
1344: AND hdr.task_id = jta.task_id
1345: AND EXISTS

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

1383: l_return_status VARCHAR2(2000);
1384:
1385: -- cursor to get all requirement lines for the task_id
1386:
1387: CURSOR l_req_lines_csr(p_task_assg_id IN jtf_task_assignments.task_assignment_id%TYPE,
1388: p_user_id IN NUMBER)
1389: IS
1390: SELECT line.requirement_line_id,
1391: line.requirement_header_id,

Line 1393: FROM jtf_task_assignments jta,

1389: IS
1390: SELECT line.requirement_line_id,
1391: line.requirement_header_id,
1392: acc.user_id
1393: FROM jtf_task_assignments jta,
1394: csp_requirement_headers hdr,
1395: csp_requirement_lines line,
1396: csm_req_lines_acc acc
1397: WHERE jta.task_assignment_id = p_task_assg_id

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

1515: l_return_status VARCHAR2(2000);
1516: l_organization_id NUMBER;
1517: l_flowtype VARCHAR2(20);
1518:
1519: CURSOR l_TaskAssgHistPurge_csr (p_task_assignment_id jtf_task_assignments.task_assignment_id%TYPE)
1520: IS
1521: --Bug 5220635
1522: SELECT jta.resource_id,
1523: jta.task_id,

Line 1536: FROM JTF_TASK_ASSIGNMENTS jta,

1532: csi.customer_product_id,
1533: hz_ps.location_id,
1534: jt.source_object_type_code,
1535: csi.incident_location_type
1536: FROM JTF_TASK_ASSIGNMENTS jta,
1537: jtf_tasks_b jt,
1538: cs_incidents_all_b csi,
1539: hz_party_sites hz_ps
1540: WHERE jta.task_assignment_id = p_task_assignment_id

Line 1561: FROM JTF_TASK_ASSIGNMENTS jta,

1557: csi.customer_product_id,
1558: lc.location_id,
1559: jt.source_object_type_code,
1560: csi.incident_location_type
1561: FROM JTF_TASK_ASSIGNMENTS jta,
1562: jtf_tasks_b jt,
1563: cs_incidents_all_b csi,
1564: hz_locations lc
1565: WHERE jta.task_assignment_id = p_task_assignment_id