[Home] [Help]
1: PACKAGE BODY CSL_CSP_REQ_LINES_ACC_PKG AS
2: /* $Header: cslrlacb.pls 120.0 2005/05/24 17:19:34 appldev noship $ */
3:
4: /*** Globals ***/
5: -- CSP_REQUIREMENT_HEADERS
6: g_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_CSP_REQ_LINES_ACC';
7: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
8: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSP_REQUIREMENT_LINES');
9: g_pk1_name CONSTANT VARCHAR2(30) := 'REQUIREMENT_LINE_ID';
30: RETURN BOOLEAN
31: IS
32: CURSOR c_req_resource (b_req_line_id NUMBER) IS
33: SELECT RH.resource_id
34: FROM CSP_REQUIREMENT_HEADERS RH
35: , CSP_REQUIREMENT_LINES RL
36: WHERE RH.REQUIREMENT_HEADER_ID = RL.REQUIREMENT_HEADER_ID
37: AND RL.REQUIREMENT_LINE_ID = b_req_line_id;
38:
38:
39: /* CURSOR c_req_task_ass( b_req_line_id NUMBER ) IS
40: SELECT jta.resource_id
41: FROM jtf.jtf_task_assignments jta
42: , csp_requirement_headers crh
43: , csp_requirement_lines crl
44: WHERE crh.task_assignment_id = jta.task_assignment_id
45: AND jta.assignee_role = 'ASSIGNEE'
46: AND crh.requirement_header_id = crl.requirement_header_id
121: , OH.HEADER_ID
122: , OL.LINE_ID
123: , RH.DESTINATION_ORGANIZATION_ID
124: , RL.INVENTORY_ITEM_ID
125: FROM CSP_REQUIREMENT_HEADERS RH
126: , CSP_REQUIREMENT_LINES RL
127: , OE_ORDER_LINES_ALL OL
128: , OE_ORDER_HEADERS_ALL OH
129: WHERE RH.REQUIREMENT_HEADER_ID = RL.REQUIREMENT_HEADER_ID
137: SELECT jta.resource_id
138: , oh.header_id
139: , ol.line_id
140: FROM jtf.jtf_task_assignments jta
141: , csp_requirement_headers crh
142: , csp_requirement_lines crl
143: , oe_order_headers_all oh
144: , oe_order_lines_all ol
145: WHERE crh.task_assignment_id = jta.task_assignment_id
258: , OH.HEADER_ID
259: , OL.LINE_ID
260: , RH.DESTINATION_ORGANIZATION_ID
261: , RL.INVENTORY_ITEM_ID
262: FROM CSP_REQUIREMENT_HEADERS RH
263: , CSP_REQUIREMENT_LINES RL
264: , OE_ORDER_LINES_ALL OL
265: , OE_ORDER_HEADERS_ALL OH
266: WHERE RH.REQUIREMENT_HEADER_ID = RL.REQUIREMENT_HEADER_ID
274: SELECT jta.resource_id
275: , oh.header_id
276: , ol.line_id
277: FROM jtf.jtf_task_assignments jta
278: , csp_requirement_headers crh
279: , csp_requirement_lines crl
280: , oe_order_headers_all oh
281: , oe_order_lines_all ol
282: WHERE crh.task_assignment_id = jta.task_assignment_id
393: CURSOR c_req_line_id (b_req_line_id NUMBER) IS
394: SELECT RH.resource_id
395: , OH.HEADER_ID
396: , OL.LINE_ID
397: FROM CSP_REQUIREMENT_HEADERS RH
398: , CSP_REQUIREMENT_LINES RL
399: , OE_ORDER_LINES_ALL OL
400: , OE_ORDER_HEADERS_ALL OH
401: WHERE RH.REQUIREMENT_HEADER_ID = RL.REQUIREMENT_HEADER_ID
660: )
661: IS
662: CURSOR c_req_resource (b_resource_id NUMBER) IS
663: SELECT RL.REQUIREMENT_LINE_ID
664: FROM CSP_REQUIREMENT_HEADERS RH
665: , CSP_REQUIREMENT_LINES RL
666: WHERE RH.REQUIREMENT_HEADER_ID = RL.REQUIREMENT_HEADER_ID
667: AND RH.RESOURCE_ID = b_resource_id;
668:
668:
669: /* CURSOR c_req_task_ass( b_resource_id NUMBER ) IS
670: SELECT crl.requirement_line_id
671: FROM jtf.jtf_task_assignments jta
672: , csp_requirement_headers crh
673: , csp_requirement_lines crl
674: WHERE crh.task_assignment_id = jta.task_assignment_id
675: AND jta.assignee_role = 'ASSIGNEE'
676: AND crh.requirement_header_id = crl.requirement_header_id
720: )
721: IS
722: CURSOR c_req_resource (b_resource_id NUMBER) IS
723: SELECT RL.REQUIREMENT_LINE_ID
724: FROM CSP_REQUIREMENT_HEADERS RH
725: , CSP_REQUIREMENT_LINES RL
726: WHERE RH.REQUIREMENT_HEADER_ID = RL.REQUIREMENT_HEADER_ID
727: AND RH.RESOURCE_ID = b_resource_id;
728:
728:
729: /* CURSOR c_req_task_ass( b_resource_id NUMBER ) IS
730: SELECT crl.requirement_line_id
731: FROM jtf.jtf_task_assignments jta
732: , csp_requirement_headers crh
733: , csp_requirement_lines crl
734: WHERE crh.task_assignment_id = jta.task_assignment_id
735: AND jta.assignee_role = 'ASSIGNEE'
736: AND crh.requirement_header_id = crl.requirement_header_id