1307: WHERE IPYB.ID = p_ipy_id;
1308: l_khr_status VARCHAR2(30) ;
1309: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
1310: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
1311: l_klev_rec Okl_Kle_Pvt.klev_rec_type ;
1312: lx_klev_rec Okl_Kle_Pvt.klev_rec_type ;
1313:
1314: BEGIN
1315:
1308: l_khr_status VARCHAR2(30) ;
1309: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
1310: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
1311: l_klev_rec Okl_Kle_Pvt.klev_rec_type ;
1312: lx_klev_rec Okl_Kle_Pvt.klev_rec_type ;
1313:
1314: BEGIN
1315:
1316: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
4728: l_vendor_refund_amount NUMBER;
4729: l_khr_status VARCHAR2(30) ;
4730: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
4731: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
4732: l_klev_rec Okl_Kle_Pvt.klev_rec_type ;
4733: lx_klev_rec Okl_Kle_Pvt.klev_rec_type ;
4734: --
4735: -- Records /Tables Declaration
4736: l_ipyv_rec ipyv_rec_type;
4729: l_khr_status VARCHAR2(30) ;
4730: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
4731: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
4732: l_klev_rec Okl_Kle_Pvt.klev_rec_type ;
4733: lx_klev_rec Okl_Kle_Pvt.klev_rec_type ;
4734: --
4735: -- Records /Tables Declaration
4736: l_ipyv_rec ipyv_rec_type;
4737:
5869: l_id NUMBER ;
5870: l_ipyv_rec ipyv_rec_type;
5871: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
5872: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
5873: l_klev_rec Okl_Kle_Pvt.klev_rec_type ;
5874: lx_klev_rec Okl_Kle_Pvt.klev_rec_type ;
5875: l_cust_refund NUMBER ;
5876: l_vendor_adjustment NUMBER;
5877: l_khr_status VARCHAR2(30) ;
5870: l_ipyv_rec ipyv_rec_type;
5871: l_clev_rec okl_okc_migration_pvt.clev_rec_type;
5872: lx_clev_rec okl_okc_migration_pvt.clev_rec_type;
5873: l_klev_rec Okl_Kle_Pvt.klev_rec_type ;
5874: lx_klev_rec Okl_Kle_Pvt.klev_rec_type ;
5875: l_cust_refund NUMBER ;
5876: l_vendor_adjustment NUMBER;
5877: l_khr_status VARCHAR2(30) ;
5878: l_adjustment_amount NUMBER ;