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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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