eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_SRP_PMT_PLANS_PKG dependencies on CN_SRP_PMT_PLANS

Line 1: PACKAGE BODY CN_SRP_PMT_PLANS_PKG AS

1: PACKAGE BODY CN_SRP_PMT_PLANS_PKG AS
2: /* $Header: cntsppb.pls 120.1 2005/06/16 15:06:08 appldev $ */
3: --
4: -- Package Name
5: -- CN_SRP_PMT_PLANS_PKG

Line 5: -- CN_SRP_PMT_PLANS_PKG

1: PACKAGE BODY CN_SRP_PMT_PLANS_PKG AS
2: /* $Header: cntsppb.pls 120.1 2005/06/16 15:06:08 appldev $ */
3: --
4: -- Package Name
5: -- CN_SRP_PMT_PLANS_PKG
6: -- Purpose
7: -- Table Handler for CN_SRP_PMT_PLANS
8: -- FORM CNSRMT
9: -- BLOCK SRP_PMT_PLAN

Line 7: -- Table Handler for CN_SRP_PMT_PLANS

3: --
4: -- Package Name
5: -- CN_SRP_PMT_PLANS_PKG
6: -- Purpose
7: -- Table Handler for CN_SRP_PMT_PLANS
8: -- FORM CNSRMT
9: -- BLOCK SRP_PMT_PLAN
10: --
11: -- History

Line 34: SELECT cn_srp_pmt_plans_s.nextval

30: PROCEDURE Get_UID( X_srp_pmt_plan_id IN OUT NOCOPY NUMBER) IS
31:
32: BEGIN
33:
34: SELECT cn_srp_pmt_plans_s.nextval
35: INTO X_srp_pmt_plan_id
36: FROM dual;
37:
38: END Get_UID;

Line 89: INSERT INTO cn_srp_pmt_plans

85: BEGIN
86:
87: Get_UID( x_srp_pmt_plan_id );
88:
89: INSERT INTO cn_srp_pmt_plans
90: (srp_pmt_plan_id
91: ,pmt_plan_id
92: ,salesrep_id
93: ,org_id

Line 165: select 1 INTO l_dummy from CN_SRP_PMT_PLANS

161: ,x_role_pmt_plan_id
162: ,NVL(x_lock_flag, 'N')
163: );
164:
165: select 1 INTO l_dummy from CN_SRP_PMT_PLANS
166: where SRP_PMT_PLAN_ID = x_srp_pmt_plan_id;
167:
168: END Insert_row;
169:

Line 210: FROM cn_srp_pmt_plans

206: ) IS
207:
208: CURSOR C IS
209: SELECT *
210: FROM cn_srp_pmt_plans
211: WHERE srp_pmt_plan_id = x_srp_pmt_plan_id
212: FOR UPDATE of srp_pmt_plan_id NOWAIT;
213: tlinfo C%ROWTYPE;
214:

Line 327: l_pmt_plan_id cn_srp_pmt_plans.pmt_plan_id%TYPE;

323: ,x_Last_Update_Login NUMBER
324: ,x_object_version_number NUMBER
325: ,x_lock_flag VARCHAR2 ) IS
326:
327: l_pmt_plan_id cn_srp_pmt_plans.pmt_plan_id%TYPE;
328: l_salesrep_id cn_srp_pmt_plans.salesrep_id%TYPE;
329: l_org_id cn_srp_pmt_plans.org_id%TYPE;
330: l_role_id cn_srp_pmt_plans.role_id%TYPE;
331: l_credit_type_id cn_srp_pmt_plans.credit_type_id%TYPE;

Line 328: l_salesrep_id cn_srp_pmt_plans.salesrep_id%TYPE;

324: ,x_object_version_number NUMBER
325: ,x_lock_flag VARCHAR2 ) IS
326:
327: l_pmt_plan_id cn_srp_pmt_plans.pmt_plan_id%TYPE;
328: l_salesrep_id cn_srp_pmt_plans.salesrep_id%TYPE;
329: l_org_id cn_srp_pmt_plans.org_id%TYPE;
330: l_role_id cn_srp_pmt_plans.role_id%TYPE;
331: l_credit_type_id cn_srp_pmt_plans.credit_type_id%TYPE;
332: l_start_date cn_srp_pmt_plans.start_date%TYPE;

Line 329: l_org_id cn_srp_pmt_plans.org_id%TYPE;

325: ,x_lock_flag VARCHAR2 ) IS
326:
327: l_pmt_plan_id cn_srp_pmt_plans.pmt_plan_id%TYPE;
328: l_salesrep_id cn_srp_pmt_plans.salesrep_id%TYPE;
329: l_org_id cn_srp_pmt_plans.org_id%TYPE;
330: l_role_id cn_srp_pmt_plans.role_id%TYPE;
331: l_credit_type_id cn_srp_pmt_plans.credit_type_id%TYPE;
332: l_start_date cn_srp_pmt_plans.start_date%TYPE;
333: l_end_date cn_srp_pmt_plans.end_date%TYPE;

Line 330: l_role_id cn_srp_pmt_plans.role_id%TYPE;

326:
327: l_pmt_plan_id cn_srp_pmt_plans.pmt_plan_id%TYPE;
328: l_salesrep_id cn_srp_pmt_plans.salesrep_id%TYPE;
329: l_org_id cn_srp_pmt_plans.org_id%TYPE;
330: l_role_id cn_srp_pmt_plans.role_id%TYPE;
331: l_credit_type_id cn_srp_pmt_plans.credit_type_id%TYPE;
332: l_start_date cn_srp_pmt_plans.start_date%TYPE;
333: l_end_date cn_srp_pmt_plans.end_date%TYPE;
334: l_minimum_amount cn_srp_pmt_plans.minimum_amount%TYPE;

Line 331: l_credit_type_id cn_srp_pmt_plans.credit_type_id%TYPE;

327: l_pmt_plan_id cn_srp_pmt_plans.pmt_plan_id%TYPE;
328: l_salesrep_id cn_srp_pmt_plans.salesrep_id%TYPE;
329: l_org_id cn_srp_pmt_plans.org_id%TYPE;
330: l_role_id cn_srp_pmt_plans.role_id%TYPE;
331: l_credit_type_id cn_srp_pmt_plans.credit_type_id%TYPE;
332: l_start_date cn_srp_pmt_plans.start_date%TYPE;
333: l_end_date cn_srp_pmt_plans.end_date%TYPE;
334: l_minimum_amount cn_srp_pmt_plans.minimum_amount%TYPE;
335: l_maximum_amount cn_srp_pmt_plans.maximum_amount%TYPE;

Line 332: l_start_date cn_srp_pmt_plans.start_date%TYPE;

328: l_salesrep_id cn_srp_pmt_plans.salesrep_id%TYPE;
329: l_org_id cn_srp_pmt_plans.org_id%TYPE;
330: l_role_id cn_srp_pmt_plans.role_id%TYPE;
331: l_credit_type_id cn_srp_pmt_plans.credit_type_id%TYPE;
332: l_start_date cn_srp_pmt_plans.start_date%TYPE;
333: l_end_date cn_srp_pmt_plans.end_date%TYPE;
334: l_minimum_amount cn_srp_pmt_plans.minimum_amount%TYPE;
335: l_maximum_amount cn_srp_pmt_plans.maximum_amount%TYPE;
336: l_max_recovery_amount cn_srp_pmt_plans.max_recovery_amount%TYPE;

Line 333: l_end_date cn_srp_pmt_plans.end_date%TYPE;

329: l_org_id cn_srp_pmt_plans.org_id%TYPE;
330: l_role_id cn_srp_pmt_plans.role_id%TYPE;
331: l_credit_type_id cn_srp_pmt_plans.credit_type_id%TYPE;
332: l_start_date cn_srp_pmt_plans.start_date%TYPE;
333: l_end_date cn_srp_pmt_plans.end_date%TYPE;
334: l_minimum_amount cn_srp_pmt_plans.minimum_amount%TYPE;
335: l_maximum_amount cn_srp_pmt_plans.maximum_amount%TYPE;
336: l_max_recovery_amount cn_srp_pmt_plans.max_recovery_amount%TYPE;
337: l_attribute_category cn_srp_pmt_plans.attribute_category%TYPE;

Line 334: l_minimum_amount cn_srp_pmt_plans.minimum_amount%TYPE;

330: l_role_id cn_srp_pmt_plans.role_id%TYPE;
331: l_credit_type_id cn_srp_pmt_plans.credit_type_id%TYPE;
332: l_start_date cn_srp_pmt_plans.start_date%TYPE;
333: l_end_date cn_srp_pmt_plans.end_date%TYPE;
334: l_minimum_amount cn_srp_pmt_plans.minimum_amount%TYPE;
335: l_maximum_amount cn_srp_pmt_plans.maximum_amount%TYPE;
336: l_max_recovery_amount cn_srp_pmt_plans.max_recovery_amount%TYPE;
337: l_attribute_category cn_srp_pmt_plans.attribute_category%TYPE;
338: l_attribute1 cn_srp_pmt_plans.attribute1%TYPE;

Line 335: l_maximum_amount cn_srp_pmt_plans.maximum_amount%TYPE;

331: l_credit_type_id cn_srp_pmt_plans.credit_type_id%TYPE;
332: l_start_date cn_srp_pmt_plans.start_date%TYPE;
333: l_end_date cn_srp_pmt_plans.end_date%TYPE;
334: l_minimum_amount cn_srp_pmt_plans.minimum_amount%TYPE;
335: l_maximum_amount cn_srp_pmt_plans.maximum_amount%TYPE;
336: l_max_recovery_amount cn_srp_pmt_plans.max_recovery_amount%TYPE;
337: l_attribute_category cn_srp_pmt_plans.attribute_category%TYPE;
338: l_attribute1 cn_srp_pmt_plans.attribute1%TYPE;
339: l_attribute2 cn_srp_pmt_plans.attribute2%TYPE;

Line 336: l_max_recovery_amount cn_srp_pmt_plans.max_recovery_amount%TYPE;

332: l_start_date cn_srp_pmt_plans.start_date%TYPE;
333: l_end_date cn_srp_pmt_plans.end_date%TYPE;
334: l_minimum_amount cn_srp_pmt_plans.minimum_amount%TYPE;
335: l_maximum_amount cn_srp_pmt_plans.maximum_amount%TYPE;
336: l_max_recovery_amount cn_srp_pmt_plans.max_recovery_amount%TYPE;
337: l_attribute_category cn_srp_pmt_plans.attribute_category%TYPE;
338: l_attribute1 cn_srp_pmt_plans.attribute1%TYPE;
339: l_attribute2 cn_srp_pmt_plans.attribute2%TYPE;
340: l_attribute3 cn_srp_pmt_plans.attribute3%TYPE;

Line 337: l_attribute_category cn_srp_pmt_plans.attribute_category%TYPE;

333: l_end_date cn_srp_pmt_plans.end_date%TYPE;
334: l_minimum_amount cn_srp_pmt_plans.minimum_amount%TYPE;
335: l_maximum_amount cn_srp_pmt_plans.maximum_amount%TYPE;
336: l_max_recovery_amount cn_srp_pmt_plans.max_recovery_amount%TYPE;
337: l_attribute_category cn_srp_pmt_plans.attribute_category%TYPE;
338: l_attribute1 cn_srp_pmt_plans.attribute1%TYPE;
339: l_attribute2 cn_srp_pmt_plans.attribute2%TYPE;
340: l_attribute3 cn_srp_pmt_plans.attribute3%TYPE;
341: l_attribute4 cn_srp_pmt_plans.attribute4%TYPE;

Line 338: l_attribute1 cn_srp_pmt_plans.attribute1%TYPE;

334: l_minimum_amount cn_srp_pmt_plans.minimum_amount%TYPE;
335: l_maximum_amount cn_srp_pmt_plans.maximum_amount%TYPE;
336: l_max_recovery_amount cn_srp_pmt_plans.max_recovery_amount%TYPE;
337: l_attribute_category cn_srp_pmt_plans.attribute_category%TYPE;
338: l_attribute1 cn_srp_pmt_plans.attribute1%TYPE;
339: l_attribute2 cn_srp_pmt_plans.attribute2%TYPE;
340: l_attribute3 cn_srp_pmt_plans.attribute3%TYPE;
341: l_attribute4 cn_srp_pmt_plans.attribute4%TYPE;
342: l_attribute5 cn_srp_pmt_plans.attribute5%TYPE;

Line 339: l_attribute2 cn_srp_pmt_plans.attribute2%TYPE;

335: l_maximum_amount cn_srp_pmt_plans.maximum_amount%TYPE;
336: l_max_recovery_amount cn_srp_pmt_plans.max_recovery_amount%TYPE;
337: l_attribute_category cn_srp_pmt_plans.attribute_category%TYPE;
338: l_attribute1 cn_srp_pmt_plans.attribute1%TYPE;
339: l_attribute2 cn_srp_pmt_plans.attribute2%TYPE;
340: l_attribute3 cn_srp_pmt_plans.attribute3%TYPE;
341: l_attribute4 cn_srp_pmt_plans.attribute4%TYPE;
342: l_attribute5 cn_srp_pmt_plans.attribute5%TYPE;
343: l_attribute6 cn_srp_pmt_plans.attribute6%TYPE;

Line 340: l_attribute3 cn_srp_pmt_plans.attribute3%TYPE;

336: l_max_recovery_amount cn_srp_pmt_plans.max_recovery_amount%TYPE;
337: l_attribute_category cn_srp_pmt_plans.attribute_category%TYPE;
338: l_attribute1 cn_srp_pmt_plans.attribute1%TYPE;
339: l_attribute2 cn_srp_pmt_plans.attribute2%TYPE;
340: l_attribute3 cn_srp_pmt_plans.attribute3%TYPE;
341: l_attribute4 cn_srp_pmt_plans.attribute4%TYPE;
342: l_attribute5 cn_srp_pmt_plans.attribute5%TYPE;
343: l_attribute6 cn_srp_pmt_plans.attribute6%TYPE;
344: l_attribute7 cn_srp_pmt_plans.attribute7%TYPE;

Line 341: l_attribute4 cn_srp_pmt_plans.attribute4%TYPE;

337: l_attribute_category cn_srp_pmt_plans.attribute_category%TYPE;
338: l_attribute1 cn_srp_pmt_plans.attribute1%TYPE;
339: l_attribute2 cn_srp_pmt_plans.attribute2%TYPE;
340: l_attribute3 cn_srp_pmt_plans.attribute3%TYPE;
341: l_attribute4 cn_srp_pmt_plans.attribute4%TYPE;
342: l_attribute5 cn_srp_pmt_plans.attribute5%TYPE;
343: l_attribute6 cn_srp_pmt_plans.attribute6%TYPE;
344: l_attribute7 cn_srp_pmt_plans.attribute7%TYPE;
345: l_attribute8 cn_srp_pmt_plans.attribute8%TYPE;

Line 342: l_attribute5 cn_srp_pmt_plans.attribute5%TYPE;

338: l_attribute1 cn_srp_pmt_plans.attribute1%TYPE;
339: l_attribute2 cn_srp_pmt_plans.attribute2%TYPE;
340: l_attribute3 cn_srp_pmt_plans.attribute3%TYPE;
341: l_attribute4 cn_srp_pmt_plans.attribute4%TYPE;
342: l_attribute5 cn_srp_pmt_plans.attribute5%TYPE;
343: l_attribute6 cn_srp_pmt_plans.attribute6%TYPE;
344: l_attribute7 cn_srp_pmt_plans.attribute7%TYPE;
345: l_attribute8 cn_srp_pmt_plans.attribute8%TYPE;
346: l_attribute9 cn_srp_pmt_plans.attribute9%TYPE;

Line 343: l_attribute6 cn_srp_pmt_plans.attribute6%TYPE;

339: l_attribute2 cn_srp_pmt_plans.attribute2%TYPE;
340: l_attribute3 cn_srp_pmt_plans.attribute3%TYPE;
341: l_attribute4 cn_srp_pmt_plans.attribute4%TYPE;
342: l_attribute5 cn_srp_pmt_plans.attribute5%TYPE;
343: l_attribute6 cn_srp_pmt_plans.attribute6%TYPE;
344: l_attribute7 cn_srp_pmt_plans.attribute7%TYPE;
345: l_attribute8 cn_srp_pmt_plans.attribute8%TYPE;
346: l_attribute9 cn_srp_pmt_plans.attribute9%TYPE;
347: l_attribute10 cn_srp_pmt_plans.attribute10%TYPE;

Line 344: l_attribute7 cn_srp_pmt_plans.attribute7%TYPE;

340: l_attribute3 cn_srp_pmt_plans.attribute3%TYPE;
341: l_attribute4 cn_srp_pmt_plans.attribute4%TYPE;
342: l_attribute5 cn_srp_pmt_plans.attribute5%TYPE;
343: l_attribute6 cn_srp_pmt_plans.attribute6%TYPE;
344: l_attribute7 cn_srp_pmt_plans.attribute7%TYPE;
345: l_attribute8 cn_srp_pmt_plans.attribute8%TYPE;
346: l_attribute9 cn_srp_pmt_plans.attribute9%TYPE;
347: l_attribute10 cn_srp_pmt_plans.attribute10%TYPE;
348: l_attribute11 cn_srp_pmt_plans.attribute11%TYPE;

Line 345: l_attribute8 cn_srp_pmt_plans.attribute8%TYPE;

341: l_attribute4 cn_srp_pmt_plans.attribute4%TYPE;
342: l_attribute5 cn_srp_pmt_plans.attribute5%TYPE;
343: l_attribute6 cn_srp_pmt_plans.attribute6%TYPE;
344: l_attribute7 cn_srp_pmt_plans.attribute7%TYPE;
345: l_attribute8 cn_srp_pmt_plans.attribute8%TYPE;
346: l_attribute9 cn_srp_pmt_plans.attribute9%TYPE;
347: l_attribute10 cn_srp_pmt_plans.attribute10%TYPE;
348: l_attribute11 cn_srp_pmt_plans.attribute11%TYPE;
349: l_attribute12 cn_srp_pmt_plans.attribute12%TYPE;

Line 346: l_attribute9 cn_srp_pmt_plans.attribute9%TYPE;

342: l_attribute5 cn_srp_pmt_plans.attribute5%TYPE;
343: l_attribute6 cn_srp_pmt_plans.attribute6%TYPE;
344: l_attribute7 cn_srp_pmt_plans.attribute7%TYPE;
345: l_attribute8 cn_srp_pmt_plans.attribute8%TYPE;
346: l_attribute9 cn_srp_pmt_plans.attribute9%TYPE;
347: l_attribute10 cn_srp_pmt_plans.attribute10%TYPE;
348: l_attribute11 cn_srp_pmt_plans.attribute11%TYPE;
349: l_attribute12 cn_srp_pmt_plans.attribute12%TYPE;
350: l_attribute13 cn_srp_pmt_plans.attribute13%TYPE;

Line 347: l_attribute10 cn_srp_pmt_plans.attribute10%TYPE;

343: l_attribute6 cn_srp_pmt_plans.attribute6%TYPE;
344: l_attribute7 cn_srp_pmt_plans.attribute7%TYPE;
345: l_attribute8 cn_srp_pmt_plans.attribute8%TYPE;
346: l_attribute9 cn_srp_pmt_plans.attribute9%TYPE;
347: l_attribute10 cn_srp_pmt_plans.attribute10%TYPE;
348: l_attribute11 cn_srp_pmt_plans.attribute11%TYPE;
349: l_attribute12 cn_srp_pmt_plans.attribute12%TYPE;
350: l_attribute13 cn_srp_pmt_plans.attribute13%TYPE;
351: l_attribute14 cn_srp_pmt_plans.attribute14%TYPE;

Line 348: l_attribute11 cn_srp_pmt_plans.attribute11%TYPE;

344: l_attribute7 cn_srp_pmt_plans.attribute7%TYPE;
345: l_attribute8 cn_srp_pmt_plans.attribute8%TYPE;
346: l_attribute9 cn_srp_pmt_plans.attribute9%TYPE;
347: l_attribute10 cn_srp_pmt_plans.attribute10%TYPE;
348: l_attribute11 cn_srp_pmt_plans.attribute11%TYPE;
349: l_attribute12 cn_srp_pmt_plans.attribute12%TYPE;
350: l_attribute13 cn_srp_pmt_plans.attribute13%TYPE;
351: l_attribute14 cn_srp_pmt_plans.attribute14%TYPE;
352: l_attribute15 cn_srp_pmt_plans.attribute15%TYPE;

Line 349: l_attribute12 cn_srp_pmt_plans.attribute12%TYPE;

345: l_attribute8 cn_srp_pmt_plans.attribute8%TYPE;
346: l_attribute9 cn_srp_pmt_plans.attribute9%TYPE;
347: l_attribute10 cn_srp_pmt_plans.attribute10%TYPE;
348: l_attribute11 cn_srp_pmt_plans.attribute11%TYPE;
349: l_attribute12 cn_srp_pmt_plans.attribute12%TYPE;
350: l_attribute13 cn_srp_pmt_plans.attribute13%TYPE;
351: l_attribute14 cn_srp_pmt_plans.attribute14%TYPE;
352: l_attribute15 cn_srp_pmt_plans.attribute15%TYPE;
353: l_lock_flag cn_srp_pmt_plans.lock_flag%TYPE;

Line 350: l_attribute13 cn_srp_pmt_plans.attribute13%TYPE;

346: l_attribute9 cn_srp_pmt_plans.attribute9%TYPE;
347: l_attribute10 cn_srp_pmt_plans.attribute10%TYPE;
348: l_attribute11 cn_srp_pmt_plans.attribute11%TYPE;
349: l_attribute12 cn_srp_pmt_plans.attribute12%TYPE;
350: l_attribute13 cn_srp_pmt_plans.attribute13%TYPE;
351: l_attribute14 cn_srp_pmt_plans.attribute14%TYPE;
352: l_attribute15 cn_srp_pmt_plans.attribute15%TYPE;
353: l_lock_flag cn_srp_pmt_plans.lock_flag%TYPE;
354:

Line 351: l_attribute14 cn_srp_pmt_plans.attribute14%TYPE;

347: l_attribute10 cn_srp_pmt_plans.attribute10%TYPE;
348: l_attribute11 cn_srp_pmt_plans.attribute11%TYPE;
349: l_attribute12 cn_srp_pmt_plans.attribute12%TYPE;
350: l_attribute13 cn_srp_pmt_plans.attribute13%TYPE;
351: l_attribute14 cn_srp_pmt_plans.attribute14%TYPE;
352: l_attribute15 cn_srp_pmt_plans.attribute15%TYPE;
353: l_lock_flag cn_srp_pmt_plans.lock_flag%TYPE;
354:
355: CURSOR C IS

Line 352: l_attribute15 cn_srp_pmt_plans.attribute15%TYPE;

348: l_attribute11 cn_srp_pmt_plans.attribute11%TYPE;
349: l_attribute12 cn_srp_pmt_plans.attribute12%TYPE;
350: l_attribute13 cn_srp_pmt_plans.attribute13%TYPE;
351: l_attribute14 cn_srp_pmt_plans.attribute14%TYPE;
352: l_attribute15 cn_srp_pmt_plans.attribute15%TYPE;
353: l_lock_flag cn_srp_pmt_plans.lock_flag%TYPE;
354:
355: CURSOR C IS
356: SELECT *

Line 353: l_lock_flag cn_srp_pmt_plans.lock_flag%TYPE;

349: l_attribute12 cn_srp_pmt_plans.attribute12%TYPE;
350: l_attribute13 cn_srp_pmt_plans.attribute13%TYPE;
351: l_attribute14 cn_srp_pmt_plans.attribute14%TYPE;
352: l_attribute15 cn_srp_pmt_plans.attribute15%TYPE;
353: l_lock_flag cn_srp_pmt_plans.lock_flag%TYPE;
354:
355: CURSOR C IS
356: SELECT *
357: FROM cn_srp_pmt_plans

Line 357: FROM cn_srp_pmt_plans

353: l_lock_flag cn_srp_pmt_plans.lock_flag%TYPE;
354:
355: CURSOR C IS
356: SELECT *
357: FROM cn_srp_pmt_plans
358: WHERE srp_pmt_plan_id = x_srp_pmt_plan_id
359: FOR UPDATE of srp_pmt_plan_id NOWAIT;
360: oldrow C%ROWTYPE;
361:

Line 493: UPDATE cn_srp_pmt_plans

489: l_attribute15,
490: l_lock_flag
491: FROM dual;
492:
493: UPDATE cn_srp_pmt_plans
494: SET
495: pmt_plan_id = l_pmt_plan_id,
496: salesrep_id = l_salesrep_id,
497: org_id = l_org_id,

Line 544: DELETE FROM cn_srp_pmt_plans

540: *-------------------------------------------------------------------------*/
541: PROCEDURE Delete_row( x_srp_pmt_plan_id NUMBER ) IS
542: BEGIN
543:
544: DELETE FROM cn_srp_pmt_plans
545: WHERE srp_pmt_plan_id = x_srp_pmt_plan_id;
546: IF (SQL%NOTFOUND) THEN
547: RAISE NO_DATA_FOUND;
548: END IF;

Line 552: END CN_SRP_PMT_PLANS_PKG;

548: END IF;
549:
550: END Delete_row;
551:
552: END CN_SRP_PMT_PLANS_PKG;