[Home] [Help]
689: END IF;
690: END IF;
691: FOR I IN 1..x_rqmt_line_tbl.count LOOP
692: IF x_rqmt_line_tbl(I).order_line_id IS NOT NULL THEN
693: SELECT csp_req_line_Details_s1.nextval
694: INTO l_req_line_Dtl_id
695: FROM dual;
696:
697: csp_req_line_Details_pkg.Insert_Row(
1306: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1307: RAISE FND_API.G_EXC_ERROR;
1308: ELSE
1309: -- code for inserting into req line dtls
1310: SELECT csp_req_line_Details_s1.nextval
1311: INTO l_req_line_Dtl_id
1312: FROM dual;
1313:
1314: csp_req_line_Details_pkg.Insert_Row(
1352: -- insert record in csp_req_line_details table with order information
1353: FOR I IN 1..l_oe_line_tbl.COUNT LOOP
1354: l_line_rec := l_oe_line_tbl(I);
1355:
1356: SELECT csp_req_line_Details_s1.nextval
1357: INTO l_req_line_Dtl_id
1358: FROM dual;
1359:
1360: csp_req_line_Details_pkg.Insert_Row(
1390: -- insert into csp_req_line_Details table with purchase req information
1391: FOR I IN 1..l_po_line_tbl.COUNT LOOP
1392: l_line_rec := l_po_line_tbl(I);
1393:
1394: SELECT csp_req_line_Details_s1.nextval
1395: INTO l_req_line_Dtl_id
1396: FROM dual;
1397:
1398: csp_req_line_Details_pkg.Insert_Row(
2623: -- update csp_requirement_line table with order information
2624: FOR I IN 1..l_oe_line_tbl.COUNT LOOP
2625: l_line_rec := l_oe_line_tbl(I);
2626:
2627: SELECT csp_req_line_Details_s1.nextval
2628: INTO l_req_line_Dtl_id
2629: FROM dual;
2630:
2631: csp_req_line_Details_pkg.Insert_Row(
2675: -- insert into csp_req_line_Details table with purchase req information
2676: FOR I IN 1..l_po_line_tbl.COUNT LOOP
2677: l_line_rec := l_po_line_tbl(I);
2678:
2679: SELECT csp_req_line_Details_s1.nextval
2680: INTO l_req_line_Dtl_id
2681: FROM dual;
2682:
2683: csp_req_line_Details_pkg.Insert_Row(