DBA Data[Home] [Help]

APPS.WMS_REPLENISHMENT_PVT dependencies on WSH_UTIL_CORE

Line 10: g_backorder_deliv_tab WSH_UTIL_CORE.ID_TAB_TYPE;

6: g_ordered_psr psrTabTyp;
7: g_total_pick_criteria NUMBER := 5;
8: g_conversion_precision NUMBER := 5;
9:
10: g_backorder_deliv_tab WSH_UTIL_CORE.ID_TAB_TYPE;
11: g_backorder_qty_tab WSH_UTIL_CORE.ID_TAB_TYPE;
12: g_dummy_table WSH_UTIL_CORE.ID_TAB_TYPE;
13:
14: -- replenishment Type

Line 11: g_backorder_qty_tab WSH_UTIL_CORE.ID_TAB_TYPE;

7: g_total_pick_criteria NUMBER := 5;
8: g_conversion_precision NUMBER := 5;
9:
10: g_backorder_deliv_tab WSH_UTIL_CORE.ID_TAB_TYPE;
11: g_backorder_qty_tab WSH_UTIL_CORE.ID_TAB_TYPE;
12: g_dummy_table WSH_UTIL_CORE.ID_TAB_TYPE;
13:
14: -- replenishment Type
15: g_push_repl NUMBER := 1;

Line 12: g_dummy_table WSH_UTIL_CORE.ID_TAB_TYPE;

8: g_conversion_precision NUMBER := 5;
9:
10: g_backorder_deliv_tab WSH_UTIL_CORE.ID_TAB_TYPE;
11: g_backorder_qty_tab WSH_UTIL_CORE.ID_TAB_TYPE;
12: g_dummy_table WSH_UTIL_CORE.ID_TAB_TYPE;
13:
14: -- replenishment Type
15: g_push_repl NUMBER := 1;
16: g_dynamic_repl NUMBER := 2;

Line 343: l_out_rows WSH_UTIL_CORE.ID_TAB_TYPE;

339: l_msg_data VARCHAR2(1000);
340: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
341:
342: -- for backordering
343: l_out_rows WSH_UTIL_CORE.ID_TAB_TYPE;
344: l_backorder_deliv_tab WSH_UTIL_CORE.ID_TAB_TYPE;
345: l_backorder_qty_tab WSH_UTIL_CORE.ID_TAB_TYPE;
346: l_dummy_table WSH_UTIL_CORE.ID_TAB_TYPE;
347: BEGIN

Line 344: l_backorder_deliv_tab WSH_UTIL_CORE.ID_TAB_TYPE;

340: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
341:
342: -- for backordering
343: l_out_rows WSH_UTIL_CORE.ID_TAB_TYPE;
344: l_backorder_deliv_tab WSH_UTIL_CORE.ID_TAB_TYPE;
345: l_backorder_qty_tab WSH_UTIL_CORE.ID_TAB_TYPE;
346: l_dummy_table WSH_UTIL_CORE.ID_TAB_TYPE;
347: BEGIN
348:

Line 345: l_backorder_qty_tab WSH_UTIL_CORE.ID_TAB_TYPE;

341:
342: -- for backordering
343: l_out_rows WSH_UTIL_CORE.ID_TAB_TYPE;
344: l_backorder_deliv_tab WSH_UTIL_CORE.ID_TAB_TYPE;
345: l_backorder_qty_tab WSH_UTIL_CORE.ID_TAB_TYPE;
346: l_dummy_table WSH_UTIL_CORE.ID_TAB_TYPE;
347: BEGIN
348:
349: IF (l_debug = 1) THEN

Line 346: l_dummy_table WSH_UTIL_CORE.ID_TAB_TYPE;

342: -- for backordering
343: l_out_rows WSH_UTIL_CORE.ID_TAB_TYPE;
344: l_backorder_deliv_tab WSH_UTIL_CORE.ID_TAB_TYPE;
345: l_backorder_qty_tab WSH_UTIL_CORE.ID_TAB_TYPE;
346: l_dummy_table WSH_UTIL_CORE.ID_TAB_TYPE;
347: BEGIN
348:
349: IF (l_debug = 1) THEN
350: print_debug('Updating Repl status of delivery_detail :'||p_deliv_detail_id

Line 688: l_out_rows WSH_UTIL_CORE.ID_TAB_TYPE;

684: )
685: IS
686: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
687: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
688: l_out_rows WSH_UTIL_CORE.ID_TAB_TYPE;
689: BEGIN
690:
691: IF (l_debug = 1) THEN
692: print_debug( 'Calling Shipping API to backorder all unment demand lines during Replenishment');

Line 787: l_detail_id_tab WSH_UTIL_CORE.id_tab_type;

783: l_detail_info_tab WSH_INTERFACE_EXT_GRP.delivery_details_Attr_tbl_Type;
784: l_in_rec WSH_INTERFACE_EXT_GRP.detailInRecType;
785: l_out_rec WSH_INTERFACE_EXT_GRP.detailOutRecType;
786:
787: l_detail_id_tab WSH_UTIL_CORE.id_tab_type;
788: l_action_prms WSH_GLBL_VAR_STRCT_GRP.dd_action_parameters_rec_type;
789: l_action_out_rec WSH_GLBL_VAR_STRCT_GRP.dd_action_out_rec_type;
790:
791: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;