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 456: -- source_transaction_date in csi_transactions

452: p_number => p_instance_rec.location_id,
453: p_param_name => 'p_instance_rec.location_id',
454: p_api_name => 'csi_fa_instance_grp.create_item_instance');
455:
456: -- source_transaction_date in csi_transactions
457: csi_item_instance_vld_pvt.check_reqd_param_date(
458: p_date => px_csi_txn_rec.source_transaction_date,
459: p_param_name => 'px_csi_txn_rec.source_transaction_date',
460: p_api_name => 'csi_fa_instance_grp.create_item_instance');

Line 462: -- transaction_type_id in csi_transactions

458: p_date => px_csi_txn_rec.source_transaction_date,
459: p_param_name => 'px_csi_txn_rec.source_transaction_date',
460: p_api_name => 'csi_fa_instance_grp.create_item_instance');
461:
462: -- transaction_type_id in csi_transactions
463: csi_item_instance_vld_pvt.check_reqd_param_num(
464: p_number => px_csi_txn_rec.transaction_type_id,
465: p_param_name => 'px_csi_txn_rec.transaction_type_id',
466: p_api_name => 'csi_fa_instance_grp.create_item_instance');

Line 511: csi_transactions_pvt.create_transaction(

507: END IF;
508: END IF;
509: END IF;
510:
511: csi_transactions_pvt.create_transaction(
512: p_api_version => 1.0,
513: p_commit => fnd_api.g_false,
514: p_init_msg_list => fnd_api.g_true,
515: p_validation_level => fnd_api.g_valid_level_full,

Line 970: csi_transactions_pvt.create_transaction(

966: p_number => p_instance_rec.instance_id,
967: p_param_name => 'p_instance_rec.instance_id',
968: p_api_name => 'csi_fa_instance_rec.copy_item_instance');
969:
970: csi_transactions_pvt.create_transaction(
971: p_api_version => 1.0,
972: p_commit => fnd_api.g_false,
973: p_init_msg_list => fnd_api.g_true,
974: p_validation_level => fnd_api.g_valid_level_full,

Line 1297: csi_transactions_pvt.create_transaction(

1293: END IF;
1294:
1295: IF l_instance_asset_tbl.COUNT > 0 THEN
1296:
1297: csi_transactions_pvt.create_transaction(
1298: p_api_version => 1.0,
1299: p_commit => fnd_api.g_false,
1300: p_init_msg_list => fnd_api.g_true,
1301: p_validation_level => fnd_api.g_valid_level_full,

Line 1363: csi_transactions_pvt.create_transaction(

1359:
1360: x_return_status := fnd_api.g_ret_sts_success;
1361: IF p_instance_asset_tbl.count > 0 THEN
1362:
1363: csi_transactions_pvt.create_transaction(
1364: p_api_version => 1.0,
1365: p_commit => fnd_api.g_false,
1366: p_init_msg_list => fnd_api.g_true,
1367: p_validation_level => fnd_api.g_valid_level_full,