DBA Data[Home] [Help]

APPS.CSI_PARTY_RELATIONSHIPS_PVT dependencies on CSI_DATASTRUCTURES_PUB

Line 102: x_party_account_rec IN OUT NOCOPY csi_datastructures_pub.party_account_header_rec,

98: /*----------------------------------------------------------*/
99:
100: PROCEDURE Initialize_acct_rec
101: (
102: x_party_account_rec IN OUT NOCOPY csi_datastructures_pub.party_account_header_rec,
103: p_ip_account_hist_id IN NUMBER ,
104: x_nearest_full_dump IN OUT NOCOPY DATE );
105:
106: /*----------------------------------------------------------*/

Line 114: x_party_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_header_tbl,

110: /*----------------------------------------------------------*/
111:
112: PROCEDURE Construct_acct_from_hist
113: (
114: x_party_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_header_tbl,
115: p_time_stamp IN DATE ) ;
116:
117: /*----------------------------------------------------------*/
118: /* Procedure name: Resolve_id_columns */

Line 124: (p_account_header_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_header_tbl);

120: /* id columns */
121: /*----------------------------------------------------------*/
122:
123: PROCEDURE Resolve_id_columns
124: (p_account_header_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_header_tbl);
125:
126: /*----------------------------------------------------------*/
127: /* Procedure name: Get_Acct_Column_Values */
128: /* Description : This procudure gets the column values */

Line 135: x_pty_acct_query_rec OUT NOCOPY csi_datastructures_pub.party_account_header_rec );

131:
132: PROCEDURE Get_Acct_Column_Values
133: (
134: p_get_acct_cursor_id IN NUMBER ,
135: x_pty_acct_query_rec OUT NOCOPY csi_datastructures_pub.party_account_header_rec );
136:
137: /*----------------------------------------------------------*/
138: /* Procedure name: Define_Pty_Columns */
139: /* Description : This procudure defines the columns */

Line 156: p_pty_acct_query_rec IN csi_datastructures_pub.party_account_query_rec,

152: /*----------------------------------------------------------*/
153:
154: PROCEDURE Bind_Acct_variable
155: (
156: p_pty_acct_query_rec IN csi_datastructures_pub.party_account_query_rec,
157: p_get_acct_cursor_id IN NUMBER );
158:
159:
160:

Line 169: p_pty_acct_query_rec IN csi_datastructures_pub.party_account_query_rec

165: /*----------------------------------------------------------*/
166:
167: PROCEDURE Gen_Acct_Where_Clause
168: (
169: p_pty_acct_query_rec IN csi_datastructures_pub.party_account_query_rec
170: ,x_where_clause OUT NOCOPY VARCHAR2 );
171:
172:
173: /*----------------------------------------------------------*/

Line 182: x_party_rec OUT NOCOPY csi_datastructures_pub.party_header_rec );

178:
179: PROCEDURE Get_Pty_Column_Values
180: (
181: p_get_pty_cursor_id IN NUMBER ,
182: x_party_rec OUT NOCOPY csi_datastructures_pub.party_header_rec );
183:
184:
185: /*----------------------------------------------------------*/
186: /* Procedure name: Define_Pty_Columns */

Line 203: p_party_query_rec IN csi_datastructures_pub.party_query_rec,

199: /*----------------------------------------------------------*/
200:
201: PROCEDURE Bind_Pty_variable
202: (
203: p_party_query_rec IN csi_datastructures_pub.party_query_rec,
204: p_cur_get_pty_rel IN NUMBER );
205:
206: /*----------------------------------------------------------*/
207: /* Procedure name: Gen_Pty_Where_Clause */

Line 214: p_party_query_rec IN csi_datastructures_pub.party_query_rec

210: /*----------------------------------------------------------*/
211:
212: PROCEDURE Gen_Pty_Where_Clause
213: (
214: p_party_query_rec IN csi_datastructures_pub.party_query_rec
215: ,x_where_clause OUT NOCOPY VARCHAR2 );
216:
217: /*----------------------------------------------------------*/
218: /* Procedure name: Construct_pty_from_hist */

Line 225: x_party_rec IN OUT NOCOPY csi_datastructures_pub.party_header_rec,

221: /*----------------------------------------------------------*/
222:
223: PROCEDURE Initialize_pty_rec
224: (
225: x_party_rec IN OUT NOCOPY csi_datastructures_pub.party_header_rec,
226: p_inst_party_hist_id IN NUMBER ,
227: x_nearest_full_dump IN OUT NOCOPY DATE );
228:
229:

Line 238: x_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_header_tbl,

234: /*----------------------------------------------------------*/
235:
236: PROCEDURE Construct_pty_from_hist
237: (
238: x_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_header_tbl,
239: p_time_stamp IN DATE ) ;
240:
241:
242: /*-----------------------------------------------------------*/

Line 253: ,p_party_rec IN OUT NOCOPY csi_datastructures_pub.party_rec

249: ( p_api_version IN NUMBER
250: ,p_commit IN VARCHAR2 := fnd_api.g_false
251: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
252: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
253: ,p_party_rec IN OUT NOCOPY csi_datastructures_pub.party_rec
254: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
255: ,x_return_status OUT NOCOPY VARCHAR2
256: ,x_msg_count OUT NOCOPY NUMBER
257: ,x_msg_data OUT NOCOPY VARCHAR2

Line 254: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

250: ,p_commit IN VARCHAR2 := fnd_api.g_false
251: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
252: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
253: ,p_party_rec IN OUT NOCOPY csi_datastructures_pub.party_rec
254: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
255: ,x_return_status OUT NOCOPY VARCHAR2
256: ,x_msg_count OUT NOCOPY NUMBER
257: ,x_msg_data OUT NOCOPY VARCHAR2
258: ,p_party_source_tbl IN OUT NOCOPY csi_party_relationships_pvt.party_source_tbl

Line 279: ,p_party_rec IN OUT NOCOPY csi_datastructures_pub.party_rec

275: ( p_api_version IN NUMBER
276: ,p_commit IN VARCHAR2 := fnd_api.g_false
277: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
278: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
279: ,p_party_rec IN OUT NOCOPY csi_datastructures_pub.party_rec
280: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
281: ,x_return_status OUT NOCOPY VARCHAR2
282: ,x_msg_count OUT NOCOPY NUMBER
283: ,x_msg_data OUT NOCOPY VARCHAR2 );

Line 280: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

276: ,p_commit IN VARCHAR2 := fnd_api.g_false
277: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
278: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
279: ,p_party_rec IN OUT NOCOPY csi_datastructures_pub.party_rec
280: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
281: ,x_return_status OUT NOCOPY VARCHAR2
282: ,x_msg_count OUT NOCOPY NUMBER
283: ,x_msg_data OUT NOCOPY VARCHAR2 );
284:

Line 297: ,p_instance_party_rec IN csi_datastructures_pub.party_rec

293: ( p_api_version IN NUMBER
294: ,p_commit IN VARCHAR2 := fnd_api.g_false
295: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
296: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
297: ,p_instance_party_rec IN csi_datastructures_pub.party_rec
298: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
299: ,x_return_status OUT NOCOPY VARCHAR2
300: ,x_msg_count OUT NOCOPY NUMBER
301: ,x_msg_data OUT NOCOPY VARCHAR2 );

Line 298: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

294: ,p_commit IN VARCHAR2 := fnd_api.g_false
295: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
296: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
297: ,p_instance_party_rec IN csi_datastructures_pub.party_rec
298: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
299: ,x_return_status OUT NOCOPY VARCHAR2
300: ,x_msg_count OUT NOCOPY NUMBER
301: ,x_msg_data OUT NOCOPY VARCHAR2 );
302:

Line 314: ,p_party_account_rec IN OUT NOCOPY csi_datastructures_pub.party_account_rec

310: ( p_api_version IN NUMBER
311: ,p_commit IN VARCHAR2 := fnd_api.g_false
312: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
313: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
314: ,p_party_account_rec IN OUT NOCOPY csi_datastructures_pub.party_account_rec
315: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
316: ,x_return_status OUT NOCOPY VARCHAR2
317: ,x_msg_count OUT NOCOPY NUMBER
318: ,x_msg_data OUT NOCOPY VARCHAR2

Line 315: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

311: ,p_commit IN VARCHAR2 := fnd_api.g_false
312: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
313: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
314: ,p_party_account_rec IN OUT NOCOPY csi_datastructures_pub.party_account_rec
315: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
316: ,x_return_status OUT NOCOPY VARCHAR2
317: ,x_msg_count OUT NOCOPY NUMBER
318: ,x_msg_data OUT NOCOPY VARCHAR2
319: ,p_inst_party_tbl IN OUT NOCOPY csi_party_relationships_pvt.inst_party_tbl

Line 338: ,p_party_account_rec IN csi_datastructures_pub.party_account_rec

334: ( p_api_version IN NUMBER
335: ,p_commit IN VARCHAR2 := fnd_api.g_false
336: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
337: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
338: ,p_party_account_rec IN csi_datastructures_pub.party_account_rec
339: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
340: ,p_oks_txn_inst_tbl IN OUT NOCOPY oks_ibint_pub.txn_instance_tbl
341: ,x_return_status OUT NOCOPY VARCHAR2
342: ,x_msg_count OUT NOCOPY NUMBER

Line 339: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

335: ,p_commit IN VARCHAR2 := fnd_api.g_false
336: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
337: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
338: ,p_party_account_rec IN csi_datastructures_pub.party_account_rec
339: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
340: ,p_oks_txn_inst_tbl IN OUT NOCOPY oks_ibint_pub.txn_instance_tbl
341: ,x_return_status OUT NOCOPY VARCHAR2
342: ,x_msg_count OUT NOCOPY NUMBER
343: ,x_msg_data OUT NOCOPY VARCHAR2 );

Line 357: ,p_party_account_rec IN csi_datastructures_pub.party_account_rec

353: ( p_api_version IN NUMBER
354: ,p_commit IN VARCHAR2 := fnd_api.g_false
355: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
356: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
357: ,p_party_account_rec IN csi_datastructures_pub.party_account_rec
358: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
359: ,x_return_status OUT NOCOPY VARCHAR2
360: ,x_msg_count OUT NOCOPY NUMBER
361: ,x_msg_data OUT NOCOPY VARCHAR2 );

Line 358: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

354: ,p_commit IN VARCHAR2 := fnd_api.g_false
355: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
356: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
357: ,p_party_account_rec IN csi_datastructures_pub.party_account_rec
358: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
359: ,x_return_status OUT NOCOPY VARCHAR2
360: ,x_msg_count OUT NOCOPY NUMBER
361: ,x_msg_data OUT NOCOPY VARCHAR2 );
362:

Line 380: ,x_contact_details OUT NOCOPY csi_datastructures_pub.contact_details_rec

376: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
377: ,p_contact_party_id IN NUMBER
378: ,p_contact_flag IN VARCHAR2
379: ,p_party_tbl IN VARCHAR2
380: ,x_contact_details OUT NOCOPY csi_datastructures_pub.contact_details_rec
381: ,x_return_status OUT NOCOPY VARCHAR2
382: ,x_msg_count OUT NOCOPY NUMBER
383: ,x_msg_data OUT NOCOPY VARCHAR2 );
384:

Line 398: ,x_party_history_tbl OUT NOCOPY csi_datastructures_pub.party_history_tbl

394: ,p_commit IN VARCHAR2 := fnd_api.g_false
395: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
396: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
397: ,p_transaction_id IN NUMBER
398: ,x_party_history_tbl OUT NOCOPY csi_datastructures_pub.party_history_tbl
399: ,x_return_status OUT NOCOPY VARCHAR2
400: ,x_msg_count OUT NOCOPY NUMBER
401: ,x_msg_data OUT NOCOPY VARCHAR2
402: );

Line 418: ,x_account_history_tbl OUT NOCOPY csi_datastructures_pub.account_history_tbl

414: ,p_commit IN VARCHAR2 := fnd_api.g_false
415: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
416: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
417: ,p_transaction_id IN NUMBER
418: ,x_account_history_tbl OUT NOCOPY csi_datastructures_pub.account_history_tbl
419: ,x_return_status OUT NOCOPY VARCHAR2
420: ,x_msg_count OUT NOCOPY NUMBER
421: ,x_msg_data OUT NOCOPY VARCHAR2
422: );