DBA Data[Home] [Help]

APPS.CSI_T_TXN_PARTIES_PVT dependencies on CSI_T_PARTY_ACCOUNTS

Line 619: p_pkg_name => 'csi_t_party_accounts_pkg');

615:
616: begin
617: csi_t_gen_utility_pvt.dump_api_info(
618: p_api_name => 'insert_row',
619: p_pkg_name => 'csi_t_party_accounts_pkg');
620:
621: csi_t_party_accounts_pkg.insert_row(
622: px_txn_account_detail_id => l_txn_account_detail_id,
623: p_txn_party_detail_id => p_txn_pty_acct_detail_rec.txn_party_detail_id,

Line 621: csi_t_party_accounts_pkg.insert_row(

617: csi_t_gen_utility_pvt.dump_api_info(
618: p_api_name => 'insert_row',
619: p_pkg_name => 'csi_t_party_accounts_pkg');
620:
621: csi_t_party_accounts_pkg.insert_row(
622: px_txn_account_detail_id => l_txn_account_detail_id,
623: p_txn_party_detail_id => p_txn_pty_acct_detail_rec.txn_party_detail_id,
624: p_ip_account_id => p_txn_pty_acct_detail_rec.ip_account_id,
625: p_account_id => p_txn_pty_acct_detail_rec.account_id,

Line 659: 'csi_t_party_accounts_pkg.insert_row Failed. '||substr(sqlerrm,1,200));

655: exception
656: when others then
657: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
658: fnd_message.set_token('MESSAGE',
659: 'csi_t_party_accounts_pkg.insert_row Failed. '||substr(sqlerrm,1,200));
660: fnd_msg_pub.add;
661: raise fnd_api.g_exc_error;
662: end;
663:

Line 756: FROM csi_t_party_accounts

752: WHERE txn_party_detail_id = p_pty_dtl_id;
753:
754: CURSOR pa_cur(p_pty_dtl_id in number) IS
755: SELECT *
756: FROM csi_t_party_accounts
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

Line 1473: l_pa_rec csi_t_party_accounts%rowtype;

1469: l_debug_level NUMBER;
1470:
1471: l_processing_status csi_t_transaction_lines.processing_status%TYPE;
1472: l_return_status varchar2(1);
1473: l_pa_rec csi_t_party_accounts%rowtype;
1474:
1475: CURSOR pa_cur (p_acct_dtl_id in number) IS
1476: SELECT *
1477: FROM csi_t_party_accounts

Line 1477: FROM csi_t_party_accounts

1473: l_pa_rec csi_t_party_accounts%rowtype;
1474:
1475: CURSOR pa_cur (p_acct_dtl_id in number) IS
1476: SELECT *
1477: FROM csi_t_party_accounts
1478: where txn_account_detail_id = p_acct_dtl_id;
1479:
1480: BEGIN
1481:

Line 1661: csi_t_party_accounts_pkg.update_row (

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,
1664: p_ip_account_id => l_pa_rec.ip_account_id,
1665: p_account_id => l_pa_rec.account_id,

Line 1699: 'csi_t_party_accounts_pkg.update_row Failed. '||substr(sqlerrm,1,200));

1695: exception
1696: when others then
1697: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
1698: fnd_message.set_token('MESSAGE',
1699: 'csi_t_party_accounts_pkg.update_row Failed. '||substr(sqlerrm,1,200));
1700: fnd_msg_pub.add;
1701: raise fnd_api.g_exc_error;
1702: end;
1703:

Line 1784: FROM csi_t_party_accounts

1780: l_msg_data VARCHAR2(2000);
1781:
1782: CURSOR pty_acc_cur(p_txn_party_detail_id in number) IS
1783: SELECT txn_account_detail_id
1784: FROM csi_t_party_accounts
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

Line 2057: FROM csi_t_party_accounts

2053: l_pty_dtl_id NUMBER;
2054:
2055: CURSOR pty_acc_cur (p_pty_dtl_id IN NUMBER) IS
2056: SELECT txn_account_detail_id
2057: FROM csi_t_party_accounts
2058: WHERE txn_party_detail_id = p_pty_dtl_id;
2059:
2060: BEGIN
2061:

Line 2122: p_pkg_name => 'csi_t_party_accounts_pkg');

2118: END IF;
2119:
2120: csi_t_gen_utility_pvt.dump_api_info(
2121: p_api_name => 'delete_row',
2122: p_pkg_name => 'csi_t_party_accounts_pkg');
2123:
2124: csi_t_party_accounts_pkg.delete_row(
2125: p_txn_account_detail_id => l_acct_dtl_id);
2126:

Line 2124: csi_t_party_accounts_pkg.delete_row(

2120: csi_t_gen_utility_pvt.dump_api_info(
2121: p_api_name => 'delete_row',
2122: p_pkg_name => 'csi_t_party_accounts_pkg');
2123:
2124: csi_t_party_accounts_pkg.delete_row(
2125: p_txn_account_detail_id => l_acct_dtl_id);
2126:
2127: ELSE
2128:

Line 2150: p_pkg_name => 'csi_t_party_accounts_pkg');

2146: LOOP
2147:
2148: csi_t_gen_utility_pvt.dump_api_info(
2149: p_api_name => 'delete_row',
2150: p_pkg_name => 'csi_t_party_accounts_pkg');
2151:
2152: csi_t_party_accounts_pkg.delete_row(
2153: p_txn_account_detail_id => pty_acc_rec.txn_account_detail_id);
2154:

Line 2152: csi_t_party_accounts_pkg.delete_row(

2148: csi_t_gen_utility_pvt.dump_api_info(
2149: p_api_name => 'delete_row',
2150: p_pkg_name => 'csi_t_party_accounts_pkg');
2151:
2152: csi_t_party_accounts_pkg.delete_row(
2153: p_txn_account_detail_id => pty_acc_rec.txn_account_detail_id);
2154:
2155: END LOOP;
2156:

Line 2235: 'from csi_t_party_accounts '||

2231: ' active_start_date, active_end_date, preserve_detail_flag, context, '||
2232: ' attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, '||
2233: ' attribute7, attribute8, attribute9, attribute10, attribute11, attribute12, '||
2234: ' attribute13, attribute14, attribute15, object_version_number '||
2235: 'from csi_t_party_accounts '||
2236: 'where txn_party_detail_id = :party_dtl_id';
2237:
2238: l_pty_acct_cur_id := dbms_sql.open_cursor;
2239: