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: l_cascade_ownership_uimu VARCHAR2(1) :='N'; --Added for Bug 10414588

Line 1107: csi_party_relationships_pvt.update_inst_party_relationship

1103: END LOOP;
1104: END IF;
1105: -- end of addition by sk on 12/07 for accounts fix
1106:
1107: csi_party_relationships_pvt.update_inst_party_relationship
1108: ( p_api_version => p_api_version
1109: ,p_commit => p_commit
1110: ,p_init_msg_list => p_init_msg_list
1111: ,p_validation_level => p_validation_level

Line 1150: csi_party_relationships_pvt.create_inst_party_account

1146: IF ( (p_party_account_tbl(l_acct_row).ip_account_id IS NULL)
1147: OR
1148: (p_party_account_tbl(l_acct_row).ip_account_id = FND_API.G_MISS_NUM) ) THEN
1149: -- Call Private package to validate and create party accounts
1150: csi_party_relationships_pvt.create_inst_party_account
1151: ( p_api_version => p_api_version
1152: ,p_commit => p_commit
1153: ,p_init_msg_list => p_init_msg_list
1154: ,p_validation_level => p_validation_level

Line 1218: csi_party_relationships_pvt.update_inst_party_account

1214: NULL;
1215: END;
1216: END IF;
1217: --
1218: csi_party_relationships_pvt.update_inst_party_account
1219: ( p_api_version => p_api_version
1220: ,p_commit => p_commit
1221: ,p_init_msg_list => p_init_msg_list
1222: ,p_validation_level => p_validation_level

Line 1300: csi_party_relationships_pvt.update_inst_party_account

1296: IF l_exp_acct_rec.ip_account_id IS NOT NULL
1297: AND l_exp_acct_rec.ip_account_id <> fnd_api.g_miss_num
1298: THEN
1299: l_exp_acct_rec.grp_call_contracts := l_grp_call_contracts;
1300: csi_party_relationships_pvt.update_inst_party_account
1301: ( p_api_version => p_api_version
1302: ,p_commit => p_commit
1303: ,p_init_msg_list => p_init_msg_list
1304: ,p_validation_level => p_validation_level

Line 1352: csi_party_relationships_pvt.update_inst_party_relationship

1348: csi_gen_utility_pvt.put_line(' party old active_end_date : '||l_exp_pty.active_end_date);
1349: csi_gen_utility_pvt.put_line(' party new active_end_date : '||l_exp_party_rec.active_end_date);
1350: csi_gen_utility_pvt.put_line(' sysdate : '||SYSDATE);
1351: END IF;
1352: csi_party_relationships_pvt.update_inst_party_relationship
1353: ( p_api_version => p_api_version
1354: ,p_commit => p_commit
1355: ,p_init_msg_list => p_init_msg_list
1356: ,p_validation_level => p_validation_level

Line 1405: csi_party_relationships_pvt.update_inst_party_account

1401: IF l_exp_acct_rec.ip_account_id IS NOT NULL
1402: AND l_exp_acct_rec.ip_account_id <> fnd_api.g_miss_num
1403: THEN
1404: l_exp_acct_rec.grp_call_contracts := l_grp_call_contracts;
1405: csi_party_relationships_pvt.update_inst_party_account
1406: ( p_api_version => p_api_version
1407: ,p_commit => p_commit
1408: ,p_init_msg_list => p_init_msg_list
1409: ,p_validation_level => p_validation_level

Line 1697: csi_party_relationships_pvt.update_inst_party_relationship

1693: )
1694: THEN
1695: -- End of code addition for fixing bug 6368172, section 5 of 5
1696:
1697: csi_party_relationships_pvt.update_inst_party_relationship
1698: ( p_api_version => p_api_version
1699: ,p_commit => p_commit
1700: ,p_init_msg_list => p_init_msg_list
1701: ,p_validation_level => p_validation_level

Line 1749: csi_party_relationships_pvt.update_inst_party_relationship

1745: ELSE
1746: l_exp_party_rec.active_end_date := p_txn_rec.src_txn_creation_date;
1747: END IF;
1748: -- End of 3804960
1749: csi_party_relationships_pvt.update_inst_party_relationship
1750: ( p_api_version => p_api_version
1751: ,p_commit => p_commit
1752: ,p_init_msg_list => p_init_msg_list
1753: ,p_validation_level => p_validation_level

Line 1807: csi_party_relationships_pvt.update_inst_party_account

1803: IF l_exp_acct_rec.ip_account_id IS NOT NULL
1804: AND l_exp_acct_rec.ip_account_id <> fnd_api.g_miss_num
1805: THEN
1806: l_exp_acct_rec.grp_call_contracts := l_grp_call_contracts;
1807: csi_party_relationships_pvt.update_inst_party_account
1808: ( p_api_version => p_api_version
1809: ,p_commit => p_commit
1810: ,p_init_msg_list => p_init_msg_list
1811: ,p_validation_level => p_validation_level

Line 1877: csi_party_relationships_pvt.create_inst_party_account

1873: when no_data_found then
1874: l_ip_acct_rec.system_id := fnd_api.g_miss_num;
1875: End;
1876: END IF;
1877: csi_party_relationships_pvt.create_inst_party_account
1878: ( p_api_version => p_api_version
1879: ,p_commit => p_commit
1880: ,p_init_msg_list => p_init_msg_list
1881: ,p_validation_level => p_validation_level

Line 2053: csi_party_relationships_pvt.expire_inst_party_relationship

2049: --
2050: IF p_instance_party_tbl.count > 0 THEN
2051: FOR l_count IN p_instance_party_tbl.FIRST..p_instance_party_tbl.LAST LOOP
2052: IF p_instance_party_tbl.EXISTS(l_count) THEN
2053: csi_party_relationships_pvt.expire_inst_party_relationship
2054: ( p_api_version => p_api_version,
2055: p_commit => p_commit,
2056: p_init_msg_list => p_init_msg_list,
2057: p_validation_level => p_validation_level,

Line 2238: csi_party_relationships_pvt.Gen_Acct_Where_Clause

2234: RAISE FND_API.G_EXC_ERROR;
2235: END IF;
2236:
2237: -- Generate the where clause
2238: csi_party_relationships_pvt.Gen_Acct_Where_Clause
2239: ( p_pty_acct_query_rec => p_account_query_rec,
2240: x_where_clause => l_where_clause );
2241:
2242: -- Build the select statement

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

2248: --Parse the select statement
2249: dbms_sql.parse(l_get_acct_cursor_id, l_select_stmt , dbms_sql.native);
2250:
2251: -- Bind the variables
2252: csi_party_relationships_pvt.Bind_acct_variable(p_account_query_rec, l_get_acct_cursor_id);
2253:
2254: -- Define output variables
2255: csi_party_relationships_pvt.Define_Acct_Columns(l_get_acct_cursor_id);
2256:

Line 2255: csi_party_relationships_pvt.Define_Acct_Columns(l_get_acct_cursor_id);

2251: -- Bind the variables
2252: csi_party_relationships_pvt.Bind_acct_variable(p_account_query_rec, l_get_acct_cursor_id);
2253:
2254: -- Define output variables
2255: csi_party_relationships_pvt.Define_Acct_Columns(l_get_acct_cursor_id);
2256:
2257: -- execute the select statement
2258: l_rows_processed := dbms_sql.execute(l_get_acct_cursor_id);
2259:

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

2258: l_rows_processed := dbms_sql.execute(l_get_acct_cursor_id);
2259:
2260: LOOP
2261: EXIT WHEN DBMS_SQL.FETCH_ROWS(l_get_acct_cursor_id) = 0;
2262: csi_party_relationships_pvt.Get_acct_Column_Values(l_get_acct_cursor_id, l_party_account_rec);
2263: l_count := l_count + 1;
2264: x_account_header_tbl(l_count) := l_party_account_rec;
2265: END LOOP;
2266:

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

2269:
2270: IF ((p_time_stamp IS NOT NULL) AND (p_time_stamp <> FND_API.G_MISS_DATE)) THEN
2271: IF p_time_stamp <= sysdate THEN
2272: -- Contruct from the history if p_time_stamp is less than sysdate
2273: csi_party_relationships_pvt.Construct_acct_from_hist(x_account_header_tbl, p_time_stamp);
2274: ELSE
2275: FND_MESSAGE.Set_Name('CSI', 'CSI_API_INVALID_HIST_PARAMS');
2276: FND_MSG_PUB.ADD;
2277: RAISE FND_API.G_EXC_ERROR;

Line 2285: csi_party_relationships_pvt.Resolve_id_columns(l_account_header_tbl);

2281: -- foreign key resolution for the id columns
2282: IF p_resolve_id_columns = fnd_api.g_true THEN
2283: IF x_account_header_tbl.count > 0 THEN
2284: l_account_header_tbl := x_account_header_tbl;
2285: csi_party_relationships_pvt.Resolve_id_columns(l_account_header_tbl);
2286:
2287: x_account_header_tbl := l_account_header_tbl;
2288: END IF;
2289: END IF;

Line 2369: l_inst_party_tbl csi_party_relationships_pvt.inst_party_tbl;

2365: l_msg_index NUMBER;
2366: l_msg_count NUMBER;
2367: l_line_count NUMBER;
2368: l_flag VARCHAR2(1) :='N';
2369: l_inst_party_tbl csi_party_relationships_pvt.inst_party_tbl;
2370: l_acct_rel_type_tbl csi_party_relationships_pvt.acct_rel_type_tbl;
2371: l_site_use_tbl csi_party_relationships_pvt.site_use_tbl;
2372: l_account_count_rec csi_party_relationships_pvt.account_count_rec;
2373: --

Line 2370: l_acct_rel_type_tbl csi_party_relationships_pvt.acct_rel_type_tbl;

2366: l_msg_count NUMBER;
2367: l_line_count NUMBER;
2368: l_flag VARCHAR2(1) :='N';
2369: l_inst_party_tbl csi_party_relationships_pvt.inst_party_tbl;
2370: l_acct_rel_type_tbl csi_party_relationships_pvt.acct_rel_type_tbl;
2371: l_site_use_tbl csi_party_relationships_pvt.site_use_tbl;
2372: l_account_count_rec csi_party_relationships_pvt.account_count_rec;
2373: --
2374: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;

Line 2371: l_site_use_tbl csi_party_relationships_pvt.site_use_tbl;

2367: l_line_count NUMBER;
2368: l_flag VARCHAR2(1) :='N';
2369: l_inst_party_tbl csi_party_relationships_pvt.inst_party_tbl;
2370: l_acct_rel_type_tbl csi_party_relationships_pvt.acct_rel_type_tbl;
2371: l_site_use_tbl csi_party_relationships_pvt.site_use_tbl;
2372: l_account_count_rec csi_party_relationships_pvt.account_count_rec;
2373: --
2374: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;
2375:

Line 2372: l_account_count_rec csi_party_relationships_pvt.account_count_rec;

2368: l_flag VARCHAR2(1) :='N';
2369: l_inst_party_tbl csi_party_relationships_pvt.inst_party_tbl;
2370: l_acct_rel_type_tbl csi_party_relationships_pvt.acct_rel_type_tbl;
2371: l_site_use_tbl csi_party_relationships_pvt.site_use_tbl;
2372: l_account_count_rec csi_party_relationships_pvt.account_count_rec;
2373: --
2374: px_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;
2375:
2376: BEGIN

Line 2435: csi_party_relationships_pvt.create_inst_party_account

2431: FOR l_count IN p_party_account_tbl.FIRST..p_party_account_tbl.LAST LOOP
2432: IF p_party_account_tbl.EXISTS(l_count) THEN
2433:
2434: -- Call Private package to validate and create party accounts
2435: csi_party_relationships_pvt.create_inst_party_account
2436: ( p_api_version => p_api_version
2437: ,p_commit => p_commit
2438: ,p_init_msg_list => p_init_msg_list
2439: ,p_validation_level => p_validation_level

Line 2642: csi_party_relationships_pvt.update_inst_party_account

2638: NULL;
2639: END;
2640: END IF;
2641: -- dbms_output.put_line('PUB: caling update_inst_party_account');
2642: csi_party_relationships_pvt.update_inst_party_account
2643: ( p_api_version => p_api_version
2644: ,p_commit => p_commit
2645: ,p_init_msg_list => p_init_msg_list
2646: ,p_validation_level => p_validation_level

Line 2772: csi_party_relationships_pvt.update_inst_party_account

2768: IF l_party_account_tbl(l_old_party_row).ip_account_id IS NOT NULL AND
2769: l_party_account_tbl(l_old_party_row).ip_account_id <> fnd_api.g_miss_num AND
2770: old_party_id = l_party_id
2771: THEN
2772: csi_party_relationships_pvt.update_inst_party_account
2773: ( p_api_version => p_api_version
2774: ,p_commit => p_commit
2775: ,p_init_msg_list => p_init_msg_list
2776: ,p_validation_level => p_validation_level

Line 2941: csi_party_relationships_pvt.expire_inst_party_account

2937: --
2938: IF p_party_account_tbl.count > 0 THEN
2939: FOR l_count IN p_party_account_tbl.FIRST..p_party_account_tbl.LAST LOOP
2940: IF p_party_account_tbl.EXISTS(l_count) THEN
2941: csi_party_relationships_pvt.expire_inst_party_account
2942: ( p_api_version => p_api_version
2943: ,p_commit => p_commit
2944: ,p_init_msg_list => p_init_msg_list
2945: ,p_validation_level => p_validation_level