APPS.AHL_UTIL_UC_PKG dependencies on CSI_TXN_TYPES

Line 324: CURSOR csi_txn_types_csr(p_txn_code IN VARCHAR2) IS

320: x_txn_type_id OUT NOCOPY NUMBER,
321: x_return_val OUT NOCOPY BOOLEAN) IS
322:
323: -- For transaction code.
324: CURSOR csi_txn_types_csr(p_txn_code IN VARCHAR2) IS
325: SELECT ctxn.transaction_type_id
326: FROM csi_txn_types ctxn, fnd_application app
327: WHERE ctxn.source_application_id = app.application_id
328: AND app.APPLICATION_SHORT_NAME = 'AHL'

Line 326: FROM csi_txn_types ctxn, fnd_application app

322:
323: -- For transaction code.
324: CURSOR csi_txn_types_csr(p_txn_code IN VARCHAR2) IS
325: SELECT ctxn.transaction_type_id
326: FROM csi_txn_types ctxn, fnd_application app
327: WHERE ctxn.source_application_id = app.application_id
328: AND app.APPLICATION_SHORT_NAME = 'AHL'
329: AND ctxn.source_transaction_type = p_txn_code;
330:

Line 337: OPEN csi_txn_types_csr(p_txn_code);

333:
334: BEGIN
335:
336: -- get transaction_type_id .
337: OPEN csi_txn_types_csr(p_txn_code);
338: FETCH csi_txn_types_csr INTO l_txn_type_id;
339: IF (csi_txn_types_csr%NOTFOUND) THEN
340: FND_MESSAGE.Set_Name('AHL','AHL_UC_TXNCODE_INVALID');
341: FND_MESSAGE.Set_Token('CODE',p_txn_code);

Line 338: FETCH csi_txn_types_csr INTO l_txn_type_id;

334: BEGIN
335:
336: -- get transaction_type_id .
337: OPEN csi_txn_types_csr(p_txn_code);
338: FETCH csi_txn_types_csr INTO l_txn_type_id;
339: IF (csi_txn_types_csr%NOTFOUND) THEN
340: FND_MESSAGE.Set_Name('AHL','AHL_UC_TXNCODE_INVALID');
341: FND_MESSAGE.Set_Token('CODE',p_txn_code);
342: FND_MSG_PUB.ADD;

Line 339: IF (csi_txn_types_csr%NOTFOUND) THEN

335:
336: -- get transaction_type_id .
337: OPEN csi_txn_types_csr(p_txn_code);
338: FETCH csi_txn_types_csr INTO l_txn_type_id;
339: IF (csi_txn_types_csr%NOTFOUND) THEN
340: FND_MESSAGE.Set_Name('AHL','AHL_UC_TXNCODE_INVALID');
341: FND_MESSAGE.Set_Token('CODE',p_txn_code);
342: FND_MSG_PUB.ADD;
343: --dbms_output.put_line('Transaction code not found');

Line 346: CLOSE csi_txn_types_csr;

342: FND_MSG_PUB.ADD;
343: --dbms_output.put_line('Transaction code not found');
344: l_return_val := FALSE;
345: END IF;
346: CLOSE csi_txn_types_csr;
347:
348: -- assign out parameters.
349: x_return_val := l_return_val;
350: x_txn_type_id := l_txn_type_id;