APPS.CSP_PARTS_REQUIREMENT dependencies on DUAL

Line 241: SELECT Sysdate INTO l_today FROM dual;

237: l_header_Rec := px_header_rec;
238: l_line_tbl := px_line_table;
239:
240: -- user and login information
241: SELECT Sysdate INTO l_today FROM dual;
242: l_user_id := fnd_global.user_id;
243: l_login_id := fnd_global.login_id;
244:
245: -- call availability API to get source organization

Line 680: FROM dual;

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(
683: px_REQ_LINE_DETAIL_ID => l_Req_line_Dtl_id,
684: p_REQUIREMENT_LINE_ID => x_rqmt_line_tbl(I).requirement_line_id,

Line 853: SELECT Sysdate INTO l_today FROM dual;

849: l_header_Rec := px_header_rec;
850: l_old_line_tbl := px_line_table;
851:
852: -- user and login information
853: SELECT Sysdate INTO l_today FROM dual;
854: l_user_id := fnd_global.user_id;
855: l_login_id := fnd_global.login_id;
856:
857: -- create reservations and create line table which qualify for creating order

Line 1174: SELECT Sysdate INTO l_today FROM dual;

1170: l_header_Rec := px_header_rec;
1171: l_line_tbl := px_line_table;
1172:
1173: -- user and login information
1174: SELECT Sysdate INTO l_today FROM dual;
1175: l_user_id := fnd_global.user_id;
1176: l_login_id := fnd_global.login_id;
1177:
1178: -- create reservations and create line table which qualify for creating order

Line 1203: FROM dual;

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(
1206: px_REQ_LINE_DETAIL_ID => l_Req_line_Dtl_id,
1207: p_REQUIREMENT_LINE_ID => l_line_rec.requirement_line_id,

Line 1249: FROM dual;

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(
1252: px_REQ_LINE_DETAIL_ID => l_Req_line_Dtl_id,
1253: p_REQUIREMENT_LINE_ID => l_line_rec.requirement_line_id,

Line 1287: FROM dual;

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(
1290: px_REQ_LINE_DETAIL_ID => l_Req_line_Dtl_id,
1291: p_REQUIREMENT_LINE_ID => l_line_rec.requirement_line_id,

Line 1517: SELECT Sysdate INTO l_today FROM dual;

1513: l_header_Rec := px_header_rec;
1514: l_line_tbl := px_line_tbl;
1515:
1516: -- user and login information
1517: SELECT Sysdate INTO l_today FROM dual;
1518: l_user_id := fnd_global.user_id;
1519:
1520: l_login_id := fnd_global.login_id;
1521:

Line 2322: SELECT Sysdate INTO l_today FROM dual;

2318: -- initialize return status
2319: x_return_status := FND_API.G_RET_STS_SUCCESS;
2320:
2321: -- user and login information
2322: SELECT Sysdate INTO l_today FROM dual;
2323: l_user_id := fnd_global.user_id;
2324: l_login_id := fnd_global.login_id;
2325:
2326: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 2509: FROM dual;

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(
2512: px_REQ_LINE_DETAIL_ID => l_Req_line_Dtl_id,
2513: p_REQUIREMENT_LINE_ID => l_line_rec.requirement_line_id,

Line 2561: FROM dual;

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(
2564: px_REQ_LINE_DETAIL_ID => l_Req_line_Dtl_id,
2565: p_REQUIREMENT_LINE_ID => l_line_rec.requirement_line_id,