[Home] [Help]
11: -- Person Date Comments
12: -- --------- ------ ------------------------------------------
13: -- Enter procedure, function bodies as shown below
14:
15: g_table_name1 CONSTANT VARCHAR2(30) := 'CSP_REQUIREMENT_LINES';
16: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_REQ_LINES_ACC';
17: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_REQ_LINES_ACC_S';
18: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
19: CSM_ACC_PKG.t_publication_item_list('CSM_REQ_LINES');
312: l_dummy boolean;
313: l_src VARCHAR2(30);
314: l_src_id NUMBER;
315: l_req_line_detail_id csp_req_line_details.req_line_detail_id%TYPE :=p_rld;
316: l_req_line_id csp_requirement_lines.requirement_line_id%TYPE;
317: l_found BOOLEAN:=false;
318: l_access_id NUMBER;
319: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
320: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
354: and b.source_type= 'RES' and b.source_id=c.reservation_id
355: and b.req_line_detail_id=l_req_line_detail_id
356: and au.user_id=a.user_id ) b,
357: csp_requirement_headers d ,
358: csp_requirement_lines e
359: where e.requirement_line_id=b.requirement_line_id
360: and d.requirement_header_id=e.requirement_header_id
361: and not exists(select 1 from CSM_REQ_LINE_DETAILS_ACC acc
362: where acc.req_line_detail_id=b.req_line_detail_id