APPS.CS_COVERAGELEVEL_PVT dependencies on CS_CP_SERVICES_ALL

Line 90: CURSOR cs_cp_services_all_pk_csr (p_cp_service_id IN NUMBER) IS

86: p_coveragelevel_rec IN CoverageLevel_Rec_Type
87: )
88: RETURN VARCHAR2 IS
89: item_not_found_error EXCEPTION;
90: CURSOR cs_cp_services_all_pk_csr (p_cp_service_id IN NUMBER) IS
91: SELECT *
92: FROM Cs_Cp_Services_All
93: WHERE cs_cp_services_all.cp_service_id = p_cp_service_id;
94: l_cs_cp_services_all_pk cs_cp_services_all_pk_csr%ROWTYPE;

Line 92: FROM Cs_Cp_Services_All

88: RETURN VARCHAR2 IS
89: item_not_found_error EXCEPTION;
90: CURSOR cs_cp_services_all_pk_csr (p_cp_service_id IN NUMBER) IS
91: SELECT *
92: FROM Cs_Cp_Services_All
93: WHERE cs_cp_services_all.cp_service_id = p_cp_service_id;
94: l_cs_cp_services_all_pk cs_cp_services_all_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_cp_services_all.cp_service_id = p_cp_service_id;

89: item_not_found_error EXCEPTION;
90: CURSOR cs_cp_services_all_pk_csr (p_cp_service_id IN NUMBER) IS
91: SELECT *
92: FROM Cs_Cp_Services_All
93: WHERE cs_cp_services_all.cp_service_id = p_cp_service_id;
94: l_cs_cp_services_all_pk cs_cp_services_all_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_cp_services_all_pk cs_cp_services_all_pk_csr%ROWTYPE;

90: CURSOR cs_cp_services_all_pk_csr (p_cp_service_id IN NUMBER) IS
91: SELECT *
92: FROM Cs_Cp_Services_All
93: WHERE cs_cp_services_all.cp_service_id = p_cp_service_id;
94: l_cs_cp_services_all_pk cs_cp_services_all_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_coveragelevel_rec.CP_SERVICE_ID IS NOT NULL)

Line 100: OPEN cs_cp_services_all_pk_csr(p_coveragelevel_rec.CP_SERVICE_ID);

96: l_row_notfound BOOLEAN := TRUE;
97: BEGIN
98: IF (p_coveragelevel_rec.CP_SERVICE_ID IS NOT NULL)
99: THEN
100: OPEN cs_cp_services_all_pk_csr(p_coveragelevel_rec.CP_SERVICE_ID);
101: FETCH cs_cp_services_all_pk_csr INTO l_cs_cp_services_all_pk;
102: l_row_notfound := cs_cp_services_all_pk_csr%NOTFOUND;
103: CLOSE cs_cp_services_all_pk_csr;
104: IF (l_row_notfound) THEN

Line 101: FETCH cs_cp_services_all_pk_csr INTO l_cs_cp_services_all_pk;

97: BEGIN
98: IF (p_coveragelevel_rec.CP_SERVICE_ID IS NOT NULL)
99: THEN
100: OPEN cs_cp_services_all_pk_csr(p_coveragelevel_rec.CP_SERVICE_ID);
101: FETCH cs_cp_services_all_pk_csr INTO l_cs_cp_services_all_pk;
102: l_row_notfound := cs_cp_services_all_pk_csr%NOTFOUND;
103: CLOSE cs_cp_services_all_pk_csr;
104: IF (l_row_notfound) THEN
105: TAPI_DEV_KIT.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'CP_SERVICE_ID');

Line 102: l_row_notfound := cs_cp_services_all_pk_csr%NOTFOUND;

98: IF (p_coveragelevel_rec.CP_SERVICE_ID IS NOT NULL)
99: THEN
100: OPEN cs_cp_services_all_pk_csr(p_coveragelevel_rec.CP_SERVICE_ID);
101: FETCH cs_cp_services_all_pk_csr INTO l_cs_cp_services_all_pk;
102: l_row_notfound := cs_cp_services_all_pk_csr%NOTFOUND;
103: CLOSE cs_cp_services_all_pk_csr;
104: IF (l_row_notfound) THEN
105: TAPI_DEV_KIT.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'CP_SERVICE_ID');
106: RAISE item_not_found_error;

Line 103: CLOSE cs_cp_services_all_pk_csr;

99: THEN
100: OPEN cs_cp_services_all_pk_csr(p_coveragelevel_rec.CP_SERVICE_ID);
101: FETCH cs_cp_services_all_pk_csr INTO l_cs_cp_services_all_pk;
102: l_row_notfound := cs_cp_services_all_pk_csr%NOTFOUND;
103: CLOSE cs_cp_services_all_pk_csr;
104: IF (l_row_notfound) THEN
105: TAPI_DEV_KIT.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'CP_SERVICE_ID');
106: RAISE item_not_found_error;
107: END IF;