[Home] [Help]
PACKAGE: APPS.EAM_MATERIAL_ALLOCATIONS_PVT
Source
1 PACKAGE eam_material_allocations_pvt AUTHID CURRENT_USER AS
2 /* $Header: EAMMTALS.pls 115.1 2003/10/09 03:20:44 dgupta noship $*/
3
4 PROCEDURE reduce_allocation_header(
5 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
6 p_commit IN VARCHAR2 := fnd_api.g_false,
7 p_transaction_temp_id IN NUMBER,
8 p_organization_id IN NUMBER := null,
9 p_qty_to_reduce IN NUMBER := null,
10 p_final_qty IN NUMBER := null,
11 p_delete_remaining IN VARCHAR2 := 'N',
12 x_new_transaction_temp_id OUT NOCOPY NUMBER,
13 x_return_status OUT NOCOPY VARCHAR2,
14 x_msg_count OUT NOCOPY NUMBER,
15 x_msg_data OUT NOCOPY VARCHAR2
16 );
17
18 PROCEDURE remove_serial(
19 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
20 p_commit IN VARCHAR2 := fnd_api.g_false,
21 p_transaction_temp_id IN NUMBER,
22 p_serial IN VARCHAR2,
23 p_lot IN VARCHAR2 := null,
24 p_inventory_item_id IN NUMBER := null,
25 p_new_transaction_temp_id IN NUMBER := null,
26 x_return_status OUT NOCOPY VARCHAR2,
27 x_msg_count OUT NOCOPY NUMBER,
28 x_msg_data OUT NOCOPY VARCHAR2
29 );
30
31 PROCEDURE add_serial(
32 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
33 p_commit IN VARCHAR2 := fnd_api.g_false,
34 p_transaction_temp_id IN NUMBER,
35 p_organization_id IN NUMBER,
36 p_inventory_item_id IN NUMBER,
37 p_serial IN VARCHAR2,
38 x_return_status OUT NOCOPY VARCHAR2,
39 x_msg_count OUT NOCOPY NUMBER,
40 x_msg_data OUT NOCOPY VARCHAR2
41 );
42
43 PROCEDURE update_lot(
44 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
45 p_commit IN VARCHAR2 := fnd_api.g_false,
46 p_transaction_temp_id IN NUMBER,
47 p_serial_transaction_temp_id IN NUMBER := null,
48 p_lot IN VARCHAR2,
49 p_lot_quantity IN NUMBER,
50 p_old_lot_quantity IN NUMBER,
51 p_new_transaction_temp_id IN NUMBER := null,
52 x_ser_trx_id OUT NOCOPY NUMBER,
53 x_return_status OUT NOCOPY VARCHAR2,
54 x_msg_count OUT NOCOPY NUMBER,
55 x_msg_data OUT NOCOPY VARCHAR2
56 );
57
58 PROCEDURE mark_lot_with_ser_temp_id(
59 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
60 p_commit IN VARCHAR2 := fnd_api.g_false,
61 p_transaction_temp_id IN NUMBER,
62 p_lot IN VARCHAR2,
63 p_primary_quantity IN NUMBER,
64 x_ser_trx_id OUT NOCOPY NUMBER,
65 x_return_status OUT NOCOPY VARCHAR2,
66 x_msg_count OUT NOCOPY NUMBER,
67 x_msg_data OUT NOCOPY VARCHAR2
68 );
69
70 PROCEDURE delete_allocation(
71 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
72 p_commit IN VARCHAR2 := fnd_api.g_false,
73 p_transaction_temp_id IN NUMBER,
74 x_return_status OUT NOCOPY VARCHAR2,
75 x_msg_count OUT NOCOPY NUMBER,
76 x_msg_data OUT NOCOPY VARCHAR2
77 );
78
79 END EAM_MATERIAL_ALLOCATIONS_PVT;