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
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;
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;
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
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:
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
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
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');
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;