DBA Data[Home] [Help]

APPS.GME_MOVE_ORDERS_PVT dependencies on INV_GLOBALS

Line 66: l_in_trohdr_rec.operation := inv_globals.g_opr_create;

62:
63: x_return_status := fnd_api.g_ret_sts_success;
64: l_in_trohdr_rec.organization_id := p_organization_id;
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;

Line 196: inv_globals.g_opr_create;

192: IF (l_txn_enabled_flag = 'Y' AND NVL(p_material_details_tbl (i).phantom_type,0) = 0) THEN
193: l_count := l_material_details_tbl.COUNT + 1;
194: l_material_details_tbl (l_count) := p_material_details_tbl (i);
195: l_in_trolin_tbl (l_count).operation :=
196: inv_globals.g_opr_create;
197: l_in_trolin_tbl (l_count).header_id := p_move_order_header_id;
198: l_in_trolin_tbl (l_count).inventory_item_id :=
199: l_material_details_tbl (l_count).inventory_item_id;
200: l_in_trolin_tbl (l_count).organization_id :=

Line 603: ,inv_globals.g_move_order_put_away)

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
607: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

Line 689: l_trolin_tbl (i).operation := inv_globals.g_opr_delete;

685: RAISE get_mo_line_err;
686: END IF;
687:
688: FOR i IN 1 .. l_line_tbl.COUNT LOOP
689: l_trolin_tbl (i).operation := inv_globals.g_opr_delete;
690: l_trolin_tbl (i).line_id := l_line_tbl (i).line_id;
691: l_trolin_tbl (i).header_id := l_line_tbl (i).header_id;
692: END LOOP;
693:

Line 696: l_trolin_tbl (l_row).operation := inv_globals.g_opr_delete;

692: END LOOP;
693:
694: IF (p_invis_move_line_id IS NOT NULL) THEN
695: l_row := l_trolin_tbl.COUNT + 1;
696: l_trolin_tbl (l_row).operation := inv_globals.g_opr_delete;
697: l_trolin_tbl (l_row).line_id := p_invis_move_line_id;
698: l_trolin_tbl (l_row).header_id := p_invis_move_header_id;
699: END IF;
700:

Line 743: l_trohdr_rec.operation := inv_globals.g_opr_delete;

739: CLOSE cur_move_order_lines;
740:
741: IF (l_count = 0) THEN
742: l_trohdr_rec.header_id := l_trolin_tbl (i).header_id;
743: l_trohdr_rec.operation := inv_globals.g_opr_delete;
744:
745: IF (g_debug <= gme_debug.g_log_statement) THEN
746: gme_debug.put_line
747: ( 'Calling inv_move_order_pub.process_move_order in '

Line 843: ,inv_globals.g_move_order_put_away)

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
847: INDEX BY BINARY_INTEGER;

Line 890: l_trolin_tbl (1).operation := inv_globals.g_opr_update;

886: FETCH cur_item_mst INTO l_prim_uom_code, l_sec_uom_code, l_tracking_quantity_ind ;
887: CLOSE cur_item_mst;
888:
889: IF (p_invis_move_line_id IS NOT NULL) THEN
890: l_trolin_tbl (1).operation := inv_globals.g_opr_update;
891: l_trolin_tbl (1).line_id := p_invis_move_line_id;
892: l_trolin_tbl (1).uom_code := l_line_uom;
893:
894: IF (p_new_qty IS NOT NULL) THEN

Line 966: inv_globals.g_opr_delete;

962: END IF;
963:
964: IF (l_line_tbl (l_cnt).quantity <= ABS (l_diff_qty) ) THEN
965: l_trolin_tbl (l_cnt).operation :=
966: inv_globals.g_opr_delete;
967: l_trolin_tbl (l_cnt).line_id := l_line_tbl (i).line_id;
968: l_trolin_tbl (l_cnt).header_id :=
969: l_line_tbl (i).header_id;
970: l_diff_qty := l_diff_qty + l_line_tbl (i).quantity;

Line 973: inv_globals.g_opr_update;

969: l_line_tbl (i).header_id;
970: l_diff_qty := l_diff_qty + l_line_tbl (i).quantity;
971: ELSE
972: l_trolin_tbl (l_cnt).operation :=
973: inv_globals.g_opr_update;
974: l_trolin_tbl (l_cnt).line_id := l_line_tbl (i).line_id;
975: l_trolin_tbl (l_cnt).header_id :=
976: l_line_tbl (i).header_id;
977: --Bug#5078853 replaced l_trolin_tbl (i).quantity

Line 1028: l_trolin_tbl (1).operation := inv_globals.g_opr_update;

1024: END IF;
1025: END LOOP;
1026: ELSIF (l_diff_qty > 0) THEN
1027: /*user is trying to increase the qty in batch*/
1028: l_trolin_tbl (1).operation := inv_globals.g_opr_update;
1029: l_trolin_tbl (1).line_id := l_line_tbl (1).line_id;
1030: l_trolin_tbl (1).header_id := l_line_tbl (1).header_id;
1031: --Bug#5078853 replaced l_trolin_tbl (i).quantity
1032: l_trolin_tbl (1).quantity :=

Line 1085: l_trolin_tbl (l_cnt).operation := inv_globals.g_opr_update;

1081: IF (p_new_date IS NOT NULL) THEN
1082: FOR i IN 1 .. l_line_tbl.COUNT LOOP
1083: IF (nvl(l_line_tbl (i).REFERENCE,' ') <> ' ') THEN
1084: l_cnt := l_trolin_tbl.COUNT + 1;
1085: l_trolin_tbl (l_cnt).operation := inv_globals.g_opr_update;
1086: l_trolin_tbl (l_cnt).line_id := l_line_tbl (i).line_id;
1087: l_trolin_tbl (l_cnt).header_id := l_line_tbl (i).header_id;
1088: l_trolin_tbl (l_cnt).date_required := p_new_date;
1089: END IF;