APPS.CSL_CSP_REQ_HEADERS_ACC_PKG dependencies on CSP_REQUIREMENT_HEADERS

Line 5: -- CSP_REQUIREMENT_HEADERS

1: PACKAGE BODY CSL_CSP_REQ_HEADERS_ACC_PKG AS
2: /* $Header: cslrhacb.pls 120.0 2005/05/25 11:06:42 appldev noship $ */
3:
4: /*** Globals ***/
5: -- CSP_REQUIREMENT_HEADERS
6: g_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_CSP_REQ_HEADERS_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_HEADERS');
9: g_pk1_name CONSTANT VARCHAR2(30) := 'REQUIREMENT_HEADER_ID';

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

4: /*** Globals ***/
5: -- CSP_REQUIREMENT_HEADERS
6: g_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_CSP_REQ_HEADERS_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_HEADERS');
9: g_pk1_name CONSTANT VARCHAR2(30) := 'REQUIREMENT_HEADER_ID';
10:
11: g_table_name CONSTANT VARCHAR2(30) := 'CSP_REQUIREMENT_HEADERS';
12: g_debug_level NUMBER; -- debug level

Line 11: g_table_name CONSTANT VARCHAR2(30) := 'CSP_REQUIREMENT_HEADERS';

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_HEADERS');
9: g_pk1_name CONSTANT VARCHAR2(30) := 'REQUIREMENT_HEADER_ID';
10:
11: g_table_name CONSTANT VARCHAR2(30) := 'CSP_REQUIREMENT_HEADERS';
12: g_debug_level NUMBER; -- debug level
13:
14: /*** Function that checks if requirement record(s) should be replicated. Returns TRUE if it should ***/
15: FUNCTION Replicate_Record

Line 23: , csp_requirement_headers crh

19: IS
20: /* CURSOR c_req_task_ass( b_req_header_id NUMBER ) IS
21: SELECT jta.resource_id
22: FROM jtf.jtf_task_assignments jta
23: , csp_requirement_headers crh
24: WHERE crh.task_assignment_id = jta.task_assignment_id
25: AND jta.assignee_role = 'ASSIGNEE'
26: AND crh.requirement_header_id = b_req_header_id;*/
27:

Line 30: FROM CSP_REQUIREMENT_HEADERS RH

26: AND crh.requirement_header_id = b_req_header_id;*/
27:
28: CURSOR c_req_resource( b_req_header_id NUMBER ) IS
29: SELECT RH.RESOURCE_ID
30: FROM CSP_REQUIREMENT_HEADERS RH
31: WHERE RH.REQUIREMENT_HEADER_ID = b_req_header_id;
32:
33: l_resource_id NUMBER;
34: BEGIN

Line 104: , csp_requirement_headers crh

100: IS
101: /*CURSOR c_req_task_ass( b_req_header_id NUMBER ) IS
102: SELECT jta.resource_id
103: FROM jtf.jtf_task_assignments jta
104: , csp_requirement_headers crh
105: WHERE crh.task_assignment_id = jta.task_assignment_id
106: AND jta.assignee_role = 'ASSIGNEE'
107: AND crh.requirement_header_id = b_req_header_id;*/
108:

Line 111: FROM CSP_REQUIREMENT_HEADERS RH

107: AND crh.requirement_header_id = b_req_header_id;*/
108:
109: CURSOR c_req_resource( b_req_header_id NUMBER ) IS
110: SELECT RH.RESOURCE_ID
111: FROM CSP_REQUIREMENT_HEADERS RH
112: WHERE RH.REQUIREMENT_HEADER_ID = b_req_header_id;
113:
114: l_resource_id NUMBER;
115: BEGIN

Line 179: , csp_requirement_headers crh

175: IS
176: /* CURSOR c_req_task_ass( b_req_header_id NUMBER ) IS
177: SELECT jta.resource_id
178: FROM jtf.jtf_task_assignments jta
179: , csp_requirement_headers crh
180: WHERE crh.task_assignment_id = jta.task_assignment_id
181: AND jta.assignee_role = 'ASSIGNEE'
182: AND crh.requirement_header_id = b_req_header_id;*/
183:

Line 186: FROM CSP_REQUIREMENT_HEADERS RH

182: AND crh.requirement_header_id = b_req_header_id;*/
183:
184: CURSOR c_req_resource( b_req_header_id NUMBER ) IS
185: SELECT RH.RESOURCE_ID
186: FROM CSP_REQUIREMENT_HEADERS RH
187: WHERE RH.REQUIREMENT_HEADER_ID = b_req_header_id;
188:
189: l_resource_id NUMBER;
190: BEGIN

Line 316: l_req_header_id := CSP_REQUIREMENT_HEADERS_PKG.user_hooks_rec.REQUIREMENT_HEADER_ID;

312: , 'Entering POST_INSERT hook'
313: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
314: END IF;
315:
316: l_req_header_id := CSP_REQUIREMENT_HEADERS_PKG.user_hooks_rec.REQUIREMENT_HEADER_ID;
317:
318: /*** Insert record if applicable ***/
319: IF Replicate_Record(l_req_header_id) THEN
320: Insert_ACC_Record(l_req_header_id);

Line 385: l_req_header_id := CSP_REQUIREMENT_HEADERS_PKG.user_hooks_rec.REQUIREMENT_HEADER_ID;

381: , 'Entering POST_UPDATE hook'
382: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
383: END IF;
384:
385: l_req_header_id := CSP_REQUIREMENT_HEADERS_PKG.user_hooks_rec.REQUIREMENT_HEADER_ID;
386:
387: IF Replicate_Record( l_req_header_id ) THEN
388: Update_ACC_Record(l_req_header_id);
389: END IF;

Line 447: FROM CSP_REQUIREMENT_HEADERS RH

443: )
444: IS
445: CURSOR c_req_header (b_resource_id NUMBER) IS
446: SELECT REQUIREMENT_HEADER_ID
447: FROM CSP_REQUIREMENT_HEADERS RH
448: WHERE RH.RESOURCE_ID = b_resource_id;
449:
450: /* CURSOR c_req_task_ass (b_resource_id NUMBER) IS
451: SELECT crh.requirement_header_id

Line 453: , csp_requirement_headers crh

449:
450: /* CURSOR c_req_task_ass (b_resource_id NUMBER) IS
451: SELECT crh.requirement_header_id
452: FROM jtf.jtf_task_assignments jta
453: , csp_requirement_headers crh
454: WHERE crh.task_assignment_id = jta.task_assignment_id
455: AND jta.assignee_role = 'ASSIGNEE'
456: AND jta.resource_id = b_resource_id; */
457:

Line 502: FROM CSP_REQUIREMENT_HEADERS RH

498: )
499: IS
500: CURSOR c_req_header (b_resource_id NUMBER) IS
501: SELECT REQUIREMENT_HEADER_ID
502: FROM CSP_REQUIREMENT_HEADERS RH
503: WHERE RH.RESOURCE_ID = b_resource_id;
504:
505: /* CURSOR c_req_task_ass (b_resource_id NUMBER) IS
506: SELECT crh.requirement_header_id

Line 508: , csp_requirement_headers crh

504:
505: /* CURSOR c_req_task_ass (b_resource_id NUMBER) IS
506: SELECT crh.requirement_header_id
507: FROM jtf.jtf_task_assignments jta
508: , csp_requirement_headers crh
509: WHERE crh.task_assignment_id = jta.task_assignment_id
510: AND jta.assignee_role = 'ASSIGNEE'
511: AND jta.resource_id = b_resource_id; */
512: