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_ROLE_PMT_PLANS_PVT dependencies on CN_ROLE_PMT_PLANS

Line 1: PACKAGE BODY CN_ROLE_PMT_PLANS_PVT AS

1: PACKAGE BODY CN_ROLE_PMT_PLANS_PVT AS
2: /* $Header: cnprptpb.pls 120.13 2006/08/23 10:29:14 sjustina noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_ROLE_PMT_PLANS_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cnprptpb.pls';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_ROLE_PMT_PLANS_PVT';

1: PACKAGE BODY CN_ROLE_PMT_PLANS_PVT AS
2: /* $Header: cnprptpb.pls 120.13 2006/08/23 10:29:14 sjustina noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_ROLE_PMT_PLANS_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cnprptpb.pls';
6: G_LAST_UPDATE_DATE DATE := sysdate;
7: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
8: G_CREATION_DATE DATE := sysdate;

Line 106: -- Desc : check if the record is valid to insert into cn_role_pmt_plans

102:
103:
104: -- ----------------------------------------------------------------------------*
105: -- Procedure: check_valid_insert
106: -- Desc : check if the record is valid to insert into cn_role_pmt_plans
107: -- called in create_role_pmt_plan before inserting a role-pmtplan
108: -- assignment
109: -- ----------------------------------------------------------------------------*
110: PROCEDURE check_valid_insert

Line 126: FROM cn_role_pmt_plans

122: l_api_name CONSTANT VARCHAR2(30) := 'check_valid_insert';
123:
124: CURSOR l_cur(l_role_id cn_roles.role_id%TYPE,l_org_id cn_pmt_plans.org_id%TYPE) IS
125: SELECT start_date, end_date, pmt_plan_id
126: FROM cn_role_pmt_plans
127: WHERE role_id = l_role_id
128: AND org_id = l_org_id;
129:
130: CURSOR l_pp_cur(l_pmt_plan_id cn_pmt_plans.pmt_plan_id%TYPE, l_org_id cn_pmt_plans.org_id%TYPE) IS

Line 265: -- If existing any same role_id in cn_role_pmt_plans THEN

261:
262: CLOSE l_pp_cur;
263: END IF;
264:
265: -- If existing any same role_id in cn_role_pmt_plans THEN
266: -- check no overlap and no gap
267: FOR l_rec IN l_cur(x_role_id,p_role_pmt_plan_rec.org_id)
268: LOOP
269:

Line 349: -- Desc : check if the record is valid to update in cn_role_pmt_plans

345:
346:
347: -- ----------------------------------------------------------------------------*
348: -- Procedure: check_valid_update
349: -- Desc : check if the record is valid to update in cn_role_pmt_plans
350: -- called in update_role_pmt_plan before updating a role
351: -- ----------------------------------------------------------------------------*
352: PROCEDURE check_valid_update
353: (

Line 359: x_role_pmt_plan_id_old OUT NOCOPY cn_role_pmt_plans.role_pmt_plan_id%TYPE,

355: x_msg_count OUT NOCOPY NUMBER,
356: x_msg_data OUT NOCOPY VARCHAR2,
357: p_role_pmt_plan_rec_old IN role_pmt_plan_rec_type,
358: p_role_pmt_plan_rec_new IN role_pmt_plan_rec_type,
359: x_role_pmt_plan_id_old OUT NOCOPY cn_role_pmt_plans.role_pmt_plan_id%TYPE,
360: x_role_id OUT NOCOPY cn_roles.role_id%TYPE,
361: x_pmt_plan_id OUT NOCOPY cn_pmt_plans.pmt_plan_id%TYPE,
362: x_date_update_only OUT NOCOPY VARCHAR2,
363: p_loading_status IN VARCHAR2,

Line 368: tmp_start_date cn_role_pmt_plans.start_date%TYPE;

364: x_loading_status OUT NOCOPY VARCHAR2
365: ) IS
366:
367: l_api_name CONSTANT VARCHAR2(30) := 'check_valid_update';
368: tmp_start_date cn_role_pmt_plans.start_date%TYPE;
369: tmp_end_date cn_role_pmt_plans.end_date%TYPE;
370:
371: CURSOR l_cur(l_role_id cn_role_plans.role_id%TYPE,
372: l_role_pmt_plan_id cn_role_pmt_plans.role_pmt_plan_id%TYPE) IS

Line 369: tmp_end_date cn_role_pmt_plans.end_date%TYPE;

365: ) IS
366:
367: l_api_name CONSTANT VARCHAR2(30) := 'check_valid_update';
368: tmp_start_date cn_role_pmt_plans.start_date%TYPE;
369: tmp_end_date cn_role_pmt_plans.end_date%TYPE;
370:
371: CURSOR l_cur(l_role_id cn_role_plans.role_id%TYPE,
372: l_role_pmt_plan_id cn_role_pmt_plans.role_pmt_plan_id%TYPE) IS
373: SELECT start_date, end_date, pmt_plan_id

Line 372: l_role_pmt_plan_id cn_role_pmt_plans.role_pmt_plan_id%TYPE) IS

368: tmp_start_date cn_role_pmt_plans.start_date%TYPE;
369: tmp_end_date cn_role_pmt_plans.end_date%TYPE;
370:
371: CURSOR l_cur(l_role_id cn_role_plans.role_id%TYPE,
372: l_role_pmt_plan_id cn_role_pmt_plans.role_pmt_plan_id%TYPE) IS
373: SELECT start_date, end_date, pmt_plan_id
374: FROM cn_role_pmt_plans
375: WHERE role_id = l_role_id AND
376: role_pmt_plan_id <> l_role_pmt_plan_id;

Line 374: FROM cn_role_pmt_plans

370:
371: CURSOR l_cur(l_role_id cn_role_plans.role_id%TYPE,
372: l_role_pmt_plan_id cn_role_pmt_plans.role_pmt_plan_id%TYPE) IS
373: SELECT start_date, end_date, pmt_plan_id
374: FROM cn_role_pmt_plans
375: WHERE role_id = l_role_id AND
376: role_pmt_plan_id <> l_role_pmt_plan_id;
377:
378: CURSOR l_old_cur(l_role_pmt_plan_id cn_role_pmt_plans.role_pmt_plan_id%TYPE) IS

Line 378: CURSOR l_old_cur(l_role_pmt_plan_id cn_role_pmt_plans.role_pmt_plan_id%TYPE) IS

374: FROM cn_role_pmt_plans
375: WHERE role_id = l_role_id AND
376: role_pmt_plan_id <> l_role_pmt_plan_id;
377:
378: CURSOR l_old_cur(l_role_pmt_plan_id cn_role_pmt_plans.role_pmt_plan_id%TYPE) IS
379: SELECT *
380: FROM cn_role_pmt_plans
381: WHERE role_pmt_plan_id = l_role_pmt_plan_id;
382:

Line 380: FROM cn_role_pmt_plans

376: role_pmt_plan_id <> l_role_pmt_plan_id;
377:
378: CURSOR l_old_cur(l_role_pmt_plan_id cn_role_pmt_plans.role_pmt_plan_id%TYPE) IS
379: SELECT *
380: FROM cn_role_pmt_plans
381: WHERE role_pmt_plan_id = l_role_pmt_plan_id;
382:
383: l_old_rec l_old_cur%ROWTYPE;
384:

Line 617: -- If existing any same role_id in cn_role_pmt_plans THEN

613: CLOSE l_pp_cur;
614: END IF;
615:
616:
617: -- If existing any same role_id in cn_role_pmt_plans THEN
618: -- check no overlap
619: FOR l_rec IN l_cur(x_role_id,x_role_pmt_plan_id_old)
620: LOOP
621: IF cn_api.date_range_overlap(l_rec.start_date,

Line 702: -- Desc : check if the record is valid to delete from cn_role_pmt_plans

698:
699:
700: -- ----------------------------------------------------------------------------*
701: -- Procedure: check_valid_delete
702: -- Desc : check if the record is valid to delete from cn_role_pmt_plans
703: -- called in delete_role_pmt_plan before deleting a role
704: -- ----------------------------------------------------------------------------*
705: PROCEDURE check_valid_delete
706: (

Line 797: p_role_pmt_plan_id IN cn_role_pmt_plans.role_pmt_plan_id%TYPE,

793: -- Procedure: srp_pmt_plan_asgn_for_insert
794: -- --------------------------------------------------------------------------*
795: PROCEDURE srp_pmt_plan_asgn_for_insert
796: (p_role_id IN cn_roles.role_id%TYPE,
797: p_role_pmt_plan_id IN cn_role_pmt_plans.role_pmt_plan_id%TYPE,
798: p_suppress_flag IN VARCHAR2 := 'N',
799: x_return_status OUT NOCOPY VARCHAR2,
800: p_loading_status IN VARCHAR2,
801: x_loading_status OUT NOCOPY VARCHAR2 ) IS

Line 848: from cn_role_pmt_plans

844: x_return_status := FND_API.G_RET_STS_SUCCESS;
845: x_loading_status := p_loading_status;
846:
847: select org_id into l_org_id
848: from cn_role_pmt_plans
849: where role_pmt_plan_id = p_role_pmt_plan_id;
850:
851:
852: FOR l_rec IN l_cur(l_org_id)

Line 904: (p_role_pmt_plan_id IN cn_role_pmt_plans.role_pmt_plan_id%TYPE,

900: -- --------------------------------------------------------------------------*
901: -- Procedure: srp_pmt_pmt_plan_asgn_for_update
902: -- --------------------------------------------------------------------------*
903: PROCEDURE srp_pmt_plan_asgn_for_update
904: (p_role_pmt_plan_id IN cn_role_pmt_plans.role_pmt_plan_id%TYPE,
905: p_role_id IN cn_roles.role_id%TYPE,
906: p_date_update_only IN VARCHAR2,
907: x_return_status OUT NOCOPY VARCHAR2,
908: p_loading_status IN VARCHAR2,

Line 923: CURSOR l_cur (l_org_id cn_role_pmt_plans.org_id%TYPE) IS

919: and srd.role_model_id is NULL
920: -- CHANGED FOR MODELING IMPACT
921: and sr.srp_role_id = srd.srp_role_id(+);*/
922:
923: CURSOR l_cur (l_org_id cn_role_pmt_plans.org_id%TYPE) IS
924: select srp_role_id
925: from cn_srp_roles
926: where role_id = p_role_id
927: and org_id = l_org_id;

Line 951: from cn_role_pmt_plans

947: -- status is PUSHED (salesrep push done, treat as OSC record), then
948: -- call SPA.update
949:
950: select org_id into l_org_id
951: from cn_role_pmt_plans
952: where role_pmt_plan_id = p_role_pmt_plan_id;
953:
954: FOR l_rec IN l_cur(l_org_id) LOOP
955:

Line 980: p_role_pmt_plan_id IN cn_role_pmt_plans.role_pmt_plan_id%TYPE,

976: -- Procedure: srp_pmt_plan_asgn_for_delete
977: -- --------------------------------------------------------------------------*
978: PROCEDURE srp_pmt_plan_asgn_for_delete
979: (p_role_id IN cn_roles.role_id%TYPE,
980: p_role_pmt_plan_id IN cn_role_pmt_plans.role_pmt_plan_id%TYPE,
981: p_suppress_flag IN VARCHAR2 := 'N',
982: x_return_status OUT NOCOPY VARCHAR2,
983: p_loading_status IN VARCHAR2,
984: x_loading_status OUT NOCOPY VARCHAR2 ) IS

Line 986: CURSOR l_cur (l_org_id cn_role_pmt_plans.org_id%TYPE) IS

982: x_return_status OUT NOCOPY VARCHAR2,
983: p_loading_status IN VARCHAR2,
984: x_loading_status OUT NOCOPY VARCHAR2 ) IS
985:
986: CURSOR l_cur (l_org_id cn_role_pmt_plans.org_id%TYPE) IS
987: SELECT srp_role_id
988: FROM cn_srp_roles
989: WHERE role_id = p_role_id
990: AND org_id = l_org_id;

Line 1008: from cn_role_pmt_plans

1004: x_return_status := FND_API.G_RET_STS_SUCCESS;
1005: x_loading_status := p_loading_status;
1006:
1007: select org_id into l_org_id
1008: from cn_role_pmt_plans
1009: where role_pmt_plan_id = p_role_pmt_plan_id;
1010:
1011: FOR l_rec IN l_cur(l_org_id)
1012: LOOP

Line 1075: l_role_pmt_plan_id cn_role_pmt_plans.role_pmt_plan_id%TYPE;

1071: ) IS
1072:
1073: l_api_name CONSTANT VARCHAR2(30) := 'Create_Role_Pmt_Plan';
1074: l_api_version CONSTANT NUMBER := 1.0;
1075: l_role_pmt_plan_id cn_role_pmt_plans.role_pmt_plan_id%TYPE;
1076: l_role_id cn_roles.role_id%TYPE;
1077: l_pmt_plan_id cn_pmt_plans.pmt_plan_id%TYPE;
1078:
1079:

Line 1130: SELECT cn_role_pmt_plans_s.NEXTVAL INTO l_role_pmt_plan_id

1126: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1127: RAISE FND_API.G_EXC_ERROR ;
1128: ELSE
1129:
1130: SELECT cn_role_pmt_plans_s.NEXTVAL INTO l_role_pmt_plan_id
1131: FROM dual;
1132:
1133: cn_role_pmt_plans_pkg.INSERT_ROW
1134: (

Line 1133: cn_role_pmt_plans_pkg.INSERT_ROW

1129:
1130: SELECT cn_role_pmt_plans_s.NEXTVAL INTO l_role_pmt_plan_id
1131: FROM dual;
1132:
1133: cn_role_pmt_plans_pkg.INSERT_ROW
1134: (
1135: x_org_id => p_role_pmt_plan_rec.org_id
1136: ,x_role_pmt_plan_id => l_role_pmt_plan_id
1137: ,x_role_id => l_role_id

Line 1248: p_ovn IN cn_role_pmt_plans.object_version_number%TYPE,

1244: x_loading_status OUT NOCOPY VARCHAR2 ,
1245: x_msg_count OUT NOCOPY NUMBER ,
1246: x_msg_data OUT NOCOPY VARCHAR2 ,
1247: p_role_pmt_plan_rec_old IN role_pmt_plan_rec_type := G_MISS_ROLE_PMT_PLAN_REC,
1248: p_ovn IN cn_role_pmt_plans.object_version_number%TYPE,
1249: p_role_pmt_plan_rec_new IN role_pmt_plan_rec_type := G_MISS_ROLE_PMT_PLAN_REC
1250: ) IS
1251:
1252: l_api_name CONSTANT VARCHAR2(30) := 'Update_Role_Pmt_Plan';

Line 1254: l_role_pmt_plan_id_old cn_role_pmt_plans.role_pmt_plan_id%TYPE;

1250: ) IS
1251:
1252: l_api_name CONSTANT VARCHAR2(30) := 'Update_Role_Pmt_Plan';
1253: l_api_version CONSTANT NUMBER := 1.0;
1254: l_role_pmt_plan_id_old cn_role_pmt_plans.role_pmt_plan_id%TYPE;
1255: l_role_id cn_roles.role_id%TYPE;
1256: l_pmt_plan_id cn_pmt_plans.pmt_plan_id%TYPE;
1257: l_date_update_only VARCHAR2(1);
1258:

Line 1318: cn_role_pmt_plans_pkg.UPDATE_ROW

1314: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1315: RAISE FND_API.G_EXC_ERROR;
1316: ELSE
1317:
1318: cn_role_pmt_plans_pkg.UPDATE_ROW
1319: (
1320: x_org_id => p_role_pmt_plan_rec_new.org_id
1321: ,x_role_pmt_plan_id => l_role_pmt_plan_id_old
1322: ,x_role_id => l_role_id

Line 1441: l_role_pmt_plan_id cn_role_pmt_plans.role_pmt_plan_id%TYPE;

1437: ) IS
1438:
1439: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Role_Pmt_Plan';
1440: l_api_version CONSTANT NUMBER := 1.0;
1441: l_role_pmt_plan_id cn_role_pmt_plans.role_pmt_plan_id%TYPE;
1442: l_role_id cn_roles.role_id%TYPE;
1443:
1444: -- Declaration for user hooks
1445: l_rec role_pmt_plan_rec_type;

Line 1510: cn_role_pmt_plans_pkg.delete_row(x_role_pmt_plan_id => l_role_pmt_plan_id);

1506: RAISE FND_API.G_EXC_ERROR;
1507: END IF;
1508:
1509: -- delete_row
1510: cn_role_pmt_plans_pkg.delete_row(x_role_pmt_plan_id => l_role_pmt_plan_id);
1511:
1512: END IF;
1513:
1514: -- End of API body

Line 1662: END CN_ROLE_PMT_PLANS_PVT;

1658: return 0;
1659:
1660: END date_range_intersect;
1661:
1662: END CN_ROLE_PMT_PLANS_PVT;