APPS.OKC_DELETE_CONTRACT_PVT dependencies on OKC_PRICE_ADJUSTMENT_PVT

Line 213: l_patv_tbl_in OKC_PRICE_ADJUSTMENT_PVT.patv_tbl_type;

209: ----
210:
211: FUNCTION DELETE_PRICE_ADJUSTMENTS( p_chr_id number) Return varchar2 IS
212:
213: l_patv_tbl_in OKC_PRICE_ADJUSTMENT_PVT.patv_tbl_type;
214:
215: CURSOR l_patb_csr (p_id IN NUMBER) IS
216: SELECT ID,cle_id
217: FROM OKC_PRICE_ADJUSTMENTS_V

Line 275: l_pacv_tbl_in OKC_PRICE_ADJUSTMENT_PVT.pacv_tbl_type;

271: ---Alternate code is added in OKCCPATB.pls .
272:
273: FUNCTION DELETE_PRICE_ADJ_ASSOCS( p_chr_id number) Return varchar2 IS
274:
275: l_pacv_tbl_in OKC_PRICE_ADJUSTMENT_PVT.pacv_tbl_type;
276:
277: CURSOR l_pacb_csr (p_id IN NUMBER) IS
278: SELECT ID
279: FROM OKC_PRICE_ADJ_ASSOCS_V

Line 334: l_paav_tbl_in OKC_PRICE_ADJUSTMENT_PVT.paav_tbl_type;

330:
331: ------
332: FUNCTION DELETE_PRICE_ADJ_ATTRIBS( p_chr_id number) Return varchar2 IS
333:
334: l_paav_tbl_in OKC_PRICE_ADJUSTMENT_PVT.paav_tbl_type;
335:
336: CURSOR l_paab_csr (p_id IN NUMBER) IS
337: SELECT ID
338: FROM OKC_PRICE_ADJ_ATTRIBS_V

Line 395: l_pavv_tbl_in OKC_PRICE_ADJUSTMENT_PVT.pavv_tbl_type;

391: */
392: ---------
393: FUNCTION DELETE_PRICE_ATT_VALUES( p_chr_id number) Return varchar2 IS
394:
395: l_pavv_tbl_in OKC_PRICE_ADJUSTMENT_PVT.pavv_tbl_type;
396:
397: CURSOR l_pavb_csr (p_id IN NUMBER) IS
398: SELECT ID
399: FROM OKC_PRICE_ATT_VALUES_V