APPS.CSP_PARTS_REQUIREMENT dependencies on CSP_REQ_LINE_DETAILS_S1

Line 678: SELECT csp_req_line_Details_s1.nextval

674: END IF;
675: END IF;
676: FOR I IN 1..x_rqmt_line_tbl.count LOOP
677: IF x_rqmt_line_tbl(I).order_line_id IS NOT NULL THEN
678: SELECT csp_req_line_Details_s1.nextval
679: INTO l_req_line_Dtl_id
680: FROM dual;
681:
682: csp_req_line_Details_pkg.Insert_Row(

Line 1201: SELECT csp_req_line_Details_s1.nextval

1197: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1198: RAISE FND_API.G_EXC_ERROR;
1199: ELSE
1200: -- code for inserting into req line dtls
1201: SELECT csp_req_line_Details_s1.nextval
1202: INTO l_req_line_Dtl_id
1203: FROM dual;
1204:
1205: csp_req_line_Details_pkg.Insert_Row(

Line 1247: SELECT csp_req_line_Details_s1.nextval

1243: -- insert record in csp_req_line_details table with order information
1244: FOR I IN 1..l_oe_line_tbl.COUNT LOOP
1245: l_line_rec := l_oe_line_tbl(I);
1246:
1247: SELECT csp_req_line_Details_s1.nextval
1248: INTO l_req_line_Dtl_id
1249: FROM dual;
1250:
1251: csp_req_line_Details_pkg.Insert_Row(

Line 1285: SELECT csp_req_line_Details_s1.nextval

1281: -- insert into csp_req_line_Details table with purchase req information
1282: FOR I IN 1..l_po_line_tbl.COUNT LOOP
1283: l_line_rec := l_po_line_tbl(I);
1284:
1285: SELECT csp_req_line_Details_s1.nextval
1286: INTO l_req_line_Dtl_id
1287: FROM dual;
1288:
1289: csp_req_line_Details_pkg.Insert_Row(

Line 2507: SELECT csp_req_line_Details_s1.nextval

2503: -- update csp_requirement_line table with order information
2504: FOR I IN 1..l_oe_line_tbl.COUNT LOOP
2505: l_line_rec := l_oe_line_tbl(I);
2506:
2507: SELECT csp_req_line_Details_s1.nextval
2508: INTO l_req_line_Dtl_id
2509: FROM dual;
2510:
2511: csp_req_line_Details_pkg.Insert_Row(

Line 2559: SELECT csp_req_line_Details_s1.nextval

2555: -- insert into csp_req_line_Details table with purchase req information
2556: FOR I IN 1..l_po_line_tbl.COUNT LOOP
2557: l_line_rec := l_po_line_tbl(I);
2558:
2559: SELECT csp_req_line_Details_s1.nextval
2560: INTO l_req_line_Dtl_id
2561: FROM dual;
2562:
2563: csp_req_line_Details_pkg.Insert_Row(