eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_BILLINGTYPE_PVT dependencies on CS_TXN_BILLING_TYPES

Line 90: CURSOR cs_txn_billing_types_pk_csr (p_txn_billing_type_id IN NUMBER) IS

86: SELECT *
87: FROM Cs_Coverage_Txn_Groups
88: WHERE cs_coverage_txn_groups.coverage_txn_group_id = p_coverage_txn_group_id;
89: l_cs_coverage_txn_groups_pk cs_coverage_txn_groups_pk_csr%ROWTYPE;
90: CURSOR cs_txn_billing_types_pk_csr (p_txn_billing_type_id IN NUMBER) IS
91: SELECT *
92: FROM Cs_Txn_Billing_Types
93: WHERE cs_txn_billing_types.txn_billing_type_id = p_txn_billing_type_id;
94: l_cs_txn_billing_types_pk cs_txn_billing_types_pk_csr%ROWTYPE;

Line 92: FROM Cs_Txn_Billing_Types

88: WHERE cs_coverage_txn_groups.coverage_txn_group_id = p_coverage_txn_group_id;
89: l_cs_coverage_txn_groups_pk cs_coverage_txn_groups_pk_csr%ROWTYPE;
90: CURSOR cs_txn_billing_types_pk_csr (p_txn_billing_type_id IN NUMBER) IS
91: SELECT *
92: FROM Cs_Txn_Billing_Types
93: WHERE cs_txn_billing_types.txn_billing_type_id = p_txn_billing_type_id;
94: l_cs_txn_billing_types_pk cs_txn_billing_types_pk_csr%ROWTYPE;
95: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
96: l_row_notfound BOOLEAN := TRUE;

Line 93: WHERE cs_txn_billing_types.txn_billing_type_id = p_txn_billing_type_id;

89: l_cs_coverage_txn_groups_pk cs_coverage_txn_groups_pk_csr%ROWTYPE;
90: CURSOR cs_txn_billing_types_pk_csr (p_txn_billing_type_id IN NUMBER) IS
91: SELECT *
92: FROM Cs_Txn_Billing_Types
93: WHERE cs_txn_billing_types.txn_billing_type_id = p_txn_billing_type_id;
94: l_cs_txn_billing_types_pk cs_txn_billing_types_pk_csr%ROWTYPE;
95: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
96: l_row_notfound BOOLEAN := TRUE;
97: BEGIN

Line 94: l_cs_txn_billing_types_pk cs_txn_billing_types_pk_csr%ROWTYPE;

90: CURSOR cs_txn_billing_types_pk_csr (p_txn_billing_type_id IN NUMBER) IS
91: SELECT *
92: FROM Cs_Txn_Billing_Types
93: WHERE cs_txn_billing_types.txn_billing_type_id = p_txn_billing_type_id;
94: l_cs_txn_billing_types_pk cs_txn_billing_types_pk_csr%ROWTYPE;
95: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
96: l_row_notfound BOOLEAN := TRUE;
97: BEGIN
98: IF (p_billingtype_rec.COVERAGE_TXN_GROUP_ID IS NOT NULL)

Line 111: OPEN cs_txn_billing_types_pk_csr(p_billingtype_rec.TXN_BILLING_TYPE_ID);

107: END IF;
108: END IF;
109: IF (p_billingtype_rec.TXN_BILLING_TYPE_ID IS NOT NULL)
110: THEN
111: OPEN cs_txn_billing_types_pk_csr(p_billingtype_rec.TXN_BILLING_TYPE_ID);
112: FETCH cs_txn_billing_types_pk_csr INTO l_cs_txn_billing_types_pk;
113: l_row_notfound := cs_txn_billing_types_pk_csr%NOTFOUND;
114: CLOSE cs_txn_billing_types_pk_csr;
115: IF (l_row_notfound) THEN

Line 112: FETCH cs_txn_billing_types_pk_csr INTO l_cs_txn_billing_types_pk;

108: END IF;
109: IF (p_billingtype_rec.TXN_BILLING_TYPE_ID IS NOT NULL)
110: THEN
111: OPEN cs_txn_billing_types_pk_csr(p_billingtype_rec.TXN_BILLING_TYPE_ID);
112: FETCH cs_txn_billing_types_pk_csr INTO l_cs_txn_billing_types_pk;
113: l_row_notfound := cs_txn_billing_types_pk_csr%NOTFOUND;
114: CLOSE cs_txn_billing_types_pk_csr;
115: IF (l_row_notfound) THEN
116: TAPI_DEV_KIT.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'TXN_BILLING_TYPE_ID');

Line 113: l_row_notfound := cs_txn_billing_types_pk_csr%NOTFOUND;

109: IF (p_billingtype_rec.TXN_BILLING_TYPE_ID IS NOT NULL)
110: THEN
111: OPEN cs_txn_billing_types_pk_csr(p_billingtype_rec.TXN_BILLING_TYPE_ID);
112: FETCH cs_txn_billing_types_pk_csr INTO l_cs_txn_billing_types_pk;
113: l_row_notfound := cs_txn_billing_types_pk_csr%NOTFOUND;
114: CLOSE cs_txn_billing_types_pk_csr;
115: IF (l_row_notfound) THEN
116: TAPI_DEV_KIT.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'TXN_BILLING_TYPE_ID');
117: RAISE item_not_found_error;

Line 114: CLOSE cs_txn_billing_types_pk_csr;

110: THEN
111: OPEN cs_txn_billing_types_pk_csr(p_billingtype_rec.TXN_BILLING_TYPE_ID);
112: FETCH cs_txn_billing_types_pk_csr INTO l_cs_txn_billing_types_pk;
113: l_row_notfound := cs_txn_billing_types_pk_csr%NOTFOUND;
114: CLOSE cs_txn_billing_types_pk_csr;
115: IF (l_row_notfound) THEN
116: TAPI_DEV_KIT.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'TXN_BILLING_TYPE_ID');
117: RAISE item_not_found_error;
118: END IF;