APPS.CN_PMTPLAN_PUB dependencies on CN_PMTPLAN_PUB

Line 1: PACKAGE BODY CN_PMTPLAN_PUB as

1: PACKAGE BODY CN_PMTPLAN_PUB as
2: -- $Header: cnppplnb.pls 120.4 2005/11/02 05:37:38 sjustina noship $
3:
4: -- -------------------------------------------------------------------------*
5: -- Procedure : Get_PmtPlan_ID

Line 19: L_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_PmtPlan_PUB';

15: x_pmt_plan_id OUT NOCOPY NUMBER,
16: x_loading_status OUT NOCOPY VARCHAR2,
17: x_status OUT NOCOPY VARCHAR2
18: ) IS
19: L_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_PmtPlan_PUB';
20: L_LAST_UPDATE_DATE DATE := sysdate;
21: L_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
22: L_CREATION_DATE DATE := sysdate;
23: L_CREATED_BY NUMBER := fnd_global.user_id;

Line 119: L_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_PmtPlan_PUB';

115: x_loading_status OUT NOCOPY VARCHAR2,
116: x_status OUT NOCOPY VARCHAR2
117: ) IS
118:
119: L_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_PmtPlan_PUB';
120: l_api_name CONSTANT VARCHAR2(30) := 'Create_PmtPlan';
121: l_api_version CONSTANT NUMBER := 1.0;
122:
123:

Line 135: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'cn.plsql.cn_pmtplan_pub.Create_PmtPlan.org_validate',

131:
132: l_create_rec.org_id := p_PmtPlan_rec.org_id;
133: mo_global.validate_orgid_pub_api(org_id => l_create_rec.org_id,status =>l_status);
134: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
135: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'cn.plsql.cn_pmtplan_pub.Create_PmtPlan.org_validate',
136: 'Validated org_id = ' || l_create_rec.org_id || ' status ='||l_status);
137: end if;
138:
139: l_create_rec.name := p_PmtPlan_rec.name;

Line 233: L_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_PmtPlan_PUB';

229: l_count NUMBER := 0;
230: l_start_date DATE;
231: l_end_date DATE;
232:
233: L_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_PmtPlan_PUB';
234: L_LAST_UPDATE_DATE DATE := sysdate;
235: L_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
236: L_CREATION_DATE DATE := sysdate;
237: L_CREATED_BY NUMBER := fnd_global.user_id;

Line 315: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'cn.plsql.cn_pmtplan_pub.Update_PmtPlan.org_validate',

311:
312: l_update_rec.org_id := p_PmtPlan_rec.org_id;
313: mo_global.validate_orgid_pub_api(org_id => l_update_rec.org_id,status =>l_status);
314: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
315: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'cn.plsql.cn_pmtplan_pub.Update_PmtPlan.org_validate',
316: 'Validated org_id = ' || l_update_rec.org_id || ' status ='||l_status);
317: end if;
318:
319: if (l_update_rec.org_id <> l_update_old_rec.org_id ) then

Line 441: L_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_PmtPlan_PUB';

437: ) IS
438:
439: l_api_name CONSTANT VARCHAR2(30) := 'Delete_PmtPlan';
440: l_api_version CONSTANT NUMBER := 1.0;
441: L_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_PmtPlan_PUB';
442:
443: l_create_rec cn_pmtplan_pvt.PmtPlan_rec_type;
444: l_start_date cn_pmt_plans.start_date%TYPE;
445: l_status VARCHAR2(1);

Line 457: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'cn.plsql.cn_pmtplan_pub.delete_PmtPlan.org_validate',

453: -- Get the start date for payment plan using the payment plan name and org id
454: l_create_rec.org_id := p_PmtPlan_rec.org_id;
455: mo_global.validate_orgid_pub_api(org_id => l_create_rec.org_id,status =>l_status);
456: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
457: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'cn.plsql.cn_pmtplan_pub.delete_PmtPlan.org_validate',
458: 'Validated org_id = ' || l_create_rec.org_id || ' status ='||l_status);
459: end if;
460: l_create_rec.name := p_PmtPlan_rec.name;
461: l_create_rec.start_date := p_PmtPlan_rec.start_date;

Line 484: END CN_PmtPlan_PUB ;

480: x_loading_status => x_loading_status);
481:
482: END Delete_PmtPlan;
483:
484: END CN_PmtPlan_PUB ;