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 338: (p_competence_id in per_competences.competence_id%TYPE

334: --
335: --
336: --
337: procedure chk_certification_required
338: (p_competence_id in per_competences.competence_id%TYPE
339: ,p_object_version_number in per_competences.object_version_number%TYPE
340: ,p_certification_required in per_competences.certification_required%TYPE
341: ,p_effective_date in date
342: )

Line 339: ,p_object_version_number in per_competences.object_version_number%TYPE

335: --
336: --
337: procedure chk_certification_required
338: (p_competence_id in per_competences.competence_id%TYPE
339: ,p_object_version_number in per_competences.object_version_number%TYPE
340: ,p_certification_required in per_competences.certification_required%TYPE
341: ,p_effective_date in date
342: )
343: is

Line 340: ,p_certification_required in per_competences.certification_required%TYPE

336: --
337: procedure chk_certification_required
338: (p_competence_id in per_competences.competence_id%TYPE
339: ,p_object_version_number in per_competences.object_version_number%TYPE
340: ,p_certification_required in per_competences.certification_required%TYPE
341: ,p_effective_date in date
342: )
343: is
344: --

Line 432: (p_competence_id in per_competences.competence_id%TYPE

428: -- Internal Table Handler Use Only.
429: --
430: --
431: procedure chk_evaluation_method
432: (p_competence_id in per_competences.competence_id%TYPE
433: ,p_object_version_number in per_competences.object_version_number%TYPE
434: ,p_evaluation_method in per_competences.evaluation_method%TYPE
435: ,p_effective_date in date
436: ,p_business_group_id in per_competences.business_group_id%TYPE default null

Line 433: ,p_object_version_number in per_competences.object_version_number%TYPE

429: --
430: --
431: procedure chk_evaluation_method
432: (p_competence_id in per_competences.competence_id%TYPE
433: ,p_object_version_number in per_competences.object_version_number%TYPE
434: ,p_evaluation_method in per_competences.evaluation_method%TYPE
435: ,p_effective_date in date
436: ,p_business_group_id in per_competences.business_group_id%TYPE default null
437: )

Line 434: ,p_evaluation_method in per_competences.evaluation_method%TYPE

430: --
431: procedure chk_evaluation_method
432: (p_competence_id in per_competences.competence_id%TYPE
433: ,p_object_version_number in per_competences.object_version_number%TYPE
434: ,p_evaluation_method in per_competences.evaluation_method%TYPE
435: ,p_effective_date in date
436: ,p_business_group_id in per_competences.business_group_id%TYPE default null
437: )
438: is

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

432: (p_competence_id in per_competences.competence_id%TYPE
433: ,p_object_version_number in per_competences.object_version_number%TYPE
434: ,p_evaluation_method in per_competences.evaluation_method%TYPE
435: ,p_effective_date in date
436: ,p_business_group_id in per_competences.business_group_id%TYPE default null
437: )
438: is
439: --
440: l_api_updating boolean;

Line 540: (p_competence_id in per_competences.competence_id%TYPE

536: -- Internal Table Handler Use Only.
537: --
538: --
539: procedure chk_renewal_period_units
540: (p_competence_id in per_competences.competence_id%TYPE
541: ,p_object_version_number in per_competences.object_version_number%TYPE
542: ,p_renewal_period_units in per_competences.renewal_period_units%TYPE
543: ,p_effective_date in date
544: )

Line 541: ,p_object_version_number in per_competences.object_version_number%TYPE

537: --
538: --
539: procedure chk_renewal_period_units
540: (p_competence_id in per_competences.competence_id%TYPE
541: ,p_object_version_number in per_competences.object_version_number%TYPE
542: ,p_renewal_period_units in per_competences.renewal_period_units%TYPE
543: ,p_effective_date in date
544: )
545: is

Line 542: ,p_renewal_period_units in per_competences.renewal_period_units%TYPE

538: --
539: procedure chk_renewal_period_units
540: (p_competence_id in per_competences.competence_id%TYPE
541: ,p_object_version_number in per_competences.object_version_number%TYPE
542: ,p_renewal_period_units in per_competences.renewal_period_units%TYPE
543: ,p_effective_date in date
544: )
545: is
546: --

Line 645: (p_competence_id in per_competences.competence_id%TYPE

641: -- Internal Table Handler Use Only.
642: --
643: --
644: procedure chk_renewable_unit_frequency
645: (p_competence_id in per_competences.competence_id%TYPE
646: ,p_object_version_number in per_competences.object_version_number%TYPE
647: ,p_renewal_period_units in per_competences.renewal_period_units%TYPE
648: ,p_renewal_period_frequency in per_competences.renewal_period_frequency%TYPE
649: )

Line 646: ,p_object_version_number in per_competences.object_version_number%TYPE

642: --
643: --
644: procedure chk_renewable_unit_frequency
645: (p_competence_id in per_competences.competence_id%TYPE
646: ,p_object_version_number in per_competences.object_version_number%TYPE
647: ,p_renewal_period_units in per_competences.renewal_period_units%TYPE
648: ,p_renewal_period_frequency in per_competences.renewal_period_frequency%TYPE
649: )
650: is

Line 647: ,p_renewal_period_units in per_competences.renewal_period_units%TYPE

643: --
644: procedure chk_renewable_unit_frequency
645: (p_competence_id in per_competences.competence_id%TYPE
646: ,p_object_version_number in per_competences.object_version_number%TYPE
647: ,p_renewal_period_units in per_competences.renewal_period_units%TYPE
648: ,p_renewal_period_frequency in per_competences.renewal_period_frequency%TYPE
649: )
650: is
651: --

Line 648: ,p_renewal_period_frequency in per_competences.renewal_period_frequency%TYPE

644: procedure chk_renewable_unit_frequency
645: (p_competence_id in per_competences.competence_id%TYPE
646: ,p_object_version_number in per_competences.object_version_number%TYPE
647: ,p_renewal_period_units in per_competences.renewal_period_units%TYPE
648: ,p_renewal_period_frequency in per_competences.renewal_period_frequency%TYPE
649: )
650: is
651: --
652: l_api_updating boolean;

Line 729: (p_competence_id in per_competences.competence_id%TYPE

725: -- Internal Table Handler Use Only.
726: --
727: --
728: procedure chk_rat_scale_bus_grp_exist
729: (p_competence_id in per_competences.competence_id%TYPE
730: ,p_object_version_number in per_competences.object_version_number%TYPE
731: ,p_rating_scale_id in per_rating_scales.rating_scale_id%TYPE
732: ,p_business_group_id in per_competences.business_group_id%TYPE default null
733: )

Line 730: ,p_object_version_number in per_competences.object_version_number%TYPE

726: --
727: --
728: procedure chk_rat_scale_bus_grp_exist
729: (p_competence_id in per_competences.competence_id%TYPE
730: ,p_object_version_number in per_competences.object_version_number%TYPE
731: ,p_rating_scale_id in per_rating_scales.rating_scale_id%TYPE
732: ,p_business_group_id in per_competences.business_group_id%TYPE default null
733: )
734: is

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

728: procedure chk_rat_scale_bus_grp_exist
729: (p_competence_id in per_competences.competence_id%TYPE
730: ,p_object_version_number in per_competences.object_version_number%TYPE
731: ,p_rating_scale_id in per_rating_scales.rating_scale_id%TYPE
732: ,p_business_group_id in per_competences.business_group_id%TYPE default null
733: )
734: is
735: --
736: l_exists varchar2(1);

Line 831: (p_competence_id in per_competences.competence_id%TYPE

827: -- Internal Table Handler Use Only.
828: --
829: --
830: procedure chk_rating_scale_type
831: (p_competence_id in per_competences.competence_id%TYPE
832: ,p_object_version_number in per_competences.object_version_number%TYPE
833: ,p_rating_scale_id in per_rating_scales.rating_scale_id%TYPE
834: )
835: is

Line 832: ,p_object_version_number in per_competences.object_version_number%TYPE

828: --
829: --
830: procedure chk_rating_scale_type
831: (p_competence_id in per_competences.competence_id%TYPE
832: ,p_object_version_number in per_competences.object_version_number%TYPE
833: ,p_rating_scale_id in per_rating_scales.rating_scale_id%TYPE
834: )
835: is
836: --

Line 919: (p_competence_id in per_competences.competence_id%TYPE

915: -- Internal Table Handler Use Only.
916: --
917: --
918: procedure chk_competence_has_prof
919: (p_competence_id in per_competences.competence_id%TYPE
920: ,p_object_version_number in per_competences.object_version_number%TYPE
921: ,p_rating_scale_id in per_rating_scales.rating_scale_id%TYPE
922: )
923: is

Line 920: ,p_object_version_number in per_competences.object_version_number%TYPE

916: --
917: --
918: procedure chk_competence_has_prof
919: (p_competence_id in per_competences.competence_id%TYPE
920: ,p_object_version_number in per_competences.object_version_number%TYPE
921: ,p_rating_scale_id in per_rating_scales.rating_scale_id%TYPE
922: )
923: is
924: --

Line 1006: (p_competence_id in per_competences.competence_id%TYPE

1002: -- Internal Table Handler Use Only.
1003: --
1004: --
1005: procedure chk_competence_rating_update
1006: (p_competence_id in per_competences.competence_id%TYPE
1007: ,p_object_version_number in per_competences.object_version_number%TYPE
1008: ,p_rating_scale_id in per_competences.rating_scale_id%TYPE
1009: )
1010: is

Line 1007: ,p_object_version_number in per_competences.object_version_number%TYPE

1003: --
1004: --
1005: procedure chk_competence_rating_update
1006: (p_competence_id in per_competences.competence_id%TYPE
1007: ,p_object_version_number in per_competences.object_version_number%TYPE
1008: ,p_rating_scale_id in per_competences.rating_scale_id%TYPE
1009: )
1010: is
1011: --

Line 1008: ,p_rating_scale_id in per_competences.rating_scale_id%TYPE

1004: --
1005: procedure chk_competence_rating_update
1006: (p_competence_id in per_competences.competence_id%TYPE
1007: ,p_object_version_number in per_competences.object_version_number%TYPE
1008: ,p_rating_scale_id in per_competences.rating_scale_id%TYPE
1009: )
1010: is
1011: --
1012: l_exists varchar2(1);

Line 1105: (p_competence_id in per_competences.competence_id%TYPE

1101: -- Internal Table Handler Use Only.
1102: --
1103: --
1104: procedure chk_competence_delete
1105: (p_competence_id in per_competences.competence_id%TYPE
1106: ,p_object_version_number in per_competences.object_version_number%TYPE
1107: )
1108: is
1109: --

Line 1106: ,p_object_version_number in per_competences.object_version_number%TYPE

1102: --
1103: --
1104: procedure chk_competence_delete
1105: (p_competence_id in per_competences.competence_id%TYPE
1106: ,p_object_version_number in per_competences.object_version_number%TYPE
1107: )
1108: is
1109: --
1110: l_exists varchar2(1);

Line 1263: (p_competence_id in per_competences.competence_id%TYPE

1259: -- Internal Table Handler Use Only.
1260: --
1261: --
1262: procedure chk_competence_cluster
1263: (p_competence_id in per_competences.competence_id%TYPE
1264: ,p_competence_cluster in per_competences.competence_cluster%TYPE
1265: ,p_object_version_number in per_competences.object_version_number%TYPE
1266: ,p_effective_date in date
1267: )

Line 1264: ,p_competence_cluster in per_competences.competence_cluster%TYPE

1260: --
1261: --
1262: procedure chk_competence_cluster
1263: (p_competence_id in per_competences.competence_id%TYPE
1264: ,p_competence_cluster in per_competences.competence_cluster%TYPE
1265: ,p_object_version_number in per_competences.object_version_number%TYPE
1266: ,p_effective_date in date
1267: )
1268: is

Line 1265: ,p_object_version_number in per_competences.object_version_number%TYPE

1261: --
1262: procedure chk_competence_cluster
1263: (p_competence_id in per_competences.competence_id%TYPE
1264: ,p_competence_cluster in per_competences.competence_cluster%TYPE
1265: ,p_object_version_number in per_competences.object_version_number%TYPE
1266: ,p_effective_date in date
1267: )
1268: is
1269: --

Line 1343: (p_competence_id in per_competences.competence_id%TYPE

1339: -- Internal Table Handler Use Only.
1340: --
1341: --
1342: procedure chk_unit_standard_id
1343: (p_competence_id in per_competences.competence_id%TYPE
1344: ,p_unit_standard_id in per_competences.unit_standard_id%TYPE
1345: ,p_business_group_id in per_competences.business_group_id%TYPE
1346: ,p_object_version_number in per_competences.object_version_number%TYPE
1347: ,p_effective_date in date

Line 1344: ,p_unit_standard_id in per_competences.unit_standard_id%TYPE

1340: --
1341: --
1342: procedure chk_unit_standard_id
1343: (p_competence_id in per_competences.competence_id%TYPE
1344: ,p_unit_standard_id in per_competences.unit_standard_id%TYPE
1345: ,p_business_group_id in per_competences.business_group_id%TYPE
1346: ,p_object_version_number in per_competences.object_version_number%TYPE
1347: ,p_effective_date in date
1348: )

Line 1345: ,p_business_group_id in per_competences.business_group_id%TYPE

1341: --
1342: procedure chk_unit_standard_id
1343: (p_competence_id in per_competences.competence_id%TYPE
1344: ,p_unit_standard_id in per_competences.unit_standard_id%TYPE
1345: ,p_business_group_id in per_competences.business_group_id%TYPE
1346: ,p_object_version_number in per_competences.object_version_number%TYPE
1347: ,p_effective_date in date
1348: )
1349: is

Line 1346: ,p_object_version_number in per_competences.object_version_number%TYPE

1342: procedure chk_unit_standard_id
1343: (p_competence_id in per_competences.competence_id%TYPE
1344: ,p_unit_standard_id in per_competences.unit_standard_id%TYPE
1345: ,p_business_group_id in per_competences.business_group_id%TYPE
1346: ,p_object_version_number in per_competences.object_version_number%TYPE
1347: ,p_effective_date in date
1348: )
1349: is
1350: --

Line 1355: select 1 from per_competences

1351: --
1352: -- declare cursor
1353: --
1354: cursor csr_local_unit_standard_id is
1355: select 1 from per_competences
1356: where unit_standard_id = p_unit_standard_id
1357: and business_group_id = p_business_group_id
1358: and p_effective_date between date_from and NVL(date_to, hr_api.g_eot);
1359: --

Line 1361: select 1 from per_competences

1357: and business_group_id = p_business_group_id
1358: and p_effective_date between date_from and NVL(date_to, hr_api.g_eot);
1359: --
1360: cursor csr_global_unit_standard_id is
1361: select 1 from per_competences
1362: where unit_standard_id = p_unit_standard_id
1363: and p_effective_date between date_from and NVL(date_to, hr_api.g_eot);
1364:
1365: l_proc varchar2(72) := g_package||'chk_unit_standard_id';

Line 1459: (p_competence_id in per_competences.competence_id%TYPE

1455: -- Internal Table Handler Use Only.
1456: --
1457: --
1458: procedure chk_credit_type
1459: (p_competence_id in per_competences.competence_id%TYPE
1460: ,p_credit_type in per_competences.credit_type%TYPE
1461: ,p_object_version_number in per_competences.object_version_number%TYPE
1462: ,p_effective_date in date
1463: )

Line 1460: ,p_credit_type in per_competences.credit_type%TYPE

1456: --
1457: --
1458: procedure chk_credit_type
1459: (p_competence_id in per_competences.competence_id%TYPE
1460: ,p_credit_type in per_competences.credit_type%TYPE
1461: ,p_object_version_number in per_competences.object_version_number%TYPE
1462: ,p_effective_date in date
1463: )
1464: is

Line 1461: ,p_object_version_number in per_competences.object_version_number%TYPE

1457: --
1458: procedure chk_credit_type
1459: (p_competence_id in per_competences.competence_id%TYPE
1460: ,p_credit_type in per_competences.credit_type%TYPE
1461: ,p_object_version_number in per_competences.object_version_number%TYPE
1462: ,p_effective_date in date
1463: )
1464: is
1465: --

Line 1540: (p_competence_id in per_competences.competence_id%TYPE

1536: -- Internal Table Handler Use Only.
1537: --
1538: --
1539: procedure chk_level_type
1540: (p_competence_id in per_competences.competence_id%TYPE
1541: ,p_level_type in per_competences.credit_type%TYPE
1542: ,p_object_version_number in per_competences.object_version_number%TYPE
1543: ,p_effective_date in date
1544: )

Line 1541: ,p_level_type in per_competences.credit_type%TYPE

1537: --
1538: --
1539: procedure chk_level_type
1540: (p_competence_id in per_competences.competence_id%TYPE
1541: ,p_level_type in per_competences.credit_type%TYPE
1542: ,p_object_version_number in per_competences.object_version_number%TYPE
1543: ,p_effective_date in date
1544: )
1545: is

Line 1542: ,p_object_version_number in per_competences.object_version_number%TYPE

1538: --
1539: procedure chk_level_type
1540: (p_competence_id in per_competences.competence_id%TYPE
1541: ,p_level_type in per_competences.credit_type%TYPE
1542: ,p_object_version_number in per_competences.object_version_number%TYPE
1543: ,p_effective_date in date
1544: )
1545: is
1546: --

Line 1621: (p_competence_id in per_competences.competence_id%TYPE

1617: -- Internal Table Handler Use Only.
1618: --
1619: --
1620: procedure chk_level_number
1621: (p_competence_id in per_competences.competence_id%TYPE
1622: ,p_level_number in per_competences.level_number%TYPE
1623: ,p_object_version_number in per_competences.object_version_number%TYPE
1624: ,p_effective_date in date
1625: )

Line 1622: ,p_level_number in per_competences.level_number%TYPE

1618: --
1619: --
1620: procedure chk_level_number
1621: (p_competence_id in per_competences.competence_id%TYPE
1622: ,p_level_number in per_competences.level_number%TYPE
1623: ,p_object_version_number in per_competences.object_version_number%TYPE
1624: ,p_effective_date in date
1625: )
1626: is

Line 1623: ,p_object_version_number in per_competences.object_version_number%TYPE

1619: --
1620: procedure chk_level_number
1621: (p_competence_id in per_competences.competence_id%TYPE
1622: ,p_level_number in per_competences.level_number%TYPE
1623: ,p_object_version_number in per_competences.object_version_number%TYPE
1624: ,p_effective_date in date
1625: )
1626: is
1627: --

Line 1702: (p_competence_id in per_competences.competence_id%TYPE

1698: -- Internal Table Handler Use Only.
1699: --
1700: --
1701: procedure chk_field
1702: (p_competence_id in per_competences.competence_id%TYPE
1703: ,p_field in per_competences.field%TYPE
1704: ,p_object_version_number in per_competences.object_version_number%TYPE
1705: ,p_effective_date in date
1706: )

Line 1703: ,p_field in per_competences.field%TYPE

1699: --
1700: --
1701: procedure chk_field
1702: (p_competence_id in per_competences.competence_id%TYPE
1703: ,p_field in per_competences.field%TYPE
1704: ,p_object_version_number in per_competences.object_version_number%TYPE
1705: ,p_effective_date in date
1706: )
1707: is

Line 1704: ,p_object_version_number in per_competences.object_version_number%TYPE

1700: --
1701: procedure chk_field
1702: (p_competence_id in per_competences.competence_id%TYPE
1703: ,p_field in per_competences.field%TYPE
1704: ,p_object_version_number in per_competences.object_version_number%TYPE
1705: ,p_effective_date in date
1706: )
1707: is
1708: --

Line 1783: (p_competence_id in per_competences.competence_id%TYPE

1779: -- Internal Table Handler Use Only.
1780: --
1781: --
1782: procedure chk_sub_field
1783: (p_competence_id in per_competences.competence_id%TYPE
1784: ,p_sub_field in per_competences.sub_field%TYPE
1785: ,p_object_version_number in per_competences.object_version_number%TYPE
1786: ,p_effective_date in date
1787: )

Line 1784: ,p_sub_field in per_competences.sub_field%TYPE

1780: --
1781: --
1782: procedure chk_sub_field
1783: (p_competence_id in per_competences.competence_id%TYPE
1784: ,p_sub_field in per_competences.sub_field%TYPE
1785: ,p_object_version_number in per_competences.object_version_number%TYPE
1786: ,p_effective_date in date
1787: )
1788: is

Line 1785: ,p_object_version_number in per_competences.object_version_number%TYPE

1781: --
1782: procedure chk_sub_field
1783: (p_competence_id in per_competences.competence_id%TYPE
1784: ,p_sub_field in per_competences.sub_field%TYPE
1785: ,p_object_version_number in per_competences.object_version_number%TYPE
1786: ,p_effective_date in date
1787: )
1788: is
1789: --

Line 1864: (p_competence_id in per_competences.competence_id%TYPE

1860: -- Internal Table Handler Use Only.
1861: --
1862: --
1863: procedure chk_provider
1864: (p_competence_id in per_competences.competence_id%TYPE
1865: ,p_provider in per_competences.provider%TYPE
1866: ,p_object_version_number in per_competences.object_version_number%TYPE
1867: ,p_effective_date in date
1868: )

Line 1865: ,p_provider in per_competences.provider%TYPE

1861: --
1862: --
1863: procedure chk_provider
1864: (p_competence_id in per_competences.competence_id%TYPE
1865: ,p_provider in per_competences.provider%TYPE
1866: ,p_object_version_number in per_competences.object_version_number%TYPE
1867: ,p_effective_date in date
1868: )
1869: is

Line 1866: ,p_object_version_number in per_competences.object_version_number%TYPE

1862: --
1863: procedure chk_provider
1864: (p_competence_id in per_competences.competence_id%TYPE
1865: ,p_provider in per_competences.provider%TYPE
1866: ,p_object_version_number in per_competences.object_version_number%TYPE
1867: ,p_effective_date in date
1868: )
1869: is
1870: --

Line 1945: (p_competence_id in per_competences.competence_id%TYPE

1941: -- Internal Table Handler Use Only.
1942: --
1943: --
1944: procedure chk_qa_organization
1945: (p_competence_id in per_competences.competence_id%TYPE
1946: ,p_qa_organization in per_competences.qa_organization%TYPE
1947: ,p_object_version_number in per_competences.object_version_number%TYPE
1948: ,p_effective_date in date
1949: )

Line 1946: ,p_qa_organization in per_competences.qa_organization%TYPE

1942: --
1943: --
1944: procedure chk_qa_organization
1945: (p_competence_id in per_competences.competence_id%TYPE
1946: ,p_qa_organization in per_competences.qa_organization%TYPE
1947: ,p_object_version_number in per_competences.object_version_number%TYPE
1948: ,p_effective_date in date
1949: )
1950: is

Line 1947: ,p_object_version_number in per_competences.object_version_number%TYPE

1943: --
1944: procedure chk_qa_organization
1945: (p_competence_id in per_competences.competence_id%TYPE
1946: ,p_qa_organization in per_competences.qa_organization%TYPE
1947: ,p_object_version_number in per_competences.object_version_number%TYPE
1948: ,p_effective_date in date
1949: )
1950: is
1951: --

Line 2085: ,p_descflex_name => 'PER_COMPETENCES'

2081: -- b) During insert.
2082: --
2083: hr_dflex_utility.ins_or_upd_descflex_attribs
2084: (p_appl_short_name => 'PER'
2085: ,p_descflex_name => 'PER_COMPETENCES'
2086: ,p_attribute_category => p_rec.attribute_category
2087: ,p_attribute1_name => 'ATTRIBUTE1'
2088: ,p_attribute1_value => p_rec.attribute1
2089: ,p_attribute2_name => 'ATTRIBUTE2'

Line 2753: per_competences pcp

2749: -- Bug #2536636 --Modified the cursor with outer join
2750: cursor csr_leg_code is
2751: select pbg.legislation_code, pcp.business_group_id
2752: from per_business_groups pbg,
2753: per_competences pcp
2754: where pcp.competence_id = p_competence_id
2755: and pbg.business_group_id(+) = pcp.business_group_id;
2756:
2757: l_proc varchar2(72) := g_package||'return_legislation_code';