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.INV_WIP_PICKING_PVT dependencies on INV_MOVE_ORDER_PUB

Line 26: p_mo_line_rec IN OUT NOCOPY inv_move_order_pub.trolin_rec_type

22: --g_wip_patch_level NUMBER := -999;
23:
24: -- Forward declarations
25: PROCEDURE process_line(
26: p_mo_line_rec IN OUT NOCOPY inv_move_order_pub.trolin_rec_type
27: , p_allow_partial_pick IN VARCHAR2 DEFAULT fnd_api.g_true
28: , p_grouping_rule_id IN NUMBER DEFAULT NULL
29: , p_plan_tasks IN BOOLEAN
30: , p_call_wip_api IN BOOLEAN --Added bug 4634522

Line 39: , p_mo_line_rec IN inv_move_order_pub.trolin_rec_type

35: );
36:
37: PROCEDURE update_mmtt_for_wip(
38: x_return_status OUT NOCOPY VARCHAR2
39: , p_mo_line_rec IN inv_move_order_pub.trolin_rec_type
40: , p_grouping_rule_id IN NUMBER
41: );
42:
43: FUNCTION get_mo_alloc_stat RETURN VARCHAR2;

Line 56: ( p_mo_header_rec IN INV_Move_Order_PUB.Trohdr_Rec_Type

52: --
53: -- pre patchset I version
54: --
55: PROCEDURE release_pick_batch
56: ( p_mo_header_rec IN INV_Move_Order_PUB.Trohdr_Rec_Type
57: , p_mo_line_rec_tbl IN INV_Move_Order_PUB.Trolin_Tbl_Type
58: , p_auto_detail_flag IN VARCHAR2
59: , p_auto_pick_confirm_flag IN VARCHAR2
60: , p_allow_partial_pick IN VARCHAR2

Line 57: , p_mo_line_rec_tbl IN INV_Move_Order_PUB.Trolin_Tbl_Type

53: -- pre patchset I version
54: --
55: PROCEDURE release_pick_batch
56: ( p_mo_header_rec IN INV_Move_Order_PUB.Trohdr_Rec_Type
57: , p_mo_line_rec_tbl IN INV_Move_Order_PUB.Trolin_Tbl_Type
58: , p_auto_detail_flag IN VARCHAR2
59: , p_auto_pick_confirm_flag IN VARCHAR2
60: , p_allow_partial_pick IN VARCHAR2
61: , p_commit IN VARCHAR2

Line 71: l_mo_header_rec INV_Move_Order_PUB.Trohdr_Rec_Type;

67:
68: l_conc_req_id NUMBER;
69: l_api_return_status VARCHAR2(1);
70: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
71: l_mo_header_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
72:
73: -- Bug 4288399
74: l_wip_error_table INV_WIP_Picking_PVT.Trolin_ErrTbl_Type;
75:

Line 138: ( p_mo_header_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type

134: --
135: -- patchset I version
136: --
137: PROCEDURE release_pick_batch
138: ( p_mo_header_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type
139: , p_mo_line_rec_tbl IN inv_move_order_pub.trolin_tbl_type
140: , p_auto_detail_flag IN VARCHAR2
141: , p_auto_pick_confirm_flag IN VARCHAR2
142: , p_allow_partial_pick IN VARCHAR2

Line 139: , p_mo_line_rec_tbl IN inv_move_order_pub.trolin_tbl_type

135: -- patchset I version
136: --
137: PROCEDURE release_pick_batch
138: ( p_mo_header_rec IN OUT NOCOPY inv_move_order_pub.trohdr_rec_type
139: , p_mo_line_rec_tbl IN inv_move_order_pub.trolin_tbl_type
140: , p_auto_detail_flag IN VARCHAR2
141: , p_auto_pick_confirm_flag IN VARCHAR2
142: , p_allow_partial_pick IN VARCHAR2
143: , p_print_pick_slip IN VARCHAR2

Line 158: l_trohdr_val_rec inv_move_order_pub.trohdr_val_rec_type;

154: l_api_version_number NUMBER := 1.0;
155: l_api_return_status VARCHAR2(1);
156: l_commit VARCHAR2(1) := fnd_api.g_false;
157: l_temp BOOLEAN;
158: l_trohdr_val_rec inv_move_order_pub.trohdr_val_rec_type;
159: l_trolin_val_tbl inv_move_order_pub.trolin_val_tbl_type;
160: l_organization_id NUMBER;
161: l_auto_pick_confirm VARCHAR2(1) := fnd_api.g_false;
162: l_entity_type NUMBER;

Line 159: l_trolin_val_tbl inv_move_order_pub.trolin_val_tbl_type;

155: l_api_return_status VARCHAR2(1);
156: l_commit VARCHAR2(1) := fnd_api.g_false;
157: l_temp BOOLEAN;
158: l_trohdr_val_rec inv_move_order_pub.trohdr_val_rec_type;
159: l_trolin_val_tbl inv_move_order_pub.trolin_val_tbl_type;
160: l_organization_id NUMBER;
161: l_auto_pick_confirm VARCHAR2(1) := fnd_api.g_false;
162: l_entity_type NUMBER;
163: l_max_batch NUMBER;

Line 169: l_line_tbl inv_move_order_pub.trolin_tbl_type;

165: l_last_rec NUMBER;
166: l_last_batch_rec NUMBER;
167: l_rec_count NUMBER;
168: l_index NUMBER;
169: l_line_tbl inv_move_order_pub.trolin_tbl_type;
170: l_is_wms_org BOOLEAN := FALSE;
171: l_mo_allocation_status VARCHAR2(1) := g_not_allocated;
172: l_req_msg VARCHAR2(255); -- Informational message from device integration API
173:

Line 298: inv_move_order_pub.create_move_order_header(

294: IF (l_debug = 1) THEN
295: print_debug('Calling Create Move Order Header', 'RELEASE_PICK_BATCH');
296: END IF;
297:
298: inv_move_order_pub.create_move_order_header(
299: p_api_version_number => l_api_version_number
300: , p_init_msg_list => fnd_api.g_false
301: , p_return_values => fnd_api.g_true
302: , p_commit => l_commit

Line 402: inv_move_order_pub.create_move_order_lines(

398: SAVEPOINT inv_wip_pick_release;
399: l_savept_exists := TRUE;
400: END IF;
401:
402: inv_move_order_pub.create_move_order_lines(
403: p_api_version_number => l_api_version_number
404: , p_init_msg_list => fnd_api.g_true
405: , p_return_values => fnd_api.g_true
406: , p_commit => l_commit

Line 566: inv_move_order_pub.create_move_order_lines(

562: l_line_tbl(ii).header_id := p_mo_header_rec.header_id;
563: l_line_tbl(ii).line_number := ii;
564: END LOOP;
565:
566: inv_move_order_pub.create_move_order_lines(
567: p_api_version_number => l_api_version_number
568: , p_init_msg_list => fnd_api.g_false
569: , p_return_values => fnd_api.g_true
570: , p_commit => l_commit

Line 581: print_debug ('Error occurred in INV_Move_Order_PUB.Create_Move_Order_Lines', 'RELEASE_PICK_BATCH');

577: , x_trolin_val_tbl => l_trolin_val_tbl
578: );
579:
580: IF l_api_return_status <> FND_API.G_RET_STS_SUCCESS THEN
581: print_debug ('Error occurred in INV_Move_Order_PUB.Create_Move_Order_Lines', 'RELEASE_PICK_BATCH');
582: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
583: ELSE
584: print_debug ('Created MO Lines successfully', 'RELEASE_PICK_BATCH');
585: END IF;

Line 709: , p_mo_line_tbl IN inv_move_order_pub.trolin_tbl_type

705: , x_msg_count OUT NOCOPY NUMBER
706: , x_msg_data OUT NOCOPY VARCHAR2
707: , p_commit IN VARCHAR2
708: , p_init_msg_lst IN VARCHAR2
709: , p_mo_line_tbl IN inv_move_order_pub.trolin_tbl_type
710: , p_allow_partial_pick IN VARCHAR2
711: , p_grouping_rule_id IN NUMBER
712: , p_plan_tasks IN BOOLEAN
713: , p_call_wip_api IN BOOLEAN

Line 718: l_mo_line inv_move_order_pub.trolin_rec_type;

714: ) IS
715:
716: l_api_version_number NUMBER := 1.0;
717: l_line_index NUMBER; -- The index of the line in the table being processed
718: l_mo_line inv_move_order_pub.trolin_rec_type;
719: l_organization_id NUMBER; -- The OrgID to use (based on the MO Lines Passed in).
720: l_mo_header_id NUMBER; -- Move Order Header ID
721: l_mo_type NUMBER; -- The type of the move order (Should be only 5)
722: l_mo_number VARCHAR2(30); -- The move order number

Line 1306: ( p_mo_line_rec IN OUT NOCOPY inv_move_order_pub.trolin_rec_type

1302: -- (See FND_API package for more details about the above output parameters)
1303: --
1304:
1305: PROCEDURE process_line
1306: ( p_mo_line_rec IN OUT NOCOPY inv_move_order_pub.trolin_rec_type
1307: , p_allow_partial_pick IN VARCHAR2 DEFAULT fnd_api.g_true
1308: , p_grouping_rule_id IN NUMBER
1309: , p_plan_tasks IN BOOLEAN
1310: , p_call_wip_api IN BOOLEAN --Added bug 4634522

Line 1632: , p_mo_line_rec IN inv_move_order_pub.trolin_rec_type

1628: END update_mol_for_wip;
1629:
1630: PROCEDURE update_mmtt_for_wip(
1631: x_return_status OUT NOCOPY VARCHAR2
1632: , p_mo_line_rec IN inv_move_order_pub.trolin_rec_type
1633: , p_grouping_rule_id IN NUMBER
1634: ) IS
1635: l_wip_entity_type NUMBER;
1636: l_repetitive_line_id NUMBER;