APPS.CSP_REPAIR_PO_GRP dependencies on CSP_REPAIR_PO_LINES

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

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

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

692: END LOOP;
693:
694: --COMMIT;
695:
696: /* Insert into CSP_REPAIR_PO_LINES table all the reservation made for defective parts */
697:
698: FOR I IN 1..l_out_reservation_tbl.COUNT
699: LOOP
700: l_out_reservation_rec := l_out_reservation_tbl(I);

Line 702: select csp_repair_po_lines_s1.nextval

698: FOR I IN 1..l_out_reservation_tbl.COUNT
699: LOOP
700: l_out_reservation_rec := l_out_reservation_tbl(I);
701:
702: select csp_repair_po_lines_s1.nextval
703: into l_repair_po_line_id
704: from dual;
705:
706: INSERT INTO CSP_REPAIR_PO_LINES

Line 706: INSERT INTO CSP_REPAIR_PO_LINES

702: select csp_repair_po_lines_s1.nextval
703: into l_repair_po_line_id
704: from dual;
705:
706: INSERT INTO CSP_REPAIR_PO_LINES
707: (
708: REPAIR_PO_LINE_ID
709: ,REPAIR_PO_HEADER_ID
710: ,DEFECTIVE_ORGANIZATION_ID