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;
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;
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
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)
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
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');
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;
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;