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.16.12020000.3 2013/01/30 15:42:45 gmurator 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.16.12020000.3 2013/01/30 15:42:45 gmurator 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 76: l_mat_req_tbl gme_picking_pvt.mtl_req_tab;

72: TYPE l_picking_tab IS TABLE OF gme_ingred_pick_vw%ROWTYPE
73: INDEX BY BINARY_INTEGER;
74:
75: l_picking_tbl l_picking_tab;
76: l_mat_req_tbl gme_picking_pvt.mtl_req_tab;
77: build_where_err EXCEPTION;
78: pick_material_err EXCEPTION;
79:
80: /* Bug 5212556 Added the following ref cursor etc */

Line 155: gme_picking_pvt.pick_material

151: l_mat_req_tbl (i).mtl_req_date :=
152: l_picking_tbl (i).material_requirement_date;
153: END LOOP;
154:
155: gme_picking_pvt.pick_material
156: (p_mtl_req_tbl => l_mat_req_tbl
157: ,p_task_group_id => TO_NUMBER
158: (p_pick_grouping_rule)
159: ,p_print_pick_slip => p_print_pick_slip

Line 268: p_mtl_req_tbl IN gme_picking_pvt.mtl_req_tab

264: RETURN 0;
265: END get_open_qty;
266:
267: PROCEDURE pick_material (
268: p_mtl_req_tbl IN gme_picking_pvt.mtl_req_tab
269: ,p_task_group_id IN NUMBER
270: ,p_print_pick_slip IN VARCHAR2 DEFAULT 'N'
271: ,p_plan_tasks IN VARCHAR2 DEFAULT 'N'
272: ,x_return_status OUT NOCOPY VARCHAR2

Line 552: gme_picking_pvt.process_line (p_mo_line_rec => l_trolin_tbl

548: inv_trolin_util.query_row (l_pend_lines_tbl (i).line_id);
549: END LOOP;
550:
551: FOR i IN 1 .. l_trolin_tbl.COUNT LOOP
552: gme_picking_pvt.process_line (p_mo_line_rec => l_trolin_tbl
553: (i)
554: ,p_grouping_rule_id => p_task_group_id
555: ,p_plan_tasks => p_plan_tasks
556: ,x_return_status => l_return_status);

Line 1225: END gme_picking_pvt;

1221: END IF;
1222:
1223: x_return_status := fnd_api.g_ret_sts_unexp_error;
1224: END process_line;
1225: END gme_picking_pvt;