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 69: l_in_trohdr_rec.creation_date := gme_common_pvt.g_timestamp;

65: l_in_trohdr_rec.move_order_type := p_move_order_type;
66: l_in_trohdr_rec.operation := inv_globals.g_opr_create;
67: l_in_trohdr_rec.request_number := fnd_api.g_miss_char;
68: l_in_trohdr_rec.header_id := fnd_api.g_miss_num;
69: l_in_trohdr_rec.creation_date := gme_common_pvt.g_timestamp;
70: l_in_trohdr_rec.created_by := gme_common_pvt.g_user_ident;
71: l_in_trohdr_rec.last_update_date := gme_common_pvt.g_timestamp;
72: l_in_trohdr_rec.last_updated_by := gme_common_pvt.g_user_ident;
73:

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

66: l_in_trohdr_rec.operation := inv_globals.g_opr_create;
67: l_in_trohdr_rec.request_number := fnd_api.g_miss_char;
68: l_in_trohdr_rec.header_id := fnd_api.g_miss_num;
69: l_in_trohdr_rec.creation_date := gme_common_pvt.g_timestamp;
70: l_in_trohdr_rec.created_by := gme_common_pvt.g_user_ident;
71: l_in_trohdr_rec.last_update_date := gme_common_pvt.g_timestamp;
72: l_in_trohdr_rec.last_updated_by := gme_common_pvt.g_user_ident;
73:
74: -- Bug 9941121 - Initialize grouping_rule_id properly.

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

67: l_in_trohdr_rec.request_number := fnd_api.g_miss_char;
68: l_in_trohdr_rec.header_id := fnd_api.g_miss_num;
69: l_in_trohdr_rec.creation_date := gme_common_pvt.g_timestamp;
70: l_in_trohdr_rec.created_by := gme_common_pvt.g_user_ident;
71: l_in_trohdr_rec.last_update_date := gme_common_pvt.g_timestamp;
72: l_in_trohdr_rec.last_updated_by := gme_common_pvt.g_user_ident;
73:
74: -- Bug 9941121 - Initialize grouping_rule_id properly.
75: l_in_trohdr_rec.grouping_rule_id := p_grouping_rule_id;

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

68: l_in_trohdr_rec.header_id := fnd_api.g_miss_num;
69: l_in_trohdr_rec.creation_date := gme_common_pvt.g_timestamp;
70: l_in_trohdr_rec.created_by := gme_common_pvt.g_user_ident;
71: l_in_trohdr_rec.last_update_date := gme_common_pvt.g_timestamp;
72: l_in_trohdr_rec.last_updated_by := gme_common_pvt.g_user_ident;
73:
74: -- Bug 9941121 - Initialize grouping_rule_id properly.
75: l_in_trohdr_rec.grouping_rule_id := p_grouping_rule_id;
76:

Line 138: ,p_material_details_tbl IN gme_common_pvt.material_details_tab

134:
135: PROCEDURE create_move_order_lines (
136: p_move_order_header_id IN NUMBER
137: ,p_move_order_type IN NUMBER
138: ,p_material_details_tbl IN gme_common_pvt.material_details_tab
139: ,x_material_details_tbl OUT NOCOPY gme_common_pvt.material_details_tab
140: ,x_trolin_tbl OUT NOCOPY inv_move_order_pub.trolin_tbl_type
141: ,x_return_status OUT NOCOPY VARCHAR2)
142: IS

Line 139: ,x_material_details_tbl OUT NOCOPY gme_common_pvt.material_details_tab

135: PROCEDURE create_move_order_lines (
136: p_move_order_header_id IN NUMBER
137: ,p_move_order_type IN NUMBER
138: ,p_material_details_tbl IN gme_common_pvt.material_details_tab
139: ,x_material_details_tbl OUT NOCOPY gme_common_pvt.material_details_tab
140: ,x_trolin_tbl OUT NOCOPY inv_move_order_pub.trolin_tbl_type
141: ,x_return_status OUT NOCOPY VARCHAR2)
142: IS
143: l_api_name CONSTANT VARCHAR2 (30) := 'create_move_order_lines';

Line 152: l_material_details_tbl gme_common_pvt.material_details_tab;

148: l_txn_enabled_flag VARCHAR2 (10);
149: l_sec_uom_code VARCHAR2 (10);
150: l_msg_data VARCHAR2 (2000);
151: l_item_no VARCHAR2 (2000);
152: l_material_details_tbl gme_common_pvt.material_details_tab;
153: l_in_trolin_tbl inv_move_order_pub.trolin_tbl_type;
154: l_in_trolin_val_tbl inv_move_order_pub.trolin_val_tbl_type;
155: l_out_trolin_val_tbl inv_move_order_pub.trolin_val_tbl_type;
156: create_mo_line_err EXCEPTION;

Line 215: gme_common_pvt.g_timestamp;

211: l_material_details_tbl (l_count).material_detail_id;
212: l_in_trolin_tbl (l_count).date_required :=
213: l_material_details_tbl (l_count).material_requirement_date;
214: l_in_trolin_tbl (l_count).creation_date :=
215: gme_common_pvt.g_timestamp;
216: l_in_trolin_tbl (l_count).created_by :=
217: gme_common_pvt.g_user_ident;
218: l_in_trolin_tbl (l_count).last_update_date :=
219: gme_common_pvt.g_timestamp;

Line 217: gme_common_pvt.g_user_ident;

213: l_material_details_tbl (l_count).material_requirement_date;
214: l_in_trolin_tbl (l_count).creation_date :=
215: gme_common_pvt.g_timestamp;
216: l_in_trolin_tbl (l_count).created_by :=
217: gme_common_pvt.g_user_ident;
218: l_in_trolin_tbl (l_count).last_update_date :=
219: gme_common_pvt.g_timestamp;
220: l_in_trolin_tbl (l_count).last_updated_by :=
221: gme_common_pvt.g_user_ident;

Line 219: gme_common_pvt.g_timestamp;

215: gme_common_pvt.g_timestamp;
216: l_in_trolin_tbl (l_count).created_by :=
217: gme_common_pvt.g_user_ident;
218: l_in_trolin_tbl (l_count).last_update_date :=
219: gme_common_pvt.g_timestamp;
220: l_in_trolin_tbl (l_count).last_updated_by :=
221: gme_common_pvt.g_user_ident;
222: l_in_trolin_tbl (l_count).transaction_type_id :=
223: gme_common_pvt.g_backflush_transfer;

Line 221: gme_common_pvt.g_user_ident;

217: gme_common_pvt.g_user_ident;
218: l_in_trolin_tbl (l_count).last_update_date :=
219: gme_common_pvt.g_timestamp;
220: l_in_trolin_tbl (l_count).last_updated_by :=
221: gme_common_pvt.g_user_ident;
222: l_in_trolin_tbl (l_count).transaction_type_id :=
223: gme_common_pvt.g_backflush_transfer;
224: l_in_trolin_tbl (l_count).transaction_source_type_id :=
225: gme_common_pvt.g_txn_source_type;

Line 223: gme_common_pvt.g_backflush_transfer;

219: gme_common_pvt.g_timestamp;
220: l_in_trolin_tbl (l_count).last_updated_by :=
221: gme_common_pvt.g_user_ident;
222: l_in_trolin_tbl (l_count).transaction_type_id :=
223: gme_common_pvt.g_backflush_transfer;
224: l_in_trolin_tbl (l_count).transaction_source_type_id :=
225: gme_common_pvt.g_txn_source_type;
226:
227: /* Populate below values only for explicit move orders */

Line 225: gme_common_pvt.g_txn_source_type;

221: gme_common_pvt.g_user_ident;
222: l_in_trolin_tbl (l_count).transaction_type_id :=
223: gme_common_pvt.g_backflush_transfer;
224: l_in_trolin_tbl (l_count).transaction_source_type_id :=
225: gme_common_pvt.g_txn_source_type;
226:
227: /* Populate below values only for explicit move orders */
228: IF (p_move_order_type <> gme_common_pvt.g_invis_move_order_type) THEN
229: l_in_trolin_tbl (l_count).to_subinventory_code :=

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

224: l_in_trolin_tbl (l_count).transaction_source_type_id :=
225: gme_common_pvt.g_txn_source_type;
226:
227: /* Populate below values only for explicit move orders */
228: IF (p_move_order_type <> gme_common_pvt.g_invis_move_order_type) THEN
229: l_in_trolin_tbl (l_count).to_subinventory_code :=
230: l_material_details_tbl (l_count).subinventory;
231: l_in_trolin_tbl (l_count).to_locator_id :=
232: l_material_details_tbl (l_count).locator_id;

Line 252: ,PRECISION => gme_common_pvt.g_precision

248: IF (l_sec_uom_code IS NOT NULL) THEN
249: IF (l_material_details_tbl (l_count).dtl_um <> l_sec_uom_code) THEN
250: l_temp_qty := inv_convert.inv_um_convert
251: (item_id => l_material_details_tbl (l_count).inventory_item_id
252: ,PRECISION => gme_common_pvt.g_precision
253: ,from_quantity => l_material_details_tbl (l_count).plan_qty
254: ,from_unit => l_material_details_tbl (l_count).dtl_um
255: ,to_unit => l_sec_uom_code
256: ,from_name => NULL

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

308: || x_trolin_tbl.COUNT);
309: END IF;
310:
311: /* Populate out structure only for invisible move order */
312: IF (p_move_order_type = gme_common_pvt.g_invis_move_order_type) THEN
313: FOR i IN 1 .. l_material_details_tbl.COUNT LOOP
314: l_material_details_tbl (i).move_order_line_id :=
315: x_trolin_tbl (i).line_id;
316: x_material_details_tbl (x_material_details_tbl.COUNT + 1) :=

Line 358: ,p_material_details_tbl IN gme_common_pvt.material_details_tab

354: END create_move_order_lines;
355:
356: PROCEDURE create_batch_move_order (
357: p_batch_header_rec IN gme_batch_header%ROWTYPE
358: ,p_material_details_tbl IN gme_common_pvt.material_details_tab
359: ,x_return_status OUT NOCOPY VARCHAR2)
360: IS
361: l_api_name CONSTANT VARCHAR2 (30) := 'create_batch_move_order';
362: l_return_status VARCHAR2 (1);

Line 371: l_mtl_dtl_tbl gme_common_pvt.material_details_tab;

367: l_mtl_txns_enabled_flag mtl_system_items_kfv.mtl_transactions_enabled_flag%TYPE;
368: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%TYPE;
369: l_primary_uom_code mtl_system_items_kfv.primary_uom_code%TYPE;
370:
371: l_mtl_dtl_tbl gme_common_pvt.material_details_tab;
372: l_mtl_dtl_tbl_out gme_common_pvt.material_details_tab;
373: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
374: l_is_revision_control BOOLEAN;
375: l_is_lot_control BOOLEAN;

Line 372: l_mtl_dtl_tbl_out gme_common_pvt.material_details_tab;

368: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%TYPE;
369: l_primary_uom_code mtl_system_items_kfv.primary_uom_code%TYPE;
370:
371: l_mtl_dtl_tbl gme_common_pvt.material_details_tab;
372: l_mtl_dtl_tbl_out gme_common_pvt.material_details_tab;
373: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
374: l_is_revision_control BOOLEAN;
375: l_is_lot_control BOOLEAN;
376: l_is_serial_control BOOLEAN;

Line 418: gme_debug.put_line ('g_move_order_timefence is '||NVL(gme_common_pvt.g_move_order_timefence, 99999));

414: gme_debug.put_line ('Iteration of loop is '||i);
415: gme_debug.put_line ('line_type is '||p_material_details_tbl (i).line_type);
416: gme_debug.put_line ('subinventory is '||p_material_details_tbl (i).subinventory);
417: gme_debug.put_line ('material_requirement_date is '||TO_CHAR(p_material_details_tbl (i).material_requirement_date,'DD-MON-YYYY HH24:MI:SS'));
418: gme_debug.put_line ('g_move_order_timefence is '||NVL(gme_common_pvt.g_move_order_timefence, 99999));
419: END IF;
420:
421: IF ( p_material_details_tbl (i).line_type = -1
422: AND p_material_details_tbl (i).subinventory IS NOT NULL

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

420:
421: IF ( p_material_details_tbl (i).line_type = -1
422: AND p_material_details_tbl (i).subinventory IS NOT NULL
423: AND p_material_details_tbl (i).material_requirement_date <
424: (SYSDATE + NVL (gme_common_pvt.g_move_order_timefence, 0) ) ) THEN
425: IF g_debug <= gme_debug.g_log_procedure THEN
426: gme_debug.put_line ('point 1');
427: END IF;
428:

Line 446: ,p_tree_mode => gme_common_pvt.g_tree_transaction_mode

442: ,p_organization_id => p_material_details_tbl
443: (i).organization_id
444: ,p_inventory_item_id => p_material_details_tbl
445: (i).inventory_item_id
446: ,p_tree_mode => gme_common_pvt.g_tree_transaction_mode
447: ,p_grade_code => NULL
448: ,p_demand_source_header_id => p_material_details_tbl
449: (i).batch_id
450: ,p_demand_source_line_id => p_material_details_tbl

Line 484: ,PRECISION => gme_common_pvt.g_precision

480: p_material_details_tbl (i).dtl_um) THEN
481: l_plan_qty_prim :=
482: inv_convert.inv_um_convert
483: (item_id => p_material_details_tbl (i).inventory_item_id
484: ,PRECISION => gme_common_pvt.g_precision
485: ,from_quantity => p_material_details_tbl (i).plan_qty
486: ,from_unit => p_material_details_tbl (i).dtl_um
487: ,to_unit => l_primary_uom_code
488: ,from_name => NULL

Line 514: ,PRECISION => gme_common_pvt.g_precision

510: l_mtl_dtl_tbl (l_count).plan_qty :=
511: inv_convert.inv_um_convert
512: (item_id => p_material_details_tbl
513: (i).inventory_item_id
514: ,PRECISION => gme_common_pvt.g_precision
515: ,from_quantity => l_diff_qty
516: ,from_unit => l_primary_uom_code
517: ,to_unit => p_material_details_tbl
518: (i).dtl_um

Line 534: ,p_move_order_type => gme_common_pvt.g_move_order_type

530: END LOOP;
531: IF (l_count > 0) THEN
532: gme_move_orders_pvt.create_move_order_hdr
533: (p_organization_id => p_batch_header_rec.organization_id
534: ,p_move_order_type => gme_common_pvt.g_move_order_type
535: ,x_move_order_header_id => l_move_order_header_id
536: ,x_return_status => l_return_status);
537:
538: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

Line 543: ,p_move_order_type => gme_common_pvt.g_move_order_type

539: RAISE create_mo_err;
540: ELSE
541: gme_move_orders_pvt.create_move_order_lines
542: (p_move_order_header_id => l_move_order_header_id
543: ,p_move_order_type => gme_common_pvt.g_move_order_type
544: ,p_material_details_tbl => l_mtl_dtl_tbl
545: ,x_material_details_tbl => l_mtl_dtl_tbl_out
546: ,x_trolin_tbl => l_trolin_tbl
547: ,x_return_status => l_return_status);

Line 585: ,x_mo_line_tbl OUT NOCOPY gme_common_pvt.mo_lines_tab

581: PROCEDURE get_move_order_lines (
582: p_organization_id IN NUMBER
583: ,p_batch_id IN NUMBER
584: ,p_material_detail_id IN NUMBER
585: ,x_mo_line_tbl OUT NOCOPY gme_common_pvt.mo_lines_tab
586: ,x_return_status OUT NOCOPY VARCHAR2)
587: IS
588: l_api_name CONSTANT VARCHAR2 (30) := 'get_move_order_lines';
589:

Line 596: gme_common_pvt.g_txn_source_type

592: SELECT l.*
593: FROM mtl_txn_request_lines l, mtl_txn_request_headers h
594: WHERE l.organization_id = p_organization_id
595: AND transaction_source_type_id =
596: gme_common_pvt.g_txn_source_type
597: AND l.txn_source_id = p_batch_id
598: AND l.txn_source_line_id = p_material_detail_id
599: AND l.line_status NOT IN (5, 6)
600: AND h.header_id = l.header_id

Line 602: (gme_common_pvt.g_invis_move_order_type

598: AND l.txn_source_line_id = p_material_detail_id
599: AND l.line_status NOT IN (5, 6)
600: AND h.header_id = l.header_id
601: AND h.move_order_type NOT IN
602: (gme_common_pvt.g_invis_move_order_type
603: ,inv_globals.g_move_order_put_away)
604: ORDER BY l.header_id, l.line_id;
605: BEGIN
606: IF g_debug <= gme_debug.g_log_procedure THEN

Line 660: l_line_tbl gme_common_pvt.mo_lines_tab;

656: l_trolin_val_tbl inv_move_order_pub.trolin_val_tbl_type;
657: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
658: l_old_trolin_tbl inv_move_order_pub.trolin_tbl_type;
659: l_out_trolin_tbl inv_move_order_pub.trolin_tbl_type;
660: l_line_tbl gme_common_pvt.mo_lines_tab;
661: delete_mo_line_err EXCEPTION;
662: delete_mo_hdr_err EXCEPTION;
663: get_mo_line_err EXCEPTION;
664:

Line 836: gme_common_pvt.g_txn_source_type

832: IS
833: SELECT l.*
834: FROM mtl_txn_request_lines l, mtl_txn_request_headers h
835: WHERE transaction_source_type_id =
836: gme_common_pvt.g_txn_source_type
837: AND l.txn_source_id = p_batch_id
838: AND l.txn_source_line_id = p_material_detail_id
839: AND l.line_status NOT IN (5, 6)
840: AND h.header_id = l.header_id

Line 842: (gme_common_pvt.g_invis_move_order_type

838: AND l.txn_source_line_id = p_material_detail_id
839: AND l.line_status NOT IN (5, 6)
840: AND h.header_id = l.header_id
841: AND h.move_order_type NOT IN
842: (gme_common_pvt.g_invis_move_order_type
843: ,inv_globals.g_move_order_put_away)
844: ORDER BY l.creation_date DESC;
845:
846: TYPE line_tab IS TABLE OF mtl_txn_request_lines%ROWTYPE

Line 1165: AND h.move_order_type = gme_common_pvt.g_move_order_type

1161: AND l.txn_source_line_id = p_material_detail_id
1162: AND l.organization_id = p_organization_id
1163: AND l.line_status NOT IN (5, 6)
1164: AND h.header_id = l.header_id
1165: AND h.move_order_type = gme_common_pvt.g_move_order_type
1166: AND ROWNUM = 1;
1167: BEGIN
1168: IF g_debug <= gme_debug.g_log_procedure THEN
1169: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

Line 1217: l_line_tbl gme_common_pvt.mo_lines_tab;

1213: l_from_uom VARCHAR2 (3);
1214: l_to_uom VARCHAR2 (3);
1215: l_item_no VARCHAR2 (2000);
1216: l_temp_qty NUMBER;
1217: l_line_tbl gme_common_pvt.mo_lines_tab;
1218:
1219: CURSOR cur_item_uoms (v_org_id NUMBER, v_inventory_item_id NUMBER)
1220: IS
1221: SELECT primary_uom_code, secondary_uom_code, concatenated_segments

Line 1269: ,PRECISION => gme_common_pvt.g_precision

1265: -- Bug 13076579 Use detailed qty.
1266: l_temp_qty :=
1267: inv_convert.inv_um_convert
1268: (item_id => l_line_tbl (i).inventory_item_id
1269: ,PRECISION => gme_common_pvt.g_precision
1270: -- ,from_quantity => l_line_tbl (i).quantity_detailed
1271: ,from_quantity => l_line_tbl (i).quantity
1272: ,from_unit => l_line_tbl (i).uom_code
1273: ,to_unit => p_mtl_dtl_rec.dtl_um

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

1327: FROM gme_batch_header h, gme_material_details d
1328: WHERE h.organization_id = p_organization_id
1329: AND h.batch_id = p_batch_id
1330: AND d.batch_id = h.batch_id
1331: AND d.line_type = gme_common_pvt.g_line_type_ing;
1332:
1333: TYPE lines_tab IS TABLE OF cur_batch_lines%ROWTYPE
1334: INDEX BY BINARY_INTEGER;
1335: