DBA Data[Home] [Help]

APPS.CSI_FA_INSTANCE_GRP dependencies on CSI_TRANSACTIONS

Line 84: csi_transactions ct

80:
81: CURSOR pending_txn_cur(p_instance_id in number) is
82: SELECT ct.transaction_id
83: FROM csi_item_instances_h ciih,
84: csi_transactions ct
85: WHERE ciih.instance_id = p_instance_id
86: AND ct.transaction_id = ciih.transaction_id
87: AND ct.transaction_type_id IN (117, 129, 128, 105, 112, 118, 119)
88: AND ct.transaction_status_code = l_pending_status

Line 452: -- source_transaction_date in csi_transactions

448: p_number => p_instance_rec.location_id,
449: p_param_name => 'p_instance_rec.location_id',
450: p_api_name => 'csi_fa_instance_grp.create_item_instance');
451:
452: -- source_transaction_date in csi_transactions
453: csi_item_instance_vld_pvt.check_reqd_param_date(
454: p_date => px_csi_txn_rec.source_transaction_date,
455: p_param_name => 'px_csi_txn_rec.source_transaction_date',
456: p_api_name => 'csi_fa_instance_grp.create_item_instance');

Line 458: -- transaction_type_id in csi_transactions

454: p_date => px_csi_txn_rec.source_transaction_date,
455: p_param_name => 'px_csi_txn_rec.source_transaction_date',
456: p_api_name => 'csi_fa_instance_grp.create_item_instance');
457:
458: -- transaction_type_id in csi_transactions
459: csi_item_instance_vld_pvt.check_reqd_param_num(
460: p_number => px_csi_txn_rec.transaction_type_id,
461: p_param_name => 'px_csi_txn_rec.transaction_type_id',
462: p_api_name => 'csi_fa_instance_grp.create_item_instance');

Line 507: csi_transactions_pvt.create_transaction(

503: END IF;
504: END IF;
505: END IF;
506:
507: csi_transactions_pvt.create_transaction(
508: p_api_version => 1.0,
509: p_commit => fnd_api.g_false,
510: p_init_msg_list => fnd_api.g_true,
511: p_validation_level => fnd_api.g_valid_level_full,

Line 946: csi_transactions_pvt.create_transaction(

942: p_number => p_instance_rec.instance_id,
943: p_param_name => 'p_instance_rec.instance_id',
944: p_api_name => 'csi_fa_instance_rec.copy_item_instance');
945:
946: csi_transactions_pvt.create_transaction(
947: p_api_version => 1.0,
948: p_commit => fnd_api.g_false,
949: p_init_msg_list => fnd_api.g_true,
950: p_validation_level => fnd_api.g_valid_level_full,

Line 1272: csi_transactions_pvt.create_transaction(

1268: END IF;
1269:
1270: IF l_instance_asset_tbl.COUNT > 0 THEN
1271:
1272: csi_transactions_pvt.create_transaction(
1273: p_api_version => 1.0,
1274: p_commit => fnd_api.g_false,
1275: p_init_msg_list => fnd_api.g_true,
1276: p_validation_level => fnd_api.g_valid_level_full,

Line 1338: csi_transactions_pvt.create_transaction(

1334:
1335: x_return_status := fnd_api.g_ret_sts_success;
1336: IF p_instance_asset_tbl.count > 0 THEN
1337:
1338: csi_transactions_pvt.create_transaction(
1339: p_api_version => 1.0,
1340: p_commit => fnd_api.g_false,
1341: p_init_msg_list => fnd_api.g_true,
1342: p_validation_level => fnd_api.g_valid_level_full,