10: /*------------------------------------------------------*/
11:
12: TYPE PARTY_SOURCE_TAB_REC IS RECORD
13: (
14: party_source_table VARCHAR2(30) := FND_API.G_MISS_CHAR
15: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
16: );
17:
18: TYPE PARTY_SOURCE_TBL IS TABLE OF PARTY_SOURCE_TAB_REC INDEX BY BINARY_INTEGER;
11:
12: TYPE PARTY_SOURCE_TAB_REC IS RECORD
13: (
14: party_source_table VARCHAR2(30) := FND_API.G_MISS_CHAR
15: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
16: );
17:
18: TYPE PARTY_SOURCE_TBL IS TABLE OF PARTY_SOURCE_TAB_REC INDEX BY BINARY_INTEGER;
19: --
18: TYPE PARTY_SOURCE_TBL IS TABLE OF PARTY_SOURCE_TAB_REC INDEX BY BINARY_INTEGER;
19: --
20: TYPE PARTY_ID_REC IS RECORD
21: (
22: party_id NUMBER := FND_API.G_MISS_NUM
23: ,party_source_table VARCHAR2(30) := FND_API.G_MISS_CHAR
24: ,contact_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
25: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
26: );
19: --
20: TYPE PARTY_ID_REC IS RECORD
21: (
22: party_id NUMBER := FND_API.G_MISS_NUM
23: ,party_source_table VARCHAR2(30) := FND_API.G_MISS_CHAR
24: ,contact_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
25: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
26: );
27:
20: TYPE PARTY_ID_REC IS RECORD
21: (
22: party_id NUMBER := FND_API.G_MISS_NUM
23: ,party_source_table VARCHAR2(30) := FND_API.G_MISS_CHAR
24: ,contact_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
25: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
26: );
27:
28: TYPE PARTY_ID_TBL IS TABLE OF PARTY_ID_REC INDEX BY BINARY_INTEGER;
21: (
22: party_id NUMBER := FND_API.G_MISS_NUM
23: ,party_source_table VARCHAR2(30) := FND_API.G_MISS_CHAR
24: ,contact_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
25: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
26: );
27:
28: TYPE PARTY_ID_TBL IS TABLE OF PARTY_ID_REC INDEX BY BINARY_INTEGER;
29: --
28: TYPE PARTY_ID_TBL IS TABLE OF PARTY_ID_REC INDEX BY BINARY_INTEGER;
29: --
30: TYPE CONTACT_REC IS RECORD
31: (
32: contact_party_id NUMBER := FND_API.G_MISS_NUM
33: ,party_source_table VARCHAR2(30) := FND_API.G_MISS_CHAR
34: ,contact_ip_id NUMBER := FND_API.G_MISS_NUM
35: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
36: );
29: --
30: TYPE CONTACT_REC IS RECORD
31: (
32: contact_party_id NUMBER := FND_API.G_MISS_NUM
33: ,party_source_table VARCHAR2(30) := FND_API.G_MISS_CHAR
34: ,contact_ip_id NUMBER := FND_API.G_MISS_NUM
35: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
36: );
37:
30: TYPE CONTACT_REC IS RECORD
31: (
32: contact_party_id NUMBER := FND_API.G_MISS_NUM
33: ,party_source_table VARCHAR2(30) := FND_API.G_MISS_CHAR
34: ,contact_ip_id NUMBER := FND_API.G_MISS_NUM
35: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
36: );
37:
38: TYPE CONTACT_TBL IS TABLE OF CONTACT_REC INDEX BY BINARY_INTEGER;
31: (
32: contact_party_id NUMBER := FND_API.G_MISS_NUM
33: ,party_source_table VARCHAR2(30) := FND_API.G_MISS_CHAR
34: ,contact_ip_id NUMBER := FND_API.G_MISS_NUM
35: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
36: );
37:
38: TYPE CONTACT_TBL IS TABLE OF CONTACT_REC INDEX BY BINARY_INTEGER;
39: --
38: TYPE CONTACT_TBL IS TABLE OF CONTACT_REC INDEX BY BINARY_INTEGER;
39: --
40: TYPE PARTY_REL_TYPE_REC IS RECORD
41: (
42: rel_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
43: ,contact_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
44: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
45: );
46:
39: --
40: TYPE PARTY_REL_TYPE_REC IS RECORD
41: (
42: rel_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
43: ,contact_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
44: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
45: );
46:
47: TYPE PARTY_REL_TYPE_TBL IS TABLE OF PARTY_REL_TYPE_REC INDEX BY BINARY_INTEGER;
40: TYPE PARTY_REL_TYPE_REC IS RECORD
41: (
42: rel_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
43: ,contact_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
44: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
45: );
46:
47: TYPE PARTY_REL_TYPE_TBL IS TABLE OF PARTY_REL_TYPE_REC INDEX BY BINARY_INTEGER;
48: --
47: TYPE PARTY_REL_TYPE_TBL IS TABLE OF PARTY_REL_TYPE_REC INDEX BY BINARY_INTEGER;
48: --
49: TYPE PARTY_COUNT_REC IS RECORD
50: (
51: party_source_count NUMBER := FND_API.G_MISS_NUM
52: ,party_id_count NUMBER := FND_API.G_MISS_NUM
53: ,contact_id_count NUMBER := FND_API.G_MISS_NUM
54: ,rel_type_count NUMBER := FND_API.G_MISS_NUM
55: );
48: --
49: TYPE PARTY_COUNT_REC IS RECORD
50: (
51: party_source_count NUMBER := FND_API.G_MISS_NUM
52: ,party_id_count NUMBER := FND_API.G_MISS_NUM
53: ,contact_id_count NUMBER := FND_API.G_MISS_NUM
54: ,rel_type_count NUMBER := FND_API.G_MISS_NUM
55: );
56: --
49: TYPE PARTY_COUNT_REC IS RECORD
50: (
51: party_source_count NUMBER := FND_API.G_MISS_NUM
52: ,party_id_count NUMBER := FND_API.G_MISS_NUM
53: ,contact_id_count NUMBER := FND_API.G_MISS_NUM
54: ,rel_type_count NUMBER := FND_API.G_MISS_NUM
55: );
56: --
57: TYPE INST_PARTY_REC IS RECORD
50: (
51: party_source_count NUMBER := FND_API.G_MISS_NUM
52: ,party_id_count NUMBER := FND_API.G_MISS_NUM
53: ,contact_id_count NUMBER := FND_API.G_MISS_NUM
54: ,rel_type_count NUMBER := FND_API.G_MISS_NUM
55: );
56: --
57: TYPE INST_PARTY_REC IS RECORD
58: (
55: );
56: --
57: TYPE INST_PARTY_REC IS RECORD
58: (
59: instance_party_id NUMBER := FND_API.G_MISS_NUM
60: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
61: );
62: TYPE INST_PARTY_TBL IS TABLE OF INST_PARTY_REC INDEX BY BINARY_INTEGER;
63: --
56: --
57: TYPE INST_PARTY_REC IS RECORD
58: (
59: instance_party_id NUMBER := FND_API.G_MISS_NUM
60: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
61: );
62: TYPE INST_PARTY_TBL IS TABLE OF INST_PARTY_REC INDEX BY BINARY_INTEGER;
63: --
64: TYPE ACCT_REL_TYPE_REC IS RECORD
62: TYPE INST_PARTY_TBL IS TABLE OF INST_PARTY_REC INDEX BY BINARY_INTEGER;
63: --
64: TYPE ACCT_REL_TYPE_REC IS RECORD
65: (
66: rel_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
67: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
68: );
69: TYPE ACCT_REL_TYPE_TBL IS TABLE OF ACCT_REL_TYPE_REC INDEX BY BINARY_INTEGER;
70: --
63: --
64: TYPE ACCT_REL_TYPE_REC IS RECORD
65: (
66: rel_type_code VARCHAR2(30) := FND_API.G_MISS_CHAR
67: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
68: );
69: TYPE ACCT_REL_TYPE_TBL IS TABLE OF ACCT_REL_TYPE_REC INDEX BY BINARY_INTEGER;
70: --
71: TYPE SITE_USE_REC IS RECORD
69: TYPE ACCT_REL_TYPE_TBL IS TABLE OF ACCT_REL_TYPE_REC INDEX BY BINARY_INTEGER;
70: --
71: TYPE SITE_USE_REC IS RECORD
72: (
73: Site_use_id NUMBER := FND_API.G_MISS_NUM
74: ,site_use_code VARCHAR2(30) := FND_API.G_MISS_CHAR
75: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
76: );
77: TYPE SITE_USE_TBL IS TABLE OF SITE_USE_REC INDEX BY BINARY_INTEGER;
70: --
71: TYPE SITE_USE_REC IS RECORD
72: (
73: Site_use_id NUMBER := FND_API.G_MISS_NUM
74: ,site_use_code VARCHAR2(30) := FND_API.G_MISS_CHAR
75: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
76: );
77: TYPE SITE_USE_TBL IS TABLE OF SITE_USE_REC INDEX BY BINARY_INTEGER;
78: --
71: TYPE SITE_USE_REC IS RECORD
72: (
73: Site_use_id NUMBER := FND_API.G_MISS_NUM
74: ,site_use_code VARCHAR2(30) := FND_API.G_MISS_CHAR
75: ,valid_flag VARCHAR2(1) := FND_API.G_MISS_CHAR
76: );
77: TYPE SITE_USE_TBL IS TABLE OF SITE_USE_REC INDEX BY BINARY_INTEGER;
78: --
79: TYPE ACCOUNT_COUNT_REC IS RECORD
77: TYPE SITE_USE_TBL IS TABLE OF SITE_USE_REC INDEX BY BINARY_INTEGER;
78: --
79: TYPE ACCOUNT_COUNT_REC IS RECORD
80: (
81: inst_party_count NUMBER := FND_API.G_MISS_NUM
82: ,rel_type_count NUMBER := FND_API.G_MISS_NUM
83: ,site_use_count NUMBER := FND_API.G_MISS_NUM
84: );
85: --
78: --
79: TYPE ACCOUNT_COUNT_REC IS RECORD
80: (
81: inst_party_count NUMBER := FND_API.G_MISS_NUM
82: ,rel_type_count NUMBER := FND_API.G_MISS_NUM
83: ,site_use_count NUMBER := FND_API.G_MISS_NUM
84: );
85: --
86: TYPE ACCT_ID_REC IS RECORD
79: TYPE ACCOUNT_COUNT_REC IS RECORD
80: (
81: inst_party_count NUMBER := FND_API.G_MISS_NUM
82: ,rel_type_count NUMBER := FND_API.G_MISS_NUM
83: ,site_use_count NUMBER := FND_API.G_MISS_NUM
84: );
85: --
86: TYPE ACCT_ID_REC IS RECORD
87: (
246: /*-----------------------------------------------------------*/
247:
248: PROCEDURE create_inst_party_relationship
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
247:
248: PROCEDURE create_inst_party_relationship
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
248: PROCEDURE create_inst_party_relationship
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
259: ,p_party_id_tbl IN OUT NOCOPY csi_party_relationships_pvt.party_id_tbl
260: ,p_contact_tbl IN OUT NOCOPY csi_party_relationships_pvt.contact_tbl
261: ,p_party_rel_type_tbl IN OUT NOCOPY csi_party_relationships_pvt.party_rel_type_tbl
262: ,p_party_count_rec IN OUT NOCOPY csi_party_relationships_pvt.party_count_rec
263: ,p_called_from_grp IN VARCHAR2 DEFAULT fnd_api.g_false
264: );
265:
266:
267: /*---------------------------------------------------------*/
272:
273:
274: PROCEDURE update_inst_party_relationship
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
273:
274: PROCEDURE update_inst_party_relationship
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
274: PROCEDURE update_inst_party_relationship
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
290: /*---------------------------------------------------------*/
291:
292: PROCEDURE expire_inst_party_relationship
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
291:
292: PROCEDURE expire_inst_party_relationship
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
292: PROCEDURE expire_inst_party_relationship
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
307: /*-------------------------------------------------------------*/
308:
309: PROCEDURE create_inst_party_account
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
308:
309: PROCEDURE create_inst_party_account
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
309: PROCEDURE create_inst_party_account
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
319: ,p_inst_party_tbl IN OUT NOCOPY csi_party_relationships_pvt.inst_party_tbl
320: ,p_acct_rel_type_tbl IN OUT NOCOPY csi_party_relationships_pvt.acct_rel_type_tbl
321: ,p_site_use_tbl IN OUT NOCOPY csi_party_relationships_pvt.site_use_tbl
322: ,p_account_count_rec IN OUT NOCOPY csi_party_relationships_pvt.account_count_rec
323: ,p_called_from_grp IN VARCHAR2 DEFAULT fnd_api.g_false
324: ,p_oks_txn_inst_tbl IN OUT NOCOPY oks_ibint_pub.txn_instance_tbl
325: );
326:
327: /*--------------------------------------------------------*/
331: /*--------------------------------------------------------*/
332:
333: PROCEDURE update_inst_party_account
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
332:
333: PROCEDURE update_inst_party_account
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
333: PROCEDURE update_inst_party_account
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
350:
351:
352: PROCEDURE expire_inst_party_account
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
351:
352: PROCEDURE expire_inst_party_account
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
352: PROCEDURE expire_inst_party_account
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
370:
371: PROCEDURE get_contact_details
372: (
373: p_api_version IN NUMBER
374: ,p_commit IN VARCHAR2 := fnd_api.g_false
375: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
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
371: PROCEDURE get_contact_details
372: (
373: p_api_version IN NUMBER
374: ,p_commit IN VARCHAR2 := fnd_api.g_false
375: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
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
372: (
373: p_api_version IN NUMBER
374: ,p_commit IN VARCHAR2 := fnd_api.g_false
375: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
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
390: /*------------------------------------------------------------*/
391:
392: PROCEDURE get_inst_party_rel_hist
393: ( p_api_version IN NUMBER
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
391:
392: PROCEDURE get_inst_party_rel_hist
393: ( p_api_version IN NUMBER
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
392: PROCEDURE get_inst_party_rel_hist
393: ( p_api_version IN NUMBER
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
410: /*------------------------------------------------------------*/
411:
412: PROCEDURE get_inst_party_account_hist
413: ( p_api_version IN NUMBER
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
411:
412: PROCEDURE get_inst_party_account_hist
413: ( p_api_version IN NUMBER
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
412: PROCEDURE get_inst_party_account_hist
413: ( p_api_version IN NUMBER
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