1 PACKAGE csi_party_relationships_pub AUTHID CURRENT_USER AS
2 /* $Header: csipips.pls 120.1 2005/06/06 17:46:57 appldev $ */
3
4
5 /*----------------------------------------------------------*/
6 /* Procedure name: Get_inst_party_relationships */
7 /* Description : Procedure used to get party relationships */
8 /* for an item instance */
9 /*----------------------------------------------------------*/
10
11 PROCEDURE get_inst_party_relationships
12 ( p_api_version IN NUMBER
13 ,p_commit IN VARCHAR2 := fnd_api.g_false
14 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
15 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
16 ,p_party_query_rec IN csi_datastructures_pub.party_query_rec
17 ,p_resolve_id_columns IN VARCHAR2 := fnd_api.g_false
18 ,p_time_stamp IN DATE
19 ,x_party_header_tbl OUT NOCOPY csi_datastructures_pub.party_header_tbl
20 ,x_return_status OUT NOCOPY VARCHAR2
21 ,x_msg_count OUT NOCOPY NUMBER
22 ,x_msg_data OUT NOCOPY VARCHAR2 );
23
24
25 /*-------------------------------------------------------------*/
26 /* Procedure name: Create_inst_party_realationships */
27 /* Description : Procedure used to create new instance-party */
28 /* relationships */
29 /*-------------------------------------------------------------*/
30
31 PROCEDURE create_inst_party_relationship
32 ( p_api_version IN NUMBER
33 ,p_commit IN VARCHAR2 := fnd_api.g_false
34 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
35 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
36 ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
37 ,p_party_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
38 ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
39 ,p_oks_txn_inst_tbl IN OUT NOCOPY oks_ibint_pub.txn_instance_tbl
40 ,x_return_status OUT NOCOPY VARCHAR2
41 ,x_msg_count OUT NOCOPY NUMBER
42 ,x_msg_data OUT NOCOPY VARCHAR2 );
43
44
45 /*---------------------------------------------------------------*/
46 /* Procedure name: Update_inst_party_relationship */
47 /* Description : Procedure used to update the existing */
48 /* instance -party relationships */
49 /*---------------------------------------------------------------*/
50
51
52 PROCEDURE update_inst_party_relationship
53 ( p_api_version IN NUMBER
54 ,p_commit IN VARCHAR2 := fnd_api.g_false
55 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
56 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
57 ,p_party_tbl IN csi_datastructures_pub.party_tbl
58 ,p_party_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
59 ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
60 ,p_oks_txn_inst_tbl IN OUT NOCOPY oks_ibint_pub.txn_instance_tbl
61 ,x_return_status OUT NOCOPY VARCHAR2
62 ,x_msg_count OUT NOCOPY NUMBER
63 ,x_msg_data OUT NOCOPY VARCHAR2 );
64
65 /*---------------------------------------------------------------*/
66 /* Procedure name: Expire_inst_party_relationship */
67 /* Description : Procedure used to expire an existing */
68 /* instance -party relationships */
69 /*---------------------------------------------------------------*/
70
71 PROCEDURE expire_inst_party_relationship
72 ( p_api_version IN NUMBER
73 ,p_commit IN VARCHAR2 := fnd_api.g_false
74 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
75 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
76 ,p_instance_party_tbl IN csi_datastructures_pub.party_tbl
77 ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
78 ,x_return_status OUT NOCOPY VARCHAR2
79 ,x_msg_count OUT NOCOPY NUMBER
80 ,x_msg_data OUT NOCOPY VARCHAR2 );
81
82
83 /*----------------------------------------------------------------*/
84 /* Procedure name: Get_inst_party_account */
85 /* Description : Procedure used to get the accounts related to */
86 /* an instance-parties */
87 /*----------------------------------------------------------------*/
88
89 PROCEDURE get_inst_party_accounts
90 ( p_api_version IN NUMBER
91 ,p_commit IN VARCHAR2 := fnd_api.g_false
92 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
93 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
94 ,p_account_query_rec IN csi_datastructures_pub.party_account_query_rec
95 ,p_resolve_id_columns IN VARCHAR2 := fnd_api.g_false
96 ,p_time_stamp IN DATE
97 ,x_account_header_tbl OUT NOCOPY csi_datastructures_pub.party_account_header_tbl
98 ,x_return_status OUT NOCOPY VARCHAR2
99 ,x_msg_count OUT NOCOPY NUMBER
100 ,x_msg_data OUT NOCOPY VARCHAR2 );
101
102
103 /*----------------------------------------------------------*/
104 /* Procedure name: Create_inst_party_account */
105 /* Description : Procedure used to create new */
106 /* instance-party account relationships */
107 /*----------------------------------------------------------*/
108
109 PROCEDURE create_inst_party_account
110 ( p_api_version IN NUMBER
111 ,p_commit IN VARCHAR2 := fnd_api.g_false
112 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
113 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
114 ,p_party_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
115 ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
116 ,x_return_status OUT NOCOPY VARCHAR2
117 ,x_msg_count OUT NOCOPY NUMBER
118 ,x_msg_data OUT NOCOPY VARCHAR2 );
119
120 /*--------------------------------------------------------------*/
121 /* Procedure name: Update_inst_party_account */
122 /* Description : Procedure used to update the existing */
123 /* instance-party account relationships */
124 /*--------------------------------------------------------------*/
125
126 PROCEDURE update_inst_party_account
127 ( p_api_version IN NUMBER
128 ,p_commit IN VARCHAR2 := fnd_api.g_false
129 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
130 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
131 ,p_party_account_tbl IN csi_datastructures_pub.party_account_tbl
132 ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
133 ,x_return_status OUT NOCOPY VARCHAR2
134 ,x_msg_count OUT NOCOPY NUMBER
135 ,x_msg_data OUT NOCOPY VARCHAR2 );
136
137
138
139 /*-------------------------------------------------------------*/
140 /* Procedure name: Expire_inst_party_account */
141 /* Description : Procedure used to expire an existing */
142 /* instance-party account relationships */
143 /*-------------------------------------------------------------*/
144
145 PROCEDURE expire_inst_party_account
146 ( p_api_version IN NUMBER
147 ,p_commit IN VARCHAR2 := fnd_api.g_false
148 ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
149 ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
150 ,p_party_account_tbl IN csi_datastructures_pub.party_account_tbl
151 ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
152 ,x_return_status OUT NOCOPY VARCHAR2
153 ,x_msg_count OUT NOCOPY NUMBER
154 ,x_msg_data OUT NOCOPY VARCHAR2 );
155
156
157 END csi_party_relationships_pub ;
158