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_PLANS_PUB dependencies on CN_ROLE_PLANS

Line 1: PACKAGE BODY cn_role_plans_pub AS

1: PACKAGE BODY cn_role_plans_pub AS
2: /* $Header: cnprlplb.pls 120.11 2007/07/26 01:10:20 appldev ship $ */
3: g_pkg_name CONSTANT VARCHAR2 (30) := 'CN_ROLE_PLANS_PUB';
4: g_file_name CONSTANT VARCHAR2 (12) := 'cnprlplb.pls';
5: g_last_update_date DATE := SYSDATE;

Line 3: g_pkg_name CONSTANT VARCHAR2 (30) := 'CN_ROLE_PLANS_PUB';

1: PACKAGE BODY cn_role_plans_pub AS
2: /* $Header: cnprlplb.pls 120.11 2007/07/26 01:10:20 appldev ship $ */
3: g_pkg_name CONSTANT VARCHAR2 (30) := 'CN_ROLE_PLANS_PUB';
4: g_file_name CONSTANT VARCHAR2 (12) := 'cnprlplb.pls';
5: g_last_update_date DATE := SYSDATE;
6: g_last_updated_by NUMBER := fnd_global.user_id;
7: g_creation_date DATE := SYSDATE;

Line 18: p_role_plan_id IN cn_role_plans.role_plan_id%TYPE,

14:
15: PROCEDURE business_event(
16: p_operation IN VARCHAR2,
17: p_pre_or_post IN VARCHAR2,
18: p_role_plan_id IN cn_role_plans.role_plan_id%TYPE,
19: p_role_plan_rec IN role_plan_rec_type
20: ) IS
21:
22: l_key VARCHAR2(80);

Line 142: p_role_plan_id cn_role_plans.role_plan_id%TYPE

138: -- Function : valid_role_plan_id
139: -- Desc : check if the role_plan_id exists in cn_roles
140: -- ---------------------------------------------------------------------------*
141: FUNCTION valid_role_plan_id (
142: p_role_plan_id cn_role_plans.role_plan_id%TYPE
143: )
144: RETURN BOOLEAN
145: IS
146: CURSOR l_cur (l_role_plan_id cn_role_plans.role_plan_id%TYPE)

Line 146: CURSOR l_cur (l_role_plan_id cn_role_plans.role_plan_id%TYPE)

142: p_role_plan_id cn_role_plans.role_plan_id%TYPE
143: )
144: RETURN BOOLEAN
145: IS
146: CURSOR l_cur (l_role_plan_id cn_role_plans.role_plan_id%TYPE)
147: IS
148: SELECT *
149: FROM cn_role_plans
150: WHERE role_plan_id = l_role_plan_id;

Line 149: FROM cn_role_plans

145: IS
146: CURSOR l_cur (l_role_plan_id cn_role_plans.role_plan_id%TYPE)
147: IS
148: SELECT *
149: FROM cn_role_plans
150: WHERE role_plan_id = l_role_plan_id;
151:
152: l_rec l_cur%ROWTYPE;
153: BEGIN

Line 173: -- Desc : check if the role_plan_id exists in cn_role_plans

169: END valid_role_plan_id;
170:
171: -- ----------------------------------------------------------------------------*
172: -- Function : is_exist
173: -- Desc : check if the role_plan_id exists in cn_role_plans
174: -- ---------------------------------------------------------------------------*
175: FUNCTION is_exist (p_role_plan_id cn_role_plans.role_plan_id%TYPE)
176: RETURN BOOLEAN
177: IS

Line 175: FUNCTION is_exist (p_role_plan_id cn_role_plans.role_plan_id%TYPE)

171: -- ----------------------------------------------------------------------------*
172: -- Function : is_exist
173: -- Desc : check if the role_plan_id exists in cn_role_plans
174: -- ---------------------------------------------------------------------------*
175: FUNCTION is_exist (p_role_plan_id cn_role_plans.role_plan_id%TYPE)
176: RETURN BOOLEAN
177: IS
178: CURSOR l_cur (l_role_plan_id cn_role_plans.role_plan_id%TYPE)
179: IS

Line 178: CURSOR l_cur (l_role_plan_id cn_role_plans.role_plan_id%TYPE)

174: -- ---------------------------------------------------------------------------*
175: FUNCTION is_exist (p_role_plan_id cn_role_plans.role_plan_id%TYPE)
176: RETURN BOOLEAN
177: IS
178: CURSOR l_cur (l_role_plan_id cn_role_plans.role_plan_id%TYPE)
179: IS
180: SELECT *
181: FROM cn_role_plans
182: WHERE role_plan_id = l_role_plan_id;

Line 181: FROM cn_role_plans

177: IS
178: CURSOR l_cur (l_role_plan_id cn_role_plans.role_plan_id%TYPE)
179: IS
180: SELECT *
181: FROM cn_role_plans
182: WHERE role_plan_id = l_role_plan_id;
183:
184: l_rec l_cur%ROWTYPE;
185: BEGIN

Line 205: -- Desc : check if the record is valid to insert into cn_role_plans

201: END is_exist;
202:
203: -- ----------------------------------------------------------------------------*
204: -- Procedure: check_valid_insert
205: -- Desc : check if the record is valid to insert into cn_role_plans
206: -- called in create_role_plan before inserting a role-plan
207: -- assignment
208: -- ----------------------------------------------------------------------------*
209: PROCEDURE check_valid_insert (

Line 225: l_org_id cn_role_plans.org_id%TYPE

221:
222: -- CHANTHON: Added ORG_ID as a param
223: CURSOR l_cur (
224: l_role_id cn_roles.role_id%TYPE,
225: l_org_id cn_role_plans.org_id%TYPE
226: )
227: IS
228: SELECT start_date, end_date, comp_plan_id
229: FROM cn_role_plans

Line 229: FROM cn_role_plans

225: l_org_id cn_role_plans.org_id%TYPE
226: )
227: IS
228: SELECT start_date, end_date, comp_plan_id
229: FROM cn_role_plans
230: WHERE role_id = l_role_id AND org_id = l_org_id;
231:
232: -- CHANTHON: Added the ORG_ID as a param
233: CURSOR l_cp_cur (

Line 388: -- If existing any same role_id in cn_role_plans THEN

384: CLOSE l_cp_cur;
385: END IF;
386:
387: -- CHANTHON: Adding the Org_id in the cursor.
388: -- If existing any same role_id in cn_role_plans THEN
389: -- check no overlap and no gap
390: FOR l_rec IN l_cur (x_role_id, p_role_plan_rec.org_id)
391: LOOP
392: IF cn_api.date_range_overlap (l_rec.start_date,

Line 455: -- Desc : check if the record is valid to update in cn_role_plans

451: END check_valid_insert;
452:
453: -- ----------------------------------------------------------------------------*
454: -- Procedure: check_valid_update
455: -- Desc : check if the record is valid to update in cn_role_plans
456: -- called in update_role_plan before updating a role
457: -- ----------------------------------------------------------------------------*
458: PROCEDURE check_valid_update (
459: x_return_status OUT NOCOPY VARCHAR2,

Line 464: x_role_plan_id_old OUT NOCOPY cn_role_plans.role_plan_id%TYPE,

460: x_msg_count OUT NOCOPY NUMBER,
461: x_msg_data OUT NOCOPY VARCHAR2,
462: p_role_plan_rec_old IN role_plan_rec_type,
463: p_role_plan_rec_new IN role_plan_rec_type,
464: x_role_plan_id_old OUT NOCOPY cn_role_plans.role_plan_id%TYPE,
465: x_role_id OUT NOCOPY cn_roles.role_id%TYPE,
466: x_comp_plan_id OUT NOCOPY cn_comp_plans.comp_plan_id%TYPE,
467: x_date_update_only OUT NOCOPY VARCHAR2,
468: p_loading_status IN VARCHAR2,

Line 473: tmp_start_date cn_role_plans.start_date%TYPE;

469: x_loading_status OUT NOCOPY VARCHAR2
470: )
471: IS
472: l_api_name CONSTANT VARCHAR2 (30) := 'check_valid_update';
473: tmp_start_date cn_role_plans.start_date%TYPE;
474: tmp_end_date cn_role_plans.end_date%TYPE;
475:
476: -- CHANTHON: Adding ORG_ID.. This cursor is used to check for whether the
477: -- role id already exists for another role_plan_id. If it does then the date overlap is

Line 474: tmp_end_date cn_role_plans.end_date%TYPE;

470: )
471: IS
472: l_api_name CONSTANT VARCHAR2 (30) := 'check_valid_update';
473: tmp_start_date cn_role_plans.start_date%TYPE;
474: tmp_end_date cn_role_plans.end_date%TYPE;
475:
476: -- CHANTHON: Adding ORG_ID.. This cursor is used to check for whether the
477: -- role id already exists for another role_plan_id. If it does then the date overlap is
478: -- being checked. So org_id is required.

Line 480: l_role_id cn_role_plans.role_id%TYPE,

476: -- CHANTHON: Adding ORG_ID.. This cursor is used to check for whether the
477: -- role id already exists for another role_plan_id. If it does then the date overlap is
478: -- being checked. So org_id is required.
479: CURSOR l_cur (
480: l_role_id cn_role_plans.role_id%TYPE,
481: l_role_plan_id cn_role_plans.role_plan_id%TYPE,
482: l_org_id cn_role_plans.org_id%TYPE
483: )
484: IS

Line 481: l_role_plan_id cn_role_plans.role_plan_id%TYPE,

477: -- role id already exists for another role_plan_id. If it does then the date overlap is
478: -- being checked. So org_id is required.
479: CURSOR l_cur (
480: l_role_id cn_role_plans.role_id%TYPE,
481: l_role_plan_id cn_role_plans.role_plan_id%TYPE,
482: l_org_id cn_role_plans.org_id%TYPE
483: )
484: IS
485: SELECT start_date, end_date, comp_plan_id

Line 482: l_org_id cn_role_plans.org_id%TYPE

478: -- being checked. So org_id is required.
479: CURSOR l_cur (
480: l_role_id cn_role_plans.role_id%TYPE,
481: l_role_plan_id cn_role_plans.role_plan_id%TYPE,
482: l_org_id cn_role_plans.org_id%TYPE
483: )
484: IS
485: SELECT start_date, end_date, comp_plan_id
486: FROM cn_role_plans

Line 486: FROM cn_role_plans

482: l_org_id cn_role_plans.org_id%TYPE
483: )
484: IS
485: SELECT start_date, end_date, comp_plan_id
486: FROM cn_role_plans
487: WHERE role_id = l_role_id
488: AND org_id = l_org_id
489: AND role_plan_id <> l_role_plan_id;
490:

Line 492: CURSOR l_old_cur (l_role_plan_id cn_role_plans.role_plan_id%TYPE)

488: AND org_id = l_org_id
489: AND role_plan_id <> l_role_plan_id;
490:
491: -- CHANTHON: Id based so ORG_ID not required
492: CURSOR l_old_cur (l_role_plan_id cn_role_plans.role_plan_id%TYPE)
493: IS
494: SELECT *
495: FROM cn_role_plans
496: WHERE role_plan_id = l_role_plan_id;

Line 495: FROM cn_role_plans

491: -- CHANTHON: Id based so ORG_ID not required
492: CURSOR l_old_cur (l_role_plan_id cn_role_plans.role_plan_id%TYPE)
493: IS
494: SELECT *
495: FROM cn_role_plans
496: WHERE role_plan_id = l_role_plan_id;
497:
498: l_old_rec l_old_cur%ROWTYPE;
499:

Line 516: -- old role_plan_id must exist in cn_role_plans

512: -- Start of API body
513:
514: -- validate the following issues
515:
516: -- old role_plan_id must exist in cn_role_plans
517: x_role_plan_id_old :=
518: cn_api.get_role_plan_id (p_role_plan_rec_old.role_name,
519: p_role_plan_rec_old.comp_plan_name,
520: p_role_plan_rec_old.start_date,

Line 804: -- If existing any same role_id in cn_role_plans THEN

800: CLOSE l_cp_cur;
801: END IF;
802:
803: --CHANTHON: Adding the org_id param in the cursor. Should be the org_id of the updated record.
804: -- If existing any same role_id in cn_role_plans THEN
805: -- check no overlap
806: FOR l_rec IN l_cur (x_role_id,
807: x_role_plan_id_old,
808: p_role_plan_rec_new.org_id

Line 902: -- Desc : check if the record is valid to delete from cn_role_plans

898: END check_valid_update;
899:
900: -- ----------------------------------------------------------------------------*
901: -- Procedure: check_valid_delete
902: -- Desc : check if the record is valid to delete from cn_role_plans
903: -- called in delete_role_plan before deleting a role
904: -- ----------------------------------------------------------------------------*
905: PROCEDURE check_valid_delete (
906: x_return_status OUT NOCOPY VARCHAR2,

Line 989: p_role_plan_id IN cn_role_plans.role_plan_id%TYPE,

985: -- Procedure: srp_plan_assignment_for_insert
986: -- --------------------------------------------------------------------------*
987: PROCEDURE srp_plan_assignment_for_insert (
988: p_role_id IN cn_roles.role_id%TYPE,
989: p_role_plan_id IN cn_role_plans.role_plan_id%TYPE,
990: x_return_status OUT NOCOPY VARCHAR2,
991: p_loading_status IN VARCHAR2,
992: x_loading_status OUT NOCOPY VARCHAR2,
993: p_org_id IN cn_role_plans.org_id%TYPE

Line 993: p_org_id IN cn_role_plans.org_id%TYPE

989: p_role_plan_id IN cn_role_plans.role_plan_id%TYPE,
990: x_return_status OUT NOCOPY VARCHAR2,
991: p_loading_status IN VARCHAR2,
992: x_loading_status OUT NOCOPY VARCHAR2,
993: p_org_id IN cn_role_plans.org_id%TYPE
994: )
995: IS
996: /* CURSOR l_cur IS
997: select sr.srp_role_id srp_role_id,

Line 1065: p_role_plan_id IN cn_role_plans.role_plan_id%TYPE,

1061: -- --------------------------------------------------------------------------*
1062: PROCEDURE srp_plan_assignment_for_update (
1063: p_role_id IN cn_roles.role_id%TYPE,
1064: p_role_id_old IN cn_roles.role_id%TYPE,
1065: p_role_plan_id IN cn_role_plans.role_plan_id%TYPE,
1066: p_date_update_only IN VARCHAR2,
1067: x_return_status OUT NOCOPY VARCHAR2,
1068: p_loading_status IN VARCHAR2,
1069: x_loading_status OUT NOCOPY VARCHAR2,

Line 1070: p_org_id IN cn_role_plans.org_id%TYPE,

1066: p_date_update_only IN VARCHAR2,
1067: x_return_status OUT NOCOPY VARCHAR2,
1068: p_loading_status IN VARCHAR2,
1069: x_loading_status OUT NOCOPY VARCHAR2,
1070: p_org_id IN cn_role_plans.org_id%TYPE,
1071: p_org_id_old IN cn_role_plans.org_id%TYPE
1072: )
1073: IS
1074: /* CURSOR l_cur IS

Line 1071: p_org_id_old IN cn_role_plans.org_id%TYPE

1067: x_return_status OUT NOCOPY VARCHAR2,
1068: p_loading_status IN VARCHAR2,
1069: x_loading_status OUT NOCOPY VARCHAR2,
1070: p_org_id IN cn_role_plans.org_id%TYPE,
1071: p_org_id_old IN cn_role_plans.org_id%TYPE
1072: )
1073: IS
1074: /* CURSOR l_cur IS
1075: select sr.srp_role_id srp_role_id,

Line 1191: p_role_plan_id IN cn_role_plans.role_plan_id%TYPE,

1187: -- Procedure: srp_plan_assignment_for_delete
1188: -- --------------------------------------------------------------------------*
1189: PROCEDURE srp_plan_assignment_for_delete (
1190: p_role_id IN cn_roles.role_id%TYPE,
1191: p_role_plan_id IN cn_role_plans.role_plan_id%TYPE,
1192: x_return_status OUT NOCOPY VARCHAR2,
1193: p_loading_status IN VARCHAR2,
1194: x_loading_status OUT NOCOPY VARCHAR2,
1195: p_org_id IN cn_role_plans.org_id%TYPE

Line 1195: p_org_id IN cn_role_plans.org_id%TYPE

1191: p_role_plan_id IN cn_role_plans.role_plan_id%TYPE,
1192: x_return_status OUT NOCOPY VARCHAR2,
1193: p_loading_status IN VARCHAR2,
1194: x_loading_status OUT NOCOPY VARCHAR2,
1195: p_org_id IN cn_role_plans.org_id%TYPE
1196: )
1197: IS
1198: CURSOR l_cur
1199: IS

Line 1259: l_role_plan_id cn_role_plans.role_plan_id%TYPE;

1255: )
1256: IS
1257: l_api_name CONSTANT VARCHAR2 (30) := 'Create_Role_Plan';
1258: l_api_version CONSTANT NUMBER := 1.0;
1259: l_role_plan_id cn_role_plans.role_plan_id%TYPE;
1260: l_role_id cn_roles.role_id%TYPE;
1261: l_comp_plan_id cn_comp_plans.comp_plan_id%TYPE;
1262: l_object_version_number cn_role_plans.object_version_number%TYPE := 1;
1263: -- Declaration for user hooks

Line 1262: l_object_version_number cn_role_plans.object_version_number%TYPE := 1;

1258: l_api_version CONSTANT NUMBER := 1.0;
1259: l_role_plan_id cn_role_plans.role_plan_id%TYPE;
1260: l_role_id cn_roles.role_id%TYPE;
1261: l_comp_plan_id cn_comp_plans.comp_plan_id%TYPE;
1262: l_object_version_number cn_role_plans.object_version_number%TYPE := 1;
1263: -- Declaration for user hooks
1264: l_rec role_plan_rec_type;
1265: l_oai_array jtf_usr_hks.oai_data_array_type;
1266: l_bind_data_id NUMBER;

Line 1303: 'cn.plsql.cn_role_plans_pub.create_role_plan.org_validate',

1299: status => l_status);
1300:
1301: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1302: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1303: 'cn.plsql.cn_role_plans_pub.create_role_plan.org_validate',
1304: 'Validated org_id = ' || l_org_id || ' status = '||l_status);
1305: end if;
1306: -- END OF MOAC ORG_ID VALIDATION
1307:

Line 1323: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',

1319:
1320: -- User hooks
1321:
1322: -- Customer pre-processing section
1323: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',
1324: 'CREATE_ROLE_PLAN',
1325: 'B',
1326: 'C'
1327: )

Line 1329: cn_role_plans_pub_cuhk.create_role_plan_pre

1325: 'B',
1326: 'C'
1327: )
1328: THEN
1329: cn_role_plans_pub_cuhk.create_role_plan_pre
1330: (p_api_version => p_api_version,
1331: p_init_msg_list => p_init_msg_list,
1332: p_commit => p_commit,
1333: p_validation_level => p_validation_level,

Line 1351: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',

1347: END IF;
1348: END IF;
1349:
1350: -- Vertical industry pre-processing section
1351: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',
1352: 'CREATE_ROLE_PLAN',
1353: 'B',
1354: 'V'
1355: )

Line 1357: cn_role_plans_pub_vuhk.create_role_plan_pre

1353: 'B',
1354: 'V'
1355: )
1356: THEN
1357: cn_role_plans_pub_vuhk.create_role_plan_pre
1358: (p_api_version => p_api_version,
1359: p_init_msg_list => p_init_msg_list,
1360: p_commit => p_commit,
1361: p_validation_level => p_validation_level,

Line 1395: SELECT cn_role_plans_s.NEXTVAL

1391: IF (x_return_status <> fnd_api.g_ret_sts_success)
1392: THEN
1393: RAISE fnd_api.g_exc_error;
1394: ELSE
1395: SELECT cn_role_plans_s.NEXTVAL
1396: INTO l_role_plan_id
1397: FROM DUAL;
1398:
1399: -- CHANTHON: Setting the role plan id out param

Line 1411: cn_role_plans_pkg.insert_row

1407: p_role_plan_id => l_role_plan_id,
1408: p_role_plan_rec => l_rec);
1409:
1410:
1411: cn_role_plans_pkg.insert_row
1412: (x_rowid => g_rowid,
1413: x_role_plan_id => l_role_plan_id,
1414: x_role_id => l_role_id,
1415: x_comp_plan_id => l_comp_plan_id,

Line 1485: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',

1481:
1482: -- User hooks
1483:
1484: -- Customer post-processing section
1485: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',
1486: 'CREATE_ROLE_PLAN',
1487: 'A',
1488: 'V'
1489: )

Line 1491: cn_role_plans_pub_cuhk.create_role_plan_post

1487: 'A',
1488: 'V'
1489: )
1490: THEN
1491: cn_role_plans_pub_cuhk.create_role_plan_post
1492: (p_api_version => p_api_version,
1493: p_init_msg_list => p_init_msg_list,
1494: p_commit => p_commit,
1495: p_validation_level => p_validation_level,

Line 1513: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',

1509: END IF;
1510: END IF;
1511:
1512: -- Vertical industry post-processing section
1513: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',
1514: 'CREATE_ROLE_PLAN',
1515: 'A',
1516: 'C'
1517: )

Line 1519: cn_role_plans_pub_vuhk.create_role_plan_post

1515: 'A',
1516: 'C'
1517: )
1518: THEN
1519: cn_role_plans_pub_vuhk.create_role_plan_post
1520: (p_api_version => p_api_version,
1521: p_init_msg_list => p_init_msg_list,
1522: p_commit => p_commit,
1523: p_validation_level => p_validation_level,

Line 1541: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',

1537: END IF;
1538: END IF;
1539:
1540: -- Message enable hook
1541: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',
1542: 'CREATE_ROLE_PLAN',
1543: 'M',
1544: 'M'
1545: )

Line 1547: IF cn_role_plans_pub_cuhk.ok_to_generate_msg

1543: 'M',
1544: 'M'
1545: )
1546: THEN
1547: IF cn_role_plans_pub_cuhk.ok_to_generate_msg
1548: (p_role_plan_rec => l_rec)
1549: THEN
1550: -- Clear bind variables
1551: -- XMLGEN.clearBindValues;

Line 1660: p_ovn IN OUT NOCOPY cn_role_plans.object_version_number%TYPE,

1656: x_msg_count OUT NOCOPY NUMBER,
1657: x_msg_data OUT NOCOPY VARCHAR2,
1658: p_role_plan_rec_old IN role_plan_rec_type
1659: := g_miss_role_plan_rec,
1660: p_ovn IN OUT NOCOPY cn_role_plans.object_version_number%TYPE,
1661: p_role_plan_rec_new IN role_plan_rec_type
1662: := g_miss_role_plan_rec,
1663: p_role_plan_id IN cn_role_plans.role_plan_id%TYPE
1664: )

Line 1663: p_role_plan_id IN cn_role_plans.role_plan_id%TYPE

1659: := g_miss_role_plan_rec,
1660: p_ovn IN OUT NOCOPY cn_role_plans.object_version_number%TYPE,
1661: p_role_plan_rec_new IN role_plan_rec_type
1662: := g_miss_role_plan_rec,
1663: p_role_plan_id IN cn_role_plans.role_plan_id%TYPE
1664: )
1665: IS
1666: --p_role_plan_id should be NULL if passing p_role_plan_rec_old
1667: l_api_name CONSTANT VARCHAR2 (30) := 'Update_Role_Plan';

Line 1669: l_role_plan_id_old cn_role_plans.role_plan_id%TYPE;

1665: IS
1666: --p_role_plan_id should be NULL if passing p_role_plan_rec_old
1667: l_api_name CONSTANT VARCHAR2 (30) := 'Update_Role_Plan';
1668: l_api_version CONSTANT NUMBER := 1.0;
1669: l_role_plan_id_old cn_role_plans.role_plan_id%TYPE;
1670: l_role_id cn_roles.role_id%TYPE;
1671: l_comp_plan_id cn_comp_plans.comp_plan_id%TYPE;
1672: l_date_update_only VARCHAR2 (1);
1673: -- Declaration for user hooks

Line 1743: FROM cn_role_plans

1739: attribute15,
1740: object_version_number,
1741: org_id
1742: INTO l_rec_old
1743: FROM cn_role_plans
1744: WHERE role_plan_id = p_role_plan_id;
1745: END IF;
1746:
1747: -- CHANTHON: Added to select the orignial record before updation END OF QUERY

Line 1756: 'cn.plsql.cn_role_plans_pub.update_role_plan.org_validate',

1752: status => l_status);
1753:
1754: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1755: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1756: 'cn.plsql.cn_role_plans_pub.update_role_plan.org_validate',
1757: 'Validated org_id = ' || l_org_id || ' status = '||l_status);
1758: end if;
1759:
1760: if (nvl(p_role_plan_rec_new.org_id, l_org_id)

Line 1765: 'cn.plsql.cn_role_plans_pub.update_role_plan.error',

1761: <> nvl(l_rec_old.org_id, l_org_id)) then
1762: FND_MESSAGE.SET_NAME ('FND' , 'FND_MO_OU_CANNOT_UPDATE');
1763: if (FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1764: FND_LOG.MESSAGE(FND_LOG.LEVEL_ERROR,
1765: 'cn.plsql.cn_role_plans_pub.update_role_plan.error',
1766: true);
1767: end if;
1768:
1769: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 1793: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',

1789:
1790: -- User hooks
1791:
1792: -- Customer pre-processing section
1793: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',
1794: 'UPDATE_ROLE_PLAN',
1795: 'B',
1796: 'C'
1797: )

Line 1799: cn_role_plans_pub_cuhk.update_role_plan_pre

1795: 'B',
1796: 'C'
1797: )
1798: THEN
1799: cn_role_plans_pub_cuhk.update_role_plan_pre
1800: (p_api_version => p_api_version,
1801: p_init_msg_list => p_init_msg_list,
1802: p_commit => p_commit,
1803: p_validation_level => p_validation_level,

Line 1822: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',

1818: END IF;
1819: END IF;
1820:
1821: -- Vertical industry pre-processing section
1822: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',
1823: 'UPDATE_ROLE_PLAN',
1824: 'B',
1825: 'V'
1826: )

Line 1828: cn_role_plans_pub_vuhk.update_role_plan_pre

1824: 'B',
1825: 'V'
1826: )
1827: THEN
1828: cn_role_plans_pub_vuhk.update_role_plan_pre
1829: (p_api_version => p_api_version,
1830: p_init_msg_list => p_init_msg_list,
1831: p_commit => p_commit,
1832: p_validation_level => p_validation_level,

Line 1882: cn_role_plans_pkg.update_row

1878: p_pre_or_post => 'pre',
1879: p_role_plan_id => l_role_plan_id_old,
1880: p_role_plan_rec => l_rec_old);
1881:
1882: cn_role_plans_pkg.update_row
1883: (x_role_plan_id => l_role_plan_id_old,
1884: x_role_id => l_role_id,
1885: x_comp_plan_id => l_comp_plan_id,
1886: x_start_date => p_role_plan_rec_new.start_date,

Line 2134: FROM cn_role_plans

2130: END IF;
2131: --CHANTHON: Selecting the object version number
2132: SELECT object_version_number
2133: INTO p_ovn
2134: FROM cn_role_plans
2135: WHERE role_plan_id = l_role_plan_id_old;
2136:
2137: -- Call srp assignment API to update
2138:

Line 2177: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',

2173:
2174: -- User hooks
2175:
2176: -- Customer post-processing section
2177: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',
2178: 'UPDATE_ROLE_PLAN',
2179: 'A',
2180: 'V'
2181: )

Line 2183: cn_role_plans_pub_cuhk.update_role_plan_post

2179: 'A',
2180: 'V'
2181: )
2182: THEN
2183: cn_role_plans_pub_cuhk.update_role_plan_post
2184: (p_api_version => p_api_version,
2185: p_init_msg_list => p_init_msg_list,
2186: p_commit => p_commit,
2187: p_validation_level => p_validation_level,

Line 2206: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',

2202: END IF;
2203: END IF;
2204:
2205: -- Vertical industry post-processing section
2206: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',
2207: 'UPDATE_ROLE_PLAN',
2208: 'A',
2209: 'C'
2210: )

Line 2212: cn_role_plans_pub_vuhk.update_role_plan_post

2208: 'A',
2209: 'C'
2210: )
2211: THEN
2212: cn_role_plans_pub_vuhk.update_role_plan_post
2213: (p_api_version => p_api_version,
2214: p_init_msg_list => p_init_msg_list,
2215: p_commit => p_commit,
2216: p_validation_level => p_validation_level,

Line 2235: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',

2231: END IF;
2232: END IF;
2233:
2234: -- Message enable hook
2235: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',
2236: 'UPDATE_ROLE_PLAN',
2237: 'M',
2238: 'M'
2239: )

Line 2241: IF cn_role_plans_pub_cuhk.ok_to_generate_msg

2237: 'M',
2238: 'M'
2239: )
2240: THEN
2241: IF cn_role_plans_pub_cuhk.ok_to_generate_msg
2242: (p_role_plan_rec => l_rec_new)
2243: THEN
2244: -- Clear bind variables
2245: -- XMLGEN.clearBindValues;

Line 2346: l_role_plan_id cn_role_plans.role_plan_id%TYPE;

2342: )
2343: IS
2344: l_api_name CONSTANT VARCHAR2 (30) := 'Delete_Role_Plan';
2345: l_api_version CONSTANT NUMBER := 1.0;
2346: l_role_plan_id cn_role_plans.role_plan_id%TYPE;
2347: l_role_id cn_roles.role_id%TYPE;
2348: -- Declaration for user hooks
2349: l_rec role_plan_rec_type;
2350: l_oai_array jtf_usr_hks.oai_data_array_type;

Line 2387: 'cn.plsql.cn_role_plans_pub.delete_role_plan.org_validate',

2383: status => l_status);
2384:
2385: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2386: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2387: 'cn.plsql.cn_role_plans_pub.delete_role_plan.org_validate',
2388: 'Validated org_id = ' || l_org_id || ' status = '||l_status);
2389: end if;
2390: -- END OF MOAC ORG_ID VALIDATION
2391:

Line 2408: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',

2404:
2405: -- User hooks
2406:
2407: -- Customer pre-processing section
2408: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',
2409: 'DELETE_ROLE_PLAN',
2410: 'B',
2411: 'C'
2412: )

Line 2414: cn_role_plans_pub_cuhk.delete_role_plan_pre

2410: 'B',
2411: 'C'
2412: )
2413: THEN
2414: cn_role_plans_pub_cuhk.delete_role_plan_pre
2415: (p_api_version => p_api_version,
2416: p_init_msg_list => p_init_msg_list,
2417: p_commit => p_commit,
2418: p_validation_level => p_validation_level,

Line 2436: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',

2432: END IF;
2433: END IF;
2434:
2435: -- Vertical industry pre-processing section
2436: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',
2437: 'DELETE_ROLE_PLAN',
2438: 'B',
2439: 'V'
2440: )

Line 2442: cn_role_plans_pub_vuhk.delete_role_plan_pre

2438: 'B',
2439: 'V'
2440: )
2441: THEN
2442: cn_role_plans_pub_vuhk.delete_role_plan_pre
2443: (p_api_version => p_api_version,
2444: p_init_msg_list => p_init_msg_list,
2445: p_commit => p_commit,
2446: p_validation_level => p_validation_level,

Line 2529: cn_role_plans_pkg.delete_row (x_role_plan_id => l_role_plan_id);

2525: END IF;
2526: -- Ends 12+ enhancement
2527:
2528: -- delete_row
2529: cn_role_plans_pkg.delete_row (x_role_plan_id => l_role_plan_id);
2530:
2531: /* System Generated - Create Note Functionality */
2532: fnd_message.set_name ('CN', 'CN_ROLE_PLAN_DEL');
2533: fnd_message.set_token ('NEWVALUE', l_rec.role_name);

Line 2565: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',

2561:
2562: -- User hooks
2563:
2564: -- Customer post-processing section
2565: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',
2566: 'DELETE_ROLE_PLAN',
2567: 'A',
2568: 'V'
2569: )

Line 2571: cn_role_plans_pub_cuhk.delete_role_plan_post

2567: 'A',
2568: 'V'
2569: )
2570: THEN
2571: cn_role_plans_pub_cuhk.delete_role_plan_post
2572: (p_api_version => p_api_version,
2573: p_init_msg_list => p_init_msg_list,
2574: p_commit => p_commit,
2575: p_validation_level => p_validation_level,

Line 2593: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',

2589: END IF;
2590: END IF;
2591:
2592: -- Vertical industry post-processing section
2593: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',
2594: 'DELETE_ROLE_PLAN',
2595: 'A',
2596: 'C'
2597: )

Line 2599: cn_role_plans_pub_vuhk.delete_role_plan_post

2595: 'A',
2596: 'C'
2597: )
2598: THEN
2599: cn_role_plans_pub_vuhk.delete_role_plan_post
2600: (p_api_version => p_api_version,
2601: p_init_msg_list => p_init_msg_list,
2602: p_commit => p_commit,
2603: p_validation_level => p_validation_level,

Line 2621: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',

2617: END IF;
2618: END IF;
2619:
2620: -- Message enable hook
2621: IF jtf_usr_hks.ok_to_execute ('CN_ROLE_PLANS_PUB',
2622: 'DELETE_ROLE_PLAN',
2623: 'M',
2624: 'M'
2625: )

Line 2627: IF cn_role_plans_pub_cuhk.ok_to_generate_msg

2623: 'M',
2624: 'M'
2625: )
2626: THEN
2627: IF cn_role_plans_pub_cuhk.ok_to_generate_msg
2628: (p_role_plan_rec => l_rec)
2629: THEN
2630: -- Clear bind variables
2631: -- XMLGEN.clearBindValues;

Line 2713: END cn_role_plans_pub;

2709: p_encoded => fnd_api.g_false
2710: );
2711: END delete_role_plan;
2712:
2713: END cn_role_plans_pub;