DBA Data[Home] [Help]

APPS.GME_PICKING_PVT dependencies on GME_PICKING_PVT

Line 1: PACKAGE BODY gme_picking_pvt AS

1: PACKAGE BODY gme_picking_pvt AS
2: /* $Header: GMEVPCKB.pls 120.7.12010000.2 2008/11/06 03:30:08 srpuri ship $ */
3: g_debug VARCHAR2 (5) := fnd_profile.VALUE ('AFLOG_LEVEL');
4: g_pkg_name CONSTANT VARCHAR2 (30) := 'GME_PICKING_PVT';
5: g_partially_allocated BOOLEAN := FALSE;

Line 4: g_pkg_name CONSTANT VARCHAR2 (30) := 'GME_PICKING_PVT';

1: PACKAGE BODY gme_picking_pvt AS
2: /* $Header: GMEVPCKB.pls 120.7.12010000.2 2008/11/06 03:30:08 srpuri ship $ */
3: g_debug VARCHAR2 (5) := fnd_profile.VALUE ('AFLOG_LEVEL');
4: g_pkg_name CONSTANT VARCHAR2 (30) := 'GME_PICKING_PVT';
5: g_partially_allocated BOOLEAN := FALSE;
6: g_fully_allocated BOOLEAN := FALSE;
7: g_not_allocated BOOLEAN := FALSE;
8:

Line 57: l_mat_req_tbl gme_picking_pvt.mtl_req_tab;

53: TYPE l_picking_tab IS TABLE OF gme_ingred_pick_vw%ROWTYPE
54: INDEX BY BINARY_INTEGER;
55:
56: l_picking_tbl l_picking_tab;
57: l_mat_req_tbl gme_picking_pvt.mtl_req_tab;
58: build_where_err EXCEPTION;
59: pick_material_err EXCEPTION;
60:
61: /* Bug 5212556 Added the following ref cursor etc */

Line 136: gme_picking_pvt.pick_material

132: l_mat_req_tbl (i).mtl_req_date :=
133: l_picking_tbl (i).material_requirement_date;
134: END LOOP;
135:
136: gme_picking_pvt.pick_material
137: (p_mtl_req_tbl => l_mat_req_tbl
138: ,p_task_group_id => TO_NUMBER
139: (p_pick_grouping_rule)
140: ,p_print_pick_slip => p_print_pick_slip

Line 243: p_mtl_req_tbl IN gme_picking_pvt.mtl_req_tab

239: RETURN 0;
240: END get_open_qty;
241:
242: PROCEDURE pick_material (
243: p_mtl_req_tbl IN gme_picking_pvt.mtl_req_tab
244: ,p_task_group_id IN NUMBER
245: ,p_print_pick_slip IN VARCHAR2 DEFAULT 'N'
246: ,p_plan_tasks IN VARCHAR2 DEFAULT 'N'
247: ,x_return_status OUT NOCOPY VARCHAR2

Line 422: gme_picking_pvt.process_line (p_mo_line_rec => l_trolin_tbl

418: inv_trolin_util.query_row (l_pend_lines_tbl (i).line_id);
419: END LOOP;
420:
421: FOR i IN 1 .. l_trolin_tbl.COUNT LOOP
422: gme_picking_pvt.process_line (p_mo_line_rec => l_trolin_tbl
423: (i)
424: ,p_grouping_rule_id => p_task_group_id
425: ,p_plan_tasks => p_plan_tasks
426: ,x_return_status => l_return_status);

Line 922: END gme_picking_pvt;

918: END IF;
919:
920: x_return_status := fnd_api.g_ret_sts_unexp_error;
921: END process_line;
922: END gme_picking_pvt;