APPS.CS_SERVICE_PVT dependencies on CS_CONTRACTS_ALL

Line 104: CURSOR cs_contracts_all_pk_csr (p_contract_id IN NUMBER) IS

100: SELECT *
101: FROM Cs_Customer_Products
102: WHERE cs_customer_products.customer_product_id = p_customer_product_id;
103: l_ccpall_pk ccpall_pk_csr%ROWTYPE;
104: CURSOR cs_contracts_all_pk_csr (p_contract_id IN NUMBER) IS
105: SELECT *
106: FROM Cs_Contracts_All
107: WHERE cs_contracts_all.contract_id = p_contract_id;
108: l_cs_contracts_all_pk cs_contracts_all_pk_csr%ROWTYPE;

Line 106: FROM Cs_Contracts_All

102: WHERE cs_customer_products.customer_product_id = p_customer_product_id;
103: l_ccpall_pk ccpall_pk_csr%ROWTYPE;
104: CURSOR cs_contracts_all_pk_csr (p_contract_id IN NUMBER) IS
105: SELECT *
106: FROM Cs_Contracts_All
107: WHERE cs_contracts_all.contract_id = p_contract_id;
108: l_cs_contracts_all_pk cs_contracts_all_pk_csr%ROWTYPE;
109: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
110: l_row_notfound BOOLEAN := TRUE;

Line 107: WHERE cs_contracts_all.contract_id = p_contract_id;

103: l_ccpall_pk ccpall_pk_csr%ROWTYPE;
104: CURSOR cs_contracts_all_pk_csr (p_contract_id IN NUMBER) IS
105: SELECT *
106: FROM Cs_Contracts_All
107: WHERE cs_contracts_all.contract_id = p_contract_id;
108: l_cs_contracts_all_pk cs_contracts_all_pk_csr%ROWTYPE;
109: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
110: l_row_notfound BOOLEAN := TRUE;
111: BEGIN

Line 108: l_cs_contracts_all_pk cs_contracts_all_pk_csr%ROWTYPE;

104: CURSOR cs_contracts_all_pk_csr (p_contract_id IN NUMBER) IS
105: SELECT *
106: FROM Cs_Contracts_All
107: WHERE cs_contracts_all.contract_id = p_contract_id;
108: l_cs_contracts_all_pk cs_contracts_all_pk_csr%ROWTYPE;
109: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
110: l_row_notfound BOOLEAN := TRUE;
111: BEGIN
112: IF (p_service_rec.CONTRACT_LINE_STATUS_ID IS NOT NULL)

Line 147: OPEN cs_contracts_all_pk_csr(p_service_rec.CONTRACT_ID);

143: END IF;
144: END IF;
145: IF (p_service_rec.CONTRACT_ID IS NOT NULL)
146: THEN
147: OPEN cs_contracts_all_pk_csr(p_service_rec.CONTRACT_ID);
148: FETCH cs_contracts_all_pk_csr INTO l_cs_contracts_all_pk;
149: l_row_notfound := cs_contracts_all_pk_csr%NOTFOUND;
150: CLOSE cs_contracts_all_pk_csr;
151: IF (l_row_notfound) THEN

Line 148: FETCH cs_contracts_all_pk_csr INTO l_cs_contracts_all_pk;

144: END IF;
145: IF (p_service_rec.CONTRACT_ID IS NOT NULL)
146: THEN
147: OPEN cs_contracts_all_pk_csr(p_service_rec.CONTRACT_ID);
148: FETCH cs_contracts_all_pk_csr INTO l_cs_contracts_all_pk;
149: l_row_notfound := cs_contracts_all_pk_csr%NOTFOUND;
150: CLOSE cs_contracts_all_pk_csr;
151: IF (l_row_notfound) THEN
152: TAPI_DEV_KIT.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'CONTRACT_ID');

Line 149: l_row_notfound := cs_contracts_all_pk_csr%NOTFOUND;

145: IF (p_service_rec.CONTRACT_ID IS NOT NULL)
146: THEN
147: OPEN cs_contracts_all_pk_csr(p_service_rec.CONTRACT_ID);
148: FETCH cs_contracts_all_pk_csr INTO l_cs_contracts_all_pk;
149: l_row_notfound := cs_contracts_all_pk_csr%NOTFOUND;
150: CLOSE cs_contracts_all_pk_csr;
151: IF (l_row_notfound) THEN
152: TAPI_DEV_KIT.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'CONTRACT_ID');
153: RAISE item_not_found_error;

Line 150: CLOSE cs_contracts_all_pk_csr;

146: THEN
147: OPEN cs_contracts_all_pk_csr(p_service_rec.CONTRACT_ID);
148: FETCH cs_contracts_all_pk_csr INTO l_cs_contracts_all_pk;
149: l_row_notfound := cs_contracts_all_pk_csr%NOTFOUND;
150: CLOSE cs_contracts_all_pk_csr;
151: IF (l_row_notfound) THEN
152: TAPI_DEV_KIT.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'CONTRACT_ID');
153: RAISE item_not_found_error;
154: END IF;