eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSI_PARTY_RELATIONSHIPS_PUB dependencies on CSI_PARTY_RELATIONSHIPS_PVT

Line 115: csi_party_relationships_pvt.Gen_Pty_Where_Clause

111: RAISE FND_API.G_EXC_ERROR;
112: END IF;
113:
114: -- Generate the where clause dynamically
115: csi_party_relationships_pvt.Gen_Pty_Where_Clause
116: ( p_party_query_rec => p_party_query_rec,
117: x_where_clause => l_where_clause );
118:
119: -- Build the select statement

Line 129: csi_party_relationships_pvt.Bind_pty_variable(p_party_query_rec, l_get_party_cursor_id);

125: --Parse the select statement
126: dbms_sql.parse(l_get_party_cursor_id, l_select_stmt , dbms_sql.native);
127:
128: -- Bind the variables
129: csi_party_relationships_pvt.Bind_pty_variable(p_party_query_rec, l_get_party_cursor_id);
130:
131: -- Define output variables
132: csi_party_relationships_pvt.Define_Pty_Columns(l_get_party_cursor_id);
133:

Line 132: csi_party_relationships_pvt.Define_Pty_Columns(l_get_party_cursor_id);

128: -- Bind the variables
129: csi_party_relationships_pvt.Bind_pty_variable(p_party_query_rec, l_get_party_cursor_id);
130:
131: -- Define output variables
132: csi_party_relationships_pvt.Define_Pty_Columns(l_get_party_cursor_id);
133:
134: -- execute the select statement
135: l_rows_processed := dbms_sql.execute(l_get_party_cursor_id);
136:

Line 140: csi_party_relationships_pvt.Get_pty_Column_Values(l_get_party_cursor_id, l_party_rec);

136:
137: LOOP
138: EXIT WHEN DBMS_SQL.FETCH_ROWS(l_get_party_cursor_id) = 0;
139: -- get the values after executing the selecl statement
140: csi_party_relationships_pvt.Get_pty_Column_Values(l_get_party_cursor_id, l_party_rec);
141: l_count := l_count + 1;
142: x_party_header_tbl(l_count) := l_party_rec;
143: END LOOP;
144:

Line 153: csi_party_relationships_pvt.Construct_pty_from_hist(x_party_header_tbl, p_time_stamp);

149:
150: IF p_time_stamp <= sysdate THEN
151: -- contruct from the history if the p_time_stamp
152: -- is < than sysdate
153: csi_party_relationships_pvt.Construct_pty_from_hist(x_party_header_tbl, p_time_stamp);
154: ELSE
155: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_HIST_PARAMS');
156: FND_MSG_PUB.ADD;
157: RAISE FND_API.G_EXC_ERROR;

Line 173: csi_party_relationships_pvt.get_contact_details

169: l_contact_party_id := x_party_header_tbl(i).instance_party_id ;
170: l_contact_flag := x_party_header_tbl(i).contact_flag;
171: l_party_source_tbl := x_party_header_tbl(i).party_source_table;
172:
173: csi_party_relationships_pvt.get_contact_details
174: (
175: p_api_version => p_api_version
176: ,p_commit => p_commit
177: ,p_init_msg_list => p_init_msg_list

Line 385: l_party_source_tbl csi_party_relationships_pvt.party_source_tbl;

381: l_internal_party_id NUMBER;
382: l_msg_index NUMBER;
383: l_msg_count NUMBER;
384: l_flag VARCHAR2(1) :='N';
385: l_party_source_tbl csi_party_relationships_pvt.party_source_tbl;
386: l_party_id_tbl csi_party_relationships_pvt.party_id_tbl;
387: l_contact_tbl csi_party_relationships_pvt.contact_tbl;
388: l_party_rel_type_tbl csi_party_relationships_pvt.party_rel_type_tbl;
389: l_party_count_rec csi_party_relationships_pvt.party_count_rec;

Line 386: l_party_id_tbl csi_party_relationships_pvt.party_id_tbl;

382: l_msg_index NUMBER;
383: l_msg_count NUMBER;
384: l_flag VARCHAR2(1) :='N';
385: l_party_source_tbl csi_party_relationships_pvt.party_source_tbl;
386: l_party_id_tbl csi_party_relationships_pvt.party_id_tbl;
387: l_contact_tbl csi_party_relationships_pvt.contact_tbl;
388: l_party_rel_type_tbl csi_party_relationships_pvt.party_rel_type_tbl;
389: l_party_count_rec csi_party_relationships_pvt.party_count_rec;
390: l_inst_party_tbl csi_party_relationships_pvt.inst_party_tbl;

Line 387: l_contact_tbl csi_party_relationships_pvt.contact_tbl;

383: l_msg_count NUMBER;
384: l_flag VARCHAR2(1) :='N';
385: l_party_source_tbl csi_party_relationships_pvt.party_source_tbl;
386: l_party_id_tbl csi_party_relationships_pvt.party_id_tbl;
387: l_contact_tbl csi_party_relationships_pvt.contact_tbl;
388: l_party_rel_type_tbl csi_party_relationships_pvt.party_rel_type_tbl;
389: l_party_count_rec csi_party_relationships_pvt.party_count_rec;
390: l_inst_party_tbl csi_party_relationships_pvt.inst_party_tbl;
391: l_acct_rel_type_tbl csi_party_relationships_pvt.acct_rel_type_tbl;

Line 388: l_party_rel_type_tbl csi_party_relationships_pvt.party_rel_type_tbl;

384: l_flag VARCHAR2(1) :='N';
385: l_party_source_tbl csi_party_relationships_pvt.party_source_tbl;
386: l_party_id_tbl csi_party_relationships_pvt.party_id_tbl;
387: l_contact_tbl csi_party_relationships_pvt.contact_tbl;
388: l_party_rel_type_tbl csi_party_relationships_pvt.party_rel_type_tbl;
389: l_party_count_rec csi_party_relationships_pvt.party_count_rec;
390: l_inst_party_tbl csi_party_relationships_pvt.inst_party_tbl;
391: l_acct_rel_type_tbl csi_party_relationships_pvt.acct_rel_type_tbl;
392: l_site_use_tbl csi_party_relationships_pvt.site_use_tbl;

Line 389: l_party_count_rec csi_party_relationships_pvt.party_count_rec;

385: l_party_source_tbl csi_party_relationships_pvt.party_source_tbl;
386: l_party_id_tbl csi_party_relationships_pvt.party_id_tbl;
387: l_contact_tbl csi_party_relationships_pvt.contact_tbl;
388: l_party_rel_type_tbl csi_party_relationships_pvt.party_rel_type_tbl;
389: l_party_count_rec csi_party_relationships_pvt.party_count_rec;
390: l_inst_party_tbl csi_party_relationships_pvt.inst_party_tbl;
391: l_acct_rel_type_tbl csi_party_relationships_pvt.acct_rel_type_tbl;
392: l_site_use_tbl csi_party_relationships_pvt.site_use_tbl;
393: l_account_count_rec csi_party_relationships_pvt.account_count_rec;

Line 390: l_inst_party_tbl csi_party_relationships_pvt.inst_party_tbl;

386: l_party_id_tbl csi_party_relationships_pvt.party_id_tbl;
387: l_contact_tbl csi_party_relationships_pvt.contact_tbl;
388: l_party_rel_type_tbl csi_party_relationships_pvt.party_rel_type_tbl;
389: l_party_count_rec csi_party_relationships_pvt.party_count_rec;
390: l_inst_party_tbl csi_party_relationships_pvt.inst_party_tbl;
391: l_acct_rel_type_tbl csi_party_relationships_pvt.acct_rel_type_tbl;
392: l_site_use_tbl csi_party_relationships_pvt.site_use_tbl;
393: l_account_count_rec csi_party_relationships_pvt.account_count_rec;
394: l_account_found VARCHAR2(1) :=NULL;

Line 391: l_acct_rel_type_tbl csi_party_relationships_pvt.acct_rel_type_tbl;

387: l_contact_tbl csi_party_relationships_pvt.contact_tbl;
388: l_party_rel_type_tbl csi_party_relationships_pvt.party_rel_type_tbl;
389: l_party_count_rec csi_party_relationships_pvt.party_count_rec;
390: l_inst_party_tbl csi_party_relationships_pvt.inst_party_tbl;
391: l_acct_rel_type_tbl csi_party_relationships_pvt.acct_rel_type_tbl;
392: l_site_use_tbl csi_party_relationships_pvt.site_use_tbl;
393: l_account_count_rec csi_party_relationships_pvt.account_count_rec;
394: l_account_found VARCHAR2(1) :=NULL;
395: BEGIN

Line 392: l_site_use_tbl csi_party_relationships_pvt.site_use_tbl;

388: l_party_rel_type_tbl csi_party_relationships_pvt.party_rel_type_tbl;
389: l_party_count_rec csi_party_relationships_pvt.party_count_rec;
390: l_inst_party_tbl csi_party_relationships_pvt.inst_party_tbl;
391: l_acct_rel_type_tbl csi_party_relationships_pvt.acct_rel_type_tbl;
392: l_site_use_tbl csi_party_relationships_pvt.site_use_tbl;
393: l_account_count_rec csi_party_relationships_pvt.account_count_rec;
394: l_account_found VARCHAR2(1) :=NULL;
395: BEGIN
396: -- Standard Start of API savepoint

Line 393: l_account_count_rec csi_party_relationships_pvt.account_count_rec;

389: l_party_count_rec csi_party_relationships_pvt.party_count_rec;
390: l_inst_party_tbl csi_party_relationships_pvt.inst_party_tbl;
391: l_acct_rel_type_tbl csi_party_relationships_pvt.acct_rel_type_tbl;
392: l_site_use_tbl csi_party_relationships_pvt.site_use_tbl;
393: l_account_count_rec csi_party_relationships_pvt.account_count_rec;
394: l_account_found VARCHAR2(1) :=NULL;
395: BEGIN
396: -- Standard Start of API savepoint
397: SAVEPOINT create_inst_party_rel_pub;

Line 524: csi_party_relationships_pvt.create_inst_party_relationship

520:
521: -- End of addition by sguthiva
522:
523: -- Call Private package to validate and create party relationship
524: csi_party_relationships_pvt.create_inst_party_relationship
525: ( p_api_version => p_api_version
526: ,p_commit => p_commit
527: ,p_init_msg_list => p_init_msg_list
528: ,p_validation_level => p_validation_level

Line 602: csi_party_relationships_pvt.update_inst_party_account

598: IF p_party_account_tbl(l_acct_row).ip_account_id IS NOT NULL
599: AND p_party_account_tbl(l_acct_row).ip_account_id <> fnd_api.g_miss_num
600: AND l_account_found IS NOT NULL
601: THEN
602: csi_party_relationships_pvt.update_inst_party_account
603: ( p_api_version => p_api_version
604: ,p_commit => p_commit
605: ,p_init_msg_list => p_init_msg_list
606: ,p_validation_level => p_validation_level

Line 614: csi_party_relationships_pvt.create_inst_party_account

610: ,x_return_status => x_return_status
611: ,x_msg_count => x_msg_count
612: ,x_msg_data => x_msg_data);
613: ELSE
614: csi_party_relationships_pvt.create_inst_party_account
615: ( p_api_version => p_api_version
616: ,p_commit => p_commit
617: ,p_init_msg_list => p_init_msg_list
618: ,p_validation_level => p_validation_level

Line 735: l_inst_party_tbl csi_party_relationships_pvt.inst_party_tbl;

731: l_msg_index NUMBER;
732: l_msg_count NUMBER;
733: l_line_count NUMBER;
734: l_flag VARCHAR2(1) :='N';
735: l_inst_party_tbl csi_party_relationships_pvt.inst_party_tbl;
736: l_acct_rel_type_tbl csi_party_relationships_pvt.acct_rel_type_tbl;
737: l_site_use_tbl csi_party_relationships_pvt.site_use_tbl;
738: l_account_count_rec csi_party_relationships_pvt.account_count_rec;
739: p_rel_query_rec csi_datastructures_pub.relationship_query_rec;

Line 736: l_acct_rel_type_tbl csi_party_relationships_pvt.acct_rel_type_tbl;

732: l_msg_count NUMBER;
733: l_line_count NUMBER;
734: l_flag VARCHAR2(1) :='N';
735: l_inst_party_tbl csi_party_relationships_pvt.inst_party_tbl;
736: l_acct_rel_type_tbl csi_party_relationships_pvt.acct_rel_type_tbl;
737: l_site_use_tbl csi_party_relationships_pvt.site_use_tbl;
738: l_account_count_rec csi_party_relationships_pvt.account_count_rec;
739: p_rel_query_rec csi_datastructures_pub.relationship_query_rec;
740: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;

Line 737: l_site_use_tbl csi_party_relationships_pvt.site_use_tbl;

733: l_line_count NUMBER;
734: l_flag VARCHAR2(1) :='N';
735: l_inst_party_tbl csi_party_relationships_pvt.inst_party_tbl;
736: l_acct_rel_type_tbl csi_party_relationships_pvt.acct_rel_type_tbl;
737: l_site_use_tbl csi_party_relationships_pvt.site_use_tbl;
738: l_account_count_rec csi_party_relationships_pvt.account_count_rec;
739: p_rel_query_rec csi_datastructures_pub.relationship_query_rec;
740: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
741: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;

Line 738: l_account_count_rec csi_party_relationships_pvt.account_count_rec;

734: l_flag VARCHAR2(1) :='N';
735: l_inst_party_tbl csi_party_relationships_pvt.inst_party_tbl;
736: l_acct_rel_type_tbl csi_party_relationships_pvt.acct_rel_type_tbl;
737: l_site_use_tbl csi_party_relationships_pvt.site_use_tbl;
738: l_account_count_rec csi_party_relationships_pvt.account_count_rec;
739: p_rel_query_rec csi_datastructures_pub.relationship_query_rec;
740: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
741: l_ii_relationship_level_tbl csi_ii_relationships_pvt.ii_relationship_level_tbl;
742:

Line 1100: csi_party_relationships_pvt.update_inst_party_relationship

1096: END LOOP;
1097: END IF;
1098: -- end of addition by sk on 12/07 for accounts fix
1099:
1100: csi_party_relationships_pvt.update_inst_party_relationship
1101: ( p_api_version => p_api_version
1102: ,p_commit => p_commit
1103: ,p_init_msg_list => p_init_msg_list
1104: ,p_validation_level => p_validation_level

Line 1143: csi_party_relationships_pvt.create_inst_party_account

1139: IF ( (p_party_account_tbl(l_acct_row).ip_account_id IS NULL)
1140: OR
1141: (p_party_account_tbl(l_acct_row).ip_account_id = FND_API.G_MISS_NUM) ) THEN
1142: -- Call Private package to validate and create party accounts
1143: csi_party_relationships_pvt.create_inst_party_account
1144: ( p_api_version => p_api_version
1145: ,p_commit => p_commit
1146: ,p_init_msg_list => p_init_msg_list
1147: ,p_validation_level => p_validation_level

Line 1211: csi_party_relationships_pvt.update_inst_party_account

1207: NULL;
1208: END;
1209: END IF;
1210: --
1211: csi_party_relationships_pvt.update_inst_party_account
1212: ( p_api_version => p_api_version
1213: ,p_commit => p_commit
1214: ,p_init_msg_list => p_init_msg_list
1215: ,p_validation_level => p_validation_level

Line 1281: csi_party_relationships_pvt.update_inst_party_relationship

1277: ELSE
1278: l_exp_party_rec.active_end_date := p_txn_rec.src_txn_creation_date;
1279: END IF;
1280: -- End of 3804960
1281: csi_party_relationships_pvt.update_inst_party_relationship
1282: ( p_api_version => p_api_version
1283: ,p_commit => p_commit
1284: ,p_init_msg_list => p_init_msg_list
1285: ,p_validation_level => p_validation_level

Line 1319: csi_party_relationships_pvt.update_inst_party_account

1315: IF l_exp_acct_rec.ip_account_id IS NOT NULL
1316: AND l_exp_acct_rec.ip_account_id <> fnd_api.g_miss_num
1317: THEN
1318: l_exp_acct_rec.grp_call_contracts := l_grp_call_contracts;
1319: csi_party_relationships_pvt.update_inst_party_account
1320: ( p_api_version => p_api_version
1321: ,p_commit => p_commit
1322: ,p_init_msg_list => p_init_msg_list
1323: ,p_validation_level => p_validation_level

Line 1374: csi_party_relationships_pvt.update_inst_party_account

1370: IF l_exp_acct_rec.ip_account_id IS NOT NULL
1371: AND l_exp_acct_rec.ip_account_id <> fnd_api.g_miss_num
1372: THEN
1373: l_exp_acct_rec.grp_call_contracts := l_grp_call_contracts;
1374: csi_party_relationships_pvt.update_inst_party_account
1375: ( p_api_version => p_api_version
1376: ,p_commit => p_commit
1377: ,p_init_msg_list => p_init_msg_list
1378: ,p_validation_level => p_validation_level

Line 1648: csi_party_relationships_pvt.update_inst_party_relationship

1644: )
1645: THEN
1646: -- End of code addition for fixing bug 6368172, section 5 of 5
1647:
1648: csi_party_relationships_pvt.update_inst_party_relationship
1649: ( p_api_version => p_api_version
1650: ,p_commit => p_commit
1651: ,p_init_msg_list => p_init_msg_list
1652: ,p_validation_level => p_validation_level

Line 1700: csi_party_relationships_pvt.update_inst_party_relationship

1696: ELSE
1697: l_exp_party_rec.active_end_date := p_txn_rec.src_txn_creation_date;
1698: END IF;
1699: -- End of 3804960
1700: csi_party_relationships_pvt.update_inst_party_relationship
1701: ( p_api_version => p_api_version
1702: ,p_commit => p_commit
1703: ,p_init_msg_list => p_init_msg_list
1704: ,p_validation_level => p_validation_level

Line 1758: csi_party_relationships_pvt.update_inst_party_account

1754: IF l_exp_acct_rec.ip_account_id IS NOT NULL
1755: AND l_exp_acct_rec.ip_account_id <> fnd_api.g_miss_num
1756: THEN
1757: l_exp_acct_rec.grp_call_contracts := l_grp_call_contracts;
1758: csi_party_relationships_pvt.update_inst_party_account
1759: ( p_api_version => p_api_version
1760: ,p_commit => p_commit
1761: ,p_init_msg_list => p_init_msg_list
1762: ,p_validation_level => p_validation_level

Line 1828: csi_party_relationships_pvt.create_inst_party_account

1824: when no_data_found then
1825: l_ip_acct_rec.system_id := fnd_api.g_miss_num;
1826: End;
1827: END IF;
1828: csi_party_relationships_pvt.create_inst_party_account
1829: ( p_api_version => p_api_version
1830: ,p_commit => p_commit
1831: ,p_init_msg_list => p_init_msg_list
1832: ,p_validation_level => p_validation_level

Line 2004: csi_party_relationships_pvt.expire_inst_party_relationship

2000: --
2001: IF p_instance_party_tbl.count > 0 THEN
2002: FOR l_count IN p_instance_party_tbl.FIRST..p_instance_party_tbl.LAST LOOP
2003: IF p_instance_party_tbl.EXISTS(l_count) THEN
2004: csi_party_relationships_pvt.expire_inst_party_relationship
2005: ( p_api_version => p_api_version,
2006: p_commit => p_commit,
2007: p_init_msg_list => p_init_msg_list,
2008: p_validation_level => p_validation_level,

Line 2189: csi_party_relationships_pvt.Gen_Acct_Where_Clause

2185: RAISE FND_API.G_EXC_ERROR;
2186: END IF;
2187:
2188: -- Generate the where clause
2189: csi_party_relationships_pvt.Gen_Acct_Where_Clause
2190: ( p_pty_acct_query_rec => p_account_query_rec,
2191: x_where_clause => l_where_clause );
2192:
2193: -- Build the select statement

Line 2203: csi_party_relationships_pvt.Bind_acct_variable(p_account_query_rec, l_get_acct_cursor_id);

2199: --Parse the select statement
2200: dbms_sql.parse(l_get_acct_cursor_id, l_select_stmt , dbms_sql.native);
2201:
2202: -- Bind the variables
2203: csi_party_relationships_pvt.Bind_acct_variable(p_account_query_rec, l_get_acct_cursor_id);
2204:
2205: -- Define output variables
2206: csi_party_relationships_pvt.Define_Acct_Columns(l_get_acct_cursor_id);
2207:

Line 2206: csi_party_relationships_pvt.Define_Acct_Columns(l_get_acct_cursor_id);

2202: -- Bind the variables
2203: csi_party_relationships_pvt.Bind_acct_variable(p_account_query_rec, l_get_acct_cursor_id);
2204:
2205: -- Define output variables
2206: csi_party_relationships_pvt.Define_Acct_Columns(l_get_acct_cursor_id);
2207:
2208: -- execute the select statement
2209: l_rows_processed := dbms_sql.execute(l_get_acct_cursor_id);
2210:

Line 2213: csi_party_relationships_pvt.Get_acct_Column_Values(l_get_acct_cursor_id, l_party_account_rec);

2209: l_rows_processed := dbms_sql.execute(l_get_acct_cursor_id);
2210:
2211: LOOP
2212: EXIT WHEN DBMS_SQL.FETCH_ROWS(l_get_acct_cursor_id) = 0;
2213: csi_party_relationships_pvt.Get_acct_Column_Values(l_get_acct_cursor_id, l_party_account_rec);
2214: l_count := l_count + 1;
2215: x_account_header_tbl(l_count) := l_party_account_rec;
2216: END LOOP;
2217:

Line 2224: csi_party_relationships_pvt.Construct_acct_from_hist(x_account_header_tbl, p_time_stamp);

2220:
2221: IF ((p_time_stamp IS NOT NULL) AND (p_time_stamp <> FND_API.G_MISS_DATE)) THEN
2222: IF p_time_stamp <= sysdate THEN
2223: -- Contruct from the history if p_time_stamp is less than sysdate
2224: csi_party_relationships_pvt.Construct_acct_from_hist(x_account_header_tbl, p_time_stamp);
2225: ELSE
2226: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_HIST_PARAMS');
2227: FND_MSG_PUB.ADD;
2228: RAISE FND_API.G_EXC_ERROR;

Line 2236: csi_party_relationships_pvt.Resolve_id_columns(l_account_header_tbl);

2232: -- foreign key resolution for the id columns
2233: IF p_resolve_id_columns = fnd_api.g_true THEN
2234: IF x_account_header_tbl.count > 0 THEN
2235: l_account_header_tbl := x_account_header_tbl;
2236: csi_party_relationships_pvt.Resolve_id_columns(l_account_header_tbl);
2237:
2238: x_account_header_tbl := l_account_header_tbl;
2239: END IF;
2240: END IF;

Line 2320: l_inst_party_tbl csi_party_relationships_pvt.inst_party_tbl;

2316: l_msg_index NUMBER;
2317: l_msg_count NUMBER;
2318: l_line_count NUMBER;
2319: l_flag VARCHAR2(1) :='N';
2320: l_inst_party_tbl csi_party_relationships_pvt.inst_party_tbl;
2321: l_acct_rel_type_tbl csi_party_relationships_pvt.acct_rel_type_tbl;
2322: l_site_use_tbl csi_party_relationships_pvt.site_use_tbl;
2323: l_account_count_rec csi_party_relationships_pvt.account_count_rec;
2324: --

Line 2321: l_acct_rel_type_tbl csi_party_relationships_pvt.acct_rel_type_tbl;

2317: l_msg_count NUMBER;
2318: l_line_count NUMBER;
2319: l_flag VARCHAR2(1) :='N';
2320: l_inst_party_tbl csi_party_relationships_pvt.inst_party_tbl;
2321: l_acct_rel_type_tbl csi_party_relationships_pvt.acct_rel_type_tbl;
2322: l_site_use_tbl csi_party_relationships_pvt.site_use_tbl;
2323: l_account_count_rec csi_party_relationships_pvt.account_count_rec;
2324: --
2325: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;

Line 2322: l_site_use_tbl csi_party_relationships_pvt.site_use_tbl;

2318: l_line_count NUMBER;
2319: l_flag VARCHAR2(1) :='N';
2320: l_inst_party_tbl csi_party_relationships_pvt.inst_party_tbl;
2321: l_acct_rel_type_tbl csi_party_relationships_pvt.acct_rel_type_tbl;
2322: l_site_use_tbl csi_party_relationships_pvt.site_use_tbl;
2323: l_account_count_rec csi_party_relationships_pvt.account_count_rec;
2324: --
2325: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;
2326:

Line 2323: l_account_count_rec csi_party_relationships_pvt.account_count_rec;

2319: l_flag VARCHAR2(1) :='N';
2320: l_inst_party_tbl csi_party_relationships_pvt.inst_party_tbl;
2321: l_acct_rel_type_tbl csi_party_relationships_pvt.acct_rel_type_tbl;
2322: l_site_use_tbl csi_party_relationships_pvt.site_use_tbl;
2323: l_account_count_rec csi_party_relationships_pvt.account_count_rec;
2324: --
2325: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;
2326:
2327: BEGIN

Line 2386: csi_party_relationships_pvt.create_inst_party_account

2382: FOR l_count IN p_party_account_tbl.FIRST..p_party_account_tbl.LAST LOOP
2383: IF p_party_account_tbl.EXISTS(l_count) THEN
2384:
2385: -- Call Private package to validate and create party accounts
2386: csi_party_relationships_pvt.create_inst_party_account
2387: ( p_api_version => p_api_version
2388: ,p_commit => p_commit
2389: ,p_init_msg_list => p_init_msg_list
2390: ,p_validation_level => p_validation_level

Line 2593: csi_party_relationships_pvt.update_inst_party_account

2589: NULL;
2590: END;
2591: END IF;
2592: -- dbms_output.put_line('PUB: caling update_inst_party_account');
2593: csi_party_relationships_pvt.update_inst_party_account
2594: ( p_api_version => p_api_version
2595: ,p_commit => p_commit
2596: ,p_init_msg_list => p_init_msg_list
2597: ,p_validation_level => p_validation_level

Line 2723: csi_party_relationships_pvt.update_inst_party_account

2719: IF l_party_account_tbl(l_old_party_row).ip_account_id IS NOT NULL AND
2720: l_party_account_tbl(l_old_party_row).ip_account_id <> fnd_api.g_miss_num AND
2721: old_party_id = l_party_id
2722: THEN
2723: csi_party_relationships_pvt.update_inst_party_account
2724: ( p_api_version => p_api_version
2725: ,p_commit => p_commit
2726: ,p_init_msg_list => p_init_msg_list
2727: ,p_validation_level => p_validation_level

Line 2892: csi_party_relationships_pvt.expire_inst_party_account

2888: --
2889: IF p_party_account_tbl.count > 0 THEN
2890: FOR l_count IN p_party_account_tbl.FIRST..p_party_account_tbl.LAST LOOP
2891: IF p_party_account_tbl.EXISTS(l_count) THEN
2892: csi_party_relationships_pvt.expire_inst_party_account
2893: ( p_api_version => p_api_version
2894: ,p_commit => p_commit
2895: ,p_init_msg_list => p_init_msg_list
2896: ,p_validation_level => p_validation_level