66:
67:
68: BEGIN
69: --
70: -- Standard Start of API savepoint
71: --
72:
73: SAVEPOINT Create_delete_Wrkhst;
74: --
71: --
72:
73: SAVEPOINT Create_delete_Wrkhst;
74: --
75: -- Standard call to check for call compatibility.
76: --
77:
78: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
79: p_api_version ,
130:
131: -- End of API body.
132:
133:
134: -- Standard check of p_commit.
135: IF FND_API.To_Boolean( p_commit ) THEN
136: COMMIT WORK;
137: END IF;
138:
138:
139:
140:
141: --
142: -- Standard call to get message count and if count is 1, get message info.
143: --
144:
145: FND_MSG_PUB.Count_And_Get
146: (
242: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_WKSHT_CT_UP_PUB';
243:
244: BEGIN
245: --
246: -- Standard Start of API savepoint
247: --
248:
249: SAVEPOINT Apply_payment_plan_upd;
250: --
247: --
248:
249: SAVEPOINT Apply_payment_plan_upd;
250: --
251: -- Standard call to check for call compatibility.
252: --
253:
254: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
255: p_api_version ,
336: END LOOP;
337: close get_wksht;
338:
339: -- End of API body.
340: -- Standard check of p_commit.
341: IF FND_API.To_Boolean( p_commit ) THEN
342: COMMIT WORK;
343: END IF;
344:
342: COMMIT WORK;
343: END IF;
344:
345: --
346: -- Standard call to get message count and if count is 1, get message info.
347: --
348:
349: FND_MSG_PUB.Count_And_Get
350: (
440: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_WKSHT_CT_UP_PUB';
441:
442: BEGIN
443: --
444: -- Standard Start of API savepoint
445: --
446:
447: SAVEPOINT Apply_payment_plan_del;
448: --
445: --
446:
447: SAVEPOINT Apply_payment_plan_del;
448: --
449: -- Standard call to check for call compatibility.
450: --
451:
452: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
453: p_api_version ,
547: end if;
548: -- End of API body.
549:
550:
551: -- Standard check of p_commit.
552: IF FND_API.To_Boolean( p_commit ) THEN
553: COMMIT WORK;
554: END IF;
555:
555:
556:
557:
558: --
559: -- Standard call to get message count and if count is 1, get message info.
560: --
561:
562: FND_MSG_PUB.Count_And_Get
563: (
670: l_srp_pmt_plan_id NUMBER;
671:
672: BEGIN
673: --
674: -- Standard Start of API savepoint
675: --
676:
677: SAVEPOINT Apply_payment_plan_cre;
678: --
675: --
676:
677: SAVEPOINT Apply_payment_plan_cre;
678: --
679: -- Standard call to check for call compatibility.
680: --
681:
682: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
683: p_api_version ,
778: end if;
779: -- End of API body.
780:
781:
782: -- Standard check of p_commit.
783: IF FND_API.To_Boolean( p_commit ) THEN
784: COMMIT WORK;
785: END IF;
786:
786:
787:
788:
789: --
790: -- Standard call to get message count and if count is 1, get message info.
791: --
792:
793: FND_MSG_PUB.Count_And_Get
794: (