APPS.CSI_T_TXN_LINE_DTLS_PVT dependencies on CSI_T_TRANSACTION_LINES

Line 264: from CSI_T_TRANSACTION_LINES

260: -- Start of Addition for ER 6936037
261: BEGIN
262: SELECT source_transaction_type_id
263: into l_src_transaction_type_id
264: from CSI_T_TRANSACTION_LINES
265: WHERE transaction_line_id = p_txn_line_dtl_rec.transaction_line_id;
266: EXCEPTION
267: WHEN OTHERS THEN
268: debug('No Transaction Type Id found for transaction_line_id - ' || p_txn_line_dtl_rec.transaction_line_id);

Line 1314: from CSI_T_TRANSACTION_LINES

1310: -- Start of Addition for ER 6936037
1311: BEGIN
1312: SELECT source_transaction_type_id
1313: into l_src_transaction_type_id
1314: from CSI_T_TRANSACTION_LINES
1315: WHERE transaction_line_id = l_td_rec.transaction_line_id;
1316: EXCEPTION
1317: WHEN OTHERS THEN
1318: debug('No Transaction Type Id found for transaction_line_id - ' || l_td_rec.transaction_line_id);

Line 3230: ' transaction_line_id in (select transaction_line_id from csi_t_transaction_lines ';

3226:
3227: x_lines_restrict := 'N';
3228:
3229: l_select_stmt :=
3230: ' transaction_line_id in (select transaction_line_id from csi_t_transaction_lines ';
3231:
3232: l_where_clause := null;
3233:
3234: IF nvl(p_txn_line_query_rec.transaction_line_id,fnd_api.g_miss_num) <>

Line 3483: FROM csi_t_transaction_lines

3479:
3480:
3481: CURSOR txn_line_cur (p_txn_line_id in number)is
3482: SELECT *
3483: FROM csi_t_transaction_lines
3484: WHERE transaction_line_id = p_txn_line_id;
3485:
3486: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
3487: l_transaction_line_rec csi_t_datastructures_grp.txn_line_rec;

Line 3529: FROM csi_t_transaction_lines

3525: BEGIN
3526:
3527: SELECT transaction_line_id
3528: INTO l_txn_line_rec.transaction_line_id
3529: FROM csi_t_transaction_lines
3530: WHERE source_transaction_table = p_txn_line_rec.source_transaction_table
3531: AND source_transaction_id = p_txn_line_rec.source_transaction_id;
3532:
3533: EXCEPTION

Line 3622: p_pkg_name => 'csi_t_transaction_lines_pkg');

3618: l_txn_line_rec.object_version_number := p_txn_line_rec.object_version_number;
3619:
3620: csi_t_gen_utility_pvt.dump_api_info(
3621: p_api_name => 'update_row',
3622: p_pkg_name => 'csi_t_transaction_lines_pkg');
3623:
3624: csi_t_transaction_lines_pkg.update_row(
3625: p_transaction_line_id => l_txn_line_rec.transaction_line_id,
3626: p_source_transaction_type_id => l_txn_line_rec.source_transaction_type_id,

Line 3624: csi_t_transaction_lines_pkg.update_row(

3620: csi_t_gen_utility_pvt.dump_api_info(
3621: p_api_name => 'update_row',
3622: p_pkg_name => 'csi_t_transaction_lines_pkg');
3623:
3624: csi_t_transaction_lines_pkg.update_row(
3625: p_transaction_line_id => l_txn_line_rec.transaction_line_id,
3626: p_source_transaction_type_id => l_txn_line_rec.source_transaction_type_id,
3627: p_source_transaction_table => l_txn_line_rec.source_transaction_table,
3628: p_source_txn_header_id => l_txn_line_rec.source_txn_header_id,