DBA Data[Home] [Help]

APPS.WMS_TASK_MGMT_PUB dependencies on INV_MOVE_ORDER_PUB

Line 3066: RETURN inv_move_order_pub.trolin_tbl_type IS

3062: This function gets the move order record for the move order line passed.
3063: */
3064: -------------------------------------------------------------------------------------------------------------------
3065: FUNCTION query_rows(p_line_id IN NUMBER := fnd_api.g_miss_num)
3066: RETURN inv_move_order_pub.trolin_tbl_type IS
3067:
3068: l_trolin_rec inv_move_order_pub.trolin_rec_type;
3069: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
3070: CURSOR l_trolin_csr

Line 3068: l_trolin_rec inv_move_order_pub.trolin_rec_type;

3064: -------------------------------------------------------------------------------------------------------------------
3065: FUNCTION query_rows(p_line_id IN NUMBER := fnd_api.g_miss_num)
3066: RETURN inv_move_order_pub.trolin_tbl_type IS
3067:
3068: l_trolin_rec inv_move_order_pub.trolin_rec_type;
3069: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
3070: CURSOR l_trolin_csr
3071: IS
3072: SELECT attribute1 ,

Line 3069: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;

3065: FUNCTION query_rows(p_line_id IN NUMBER := fnd_api.g_miss_num)
3066: RETURN inv_move_order_pub.trolin_tbl_type IS
3067:
3068: l_trolin_rec inv_move_order_pub.trolin_rec_type;
3069: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
3070: CURSOR l_trolin_csr
3071: IS
3072: SELECT attribute1 ,
3073: attribute10 ,

Line 3720: p_mo_line_rec inv_move_order_pub.trolin_rec_type ,

3716: PROCEDURE backorder_source( x_return_status OUT NOCOPY VARCHAR2 ,
3717: x_msg_count OUT NOCOPY NUMBER ,
3718: x_msg_data OUT NOCOPY VARCHAR2 ,
3719: p_move_order_type NUMBER ,
3720: p_mo_line_rec inv_move_order_pub.trolin_rec_type ,
3721: p_qty_to_backorder NUMBER ) IS
3722:
3723: l_shipping_attr wsh_interface.changedattributetabtype;
3724: l_released_status VARCHAR2(1);

Line 3853: l_mo_line_rec inv_move_order_pub.trolin_rec_type;

3849: x_return_status OUT NOCOPY VARCHAR2 ,
3850: x_msg_count OUT NOCOPY NUMBER ,
3851: x_msg_data OUT NOCOPY VARCHAR2 ) IS
3852:
3853: l_mo_line_rec inv_move_order_pub.trolin_rec_type;
3854: l_mold_tbl inv_mo_line_detail_util.g_mmtt_tbl_type;
3855: l_mo_type NUMBER;
3856: l_allow_backordering VARCHAR2(1) := 'Y';
3857: l_debug NUMBER;

Line 4075: l_mo_line_rec inv_move_order_pub.trolin_rec_type;

4071: l_task_table WMS_TASK_MGMT_PUB.task_tab_type ;
4072: l_task_rec WMS_TASK_MGMT_PUB.task_output_rectype;
4073: l_transaction_record mtl_material_transactions_temp%rowtype ; --MMTT rec
4074: l_move_order_rec mtl_txn_request_lines%rowtype ; --MTRL rec
4075: l_mo_line_rec inv_move_order_pub.trolin_rec_type;
4076: l_mo_type NUMBER;
4077: l_wdt_count NUMBER;
4078: l_debug NUMBER;
4079: exc_not_deleted EXCEPTION;