DBA Data[Home] [Help]

APPS.WMS_TASK_MGMT_PUB dependencies on INV_MOVE_ORDER_PUB

Line 2977: RETURN inv_move_order_pub.trolin_tbl_type IS

2973: This function gets the move order record for the move order line passed.
2974: */
2975: -------------------------------------------------------------------------------------------------------------------
2976: FUNCTION query_rows(p_line_id IN NUMBER := fnd_api.g_miss_num)
2977: RETURN inv_move_order_pub.trolin_tbl_type IS
2978:
2979: l_trolin_rec inv_move_order_pub.trolin_rec_type;
2980: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
2981: CURSOR l_trolin_csr

Line 2979: l_trolin_rec inv_move_order_pub.trolin_rec_type;

2975: -------------------------------------------------------------------------------------------------------------------
2976: FUNCTION query_rows(p_line_id IN NUMBER := fnd_api.g_miss_num)
2977: RETURN inv_move_order_pub.trolin_tbl_type IS
2978:
2979: l_trolin_rec inv_move_order_pub.trolin_rec_type;
2980: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
2981: CURSOR l_trolin_csr
2982: IS
2983: SELECT attribute1 ,

Line 2980: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;

2976: FUNCTION query_rows(p_line_id IN NUMBER := fnd_api.g_miss_num)
2977: RETURN inv_move_order_pub.trolin_tbl_type IS
2978:
2979: l_trolin_rec inv_move_order_pub.trolin_rec_type;
2980: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
2981: CURSOR l_trolin_csr
2982: IS
2983: SELECT attribute1 ,
2984: attribute10 ,

Line 3631: p_mo_line_rec inv_move_order_pub.trolin_rec_type ,

3627: PROCEDURE backorder_source( x_return_status OUT NOCOPY VARCHAR2 ,
3628: x_msg_count OUT NOCOPY NUMBER ,
3629: x_msg_data OUT NOCOPY VARCHAR2 ,
3630: p_move_order_type NUMBER ,
3631: p_mo_line_rec inv_move_order_pub.trolin_rec_type ,
3632: p_qty_to_backorder NUMBER ) IS
3633:
3634: l_shipping_attr wsh_interface.changedattributetabtype;
3635: l_released_status VARCHAR2(1);

Line 3764: l_mo_line_rec inv_move_order_pub.trolin_rec_type;

3760: x_return_status OUT NOCOPY VARCHAR2 ,
3761: x_msg_count OUT NOCOPY NUMBER ,
3762: x_msg_data OUT NOCOPY VARCHAR2 ) IS
3763:
3764: l_mo_line_rec inv_move_order_pub.trolin_rec_type;
3765: l_mold_tbl inv_mo_line_detail_util.g_mmtt_tbl_type;
3766: l_mo_type NUMBER;
3767: l_allow_backordering VARCHAR2(1) := 'Y';
3768: l_debug NUMBER;

Line 3986: l_mo_line_rec inv_move_order_pub.trolin_rec_type;

3982: l_task_table WMS_TASK_MGMT_PUB.task_tab_type ;
3983: l_task_rec WMS_TASK_MGMT_PUB.task_output_rectype;
3984: l_transaction_record mtl_material_transactions_temp%rowtype ; --MMTT rec
3985: l_move_order_rec mtl_txn_request_lines%rowtype ; --MTRL rec
3986: l_mo_line_rec inv_move_order_pub.trolin_rec_type;
3987: l_mo_type NUMBER;
3988: l_wdt_count NUMBER;
3989: l_debug NUMBER;
3990: exc_not_deleted EXCEPTION;