APPS.CSP_PARTS_REQUIREMENT dependencies on DUAL

Line 244: SELECT Sysdate INTO l_today FROM dual;

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

Line 695: FROM dual;

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

Line 868: SELECT Sysdate INTO l_today FROM dual;

864: l_header_Rec := px_header_rec;
865: l_old_line_tbl := px_line_table;
866:
867: -- user and login information
868: SELECT Sysdate INTO l_today FROM dual;
869: l_user_id := fnd_global.user_id;
870: l_login_id := fnd_global.login_id;
871:
872: -- create reservations and create line table which qualify for creating order

Line 1203: SELECT Sysdate INTO l_today FROM dual;

1199: l_header_Rec := px_header_rec;
1200: l_line_tbl := px_line_table;
1201:
1202: -- user and login information
1203: SELECT Sysdate INTO l_today FROM dual;
1204: l_user_id := fnd_global.user_id;
1205: l_login_id := fnd_global.login_id;
1206:
1207: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 1312: FROM dual;

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

Line 1358: FROM dual;

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

Line 1396: FROM dual;

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

Line 1631: SELECT Sysdate INTO l_today FROM dual;

1627: l_header_Rec := px_header_rec;
1628: l_line_tbl := px_line_tbl;
1629:
1630: -- user and login information
1631: SELECT Sysdate INTO l_today FROM dual;
1632: l_user_id := fnd_global.user_id;
1633:
1634: l_login_id := fnd_global.login_id;
1635:

Line 2442: SELECT Sysdate INTO l_today FROM dual;

2438: -- initialize return status
2439: x_return_status := FND_API.G_RET_STS_SUCCESS;
2440:
2441: -- user and login information
2442: SELECT Sysdate INTO l_today FROM dual;
2443: l_user_id := fnd_global.user_id;
2444: l_login_id := fnd_global.login_id;
2445:
2446: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 2629: FROM dual;

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

Line 2681: FROM dual;

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