APPS.CSM_CSP_REQ_LINES_EVENT_PKG dependencies on CSM_REQ_LINE_DETAILS_ACC

Line 305: SELECT ACCESS_ID,USER_ID,SOURCE_ID FROM CSM_REQ_LINE_DETAILS_ACC WHERE REQ_LINE_DETAIL_ID=p_rld;

301:
302: PROCEDURE REQ_LINE_DTL_IUD(p_rld IN NUMBER, p_DML_t IN VARCHAR2)
303: IS
304: CURSOR c_get_dtl IS
305: SELECT ACCESS_ID,USER_ID,SOURCE_ID FROM CSM_REQ_LINE_DETAILS_ACC WHERE REQ_LINE_DETAIL_ID=p_rld;
306:
307: CURSOR c_hdr_id(b_line_id NUMBER) IS
308: SELECT HEADER_ID FROM OE_ORDER_LINES_ALL WHERE LINE_ID=b_line_id;
309:

Line 341: INSERT INTO CSM_REQ_LINE_DETAILS_ACC(ACCESS_ID,REQ_LINE_DETAIL_ID,USER_ID,ITEM_ID,ORG_ID,SOURCE_ID,CREATION_DATE,LAST_UPDATE_DATE,CREATED_BY,LAST_UPDATED_BY)

337: FETCH c_get_dtl BULK COLLECT INTO l_tab_access_id,l_tab_user_id,l_tab_old_src_id;
338: CLOSE c_get_dtl;
339:
340: IF (l_tab_access_id.COUNT=0) AND p_dml_t <> 'D' THEN
341: INSERT INTO CSM_REQ_LINE_DETAILS_ACC(ACCESS_ID,REQ_LINE_DETAIL_ID,USER_ID,ITEM_ID,ORG_ID,SOURCE_ID,CREATION_DATE,LAST_UPDATE_DATE,CREATED_BY,LAST_UPDATED_BY)
342: select CSM_REQ_LINES_ACC_S.nextval,req_line_detail_id,user_id,b.inventory_item_id,d.destination_organization_id,b.source_id,sysdate,sysdate,1,1
343: from (select b.req_line_detail_id,a.user_id,c.inventory_item_id,b.requirement_line_id,b.source_id
344: from csm_req_lines_acc a, csp_req_line_details b ,
345: oe_order_lines_all c ,asg_user au

Line 361: and not exists(select 1 from CSM_REQ_LINE_DETAILS_ACC acc

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
363: and acc.user_id=b.user_id);
364:
365: IF (sql%rowcount=0) THEN

Line 371: FROM CSM_REQ_LINE_DETAILS_ACC WHERE req_line_detail_id=l_req_line_detail_id;

367: RETURN;
368: END IF;
369:
370: SELECT ACCESS_ID,USER_ID,ITEM_ID,ORG_ID BULK COLLECT INTO l_tab_access_id,l_tab_user_id,l_tab_item_id,l_tab_org_id
371: FROM CSM_REQ_LINE_DETAILS_ACC WHERE req_line_detail_id=l_req_line_detail_id;
372:
373: l_dummy := asg_download.mark_dirty(
374: P_PUB_ITEM => 'CSM_REQ_LINE_DETAILS'
375: , p_accessList => l_tab_access_id

Line 416: UPDATE CSM_REQ_LINE_DETAILS_ACC SET SOURCE_ID=l_src_id

412: END IF;
413:
414: l_upd_dml_t:='I';
415:
416: UPDATE CSM_REQ_LINE_DETAILS_ACC SET SOURCE_ID=l_src_id
417: WHERE req_line_detail_id=l_req_line_detail_id AND USER_ID=l_tab_user_id(I);
418: END IF;
419:
420: IF l_src='RES' THEN

Line 441: DELETE FROM CSM_REQ_LINE_DETAILS_ACC WHERE ACCESS_ID=l_tab_access_id(I);

437: END LOOP;
438:
439: IF p_DML_t='D' THEN
440: FORALL I IN 1.. l_tab_access_id.COUNT
441: DELETE FROM CSM_REQ_LINE_DETAILS_ACC WHERE ACCESS_ID=l_tab_access_id(I);
442: END IF;
443:
444: IF p_DML_t<>'D' AND l_found THEN
445: FOR I IN 1..l_tab_item_id.COUNT --delete will be handled by mtl sys item refresh conc prog