[Home] [Help]
PACKAGE: APPS.INV_UTIL
Source
1 PACKAGE inv_util AUTHID CURRENT_USER AS
2 /* $Header: INVINUTS.pls 115.4 2002/12/31 20:48:43 lplam ship $ */
3
4 -- API Name insert_mmtt
5 -- Type Public
6 -- Description This procedure inserts data in mtl_material_transactions_temp.
7 --
8 -- Input Parameters:
9 -- p_api_version IN NUMBER (required)
10 -- p_init_msg_level IN VARCHAR2 (optional)
11 -- DEFAULT = FND_API.G_FALSE
12 -- p_commit IN VARCHAR2 (optional)
13 -- DEFAULT = FND_API.G_FALSE
14 -- p_validation_level NUMBER (optional)
15 -- DEFAULT = FND_API.G_VALID_LEVEL_FULL
16 -- p_mmtt_rec IN mtl_material_transactions_temp%ROWTYPE (required)
17 -- The mtl_material_transactions_temp record to be inserted.
18 --
19 -- Output Parameters:
20 -- x_trx_header_id Trasaction header id
21 -- x_trx_temp_id Transaction temp id
22 -- x_return_status fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_success,
23 -- fnd_api.g_ret_unexp_error
24 -- x_msg_count number of error messages in the buffer
25 -- x_msg_data error messages
26
27 PROCEDURE insert_mmtt(p_api_version IN NUMBER,
28 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
29 p_commit IN VARCHAR2 := FND_API.G_FALSE,
30 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
31 p_mmtt_rec IN mtl_material_transactions_temp%ROWTYPE,
32 x_trx_header_id OUT NOCOPY NUMBER,
33 x_trx_temp_id OUT NOCOPY NUMBER,
34 x_return_status OUT NOCOPY VARCHAR2,
35 x_msg_count OUT NOCOPY NUMBER,
36 x_msg_data OUT NOCOPY VARCHAR2);
37
38
39 -- API Name insert_mtlt
40 -- Type Public
41 -- Description This procedure inserts data in mtl_transaction_lots_temp.
42 --
43 -- Input Parameters:
44 -- p_api_version IN NUMBER (required)
45 -- p_init_msg_level IN VARCHAR2 (optional)
46 -- DEFAULT = FND_API.G_FALSE
47 -- p_commit IN VARCHAR2 (optional)
48 -- DEFAULT = FND_API.G_FALSE
49 -- p_validation_level NUMBER (optional)
50 -- DEFAULT = FND_API.G_VALID_LEVEL_FULL
51 -- p_mtlt_rec IN mtl_transaction_lots_temp%ROWTYPE (required)
52 -- The mtl_transaction_lots_temp record to be inserted.
53 --
54 -- Output Parameters:
55 -- x_return_status fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_success,
56 -- fnd_api.g_ret_unexp_error
57 -- x_msg_count number of error messages in the buffer
58 -- x_msg_data error messages
59
60 PROCEDURE insert_mtlt(p_api_version IN NUMBER,
61 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
62 p_commit IN VARCHAR2 := FND_API.G_FALSE,
63 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
64 p_mtlt_rec IN mtl_transaction_lots_temp%ROWTYPE,
65 x_return_status OUT NOCOPY VARCHAR2,
66 x_msg_count OUT NOCOPY NUMBER,
67 x_msg_data OUT NOCOPY VARCHAR2);
68
69
70 -- API Name insert_msnt
71 -- Type Public
72 -- Description This procedure inserts data in mtl_serial_numbers_temp.
73 --
74 -- Input Parameters:
75 -- p_api_version IN NUMBER (required)
76 -- p_init_msg_level IN VARCHAR2 (optional)
77 -- DEFAULT = FND_API.G_FALSE
78 -- p_commit IN VARCHAR2 (optional)
79 -- DEFAULT = FND_API.G_FALSE
80 -- p_validation_level NUMBER (optional)
81 -- DEFAULT = FND_API.G_VALID_LEVEL_FULL
82 -- p_msnt_rec IN mtl_serial_numbers_temp%ROWTYPE (required)
83 -- The mtl_serial_numbers_temp record to be inserted.
84 --
85 -- Output Parameters:
86 -- x_return_status fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_success,
87 -- fnd_api.g_ret_unexp_error
88 -- x_msg_count number of error messages in the buffer
89 -- x_msg_data error messages
90
91 PROCEDURE insert_msnt(p_api_version IN NUMBER,
92 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
93 p_commit IN VARCHAR2 := FND_API.G_FALSE,
94 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
95 p_msnt_rec IN mtl_serial_numbers_temp%ROWTYPE,
96 x_return_status OUT NOCOPY VARCHAR2,
97 x_msg_count OUT NOCOPY NUMBER,
98 x_msg_data OUT NOCOPY VARCHAR2);
99
100 END inv_util;