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.INV_RCV_RESERVATION_UTIL dependencies on INV_RCV_INTEGRATION_PVT

Line 696: (p_orig_rcpt_rec IN inv_rcv_integration_pvt.cas_mol_rec_type

692: END reduce_reservation;
693:
694: --This will be called from maintain_rsv_receive
695: PROCEDURE set_mol_wdd_tbl
696: (p_orig_rcpt_rec IN inv_rcv_integration_pvt.cas_mol_rec_type
697: ,p_cas_mol_rec_tb IN OUT nocopy inv_rcv_integration_pvt.cas_mol_rec_tb_tp
698: ,p_prim_qty IN NUMBER
699: ,p_wdd_id IN NUMBER
700: ,p_crossdock_type IN NUMBER

Line 697: ,p_cas_mol_rec_tb IN OUT nocopy inv_rcv_integration_pvt.cas_mol_rec_tb_tp

693:
694: --This will be called from maintain_rsv_receive
695: PROCEDURE set_mol_wdd_tbl
696: (p_orig_rcpt_rec IN inv_rcv_integration_pvt.cas_mol_rec_type
697: ,p_cas_mol_rec_tb IN OUT nocopy inv_rcv_integration_pvt.cas_mol_rec_tb_tp
698: ,p_prim_qty IN NUMBER
699: ,p_wdd_id IN NUMBER
700: ,p_crossdock_type IN NUMBER
701: ) IS

Line 764: ,p_cas_mol_rec_tb IN inv_rcv_integration_pvt.cas_mol_rec_tb_tp

760: PROCEDURE maintain_rsv_import_asn
761: (x_return_status OUT NOCOPY VARCHAR2
762: ,x_msg_count OUT NOCOPY NUMBER
763: ,x_msg_data OUT NOCOPY VARCHAR2
764: ,p_cas_mol_rec_tb IN inv_rcv_integration_pvt.cas_mol_rec_tb_tp
765: ) IS
766: l_rsv_query_rec inv_reservation_global.mtl_reservation_rec_type;
767: l_rsv_results_tbl inv_reservation_global.mtl_reservation_tbl_type;
768: l_rsv_update_rec inv_reservation_global.mtl_reservation_rec_type;

Line 1000: ,p_cas_mol_rec_tb IN inv_rcv_integration_pvt.cas_mol_rec_tb_tp

996: PROCEDURE maintain_rsv_cancel_asn
997: (x_return_status OUT NOCOPY VARCHAR2
998: ,x_msg_count OUT NOCOPY NUMBER
999: ,x_msg_data OUT NOCOPY VARCHAR2
1000: ,p_cas_mol_rec_tb IN inv_rcv_integration_pvt.cas_mol_rec_tb_tp
1001: ) IS
1002: l_rsv_query_rec inv_reservation_global.mtl_reservation_rec_type;
1003: l_rsv_results_tbl inv_reservation_global.mtl_reservation_tbl_type;
1004: l_rsv_update_rec inv_reservation_global.mtl_reservation_rec_type;

Line 1193: ,p_cas_mol_rec_tb IN inv_rcv_integration_pvt.cas_mol_rec_tb_tp

1189: PROCEDURE maintain_rsv_receive
1190: (x_return_status OUT NOCOPY VARCHAR2
1191: ,x_msg_count OUT NOCOPY NUMBER
1192: ,x_msg_data OUT NOCOPY VARCHAR2
1193: ,p_cas_mol_rec_tb IN inv_rcv_integration_pvt.cas_mol_rec_tb_tp
1194: ,x_cas_mol_rec_tb OUT nocopy inv_rcv_integration_pvt.cas_mol_rec_tb_tp
1195: ) IS
1196: l_rsv_query_rec inv_reservation_global.mtl_reservation_rec_type;
1197: l_rsv_results_tbl inv_reservation_global.mtl_reservation_tbl_type;

Line 1194: ,x_cas_mol_rec_tb OUT nocopy inv_rcv_integration_pvt.cas_mol_rec_tb_tp

1190: (x_return_status OUT NOCOPY VARCHAR2
1191: ,x_msg_count OUT NOCOPY NUMBER
1192: ,x_msg_data OUT NOCOPY VARCHAR2
1193: ,p_cas_mol_rec_tb IN inv_rcv_integration_pvt.cas_mol_rec_tb_tp
1194: ,x_cas_mol_rec_tb OUT nocopy inv_rcv_integration_pvt.cas_mol_rec_tb_tp
1195: ) IS
1196: l_rsv_query_rec inv_reservation_global.mtl_reservation_rec_type;
1197: l_rsv_results_tbl inv_reservation_global.mtl_reservation_tbl_type;
1198: l_rsv_update_rec inv_reservation_global.mtl_reservation_rec_type;

Line 1684: ,p_cas_mol_rec_tb IN inv_rcv_integration_pvt.cas_mol_rec_tb_tp

1680: PROCEDURE maintain_rsv_deliver
1681: (x_return_status OUT NOCOPY VARCHAR2
1682: ,x_msg_count OUT NOCOPY NUMBER
1683: ,x_msg_data OUT NOCOPY VARCHAR2
1684: ,p_cas_mol_rec_tb IN inv_rcv_integration_pvt.cas_mol_rec_tb_tp
1685: ) IS
1686: l_rsv_reduce_rec inv_reservation_global.mtl_maintain_rsv_rec_type;
1687: l_rsv_query_rec inv_reservation_global.mtl_reservation_rec_type;
1688: l_rsv_results_tbl inv_reservation_global.mtl_reservation_tbl_type;

Line 2044: ,p_cas_mol_rec_tb IN inv_rcv_integration_pvt.cas_mol_rec_tb_tp

2040: PROCEDURE maintain_rsv_returns
2041: (x_return_status OUT NOCOPY VARCHAR2
2042: ,x_msg_count OUT NOCOPY NUMBER
2043: ,x_msg_data OUT NOCOPY VARCHAR2
2044: ,p_cas_mol_rec_tb IN inv_rcv_integration_pvt.cas_mol_rec_tb_tp
2045: ) IS
2046: l_rsv_query_rec inv_reservation_global.mtl_reservation_rec_type;
2047: l_rsv_update_rec inv_reservation_global.mtl_reservation_rec_type;
2048: l_remaining_prim_qty NUMBER;

Line 2482: inv_rcv_integration_pvt.call_atf_api(x_return_status => l_return_status,

2478: , line_status = 5
2479: , wms_process_flag = 1
2480: WHERE line_id = l_tmp_line_id;
2481:
2482: inv_rcv_integration_pvt.call_atf_api(x_return_status => l_return_status,
2483: x_msg_data => l_msg_data,
2484: x_msg_count => l_msg_count,
2485: x_error_code => l_error_code,
2486: p_source_task_id => NULL,

Line 2490: p_atf_api_name => inv_rcv_integration_pvt.g_atf_api_cancel);

2486: p_source_task_id => NULL,
2487: p_activity_type_id => 1,
2488: p_operation_type_id => NULL,
2489: p_mol_id => l_tmp_line_id,
2490: p_atf_api_name => inv_rcv_integration_pvt.g_atf_api_cancel);
2491:
2492:
2493: ELSE --l_rsv_result_tbl(i).demand_source_line_detail IS NULL THEN
2494:

Line 2712: inv_rcv_integration_pvt.call_atf_api(x_return_status => l_return_status,

2708: IF (l_debug = 1) THEN
2709: print_debug('Call cancel ATF',l_module_name,9);
2710: END IF;
2711:
2712: inv_rcv_integration_pvt.call_atf_api(x_return_status => l_return_status,
2713: x_msg_data => l_msg_data,
2714: x_msg_count => l_msg_count,
2715: x_error_code => l_error_code,
2716: p_source_task_id => NULL,

Line 2720: p_atf_api_name => inv_rcv_integration_pvt.g_atf_api_cancel);

2716: p_source_task_id => NULL,
2717: p_activity_type_id => 1,
2718: p_operation_type_id => NULL,
2719: p_mol_id => l_tmp_line_id,
2720: p_atf_api_name => inv_rcv_integration_pvt.g_atf_api_cancel);
2721:
2722: IF (l_debug = 1) THEN
2723: print_debug('Closing MOL '||l_tmp_line_id,l_module_name,9);
2724: END IF;

Line 2774: ,p_cas_mol_tb IN inv_rcv_integration_pvt.cas_mol_rec_tb_tp

2770: PROCEDURE split_close_mo_for_ret_corr
2771: (x_return_status OUT NOCOPY VARCHAR2
2772: ,x_msg_count OUT NOCOPY NUMBER
2773: ,x_msg_data OUT NOCOPY VARCHAR2
2774: ,p_cas_mol_tb IN inv_rcv_integration_pvt.cas_mol_rec_tb_tp
2775: ) IS
2776: CURSOR c_mol_no_mmtt (p_org_id NUMBER,
2777: p_item NUMBER,
2778: p_lpn NUMBER,

Line 2966: inv_rcv_integration_pvt.call_atf_api(x_return_status => x_return_status,

2962: IF (l_debug = 1) THEN
2963: print_debug('calling call_atf_api:'||l_mol_rec.line_id,l_module_name,4);
2964: END IF;
2965:
2966: inv_rcv_integration_pvt.call_atf_api(x_return_status => x_return_status,
2967: x_msg_data => x_msg_data,
2968: x_msg_count => x_msg_count,
2969: x_error_code => l_error_code,
2970: p_source_task_id => NULL,

Line 2974: p_atf_api_name => inv_rcv_integration_pvt.g_atf_api_cancel);

2970: p_source_task_id => NULL,
2971: p_activity_type_id => 1,
2972: p_operation_type_id => NULL,
2973: p_mol_id => l_mol_rec.line_id,
2974: p_atf_api_name => inv_rcv_integration_pvt.g_atf_api_cancel);
2975:
2976: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
2977: IF (l_debug = 1) THEN
2978: print_debug('call_atf_api failed:'||l_mol_rec.line_id,l_module_name,4);

Line 3028: inv_rcv_integration_pvt.call_atf_api(x_return_status => x_return_status,

3024: , wms_process_flag = 1
3025: WHERE line_id = l_mo_split_tb(1).line_id;
3026:
3027: -- Call cancel operation plan for the new line
3028: inv_rcv_integration_pvt.call_atf_api(x_return_status => x_return_status,
3029: x_msg_data => x_msg_data,
3030: x_msg_count => x_msg_count,
3031: x_error_code => l_error_code,
3032: p_source_task_id => NULL,

Line 3036: p_atf_api_name => inv_rcv_integration_pvt.g_atf_api_cancel);

3032: p_source_task_id => NULL,
3033: p_activity_type_id => 1,
3034: p_operation_type_id => NULL,
3035: p_mol_id => l_mo_split_tb(1).line_id,
3036: p_atf_api_name => inv_rcv_integration_pvt.g_atf_api_cancel);
3037:
3038: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
3039: IF (l_debug = 1) THEN
3040: print_debug('call_atf_api failed:'||l_mo_split_tb(1).line_id,l_module_name,4);

Line 3080: ,x_mol_tb OUT NOCOPY inv_rcv_integration_pvt.cas_mol_rec_tb_tp

3076: PROCEDURE maintain_reservations
3077: (x_return_status OUT NOCOPY VARCHAR2
3078: ,x_msg_count OUT NOCOPY NUMBER
3079: ,x_msg_data OUT NOCOPY VARCHAR2
3080: ,x_mol_tb OUT NOCOPY inv_rcv_integration_pvt.cas_mol_rec_tb_tp
3081: ,p_cas_mol_tb IN inv_rcv_integration_pvt.cas_mol_rec_tb_tp
3082: )
3083: IS
3084: l_debug NUMBER;

Line 3081: ,p_cas_mol_tb IN inv_rcv_integration_pvt.cas_mol_rec_tb_tp

3077: (x_return_status OUT NOCOPY VARCHAR2
3078: ,x_msg_count OUT NOCOPY NUMBER
3079: ,x_msg_data OUT NOCOPY VARCHAR2
3080: ,x_mol_tb OUT NOCOPY inv_rcv_integration_pvt.cas_mol_rec_tb_tp
3081: ,p_cas_mol_tb IN inv_rcv_integration_pvt.cas_mol_rec_tb_tp
3082: )
3083: IS
3084: l_debug NUMBER;
3085: l_progress VARCHAR2(10);