[Home] [Help]
301: l_api_name_full CONSTANT VARCHAR2(150):= g_pkg_name || '.'
302: || l_api_name;
303: Cursor c_get_obj_ver (p_cam_id IN NUMBER) is
304: select a.object_version_number,a.cure_amount,b.khr_id
305: from okl_cure_amounts a, okl_k_headers b
306: where cure_amount_id =p_cam_id
307: and a.chr_id =b.id;
308:
309: lp_camv_rec OKL_cam_pvt.camv_rec_type;
307: and a.chr_id =b.id;
308:
309: lp_camv_rec OKL_cam_pvt.camv_rec_type;
310: xp_camv_rec OKL_cam_pvt.camv_rec_type;
311: l_short_fund_amount okl_cure_amounts.short_fund_amount%TYPE;
312: l_cure_amount okl_cure_amounts.cure_amount%TYPE;
313: l_khr_id okl_k_headers.khr_id%TYPE;
314:
315: l_rule_name VARCHAR2(200);
308:
309: lp_camv_rec OKL_cam_pvt.camv_rec_type;
310: xp_camv_rec OKL_cam_pvt.camv_rec_type;
311: l_short_fund_amount okl_cure_amounts.short_fund_amount%TYPE;
312: l_cure_amount okl_cure_amounts.cure_amount%TYPE;
313: l_khr_id okl_k_headers.khr_id%TYPE;
314:
315: l_rule_name VARCHAR2(200);
316: l_rule_value VARCHAR2(2000);
336:
337: -- update Cure amounts table set error message,so this will be prefixed before
338: -- the actual message, so it makes more sense than displaying an OKL message.
339: AddfailMsg(
340: p_object => 'RECORD IN OKL_CURE_AMOUNTS ',
341: p_operation => 'UPDATE' );
342:
343: FOR i in p_cam_tbl.FIRST..p_cam_tbl.LAST
344: LOOP
401: END IF;
402:
403: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CAM : lp_camv_rec.process : '||lp_camv_rec.process);
404:
405: okl_cure_amounts_pub.update_cure_amounts(
406: p_api_version =>1.0
407: ,p_init_msg_list =>FND_API.G_FALSE
408: ,x_return_status =>l_return_status
409: ,x_msg_count =>l_msg_count
410: ,x_msg_data =>l_msg_data
411: ,p_camv_rec =>lp_camv_rec
412: ,x_camv_rec =>xp_camv_rec);
413:
414: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_CAM : okl_cure_amounts_pub.update_cure_amounts : '||l_return_status);
415:
416: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS)
417: THEN
418: Get_Messages (l_msg_count,l_message);
914: ,chr.conversion_type conversion_type
915: ,chr.conversion_rate conversion_rate
916: ,chr.conversion_rate_date conversion_rate_date
917: ,chr.authoring_org_id org_id
918: FROM okl_cure_amounts cam
919: ,okc_k_headers_b chr
920: WHERE chr.id = cam.chr_id
921: AND cam.cure_amount_id = p_cam_id;
922:
1552: || l_api_name;
1553:
1554: cursor c_get_qte_id ( p_cam_id IN NUMBER ) is
1555: select cam.qte_id,qte.date_effective_to
1556: from okl_cure_amounts cam, okl_trx_quotes_b qte
1557: where cam.cure_amount_id =p_cam_id
1558: and qte.id =cam.qte_id;
1559:
1560: lp_term_rec OKL_AM_TERMNT_QUOTE_PUB.term_rec_type;
1672: from okl_trx_ar_invoices_b where
1673: cpy_id =p_cam_id;
1674:
1675: l_tai_id okl_trx_ar_invoices_b.id%TYPE;
1676: l_process OKL_CURE_AMOUNTS.process%TYPE;
1677: BEGIN
1678:
1679: okl_debug_pub.logmessage('OKL_CURE_RECON_PVT : UPDATE_TAI_TIL : START ');
1680:
2069: SELECT okl.pdt_id
2070: ,okl.id
2071: ,okc.scs_code -- Bug# 4622198
2072: FROM okl_k_headers okl,
2073: okl_cure_amounts cam,
2074: okc_k_headers_b okc -- Bug# 4622198
2075: WHERE okc.id = okl.id -- Bug# 4622198
2076: and okl.id = cam.chr_id
2077: and cam.cure_amount_id =p_cam_id;
2105: l_message VARCHAR2(32627);
2106: l_api_name CONSTANT VARCHAR2(50) := 'CREATE_ACCOUNTING';
2107: l_api_name_full CONSTANT VARCHAR2(150):= g_pkg_name || '.'
2108: || l_api_name;
2109: l_process OKL_CURE_AMOUNTS.process%TYPE;
2110:
2111: --Bug# 4622198 :For special accounting treatment - START
2112:
2113: l_fact_synd_code FND_LOOKUPS.Lookup_code%TYPE;