APPS.OKC_NUMBER_SCHEMES_PVT dependencies on OKC_NUMBER_SCHEME_DTLS

Line 231: -- remove child records from okc_number_scheme_dtls

227: if (sql%notfound) then
228: raise no_data_found;
229: end if;
230:
231: -- remove child records from okc_number_scheme_dtls
232: delete from okc_number_scheme_dtls
233: where NUM_SCHEME_ID = X_NUM_SCHEME_ID;
234:
235: delete from OKC_NUMBER_SCHEMES_B

Line 232: delete from okc_number_scheme_dtls

228: raise no_data_found;
229: end if;
230:
231: -- remove child records from okc_number_scheme_dtls
232: delete from okc_number_scheme_dtls
233: where NUM_SCHEME_ID = X_NUM_SCHEME_ID;
234:
235: delete from OKC_NUMBER_SCHEMES_B
236: where NUM_SCHEME_ID = X_NUM_SCHEME_ID;