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_T_TXN_PARTIES_PVT dependencies on CSI_T_PARTY_DETAILS

Line 279: p_pkg_name => 'csi_t_party_detailss_pkg');

275: BEGIN
276:
277: csi_t_gen_utility_pvt.dump_api_info(
278: p_api_name => 'insert_row',
279: p_pkg_name => 'csi_t_party_detailss_pkg');
280:
281: csi_t_party_details_pkg.insert_row(
282: px_txn_party_detail_id => l_txn_party_detail_id,
283: p_txn_line_detail_id => p_txn_party_detail_rec.txn_line_detail_id,

Line 281: csi_t_party_details_pkg.insert_row(

277: csi_t_gen_utility_pvt.dump_api_info(
278: p_api_name => 'insert_row',
279: p_pkg_name => 'csi_t_party_detailss_pkg');
280:
281: csi_t_party_details_pkg.insert_row(
282: px_txn_party_detail_id => l_txn_party_detail_id,
283: p_txn_line_detail_id => p_txn_party_detail_rec.txn_line_detail_id,
284: p_party_source_table => p_txn_party_detail_rec.party_source_table,
285: p_party_source_id => p_txn_party_detail_rec.party_source_id,

Line 324: 'csi_t_party_details_pkg.insert_row Failed. '||substr(sqlerrm,1,200));

320: exception
321: when others then
322: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
323: fnd_message.set_token('MESSAGE',
324: 'csi_t_party_details_pkg.insert_row Failed. '||substr(sqlerrm,1,200));
325: fnd_msg_pub.add;
326: raise fnd_api.g_exc_error;
327: end;
328:

Line 438: l_pty_dtl_rec csi_t_party_details%rowtype;

434: l_api_name CONSTANT varchar2(30) := 'create_txn_pty_acct_dtls';
435: l_api_version CONSTANT number := 1.0;
436: l_debug_level number;
437: l_txn_account_detail_id number;
438: l_pty_dtl_rec csi_t_party_details%rowtype;
439:
440: l_preserve_detail_flag varchar2(1);
441: l_return_status varchar2(1);
442:

Line 735: l_pty_rec csi_t_party_details%ROWTYPE;

731: l_api_name CONSTANT VARCHAR2(30) := 'update_txn_party_dtls';
732: l_api_version CONSTANT NUMBER := 1.0;
733: l_debug_level NUMBER;
734:
735: l_pty_rec csi_t_party_details%ROWTYPE;
736: l_pty_acct_rec csi_t_datastructures_grp.txn_pty_acct_detail_rec;
737: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
738: l_msg_count number;
739: l_msg_data varchar2(512);

Line 751: FROM csi_t_party_details

747: l_u_acct_ind binary_integer;
748:
749: CURSOR pty_cur(p_pty_dtl_id IN number) IS
750: SELECT *
751: FROM csi_t_party_details
752: WHERE txn_party_detail_id = p_pty_dtl_id;
753:
754: CURSOR pa_cur(p_pty_dtl_id in number) IS
755: SELECT *

Line 761: FROM csi_t_party_details

757: WHERE txn_party_detail_id = p_pty_dtl_id;
758:
759: CURSOR cont_pty_cur(p_txn_party_detail_id in number) IS
760: SELECT txn_party_detail_id, preserve_detail_flag
761: FROM csi_t_party_details
762: WHERE contact_party_id = p_txn_party_detail_id
763: AND contact_flag = 'Y';
764:
765: BEGIN

Line 1113: p_pkg_name => 'csi_t_party_details_pkg');

1109: ELSE
1110: debug('Deleting the Party Contact, must not be preserved : '||cont_pty_rec.txn_party_detail_id);
1111: csi_t_gen_utility_pvt.dump_api_info(
1112: p_api_name => 'delete_row',
1113: p_pkg_name => 'csi_t_party_details_pkg');
1114:
1115: csi_t_party_details_pkg.delete_row(
1116: p_txn_party_detail_id => cont_pty_rec.txn_party_detail_id);
1117: END IF;

Line 1115: csi_t_party_details_pkg.delete_row(

1111: csi_t_gen_utility_pvt.dump_api_info(
1112: p_api_name => 'delete_row',
1113: p_pkg_name => 'csi_t_party_details_pkg');
1114:
1115: csi_t_party_details_pkg.delete_row(
1116: p_txn_party_detail_id => cont_pty_rec.txn_party_detail_id);
1117: END IF;
1118:
1119: END LOOP;

Line 1126: p_pkg_name => 'csi_t_party_details_pkg');

1122:
1123: begin
1124: csi_t_gen_utility_pvt.dump_api_info(
1125: p_api_name => 'update_row',
1126: p_pkg_name => 'csi_t_party_details_pkg');
1127:
1128: csi_t_party_details_pkg.update_row(
1129: p_txn_party_detail_id => l_pty_rec.txn_party_detail_id,
1130: p_txn_line_detail_id => l_pty_rec.txn_line_detail_id,

Line 1128: csi_t_party_details_pkg.update_row(

1124: csi_t_gen_utility_pvt.dump_api_info(
1125: p_api_name => 'update_row',
1126: p_pkg_name => 'csi_t_party_details_pkg');
1127:
1128: csi_t_party_details_pkg.update_row(
1129: p_txn_party_detail_id => l_pty_rec.txn_party_detail_id,
1130: p_txn_line_detail_id => l_pty_rec.txn_line_detail_id,
1131: p_party_source_table => l_pty_rec.party_source_table,
1132: p_party_source_id => l_pty_rec.party_source_id,

Line 1169: 'csi_t_party_details_pkg.update_row Failed. '||substr(sqlerrm,1,200));

1165: exception
1166: when others then
1167: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1168: fnd_message.set_token('MESSAGE',
1169: 'csi_t_party_details_pkg.update_row Failed. '||substr(sqlerrm,1,200));
1170: fnd_msg_pub.add;
1171: raise fnd_api.g_exc_error;
1172: end;
1173:

Line 1659: p_pkg_name => 'csi_t_party_details_pkg');

1655: begin
1656:
1657: csi_t_gen_utility_pvt.dump_api_info(
1658: p_api_name => 'update_row',
1659: p_pkg_name => 'csi_t_party_details_pkg');
1660:
1661: csi_t_party_accounts_pkg.update_row (
1662: p_txn_account_detail_id => l_pa_rec.txn_account_detail_id,
1663: p_txn_party_detail_id => l_pa_rec.txn_party_detail_id,

Line 1789: FROM csi_t_party_details

1785: WHERE txn_party_detail_id = p_txn_party_detail_id;
1786:
1787: CURSOR pty_cur (p_line_dtl_id IN NUMBER) IS
1788: SELECT txn_party_detail_id
1789: FROM csi_t_party_details
1790: WHERE txn_line_detail_id = p_line_dtl_id;
1791:
1792: CURSOR cont_pty_cur(p_txn_party_detail_id in number) IS
1793: SELECT txn_party_detail_id

Line 1794: FROM csi_t_party_details

1790: WHERE txn_line_detail_id = p_line_dtl_id;
1791:
1792: CURSOR cont_pty_cur(p_txn_party_detail_id in number) IS
1793: SELECT txn_party_detail_id
1794: FROM csi_t_party_details
1795: WHERE contact_party_id = p_txn_party_detail_id
1796: AND contact_flag = 'Y';
1797:
1798: BEGIN

Line 1894: p_pkg_name => 'csi_t_party_details_pkg');

1890:
1891: debug('Deleting Party Contact rec: '||cont_pty_rec.txn_party_detail_id);
1892: csi_t_gen_utility_pvt.dump_api_info(
1893: p_api_name => 'delete_row',
1894: p_pkg_name => 'csi_t_party_details_pkg');
1895:
1896: csi_t_party_details_pkg.delete_row(
1897: p_txn_party_detail_id => cont_pty_rec.txn_party_detail_id);
1898:

Line 1896: csi_t_party_details_pkg.delete_row(

1892: csi_t_gen_utility_pvt.dump_api_info(
1893: p_api_name => 'delete_row',
1894: p_pkg_name => 'csi_t_party_details_pkg');
1895:
1896: csi_t_party_details_pkg.delete_row(
1897: p_txn_party_detail_id => cont_pty_rec.txn_party_detail_id);
1898:
1899: END LOOP;
1900:

Line 1903: p_pkg_name => 'csi_t_party_details_pkg');

1899: END LOOP;
1900:
1901: csi_t_gen_utility_pvt.dump_api_info(
1902: p_api_name => 'delete_row',
1903: p_pkg_name => 'csi_t_party_details_pkg');
1904:
1905: csi_t_party_details_pkg.delete_row(
1906: p_txn_party_detail_id => l_pty_dtl_id);
1907:

Line 1905: csi_t_party_details_pkg.delete_row(

1901: csi_t_gen_utility_pvt.dump_api_info(
1902: p_api_name => 'delete_row',
1903: p_pkg_name => 'csi_t_party_details_pkg');
1904:
1905: csi_t_party_details_pkg.delete_row(
1906: p_txn_party_detail_id => l_pty_dtl_id);
1907:
1908: ELSE
1909:

Line 1968: p_pkg_name => 'csi_t_party_details_pkg');

1964:
1965: debug('Deleting Party Contact rec: '||cont_pty_rec.txn_party_detail_id);
1966: csi_t_gen_utility_pvt.dump_api_info(
1967: p_api_name => 'delete_row',
1968: p_pkg_name => 'csi_t_party_details_pkg');
1969:
1970: csi_t_party_details_pkg.delete_row(
1971: p_txn_party_detail_id => cont_pty_rec.txn_party_detail_id);
1972:

Line 1970: csi_t_party_details_pkg.delete_row(

1966: csi_t_gen_utility_pvt.dump_api_info(
1967: p_api_name => 'delete_row',
1968: p_pkg_name => 'csi_t_party_details_pkg');
1969:
1970: csi_t_party_details_pkg.delete_row(
1971: p_txn_party_detail_id => cont_pty_rec.txn_party_detail_id);
1972:
1973: END LOOP;
1974:

Line 1977: p_pkg_name => 'csi_t_party_details_pkg');

1973: END LOOP;
1974:
1975: csi_t_gen_utility_pvt.dump_api_info(
1976: p_api_name => 'delete_row',
1977: p_pkg_name => 'csi_t_party_details_pkg');
1978:
1979: csi_t_party_details_pkg.delete_row(
1980: p_txn_party_detail_id => l_pty_dtl_id);
1981:

Line 1979: csi_t_party_details_pkg.delete_row(

1975: csi_t_gen_utility_pvt.dump_api_info(
1976: p_api_name => 'delete_row',
1977: p_pkg_name => 'csi_t_party_details_pkg');
1978:
1979: csi_t_party_details_pkg.delete_row(
1980: p_txn_party_detail_id => l_pty_dtl_id);
1981:
1982: END LOOP;
1983: END IF;

Line 2400: 'from csi_t_party_details '||

2396: ' context, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, '||
2397: ' attribute7, attribute8, attribute9, attribute10, attribute11, attribute12, '||
2398: ' attribute13, attribute14, attribute15, object_version_number, '||
2399: ' primary_flag, preferred_flag '||
2400: 'from csi_t_party_details '||
2401: 'where txn_line_detail_id = :line_dtl_id';
2402:
2403: l_pty_cur_id := dbms_sql.open_cursor;
2404: