APPS.CSP_SCH_INT_PVT dependencies on CSP_REQUIREMENT_LINES_S1

Line 626: select CSP_REQUIREMENT_LINES_S1.nextval INTO l_req_line_details_tbl(l_req_line_details_tbl.count).req_line_detail_id from dual;

622: , p_data => x_msg_data);
623: return;
624: END IF;
625: l_req_line_details_tbl.extend;
626: select CSP_REQUIREMENT_LINES_S1.nextval INTO l_req_line_details_tbl(l_req_line_details_tbl.count).req_line_detail_id from dual;
627: l_req_line_details_tbl(l_req_line_details_tbl.count).requirement_line_id := l_eligible_resources_list(I).line_id ;
628: l_req_line_details_tbl(l_req_line_details_tbl.count).source_type := 'RES' ;
629: l_req_line_details_tbl(l_req_line_details_tbl.count).source_id := l_reservation_id ;
630: ELSE

Line 647: select CSP_REQUIREMENT_LINES_S1.nextval INTO l_req_line_details_tbl(l_req_line_details_tbl.count).req_line_detail_id from dual;

643: l_parts_lines(rec_count).reservation_id := l_reservation_id;
644: l_parts_lines(rec_count).requirement_line_id := l_requirements_line_id;
645: rec_count := rec_count + 1;
646: l_req_line_details_tbl.extend;
647: select CSP_REQUIREMENT_LINES_S1.nextval INTO l_req_line_details_tbl(l_req_line_details_tbl.count).req_line_detail_id from dual;
648: l_req_line_details_tbl(l_req_line_details_tbl.count).requirement_line_id := l_eligible_resources_list(I).line_id ;
649: l_req_line_details_tbl(l_req_line_details_tbl.count).source_type := 'IO' ;
650: END IF;
651: END LOOP;