1 PACKAGE INV_ABC_Assignments_PUB AUTHID CURRENT_USER AS
2 /* $Header: INVPAASS.pls 120.0.12020000.4 2013/02/22 12:18:40 ksaripal noship $ */
3 /*#
4 * This package provides routines for inserting/updating ABC Assignments manually
5 * @rep:scope public
6 * @rep:product INV
7 * @rep:lifecycle active
8 * @rep:displayname ABC Assignments Public API
9 * @rep:category BUSINESS_ENTITY INV_SETUP
10 */
11
12 -- API name create_abc_assignments
13 -- Type Public
14 --
15 -- Version Current version = 1.0
16 -- Initial version = 1.0
17 --
18 -- Procedures
19 --
20 -- Name
21 -- PROCEDURE create_abc_assignments
22 --
23 -- Purpose
24 -- This procedure updates the inserts/updates the abc assignments.
25 -- Input parameters
26 -- p_api_version_number IN NUMBER (required)
27 -- API Version of this procedure
28 -- p_init_msg_list IN VARCHAR2 (optional)
29 -- DEFAULT = FND_API.G_FALSE,
30 -- p_commit IN VARCHAR2 (optional)
31 -- DEFAULT = FND_API.G_FALSE,
32 -- p_abc_assignments_rec IN Record type containing
33 -- - inventory_item_id
34 -- - assignment_group_id
35 -- - abc_class_id
36 --
37 -- Output Parameters
38 -- x_msg_count - number of error messages in the buffer
39 -- x_msg_data - error messages
40 -- x_return_status - fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_success,
41 -- fnd_api.g_ret_unexp_error
42
43 -------------------------------------------------------------------------------
44 -- Record types for ABC Assignments
45 -------------------------------------------------------------------------------
46 --------------------------------------------------------------------------------
47 -- abc_assignments_rec_type record type
48 -- Record type to hold a abc assignment required columns
49 -- inventory_item_id
50 -- assignmentg_group_id
51 -- abc_class_id
52 --------------------------------------------------------------------------------
53
54 TYPE abc_assignments_rec_type IS RECORD (
55 inventory_item_id NUMBER,
56 assignment_group_id NUMBER,
57 abc_class_id NUMBER );
58
59 TYPE abc_assignments_tbl_type
60 IS TABLE OF ABC_ASSIGNMENTS_REC_TYPE INDEX BY BINARY_INTEGER;
61 g_miss_assignments_rec_type ABC_ASSIGNMENTS_REC_TYPE;
62
63
64 /*#
65 * This procedure inserts/updates the abc assignments based on the input
66 * value of record type p_abc_assignments_rec having inventory_item_id,
67 * assignment_group_id, abc_class_id
68 * @param p_commit variable to call commit explicitly
69 * @param p_api_version_number API Version of this procedure. Current version is 1.0
70 * @param p_init_msg_list Indicates whether message stack is to be initialized
71 * @param p_abc_assignments_rec ABC Assignment record identifier to be processed to
72 * either insert or update
73 * @param x_msg_data return variable holding the error message
74 * @param x_msg_count return variable holding the number of error messages returned
75 * @param x_return_status return variable holding the status of the procedure call
76 * @rep:scope public
77 * @rep:lifecycle active
78 * @rep:displayname Create ABC Assignments
79 */
80 PROCEDURE create_abc_assignments (
81 p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
82 p_commit IN VARCHAR2 := fnd_api.g_false,
83 p_api_version_number IN NUMBER := 1.0,
84 x_return_status OUT nocopy VARCHAR2,
85 x_msg_count OUT nocopy NUMBER,
86 x_msg_data OUT nocopy VARCHAR2,
87 p_abc_assignments_rec IN ABC_ASSIGNMENTS_REC_TYPE :=
88 g_miss_assignments_rec_type );
89
90 END INV_ABC_Assignments_PUB;