APPS.WMS_UT_PKG dependencies on DUAL

Line 460: FROM DUAL;

456: l_trx_src_type_id := 13;
457: END IF;
458: SELECT MTL_MATERIAL_TRANSACTIONS_S.nextval
459: INTO l_trx_hdr_id
460: FROM DUAL;
461: print_debug('Item : ' || get_lst_val(l_txns_lst(l_ix),3));
462: l_item_id := get_item_id(p_org_id, get_lst_val(l_txns_lst(l_ix),3), p_test_id, p_runid);
463: print_debug('Item ID : ' || l_item_id);
464: l_revision := get_lst_val(l_txns_lst(l_ix),4);

Line 599: SELECT MTL_ONHAND_QUANTITIES_S.nextval INTO l_oh_id FROM DUAL;

595: g_lotser_cnt := g_lotser_cnt + 1;
596: END IF;
597: END IF;
598:
599: SELECT MTL_ONHAND_QUANTITIES_S.nextval INTO l_oh_id FROM DUAL;
600:
601: print_debug('Writing to MOQD ID : ' || l_oh_id);
602:
603: insert into mtl_onhand_quantities_detail

Line 796: lotrec.TERRITORY_CODE FROM DUAL);

792: lotrec.WIDTH,
793: lotrec.WIDTH_UOM,
794: lotrec.CURL_WRINKLE_FOLD,
795: lotrec.VENDOR_ID,
796: lotrec.TERRITORY_CODE FROM DUAL);
797:
798:
799: print_debug('Done writing LOT : ' || moqdrec.lot_number);
800: end if;

Line 1491: INTO l_start_req_date FROM dual;

1487:
1488: l_so_orders := get_value_list(p_data, 'SORDER');
1489:
1490: SELECT to_char(sysdate, 'MM/DD/RR hh:mi:ss')
1491: INTO l_start_req_date FROM dual;
1492:
1493: ij := 0;
1494:
1495: FOR i in 1..l_so_orders.count LOOP

Line 1519: into l_request_id from dual;

1515: numofdistinctlines := 1;
1516: END IF;
1517:
1518: /* select oe_perf_orig_sys_doc_ref_s.nextval
1519: into l_request_id from dual;
1520:
1521: select oe_perf_orig_sys_doc_ref_s.nextval
1522: into l_order_source_id from dual;*/
1523:

Line 1522: into l_order_source_id from dual;*/

1518: /* select oe_perf_orig_sys_doc_ref_s.nextval
1519: into l_request_id from dual;
1520:
1521: select oe_perf_orig_sys_doc_ref_s.nextval
1522: into l_order_source_id from dual;*/
1523:
1524: l_request_id := p_run_id;
1525: l_order_source_id := 0;
1526:

Line 1551: into l_orig_sys_document_ref from dual;

1547: end if;
1548:
1549: /* Needed a distinct doc ref id for each order */
1550: select MTL_MATERIAL_TRANSACTIONS_S.nextval
1551: into l_orig_sys_document_ref from dual;
1552:
1553:
1554: print_debug('Orig sys ref :'||l_orig_sys_document_ref);
1555: INSERT INTO OE_HEADERS_IFACE_ALL (

Line 1795: INTO l_end_req_date FROM dual;

1791: print_debug('UNExpected error');
1792: end if;
1793: -- Setting end request date
1794: SELECT to_char(sysdate, 'MM/DD/RR hh:mi:ss')
1795: INTO l_end_req_date FROM dual;
1796:
1797: for ij in l_orig_sys_tbl.first..l_orig_sys_tbl.last LOOP
1798: l_orig_sys := l_orig_sys_tbl(ij);
1799:

Line 2145: select sysdate into l_start from dual;

2141:
2142: FOR i in 1..g_trolin_tbl.count LOOP
2143:
2144: print_debug ('Mo Line ID : ' || g_trolin_tbl(i).line_id);
2145: select sysdate into l_start from dual;
2146:
2147: delete wms_transactions_temp;
2148:
2149: l_demand_info.oe_line_id := g_trolin_tbl(i).line_id;

Line 2922: EXECUTE IMMEDIATE ' select wms_ut_tab_testset_s.nextval from dual' INTO l_testset_id ;

2918:
2919: EXCEPTION
2920: WHEN NO_DATA_FOUND THEN
2921:
2922: EXECUTE IMMEDIATE ' select wms_ut_tab_testset_s.nextval from dual' INTO l_testset_id ;
2923: EXECUTE IMMEDIATE ' INSERT INTO WMS_UT_TESTSET (TESTSET_ID, TESTSET)' ||
2924: ' VALUES (:l_testset_id, :l_testset)' USING l_testset_id, l_testset;
2925: END;
2926: ELSIF l_testset_id IS NULL THEN

Line 2968: EXECUTE IMMEDIATE 'select wms_ut_tab_test_s.nextval from dual' INTO l_test_id;

2964: l_test := NULL;
2965: END IF;
2966: EXCEPTION
2967: WHEN NO_DATA_FOUND THEN
2968: EXECUTE IMMEDIATE 'select wms_ut_tab_test_s.nextval from dual' INTO l_test_id;
2969: EXECUTE IMMEDIATE
2970: ' INSERT INTO WMS_UT_TEST (testset_id, test_id, testname)' ||
2971: ' VALUES (:l_testset_id, :l_test_id, :l_test)' USING l_testset_id, l_test_id, l_test;
2972: END;

Line 3111: EXECUTE IMMEDIATE 'select wms_ut_tab_testset_s.nextval from dual' INTO x_new_testset_id;

3107: USING l_testset;
3108:
3109: EXCEPTION
3110: WHEN NO_DATA_FOUND THEN
3111: EXECUTE IMMEDIATE 'select wms_ut_tab_testset_s.nextval from dual' INTO x_new_testset_id;
3112: EXECUTE IMMEDIATE
3113: ' INSERT INTO WMS_UT_TESTSET (TESTSET_ID, TESTSET)' ||
3114: ' VALUES (:x_new_testset_id, :p_to_testset)'
3115: USING x_new_testset_id, p_to_testset;

Line 3126: EXECUTE IMMEDIATE 'select wms_ut_tab_test_s.nextval from dual' INTO x_new_test_id;

3122: ' WHERE test_id = :p_from_test_id'
3123: INTO x_new_testset_id
3124: USING p_from_test_id;
3125: END IF;
3126: EXECUTE IMMEDIATE 'select wms_ut_tab_test_s.nextval from dual' INTO x_new_test_id;
3127: EXECUTE IMMEDIATE
3128: ' INSERT INTO WMS_UT_TEST (testset_id, test_id, testname)' ||
3129: ' VALUES (:x_new_testset_id, :x_new_test_id, :p_to_test)'
3130: USING x_new_testset_id, x_new_test_id, p_to_test;