PACKAGE: APPS.IEX_PARTY_PREF_PUB

Source

1 PACKAGE IEX_PARTY_PREF_PUB AUTHID CURRENT_USER AS
2 /* $Header: iexphpps.pls 120.0.12010000.9 2009/07/31 15:32:33 ehuh ship $ */
3 /*#
4    Store Collection level into hz_party_preferences Table
5  * @rep:scope public
6  * @rep:product IEX
7  * @rep:lifecycle active
8  * @rep:displayname IEX Store Collection level API
9  * @rep:compatibility S
10  * @rep:category BUSINESS_ENTITY IEX_PARTY_PREF
11  */
12 
13 
14 type level_rec_type is RECORD(party_id number,ObjectCode varchar2(240));
15 type level_tbl_type is TABLE of level_rec_type index by binary_integer;
16 
17 type ulevel_rec is RECORD(party_id number,ObjectCode varchar2(240),version number);
18 type ulevel_tbl is TABLE of ulevel_rec index by binary_integer;
19 
20 /*#
21  * Creates/Updates collections level in hz_party_preferences table.
22  * @param p_api_version_number   API Version Number
23  * @param p_init_msg_list Intialize Message Stack
24  * @param p_commit        Commit flag('Y'/'N')
25  * @param x_return_status API return status
26  * @param x_msg_count     Number of error messages
27  * @param x_msg_data      Error message data
28  * @param x_insert_count  Returns created rows count
29  * @param x_update_count  Returns Updated rows count
30  * @param p_level_tbl     Input Table (party_id number, ObjectCode varchar2 'PARTY'/'ACCOUNT'/'BILLTO')
31  * @rep:scope public
32  * @rep:lifecycle active
33  * @rep:displayname  assign collections level
34  * @rep:compatibility S
35  * @rep:businessevent Collection
36  */
37 
38 PROCEDURE assign_collection_level
39 (
40     P_Api_Version_Number         IN   NUMBER DEFAULT 1.0,
41     P_Init_Msg_List              IN   VARCHAR2 DEFAULT NULL,
42     P_Commit                     IN   VARCHAR2 DEFAULT NULL,
43     X_Return_Status              OUT NOCOPY  VARCHAR2,
44     X_Msg_Count                  OUT NOCOPY  NUMBER,
45     X_Msg_Data                   OUT NOCOPY  VARCHAR2,
46     X_Insert_Count               OUT NOCOPY  NUMBER,
47     X_Update_Count               OUT NOCOPY  NUMBER,
48     p_level_tbl                  IN  level_tbl_type);
49 
50 
51 END IEX_PARTY_PREF_PUB;
52