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.PER_CPN_BUS dependencies on PER_COMPETENCES

Line 103: (p_competence_id in per_competences.competence_id%TYPE

99: --
100: --
101: --
102: procedure chk_definition_id
103: (p_competence_id in per_competences.competence_id%TYPE
104: ,p_business_group_id in per_competences.business_group_id%TYPE
105: ,p_competence_definition_id in per_competences.competence_definition_id%TYPE
106: ,p_object_version_number in per_competences.object_version_number%TYPE
107: )

Line 104: ,p_business_group_id in per_competences.business_group_id%TYPE

100: --
101: --
102: procedure chk_definition_id
103: (p_competence_id in per_competences.competence_id%TYPE
104: ,p_business_group_id in per_competences.business_group_id%TYPE
105: ,p_competence_definition_id in per_competences.competence_definition_id%TYPE
106: ,p_object_version_number in per_competences.object_version_number%TYPE
107: )
108: is

Line 105: ,p_competence_definition_id in per_competences.competence_definition_id%TYPE

101: --
102: procedure chk_definition_id
103: (p_competence_id in per_competences.competence_id%TYPE
104: ,p_business_group_id in per_competences.business_group_id%TYPE
105: ,p_competence_definition_id in per_competences.competence_definition_id%TYPE
106: ,p_object_version_number in per_competences.object_version_number%TYPE
107: )
108: is
109: --

Line 106: ,p_object_version_number in per_competences.object_version_number%TYPE

102: procedure chk_definition_id
103: (p_competence_id in per_competences.competence_id%TYPE
104: ,p_business_group_id in per_competences.business_group_id%TYPE
105: ,p_competence_definition_id in per_competences.competence_definition_id%TYPE
106: ,p_object_version_number in per_competences.object_version_number%TYPE
107: )
108: is
109: --
110: l_exists per_competences.business_group_id%TYPE;

Line 110: l_exists per_competences.business_group_id%TYPE;

106: ,p_object_version_number in per_competences.object_version_number%TYPE
107: )
108: is
109: --
110: l_exists per_competences.business_group_id%TYPE;
111: l_api_updating boolean;
112: l_proc varchar2(72) := g_package||'chk_definition_id';
113: --
114: -- Cursor to check if competence_definition_id is unique within business group

Line 118: from per_competences pc

114: -- Cursor to check if competence_definition_id is unique within business group
115: --
116: cursor csr_chk_definition_id is
117: select business_group_id
118: from per_competences pc
119: where (( p_competence_id is null)
120: or (p_competence_id <> pc.competence_id)
121: )
122: and competence_definition_id = p_competence_definition_id

Line 126: from per_competences pc

122: and competence_definition_id = p_competence_definition_id
123: and p_business_group_id is null
124: UNION
125: select business_group_id
126: from per_competences pc
127: where ( (p_competence_id is null)
128: or(p_competence_id <> pc.competence_id)
129: )
130: and competence_definition_id = p_competence_definition_id

Line 222: (p_date_from in per_competences.date_from%TYPE

218: -- Access Status
219: -- Internal Development Use Only
220: --
221: Procedure chk_competence_dates
222: (p_date_from in per_competences.date_from%TYPE
223: ,p_date_to in per_competences.date_to%TYPE
224: ,p_competence_id in per_competences.competence_id%TYPE default null
225: ,p_called_from in varchar2 default null
226: ) is

Line 223: ,p_date_to in per_competences.date_to%TYPE

219: -- Internal Development Use Only
220: --
221: Procedure chk_competence_dates
222: (p_date_from in per_competences.date_from%TYPE
223: ,p_date_to in per_competences.date_to%TYPE
224: ,p_competence_id in per_competences.competence_id%TYPE default null
225: ,p_called_from in varchar2 default null
226: ) is
227: --

Line 224: ,p_competence_id in per_competences.competence_id%TYPE default null

220: --
221: Procedure chk_competence_dates
222: (p_date_from in per_competences.date_from%TYPE
223: ,p_date_to in per_competences.date_to%TYPE
224: ,p_competence_id in per_competences.competence_id%TYPE default null
225: ,p_called_from in varchar2 default null
226: ) is
227: --
228: l_exists varchar2(1);

Line 332: (p_competence_id in per_competences.competence_id%TYPE

328: --
329: --
330: --
331: procedure chk_certification_required
332: (p_competence_id in per_competences.competence_id%TYPE
333: ,p_object_version_number in per_competences.object_version_number%TYPE
334: ,p_certification_required in per_competences.certification_required%TYPE
335: ,p_effective_date in date
336: )

Line 333: ,p_object_version_number in per_competences.object_version_number%TYPE

329: --
330: --
331: procedure chk_certification_required
332: (p_competence_id in per_competences.competence_id%TYPE
333: ,p_object_version_number in per_competences.object_version_number%TYPE
334: ,p_certification_required in per_competences.certification_required%TYPE
335: ,p_effective_date in date
336: )
337: is

Line 334: ,p_certification_required in per_competences.certification_required%TYPE

330: --
331: procedure chk_certification_required
332: (p_competence_id in per_competences.competence_id%TYPE
333: ,p_object_version_number in per_competences.object_version_number%TYPE
334: ,p_certification_required in per_competences.certification_required%TYPE
335: ,p_effective_date in date
336: )
337: is
338: --

Line 426: (p_competence_id in per_competences.competence_id%TYPE

422: -- Internal Table Handler Use Only.
423: --
424: --
425: procedure chk_evaluation_method
426: (p_competence_id in per_competences.competence_id%TYPE
427: ,p_object_version_number in per_competences.object_version_number%TYPE
428: ,p_evaluation_method in per_competences.evaluation_method%TYPE
429: ,p_effective_date in date
430: ,p_business_group_id in per_competences.business_group_id%TYPE default null

Line 427: ,p_object_version_number in per_competences.object_version_number%TYPE

423: --
424: --
425: procedure chk_evaluation_method
426: (p_competence_id in per_competences.competence_id%TYPE
427: ,p_object_version_number in per_competences.object_version_number%TYPE
428: ,p_evaluation_method in per_competences.evaluation_method%TYPE
429: ,p_effective_date in date
430: ,p_business_group_id in per_competences.business_group_id%TYPE default null
431: )

Line 428: ,p_evaluation_method in per_competences.evaluation_method%TYPE

424: --
425: procedure chk_evaluation_method
426: (p_competence_id in per_competences.competence_id%TYPE
427: ,p_object_version_number in per_competences.object_version_number%TYPE
428: ,p_evaluation_method in per_competences.evaluation_method%TYPE
429: ,p_effective_date in date
430: ,p_business_group_id in per_competences.business_group_id%TYPE default null
431: )
432: is

Line 430: ,p_business_group_id in per_competences.business_group_id%TYPE default null

426: (p_competence_id in per_competences.competence_id%TYPE
427: ,p_object_version_number in per_competences.object_version_number%TYPE
428: ,p_evaluation_method in per_competences.evaluation_method%TYPE
429: ,p_effective_date in date
430: ,p_business_group_id in per_competences.business_group_id%TYPE default null
431: )
432: is
433: --
434: l_api_updating boolean;

Line 534: (p_competence_id in per_competences.competence_id%TYPE

530: -- Internal Table Handler Use Only.
531: --
532: --
533: procedure chk_renewal_period_units
534: (p_competence_id in per_competences.competence_id%TYPE
535: ,p_object_version_number in per_competences.object_version_number%TYPE
536: ,p_renewal_period_units in per_competences.renewal_period_units%TYPE
537: ,p_effective_date in date
538: )

Line 535: ,p_object_version_number in per_competences.object_version_number%TYPE

531: --
532: --
533: procedure chk_renewal_period_units
534: (p_competence_id in per_competences.competence_id%TYPE
535: ,p_object_version_number in per_competences.object_version_number%TYPE
536: ,p_renewal_period_units in per_competences.renewal_period_units%TYPE
537: ,p_effective_date in date
538: )
539: is

Line 536: ,p_renewal_period_units in per_competences.renewal_period_units%TYPE

532: --
533: procedure chk_renewal_period_units
534: (p_competence_id in per_competences.competence_id%TYPE
535: ,p_object_version_number in per_competences.object_version_number%TYPE
536: ,p_renewal_period_units in per_competences.renewal_period_units%TYPE
537: ,p_effective_date in date
538: )
539: is
540: --

Line 639: (p_competence_id in per_competences.competence_id%TYPE

635: -- Internal Table Handler Use Only.
636: --
637: --
638: procedure chk_renewable_unit_frequency
639: (p_competence_id in per_competences.competence_id%TYPE
640: ,p_object_version_number in per_competences.object_version_number%TYPE
641: ,p_renewal_period_units in per_competences.renewal_period_units%TYPE
642: ,p_renewal_period_frequency in per_competences.renewal_period_frequency%TYPE
643: )

Line 640: ,p_object_version_number in per_competences.object_version_number%TYPE

636: --
637: --
638: procedure chk_renewable_unit_frequency
639: (p_competence_id in per_competences.competence_id%TYPE
640: ,p_object_version_number in per_competences.object_version_number%TYPE
641: ,p_renewal_period_units in per_competences.renewal_period_units%TYPE
642: ,p_renewal_period_frequency in per_competences.renewal_period_frequency%TYPE
643: )
644: is

Line 641: ,p_renewal_period_units in per_competences.renewal_period_units%TYPE

637: --
638: procedure chk_renewable_unit_frequency
639: (p_competence_id in per_competences.competence_id%TYPE
640: ,p_object_version_number in per_competences.object_version_number%TYPE
641: ,p_renewal_period_units in per_competences.renewal_period_units%TYPE
642: ,p_renewal_period_frequency in per_competences.renewal_period_frequency%TYPE
643: )
644: is
645: --

Line 642: ,p_renewal_period_frequency in per_competences.renewal_period_frequency%TYPE

638: procedure chk_renewable_unit_frequency
639: (p_competence_id in per_competences.competence_id%TYPE
640: ,p_object_version_number in per_competences.object_version_number%TYPE
641: ,p_renewal_period_units in per_competences.renewal_period_units%TYPE
642: ,p_renewal_period_frequency in per_competences.renewal_period_frequency%TYPE
643: )
644: is
645: --
646: l_api_updating boolean;

Line 723: (p_competence_id in per_competences.competence_id%TYPE

719: -- Internal Table Handler Use Only.
720: --
721: --
722: procedure chk_rat_scale_bus_grp_exist
723: (p_competence_id in per_competences.competence_id%TYPE
724: ,p_object_version_number in per_competences.object_version_number%TYPE
725: ,p_rating_scale_id in per_rating_scales.rating_scale_id%TYPE
726: ,p_business_group_id in per_competences.business_group_id%TYPE default null
727: )

Line 724: ,p_object_version_number in per_competences.object_version_number%TYPE

720: --
721: --
722: procedure chk_rat_scale_bus_grp_exist
723: (p_competence_id in per_competences.competence_id%TYPE
724: ,p_object_version_number in per_competences.object_version_number%TYPE
725: ,p_rating_scale_id in per_rating_scales.rating_scale_id%TYPE
726: ,p_business_group_id in per_competences.business_group_id%TYPE default null
727: )
728: is

Line 726: ,p_business_group_id in per_competences.business_group_id%TYPE default null

722: procedure chk_rat_scale_bus_grp_exist
723: (p_competence_id in per_competences.competence_id%TYPE
724: ,p_object_version_number in per_competences.object_version_number%TYPE
725: ,p_rating_scale_id in per_rating_scales.rating_scale_id%TYPE
726: ,p_business_group_id in per_competences.business_group_id%TYPE default null
727: )
728: is
729: --
730: l_exists varchar2(1);

Line 825: (p_competence_id in per_competences.competence_id%TYPE

821: -- Internal Table Handler Use Only.
822: --
823: --
824: procedure chk_rating_scale_type
825: (p_competence_id in per_competences.competence_id%TYPE
826: ,p_object_version_number in per_competences.object_version_number%TYPE
827: ,p_rating_scale_id in per_rating_scales.rating_scale_id%TYPE
828: )
829: is

Line 826: ,p_object_version_number in per_competences.object_version_number%TYPE

822: --
823: --
824: procedure chk_rating_scale_type
825: (p_competence_id in per_competences.competence_id%TYPE
826: ,p_object_version_number in per_competences.object_version_number%TYPE
827: ,p_rating_scale_id in per_rating_scales.rating_scale_id%TYPE
828: )
829: is
830: --

Line 913: (p_competence_id in per_competences.competence_id%TYPE

909: -- Internal Table Handler Use Only.
910: --
911: --
912: procedure chk_competence_has_prof
913: (p_competence_id in per_competences.competence_id%TYPE
914: ,p_object_version_number in per_competences.object_version_number%TYPE
915: ,p_rating_scale_id in per_rating_scales.rating_scale_id%TYPE
916: )
917: is

Line 914: ,p_object_version_number in per_competences.object_version_number%TYPE

910: --
911: --
912: procedure chk_competence_has_prof
913: (p_competence_id in per_competences.competence_id%TYPE
914: ,p_object_version_number in per_competences.object_version_number%TYPE
915: ,p_rating_scale_id in per_rating_scales.rating_scale_id%TYPE
916: )
917: is
918: --

Line 1000: (p_competence_id in per_competences.competence_id%TYPE

996: -- Internal Table Handler Use Only.
997: --
998: --
999: procedure chk_competence_rating_update
1000: (p_competence_id in per_competences.competence_id%TYPE
1001: ,p_object_version_number in per_competences.object_version_number%TYPE
1002: ,p_rating_scale_id in per_competences.rating_scale_id%TYPE
1003: )
1004: is

Line 1001: ,p_object_version_number in per_competences.object_version_number%TYPE

997: --
998: --
999: procedure chk_competence_rating_update
1000: (p_competence_id in per_competences.competence_id%TYPE
1001: ,p_object_version_number in per_competences.object_version_number%TYPE
1002: ,p_rating_scale_id in per_competences.rating_scale_id%TYPE
1003: )
1004: is
1005: --

Line 1002: ,p_rating_scale_id in per_competences.rating_scale_id%TYPE

998: --
999: procedure chk_competence_rating_update
1000: (p_competence_id in per_competences.competence_id%TYPE
1001: ,p_object_version_number in per_competences.object_version_number%TYPE
1002: ,p_rating_scale_id in per_competences.rating_scale_id%TYPE
1003: )
1004: is
1005: --
1006: l_exists varchar2(1);

Line 1099: (p_competence_id in per_competences.competence_id%TYPE

1095: -- Internal Table Handler Use Only.
1096: --
1097: --
1098: procedure chk_competence_delete
1099: (p_competence_id in per_competences.competence_id%TYPE
1100: ,p_object_version_number in per_competences.object_version_number%TYPE
1101: )
1102: is
1103: --

Line 1100: ,p_object_version_number in per_competences.object_version_number%TYPE

1096: --
1097: --
1098: procedure chk_competence_delete
1099: (p_competence_id in per_competences.competence_id%TYPE
1100: ,p_object_version_number in per_competences.object_version_number%TYPE
1101: )
1102: is
1103: --
1104: l_exists varchar2(1);

Line 1257: (p_competence_id in per_competences.competence_id%TYPE

1253: -- Internal Table Handler Use Only.
1254: --
1255: --
1256: procedure chk_competence_cluster
1257: (p_competence_id in per_competences.competence_id%TYPE
1258: ,p_competence_cluster in per_competences.competence_cluster%TYPE
1259: ,p_object_version_number in per_competences.object_version_number%TYPE
1260: ,p_effective_date in date
1261: )

Line 1258: ,p_competence_cluster in per_competences.competence_cluster%TYPE

1254: --
1255: --
1256: procedure chk_competence_cluster
1257: (p_competence_id in per_competences.competence_id%TYPE
1258: ,p_competence_cluster in per_competences.competence_cluster%TYPE
1259: ,p_object_version_number in per_competences.object_version_number%TYPE
1260: ,p_effective_date in date
1261: )
1262: is

Line 1259: ,p_object_version_number in per_competences.object_version_number%TYPE

1255: --
1256: procedure chk_competence_cluster
1257: (p_competence_id in per_competences.competence_id%TYPE
1258: ,p_competence_cluster in per_competences.competence_cluster%TYPE
1259: ,p_object_version_number in per_competences.object_version_number%TYPE
1260: ,p_effective_date in date
1261: )
1262: is
1263: --

Line 1337: (p_competence_id in per_competences.competence_id%TYPE

1333: -- Internal Table Handler Use Only.
1334: --
1335: --
1336: procedure chk_unit_standard_id
1337: (p_competence_id in per_competences.competence_id%TYPE
1338: ,p_unit_standard_id in per_competences.unit_standard_id%TYPE
1339: ,p_business_group_id in per_competences.business_group_id%TYPE
1340: ,p_object_version_number in per_competences.object_version_number%TYPE
1341: ,p_effective_date in date

Line 1338: ,p_unit_standard_id in per_competences.unit_standard_id%TYPE

1334: --
1335: --
1336: procedure chk_unit_standard_id
1337: (p_competence_id in per_competences.competence_id%TYPE
1338: ,p_unit_standard_id in per_competences.unit_standard_id%TYPE
1339: ,p_business_group_id in per_competences.business_group_id%TYPE
1340: ,p_object_version_number in per_competences.object_version_number%TYPE
1341: ,p_effective_date in date
1342: )

Line 1339: ,p_business_group_id in per_competences.business_group_id%TYPE

1335: --
1336: procedure chk_unit_standard_id
1337: (p_competence_id in per_competences.competence_id%TYPE
1338: ,p_unit_standard_id in per_competences.unit_standard_id%TYPE
1339: ,p_business_group_id in per_competences.business_group_id%TYPE
1340: ,p_object_version_number in per_competences.object_version_number%TYPE
1341: ,p_effective_date in date
1342: )
1343: is

Line 1340: ,p_object_version_number in per_competences.object_version_number%TYPE

1336: procedure chk_unit_standard_id
1337: (p_competence_id in per_competences.competence_id%TYPE
1338: ,p_unit_standard_id in per_competences.unit_standard_id%TYPE
1339: ,p_business_group_id in per_competences.business_group_id%TYPE
1340: ,p_object_version_number in per_competences.object_version_number%TYPE
1341: ,p_effective_date in date
1342: )
1343: is
1344: --

Line 1349: select 1 from per_competences

1345: --
1346: -- declare cursor
1347: --
1348: cursor csr_local_unit_standard_id is
1349: select 1 from per_competences
1350: where unit_standard_id = p_unit_standard_id
1351: and business_group_id = p_business_group_id
1352: and p_effective_date between date_from and NVL(date_to, hr_api.g_eot);
1353: --

Line 1355: select 1 from per_competences

1351: and business_group_id = p_business_group_id
1352: and p_effective_date between date_from and NVL(date_to, hr_api.g_eot);
1353: --
1354: cursor csr_global_unit_standard_id is
1355: select 1 from per_competences
1356: where unit_standard_id = p_unit_standard_id
1357: and p_effective_date between date_from and NVL(date_to, hr_api.g_eot);
1358:
1359: l_proc varchar2(72) := g_package||'chk_unit_standard_id';

Line 1453: (p_competence_id in per_competences.competence_id%TYPE

1449: -- Internal Table Handler Use Only.
1450: --
1451: --
1452: procedure chk_credit_type
1453: (p_competence_id in per_competences.competence_id%TYPE
1454: ,p_credit_type in per_competences.credit_type%TYPE
1455: ,p_object_version_number in per_competences.object_version_number%TYPE
1456: ,p_effective_date in date
1457: )

Line 1454: ,p_credit_type in per_competences.credit_type%TYPE

1450: --
1451: --
1452: procedure chk_credit_type
1453: (p_competence_id in per_competences.competence_id%TYPE
1454: ,p_credit_type in per_competences.credit_type%TYPE
1455: ,p_object_version_number in per_competences.object_version_number%TYPE
1456: ,p_effective_date in date
1457: )
1458: is

Line 1455: ,p_object_version_number in per_competences.object_version_number%TYPE

1451: --
1452: procedure chk_credit_type
1453: (p_competence_id in per_competences.competence_id%TYPE
1454: ,p_credit_type in per_competences.credit_type%TYPE
1455: ,p_object_version_number in per_competences.object_version_number%TYPE
1456: ,p_effective_date in date
1457: )
1458: is
1459: --

Line 1534: (p_competence_id in per_competences.competence_id%TYPE

1530: -- Internal Table Handler Use Only.
1531: --
1532: --
1533: procedure chk_level_type
1534: (p_competence_id in per_competences.competence_id%TYPE
1535: ,p_level_type in per_competences.credit_type%TYPE
1536: ,p_object_version_number in per_competences.object_version_number%TYPE
1537: ,p_effective_date in date
1538: )

Line 1535: ,p_level_type in per_competences.credit_type%TYPE

1531: --
1532: --
1533: procedure chk_level_type
1534: (p_competence_id in per_competences.competence_id%TYPE
1535: ,p_level_type in per_competences.credit_type%TYPE
1536: ,p_object_version_number in per_competences.object_version_number%TYPE
1537: ,p_effective_date in date
1538: )
1539: is

Line 1536: ,p_object_version_number in per_competences.object_version_number%TYPE

1532: --
1533: procedure chk_level_type
1534: (p_competence_id in per_competences.competence_id%TYPE
1535: ,p_level_type in per_competences.credit_type%TYPE
1536: ,p_object_version_number in per_competences.object_version_number%TYPE
1537: ,p_effective_date in date
1538: )
1539: is
1540: --

Line 1615: (p_competence_id in per_competences.competence_id%TYPE

1611: -- Internal Table Handler Use Only.
1612: --
1613: --
1614: procedure chk_level_number
1615: (p_competence_id in per_competences.competence_id%TYPE
1616: ,p_level_number in per_competences.level_number%TYPE
1617: ,p_object_version_number in per_competences.object_version_number%TYPE
1618: ,p_effective_date in date
1619: )

Line 1616: ,p_level_number in per_competences.level_number%TYPE

1612: --
1613: --
1614: procedure chk_level_number
1615: (p_competence_id in per_competences.competence_id%TYPE
1616: ,p_level_number in per_competences.level_number%TYPE
1617: ,p_object_version_number in per_competences.object_version_number%TYPE
1618: ,p_effective_date in date
1619: )
1620: is

Line 1617: ,p_object_version_number in per_competences.object_version_number%TYPE

1613: --
1614: procedure chk_level_number
1615: (p_competence_id in per_competences.competence_id%TYPE
1616: ,p_level_number in per_competences.level_number%TYPE
1617: ,p_object_version_number in per_competences.object_version_number%TYPE
1618: ,p_effective_date in date
1619: )
1620: is
1621: --

Line 1696: (p_competence_id in per_competences.competence_id%TYPE

1692: -- Internal Table Handler Use Only.
1693: --
1694: --
1695: procedure chk_field
1696: (p_competence_id in per_competences.competence_id%TYPE
1697: ,p_field in per_competences.field%TYPE
1698: ,p_object_version_number in per_competences.object_version_number%TYPE
1699: ,p_effective_date in date
1700: )

Line 1697: ,p_field in per_competences.field%TYPE

1693: --
1694: --
1695: procedure chk_field
1696: (p_competence_id in per_competences.competence_id%TYPE
1697: ,p_field in per_competences.field%TYPE
1698: ,p_object_version_number in per_competences.object_version_number%TYPE
1699: ,p_effective_date in date
1700: )
1701: is

Line 1698: ,p_object_version_number in per_competences.object_version_number%TYPE

1694: --
1695: procedure chk_field
1696: (p_competence_id in per_competences.competence_id%TYPE
1697: ,p_field in per_competences.field%TYPE
1698: ,p_object_version_number in per_competences.object_version_number%TYPE
1699: ,p_effective_date in date
1700: )
1701: is
1702: --

Line 1777: (p_competence_id in per_competences.competence_id%TYPE

1773: -- Internal Table Handler Use Only.
1774: --
1775: --
1776: procedure chk_sub_field
1777: (p_competence_id in per_competences.competence_id%TYPE
1778: ,p_sub_field in per_competences.sub_field%TYPE
1779: ,p_object_version_number in per_competences.object_version_number%TYPE
1780: ,p_effective_date in date
1781: )

Line 1778: ,p_sub_field in per_competences.sub_field%TYPE

1774: --
1775: --
1776: procedure chk_sub_field
1777: (p_competence_id in per_competences.competence_id%TYPE
1778: ,p_sub_field in per_competences.sub_field%TYPE
1779: ,p_object_version_number in per_competences.object_version_number%TYPE
1780: ,p_effective_date in date
1781: )
1782: is

Line 1779: ,p_object_version_number in per_competences.object_version_number%TYPE

1775: --
1776: procedure chk_sub_field
1777: (p_competence_id in per_competences.competence_id%TYPE
1778: ,p_sub_field in per_competences.sub_field%TYPE
1779: ,p_object_version_number in per_competences.object_version_number%TYPE
1780: ,p_effective_date in date
1781: )
1782: is
1783: --

Line 1858: (p_competence_id in per_competences.competence_id%TYPE

1854: -- Internal Table Handler Use Only.
1855: --
1856: --
1857: procedure chk_provider
1858: (p_competence_id in per_competences.competence_id%TYPE
1859: ,p_provider in per_competences.provider%TYPE
1860: ,p_object_version_number in per_competences.object_version_number%TYPE
1861: ,p_effective_date in date
1862: )

Line 1859: ,p_provider in per_competences.provider%TYPE

1855: --
1856: --
1857: procedure chk_provider
1858: (p_competence_id in per_competences.competence_id%TYPE
1859: ,p_provider in per_competences.provider%TYPE
1860: ,p_object_version_number in per_competences.object_version_number%TYPE
1861: ,p_effective_date in date
1862: )
1863: is

Line 1860: ,p_object_version_number in per_competences.object_version_number%TYPE

1856: --
1857: procedure chk_provider
1858: (p_competence_id in per_competences.competence_id%TYPE
1859: ,p_provider in per_competences.provider%TYPE
1860: ,p_object_version_number in per_competences.object_version_number%TYPE
1861: ,p_effective_date in date
1862: )
1863: is
1864: --

Line 1939: (p_competence_id in per_competences.competence_id%TYPE

1935: -- Internal Table Handler Use Only.
1936: --
1937: --
1938: procedure chk_qa_organization
1939: (p_competence_id in per_competences.competence_id%TYPE
1940: ,p_qa_organization in per_competences.qa_organization%TYPE
1941: ,p_object_version_number in per_competences.object_version_number%TYPE
1942: ,p_effective_date in date
1943: )

Line 1940: ,p_qa_organization in per_competences.qa_organization%TYPE

1936: --
1937: --
1938: procedure chk_qa_organization
1939: (p_competence_id in per_competences.competence_id%TYPE
1940: ,p_qa_organization in per_competences.qa_organization%TYPE
1941: ,p_object_version_number in per_competences.object_version_number%TYPE
1942: ,p_effective_date in date
1943: )
1944: is

Line 1941: ,p_object_version_number in per_competences.object_version_number%TYPE

1937: --
1938: procedure chk_qa_organization
1939: (p_competence_id in per_competences.competence_id%TYPE
1940: ,p_qa_organization in per_competences.qa_organization%TYPE
1941: ,p_object_version_number in per_competences.object_version_number%TYPE
1942: ,p_effective_date in date
1943: )
1944: is
1945: --

Line 2079: ,p_descflex_name => 'PER_COMPETENCES'

2075: -- b) During insert.
2076: --
2077: hr_dflex_utility.ins_or_upd_descflex_attribs
2078: (p_appl_short_name => 'PER'
2079: ,p_descflex_name => 'PER_COMPETENCES'
2080: ,p_attribute_category => p_rec.attribute_category
2081: ,p_attribute1_name => 'ATTRIBUTE1'
2082: ,p_attribute1_value => p_rec.attribute1
2083: ,p_attribute2_name => 'ATTRIBUTE2'

Line 2747: per_competences pcp

2743: -- Bug #2536636 --Modified the cursor with outer join
2744: cursor csr_leg_code is
2745: select pbg.legislation_code, pcp.business_group_id
2746: from per_business_groups pbg,
2747: per_competences pcp
2748: where pcp.competence_id = p_competence_id
2749: and pbg.business_group_id(+) = pcp.business_group_id;
2750:
2751: l_proc varchar2(72) := g_package||'return_legislation_code';