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.HR_COMPETENCE_ELEMENT_SWI dependencies on HR_TRANSACTION_SWI

Line 1292: l_object_version_number := hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectVersionNumber');

1288: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
1289:
1290: l_commitElement := xmldom.makeElement(l_CommitNode);
1291: l_postState := xmldom.getAttribute(l_commitElement, 'PS');
1292: l_object_version_number := hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectVersionNumber');
1293: --
1294: if p_effective_date is null
1295: then
1296: --

Line 1309: ,p_competence_element_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceElementId',null)

1305: if l_postState = '0' then
1306:
1307: create_competence_element
1308: ( p_validate => p_validate
1309: ,p_competence_element_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceElementId',null)
1310: ,p_object_version_number => l_object_version_number
1311: ,p_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Type',null)
1312: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',null)
1313: ,p_enterprise_id => hr_transaction_swi.getNumberValue(l_CommitNode,'EnterpriseId',null)

Line 1311: ,p_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Type',null)

1307: create_competence_element
1308: ( p_validate => p_validate
1309: ,p_competence_element_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceElementId',null)
1310: ,p_object_version_number => l_object_version_number
1311: ,p_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Type',null)
1312: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',null)
1313: ,p_enterprise_id => hr_transaction_swi.getNumberValue(l_CommitNode,'EnterpriseId',null)
1314: ,p_competence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceId',null)
1315: ,p_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ProficiencyLevelId',null)

Line 1312: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',null)

1308: ( p_validate => p_validate
1309: ,p_competence_element_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceElementId',null)
1310: ,p_object_version_number => l_object_version_number
1311: ,p_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Type',null)
1312: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',null)
1313: ,p_enterprise_id => hr_transaction_swi.getNumberValue(l_CommitNode,'EnterpriseId',null)
1314: ,p_competence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceId',null)
1315: ,p_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ProficiencyLevelId',null)
1316: ,p_high_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'HighProficiencyLevelId',null)

Line 1313: ,p_enterprise_id => hr_transaction_swi.getNumberValue(l_CommitNode,'EnterpriseId',null)

1309: ,p_competence_element_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceElementId',null)
1310: ,p_object_version_number => l_object_version_number
1311: ,p_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Type',null)
1312: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',null)
1313: ,p_enterprise_id => hr_transaction_swi.getNumberValue(l_CommitNode,'EnterpriseId',null)
1314: ,p_competence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceId',null)
1315: ,p_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ProficiencyLevelId',null)
1316: ,p_high_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'HighProficiencyLevelId',null)
1317: ,p_weighting_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'WeightingLevelId',null)

Line 1314: ,p_competence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceId',null)

1310: ,p_object_version_number => l_object_version_number
1311: ,p_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Type',null)
1312: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',null)
1313: ,p_enterprise_id => hr_transaction_swi.getNumberValue(l_CommitNode,'EnterpriseId',null)
1314: ,p_competence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceId',null)
1315: ,p_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ProficiencyLevelId',null)
1316: ,p_high_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'HighProficiencyLevelId',null)
1317: ,p_weighting_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'WeightingLevelId',null)
1318: ,p_rating_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RatingLevelId',null)

Line 1315: ,p_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ProficiencyLevelId',null)

1311: ,p_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Type',null)
1312: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',null)
1313: ,p_enterprise_id => hr_transaction_swi.getNumberValue(l_CommitNode,'EnterpriseId',null)
1314: ,p_competence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceId',null)
1315: ,p_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ProficiencyLevelId',null)
1316: ,p_high_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'HighProficiencyLevelId',null)
1317: ,p_weighting_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'WeightingLevelId',null)
1318: ,p_rating_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RatingLevelId',null)
1319: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId',null)

Line 1316: ,p_high_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'HighProficiencyLevelId',null)

1312: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',null)
1313: ,p_enterprise_id => hr_transaction_swi.getNumberValue(l_CommitNode,'EnterpriseId',null)
1314: ,p_competence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceId',null)
1315: ,p_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ProficiencyLevelId',null)
1316: ,p_high_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'HighProficiencyLevelId',null)
1317: ,p_weighting_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'WeightingLevelId',null)
1318: ,p_rating_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RatingLevelId',null)
1319: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId',null)
1320: ,p_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId',null)

Line 1317: ,p_weighting_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'WeightingLevelId',null)

1313: ,p_enterprise_id => hr_transaction_swi.getNumberValue(l_CommitNode,'EnterpriseId',null)
1314: ,p_competence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceId',null)
1315: ,p_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ProficiencyLevelId',null)
1316: ,p_high_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'HighProficiencyLevelId',null)
1317: ,p_weighting_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'WeightingLevelId',null)
1318: ,p_rating_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RatingLevelId',null)
1319: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId',null)
1320: ,p_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId',null)
1321: ,p_valid_grade_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ValidGradeId',null)

Line 1318: ,p_rating_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RatingLevelId',null)

1314: ,p_competence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceId',null)
1315: ,p_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ProficiencyLevelId',null)
1316: ,p_high_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'HighProficiencyLevelId',null)
1317: ,p_weighting_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'WeightingLevelId',null)
1318: ,p_rating_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RatingLevelId',null)
1319: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId',null)
1320: ,p_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId',null)
1321: ,p_valid_grade_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ValidGradeId',null)
1322: ,p_position_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PositionId',null)

Line 1319: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId',null)

1315: ,p_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ProficiencyLevelId',null)
1316: ,p_high_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'HighProficiencyLevelId',null)
1317: ,p_weighting_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'WeightingLevelId',null)
1318: ,p_rating_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RatingLevelId',null)
1319: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId',null)
1320: ,p_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId',null)
1321: ,p_valid_grade_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ValidGradeId',null)
1322: ,p_position_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PositionId',null)
1323: ,p_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OrganizationId',null)

Line 1320: ,p_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId',null)

1316: ,p_high_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'HighProficiencyLevelId',null)
1317: ,p_weighting_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'WeightingLevelId',null)
1318: ,p_rating_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RatingLevelId',null)
1319: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId',null)
1320: ,p_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId',null)
1321: ,p_valid_grade_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ValidGradeId',null)
1322: ,p_position_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PositionId',null)
1323: ,p_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OrganizationId',null)
1324: ,p_parent_competence_element_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ParentCompetenceElementId',null)

Line 1321: ,p_valid_grade_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ValidGradeId',null)

1317: ,p_weighting_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'WeightingLevelId',null)
1318: ,p_rating_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RatingLevelId',null)
1319: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId',null)
1320: ,p_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId',null)
1321: ,p_valid_grade_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ValidGradeId',null)
1322: ,p_position_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PositionId',null)
1323: ,p_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OrganizationId',null)
1324: ,p_parent_competence_element_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ParentCompetenceElementId',null)
1325: ,p_activity_version_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ActivityVersionId',null)

Line 1322: ,p_position_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PositionId',null)

1318: ,p_rating_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RatingLevelId',null)
1319: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId',null)
1320: ,p_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId',null)
1321: ,p_valid_grade_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ValidGradeId',null)
1322: ,p_position_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PositionId',null)
1323: ,p_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OrganizationId',null)
1324: ,p_parent_competence_element_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ParentCompetenceElementId',null)
1325: ,p_activity_version_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ActivityVersionId',null)
1326: ,p_assessment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssessmentId',null)

Line 1323: ,p_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OrganizationId',null)

1319: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId',null)
1320: ,p_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId',null)
1321: ,p_valid_grade_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ValidGradeId',null)
1322: ,p_position_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PositionId',null)
1323: ,p_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OrganizationId',null)
1324: ,p_parent_competence_element_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ParentCompetenceElementId',null)
1325: ,p_activity_version_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ActivityVersionId',null)
1326: ,p_assessment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssessmentId',null)
1327: ,p_assessment_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssessmentTypeId',null)

Line 1324: ,p_parent_competence_element_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ParentCompetenceElementId',null)

1320: ,p_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId',null)
1321: ,p_valid_grade_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ValidGradeId',null)
1322: ,p_position_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PositionId',null)
1323: ,p_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OrganizationId',null)
1324: ,p_parent_competence_element_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ParentCompetenceElementId',null)
1325: ,p_activity_version_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ActivityVersionId',null)
1326: ,p_assessment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssessmentId',null)
1327: ,p_assessment_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssessmentTypeId',null)
1328: ,p_mandatory => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Mandatory',null)

Line 1325: ,p_activity_version_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ActivityVersionId',null)

1321: ,p_valid_grade_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ValidGradeId',null)
1322: ,p_position_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PositionId',null)
1323: ,p_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OrganizationId',null)
1324: ,p_parent_competence_element_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ParentCompetenceElementId',null)
1325: ,p_activity_version_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ActivityVersionId',null)
1326: ,p_assessment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssessmentId',null)
1327: ,p_assessment_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssessmentTypeId',null)
1328: ,p_mandatory => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Mandatory',null)
1329: ,p_effective_date_from => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateFrom',null)

Line 1326: ,p_assessment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssessmentId',null)

1322: ,p_position_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PositionId',null)
1323: ,p_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OrganizationId',null)
1324: ,p_parent_competence_element_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ParentCompetenceElementId',null)
1325: ,p_activity_version_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ActivityVersionId',null)
1326: ,p_assessment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssessmentId',null)
1327: ,p_assessment_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssessmentTypeId',null)
1328: ,p_mandatory => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Mandatory',null)
1329: ,p_effective_date_from => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateFrom',null)
1330: ,p_effective_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateTo',null)

Line 1327: ,p_assessment_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssessmentTypeId',null)

1323: ,p_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OrganizationId',null)
1324: ,p_parent_competence_element_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ParentCompetenceElementId',null)
1325: ,p_activity_version_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ActivityVersionId',null)
1326: ,p_assessment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssessmentId',null)
1327: ,p_assessment_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssessmentTypeId',null)
1328: ,p_mandatory => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Mandatory',null)
1329: ,p_effective_date_from => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateFrom',null)
1330: ,p_effective_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateTo',null)
1331: ,p_group_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'GroupCompetenceType',null)

Line 1328: ,p_mandatory => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Mandatory',null)

1324: ,p_parent_competence_element_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ParentCompetenceElementId',null)
1325: ,p_activity_version_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ActivityVersionId',null)
1326: ,p_assessment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssessmentId',null)
1327: ,p_assessment_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssessmentTypeId',null)
1328: ,p_mandatory => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Mandatory',null)
1329: ,p_effective_date_from => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateFrom',null)
1330: ,p_effective_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateTo',null)
1331: ,p_group_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'GroupCompetenceType',null)
1332: ,p_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CompetenceType',null)

Line 1329: ,p_effective_date_from => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateFrom',null)

1325: ,p_activity_version_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ActivityVersionId',null)
1326: ,p_assessment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssessmentId',null)
1327: ,p_assessment_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssessmentTypeId',null)
1328: ,p_mandatory => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Mandatory',null)
1329: ,p_effective_date_from => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateFrom',null)
1330: ,p_effective_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateTo',null)
1331: ,p_group_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'GroupCompetenceType',null)
1332: ,p_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CompetenceType',null)
1333: ,p_normal_elapse_duration => hr_transaction_swi.getNumberValue(l_CommitNode,'NormalElapseDuration',null)

Line 1330: ,p_effective_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateTo',null)

1326: ,p_assessment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssessmentId',null)
1327: ,p_assessment_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssessmentTypeId',null)
1328: ,p_mandatory => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Mandatory',null)
1329: ,p_effective_date_from => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateFrom',null)
1330: ,p_effective_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateTo',null)
1331: ,p_group_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'GroupCompetenceType',null)
1332: ,p_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CompetenceType',null)
1333: ,p_normal_elapse_duration => hr_transaction_swi.getNumberValue(l_CommitNode,'NormalElapseDuration',null)
1334: ,p_normal_elapse_duration_unit => hr_transaction_swi.getVarchar2Value(l_CommitNode,'NormalElapseDurationUnit',null)

Line 1331: ,p_group_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'GroupCompetenceType',null)

1327: ,p_assessment_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssessmentTypeId',null)
1328: ,p_mandatory => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Mandatory',null)
1329: ,p_effective_date_from => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateFrom',null)
1330: ,p_effective_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateTo',null)
1331: ,p_group_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'GroupCompetenceType',null)
1332: ,p_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CompetenceType',null)
1333: ,p_normal_elapse_duration => hr_transaction_swi.getNumberValue(l_CommitNode,'NormalElapseDuration',null)
1334: ,p_normal_elapse_duration_unit => hr_transaction_swi.getVarchar2Value(l_CommitNode,'NormalElapseDurationUnit',null)
1335: ,p_sequence_number => hr_transaction_swi.getNumberValue(l_CommitNode,'SequenceNumber',null)

Line 1332: ,p_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CompetenceType',null)

1328: ,p_mandatory => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Mandatory',null)
1329: ,p_effective_date_from => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateFrom',null)
1330: ,p_effective_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateTo',null)
1331: ,p_group_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'GroupCompetenceType',null)
1332: ,p_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CompetenceType',null)
1333: ,p_normal_elapse_duration => hr_transaction_swi.getNumberValue(l_CommitNode,'NormalElapseDuration',null)
1334: ,p_normal_elapse_duration_unit => hr_transaction_swi.getVarchar2Value(l_CommitNode,'NormalElapseDurationUnit',null)
1335: ,p_sequence_number => hr_transaction_swi.getNumberValue(l_CommitNode,'SequenceNumber',null)
1336: ,p_source_of_proficiency_level => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SourceOfProficiencyLevel',null)

Line 1333: ,p_normal_elapse_duration => hr_transaction_swi.getNumberValue(l_CommitNode,'NormalElapseDuration',null)

1329: ,p_effective_date_from => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateFrom',null)
1330: ,p_effective_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateTo',null)
1331: ,p_group_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'GroupCompetenceType',null)
1332: ,p_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CompetenceType',null)
1333: ,p_normal_elapse_duration => hr_transaction_swi.getNumberValue(l_CommitNode,'NormalElapseDuration',null)
1334: ,p_normal_elapse_duration_unit => hr_transaction_swi.getVarchar2Value(l_CommitNode,'NormalElapseDurationUnit',null)
1335: ,p_sequence_number => hr_transaction_swi.getNumberValue(l_CommitNode,'SequenceNumber',null)
1336: ,p_source_of_proficiency_level => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SourceOfProficiencyLevel',null)
1337: ,p_line_score => hr_transaction_swi.getNumberValue(l_CommitNode,'LineScore',null)

Line 1334: ,p_normal_elapse_duration_unit => hr_transaction_swi.getVarchar2Value(l_CommitNode,'NormalElapseDurationUnit',null)

1330: ,p_effective_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateTo',null)
1331: ,p_group_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'GroupCompetenceType',null)
1332: ,p_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CompetenceType',null)
1333: ,p_normal_elapse_duration => hr_transaction_swi.getNumberValue(l_CommitNode,'NormalElapseDuration',null)
1334: ,p_normal_elapse_duration_unit => hr_transaction_swi.getVarchar2Value(l_CommitNode,'NormalElapseDurationUnit',null)
1335: ,p_sequence_number => hr_transaction_swi.getNumberValue(l_CommitNode,'SequenceNumber',null)
1336: ,p_source_of_proficiency_level => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SourceOfProficiencyLevel',null)
1337: ,p_line_score => hr_transaction_swi.getNumberValue(l_CommitNode,'LineScore',null)
1338: ,p_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'CertificationDate',null)

Line 1335: ,p_sequence_number => hr_transaction_swi.getNumberValue(l_CommitNode,'SequenceNumber',null)

1331: ,p_group_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'GroupCompetenceType',null)
1332: ,p_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CompetenceType',null)
1333: ,p_normal_elapse_duration => hr_transaction_swi.getNumberValue(l_CommitNode,'NormalElapseDuration',null)
1334: ,p_normal_elapse_duration_unit => hr_transaction_swi.getVarchar2Value(l_CommitNode,'NormalElapseDurationUnit',null)
1335: ,p_sequence_number => hr_transaction_swi.getNumberValue(l_CommitNode,'SequenceNumber',null)
1336: ,p_source_of_proficiency_level => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SourceOfProficiencyLevel',null)
1337: ,p_line_score => hr_transaction_swi.getNumberValue(l_CommitNode,'LineScore',null)
1338: ,p_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'CertificationDate',null)
1339: ,p_certification_method => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CertificationMethod',null)

Line 1336: ,p_source_of_proficiency_level => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SourceOfProficiencyLevel',null)

1332: ,p_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CompetenceType',null)
1333: ,p_normal_elapse_duration => hr_transaction_swi.getNumberValue(l_CommitNode,'NormalElapseDuration',null)
1334: ,p_normal_elapse_duration_unit => hr_transaction_swi.getVarchar2Value(l_CommitNode,'NormalElapseDurationUnit',null)
1335: ,p_sequence_number => hr_transaction_swi.getNumberValue(l_CommitNode,'SequenceNumber',null)
1336: ,p_source_of_proficiency_level => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SourceOfProficiencyLevel',null)
1337: ,p_line_score => hr_transaction_swi.getNumberValue(l_CommitNode,'LineScore',null)
1338: ,p_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'CertificationDate',null)
1339: ,p_certification_method => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CertificationMethod',null)
1340: ,p_next_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextCertificationDate',null)

Line 1337: ,p_line_score => hr_transaction_swi.getNumberValue(l_CommitNode,'LineScore',null)

1333: ,p_normal_elapse_duration => hr_transaction_swi.getNumberValue(l_CommitNode,'NormalElapseDuration',null)
1334: ,p_normal_elapse_duration_unit => hr_transaction_swi.getVarchar2Value(l_CommitNode,'NormalElapseDurationUnit',null)
1335: ,p_sequence_number => hr_transaction_swi.getNumberValue(l_CommitNode,'SequenceNumber',null)
1336: ,p_source_of_proficiency_level => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SourceOfProficiencyLevel',null)
1337: ,p_line_score => hr_transaction_swi.getNumberValue(l_CommitNode,'LineScore',null)
1338: ,p_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'CertificationDate',null)
1339: ,p_certification_method => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CertificationMethod',null)
1340: ,p_next_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextCertificationDate',null)
1341: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)

Line 1338: ,p_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'CertificationDate',null)

1334: ,p_normal_elapse_duration_unit => hr_transaction_swi.getVarchar2Value(l_CommitNode,'NormalElapseDurationUnit',null)
1335: ,p_sequence_number => hr_transaction_swi.getNumberValue(l_CommitNode,'SequenceNumber',null)
1336: ,p_source_of_proficiency_level => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SourceOfProficiencyLevel',null)
1337: ,p_line_score => hr_transaction_swi.getNumberValue(l_CommitNode,'LineScore',null)
1338: ,p_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'CertificationDate',null)
1339: ,p_certification_method => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CertificationMethod',null)
1340: ,p_next_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextCertificationDate',null)
1341: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
1342: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)

Line 1339: ,p_certification_method => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CertificationMethod',null)

1335: ,p_sequence_number => hr_transaction_swi.getNumberValue(l_CommitNode,'SequenceNumber',null)
1336: ,p_source_of_proficiency_level => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SourceOfProficiencyLevel',null)
1337: ,p_line_score => hr_transaction_swi.getNumberValue(l_CommitNode,'LineScore',null)
1338: ,p_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'CertificationDate',null)
1339: ,p_certification_method => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CertificationMethod',null)
1340: ,p_next_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextCertificationDate',null)
1341: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
1342: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
1343: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)

Line 1340: ,p_next_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextCertificationDate',null)

1336: ,p_source_of_proficiency_level => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SourceOfProficiencyLevel',null)
1337: ,p_line_score => hr_transaction_swi.getNumberValue(l_CommitNode,'LineScore',null)
1338: ,p_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'CertificationDate',null)
1339: ,p_certification_method => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CertificationMethod',null)
1340: ,p_next_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextCertificationDate',null)
1341: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
1342: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
1343: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
1344: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)

Line 1341: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)

1337: ,p_line_score => hr_transaction_swi.getNumberValue(l_CommitNode,'LineScore',null)
1338: ,p_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'CertificationDate',null)
1339: ,p_certification_method => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CertificationMethod',null)
1340: ,p_next_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextCertificationDate',null)
1341: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
1342: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
1343: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
1344: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
1345: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)

Line 1342: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)

1338: ,p_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'CertificationDate',null)
1339: ,p_certification_method => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CertificationMethod',null)
1340: ,p_next_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextCertificationDate',null)
1341: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
1342: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
1343: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
1344: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
1345: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
1346: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)

Line 1343: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)

1339: ,p_certification_method => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CertificationMethod',null)
1340: ,p_next_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextCertificationDate',null)
1341: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
1342: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
1343: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
1344: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
1345: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
1346: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
1347: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)

Line 1344: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)

1340: ,p_next_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextCertificationDate',null)
1341: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
1342: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
1343: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
1344: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
1345: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
1346: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
1347: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
1348: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)

Line 1345: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)

1341: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
1342: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
1343: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
1344: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
1345: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
1346: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
1347: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
1348: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
1349: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)

Line 1346: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)

1342: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
1343: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
1344: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
1345: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
1346: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
1347: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
1348: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
1349: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
1350: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)

Line 1347: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)

1343: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
1344: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
1345: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
1346: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
1347: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
1348: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
1349: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
1350: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
1351: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)

Line 1348: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)

1344: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
1345: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
1346: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
1347: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
1348: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
1349: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
1350: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
1351: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
1352: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)

Line 1349: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)

1345: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
1346: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
1347: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
1348: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
1349: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
1350: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
1351: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
1352: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
1353: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)

Line 1350: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)

1346: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
1347: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
1348: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
1349: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
1350: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
1351: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
1352: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
1353: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
1354: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)

Line 1351: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)

1347: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
1348: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
1349: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
1350: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
1351: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
1352: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
1353: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
1354: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
1355: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)

Line 1352: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)

1348: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
1349: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
1350: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
1351: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
1352: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
1353: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
1354: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
1355: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
1356: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)

Line 1353: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)

1349: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
1350: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
1351: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
1352: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
1353: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
1354: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
1355: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
1356: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
1357: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)

Line 1354: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)

1350: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
1351: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
1352: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
1353: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
1354: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
1355: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
1356: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
1357: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
1358: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)

Line 1355: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)

1351: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
1352: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
1353: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
1354: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
1355: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
1356: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
1357: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
1358: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
1359: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)

Line 1356: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)

1352: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
1353: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
1354: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
1355: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
1356: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
1357: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
1358: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
1359: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
1360: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)

Line 1357: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)

1353: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
1354: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
1355: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
1356: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
1357: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
1358: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
1359: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
1360: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
1361: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)

Line 1358: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)

1354: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
1355: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
1356: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
1357: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
1358: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
1359: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
1360: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
1361: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
1362: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)

Line 1359: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)

1355: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
1356: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
1357: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
1358: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
1359: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
1360: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
1361: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
1362: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
1363: ,p_effective_date => l_effective_date

Line 1360: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)

1356: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
1357: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
1358: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
1359: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
1360: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
1361: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
1362: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
1363: ,p_effective_date => l_effective_date
1364: ,p_object_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectId',null)

Line 1361: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)

1357: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
1358: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
1359: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
1360: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
1361: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
1362: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
1363: ,p_effective_date => l_effective_date
1364: ,p_object_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectId',null)
1365: ,p_object_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ObjectName',null)

Line 1362: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)

1358: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
1359: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
1360: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
1361: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
1362: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
1363: ,p_effective_date => l_effective_date
1364: ,p_object_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectId',null)
1365: ,p_object_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ObjectName',null)
1366: ,p_party_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PartyId',null)

Line 1364: ,p_object_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectId',null)

1360: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
1361: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
1362: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
1363: ,p_effective_date => l_effective_date
1364: ,p_object_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectId',null)
1365: ,p_object_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ObjectName',null)
1366: ,p_party_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PartyId',null)
1367: ,p_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status',null)
1368: ,p_return_status => l_return_status

Line 1365: ,p_object_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ObjectName',null)

1361: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
1362: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
1363: ,p_effective_date => l_effective_date
1364: ,p_object_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectId',null)
1365: ,p_object_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ObjectName',null)
1366: ,p_party_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PartyId',null)
1367: ,p_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status',null)
1368: ,p_return_status => l_return_status
1369: );

Line 1366: ,p_party_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PartyId',null)

1362: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
1363: ,p_effective_date => l_effective_date
1364: ,p_object_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectId',null)
1365: ,p_object_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ObjectName',null)
1366: ,p_party_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PartyId',null)
1367: ,p_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status',null)
1368: ,p_return_status => l_return_status
1369: );
1370:

Line 1367: ,p_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status',null)

1363: ,p_effective_date => l_effective_date
1364: ,p_object_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectId',null)
1365: ,p_object_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ObjectName',null)
1366: ,p_party_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PartyId',null)
1367: ,p_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status',null)
1368: ,p_return_status => l_return_status
1369: );
1370:
1371: elsif l_postState = '2' then

Line 1375: (p_competence_element_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceElementId')

1371: elsif l_postState = '2' then
1372:
1373:
1374: update_competence_element
1375: (p_competence_element_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceElementId')
1376: ,p_object_version_number => l_object_version_number
1377: ,p_competence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceId')
1378: ,p_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ProficiencyLevelId')
1379: ,p_high_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'HighProficiencyLevelId')

Line 1377: ,p_competence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceId')

1373:
1374: update_competence_element
1375: (p_competence_element_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceElementId')
1376: ,p_object_version_number => l_object_version_number
1377: ,p_competence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceId')
1378: ,p_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ProficiencyLevelId')
1379: ,p_high_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'HighProficiencyLevelId')
1380: ,p_weighting_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'WeightingLevelId')
1381: ,p_rating_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RatingLevelId')

Line 1378: ,p_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ProficiencyLevelId')

1374: update_competence_element
1375: (p_competence_element_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceElementId')
1376: ,p_object_version_number => l_object_version_number
1377: ,p_competence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceId')
1378: ,p_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ProficiencyLevelId')
1379: ,p_high_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'HighProficiencyLevelId')
1380: ,p_weighting_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'WeightingLevelId')
1381: ,p_rating_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RatingLevelId')
1382: ,p_mandatory => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Mandatory')

Line 1379: ,p_high_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'HighProficiencyLevelId')

1375: (p_competence_element_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceElementId')
1376: ,p_object_version_number => l_object_version_number
1377: ,p_competence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceId')
1378: ,p_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ProficiencyLevelId')
1379: ,p_high_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'HighProficiencyLevelId')
1380: ,p_weighting_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'WeightingLevelId')
1381: ,p_rating_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RatingLevelId')
1382: ,p_mandatory => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Mandatory')
1383: ,p_effective_date_from => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateFrom')

Line 1380: ,p_weighting_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'WeightingLevelId')

1376: ,p_object_version_number => l_object_version_number
1377: ,p_competence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceId')
1378: ,p_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ProficiencyLevelId')
1379: ,p_high_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'HighProficiencyLevelId')
1380: ,p_weighting_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'WeightingLevelId')
1381: ,p_rating_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RatingLevelId')
1382: ,p_mandatory => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Mandatory')
1383: ,p_effective_date_from => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateFrom')
1384: ,p_effective_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateTo')

Line 1381: ,p_rating_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RatingLevelId')

1377: ,p_competence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceId')
1378: ,p_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ProficiencyLevelId')
1379: ,p_high_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'HighProficiencyLevelId')
1380: ,p_weighting_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'WeightingLevelId')
1381: ,p_rating_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RatingLevelId')
1382: ,p_mandatory => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Mandatory')
1383: ,p_effective_date_from => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateFrom')
1384: ,p_effective_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateTo')
1385: ,p_group_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'GroupCompetenceType')

Line 1382: ,p_mandatory => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Mandatory')

1378: ,p_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ProficiencyLevelId')
1379: ,p_high_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'HighProficiencyLevelId')
1380: ,p_weighting_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'WeightingLevelId')
1381: ,p_rating_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RatingLevelId')
1382: ,p_mandatory => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Mandatory')
1383: ,p_effective_date_from => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateFrom')
1384: ,p_effective_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateTo')
1385: ,p_group_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'GroupCompetenceType')
1386: ,p_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CompetenceType')

Line 1383: ,p_effective_date_from => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateFrom')

1379: ,p_high_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'HighProficiencyLevelId')
1380: ,p_weighting_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'WeightingLevelId')
1381: ,p_rating_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RatingLevelId')
1382: ,p_mandatory => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Mandatory')
1383: ,p_effective_date_from => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateFrom')
1384: ,p_effective_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateTo')
1385: ,p_group_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'GroupCompetenceType')
1386: ,p_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CompetenceType')
1387: ,p_normal_elapse_duration => hr_transaction_swi.getNumberValue(l_CommitNode,'NormalElapseDuration')

Line 1384: ,p_effective_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateTo')

1380: ,p_weighting_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'WeightingLevelId')
1381: ,p_rating_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RatingLevelId')
1382: ,p_mandatory => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Mandatory')
1383: ,p_effective_date_from => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateFrom')
1384: ,p_effective_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateTo')
1385: ,p_group_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'GroupCompetenceType')
1386: ,p_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CompetenceType')
1387: ,p_normal_elapse_duration => hr_transaction_swi.getNumberValue(l_CommitNode,'NormalElapseDuration')
1388: ,p_normal_elapse_duration_unit => hr_transaction_swi.getVarchar2Value(l_CommitNode,'NormalElapseDurationUnit')

Line 1385: ,p_group_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'GroupCompetenceType')

1381: ,p_rating_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RatingLevelId')
1382: ,p_mandatory => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Mandatory')
1383: ,p_effective_date_from => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateFrom')
1384: ,p_effective_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateTo')
1385: ,p_group_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'GroupCompetenceType')
1386: ,p_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CompetenceType')
1387: ,p_normal_elapse_duration => hr_transaction_swi.getNumberValue(l_CommitNode,'NormalElapseDuration')
1388: ,p_normal_elapse_duration_unit => hr_transaction_swi.getVarchar2Value(l_CommitNode,'NormalElapseDurationUnit')
1389: ,p_sequence_number => hr_transaction_swi.getNumberValue(l_CommitNode,'SequenceNumber')

Line 1386: ,p_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CompetenceType')

1382: ,p_mandatory => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Mandatory')
1383: ,p_effective_date_from => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateFrom')
1384: ,p_effective_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateTo')
1385: ,p_group_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'GroupCompetenceType')
1386: ,p_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CompetenceType')
1387: ,p_normal_elapse_duration => hr_transaction_swi.getNumberValue(l_CommitNode,'NormalElapseDuration')
1388: ,p_normal_elapse_duration_unit => hr_transaction_swi.getVarchar2Value(l_CommitNode,'NormalElapseDurationUnit')
1389: ,p_sequence_number => hr_transaction_swi.getNumberValue(l_CommitNode,'SequenceNumber')
1390: ,p_source_of_proficiency_level => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SourceOfProficiencyLevel')

Line 1387: ,p_normal_elapse_duration => hr_transaction_swi.getNumberValue(l_CommitNode,'NormalElapseDuration')

1383: ,p_effective_date_from => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateFrom')
1384: ,p_effective_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateTo')
1385: ,p_group_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'GroupCompetenceType')
1386: ,p_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CompetenceType')
1387: ,p_normal_elapse_duration => hr_transaction_swi.getNumberValue(l_CommitNode,'NormalElapseDuration')
1388: ,p_normal_elapse_duration_unit => hr_transaction_swi.getVarchar2Value(l_CommitNode,'NormalElapseDurationUnit')
1389: ,p_sequence_number => hr_transaction_swi.getNumberValue(l_CommitNode,'SequenceNumber')
1390: ,p_source_of_proficiency_level => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SourceOfProficiencyLevel')
1391: ,p_line_score => hr_transaction_swi.getNumberValue(l_CommitNode,'LineScore')

Line 1388: ,p_normal_elapse_duration_unit => hr_transaction_swi.getVarchar2Value(l_CommitNode,'NormalElapseDurationUnit')

1384: ,p_effective_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateTo')
1385: ,p_group_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'GroupCompetenceType')
1386: ,p_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CompetenceType')
1387: ,p_normal_elapse_duration => hr_transaction_swi.getNumberValue(l_CommitNode,'NormalElapseDuration')
1388: ,p_normal_elapse_duration_unit => hr_transaction_swi.getVarchar2Value(l_CommitNode,'NormalElapseDurationUnit')
1389: ,p_sequence_number => hr_transaction_swi.getNumberValue(l_CommitNode,'SequenceNumber')
1390: ,p_source_of_proficiency_level => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SourceOfProficiencyLevel')
1391: ,p_line_score => hr_transaction_swi.getNumberValue(l_CommitNode,'LineScore')
1392: ,p_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'CertificationDate')

Line 1389: ,p_sequence_number => hr_transaction_swi.getNumberValue(l_CommitNode,'SequenceNumber')

1385: ,p_group_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'GroupCompetenceType')
1386: ,p_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CompetenceType')
1387: ,p_normal_elapse_duration => hr_transaction_swi.getNumberValue(l_CommitNode,'NormalElapseDuration')
1388: ,p_normal_elapse_duration_unit => hr_transaction_swi.getVarchar2Value(l_CommitNode,'NormalElapseDurationUnit')
1389: ,p_sequence_number => hr_transaction_swi.getNumberValue(l_CommitNode,'SequenceNumber')
1390: ,p_source_of_proficiency_level => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SourceOfProficiencyLevel')
1391: ,p_line_score => hr_transaction_swi.getNumberValue(l_CommitNode,'LineScore')
1392: ,p_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'CertificationDate')
1393: ,p_certification_method => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CertificationMethod')

Line 1390: ,p_source_of_proficiency_level => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SourceOfProficiencyLevel')

1386: ,p_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CompetenceType')
1387: ,p_normal_elapse_duration => hr_transaction_swi.getNumberValue(l_CommitNode,'NormalElapseDuration')
1388: ,p_normal_elapse_duration_unit => hr_transaction_swi.getVarchar2Value(l_CommitNode,'NormalElapseDurationUnit')
1389: ,p_sequence_number => hr_transaction_swi.getNumberValue(l_CommitNode,'SequenceNumber')
1390: ,p_source_of_proficiency_level => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SourceOfProficiencyLevel')
1391: ,p_line_score => hr_transaction_swi.getNumberValue(l_CommitNode,'LineScore')
1392: ,p_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'CertificationDate')
1393: ,p_certification_method => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CertificationMethod')
1394: ,p_next_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextCertificationDate')

Line 1391: ,p_line_score => hr_transaction_swi.getNumberValue(l_CommitNode,'LineScore')

1387: ,p_normal_elapse_duration => hr_transaction_swi.getNumberValue(l_CommitNode,'NormalElapseDuration')
1388: ,p_normal_elapse_duration_unit => hr_transaction_swi.getVarchar2Value(l_CommitNode,'NormalElapseDurationUnit')
1389: ,p_sequence_number => hr_transaction_swi.getNumberValue(l_CommitNode,'SequenceNumber')
1390: ,p_source_of_proficiency_level => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SourceOfProficiencyLevel')
1391: ,p_line_score => hr_transaction_swi.getNumberValue(l_CommitNode,'LineScore')
1392: ,p_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'CertificationDate')
1393: ,p_certification_method => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CertificationMethod')
1394: ,p_next_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextCertificationDate')
1395: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')

Line 1392: ,p_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'CertificationDate')

1388: ,p_normal_elapse_duration_unit => hr_transaction_swi.getVarchar2Value(l_CommitNode,'NormalElapseDurationUnit')
1389: ,p_sequence_number => hr_transaction_swi.getNumberValue(l_CommitNode,'SequenceNumber')
1390: ,p_source_of_proficiency_level => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SourceOfProficiencyLevel')
1391: ,p_line_score => hr_transaction_swi.getNumberValue(l_CommitNode,'LineScore')
1392: ,p_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'CertificationDate')
1393: ,p_certification_method => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CertificationMethod')
1394: ,p_next_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextCertificationDate')
1395: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
1396: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')

Line 1393: ,p_certification_method => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CertificationMethod')

1389: ,p_sequence_number => hr_transaction_swi.getNumberValue(l_CommitNode,'SequenceNumber')
1390: ,p_source_of_proficiency_level => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SourceOfProficiencyLevel')
1391: ,p_line_score => hr_transaction_swi.getNumberValue(l_CommitNode,'LineScore')
1392: ,p_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'CertificationDate')
1393: ,p_certification_method => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CertificationMethod')
1394: ,p_next_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextCertificationDate')
1395: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
1396: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
1397: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')

Line 1394: ,p_next_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextCertificationDate')

1390: ,p_source_of_proficiency_level => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SourceOfProficiencyLevel')
1391: ,p_line_score => hr_transaction_swi.getNumberValue(l_CommitNode,'LineScore')
1392: ,p_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'CertificationDate')
1393: ,p_certification_method => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CertificationMethod')
1394: ,p_next_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextCertificationDate')
1395: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
1396: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
1397: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
1398: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')

Line 1395: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')

1391: ,p_line_score => hr_transaction_swi.getNumberValue(l_CommitNode,'LineScore')
1392: ,p_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'CertificationDate')
1393: ,p_certification_method => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CertificationMethod')
1394: ,p_next_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextCertificationDate')
1395: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
1396: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
1397: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
1398: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
1399: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')

Line 1396: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')

1392: ,p_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'CertificationDate')
1393: ,p_certification_method => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CertificationMethod')
1394: ,p_next_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextCertificationDate')
1395: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
1396: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
1397: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
1398: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
1399: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
1400: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')

Line 1397: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')

1393: ,p_certification_method => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CertificationMethod')
1394: ,p_next_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextCertificationDate')
1395: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
1396: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
1397: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
1398: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
1399: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
1400: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
1401: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')

Line 1398: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')

1394: ,p_next_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextCertificationDate')
1395: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
1396: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
1397: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
1398: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
1399: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
1400: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
1401: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
1402: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')

Line 1399: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')

1395: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
1396: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
1397: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
1398: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
1399: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
1400: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
1401: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
1402: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
1403: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')

Line 1400: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')

1396: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
1397: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
1398: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
1399: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
1400: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
1401: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
1402: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
1403: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
1404: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')

Line 1401: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')

1397: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
1398: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
1399: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
1400: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
1401: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
1402: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
1403: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
1404: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
1405: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')

Line 1402: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')

1398: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
1399: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
1400: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
1401: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
1402: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
1403: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
1404: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
1405: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
1406: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')

Line 1403: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')

1399: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
1400: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
1401: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
1402: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
1403: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
1404: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
1405: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
1406: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
1407: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')

Line 1404: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')

1400: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
1401: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
1402: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
1403: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
1404: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
1405: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
1406: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
1407: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
1408: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')

Line 1405: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')

1401: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
1402: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
1403: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
1404: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
1405: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
1406: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
1407: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
1408: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
1409: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')

Line 1406: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')

1402: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
1403: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
1404: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
1405: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
1406: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
1407: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
1408: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
1409: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
1410: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')

Line 1407: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')

1403: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
1404: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
1405: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
1406: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
1407: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
1408: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
1409: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
1410: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
1411: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')

Line 1408: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')

1404: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
1405: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
1406: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
1407: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
1408: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
1409: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
1410: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
1411: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
1412: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')

Line 1409: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')

1405: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
1406: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
1407: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
1408: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
1409: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
1410: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
1411: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
1412: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
1413: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')

Line 1410: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')

1406: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
1407: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
1408: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
1409: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
1410: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
1411: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
1412: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
1413: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
1414: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')

Line 1411: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')

1407: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
1408: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
1409: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
1410: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
1411: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
1412: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
1413: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
1414: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
1415: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')

Line 1412: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')

1408: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
1409: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
1410: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
1411: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
1412: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
1413: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
1414: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
1415: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
1416: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')

Line 1413: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')

1409: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
1410: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
1411: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
1412: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
1413: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
1414: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
1415: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
1416: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
1417: ,p_effective_date => l_effective_date

Line 1414: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')

1410: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
1411: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
1412: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
1413: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
1414: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
1415: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
1416: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
1417: ,p_effective_date => l_effective_date
1418: ,p_validate => p_validate

Line 1415: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')

1411: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
1412: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
1413: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
1414: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
1415: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
1416: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
1417: ,p_effective_date => l_effective_date
1418: ,p_validate => p_validate
1419: ,p_party_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PartyId')

Line 1416: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')

1412: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
1413: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
1414: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
1415: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
1416: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
1417: ,p_effective_date => l_effective_date
1418: ,p_validate => p_validate
1419: ,p_party_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PartyId')
1420: ,p_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status',null)

Line 1419: ,p_party_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PartyId')

1415: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
1416: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
1417: ,p_effective_date => l_effective_date
1418: ,p_validate => p_validate
1419: ,p_party_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PartyId')
1420: ,p_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status',null)
1421: ,p_return_status => l_return_status
1422: ,p_datetrack_update_mode => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DatetrackUpdate',hr_api.g_correction)
1423: );

Line 1420: ,p_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status',null)

1416: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
1417: ,p_effective_date => l_effective_date
1418: ,p_validate => p_validate
1419: ,p_party_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PartyId')
1420: ,p_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status',null)
1421: ,p_return_status => l_return_status
1422: ,p_datetrack_update_mode => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DatetrackUpdate',hr_api.g_correction)
1423: );
1424:

Line 1422: ,p_datetrack_update_mode => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DatetrackUpdate',hr_api.g_correction)

1418: ,p_validate => p_validate
1419: ,p_party_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PartyId')
1420: ,p_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status',null)
1421: ,p_return_status => l_return_status
1422: ,p_datetrack_update_mode => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DatetrackUpdate',hr_api.g_correction)
1423: );
1424:
1425: elsif l_postState = '3' then
1426:

Line 1429: ,p_competence_element_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceElementId')

1425: elsif l_postState = '3' then
1426:
1427: delete_competence_element
1428: ( p_validate => p_validate
1429: ,p_competence_element_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceElementId')
1430: ,p_object_version_number => l_object_version_number
1431: ,p_return_status => l_return_status
1432: );
1433: