APPS.CSP_PARTS_ORDER dependencies on DUAL

Line 1185: FROM sys.dual;

1181:
1182: -- Get unique requisition_header_id
1183: CURSOR req_header_id_cur IS
1184: SELECT po_requisition_headers_s.nextval
1185: FROM sys.dual;
1186:
1187: -- Get unique requisition_line_id
1188: CURSOR req_line_id_cur IS
1189: SELECT po_requisition_lines_s.nextval

Line 1190: FROM sys.dual;

1186:
1187: -- Get unique requisition_line_id
1188: CURSOR req_line_id_cur IS
1189: SELECT po_requisition_lines_s.nextval
1190: FROM sys.dual;
1191:
1192: -- Cursor to get unique Distribution_id
1193: CURSOR dist_line_id_cur IS
1194: SELECT po_req_distributions_s.nextval

Line 1195: FROM sys.dual;

1191:
1192: -- Cursor to get unique Distribution_id
1193: CURSOR dist_line_id_cur IS
1194: SELECT po_req_distributions_s.nextval
1195: FROM sys.dual;
1196:
1197: -- Cursor to get Accrual Account ID and Variance Account ID
1198: -- For Destination Type Code INVENTORY get accrual account id
1199: -- from MTL_PARAMETERS

Line 1652: SELECT Sysdate INTO l_today FROM dual;

1648: and sub.secondary_inventory_name(+) = l_header_rec.dest_subinventory;
1649: end if;
1650:
1651: -- get all the values required to insert into po_requisition_header table
1652: SELECT Sysdate INTO l_today FROM dual;
1653: l_user_id := nvl(fnd_global.user_id, 0) ;
1654: l_login_id := nvl(fnd_global.login_id, -1);
1655:
1656: -- operating unit

Line 1660: FROM dual;*/

1656: -- operating unit
1657: BEGIN
1658: /*SELECT TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ', NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10)))
1659: INTO l_org_id
1660: FROM dual;*/
1661:
1662: l_org_id := mo_global.get_current_org_id;
1663: l_first_org_id := l_org_id;
1664:

Line 1963: FROM DUAL

1959: -- check for uniqueness of requisition_number
1960: BEGIN
1961:
1962: SELECT 1 INTO l_dummy
1963: FROM DUAL
1964: WHERE NOT EXISTS
1965: ( SELECT 1
1966: FROM po_requisition_headers
1967: WHERE Segment1 = l_header_rec.requisition_number)

Line 2942: from dual;

2938: -- order_header_id
2939: IF l_header_rec.order_header_id IS NULL THEN
2940: select oe_order_headers_s.nextval
2941: into l_header_rec.order_header_id
2942: from dual;
2943: END IF;
2944:
2945: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2946: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 3523: from dual;

3519:
3520: IF l_line_tbl(i).order_line_id IS NULL THEN
3521: select oe_order_lines_s.nextval
3522: into l_line_tbl(i).order_line_id
3523: from dual;
3524: END IF;
3525:
3526: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3527: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

Line 4382: FROM sys.dual;

4378:
4379: -- Get unique requisition_header_id
4380: CURSOR req_header_id_cur IS
4381: SELECT po_requisition_headers_s.nextval
4382: FROM sys.dual;
4383:
4384: -- Get unique requisition_line_id
4385: CURSOR req_line_id_cur IS
4386: SELECT po_requisition_lines_s.nextval

Line 4387: FROM sys.dual;

4383:
4384: -- Get unique requisition_line_id
4385: CURSOR req_line_id_cur IS
4386: SELECT po_requisition_lines_s.nextval
4387: FROM sys.dual;
4388:
4389: -- Get preparer_id
4390: CURSOR employee_id_cur IS
4391: SELECT employee_id

Line 4420: SELECT Sysdate INTO l_today FROM dual;

4416: l_header_rec := px_header_rec;
4417: l_line_tbl := px_line_table;
4418:
4419: -- Get data for populating who columns
4420: SELECT Sysdate INTO l_today FROM dual;
4421: l_user_id := nvl(fnd_global.user_id, 0) ;
4422: l_login_id := nvl(fnd_global.login_id, -1);
4423:
4424: -- operating unit

Line 4495: FROM DUAL

4491: -- check for uniqueness of requisition_number
4492: BEGIN
4493:
4494: SELECT 1 INTO l_dummy
4495: FROM DUAL
4496: WHERE NOT EXISTS
4497: ( SELECT 1
4498: FROM po_requisition_headers
4499: WHERE Segment1 = l_header_rec.requisition_number)