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.CSL_CSP_REQ_LINES_ACC_PKG dependencies on CSP_REQUIREMENT_LINES

Line 8: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSP_REQUIREMENT_LINES');

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';
10:
11: -- OE_ORDER_HEADERS_ALL
12: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'JTM_OE_ORDER_HEADERS_ALL_ACC';

Line 23: g_table_name CONSTANT VARCHAR2(30) := 'CSP_REQUIREMENT_LINES';

19: g_publication_item_name2 CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
20: JTM_HOOK_UTIL_PKG.t_publication_item_list('OE_ORDER_LINES_ALL');
21: g_pk1_name2 CONSTANT VARCHAR2(30) := 'LINE_ID';
22:
23: g_table_name CONSTANT VARCHAR2(30) := 'CSP_REQUIREMENT_LINES';
24: g_debug_level NUMBER; -- debug level
25:
26: /*** Function that checks if requirement record(s) should be replicated. Returns TRUE if it should ***/
27: FUNCTION Replicate_Record

Line 35: , CSP_REQUIREMENT_LINES RL

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:
39: /* CURSOR c_req_task_ass( b_req_line_id NUMBER ) IS

Line 43: , csp_requirement_lines crl

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
47: AND crl.requirement_line_id = b_req_line_id;*/

Line 126: , CSP_REQUIREMENT_LINES RL

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
130: AND RL.REQUIREMENT_LINE_ID = b_req_line_id

Line 142: , csp_requirement_lines crl

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
146: AND jta.assignee_role = 'ASSIGNEE'

Line 263: , CSP_REQUIREMENT_LINES RL

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
267: AND RL.REQUIREMENT_LINE_ID = b_req_line_id

Line 279: , csp_requirement_lines crl

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
283: AND jta.assignee_role = 'ASSIGNEE'

Line 398: , CSP_REQUIREMENT_LINES RL

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
402: AND RL.REQUIREMENT_LINE_ID = b_req_line_id

Line 428: , 'Could not find record associated with CSP_REQUIREMENT_LINES.REQUIREMENT_LINE_ID ' || p_req_line_id

424: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
425: jtm_message_log_pkg.Log_Msg
426: ( p_req_line_id
427: , g_table_name
428: , 'Could not find record associated with CSP_REQUIREMENT_LINES.REQUIREMENT_LINE_ID ' || p_req_line_id
429: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR);
430: END IF;
431: ELSE
432: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

Line 528: l_req_line_id := CSP_REQUIREMENT_LINES_PKG.user_hook_rec.REQUIREMENT_LINE_ID;

524: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
525: END IF;
526:
527: /*** get location record details from public API ***/
528: l_req_line_id := CSP_REQUIREMENT_LINES_PKG.user_hook_rec.REQUIREMENT_LINE_ID;
529:
530: /*** Insert record if applicable ***/
531: IF Replicate_Record(l_req_line_id) THEN
532: Insert_ACC_Record(l_req_line_id);

Line 600: l_req_line_id := CSP_REQUIREMENT_LINES_PKG.user_hook_rec.REQUIREMENT_LINE_ID;

596: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
597: END IF;
598:
599: /*** get location record details from public API ***/
600: l_req_line_id := CSP_REQUIREMENT_LINES_PKG.user_hook_rec.REQUIREMENT_LINE_ID;
601:
602: IF Replicate_Record( l_req_line_id ) THEN
603: Update_ACC_Record(l_req_line_id);
604: END IF;

Line 665: , CSP_REQUIREMENT_LINES RL

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:
669: /* CURSOR c_req_task_ass( b_resource_id NUMBER ) IS

Line 673: , csp_requirement_lines crl

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
677: AND jta.resource_id = b_resource_id;*/

Line 725: , CSP_REQUIREMENT_LINES RL

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:
729: /* CURSOR c_req_task_ass( b_resource_id NUMBER ) IS

Line 733: , csp_requirement_lines crl

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
737: AND jta.resource_id = b_resource_id;*/