eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_POSTALLOC_PVT dependencies on WMS_CARTONIZATION_TEMP

Line 503: -- into wms_cartonization_temp

499:
500:
501:
502: -- Insert all the mmtt records for a move order header id
503: -- into wms_cartonization_temp
504: PROCEDURE create_wct
505: ( p_move_order_header_id IN NUMBER
506: , x_return_status OUT NOCOPY VARCHAR2
507: ) IS

Line 528: INSERT INTO wms_cartonization_temp(

524: -- Checking if the caller is 'TRP' (i.e) from Task Release then
525: -- cartonization_id can be null as well so removing the condition
526:
527: IF g_caller = 'TRP' THEN --{
528: INSERT INTO wms_cartonization_temp(
529: transaction_header_id
530: , transaction_temp_id
531: , source_code
532: , source_line_id

Line 1010: INSERT INTO wms_cartonization_temp(

1006: -- AND mmtt.container_item_id IS NULL;
1007: --}
1008: ELSE
1009: --{
1010: INSERT INTO wms_cartonization_temp(
1011: transaction_header_id
1012: , transaction_temp_id
1013: , source_code
1014: , source_line_id

Line 1532: USING ( SELECT * FROM wms_cartonization_temp ) wct

1528:
1529: SAVEPOINT merge_wct_sp;
1530:
1531: MERGE INTO mtl_material_transactions_temp mmtt
1532: USING ( SELECT * FROM wms_cartonization_temp ) wct
1533: ON ( mmtt.transaction_temp_id = wct.transaction_temp_id )
1534: WHEN MATCHED THEN
1535: UPDATE SET
1536: mmtt.primary_quantity = wct.primary_quantity

Line 2222: FROM wms_cartonization_temp

2218: END IF;
2219: END IF;
2220:
2221: SELECT count(1) INTO l_count
2222: FROM wms_cartonization_temp
2223: WHERE cartonization_id IS NULL
2224: AND transaction_header_id >= 0;
2225:
2226: IF l_count = 0 THEN

Line 2329: DELETE wms_cartonization_temp

2325: END IF;
2326: RAISE fnd_api.g_exc_unexpected_error;
2327: END;
2328:
2329: DELETE wms_cartonization_temp
2330: WHERE transaction_header_id < 0;
2331:
2332: l_api_return_status := fnd_api.g_ret_sts_success;
2333: merge_wct_to_mmtt(l_api_return_status);

Line 2430: FROM wms_cartonization_temp wct

2426: error_msg VARCHAR2(30);
2427:
2428: CURSOR wct_rows IS
2429: SELECT wct.*
2430: FROM wms_cartonization_temp wct
2431: , mtl_txn_request_lines mtrl
2432: , mtl_secondary_inventories sub
2433: , mtl_parameters mtlp
2434: WHERE wct.move_order_line_id = mtrl.line_id

Line 2452: FROM wms_cartonization_temp

2448: , ABS(wct.transaction_temp_id);
2449:
2450: CURSOR bpack_rows (p_hdr_id NUMBER) IS
2451: SELECT *
2452: FROM wms_cartonization_temp
2453: WHERE transaction_header_id = p_hdr_id
2454: AND cartonization_id IS NULL
2455: AND transfer_lpn_id IS NULL
2456: ORDER BY move_order_line_id

Line 2475: FROM wms_cartonization_temp

2471: , secondary_transaction_quantity
2472: , content_lpn_id
2473: , container_item_id
2474: , cartonization_id
2475: FROM wms_cartonization_temp
2476: WHERE transaction_header_id = p_hdr_id
2477: ORDER BY cartonization_id;
2478:
2479: CURSOR opackages(p_hdr_id NUMBER) IS

Line 2488: FROM wms_cartonization_temp wct

2484: , wct.secondary_transaction_quantity
2485: , wct.content_lpn_id
2486: , wct.container_item_id
2487: , wct.cartonization_id
2488: FROM wms_cartonization_temp wct
2489: , mtl_txn_request_lines mtrl
2490: WHERE wct.move_order_line_id = mtrl.line_id
2491: AND mtrl.header_id = p_hdr_id
2492: ORDER BY wct.cartonization_id;

Line 2509: DELETE wms_cartonization_temp;

2505:
2506: WMS_CARTNZN_PUB.outbound := 'Y';
2507:
2508: --making sure that we are starting with an empty table
2509: DELETE wms_cartonization_temp;
2510:
2511: WMS_CARTNZN_PUB.pkg_attr_table.DELETE;
2512: WMS_CARTNZN_PUB.lpn_attr_table.DELETE;
2513: WMS_CARTNZN_PUB.lpns_generated_tb.DELETE;

Line 2587: WMS_CARTNZN_PUB.table_name := 'wms_cartonization_temp';

2583: AND from_organization_id = p_org_id
2584: AND ROWNUM = 1;
2585:
2586: IF l_rulebased_setup_exists > 0 THEN
2587: WMS_CARTNZN_PUB.table_name := 'wms_cartonization_temp';
2588: IF v_cart_value = 1 or v_cart_value = 3 THEN
2589: l_api_return_status := fnd_api.g_ret_sts_success;
2590: rulebased_cartonization
2591: ( x_return_status => l_api_return_status

Line 2626: WMS_CARTNZN_PUB.table_name := 'wms_cartonization_temp';

2622: , l_api_name);
2623: print_debug(' Percent fill basis ' || percent_fill_basis, l_api_name);
2624: END IF;
2625:
2626: WMS_CARTNZN_PUB.table_name := 'wms_cartonization_temp';
2627:
2628: IF g_debug = 1 THEN
2629: print_debug('Inserting mmtt rows of this header into wms_cartonization_temp '
2630: || p_move_order_header_id , l_api_name);

Line 2629: print_debug('Inserting mmtt rows of this header into wms_cartonization_temp '

2625:
2626: WMS_CARTNZN_PUB.table_name := 'wms_cartonization_temp';
2627:
2628: IF g_debug = 1 THEN
2629: print_debug('Inserting mmtt rows of this header into wms_cartonization_temp '
2630: || p_move_order_header_id , l_api_name);
2631: END IF;
2632:
2633: error_code := 'CARTONIZE 50';

Line 3545: DELETE wms_cartonization_temp

3541: END IF;
3542: RAISE fnd_api.g_exc_unexpected_error;
3543: END;
3544:
3545: DELETE wms_cartonization_temp
3546: WHERE transaction_header_id < 0;
3547:
3548: l_api_return_status := fnd_api.g_ret_sts_success;
3549: merge_wct_to_mmtt(l_api_return_status);