APPS.CSP_REPAIR_PO_GRP dependencies on CSP_REPAIR_PO_LINES

Line 186: /* This is for Insert the Reservation_id into CSP_REPAIR_PO_LINES table

182: IF x_reservation_id = 0 OR l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
183: RAISE EXCP_USER_DEFINED;
184: Elsif l_return_status = FND_API.G_RET_STS_SUCCESS THEN
185:
186: /* This is for Insert the Reservation_id into CSP_REPAIR_PO_LINES table
187: all the reservation made for defective parts
188: */
189:
190: l_out_reservation_rec.need_by_date := l_reservation_rec.need_by_date;

Line 689: /* Insert into CSP_REPAIR_PO_LINES table all the reservation made for defective parts */

685: END LOOP;
686:
687: --COMMIT;
688:
689: /* Insert into CSP_REPAIR_PO_LINES table all the reservation made for defective parts */
690:
691: FOR I IN 1..l_out_reservation_tbl.COUNT
692: LOOP
693: l_out_reservation_rec := l_out_reservation_tbl(I);

Line 695: select csp_repair_po_lines_s1.nextval

691: FOR I IN 1..l_out_reservation_tbl.COUNT
692: LOOP
693: l_out_reservation_rec := l_out_reservation_tbl(I);
694:
695: select csp_repair_po_lines_s1.nextval
696: into l_repair_po_line_id
697: from dual;
698:
699: INSERT INTO CSP_REPAIR_PO_LINES

Line 699: INSERT INTO CSP_REPAIR_PO_LINES

695: select csp_repair_po_lines_s1.nextval
696: into l_repair_po_line_id
697: from dual;
698:
699: INSERT INTO CSP_REPAIR_PO_LINES
700: (
701: REPAIR_PO_LINE_ID
702: ,REPAIR_PO_HEADER_ID
703: ,DEFECTIVE_ORGANIZATION_ID