1: PACKAGE BODY CN_WKSHT_CT_UP_PUB as
2: -- $Header: cnvwkcdb.pls 120.2 2006/02/13 15:24:08 fmburu noship $
3:
4: --============================================================================
5: --Modified by Julia Huang for bug 2803102.
61:
62: wksht_recs get_wksht%ROWTYPE;
63: wksht_recs1 CN_Payment_Worksheet_PVT.worksheet_rec_type;
64: l_ovn NUMBER ;
65: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_WKSHT_CT_UP_PUB';
66:
67:
68: BEGIN
69: --
238: AND Nvl(ppa.end_date,ps.end_date) >= ps.start_date);
239:
240: wksht_recs get_wksht%ROWTYPE;
241:
242: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_WKSHT_CT_UP_PUB';
243:
244: BEGIN
245: --
246: -- Standard Start of API savepoint
436:
437: wksht_recs get_wksht%ROWTYPE;
438: wksht_recs1 CN_Payment_Worksheet_PVT.worksheet_rec_type;
439:
440: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_WKSHT_CT_UP_PUB';
441:
442: BEGIN
443: --
444: -- Standard Start of API savepoint
664:
665: wksht_recs get_wksht%ROWTYPE;
666: wksht_recs1 CN_Payment_Worksheet_PVT.worksheet_rec_type;
667:
668: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_WKSHT_CT_UP_PUB';
669:
670: l_srp_pmt_plan_id NUMBER;
671:
672: BEGIN
837: p_encoded => FND_API.G_FALSE
838: );
839: END Apply_payment_plan_cre;
840:
841: END CN_WKSHT_CT_UP_PUB;