eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GME_MOVE_ORDERS_PVT dependencies on GME_COMMON_PVT

Line 46: l_in_trohdr_rec.creation_date := gme_common_pvt.g_timestamp;

42: l_in_trohdr_rec.move_order_type := p_move_order_type;
43: l_in_trohdr_rec.operation := inv_globals.g_opr_create;
44: l_in_trohdr_rec.request_number := fnd_api.g_miss_char;
45: l_in_trohdr_rec.header_id := fnd_api.g_miss_num;
46: l_in_trohdr_rec.creation_date := gme_common_pvt.g_timestamp;
47: l_in_trohdr_rec.created_by := gme_common_pvt.g_user_ident;
48: l_in_trohdr_rec.last_update_date := gme_common_pvt.g_timestamp;
49: l_in_trohdr_rec.last_updated_by := gme_common_pvt.g_user_ident;
50:

Line 47: l_in_trohdr_rec.created_by := gme_common_pvt.g_user_ident;

43: l_in_trohdr_rec.operation := inv_globals.g_opr_create;
44: l_in_trohdr_rec.request_number := fnd_api.g_miss_char;
45: l_in_trohdr_rec.header_id := fnd_api.g_miss_num;
46: l_in_trohdr_rec.creation_date := gme_common_pvt.g_timestamp;
47: l_in_trohdr_rec.created_by := gme_common_pvt.g_user_ident;
48: l_in_trohdr_rec.last_update_date := gme_common_pvt.g_timestamp;
49: l_in_trohdr_rec.last_updated_by := gme_common_pvt.g_user_ident;
50:
51: IF (g_debug IS NOT NULL) THEN

Line 48: l_in_trohdr_rec.last_update_date := gme_common_pvt.g_timestamp;

44: l_in_trohdr_rec.request_number := fnd_api.g_miss_char;
45: l_in_trohdr_rec.header_id := fnd_api.g_miss_num;
46: l_in_trohdr_rec.creation_date := gme_common_pvt.g_timestamp;
47: l_in_trohdr_rec.created_by := gme_common_pvt.g_user_ident;
48: l_in_trohdr_rec.last_update_date := gme_common_pvt.g_timestamp;
49: l_in_trohdr_rec.last_updated_by := gme_common_pvt.g_user_ident;
50:
51: IF (g_debug IS NOT NULL) THEN
52: gme_debug.put_line

Line 49: l_in_trohdr_rec.last_updated_by := gme_common_pvt.g_user_ident;

45: l_in_trohdr_rec.header_id := fnd_api.g_miss_num;
46: l_in_trohdr_rec.creation_date := gme_common_pvt.g_timestamp;
47: l_in_trohdr_rec.created_by := gme_common_pvt.g_user_ident;
48: l_in_trohdr_rec.last_update_date := gme_common_pvt.g_timestamp;
49: l_in_trohdr_rec.last_updated_by := gme_common_pvt.g_user_ident;
50:
51: IF (g_debug IS NOT NULL) THEN
52: gme_debug.put_line
53: ('Calling inv_move_order_pub.create_move_order_header');

Line 112: ,p_material_details_tbl IN gme_common_pvt.material_details_tab

108:
109: PROCEDURE create_move_order_lines (
110: p_move_order_header_id IN NUMBER
111: ,p_move_order_type IN NUMBER
112: ,p_material_details_tbl IN gme_common_pvt.material_details_tab
113: ,x_material_details_tbl OUT NOCOPY gme_common_pvt.material_details_tab
114: ,x_trolin_tbl OUT NOCOPY inv_move_order_pub.trolin_tbl_type
115: ,x_return_status OUT NOCOPY VARCHAR2)
116: IS

Line 113: ,x_material_details_tbl OUT NOCOPY gme_common_pvt.material_details_tab

109: PROCEDURE create_move_order_lines (
110: p_move_order_header_id IN NUMBER
111: ,p_move_order_type IN NUMBER
112: ,p_material_details_tbl IN gme_common_pvt.material_details_tab
113: ,x_material_details_tbl OUT NOCOPY gme_common_pvt.material_details_tab
114: ,x_trolin_tbl OUT NOCOPY inv_move_order_pub.trolin_tbl_type
115: ,x_return_status OUT NOCOPY VARCHAR2)
116: IS
117: l_api_name CONSTANT VARCHAR2 (30) := 'create_move_order_lines';

Line 126: l_material_details_tbl gme_common_pvt.material_details_tab;

122: l_txn_enabled_flag VARCHAR2 (10);
123: l_sec_uom_code VARCHAR2 (10);
124: l_msg_data VARCHAR2 (2000);
125: l_item_no VARCHAR2 (2000);
126: l_material_details_tbl gme_common_pvt.material_details_tab;
127: l_in_trolin_tbl inv_move_order_pub.trolin_tbl_type;
128: l_in_trolin_val_tbl inv_move_order_pub.trolin_val_tbl_type;
129: l_out_trolin_val_tbl inv_move_order_pub.trolin_val_tbl_type;
130: create_mo_line_err EXCEPTION;

Line 179: gme_common_pvt.g_timestamp;

175: l_material_details_tbl (l_count).material_detail_id;
176: l_in_trolin_tbl (l_count).date_required :=
177: l_material_details_tbl (l_count).material_requirement_date;
178: l_in_trolin_tbl (l_count).creation_date :=
179: gme_common_pvt.g_timestamp;
180: l_in_trolin_tbl (l_count).created_by :=
181: gme_common_pvt.g_user_ident;
182: l_in_trolin_tbl (l_count).last_update_date :=
183: gme_common_pvt.g_timestamp;

Line 181: gme_common_pvt.g_user_ident;

177: l_material_details_tbl (l_count).material_requirement_date;
178: l_in_trolin_tbl (l_count).creation_date :=
179: gme_common_pvt.g_timestamp;
180: l_in_trolin_tbl (l_count).created_by :=
181: gme_common_pvt.g_user_ident;
182: l_in_trolin_tbl (l_count).last_update_date :=
183: gme_common_pvt.g_timestamp;
184: l_in_trolin_tbl (l_count).last_updated_by :=
185: gme_common_pvt.g_user_ident;

Line 183: gme_common_pvt.g_timestamp;

179: gme_common_pvt.g_timestamp;
180: l_in_trolin_tbl (l_count).created_by :=
181: gme_common_pvt.g_user_ident;
182: l_in_trolin_tbl (l_count).last_update_date :=
183: gme_common_pvt.g_timestamp;
184: l_in_trolin_tbl (l_count).last_updated_by :=
185: gme_common_pvt.g_user_ident;
186: l_in_trolin_tbl (l_count).transaction_type_id :=
187: gme_common_pvt.g_backflush_transfer;

Line 185: gme_common_pvt.g_user_ident;

181: gme_common_pvt.g_user_ident;
182: l_in_trolin_tbl (l_count).last_update_date :=
183: gme_common_pvt.g_timestamp;
184: l_in_trolin_tbl (l_count).last_updated_by :=
185: gme_common_pvt.g_user_ident;
186: l_in_trolin_tbl (l_count).transaction_type_id :=
187: gme_common_pvt.g_backflush_transfer;
188: l_in_trolin_tbl (l_count).transaction_source_type_id :=
189: gme_common_pvt.g_txn_source_type;

Line 187: gme_common_pvt.g_backflush_transfer;

183: gme_common_pvt.g_timestamp;
184: l_in_trolin_tbl (l_count).last_updated_by :=
185: gme_common_pvt.g_user_ident;
186: l_in_trolin_tbl (l_count).transaction_type_id :=
187: gme_common_pvt.g_backflush_transfer;
188: l_in_trolin_tbl (l_count).transaction_source_type_id :=
189: gme_common_pvt.g_txn_source_type;
190:
191: /* Populate below values only for explicit move orders */

Line 189: gme_common_pvt.g_txn_source_type;

185: gme_common_pvt.g_user_ident;
186: l_in_trolin_tbl (l_count).transaction_type_id :=
187: gme_common_pvt.g_backflush_transfer;
188: l_in_trolin_tbl (l_count).transaction_source_type_id :=
189: gme_common_pvt.g_txn_source_type;
190:
191: /* Populate below values only for explicit move orders */
192: IF (p_move_order_type <> gme_common_pvt.g_invis_move_order_type) THEN
193: l_in_trolin_tbl (l_count).to_subinventory_code :=

Line 192: IF (p_move_order_type <> gme_common_pvt.g_invis_move_order_type) THEN

188: l_in_trolin_tbl (l_count).transaction_source_type_id :=
189: gme_common_pvt.g_txn_source_type;
190:
191: /* Populate below values only for explicit move orders */
192: IF (p_move_order_type <> gme_common_pvt.g_invis_move_order_type) THEN
193: l_in_trolin_tbl (l_count).to_subinventory_code :=
194: l_material_details_tbl (l_count).subinventory;
195: l_in_trolin_tbl (l_count).to_locator_id :=
196: l_material_details_tbl (l_count).locator_id;

Line 202: ,PRECISION => gme_common_pvt.g_precision

198: IF (l_sec_uom_code IS NOT NULL) THEN
199: IF (l_material_details_tbl (l_count).dtl_um <> l_sec_uom_code) THEN
200: l_temp_qty := inv_convert.inv_um_convert
201: (item_id => l_material_details_tbl (l_count).inventory_item_id
202: ,PRECISION => gme_common_pvt.g_precision
203: ,from_quantity => l_material_details_tbl (l_count).plan_qty
204: ,from_unit => l_material_details_tbl (l_count).dtl_um
205: ,to_unit => l_sec_uom_code
206: ,from_name => NULL

Line 262: IF (p_move_order_type = gme_common_pvt.g_invis_move_order_type) THEN

258: || x_trolin_tbl.COUNT);
259: END IF;
260:
261: /* Populate out structure only for invisible move order */
262: IF (p_move_order_type = gme_common_pvt.g_invis_move_order_type) THEN
263: FOR i IN 1 .. l_material_details_tbl.COUNT LOOP
264: l_material_details_tbl (i).move_order_line_id :=
265: x_trolin_tbl (i).line_id;
266: x_material_details_tbl (x_material_details_tbl.COUNT + 1) :=

Line 308: ,p_material_details_tbl IN gme_common_pvt.material_details_tab

304: END create_move_order_lines;
305:
306: PROCEDURE create_batch_move_order (
307: p_batch_header_rec IN gme_batch_header%ROWTYPE
308: ,p_material_details_tbl IN gme_common_pvt.material_details_tab
309: ,x_return_status OUT NOCOPY VARCHAR2)
310: IS
311: l_api_name CONSTANT VARCHAR2 (30) := 'create_batch_move_order';
312: l_return_status VARCHAR2 (1);

Line 321: l_mtl_dtl_tbl gme_common_pvt.material_details_tab;

317: l_mtl_txns_enabled_flag mtl_system_items_kfv.mtl_transactions_enabled_flag%TYPE;
318: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%TYPE;
319: l_primary_uom_code mtl_system_items_kfv.primary_uom_code%TYPE;
320:
321: l_mtl_dtl_tbl gme_common_pvt.material_details_tab;
322: l_mtl_dtl_tbl_out gme_common_pvt.material_details_tab;
323: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
324: l_is_revision_control BOOLEAN;
325: l_is_lot_control BOOLEAN;

Line 322: l_mtl_dtl_tbl_out gme_common_pvt.material_details_tab;

318: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%TYPE;
319: l_primary_uom_code mtl_system_items_kfv.primary_uom_code%TYPE;
320:
321: l_mtl_dtl_tbl gme_common_pvt.material_details_tab;
322: l_mtl_dtl_tbl_out gme_common_pvt.material_details_tab;
323: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
324: l_is_revision_control BOOLEAN;
325: l_is_lot_control BOOLEAN;
326: l_is_serial_control BOOLEAN;

Line 365: (SYSDATE + NVL (gme_common_pvt.g_move_order_timefence, 0) ) ) THEN

361: FOR i IN 1 .. p_material_details_tbl.COUNT LOOP
362: IF ( p_material_details_tbl (i).line_type = -1
363: AND p_material_details_tbl (i).subinventory IS NOT NULL
364: AND p_material_details_tbl (i).material_requirement_date <
365: (SYSDATE + NVL (gme_common_pvt.g_move_order_timefence, 0) ) ) THEN
366: OPEN cur_get_item_info
367: (p_material_details_tbl (i).organization_id
368: ,p_material_details_tbl (i).inventory_item_id);
369:

Line 383: ,p_tree_mode => gme_common_pvt.g_tree_transaction_mode

379: ,p_organization_id => p_material_details_tbl
380: (i).organization_id
381: ,p_inventory_item_id => p_material_details_tbl
382: (i).inventory_item_id
383: ,p_tree_mode => gme_common_pvt.g_tree_transaction_mode
384: ,p_grade_code => NULL
385: ,p_demand_source_header_id => p_material_details_tbl
386: (i).batch_id
387: ,p_demand_source_line_id => p_material_details_tbl

Line 421: ,PRECISION => gme_common_pvt.g_precision

417: p_material_details_tbl (i).dtl_um) THEN
418: l_plan_qty_prim :=
419: inv_convert.inv_um_convert
420: (item_id => p_material_details_tbl (i).inventory_item_id
421: ,PRECISION => gme_common_pvt.g_precision
422: ,from_quantity => p_material_details_tbl (i).plan_qty
423: ,from_unit => p_material_details_tbl (i).dtl_um
424: ,to_unit => l_primary_uom_code
425: ,from_name => NULL

Line 451: ,PRECISION => gme_common_pvt.g_precision

447: l_mtl_dtl_tbl (l_count).plan_qty :=
448: inv_convert.inv_um_convert
449: (item_id => p_material_details_tbl
450: (i).inventory_item_id
451: ,PRECISION => gme_common_pvt.g_precision
452: ,from_quantity => l_diff_qty
453: ,from_unit => l_primary_uom_code
454: ,to_unit => p_material_details_tbl
455: (i).dtl_um

Line 471: ,p_move_order_type => gme_common_pvt.g_move_order_type

467: END LOOP;
468: IF (l_count > 0) THEN
469: gme_move_orders_pvt.create_move_order_hdr
470: (p_organization_id => p_batch_header_rec.organization_id
471: ,p_move_order_type => gme_common_pvt.g_move_order_type
472: ,x_move_order_header_id => l_move_order_header_id
473: ,x_return_status => l_return_status);
474:
475: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

Line 480: ,p_move_order_type => gme_common_pvt.g_move_order_type

476: RAISE create_mo_err;
477: ELSE
478: gme_move_orders_pvt.create_move_order_lines
479: (p_move_order_header_id => l_move_order_header_id
480: ,p_move_order_type => gme_common_pvt.g_move_order_type
481: ,p_material_details_tbl => l_mtl_dtl_tbl
482: ,x_material_details_tbl => l_mtl_dtl_tbl_out
483: ,x_trolin_tbl => l_trolin_tbl
484: ,x_return_status => l_return_status);

Line 522: ,x_mo_line_tbl OUT NOCOPY gme_common_pvt.mo_lines_tab

518: PROCEDURE get_move_order_lines (
519: p_organization_id IN NUMBER
520: ,p_batch_id IN NUMBER
521: ,p_material_detail_id IN NUMBER
522: ,x_mo_line_tbl OUT NOCOPY gme_common_pvt.mo_lines_tab
523: ,x_return_status OUT NOCOPY VARCHAR2)
524: IS
525: l_api_name CONSTANT VARCHAR2 (30) := 'get_move_order_lines';
526:

Line 533: gme_common_pvt.g_txn_source_type

529: SELECT l.*
530: FROM mtl_txn_request_lines l, mtl_txn_request_headers h
531: WHERE l.organization_id = p_organization_id
532: AND transaction_source_type_id =
533: gme_common_pvt.g_txn_source_type
534: AND l.txn_source_id = p_batch_id
535: AND l.txn_source_line_id = p_material_detail_id
536: AND l.line_status NOT IN (5, 6)
537: AND h.header_id = l.header_id

Line 539: (gme_common_pvt.g_invis_move_order_type

535: AND l.txn_source_line_id = p_material_detail_id
536: AND l.line_status NOT IN (5, 6)
537: AND h.header_id = l.header_id
538: AND h.move_order_type NOT IN
539: (gme_common_pvt.g_invis_move_order_type
540: ,inv_globals.g_move_order_put_away)
541: ORDER BY l.header_id, l.line_id;
542: BEGIN
543: IF g_debug <= gme_debug.g_log_procedure THEN

Line 597: l_line_tbl gme_common_pvt.mo_lines_tab;

593: l_trolin_val_tbl inv_move_order_pub.trolin_val_tbl_type;
594: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
595: l_old_trolin_tbl inv_move_order_pub.trolin_tbl_type;
596: l_out_trolin_tbl inv_move_order_pub.trolin_tbl_type;
597: l_line_tbl gme_common_pvt.mo_lines_tab;
598: delete_mo_line_err EXCEPTION;
599: delete_mo_hdr_err EXCEPTION;
600: get_mo_line_err EXCEPTION;
601:

Line 772: gme_common_pvt.g_txn_source_type

768: IS
769: SELECT l.*
770: FROM mtl_txn_request_lines l, mtl_txn_request_headers h
771: WHERE transaction_source_type_id =
772: gme_common_pvt.g_txn_source_type
773: AND l.txn_source_id = p_batch_id
774: AND l.txn_source_line_id = p_material_detail_id
775: AND l.line_status NOT IN (5, 6)
776: AND h.header_id = l.header_id

Line 778: (gme_common_pvt.g_invis_move_order_type

774: AND l.txn_source_line_id = p_material_detail_id
775: AND l.line_status NOT IN (5, 6)
776: AND h.header_id = l.header_id
777: AND h.move_order_type NOT IN
778: (gme_common_pvt.g_invis_move_order_type
779: ,inv_globals.g_move_order_put_away)
780: ORDER BY l.creation_date DESC;
781:
782: TYPE line_tab IS TABLE OF mtl_txn_request_lines%ROWTYPE

Line 968: AND h.move_order_type = gme_common_pvt.g_move_order_type

964: AND l.txn_source_line_id = p_material_detail_id
965: AND l.organization_id = p_organization_id
966: AND l.line_status NOT IN (5, 6)
967: AND h.header_id = l.header_id
968: AND h.move_order_type = gme_common_pvt.g_move_order_type
969: AND ROWNUM = 1;
970: BEGIN
971: IF g_debug <= gme_debug.g_log_procedure THEN
972: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

Line 1020: l_line_tbl gme_common_pvt.mo_lines_tab;

1016: l_from_uom VARCHAR2 (3);
1017: l_to_uom VARCHAR2 (3);
1018: l_item_no VARCHAR2 (2000);
1019: l_temp_qty NUMBER;
1020: l_line_tbl gme_common_pvt.mo_lines_tab;
1021:
1022: CURSOR cur_item_uoms (v_org_id NUMBER, v_inventory_item_id NUMBER)
1023: IS
1024: SELECT primary_uom_code, secondary_uom_code, concatenated_segments

Line 1069: ,PRECISION => gme_common_pvt.g_precision

1065: ELSE
1066: l_temp_qty :=
1067: inv_convert.inv_um_convert
1068: (item_id => l_line_tbl (i).inventory_item_id
1069: ,PRECISION => gme_common_pvt.g_precision
1070: ,from_quantity => l_line_tbl (i).quantity
1071: ,from_unit => l_line_tbl (i).uom_code
1072: ,to_unit => p_mtl_dtl_rec.dtl_um
1073: ,from_name => NULL

Line 1130: AND d.line_type = gme_common_pvt.g_line_type_ing;

1126: FROM gme_batch_header h, gme_material_details d
1127: WHERE h.organization_id = p_organization_id
1128: AND h.batch_id = p_batch_id
1129: AND d.batch_id = h.batch_id
1130: AND d.line_type = gme_common_pvt.g_line_type_ing;
1131:
1132: TYPE lines_tab IS TABLE OF cur_batch_lines%ROWTYPE
1133: INDEX BY BINARY_INTEGER;
1134: