APPS.CSM_TASK_ASSIGNMENT_EVENT_PKG dependencies on CSP_REQ_LINE_DETAILS

Line 328: FOR rec IN (SELECT req_line_detail_id from csp_req_line_details WHERE requirement_line_id=r_req_lines_rec.requirement_line_id)

324: FOR r_req_lines_rec IN l_req_lines_csr(p_task_assignment_id, p_user_id) LOOP
325: -- insert requirement lines
326: csm_csp_req_lines_event_pkg.csp_req_lines_mdirty_i(p_requirement_line_id=>r_req_lines_rec.requirement_line_id,
327: p_user_id=>p_user_id);
328: FOR rec IN (SELECT req_line_detail_id from csp_req_line_details WHERE requirement_line_id=r_req_lines_rec.requirement_line_id)
329: LOOP
330: CSM_CSP_REQ_LINES_EVENT_PKG.REQ_LINE_DTL_IUD(rec.req_line_detail_id,'I');
331: END LOOP;
332: END LOOP;

Line 1413: FOR rec IN (SELECT req_line_detail_id from csp_req_line_details WHERE requirement_line_id=r_req_lines_rec.requirement_line_id)

1409: -- delete requirement lines
1410: csm_csp_req_lines_event_pkg.csp_req_lines_mdirty_d(p_requirement_line_id=>r_req_lines_rec.requirement_line_id,
1411: p_user_id=>p_user_id);
1412:
1413: FOR rec IN (SELECT req_line_detail_id from csp_req_line_details WHERE requirement_line_id=r_req_lines_rec.requirement_line_id)
1414: LOOP
1415: CSM_CSP_REQ_LINES_EVENT_PKG.REQ_LINE_DTL_IUD(rec.req_line_detail_id,'D');
1416: END LOOP;
1417: END LOOP;