1 PACKAGE AHL_MC_ITEMGROUP_PUB AUTHID CURRENT_USER AS
2 /* $Header: AHLPIGPS.pls 120.0 2005/05/26 01:00:15 appldev noship $ */
3 /*#
4 * This is the public package that creates and modifies the Item groups and item-group associations for Master Configuration
5 * @rep:scope public
6 * @rep:product AHL
7 * @rep:displayname Item Group Association
8 * @rep:lifecycle active
9 * @rep:category BUSINESS_ENTITY AHL_MASTER_CONFIG
10 */
11
12
13 -----------------------------------------
14 -- Declare Procedures for Item Groups --
15 -----------------------------------------
16 /*#
17 * It Creates and Modifies Item groups and associated Items.
18 * @param p_api_version Api Version Number
19 * @param p_init_msg_list Initialize the message stack, default value FND_API.G_FALSE
20 * @param p_commit To decide whether to commit the transaction, default value FND_API.G_FALSE
21 * @param p_validation_level Validation level, default value FND_API.G_VALID_LEVEL_FULL
22 * @param p_module_type whether 'API'or 'JSP', default value NULL
23 * @param x_return_status Return status, Standard API parameter
24 * @param x_msg_count Return message count,Standard API parameter
25 * @param x_msg_data Return message data, Standard API parameter
26 * @param p_x_item_group_rec Item Group record of type AHL_MC_ItemGroup_Pvt.Item_Group_Rec_Type
27 * @param p_x_items_tbl Items table of type AHL_MC_ItemGroup_Pvt.Item_Association_Tbl_Type
28 * @rep:scope public
29 * @rep:lifecycle active
30 * @rep:displayname Process Item Group
31 */
32 PROCEDURE PROCESS_ITEM_GROUP (p_api_version IN NUMBER,
33 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
34 p_commit IN VARCHAR2 := FND_API.G_FALSE,
35 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
36 p_module_type IN VARCHAR2 := NULL,
37 x_return_status OUT NOCOPY VARCHAR2,
38 x_msg_count OUT NOCOPY NUMBER,
39 x_msg_data OUT NOCOPY VARCHAR2,
40 p_x_item_group_rec IN OUT NOCOPY AHL_MC_ItemGroup_Pvt.Item_Group_Rec_Type,
41 p_x_items_tbl IN OUT NOCOPY AHL_MC_ItemGroup_Pvt.Item_Association_Tbl_Type
42 );
43
44 -- Start of Comments --
45 -- Procedure name : Process_Item_Group
46 -- Type : Public
47 -- Function : Creates,Modifies and Deletes Item Group for Master Configuration in ahl_item_groups_b and TL tables.
48 -- Also Creates,Modifies and Deletes item-group association in ahl_item_associations_b/TL table.
49 -- Pre-reqs :
50 -- Parameters :
51 -- Standard IN Parameters :
52 -- p_api_version IN NUMBER Required
53 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
54 -- p_commit IN VARCHAR2 Default FND_API.G_FALSE
55 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
56 -- p_module_type IN VARCHAR2 Default NULL,
57 --
58 -- Standard OUT Parameters :
59 -- x_return_status OUT VARCHAR2 Required
60 -- x_msg_count OUT NUMBER Required
61 -- x_msg_data OUT VARCHAR2 Required
62 --
63 -- p_module_type IN VARCHAR2 Required.
64 -- This parameter indicates the front-end form interface. The default value is 'JSP'. If the value
65 -- is JSP, then this API clears out all id columns and validations are done using the values based
66 -- on which the Id's are populated.
67 -- Item Group Record :
68 -- Name or item_group_id Required.
69 -- operation_flag if record needs to be created (C) or modified (M) or deleted.(D)
70 -- Item Associations Record :
71 -- Inventory_item_id Required and present and trackable in mtl_system_items_b.
72 -- priority Required.
73 -- Operation_code Required to be 'C'.(Create) or 'M' (Update) or 'D' (Delete)
74 -- End of Comments --
75
76
77
78
79 End AHL_MC_ITEMGROUP_PUB;