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 802: ,p_cas_mol_rec_tb IN inv_rcv_integration_pvt.cas_mol_rec_tb_tp

798: PROCEDURE maintain_rsv_import_asn
799: (x_return_status OUT NOCOPY VARCHAR2
800: ,x_msg_count OUT NOCOPY NUMBER
801: ,x_msg_data OUT NOCOPY VARCHAR2
802: ,p_cas_mol_rec_tb IN inv_rcv_integration_pvt.cas_mol_rec_tb_tp
803: ) IS
804: l_rsv_query_rec inv_reservation_global.mtl_reservation_rec_type;
805: l_rsv_results_tbl inv_reservation_global.mtl_reservation_tbl_type;
806: l_rsv_update_rec inv_reservation_global.mtl_reservation_rec_type;

Line 1038: ,p_cas_mol_rec_tb IN inv_rcv_integration_pvt.cas_mol_rec_tb_tp

1034: PROCEDURE maintain_rsv_cancel_asn
1035: (x_return_status OUT NOCOPY VARCHAR2
1036: ,x_msg_count OUT NOCOPY NUMBER
1037: ,x_msg_data OUT NOCOPY VARCHAR2
1038: ,p_cas_mol_rec_tb IN inv_rcv_integration_pvt.cas_mol_rec_tb_tp
1039: ) IS
1040: l_rsv_query_rec inv_reservation_global.mtl_reservation_rec_type;
1041: l_rsv_results_tbl inv_reservation_global.mtl_reservation_tbl_type;
1042: l_rsv_update_rec inv_reservation_global.mtl_reservation_rec_type;

Line 1231: ,p_cas_mol_rec_tb IN inv_rcv_integration_pvt.cas_mol_rec_tb_tp

1227: PROCEDURE maintain_rsv_receive
1228: (x_return_status OUT NOCOPY VARCHAR2
1229: ,x_msg_count OUT NOCOPY NUMBER
1230: ,x_msg_data OUT NOCOPY VARCHAR2
1231: ,p_cas_mol_rec_tb IN inv_rcv_integration_pvt.cas_mol_rec_tb_tp
1232: ,x_cas_mol_rec_tb OUT nocopy inv_rcv_integration_pvt.cas_mol_rec_tb_tp
1233: ) IS
1234: l_rsv_query_rec inv_reservation_global.mtl_reservation_rec_type;
1235: l_rsv_results_tbl inv_reservation_global.mtl_reservation_tbl_type;

Line 1232: ,x_cas_mol_rec_tb OUT nocopy inv_rcv_integration_pvt.cas_mol_rec_tb_tp

1228: (x_return_status OUT NOCOPY VARCHAR2
1229: ,x_msg_count OUT NOCOPY NUMBER
1230: ,x_msg_data OUT NOCOPY VARCHAR2
1231: ,p_cas_mol_rec_tb IN inv_rcv_integration_pvt.cas_mol_rec_tb_tp
1232: ,x_cas_mol_rec_tb OUT nocopy inv_rcv_integration_pvt.cas_mol_rec_tb_tp
1233: ) IS
1234: l_rsv_query_rec inv_reservation_global.mtl_reservation_rec_type;
1235: l_rsv_results_tbl inv_reservation_global.mtl_reservation_tbl_type;
1236: l_rsv_update_rec inv_reservation_global.mtl_reservation_rec_type;

Line 1773: ,p_cas_mol_rec_tb IN inv_rcv_integration_pvt.cas_mol_rec_tb_tp

1769: PROCEDURE maintain_rsv_deliver
1770: (x_return_status OUT NOCOPY VARCHAR2
1771: ,x_msg_count OUT NOCOPY NUMBER
1772: ,x_msg_data OUT NOCOPY VARCHAR2
1773: ,p_cas_mol_rec_tb IN inv_rcv_integration_pvt.cas_mol_rec_tb_tp
1774: ) IS
1775: l_rsv_reduce_rec inv_reservation_global.mtl_maintain_rsv_rec_type;
1776: l_rsv_query_rec inv_reservation_global.mtl_reservation_rec_type;
1777: l_rsv_results_tbl inv_reservation_global.mtl_reservation_tbl_type;

Line 2250: ,p_cas_mol_rec_tb IN inv_rcv_integration_pvt.cas_mol_rec_tb_tp

2246: PROCEDURE maintain_rsv_returns
2247: (x_return_status OUT NOCOPY VARCHAR2
2248: ,x_msg_count OUT NOCOPY NUMBER
2249: ,x_msg_data OUT NOCOPY VARCHAR2
2250: ,p_cas_mol_rec_tb IN inv_rcv_integration_pvt.cas_mol_rec_tb_tp
2251: ) IS
2252: l_rsv_query_rec inv_reservation_global.mtl_reservation_rec_type;
2253: l_rsv_update_rec inv_reservation_global.mtl_reservation_rec_type;
2254: l_remaining_prim_qty NUMBER;

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

2684: , line_status = 5
2685: , wms_process_flag = 1
2686: WHERE line_id = l_tmp_line_id;
2687:
2688: inv_rcv_integration_pvt.call_atf_api(x_return_status => l_return_status,
2689: x_msg_data => l_msg_data,
2690: x_msg_count => l_msg_count,
2691: x_error_code => l_error_code,
2692: p_source_task_id => NULL,

Line 2696: p_atf_api_name => inv_rcv_integration_pvt.g_atf_api_cancel);

2692: p_source_task_id => NULL,
2693: p_activity_type_id => 1,
2694: p_operation_type_id => NULL,
2695: p_mol_id => l_tmp_line_id,
2696: p_atf_api_name => inv_rcv_integration_pvt.g_atf_api_cancel);
2697:
2698:
2699: ELSE --l_rsv_result_tbl(i).demand_source_line_detail IS NULL THEN
2700:

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

2914: IF (l_debug = 1) THEN
2915: print_debug('Call cancel ATF',l_module_name,9);
2916: END IF;
2917:
2918: inv_rcv_integration_pvt.call_atf_api(x_return_status => l_return_status,
2919: x_msg_data => l_msg_data,
2920: x_msg_count => l_msg_count,
2921: x_error_code => l_error_code,
2922: p_source_task_id => NULL,

Line 2926: p_atf_api_name => inv_rcv_integration_pvt.g_atf_api_cancel);

2922: p_source_task_id => NULL,
2923: p_activity_type_id => 1,
2924: p_operation_type_id => NULL,
2925: p_mol_id => l_tmp_line_id,
2926: p_atf_api_name => inv_rcv_integration_pvt.g_atf_api_cancel);
2927:
2928: IF (l_debug = 1) THEN
2929: print_debug('Closing MOL '||l_tmp_line_id,l_module_name,9);
2930: END IF;

Line 2980: ,p_cas_mol_tb IN inv_rcv_integration_pvt.cas_mol_rec_tb_tp

2976: PROCEDURE split_close_mo_for_ret_corr
2977: (x_return_status OUT NOCOPY VARCHAR2
2978: ,x_msg_count OUT NOCOPY NUMBER
2979: ,x_msg_data OUT NOCOPY VARCHAR2
2980: ,p_cas_mol_tb IN inv_rcv_integration_pvt.cas_mol_rec_tb_tp
2981: ) IS
2982: CURSOR c_mol_no_mmtt (p_org_id NUMBER,
2983: p_item NUMBER,
2984: p_lpn NUMBER,

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

3168: IF (l_debug = 1) THEN
3169: print_debug('calling call_atf_api:'||l_mol_rec.line_id,l_module_name,4);
3170: END IF;
3171:
3172: inv_rcv_integration_pvt.call_atf_api(x_return_status => x_return_status,
3173: x_msg_data => x_msg_data,
3174: x_msg_count => x_msg_count,
3175: x_error_code => l_error_code,
3176: p_source_task_id => NULL,

Line 3180: p_atf_api_name => inv_rcv_integration_pvt.g_atf_api_cancel);

3176: p_source_task_id => NULL,
3177: p_activity_type_id => 1,
3178: p_operation_type_id => NULL,
3179: p_mol_id => l_mol_rec.line_id,
3180: p_atf_api_name => inv_rcv_integration_pvt.g_atf_api_cancel);
3181:
3182: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
3183: IF (l_debug = 1) THEN
3184: print_debug('call_atf_api failed:'||l_mol_rec.line_id,l_module_name,4);

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

3230: , wms_process_flag = 1
3231: WHERE line_id = l_mo_split_tb(1).line_id;
3232:
3233: -- Call cancel operation plan for the new line
3234: inv_rcv_integration_pvt.call_atf_api(x_return_status => x_return_status,
3235: x_msg_data => x_msg_data,
3236: x_msg_count => x_msg_count,
3237: x_error_code => l_error_code,
3238: p_source_task_id => NULL,

Line 3242: p_atf_api_name => inv_rcv_integration_pvt.g_atf_api_cancel);

3238: p_source_task_id => NULL,
3239: p_activity_type_id => 1,
3240: p_operation_type_id => NULL,
3241: p_mol_id => l_mo_split_tb(1).line_id,
3242: p_atf_api_name => inv_rcv_integration_pvt.g_atf_api_cancel);
3243:
3244: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
3245: IF (l_debug = 1) THEN
3246: print_debug('call_atf_api failed:'||l_mo_split_tb(1).line_id,l_module_name,4);

Line 3286: ,x_mol_tb OUT NOCOPY inv_rcv_integration_pvt.cas_mol_rec_tb_tp

3282: PROCEDURE maintain_reservations
3283: (x_return_status OUT NOCOPY VARCHAR2
3284: ,x_msg_count OUT NOCOPY NUMBER
3285: ,x_msg_data OUT NOCOPY VARCHAR2
3286: ,x_mol_tb OUT NOCOPY inv_rcv_integration_pvt.cas_mol_rec_tb_tp
3287: ,p_cas_mol_tb IN inv_rcv_integration_pvt.cas_mol_rec_tb_tp
3288: )
3289: IS
3290: l_debug NUMBER;

Line 3287: ,p_cas_mol_tb IN inv_rcv_integration_pvt.cas_mol_rec_tb_tp

3283: (x_return_status OUT NOCOPY VARCHAR2
3284: ,x_msg_count OUT NOCOPY NUMBER
3285: ,x_msg_data OUT NOCOPY VARCHAR2
3286: ,x_mol_tb OUT NOCOPY inv_rcv_integration_pvt.cas_mol_rec_tb_tp
3287: ,p_cas_mol_tb IN inv_rcv_integration_pvt.cas_mol_rec_tb_tp
3288: )
3289: IS
3290: l_debug NUMBER;
3291: l_progress VARCHAR2(10);