1 PACKAGE PV_PARTNER_ATTR_LOAD_PUB AUTHID CURRENT_USER as
2 /* $Header: pvxpldps.pls 120.4 2006/01/20 02:13 rdsharma noship $ */
3 /*#
4 * This public interface can be utilized to insert/update a set of Partners
5 * into the PRM application. As a pre-requisite each Partner organization should
6 * already exist as a Party in TCA.
7 * @rep:scope public
8 * @rep:product PV
9 * @rep:displayname Import Partner Attributes
10 * @rep:lifecycle active
11 * @rep:compatibility N
12 * @rep:category BUSINESS_ENTITY PV_PARTNER_PROFILE
13 */
14
15
16 g_data_block_size CONSTANT NUMBER := 50 ;
17
18
19 TYPE attribute_details_rec_type IS RECORD
20 (
21 attribute_id number,
22 attr_values_tbl PV_ENTY_ATTR_VALUE_PUB.attr_value_tbl_type --attr_values_tbl_type
23 );
24 g_miss_attribute_details_rec attribute_details_rec_type;
25
26 TYPE attr_details_tbl_type IS TABLE OF attribute_details_rec_type INDEX BY BINARY_INTEGER;
27 g_miss_attr_details_tbl attr_details_tbl_type;
28
29
30 TYPE partner_details_rec_type IS RECORD
31 (
32 orig_system varchar2(30),
33 orig_system_ref varchar2(255),
34 party_id NUMBER,
35 partner_id NUMBER,
36 partner_name varchar2(360),
37 attribute_details_tbl attr_details_tbl_type,
38 gbl_orig_system varchar2(30),
39 gbl_orig_system_ref varchar2(255),
40 gbl_party_id number,
41 gbl_partner_id number,
42 update_if_exists varchar2(1)
43 );
44 g_miss_partner_details_rec partner_details_rec_type := NULL;
45
46
47 TYPE partner_details_tbl_type IS TABLE OF partner_details_rec_type INDEX BY BINARY_INTEGER;
48 g_miss_partner_details_tbl partner_details_tbl_type;
49
50
51 TYPE partner_output_rec_type IS RECORD
52 (
53 orig_system varchar2(30),
54 orig_system_ref varchar2(255),
55 party_id NUMBER,
56 partner_id NUMBER,
57 return_status varchar2(10)
58 );
59 g_miss_partner_details_rec partner_output_rec_type := NULL;
60
61
62 TYPE partner_output_tbl_type IS TABLE OF partner_output_rec_type INDEX BY BINARY_INTEGER;
63 g_miss_partner_output_tbl partner_output_tbl_type;
64
65
66
67 /*#
68 * A public API to insert and/or update attribute information of Partners in the
69 * Oracle PRM application. Prior to insert/update, the API performs all the
70 * necessary business validations to ensure data integrity.
71 * @param p_api_version_number Version of the API
72 * @param p_init_msg_list Indicator whether to initialize the message stack
73 * @param p_mode A parameter that indicates if the API should be executed in an experimental mode. A value of "EVALUATION" indicates that the execution is experimental and no changes are committed. "EXECUTION" indicates that changes are to be committed.
74 * @param p_validation_level Level for validation
75 * @param x_return_status Status of the program
76 * @param x_msg_data Return message by the program
77 * @param x_msg_count Number of the messages returned by the program.
78 * @param p_partner_details_tbl Table related to partner details
79 * @param p_update_if_exists A Boolean parameter to indicate whether or not an update should be performed if a record already exists for the Partner. True indicates that the record should be updated with the supplied data.
80 * @param p_data_block_size A numerical parameter that indicates the number of Partner records to be processed per commit.
81 * @param x_file_name Path and Name of the log file generated by the API.
82 * @param x_partner_output_tbl A table that contains details about the Partners that were processed by the API.
83
84 * @rep:displayname Load Partners
85 * @rep:scope public
86 * @rep:lifecycle active
87 * @rep:compatibility N
88 */
89
90
91 PROCEDURE Load_Partners
92 (
93 p_api_version_number IN NUMBER
94 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
95 ,p_mode IN VARCHAR2
96 ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
97 ,x_return_status OUT NOCOPY VARCHAR2
98 ,x_msg_data OUT NOCOPY VARCHAR2
99 ,x_msg_count OUT NOCOPY NUMBER
100 ,p_partner_details_tbl IN partner_details_tbl_type
101 ,p_update_if_exists IN varchar2
102 ,p_data_block_size IN number
103 ,x_file_name OUT NOCOPY varchar2
104 ,x_partner_output_tbl OUT NOCOPY partner_output_tbl_type);
105
106
107
108 END PV_PARTNER_ATTR_LOAD_PUB;