1: PACKAGE inv_material_allocations_grp AUTHID CURRENT_USER AS
2: /* $Header: INVMTALS.pls 115.0 2004/02/11 18:38:44 pgoel 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,
2: /* $Header: INVMTALS.pls 115.0 2004/02/11 18:38:44 pgoel 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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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