DBA Data[Home] [Help]

APPS.CSI_T_TXN_DETAILS_PVT dependencies on CSI_T_TXN_SYSTEMS

Line 432: csi_t_txn_systems_grp.create_txn_system(

428:
429: l_txn_system_rec := px_txn_systems_tbl(l_ind);
430: l_txn_system_rec.transaction_line_id := l_txn_line_id;
431:
432: csi_t_txn_systems_grp.create_txn_system(
433: p_api_version => p_api_version,
434: p_commit => p_commit,
435: p_init_msg_list => p_init_msg_list,
436: p_validation_level => p_validation_level,

Line 447: 'csi_t_txn_systems_grp.create_txn_system API failed.');

443: IF l_return_status <> fnd_api.g_ret_sts_success THEN
444:
445: FND_MESSAGE.set_name('FND','FND_GENERIC_MESSAGE');
446: FND_MESSAGE.set_token('MESSAGE',
447: 'csi_t_txn_systems_grp.create_txn_system API failed.');
448: FND_MSG_PUB.add;
449: RAISE fnd_api.g_exc_error;
450: END IF;
451:

Line 1729: FROM csi_t_txn_systems

1725: WHERE txn_line_detail_id = p_txn_line_dtl_id;
1726:
1727: CURSOR sys_cur IS
1728: SELECT transaction_system_id
1729: FROM csi_t_txn_systems
1730: WHERE transaction_line_id = p_transaction_line_id;
1731:
1732: BEGIN
1733:

Line 1971: csi_t_txn_systems_grp.delete_txn_system(

1967:
1968: FOR sys_rec in sys_cur
1969: LOOP
1970:
1971: csi_t_txn_systems_grp.delete_txn_system(
1972: p_api_version => 1.0,
1973: p_commit => fnd_api.g_false,
1974: p_init_msg_list => fnd_api.g_false,
1975: p_validation_level => fnd_api.g_valid_level_full,

Line 2154: From csi_t_txn_systems

2150: end_date_active,context, attribute1, attribute2, attribute3,
2151: attribute4, attribute5, attribute6, attribute7, attribute8,
2152: attribute9, attribute10, attribute11, attribute12,
2153: attribute13, attribute14, attribute15, object_version_number
2154: From csi_t_txn_systems
2155: Where transaction_system_id = p_txn_system_id;
2156:
2157: BEGIN
2158: IF p_txn_line_dtl_tbl.count > 0 THEN

Line 2257: 'from csi_t_txn_systems '||

2253: ' context, attribute1, attribute2, attribute3, attribute4, attribute5,'||
2254: ' attribute6, attribute7, attribute8, attribute9, attribute10,'||
2255: ' attribute11, attribute12, attribute13, attribute14, attribute15,'||
2256: ' object_version_number '||
2257: 'from csi_t_txn_systems '||
2258: 'where transaction_system_id in '||p_txn_system_id_list;
2259:
2260: --csi_t_gen_utility_pvt.add(l_select_stmt);
2261: