DBA Data[Home] [Help]

APPS.WMS_PUTAWAY_UTILS dependencies on WSH_UTIL_CORE

Line 121: g_line_rows WSH_UTIL_CORE.id_tab_type;

117: -- Task Record
118: SUBTYPE task_rec IS wms_dispatched_tasks%ROWTYPE;
119:
120: --Added for bug 5286880
121: g_line_rows WSH_UTIL_CORE.id_tab_type;
122: g_grouping_rows WSH_UTIL_CORE.id_tab_type;
123:
124:
125: /**

Line 122: g_grouping_rows WSH_UTIL_CORE.id_tab_type;

118: SUBTYPE task_rec IS wms_dispatched_tasks%ROWTYPE;
119:
120: --Added for bug 5286880
121: g_line_rows WSH_UTIL_CORE.id_tab_type;
122: g_grouping_rows WSH_UTIL_CORE.id_tab_type;
123:
124:
125: /**
126: * This procedure will call the inv_log_util package to log the messages

Line 12316: v_line_rows WSH_UTIL_CORE.id_tab_type;

12312: l_lpn_has_material NUMBER;
12313: --BUG#11769042
12314: l_bo_d_frm_id NUMBER;
12315: l_bo_d_to_id NUMBER;
12316: v_line_rows WSH_UTIL_CORE.id_tab_type;
12317: v_grouping_rows WSH_UTIL_CORE.id_tab_type;
12318: l_return_status VARCHAR2(1);
12319: --BUG#11769042
12320:

Line 12317: v_grouping_rows WSH_UTIL_CORE.id_tab_type;

12313: --BUG#11769042
12314: l_bo_d_frm_id NUMBER;
12315: l_bo_d_to_id NUMBER;
12316: v_line_rows WSH_UTIL_CORE.id_tab_type;
12317: v_grouping_rows WSH_UTIL_CORE.id_tab_type;
12318: l_return_status VARCHAR2(1);
12319: --BUG#11769042
12320:
12321: BEGIN

Line 14564: l_non_so_lines WSH_UTIL_CORE.id_tab_type; --9505772-This table will hold non-so lines

14560: l_progress NUMBER;
14561: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
14562: l_proc_name VARCHAR2(30) := 'populate_grouping_rows';
14563: l_xdock_type NUMBER; --Bug#6968476
14564: l_non_so_lines WSH_UTIL_CORE.id_tab_type; --9505772-This table will hold non-so lines
14565: BEGIN
14566:
14567: g_line_rows.delete; --This table will hold So lines
14568: g_grouping_rows.delete;

Line 14637: (p_line_rows IN WSH_UTIL_CORE.id_tab_type)

14633: RETURN g_grouping_rows.COUNT;
14634: END populate_grouping_rows;
14635:
14636: FUNCTION get_grouping_count
14637: (p_line_rows IN WSH_UTIL_CORE.id_tab_type)
14638: RETURN NUMBER IS
14639:
14640: l_count NUMBER;
14641: l_bo_dd_id NUMBER := -1;

Line 14646: l_line_rows WSH_UTIL_CORE.id_tab_type;

14642: l_duplicate NUMBER := 0;
14643: l_progress NUMBER;
14644: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
14645: l_proc_name VARCHAR2(30) := 'get_grouping_count';
14646: l_line_rows WSH_UTIL_CORE.id_tab_type;
14647: l_temp NUMBER;
14648:
14649: BEGIN
14650: l_line_rows := p_line_rows ; --9695544