APPS.CSP_SCH_INT_PVT dependencies on CSP_REQUIREMENT_LINES_S1

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

2083: l_requirement_header.DESTINATION_ORGANIZATION_ID := l_eligible_resources_list(I).source_org;
2084: l_requirement_header.DESTINATION_SUBINVENTORY := l_eligible_resources_list(I).sub_inventory;
2085:
2086: l_req_line_details_tbl.extend;
2087: select CSP_REQUIREMENT_LINES_S1.nextval INTO l_req_line_details_tbl(l_req_line_details_tbl.count).req_line_detail_id from dual;
2088: l_req_line_details_tbl(l_req_line_details_tbl.count).requirement_line_id := l_eligible_resources_list(I).line_id ;
2089: l_req_line_details_tbl(l_req_line_details_tbl.count).source_type := 'RES' ;
2090: l_req_line_details_tbl(l_req_line_details_tbl.count).source_id := l_reservation_id ;
2091: ELSE

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

2104: l_parts_lines(rec_count).reservation_id := l_reservation_id;
2105: l_parts_lines(rec_count).requirement_line_id := l_requirements_line_id;
2106: rec_count := rec_count + 1;
2107: l_req_line_details_tbl.extend;
2108: select CSP_REQUIREMENT_LINES_S1.nextval INTO l_req_line_details_tbl(l_req_line_details_tbl.count).req_line_detail_id from dual;
2109: l_req_line_details_tbl(l_req_line_details_tbl.count).requirement_line_id := l_eligible_resources_list(I).line_id ;
2110: l_req_line_details_tbl(l_req_line_details_tbl.count).source_type := 'IO' ;
2111: END IF;
2112: END LOOP;