APPS.AHL_PRD_SERN_CHANGE_PVT dependencies on CSI_TXN_TYPES

Line 19: CURSOR csi_txn_types_csr(p_txn_code IN VARCHAR2) IS

15: x_txn_type_id OUT NOCOPY NUMBER,
16: x_return_val OUT NOCOPY BOOLEAN) IS
17:
18: -- For transaction code.
19: CURSOR csi_txn_types_csr(p_txn_code IN VARCHAR2) IS
20: SELECT ctxn.transaction_type_id
21: FROM csi_txn_types ctxn, fnd_application app
22: WHERE ctxn.source_application_id = app.application_id
23: AND app.APPLICATION_SHORT_NAME = 'AHL'

Line 21: FROM csi_txn_types ctxn, fnd_application app

17:
18: -- For transaction code.
19: CURSOR csi_txn_types_csr(p_txn_code IN VARCHAR2) IS
20: SELECT ctxn.transaction_type_id
21: FROM csi_txn_types ctxn, fnd_application app
22: WHERE ctxn.source_application_id = app.application_id
23: AND app.APPLICATION_SHORT_NAME = 'AHL'
24: AND ctxn.source_transaction_type = p_txn_code;
25:

Line 32: OPEN csi_txn_types_csr(p_txn_code);

28:
29: BEGIN
30:
31: -- get transaction_type_id .
32: OPEN csi_txn_types_csr(p_txn_code);
33: FETCH csi_txn_types_csr INTO l_txn_type_id;
34: IF (csi_txn_types_csr%NOTFOUND) THEN
35: FND_MESSAGE.Set_Name('AHL','AHL__TXNCODE_INVALID');
36: FND_MESSAGE.Set_Token('CODE',p_txn_code);

Line 33: FETCH csi_txn_types_csr INTO l_txn_type_id;

29: BEGIN
30:
31: -- get transaction_type_id .
32: OPEN csi_txn_types_csr(p_txn_code);
33: FETCH csi_txn_types_csr INTO l_txn_type_id;
34: IF (csi_txn_types_csr%NOTFOUND) THEN
35: FND_MESSAGE.Set_Name('AHL','AHL__TXNCODE_INVALID');
36: FND_MESSAGE.Set_Token('CODE',p_txn_code);
37: FND_MSG_PUB.ADD;

Line 34: IF (csi_txn_types_csr%NOTFOUND) THEN

30:
31: -- get transaction_type_id .
32: OPEN csi_txn_types_csr(p_txn_code);
33: FETCH csi_txn_types_csr INTO l_txn_type_id;
34: IF (csi_txn_types_csr%NOTFOUND) THEN
35: FND_MESSAGE.Set_Name('AHL','AHL__TXNCODE_INVALID');
36: FND_MESSAGE.Set_Token('CODE',p_txn_code);
37: FND_MSG_PUB.ADD;
38: --dbms_output.put_line('Transaction code not found');

Line 41: CLOSE csi_txn_types_csr;

37: FND_MSG_PUB.ADD;
38: --dbms_output.put_line('Transaction code not found');
39: l_return_val := FALSE;
40: END IF;
41: CLOSE csi_txn_types_csr;
42:
43: -- assign out parameters.
44: x_return_val := l_return_val;
45: x_txn_type_id := l_txn_type_id;