DBA Data[Home] [Help]

APPS.GME_MOVE_ORDERS_PVT dependencies on INV_GLOBALS

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

39:
40: x_return_status := fnd_api.g_ret_sts_success;
41: l_in_trohdr_rec.organization_id := p_organization_id;
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;

Line 160: inv_globals.g_opr_create;

156: IF (l_txn_enabled_flag = 'Y' AND NVL(p_material_details_tbl (i).phantom_type,0) = 0) THEN
157: l_count := l_material_details_tbl.COUNT + 1;
158: l_material_details_tbl (l_count) := p_material_details_tbl (i);
159: l_in_trolin_tbl (l_count).operation :=
160: inv_globals.g_opr_create;
161: l_in_trolin_tbl (l_count).header_id := p_move_order_header_id;
162: l_in_trolin_tbl (l_count).inventory_item_id :=
163: l_material_details_tbl (l_count).inventory_item_id;
164: l_in_trolin_tbl (l_count).organization_id :=

Line 540: ,inv_globals.g_move_order_put_away)

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

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

622: RAISE get_mo_line_err;
623: END IF;
624:
625: FOR i IN 1 .. l_line_tbl.COUNT LOOP
626: l_trolin_tbl (i).operation := inv_globals.g_opr_delete;
627: l_trolin_tbl (i).line_id := l_line_tbl (i).line_id;
628: l_trolin_tbl (i).header_id := l_line_tbl (i).header_id;
629: END LOOP;
630:

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

629: END LOOP;
630:
631: IF (p_invis_move_line_id IS NOT NULL) THEN
632: l_row := l_trolin_tbl.COUNT + 1;
633: l_trolin_tbl (l_row).operation := inv_globals.g_opr_delete;
634: l_trolin_tbl (l_row).line_id := p_invis_move_line_id;
635: l_trolin_tbl (l_row).header_id := p_invis_move_header_id;
636: END IF;
637:

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

676: CLOSE cur_move_order_lines;
677:
678: IF (l_count = 0) THEN
679: l_trohdr_rec.header_id := l_trolin_tbl (i).header_id;
680: l_trohdr_rec.operation := inv_globals.g_opr_delete;
681:
682: IF (g_debug <= gme_debug.g_log_statement) THEN
683: gme_debug.put_line
684: ( 'Calling inv_move_order_pub.process_move_order in '

Line 779: ,inv_globals.g_move_order_put_away)

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

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

798:
799: x_return_status := fnd_api.g_ret_sts_success;
800:
801: IF (p_invis_move_line_id IS NOT NULL) THEN
802: l_trolin_tbl (1).operation := inv_globals.g_opr_update;
803: l_trolin_tbl (1).line_id := p_invis_move_line_id;
804:
805: IF (p_new_qty IS NOT NULL) THEN
806: l_trolin_tbl (1).quantity := p_new_qty;

Line 845: inv_globals.g_opr_delete;

841: END IF;
842:
843: IF (l_line_tbl (l_cnt).quantity <= ABS (l_diff_qty) ) THEN
844: l_trolin_tbl (l_cnt).operation :=
845: inv_globals.g_opr_delete;
846: l_trolin_tbl (l_cnt).line_id := l_line_tbl (i).line_id;
847: l_trolin_tbl (l_cnt).header_id :=
848: l_line_tbl (i).header_id;
849: l_diff_qty := l_diff_qty + l_line_tbl (i).quantity;

Line 852: inv_globals.g_opr_update;

848: l_line_tbl (i).header_id;
849: l_diff_qty := l_diff_qty + l_line_tbl (i).quantity;
850: ELSE
851: l_trolin_tbl (l_cnt).operation :=
852: inv_globals.g_opr_update;
853: l_trolin_tbl (l_cnt).line_id := l_line_tbl (i).line_id;
854: l_trolin_tbl (l_cnt).header_id :=
855: l_line_tbl (i).header_id;
856: --Bug#5078853 replaced l_trolin_tbl (i).quantity

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

865: END IF;
866: END LOOP;
867: ELSIF (l_diff_qty > 0) THEN
868: /*user is trying to increase the qty in batch*/
869: l_trolin_tbl (1).operation := inv_globals.g_opr_update;
870: l_trolin_tbl (1).line_id := l_line_tbl (1).line_id;
871: l_trolin_tbl (1).header_id := l_line_tbl (1).header_id;
872: --Bug#5078853 replaced l_trolin_tbl (i).quantity
873: l_trolin_tbl (1).quantity :=

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

884: IF (p_new_date IS NOT NULL) THEN
885: FOR i IN 1 .. l_line_tbl.COUNT LOOP
886: IF (nvl(l_line_tbl (i).REFERENCE,' ') <> ' ') THEN
887: l_cnt := l_trolin_tbl.COUNT + 1;
888: l_trolin_tbl (l_cnt).operation := inv_globals.g_opr_update;
889: l_trolin_tbl (l_cnt).line_id := l_line_tbl (i).line_id;
890: l_trolin_tbl (l_cnt).header_id := l_line_tbl (i).header_id;
891: l_trolin_tbl (l_cnt).date_required := p_new_date;
892: END IF;