DBA Data[Home] [Help]

APPS.CSI_INV_TXNSTUB_PKG dependencies on CSI_DATASTRUCTURES_PUB

Line 18: x_trx_error_rec IN OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)

14:
15: PROCEDURE execute_trx_dpl(p_transaction_type IN VARCHAR2,
16: p_transaction_id IN NUMBER,
17: x_trx_return_status OUT NOCOPY VARCHAR2,
18: x_trx_error_rec IN OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC)
19:
20: IS
21: l_api_name VARCHAR2(100) := 'CSI_INV_TXNSTUB_PUB.EXECUTE_TRX_DPL';
22: l_api_version NUMBER := 1.0;

Line 32: l_trx_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;

28: l_return_status VARCHAR2(1);
29: l_fnd_success VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
30: l_fnd_error VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
31: l_mtl_trx_rec CSI_INV_TRXS_PKG.MTL_TRX_TYPE;
32: l_trx_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
33: l_msg_count NUMBER;
34: l_msg_data VARCHAR2(4000);
35: l_txn_error_id NUMBER;
36: l_file VARCHAR2(500);

Line 38: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;

34: l_msg_data VARCHAR2(4000);
35: l_txn_error_id NUMBER;
36: l_file VARCHAR2(500);
37: l_xml_string VARCHAR2(2000);
38: l_txn_error_rec CSI_DATASTRUCTURES_PUB.TRANSACTION_ERROR_REC;
39: l_fnd_unexpected VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
40: e_dpl_error EXCEPTION;
41: csi_txn_exists EXCEPTION;
42: l_txn_type_id NUMBER := NULL;

Line 81: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN

77: p_file_segment2 => p_transaction_id);
78: END IF;
79:
80: -- Added for Cursor Optimization on CSI_INSTALL_PARAMETERS
81: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
82: csi_gen_utility_pvt.populate_install_param_rec;
83: END IF;
84:
85: savepoint one;

Line 93: debug(' Ownership Override: '||csi_datastructures_pub.g_install_param_rec.ownership_override_at_txn);

89: debug('In execute_trx_dpl for MTL Transaction ID:'||p_transaction_id);
90: debug('-------');
91:
92: debug('Install Parameter Datastructure Populated');
93: debug(' Ownership Override: '||csi_datastructures_pub.g_install_param_rec.ownership_override_at_txn);
94: debug(' SFM Flag: '||csi_datastructures_pub.g_install_param_rec.sfm_queue_bypass_flag);
95:
96: -- Check to see if any CSI Transactions Exist. If it does then just exit if there is not
97: -- then process as normal

Line 94: debug(' SFM Flag: '||csi_datastructures_pub.g_install_param_rec.sfm_queue_bypass_flag);

90: debug('-------');
91:
92: debug('Install Parameter Datastructure Populated');
93: debug(' Ownership Override: '||csi_datastructures_pub.g_install_param_rec.ownership_override_at_txn);
94: debug(' SFM Flag: '||csi_datastructures_pub.g_install_param_rec.sfm_queue_bypass_flag);
95:
96: -- Check to see if any CSI Transactions Exist. If it does then just exit if there is not
97: -- then process as normal
98: