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 1304: l_object_version_number := hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectVersionNumber');

1300: hr_utility.set_location('Extracting the PostState:' || l_proc,20);
1301:
1302: l_commitElement := xmldom.makeElement(l_CommitNode);
1303: l_postState := xmldom.getAttribute(l_commitElement, 'PS');
1304: l_object_version_number := hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectVersionNumber');
1305: --
1306: if p_effective_date is null
1307: then
1308: --

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

1317: if l_postState = '0' then
1318:
1319: create_competence_element
1320: ( p_validate => p_validate
1321: ,p_competence_element_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceElementId',null)
1322: ,p_object_version_number => l_object_version_number
1323: ,p_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Type',null)
1324: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',null)
1325: ,p_enterprise_id => hr_transaction_swi.getNumberValue(l_CommitNode,'EnterpriseId',null)

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

1319: create_competence_element
1320: ( p_validate => p_validate
1321: ,p_competence_element_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceElementId',null)
1322: ,p_object_version_number => l_object_version_number
1323: ,p_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Type',null)
1324: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',null)
1325: ,p_enterprise_id => hr_transaction_swi.getNumberValue(l_CommitNode,'EnterpriseId',null)
1326: ,p_competence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceId',null)
1327: ,p_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ProficiencyLevelId',null)

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

1320: ( p_validate => p_validate
1321: ,p_competence_element_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceElementId',null)
1322: ,p_object_version_number => l_object_version_number
1323: ,p_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Type',null)
1324: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',null)
1325: ,p_enterprise_id => hr_transaction_swi.getNumberValue(l_CommitNode,'EnterpriseId',null)
1326: ,p_competence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceId',null)
1327: ,p_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ProficiencyLevelId',null)
1328: ,p_high_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'HighProficiencyLevelId',null)

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

1321: ,p_competence_element_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceElementId',null)
1322: ,p_object_version_number => l_object_version_number
1323: ,p_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Type',null)
1324: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',null)
1325: ,p_enterprise_id => hr_transaction_swi.getNumberValue(l_CommitNode,'EnterpriseId',null)
1326: ,p_competence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceId',null)
1327: ,p_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ProficiencyLevelId',null)
1328: ,p_high_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'HighProficiencyLevelId',null)
1329: ,p_weighting_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'WeightingLevelId',null)

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

1322: ,p_object_version_number => l_object_version_number
1323: ,p_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Type',null)
1324: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',null)
1325: ,p_enterprise_id => hr_transaction_swi.getNumberValue(l_CommitNode,'EnterpriseId',null)
1326: ,p_competence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceId',null)
1327: ,p_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ProficiencyLevelId',null)
1328: ,p_high_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'HighProficiencyLevelId',null)
1329: ,p_weighting_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'WeightingLevelId',null)
1330: ,p_rating_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RatingLevelId',null)

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

1323: ,p_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Type',null)
1324: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',null)
1325: ,p_enterprise_id => hr_transaction_swi.getNumberValue(l_CommitNode,'EnterpriseId',null)
1326: ,p_competence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceId',null)
1327: ,p_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ProficiencyLevelId',null)
1328: ,p_high_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'HighProficiencyLevelId',null)
1329: ,p_weighting_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'WeightingLevelId',null)
1330: ,p_rating_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RatingLevelId',null)
1331: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId',null)

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

1324: ,p_business_group_id => hr_transaction_swi.getNumberValue(l_CommitNode,'BusinessGroupId',null)
1325: ,p_enterprise_id => hr_transaction_swi.getNumberValue(l_CommitNode,'EnterpriseId',null)
1326: ,p_competence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceId',null)
1327: ,p_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ProficiencyLevelId',null)
1328: ,p_high_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'HighProficiencyLevelId',null)
1329: ,p_weighting_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'WeightingLevelId',null)
1330: ,p_rating_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RatingLevelId',null)
1331: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId',null)
1332: ,p_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId',null)

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

1325: ,p_enterprise_id => hr_transaction_swi.getNumberValue(l_CommitNode,'EnterpriseId',null)
1326: ,p_competence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceId',null)
1327: ,p_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ProficiencyLevelId',null)
1328: ,p_high_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'HighProficiencyLevelId',null)
1329: ,p_weighting_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'WeightingLevelId',null)
1330: ,p_rating_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RatingLevelId',null)
1331: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId',null)
1332: ,p_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId',null)
1333: ,p_valid_grade_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ValidGradeId',null)

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

1326: ,p_competence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceId',null)
1327: ,p_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ProficiencyLevelId',null)
1328: ,p_high_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'HighProficiencyLevelId',null)
1329: ,p_weighting_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'WeightingLevelId',null)
1330: ,p_rating_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RatingLevelId',null)
1331: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId',null)
1332: ,p_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId',null)
1333: ,p_valid_grade_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ValidGradeId',null)
1334: ,p_position_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PositionId',null)

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

1327: ,p_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ProficiencyLevelId',null)
1328: ,p_high_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'HighProficiencyLevelId',null)
1329: ,p_weighting_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'WeightingLevelId',null)
1330: ,p_rating_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RatingLevelId',null)
1331: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId',null)
1332: ,p_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId',null)
1333: ,p_valid_grade_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ValidGradeId',null)
1334: ,p_position_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PositionId',null)
1335: ,p_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OrganizationId',null)

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

1328: ,p_high_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'HighProficiencyLevelId',null)
1329: ,p_weighting_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'WeightingLevelId',null)
1330: ,p_rating_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RatingLevelId',null)
1331: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId',null)
1332: ,p_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId',null)
1333: ,p_valid_grade_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ValidGradeId',null)
1334: ,p_position_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PositionId',null)
1335: ,p_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OrganizationId',null)
1336: ,p_parent_competence_element_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ParentCompetenceElementId',null)

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

1329: ,p_weighting_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'WeightingLevelId',null)
1330: ,p_rating_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RatingLevelId',null)
1331: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId',null)
1332: ,p_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId',null)
1333: ,p_valid_grade_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ValidGradeId',null)
1334: ,p_position_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PositionId',null)
1335: ,p_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OrganizationId',null)
1336: ,p_parent_competence_element_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ParentCompetenceElementId',null)
1337: ,p_activity_version_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ActivityVersionId',null)

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

1330: ,p_rating_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RatingLevelId',null)
1331: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId',null)
1332: ,p_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId',null)
1333: ,p_valid_grade_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ValidGradeId',null)
1334: ,p_position_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PositionId',null)
1335: ,p_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OrganizationId',null)
1336: ,p_parent_competence_element_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ParentCompetenceElementId',null)
1337: ,p_activity_version_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ActivityVersionId',null)
1338: ,p_assessment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssessmentId',null)

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

1331: ,p_person_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PersonId',null)
1332: ,p_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId',null)
1333: ,p_valid_grade_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ValidGradeId',null)
1334: ,p_position_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PositionId',null)
1335: ,p_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OrganizationId',null)
1336: ,p_parent_competence_element_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ParentCompetenceElementId',null)
1337: ,p_activity_version_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ActivityVersionId',null)
1338: ,p_assessment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssessmentId',null)
1339: ,p_assessment_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssessmentTypeId',null)

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

1332: ,p_job_id => hr_transaction_swi.getNumberValue(l_CommitNode,'JobId',null)
1333: ,p_valid_grade_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ValidGradeId',null)
1334: ,p_position_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PositionId',null)
1335: ,p_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OrganizationId',null)
1336: ,p_parent_competence_element_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ParentCompetenceElementId',null)
1337: ,p_activity_version_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ActivityVersionId',null)
1338: ,p_assessment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssessmentId',null)
1339: ,p_assessment_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssessmentTypeId',null)
1340: ,p_mandatory => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Mandatory',null)

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

1333: ,p_valid_grade_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ValidGradeId',null)
1334: ,p_position_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PositionId',null)
1335: ,p_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OrganizationId',null)
1336: ,p_parent_competence_element_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ParentCompetenceElementId',null)
1337: ,p_activity_version_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ActivityVersionId',null)
1338: ,p_assessment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssessmentId',null)
1339: ,p_assessment_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssessmentTypeId',null)
1340: ,p_mandatory => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Mandatory',null)
1341: ,p_effective_date_from => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateFrom',null)

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

1334: ,p_position_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PositionId',null)
1335: ,p_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OrganizationId',null)
1336: ,p_parent_competence_element_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ParentCompetenceElementId',null)
1337: ,p_activity_version_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ActivityVersionId',null)
1338: ,p_assessment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssessmentId',null)
1339: ,p_assessment_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssessmentTypeId',null)
1340: ,p_mandatory => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Mandatory',null)
1341: ,p_effective_date_from => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateFrom',null)
1342: ,p_effective_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateTo',null)

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

1335: ,p_organization_id => hr_transaction_swi.getNumberValue(l_CommitNode,'OrganizationId',null)
1336: ,p_parent_competence_element_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ParentCompetenceElementId',null)
1337: ,p_activity_version_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ActivityVersionId',null)
1338: ,p_assessment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssessmentId',null)
1339: ,p_assessment_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssessmentTypeId',null)
1340: ,p_mandatory => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Mandatory',null)
1341: ,p_effective_date_from => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateFrom',null)
1342: ,p_effective_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateTo',null)
1343: ,p_group_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'GroupCompetenceType',null)

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

1336: ,p_parent_competence_element_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ParentCompetenceElementId',null)
1337: ,p_activity_version_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ActivityVersionId',null)
1338: ,p_assessment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssessmentId',null)
1339: ,p_assessment_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssessmentTypeId',null)
1340: ,p_mandatory => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Mandatory',null)
1341: ,p_effective_date_from => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateFrom',null)
1342: ,p_effective_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateTo',null)
1343: ,p_group_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'GroupCompetenceType',null)
1344: ,p_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CompetenceType',null)

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

1337: ,p_activity_version_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ActivityVersionId',null)
1338: ,p_assessment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssessmentId',null)
1339: ,p_assessment_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssessmentTypeId',null)
1340: ,p_mandatory => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Mandatory',null)
1341: ,p_effective_date_from => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateFrom',null)
1342: ,p_effective_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateTo',null)
1343: ,p_group_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'GroupCompetenceType',null)
1344: ,p_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CompetenceType',null)
1345: ,p_normal_elapse_duration => hr_transaction_swi.getNumberValue(l_CommitNode,'NormalElapseDuration',null)

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

1338: ,p_assessment_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssessmentId',null)
1339: ,p_assessment_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssessmentTypeId',null)
1340: ,p_mandatory => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Mandatory',null)
1341: ,p_effective_date_from => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateFrom',null)
1342: ,p_effective_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateTo',null)
1343: ,p_group_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'GroupCompetenceType',null)
1344: ,p_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CompetenceType',null)
1345: ,p_normal_elapse_duration => hr_transaction_swi.getNumberValue(l_CommitNode,'NormalElapseDuration',null)
1346: ,p_normal_elapse_duration_unit => hr_transaction_swi.getVarchar2Value(l_CommitNode,'NormalElapseDurationUnit',null)

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

1339: ,p_assessment_type_id => hr_transaction_swi.getNumberValue(l_CommitNode,'AssessmentTypeId',null)
1340: ,p_mandatory => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Mandatory',null)
1341: ,p_effective_date_from => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateFrom',null)
1342: ,p_effective_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateTo',null)
1343: ,p_group_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'GroupCompetenceType',null)
1344: ,p_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CompetenceType',null)
1345: ,p_normal_elapse_duration => hr_transaction_swi.getNumberValue(l_CommitNode,'NormalElapseDuration',null)
1346: ,p_normal_elapse_duration_unit => hr_transaction_swi.getVarchar2Value(l_CommitNode,'NormalElapseDurationUnit',null)
1347: ,p_sequence_number => hr_transaction_swi.getNumberValue(l_CommitNode,'SequenceNumber',null)

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

1340: ,p_mandatory => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Mandatory',null)
1341: ,p_effective_date_from => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateFrom',null)
1342: ,p_effective_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateTo',null)
1343: ,p_group_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'GroupCompetenceType',null)
1344: ,p_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CompetenceType',null)
1345: ,p_normal_elapse_duration => hr_transaction_swi.getNumberValue(l_CommitNode,'NormalElapseDuration',null)
1346: ,p_normal_elapse_duration_unit => hr_transaction_swi.getVarchar2Value(l_CommitNode,'NormalElapseDurationUnit',null)
1347: ,p_sequence_number => hr_transaction_swi.getNumberValue(l_CommitNode,'SequenceNumber',null)
1348: ,p_source_of_proficiency_level => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SourceOfProficiencyLevel',null)

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

1341: ,p_effective_date_from => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateFrom',null)
1342: ,p_effective_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateTo',null)
1343: ,p_group_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'GroupCompetenceType',null)
1344: ,p_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CompetenceType',null)
1345: ,p_normal_elapse_duration => hr_transaction_swi.getNumberValue(l_CommitNode,'NormalElapseDuration',null)
1346: ,p_normal_elapse_duration_unit => hr_transaction_swi.getVarchar2Value(l_CommitNode,'NormalElapseDurationUnit',null)
1347: ,p_sequence_number => hr_transaction_swi.getNumberValue(l_CommitNode,'SequenceNumber',null)
1348: ,p_source_of_proficiency_level => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SourceOfProficiencyLevel',null)
1349: ,p_line_score => hr_transaction_swi.getNumberValue(l_CommitNode,'LineScore',null)

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

1342: ,p_effective_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateTo',null)
1343: ,p_group_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'GroupCompetenceType',null)
1344: ,p_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CompetenceType',null)
1345: ,p_normal_elapse_duration => hr_transaction_swi.getNumberValue(l_CommitNode,'NormalElapseDuration',null)
1346: ,p_normal_elapse_duration_unit => hr_transaction_swi.getVarchar2Value(l_CommitNode,'NormalElapseDurationUnit',null)
1347: ,p_sequence_number => hr_transaction_swi.getNumberValue(l_CommitNode,'SequenceNumber',null)
1348: ,p_source_of_proficiency_level => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SourceOfProficiencyLevel',null)
1349: ,p_line_score => hr_transaction_swi.getNumberValue(l_CommitNode,'LineScore',null)
1350: ,p_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'CertificationDate',null)

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

1343: ,p_group_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'GroupCompetenceType',null)
1344: ,p_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CompetenceType',null)
1345: ,p_normal_elapse_duration => hr_transaction_swi.getNumberValue(l_CommitNode,'NormalElapseDuration',null)
1346: ,p_normal_elapse_duration_unit => hr_transaction_swi.getVarchar2Value(l_CommitNode,'NormalElapseDurationUnit',null)
1347: ,p_sequence_number => hr_transaction_swi.getNumberValue(l_CommitNode,'SequenceNumber',null)
1348: ,p_source_of_proficiency_level => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SourceOfProficiencyLevel',null)
1349: ,p_line_score => hr_transaction_swi.getNumberValue(l_CommitNode,'LineScore',null)
1350: ,p_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'CertificationDate',null)
1351: ,p_certification_method => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CertificationMethod',null)

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

1344: ,p_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CompetenceType',null)
1345: ,p_normal_elapse_duration => hr_transaction_swi.getNumberValue(l_CommitNode,'NormalElapseDuration',null)
1346: ,p_normal_elapse_duration_unit => hr_transaction_swi.getVarchar2Value(l_CommitNode,'NormalElapseDurationUnit',null)
1347: ,p_sequence_number => hr_transaction_swi.getNumberValue(l_CommitNode,'SequenceNumber',null)
1348: ,p_source_of_proficiency_level => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SourceOfProficiencyLevel',null)
1349: ,p_line_score => hr_transaction_swi.getNumberValue(l_CommitNode,'LineScore',null)
1350: ,p_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'CertificationDate',null)
1351: ,p_certification_method => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CertificationMethod',null)
1352: ,p_next_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextCertificationDate',null)

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

1345: ,p_normal_elapse_duration => hr_transaction_swi.getNumberValue(l_CommitNode,'NormalElapseDuration',null)
1346: ,p_normal_elapse_duration_unit => hr_transaction_swi.getVarchar2Value(l_CommitNode,'NormalElapseDurationUnit',null)
1347: ,p_sequence_number => hr_transaction_swi.getNumberValue(l_CommitNode,'SequenceNumber',null)
1348: ,p_source_of_proficiency_level => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SourceOfProficiencyLevel',null)
1349: ,p_line_score => hr_transaction_swi.getNumberValue(l_CommitNode,'LineScore',null)
1350: ,p_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'CertificationDate',null)
1351: ,p_certification_method => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CertificationMethod',null)
1352: ,p_next_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextCertificationDate',null)
1353: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)

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

1346: ,p_normal_elapse_duration_unit => hr_transaction_swi.getVarchar2Value(l_CommitNode,'NormalElapseDurationUnit',null)
1347: ,p_sequence_number => hr_transaction_swi.getNumberValue(l_CommitNode,'SequenceNumber',null)
1348: ,p_source_of_proficiency_level => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SourceOfProficiencyLevel',null)
1349: ,p_line_score => hr_transaction_swi.getNumberValue(l_CommitNode,'LineScore',null)
1350: ,p_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'CertificationDate',null)
1351: ,p_certification_method => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CertificationMethod',null)
1352: ,p_next_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextCertificationDate',null)
1353: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
1354: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)

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

1347: ,p_sequence_number => hr_transaction_swi.getNumberValue(l_CommitNode,'SequenceNumber',null)
1348: ,p_source_of_proficiency_level => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SourceOfProficiencyLevel',null)
1349: ,p_line_score => hr_transaction_swi.getNumberValue(l_CommitNode,'LineScore',null)
1350: ,p_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'CertificationDate',null)
1351: ,p_certification_method => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CertificationMethod',null)
1352: ,p_next_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextCertificationDate',null)
1353: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
1354: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
1355: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)

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

1348: ,p_source_of_proficiency_level => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SourceOfProficiencyLevel',null)
1349: ,p_line_score => hr_transaction_swi.getNumberValue(l_CommitNode,'LineScore',null)
1350: ,p_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'CertificationDate',null)
1351: ,p_certification_method => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CertificationMethod',null)
1352: ,p_next_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextCertificationDate',null)
1353: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
1354: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
1355: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
1356: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)

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

1349: ,p_line_score => hr_transaction_swi.getNumberValue(l_CommitNode,'LineScore',null)
1350: ,p_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'CertificationDate',null)
1351: ,p_certification_method => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CertificationMethod',null)
1352: ,p_next_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextCertificationDate',null)
1353: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
1354: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
1355: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
1356: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
1357: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)

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

1350: ,p_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'CertificationDate',null)
1351: ,p_certification_method => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CertificationMethod',null)
1352: ,p_next_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextCertificationDate',null)
1353: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
1354: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
1355: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
1356: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
1357: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
1358: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)

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

1351: ,p_certification_method => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CertificationMethod',null)
1352: ,p_next_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextCertificationDate',null)
1353: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
1354: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
1355: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
1356: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
1357: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
1358: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
1359: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)

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

1352: ,p_next_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextCertificationDate',null)
1353: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
1354: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
1355: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
1356: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
1357: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
1358: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
1359: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
1360: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)

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

1353: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments',null)
1354: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
1355: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
1356: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
1357: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
1358: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
1359: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
1360: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
1361: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)

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

1354: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory',null)
1355: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
1356: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
1357: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
1358: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
1359: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
1360: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
1361: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
1362: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)

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

1355: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1',null)
1356: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
1357: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
1358: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
1359: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
1360: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
1361: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
1362: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
1363: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)

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

1356: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2',null)
1357: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
1358: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
1359: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
1360: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
1361: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
1362: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
1363: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
1364: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)

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

1357: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3',null)
1358: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
1359: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
1360: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
1361: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
1362: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
1363: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
1364: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
1365: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)

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

1358: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4',null)
1359: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
1360: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
1361: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
1362: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
1363: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
1364: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
1365: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
1366: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)

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

1359: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5',null)
1360: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
1361: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
1362: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
1363: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
1364: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
1365: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
1366: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
1367: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)

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

1360: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6',null)
1361: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
1362: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
1363: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
1364: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
1365: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
1366: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
1367: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
1368: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)

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

1361: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7',null)
1362: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
1363: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
1364: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
1365: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
1366: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
1367: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
1368: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
1369: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)

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

1362: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8',null)
1363: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
1364: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
1365: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
1366: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
1367: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
1368: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
1369: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
1370: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)

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

1363: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9',null)
1364: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
1365: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
1366: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
1367: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
1368: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
1369: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
1370: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
1371: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)

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

1364: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10',null)
1365: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
1366: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
1367: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
1368: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
1369: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
1370: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
1371: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
1372: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)

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

1365: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11',null)
1366: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
1367: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
1368: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
1369: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
1370: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
1371: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
1372: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
1373: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)

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

1366: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12',null)
1367: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
1368: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
1369: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
1370: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
1371: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
1372: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
1373: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
1374: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)

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

1367: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13',null)
1368: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
1369: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
1370: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
1371: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
1372: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
1373: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
1374: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
1375: ,p_effective_date => l_effective_date

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

1368: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14',null)
1369: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
1370: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
1371: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
1372: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
1373: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
1374: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
1375: ,p_effective_date => l_effective_date
1376: ,p_object_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectId',null)

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

1369: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15',null)
1370: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
1371: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
1372: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
1373: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
1374: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
1375: ,p_effective_date => l_effective_date
1376: ,p_object_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectId',null)
1377: ,p_object_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ObjectName',null)

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

1370: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16',null)
1371: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17',null)
1372: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
1373: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
1374: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
1375: ,p_effective_date => l_effective_date
1376: ,p_object_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectId',null)
1377: ,p_object_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ObjectName',null)
1378: ,p_party_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PartyId',null)

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

1372: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18',null)
1373: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
1374: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
1375: ,p_effective_date => l_effective_date
1376: ,p_object_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectId',null)
1377: ,p_object_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ObjectName',null)
1378: ,p_party_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PartyId',null)
1379: ,p_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status',null)
1380: ,p_return_status => l_return_status

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

1373: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19',null)
1374: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
1375: ,p_effective_date => l_effective_date
1376: ,p_object_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectId',null)
1377: ,p_object_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ObjectName',null)
1378: ,p_party_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PartyId',null)
1379: ,p_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status',null)
1380: ,p_return_status => l_return_status
1381: );

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

1374: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20',null)
1375: ,p_effective_date => l_effective_date
1376: ,p_object_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectId',null)
1377: ,p_object_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ObjectName',null)
1378: ,p_party_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PartyId',null)
1379: ,p_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status',null)
1380: ,p_return_status => l_return_status
1381: );
1382:

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

1375: ,p_effective_date => l_effective_date
1376: ,p_object_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ObjectId',null)
1377: ,p_object_name => hr_transaction_swi.getVarchar2Value(l_CommitNode,'ObjectName',null)
1378: ,p_party_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PartyId',null)
1379: ,p_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status',null)
1380: ,p_return_status => l_return_status
1381: );
1382:
1383: elsif l_postState = '2' then

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

1383: elsif l_postState = '2' then
1384:
1385:
1386: update_competence_element
1387: (p_competence_element_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceElementId')
1388: ,p_object_version_number => l_object_version_number
1389: ,p_competence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceId')
1390: ,p_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ProficiencyLevelId')
1391: ,p_high_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'HighProficiencyLevelId')

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

1385:
1386: update_competence_element
1387: (p_competence_element_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceElementId')
1388: ,p_object_version_number => l_object_version_number
1389: ,p_competence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceId')
1390: ,p_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ProficiencyLevelId')
1391: ,p_high_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'HighProficiencyLevelId')
1392: ,p_weighting_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'WeightingLevelId')
1393: ,p_rating_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RatingLevelId')

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

1386: update_competence_element
1387: (p_competence_element_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceElementId')
1388: ,p_object_version_number => l_object_version_number
1389: ,p_competence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceId')
1390: ,p_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ProficiencyLevelId')
1391: ,p_high_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'HighProficiencyLevelId')
1392: ,p_weighting_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'WeightingLevelId')
1393: ,p_rating_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RatingLevelId')
1394: ,p_mandatory => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Mandatory')

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

1387: (p_competence_element_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceElementId')
1388: ,p_object_version_number => l_object_version_number
1389: ,p_competence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceId')
1390: ,p_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ProficiencyLevelId')
1391: ,p_high_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'HighProficiencyLevelId')
1392: ,p_weighting_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'WeightingLevelId')
1393: ,p_rating_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RatingLevelId')
1394: ,p_mandatory => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Mandatory')
1395: ,p_effective_date_from => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateFrom')

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

1388: ,p_object_version_number => l_object_version_number
1389: ,p_competence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceId')
1390: ,p_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ProficiencyLevelId')
1391: ,p_high_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'HighProficiencyLevelId')
1392: ,p_weighting_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'WeightingLevelId')
1393: ,p_rating_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RatingLevelId')
1394: ,p_mandatory => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Mandatory')
1395: ,p_effective_date_from => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateFrom')
1396: ,p_effective_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateTo')

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

1389: ,p_competence_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceId')
1390: ,p_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ProficiencyLevelId')
1391: ,p_high_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'HighProficiencyLevelId')
1392: ,p_weighting_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'WeightingLevelId')
1393: ,p_rating_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RatingLevelId')
1394: ,p_mandatory => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Mandatory')
1395: ,p_effective_date_from => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateFrom')
1396: ,p_effective_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateTo')
1397: ,p_group_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'GroupCompetenceType')

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

1390: ,p_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'ProficiencyLevelId')
1391: ,p_high_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'HighProficiencyLevelId')
1392: ,p_weighting_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'WeightingLevelId')
1393: ,p_rating_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RatingLevelId')
1394: ,p_mandatory => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Mandatory')
1395: ,p_effective_date_from => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateFrom')
1396: ,p_effective_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateTo')
1397: ,p_group_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'GroupCompetenceType')
1398: ,p_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CompetenceType')

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

1391: ,p_high_proficiency_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'HighProficiencyLevelId')
1392: ,p_weighting_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'WeightingLevelId')
1393: ,p_rating_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RatingLevelId')
1394: ,p_mandatory => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Mandatory')
1395: ,p_effective_date_from => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateFrom')
1396: ,p_effective_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateTo')
1397: ,p_group_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'GroupCompetenceType')
1398: ,p_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CompetenceType')
1399: ,p_normal_elapse_duration => hr_transaction_swi.getNumberValue(l_CommitNode,'NormalElapseDuration')

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

1392: ,p_weighting_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'WeightingLevelId')
1393: ,p_rating_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RatingLevelId')
1394: ,p_mandatory => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Mandatory')
1395: ,p_effective_date_from => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateFrom')
1396: ,p_effective_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateTo')
1397: ,p_group_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'GroupCompetenceType')
1398: ,p_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CompetenceType')
1399: ,p_normal_elapse_duration => hr_transaction_swi.getNumberValue(l_CommitNode,'NormalElapseDuration')
1400: ,p_normal_elapse_duration_unit => hr_transaction_swi.getVarchar2Value(l_CommitNode,'NormalElapseDurationUnit')

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

1393: ,p_rating_level_id => hr_transaction_swi.getNumberValue(l_CommitNode,'RatingLevelId')
1394: ,p_mandatory => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Mandatory')
1395: ,p_effective_date_from => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateFrom')
1396: ,p_effective_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateTo')
1397: ,p_group_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'GroupCompetenceType')
1398: ,p_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CompetenceType')
1399: ,p_normal_elapse_duration => hr_transaction_swi.getNumberValue(l_CommitNode,'NormalElapseDuration')
1400: ,p_normal_elapse_duration_unit => hr_transaction_swi.getVarchar2Value(l_CommitNode,'NormalElapseDurationUnit')
1401: ,p_sequence_number => hr_transaction_swi.getNumberValue(l_CommitNode,'SequenceNumber')

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

1394: ,p_mandatory => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Mandatory')
1395: ,p_effective_date_from => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateFrom')
1396: ,p_effective_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateTo')
1397: ,p_group_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'GroupCompetenceType')
1398: ,p_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CompetenceType')
1399: ,p_normal_elapse_duration => hr_transaction_swi.getNumberValue(l_CommitNode,'NormalElapseDuration')
1400: ,p_normal_elapse_duration_unit => hr_transaction_swi.getVarchar2Value(l_CommitNode,'NormalElapseDurationUnit')
1401: ,p_sequence_number => hr_transaction_swi.getNumberValue(l_CommitNode,'SequenceNumber')
1402: ,p_source_of_proficiency_level => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SourceOfProficiencyLevel')

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

1395: ,p_effective_date_from => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateFrom')
1396: ,p_effective_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateTo')
1397: ,p_group_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'GroupCompetenceType')
1398: ,p_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CompetenceType')
1399: ,p_normal_elapse_duration => hr_transaction_swi.getNumberValue(l_CommitNode,'NormalElapseDuration')
1400: ,p_normal_elapse_duration_unit => hr_transaction_swi.getVarchar2Value(l_CommitNode,'NormalElapseDurationUnit')
1401: ,p_sequence_number => hr_transaction_swi.getNumberValue(l_CommitNode,'SequenceNumber')
1402: ,p_source_of_proficiency_level => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SourceOfProficiencyLevel')
1403: ,p_line_score => hr_transaction_swi.getNumberValue(l_CommitNode,'LineScore')

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

1396: ,p_effective_date_to => hr_transaction_swi.getDateValue(l_CommitNode,'EffectiveDateTo')
1397: ,p_group_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'GroupCompetenceType')
1398: ,p_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CompetenceType')
1399: ,p_normal_elapse_duration => hr_transaction_swi.getNumberValue(l_CommitNode,'NormalElapseDuration')
1400: ,p_normal_elapse_duration_unit => hr_transaction_swi.getVarchar2Value(l_CommitNode,'NormalElapseDurationUnit')
1401: ,p_sequence_number => hr_transaction_swi.getNumberValue(l_CommitNode,'SequenceNumber')
1402: ,p_source_of_proficiency_level => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SourceOfProficiencyLevel')
1403: ,p_line_score => hr_transaction_swi.getNumberValue(l_CommitNode,'LineScore')
1404: ,p_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'CertificationDate')

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

1397: ,p_group_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'GroupCompetenceType')
1398: ,p_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CompetenceType')
1399: ,p_normal_elapse_duration => hr_transaction_swi.getNumberValue(l_CommitNode,'NormalElapseDuration')
1400: ,p_normal_elapse_duration_unit => hr_transaction_swi.getVarchar2Value(l_CommitNode,'NormalElapseDurationUnit')
1401: ,p_sequence_number => hr_transaction_swi.getNumberValue(l_CommitNode,'SequenceNumber')
1402: ,p_source_of_proficiency_level => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SourceOfProficiencyLevel')
1403: ,p_line_score => hr_transaction_swi.getNumberValue(l_CommitNode,'LineScore')
1404: ,p_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'CertificationDate')
1405: ,p_certification_method => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CertificationMethod')

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

1398: ,p_competence_type => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CompetenceType')
1399: ,p_normal_elapse_duration => hr_transaction_swi.getNumberValue(l_CommitNode,'NormalElapseDuration')
1400: ,p_normal_elapse_duration_unit => hr_transaction_swi.getVarchar2Value(l_CommitNode,'NormalElapseDurationUnit')
1401: ,p_sequence_number => hr_transaction_swi.getNumberValue(l_CommitNode,'SequenceNumber')
1402: ,p_source_of_proficiency_level => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SourceOfProficiencyLevel')
1403: ,p_line_score => hr_transaction_swi.getNumberValue(l_CommitNode,'LineScore')
1404: ,p_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'CertificationDate')
1405: ,p_certification_method => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CertificationMethod')
1406: ,p_next_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextCertificationDate')

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

1399: ,p_normal_elapse_duration => hr_transaction_swi.getNumberValue(l_CommitNode,'NormalElapseDuration')
1400: ,p_normal_elapse_duration_unit => hr_transaction_swi.getVarchar2Value(l_CommitNode,'NormalElapseDurationUnit')
1401: ,p_sequence_number => hr_transaction_swi.getNumberValue(l_CommitNode,'SequenceNumber')
1402: ,p_source_of_proficiency_level => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SourceOfProficiencyLevel')
1403: ,p_line_score => hr_transaction_swi.getNumberValue(l_CommitNode,'LineScore')
1404: ,p_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'CertificationDate')
1405: ,p_certification_method => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CertificationMethod')
1406: ,p_next_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextCertificationDate')
1407: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')

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

1400: ,p_normal_elapse_duration_unit => hr_transaction_swi.getVarchar2Value(l_CommitNode,'NormalElapseDurationUnit')
1401: ,p_sequence_number => hr_transaction_swi.getNumberValue(l_CommitNode,'SequenceNumber')
1402: ,p_source_of_proficiency_level => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SourceOfProficiencyLevel')
1403: ,p_line_score => hr_transaction_swi.getNumberValue(l_CommitNode,'LineScore')
1404: ,p_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'CertificationDate')
1405: ,p_certification_method => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CertificationMethod')
1406: ,p_next_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextCertificationDate')
1407: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
1408: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')

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

1401: ,p_sequence_number => hr_transaction_swi.getNumberValue(l_CommitNode,'SequenceNumber')
1402: ,p_source_of_proficiency_level => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SourceOfProficiencyLevel')
1403: ,p_line_score => hr_transaction_swi.getNumberValue(l_CommitNode,'LineScore')
1404: ,p_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'CertificationDate')
1405: ,p_certification_method => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CertificationMethod')
1406: ,p_next_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextCertificationDate')
1407: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
1408: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
1409: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')

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

1402: ,p_source_of_proficiency_level => hr_transaction_swi.getVarchar2Value(l_CommitNode,'SourceOfProficiencyLevel')
1403: ,p_line_score => hr_transaction_swi.getNumberValue(l_CommitNode,'LineScore')
1404: ,p_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'CertificationDate')
1405: ,p_certification_method => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CertificationMethod')
1406: ,p_next_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextCertificationDate')
1407: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
1408: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
1409: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
1410: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')

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

1403: ,p_line_score => hr_transaction_swi.getNumberValue(l_CommitNode,'LineScore')
1404: ,p_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'CertificationDate')
1405: ,p_certification_method => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CertificationMethod')
1406: ,p_next_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextCertificationDate')
1407: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
1408: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
1409: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
1410: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
1411: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')

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

1404: ,p_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'CertificationDate')
1405: ,p_certification_method => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CertificationMethod')
1406: ,p_next_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextCertificationDate')
1407: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
1408: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
1409: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
1410: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
1411: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
1412: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')

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

1405: ,p_certification_method => hr_transaction_swi.getVarchar2Value(l_CommitNode,'CertificationMethod')
1406: ,p_next_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextCertificationDate')
1407: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
1408: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
1409: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
1410: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
1411: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
1412: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
1413: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')

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

1406: ,p_next_certification_date => hr_transaction_swi.getDateValue(l_CommitNode,'NextCertificationDate')
1407: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
1408: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
1409: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
1410: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
1411: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
1412: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
1413: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
1414: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')

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

1407: ,p_comments => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Comments')
1408: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
1409: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
1410: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
1411: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
1412: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
1413: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
1414: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
1415: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')

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

1408: ,p_attribute_category => hr_transaction_swi.getVarchar2Value(l_CommitNode,'AttributeCategory')
1409: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
1410: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
1411: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
1412: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
1413: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
1414: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
1415: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
1416: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')

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

1409: ,p_attribute1 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute1')
1410: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
1411: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
1412: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
1413: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
1414: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
1415: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
1416: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
1417: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')

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

1410: ,p_attribute2 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute2')
1411: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
1412: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
1413: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
1414: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
1415: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
1416: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
1417: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
1418: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')

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

1411: ,p_attribute3 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute3')
1412: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
1413: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
1414: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
1415: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
1416: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
1417: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
1418: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
1419: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')

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

1412: ,p_attribute4 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute4')
1413: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
1414: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
1415: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
1416: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
1417: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
1418: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
1419: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
1420: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')

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

1413: ,p_attribute5 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute5')
1414: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
1415: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
1416: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
1417: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
1418: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
1419: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
1420: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
1421: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')

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

1414: ,p_attribute6 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute6')
1415: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
1416: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
1417: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
1418: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
1419: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
1420: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
1421: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
1422: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')

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

1415: ,p_attribute7 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute7')
1416: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
1417: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
1418: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
1419: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
1420: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
1421: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
1422: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
1423: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')

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

1416: ,p_attribute8 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute8')
1417: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
1418: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
1419: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
1420: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
1421: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
1422: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
1423: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
1424: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')

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

1417: ,p_attribute9 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute9')
1418: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
1419: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
1420: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
1421: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
1422: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
1423: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
1424: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
1425: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')

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

1418: ,p_attribute10 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute10')
1419: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
1420: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
1421: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
1422: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
1423: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
1424: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
1425: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
1426: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')

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

1419: ,p_attribute11 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute11')
1420: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
1421: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
1422: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
1423: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
1424: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
1425: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
1426: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
1427: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')

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

1420: ,p_attribute12 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute12')
1421: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
1422: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
1423: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
1424: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
1425: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
1426: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
1427: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
1428: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')

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

1421: ,p_attribute13 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute13')
1422: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
1423: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
1424: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
1425: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
1426: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
1427: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
1428: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
1429: ,p_effective_date => l_effective_date

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

1422: ,p_attribute14 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute14')
1423: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
1424: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
1425: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
1426: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
1427: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
1428: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
1429: ,p_effective_date => l_effective_date
1430: ,p_validate => p_validate

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

1423: ,p_attribute15 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute15')
1424: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
1425: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
1426: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
1427: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
1428: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
1429: ,p_effective_date => l_effective_date
1430: ,p_validate => p_validate
1431: ,p_party_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PartyId')

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

1424: ,p_attribute16 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute16')
1425: ,p_attribute17 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute17')
1426: ,p_attribute18 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute18')
1427: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
1428: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
1429: ,p_effective_date => l_effective_date
1430: ,p_validate => p_validate
1431: ,p_party_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PartyId')
1432: ,p_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status',null)

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

1427: ,p_attribute19 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute19')
1428: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
1429: ,p_effective_date => l_effective_date
1430: ,p_validate => p_validate
1431: ,p_party_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PartyId')
1432: ,p_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status',null)
1433: ,p_return_status => l_return_status
1434: ,p_datetrack_update_mode => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DatetrackUpdate',hr_api.g_correction)
1435: );

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

1428: ,p_attribute20 => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Attribute20')
1429: ,p_effective_date => l_effective_date
1430: ,p_validate => p_validate
1431: ,p_party_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PartyId')
1432: ,p_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status',null)
1433: ,p_return_status => l_return_status
1434: ,p_datetrack_update_mode => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DatetrackUpdate',hr_api.g_correction)
1435: );
1436:

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

1430: ,p_validate => p_validate
1431: ,p_party_id => hr_transaction_swi.getNumberValue(l_CommitNode,'PartyId')
1432: ,p_status => hr_transaction_swi.getVarchar2Value(l_CommitNode,'Status',null)
1433: ,p_return_status => l_return_status
1434: ,p_datetrack_update_mode => hr_transaction_swi.getVarchar2Value(l_CommitNode,'DatetrackUpdate',hr_api.g_correction)
1435: );
1436:
1437: elsif l_postState = '3' then
1438:

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

1437: elsif l_postState = '3' then
1438:
1439: delete_competence_element
1440: ( p_validate => p_validate
1441: ,p_competence_element_id => hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceElementId')
1442: ,p_object_version_number => l_object_version_number
1443: ,p_return_status => l_return_status
1444: );
1445:

Line 1453: OPEN get_person_for_comp_element(hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceElementId'));

1449: p_return_status := l_return_status;
1450:
1451: --
1452: -- SSHR Attachment feature changes : 8691102
1453: OPEN get_person_for_comp_element(hr_transaction_swi.getNumberValue(l_CommitNode,'CompetenceElementId'));
1454: FETCH get_person_for_comp_element INTO l_person_id;
1455: CLOSE get_person_for_comp_element;
1456:
1457: hr_utility.set_location('merge_attachments Start : l_person_id = ' || l_person_id || ' ' ||l_proc, 30);