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.IRC_VACANCY_COMMIT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 105


   hr_wip_txns.delete_transaction(
        p_item_type  => itemtype
       ,p_item_key   => itemkey);

Line: 121


procedure commit_insert (itemtype in varchar2,
                         itemkey in varchar2,
                         actid in number,
                         funcmode in varchar2,
                         resultout out nocopy varchar2) is
--
  transaction_number number;

Line: 155


hr_utility.trace('Entering commit_insert for :' || itemtype || '-' || itemkey || ':');

Line: 177


  select transaction_id
    into transaction_number
    from hr_wip_transactions
   where item_key = itemkey
     and item_type = itemtype;

Line: 187


  select vo_cache
    into xmlClob
    from hr_wip_transactions
   where transaction_id = transaction_number;

Line: 199


hr_utility.trace('Inserting PER_REQUISITIONS records');

Line: 207


hr_utility.trace('ERROR Inserting PER_REQUISITIONS records');

Line: 212


hr_utility.trace('Inserting IRC_POSTING_CONTENTS records');

Line: 220


hr_utility.trace('ERROR Inserting IRC_POSTING_CONTENTS records');

Line: 225


hr_utility.trace('Inserting PER_ALL_VACANCIES records');

Line: 233


hr_utility.trace('ERROR Inserting PER_ALL_VACANCIES records');

Line: 238


hr_utility.trace('Inserting IRC_SEARCH_CRITERIA records');

Line: 246


hr_utility.trace('ERROR Inserting IRC_SEARCH_CRITERIA records');

Line: 251


hr_utility.trace('Inserting IRC_VARIABLE_COMP_ELEMENTS records');

Line: 259


hr_utility.trace('ERROR Inserting IRC_VARIABLE_COMP_ELEMENTS records');

Line: 264


hr_utility.trace('Inserting PER_COMPETENCE_ELEMENTS records');

Line: 272


hr_utility.trace('ERROR Inserting PER_COMPETENCE_ELEMENTS records');

Line: 277


hr_utility.trace('Inserting IRC_REC_TEAM_MEMBERS records');

Line: 285


hr_utility.trace('ERROR Inserting IRC_REC_TEAM_MEMBERS records');

Line: 290


hr_utility.trace('Inserting IRC_AGENCY_VACANCY records');

Line: 298


hr_utility.trace('ERROR Inserting IRC_AGENCY_VACANCY records');

Line: 303


hr_utility.trace('Inserting PER_RECRUITMENT_ACTIVITIES records');

Line: 319


hr_utility.trace('ERROR Inserting PER_RECRUITMENT_ACTIVITIES records');

Line: 324


hr_utility.trace('Inserting PER_RECRUITMENT_ACTIVITY_FOR records');

Line: 332


hr_utility.trace('ERROR Inserting PER_RECRUITMENT_ACTIVITY_FOR records');

Line: 355


    hr_wip_txns.delete_transaction(
         p_item_type  => itemtype
        ,p_item_key   => itemkey);

Line: 362


hr_utility.trace('Exiting commit_insert');

Line: 388


END commit_insert;

Line: 397


procedure commit_update (itemtype in varchar2,
                         itemkey in varchar2,
                         actid in number,
                         funcmode in varchar2,
                         resultout out nocopy varchar2) is
--
  transaction_number number;

Line: 427


hr_utility.trace('Entering commit_update');

Line: 448


  select transaction_id
    into transaction_number
    from hr_wip_transactions
   where item_key = itemkey
     and item_type = itemtype;

Line: 458


  select vo_cache
    into xmlClob
    from hr_wip_transactions
   where transaction_id = transaction_number;

Line: 694


    hr_wip_txns.delete_transaction(
         p_item_type  => itemtype
        ,p_item_key   => itemkey);

Line: 701


hr_utility.trace('Exiting commit_update');

Line: 726


END commit_update;

Line: 807


per_requisitions_swi.delete_requisition (
   P_REQUISITION_ID        => valueOf(commitNode,'RequisitionId')
  ,P_OBJECT_VERSION_NUMBER => l_object_version_number
  ,P_RETURN_STATUS          => l_return_status
  ,P_VALIDATE              => valueOf(commitNode,''));

Line: 841


per_requisitions_swi.update_requisition (
   P_REQUISITION_ID       => valueOf(commitNode,'RequisitionId')
  ,P_OBJECT_VERSION_NUMBER => l_object_version_number
  ,P_DATE_FROM            => date_value(valueOf(commitNode,'DateFrom'))
  ,P_PERSON_ID            => valueOf(commitNode,'PersonId')
  ,P_COMMENTS             => valueOf(commitNode,'Comments')
  ,P_DATE_TO              => date_value(valueOf(commitNode,'DateTo'))
  ,P_DESCRIPTION          => valueOf(commitNode,'Description')
  ,P_ATTRIBUTE_CATEGORY => valueOf(commitNode,'AttributeCategory')
  ,P_ATTRIBUTE1           => valueOf(commitNode,'Attribute1')
  ,P_ATTRIBUTE2           => valueOf(commitNode,'Attribute2')
  ,P_ATTRIBUTE3           => valueOf(commitNode,'Attribute3')
  ,P_ATTRIBUTE4           => valueOf(commitNode,'Attribute4')
  ,P_ATTRIBUTE5           => valueOf(commitNode,'Attribute5')
  ,P_ATTRIBUTE6           => valueOf(commitNode,'Attribute6')
  ,P_ATTRIBUTE7           => valueOf(commitNode,'Attribute7')
  ,P_ATTRIBUTE8           => valueOf(commitNode,'Attribute8')
  ,P_ATTRIBUTE9           => valueOf(commitNode,'Attribute9')
  ,P_ATTRIBUTE10          => valueOf(commitNode,'Attribute10')
  ,P_ATTRIBUTE11          => valueOf(commitNode,'Attribute11')
  ,P_ATTRIBUTE12          => valueOf(commitNode,'Attribute12')
  ,P_ATTRIBUTE13          => valueOf(commitNode,'Attribute13')
  ,P_ATTRIBUTE14          => valueOf(commitNode,'Attribute14')
  ,P_ATTRIBUTE15          => valueOf(commitNode,'Attribute15')
  ,P_ATTRIBUTE16          => valueOf(commitNode,'Attribute16')
  ,P_ATTRIBUTE17          => valueOf(commitNode,'Attribute17')
  ,P_ATTRIBUTE18          => valueOf(commitNode,'Attribute18')
  ,P_ATTRIBUTE19          => valueOf(commitNode,'Attribute19')
  ,P_ATTRIBUTE20          => valueOf(commitNode,'Attribute20')
  ,P_RETURN_STATUS        => l_return_status
  ,P_VALIDATE             => g_validate);

Line: 988


per_vacancy_swi.UPDATE_VACANCY (
   P_VACANCY_ID                   => valueOf(commitNode,'VacancyId')
  ,P_OBJECT_VERSION_NUMBER        => l_object_version_number
  ,P_DATE_FROM                    => date_value(valueOf(commitNode,'DateFrom'))
  ,P_POSITION_ID                  => valueOf(commitNode,'PositionId')
  ,P_JOB_ID                       => valueOf(commitNode,'JobId')
  ,P_GRADE_ID                     => valueOf(commitNode,'GradeId')
  ,P_ORGANIZATION_ID              => valueOf(commitNode,'OrganizationId')
  ,P_PEOPLE_GROUP_ID              => valueOf(commitNode,'PeopleGroupId')
  ,P_LOCATION_ID                  => valueOf(commitNode,'LocationId')
  ,P_RECRUITER_ID                 => valueOf(commitNode,'RecruiterId')
  ,P_DATE_TO                      => date_value(valueOf(commitNode,'DateTo'))
  ,P_SECURITY_METHOD              => valueOf(commitNode,'SecurityMethod')
  ,P_DESCRIPTION                  => valueOf(commitNode,'Description')
  ,P_NUMBER_OF_OPENINGS           => valueOf(commitNode,'NumberOfOpenings')
  ,P_STATUS                       => status
  ,P_BUDGET_MEASUREMENT_TYPE      => valueOf(commitNode,'BudgetMeasurementType')
  ,P_BUDGET_MEASUREMENT_VALUE     => valueOf(commitNode,'BudgetMeasurementValue')
  ,P_VACANCY_CATEGORY             => valueOf(commitNode,'VacancyCategory')
  ,P_MANAGER_ID                   => valueOf(commitNode,'ManagerId')
  ,P_PRIMARY_POSTING_ID           => valueOf(commitNode,'PrimaryPostingId')
  ,P_ASSESSMENT_ID                => valueOf(commitNode,'AssessmentId')
  ,P_ATTRIBUTE_CATEGORY           => valueOf(commitNode,'AttributeCategory')
  ,P_ATTRIBUTE1                   => valueOf(commitNode,'Attribute1')
  ,P_ATTRIBUTE2                   => valueOf(commitNode,'Attribute2')
  ,P_ATTRIBUTE3                   => valueOf(commitNode,'Attribute3')
  ,P_ATTRIBUTE4                   => valueOf(commitNode,'Attribute4')
  ,P_ATTRIBUTE5                   => valueOf(commitNode,'Attribute5')
  ,P_ATTRIBUTE6                   => valueOf(commitNode,'Attribute6')
  ,P_ATTRIBUTE7                   => valueOf(commitNode,'Attribute7')
  ,P_ATTRIBUTE8                   => valueOf(commitNode,'Attribute8')
  ,P_ATTRIBUTE9                   => valueOf(commitNode,'Attribute9')
  ,P_ATTRIBUTE10                  => valueOf(commitNode,'Attribute10')
  ,P_ATTRIBUTE11                  => valueOf(commitNode,'Attribute11')
  ,P_ATTRIBUTE12                  => valueOf(commitNode,'Attribute12')
  ,P_ATTRIBUTE13                  => valueOf(commitNode,'Attribute13')
  ,P_ATTRIBUTE14                  => valueOf(commitNode,'Attribute14')
  ,P_ATTRIBUTE15                  => valueOf(commitNode,'Attribute15')
  ,P_ATTRIBUTE16                  => valueOf(commitNode,'Attribute16')
  ,P_ATTRIBUTE17                  => valueOf(commitNode,'Attribute17')
  ,P_ATTRIBUTE18                  => valueOf(commitNode,'Attribute18')
  ,P_ATTRIBUTE19                  => valueOf(commitNode,'Attribute19')
  ,P_ATTRIBUTE20                  => valueOf(commitNode,'Attribute20')
  ,P_ASSIGNMENT_CHANGED           => l_assignment_changed
  ,P_RETURN_STATUS                => l_return_status
  ,P_VALIDATE                     => g_validate
  ,P_EFFECTIVE_DATE               => l_effective_date);

Line: 1178


irc_search_criteria_swi.delete_vacancy_criteria (
   P_SEARCH_CRITERIA_ID    => valueOf(commitNode,'SearchCriteriaId')
  ,P_OBJECT_VERSION_NUMBER => l_object_version_number
  ,P_RETURN_STATUS         => l_return_status
  ,P_VALIDATE              => g_validate);

Line: 1213


irc_search_criteria_swi.update_vacancy_criteria (
   P_VACANCY_ID               => valueOf(commitNode,'ObjectId')
  ,P_EFFECTIVE_DATE           => l_effective_date
  ,P_LOCATION                 => valueOf(commitNode,'Location')
  ,P_EMPLOYEE                 => valueOf(commitNode,'Employee')
  ,P_CONTRACTOR               => valueOf(commitNode,'Contractor')
  ,P_EMPLOYMENT_CATEGORY      => valueOf(commitNode,'EmploymentCategory')
  ,P_KEYWORDS                 => valueOf(commitNode,'Keywords')
  ,P_TRAVEL_PERCENTAGE        => valueOf(commitNode,'TravelPercentage')
  ,P_MIN_SALARY               => valueOf(commitNode,'MinSalary')
  ,P_MAX_SALARY               => valueOf(commitNode,'MaxSalary')
  ,P_SALARY_CURRENCY          => valueOf(commitNode,'SalaryCurrency')
  ,P_SALARY_PERIOD            => valueOf(commitNode,'SalaryPeriod')
  ,P_PROFESSIONAL_AREA        => valueOf(commitNode,'ProfessionalArea')
  ,P_WORK_AT_HOME             => valueOf(commitNode,'WorkAtHome')
  ,P_MIN_QUAL_LEVEL           => valueOf(commitNode,'MinQualLevel')
  ,P_MAX_QUAL_LEVEL           => valueOf(commitNode,'MaxQualLevel')
  ,P_ATTRIBUTE_CATEGORY       => valueOf(commitNode,'AttributeCategory')
  ,P_ATTRIBUTE1               => valueOf(commitNode,'Attribute1')
  ,P_ATTRIBUTE2               => valueOf(commitNode,'Attribute2')
  ,P_ATTRIBUTE3               => valueOf(commitNode,'Attribute3')
  ,P_ATTRIBUTE4               => valueOf(commitNode,'Attribute4')
  ,P_ATTRIBUTE5               => valueOf(commitNode,'Attribute5')
  ,P_ATTRIBUTE6               => valueOf(commitNode,'Attribute6')
  ,P_ATTRIBUTE7               => valueOf(commitNode,'Attribute7')
  ,P_ATTRIBUTE8               => valueOf(commitNode,'Attribute8')
  ,P_ATTRIBUTE9               => valueOf(commitNode,'Attribute9')
  ,P_ATTRIBUTE10              => valueOf(commitNode,'Attribute10')
  ,P_ATTRIBUTE11              => valueOf(commitNode,'Attribute11')
  ,P_ATTRIBUTE12              => valueOf(commitNode,'Attribute12')
  ,P_ATTRIBUTE13              => valueOf(commitNode,'Attribute13')
  ,P_ATTRIBUTE14              => valueOf(commitNode,'Attribute14')
  ,P_ATTRIBUTE15              => valueOf(commitNode,'Attribute15')
  ,P_ATTRIBUTE16              => valueOf(commitNode,'Attribute16')
  ,P_ATTRIBUTE17              => valueOf(commitNode,'Attribute17')
  ,P_ATTRIBUTE18              => valueOf(commitNode,'Attribute18')
  ,P_ATTRIBUTE19              => valueOf(commitNode,'Attribute19')
  ,P_ATTRIBUTE20              => valueOf(commitNode,'Attribute20')
  ,P_ATTRIBUTE21              => valueOf(commitNode,'Attribute21')
  ,P_ATTRIBUTE22              => valueOf(commitNode,'Attribute22')
  ,P_ATTRIBUTE23              => valueOf(commitNode,'Attribute23')
  ,P_ATTRIBUTE24              => valueOf(commitNode,'Attribute24')
  ,P_ATTRIBUTE25              => valueOf(commitNode,'Attribute25')
  ,P_ATTRIBUTE26              => valueOf(commitNode,'Attribute26')
  ,P_ATTRIBUTE27              => valueOf(commitNode,'Attribute27')
  ,P_ATTRIBUTE28              => valueOf(commitNode,'Attribute28')
  ,P_ATTRIBUTE29              => valueOf(commitNode,'Attribute29')
  ,P_ATTRIBUTE30              => valueOf(commitNode,'Attribute30')
  ,P_ISC_INFORMATION_CATEGORY => valueOf(commitNode,'IscInformationCategory')
  ,P_ISC_INFORMATION1         => valueOf(commitNode,'IscInformation1')
  ,P_ISC_INFORMATION2         => valueOf(commitNode,'IscInformation2')
  ,P_ISC_INFORMATION3         => valueOf(commitNode,'IscInformation3')
  ,P_ISC_INFORMATION4         => valueOf(commitNode,'IscInformation4')
  ,P_ISC_INFORMATION5         => valueOf(commitNode,'IscInformation5')
  ,P_ISC_INFORMATION6         => valueOf(commitNode,'IscInformation6')
  ,P_ISC_INFORMATION7         => valueOf(commitNode,'IscInformation7')
  ,P_ISC_INFORMATION8         => valueOf(commitNode,'IscInformation8')
  ,P_ISC_INFORMATION9         => valueOf(commitNode,'IscInformation9')
  ,P_ISC_INFORMATION10        => valueOf(commitNode,'IscInformation10')
  ,P_ISC_INFORMATION11        => valueOf(commitNode,'IscInformation11')
  ,P_ISC_INFORMATION12        => valueOf(commitNode,'IscInformation12')
  ,P_ISC_INFORMATION13        => valueOf(commitNode,'IscInformation13')
  ,P_ISC_INFORMATION14        => valueOf(commitNode,'IscInformation14')
  ,P_ISC_INFORMATION15        => valueOf(commitNode,'IscInformation15')
  ,P_ISC_INFORMATION16        => valueOf(commitNode,'IscInformation16')
  ,P_ISC_INFORMATION17        => valueOf(commitNode,'IscInformation17')
  ,P_ISC_INFORMATION18        => valueOf(commitNode,'IscInformation18')
  ,P_ISC_INFORMATION19        => valueOf(commitNode,'IscInformation19')
  ,P_ISC_INFORMATION20        => valueOf(commitNode,'IscInformation20')
  ,P_ISC_INFORMATION21        => valueOf(commitNode,'IscInformation21')
  ,P_ISC_INFORMATION22        => valueOf(commitNode,'IscInformation22')
  ,P_ISC_INFORMATION23        => valueOf(commitNode,'IscInformation23')
  ,P_ISC_INFORMATION24        => valueOf(commitNode,'IscInformation24')
  ,P_ISC_INFORMATION25        => valueOf(commitNode,'IscInformation25')
  ,P_ISC_INFORMATION26        => valueOf(commitNode,'IscInformation26')
  ,P_ISC_INFORMATION27        => valueOf(commitNode,'IscInformation27')
  ,P_ISC_INFORMATION28        => valueOf(commitNode,'IscInformation28')
  ,P_ISC_INFORMATION29        => valueOf(commitNode,'IscInformation29')
  ,P_ISC_INFORMATION30        => valueOf(commitNode,'IscInformation30')
  ,P_OBJECT_VERSION_NUMBER    => l_object_version_number
  ,P_RETURN_STATUS            => l_return_status
  ,P_VALIDATE                 => g_validate
  ,P_SEARCH_CRITERIA_ID       => valueOf(commitNode,'SearchCriteriaId')
  ,P_DESCRIPTION              => valueOf(commitNode,'Description'));

Line: 1416


hr_competence_element_swi.update_competence_element (
   P_COMPETENCE_ELEMENT_ID       => valueOf(commitNode,'CompetenceElementId')
  ,P_OBJECT_VERSION_NUMBER       => l_object_version_number
  ,P_PROFICIENCY_LEVEL_ID        => valueOf(commitNode,'ProficiencyLevelId')
  ,P_HIGH_PROFICIENCY_LEVEL_ID   => valueOf(commitNode,'HighProficiencyLevelId')
  ,P_WEIGHTING_LEVEL_ID          => valueOf(commitNode,'WeightingLevelId')
  ,P_RATING_LEVEL_ID             => valueOf(commitNode,'RatingLevelId')
  ,P_MANDATORY                   => valueOf(commitNode,'Mandatory')
  ,P_EFFECTIVE_DATE_FROM         => date_value(valueOf(commitNode,'EffectiveDateFrom'))
  ,P_EFFECTIVE_DATE_TO           => date_value(valueOf(commitNode,'EffectiveDateTo'))
  ,P_GROUP_COMPETENCE_TYPE       => valueOf(commitNode,'GroupCompetenceType')
  ,P_COMPETENCE_TYPE             => valueOf(commitNode,'CompetenceType')
  ,P_NORMAL_ELAPSE_DURATION      => valueOf(commitNode,'NormalElapseDuration')
  ,P_NORMAL_ELAPSE_DURATION_UNIT => valueOf(commitNode,'NormalElapseDurationUnit')
  ,P_SEQUENCE_NUMBER             => valueOf(commitNode,'SequenceNumber')
  ,P_SOURCE_OF_PROFICIENCY_LEVEL => valueOf(commitNode,'SourceOfProficiencyLevel')
  ,P_LINE_SCORE                  => valueOf(commitNode,'LineScore')
  ,P_CERTIFICATION_DATE          => date_value(valueOf(commitNode,'CertificationDate'))
  ,P_CERTIFICATION_METHOD        => valueOf(commitNode,'CertificationMethod')
  ,P_NEXT_CERTIFICATION_DATE     => date_value(valueOf(commitNode,'NextCertificationDate'))
  ,P_COMMENTS                    => valueOf(commitNode,'Comments')
  ,P_ATTRIBUTE_CATEGORY          => valueOf(commitNode,'AttributeCategory')
  ,P_ATTRIBUTE1                  => valueOf(commitNode,'Attribute1')
  ,P_ATTRIBUTE2                  => valueOf(commitNode,'Attribute2')
  ,P_ATTRIBUTE3                  => valueOf(commitNode,'Attribute3')
  ,P_ATTRIBUTE4                  => valueOf(commitNode,'Attribute4')
  ,P_ATTRIBUTE5                  => valueOf(commitNode,'Attribute5')
  ,P_ATTRIBUTE6                  => valueOf(commitNode,'Attribute6')
  ,P_ATTRIBUTE7                  => valueOf(commitNode,'Attribute7')
  ,P_ATTRIBUTE8                  => valueOf(commitNode,'Attribute8')
  ,P_ATTRIBUTE9                  => valueOf(commitNode,'Attribute9')
  ,P_ATTRIBUTE10                 => valueOf(commitNode,'Attribute10')
  ,P_ATTRIBUTE11                 => valueOf(commitNode,'Attribute11')
  ,P_ATTRIBUTE12                 => valueOf(commitNode,'Attribute12')
  ,P_ATTRIBUTE13                 => valueOf(commitNode,'Attribute13')
  ,P_ATTRIBUTE14                 => valueOf(commitNode,'Attribute14')
  ,P_ATTRIBUTE15                 => valueOf(commitNode,'Attribute15')
  ,P_ATTRIBUTE16                 => valueOf(commitNode,'Attribute16')
  ,P_ATTRIBUTE17                 => valueOf(commitNode,'Attribute17')
  ,P_ATTRIBUTE18                 => valueOf(commitNode,'Attribute18')
  ,P_ATTRIBUTE19                 => valueOf(commitNode,'Attribute19')
  ,P_ATTRIBUTE20                 => valueOf(commitNode,'Attribute20')
  ,P_EFFECTIVE_DATE              => l_effective_date
  ,P_PARTY_ID                    => valueOf(commitNode,'PartyId')
  ,P_RETURN_STATUS               => l_return_status
  ,P_VALIDATE                    => g_validate
  ,P_COMPETENCE_ID               => valueOf(commitNode,'CompetenceId'));

Line: 1490


hr_competence_element_swi.delete_competence_element (
   P_COMPETENCE_ELEMENT_ID => valueOf(commitNode,'CompetenceElementId')
  ,P_OBJECT_VERSION_NUMBER => l_object_version_number
  ,P_RETURN_STATUS          => l_return_status
  ,P_VALIDATE              => g_validate);

Line: 1557


irc_variable_comp_element_swi.delete_variable_compensation (
   P_VACANCY_ID            => valueOf(commitNode,'VacancyId')
  ,P_VARIABLE_COMP_LOOKUP  => valueOf(commitNode,'LookupCode')
  ,P_OBJECT_VERSION_NUMBER => l_object_version_number
  ,P_RETURN_STATUS          => l_return_status
  ,P_VALIDATE              => g_validate);

Line: 1597


  ,P_UPDATE_ALLOWED        => valueOf(commitNode,'UpdateAllowed')
  ,P_DELETE_ALLOWED        => valueOf(commitNode,'DeleteAllowed')
  ,P_OBJECT_VERSION_NUMBER => l_object_version_number
  ,P_RETURN_STATUS         => l_return_status
  ,P_VALIDATE              => g_validate);

Line: 1629


irc_rec_team_members_swi.delete_rec_team_member (
   P_REC_TEAM_MEMBER_ID    => valueOf(commitNode,'RecTeamMemberId')
  ,P_OBJECT_VERSION_NUMBER => l_object_version_number
  ,P_RETURN_STATUS         => l_return_status
  ,P_VALIDATE              => g_validate);

Line: 1661


irc_rec_team_members_swi.update_rec_team_member (
   P_REC_TEAM_MEMBER_ID    => valueOf(commitNode,'RecTeamMemberId')
  ,P_PERSON_ID             => valueOf(commitNode,'PersonId')
  ,P_VACANCY_ID            => valueOf(commitNode,'VacancyId')
  ,P_OBJECT_VERSION_NUMBER => l_object_version_number
  ,P_JOB_ID                => valueOf(commitNode,'JobId')
  ,P_START_DATE            => date_value(valueOf(commitNode,'StartDate'))
  ,P_END_DATE              => date_value(valueOf(commitNode,'EndDate'))
  ,P_UPDATE_ALLOWED        => valueOf(commitNode,'UpdateAllowed')
  ,P_DELETE_ALLOWED        => valueOf(commitNode,'DeleteAllowed')
  ,P_RETURN_STATUS          => l_return_status
  ,P_VALIDATE              => g_validate);

Line: 1764


irc_agency_vacancies_swi.delete_agency_vacancy (
   P_AGENCY_VACANCY_ID        => valueOf(commitNode,'AgencyVacancyId')
  ,P_OBJECT_VERSION_NUMBER => l_object_version_number
  ,P_RETURN_STATUS          => l_return_status
  ,P_VALIDATE              => g_validate);

Line: 1795


irc_agency_vacancies_swi.update_agency_vacancy (
   P_AGENCY_ID            => valueOf(commitNode,'AgencyId')
  ,P_VACANCY_ID           => valueOf(commitNode,'VacancyId')
  ,P_START_DATE           => date_value(valueOf(commitNode,'StartDate'))
  ,P_END_DATE             => date_value(valueOf(commitNode,'EndDate'))
  ,P_MAX_ALLOWED_APPLICANTS => valueOf(commitNode,'MaxAllowedApplicants')
  ,P_MANAGE_APPLICANTS_ALLOWED => valueOf(commitNode,'ManageApplicantsAllowed')
  ,P_AGENCY_VACANCY_ID    => valueOf(commitNode,'AgencyVacancyId')
  ,P_OBJECT_VERSION_NUMBER => l_object_version_number
  ,P_ATTRIBUTE_CATEGORY => valueOf(commitNode,'AttributeCategory')
  ,P_ATTRIBUTE1           => valueOf(commitNode,'Attribute1')
  ,P_ATTRIBUTE2           => valueOf(commitNode,'Attribute2')
  ,P_ATTRIBUTE3           => valueOf(commitNode,'Attribute3')
  ,P_ATTRIBUTE4           => valueOf(commitNode,'Attribute4')
  ,P_ATTRIBUTE5           => valueOf(commitNode,'Attribute5')
  ,P_ATTRIBUTE6           => valueOf(commitNode,'Attribute6')
  ,P_ATTRIBUTE7           => valueOf(commitNode,'Attribute7')
  ,P_ATTRIBUTE8           => valueOf(commitNode,'Attribute8')
  ,P_ATTRIBUTE9           => valueOf(commitNode,'Attribute9')
  ,P_ATTRIBUTE10          => valueOf(commitNode,'Attribute10')
  ,P_ATTRIBUTE11          => valueOf(commitNode,'Attribute11')
  ,P_ATTRIBUTE12          => valueOf(commitNode,'Attribute12')
  ,P_ATTRIBUTE13          => valueOf(commitNode,'Attribute13')
  ,P_ATTRIBUTE14          => valueOf(commitNode,'Attribute14')
  ,P_ATTRIBUTE15          => valueOf(commitNode,'Attribute15')
  ,P_ATTRIBUTE16          => valueOf(commitNode,'Attribute16')
  ,P_ATTRIBUTE17          => valueOf(commitNode,'Attribute17')
  ,P_ATTRIBUTE18          => valueOf(commitNode,'Attribute18')
  ,P_ATTRIBUTE19          => valueOf(commitNode,'Attribute19')
  ,P_ATTRIBUTE20          => valueOf(commitNode,'Attribute20')
  ,P_ATTRIBUTE21          => valueOf(commitNode,'Attribute21')
  ,P_ATTRIBUTE22          => valueOf(commitNode,'Attribute22')
  ,P_ATTRIBUTE23          => valueOf(commitNode,'Attribute23')
  ,P_ATTRIBUTE24          => valueOf(commitNode,'Attribute24')
  ,P_ATTRIBUTE25          => valueOf(commitNode,'Attribute25')
  ,P_ATTRIBUTE26          => valueOf(commitNode,'Attribute26')
  ,P_ATTRIBUTE27          => valueOf(commitNode,'Attribute27')
  ,P_ATTRIBUTE28          => valueOf(commitNode,'Attribute28')
  ,P_ATTRIBUTE29          => valueOf(commitNode,'Attribute29')
  ,P_ATTRIBUTE30          => valueOf(commitNode,'Attribute30')
  ,P_RETURN_STATUS        => l_return_status
  ,P_VALIDATE             => g_validate);

Line: 1900


per_rec_activity_for_swi.delete_rec_activity_for (
   P_REC_ACTIVITY_FOR_ID   => valueOf(commitNode,'RecruitmentActivityForId')
  ,P_OBJECT_VERSION_NUMBER => l_object_version_number
  ,P_RETURN_STATUS          => l_return_status
  ,P_VALIDATE              => g_validate);

Line: 1932


per_rec_activity_for_swi.update_rec_activity_for (
   P_REC_ACTIVITY_FOR_ID   => valueOf(commitNode,'RecruitmentActivityForId')
  ,P_VACANCY_ID            => valueOf(commitNode,'VacancyId')
  ,P_REC_ACTIVITY_ID       => valueOf(commitNode,'RecruitmentActivityId')
  ,P_OBJECT_VERSION_NUMBER => l_object_version_number
  ,P_RETURN_STATUS          => l_return_status
  ,P_VALIDATE              => g_validate);

Line: 2039


per_recruitment_activity_swi.delete_recruitment_activity (
   P_OBJECT_VERSION_NUMBER   => l_object_version_number
  ,P_RECRUITMENT_ACTIVITY_ID => valueOf(commitNode,'RecruitmentActivityId')
  ,P_RETURN_STATUS           => l_return_status
  ,P_VALIDATE                => g_validate);

Line: 2071


per_recruitment_activity_swi.update_recruitment_activity (
   P_RECRUITMENT_ACTIVITY_ID     => valueOf(commitNode,'RecruitmentActivityId')
  ,P_AUTHORISING_PERSON_ID       => valueOf(commitNode,'AuthorisingPersonId')
  ,P_RUN_BY_ORGANIZATION_ID      => valueOf(commitNode,'RunByOrganizationId')
  ,P_INTERNAL_CONTACT_PERSON_ID  => valueOf(commitNode,'InternalContactPersonId')
  ,P_PARENT_RECRUITMENT_ACTIVITY => valueOf(commitNode,'ParentRecruitmentActivityId')
  ,P_CURRENCY_CODE               => valueOf(commitNode,'CurrencyCode')
  ,P_DATE_START                  => date_value(valueOf(commitNode,'DateStart'))
  ,P_NAME                        => valueOf(commitNode,'Name')
  ,P_ACTUAL_COST                 => valueOf(commitNode,'ActualCost')
  ,P_COMMENTS                    => valueOf(commitNode,'Comments')
  ,P_CONTACT_TELEPHONE_NUMBER    => valueOf(commitNode,'ContactTelephoneNumber')
  ,P_DATE_CLOSING                => date_value(valueOf(commitNode,'DateClosing'))
  ,P_DATE_END                    => date_value(valueOf(commitNode,'DateEnd'))
  ,P_EXTERNAL_CONTACT            => valueOf(commitNode,'ExternalContact')
  ,P_PLANNED_COST                => valueOf(commitNode,'PlannedCost')
  ,P_TYPE                        => valueOf(commitNode,'Type')
  ,P_ATTRIBUTE_CATEGORY          => valueOf(commitNode,'AttributeCategory')
  ,P_ATTRIBUTE1                  => valueOf(commitNode,'Attribute1')
  ,P_ATTRIBUTE2                  => valueOf(commitNode,'Attribute2')
  ,P_ATTRIBUTE3                  => valueOf(commitNode,'Attribute3')
  ,P_ATTRIBUTE4                  => valueOf(commitNode,'Attribute4')
  ,P_ATTRIBUTE5                  => valueOf(commitNode,'Attribute5')
  ,P_ATTRIBUTE6                  => valueOf(commitNode,'Attribute6')
  ,P_ATTRIBUTE7                  => valueOf(commitNode,'Attribute7')
  ,P_ATTRIBUTE8                  => valueOf(commitNode,'Attribute8')
  ,P_ATTRIBUTE9                  => valueOf(commitNode,'Attribute9')
  ,P_ATTRIBUTE10                 => valueOf(commitNode,'Attribute10')
  ,P_ATTRIBUTE11                 => valueOf(commitNode,'Attribute11')
  ,P_ATTRIBUTE12                 => valueOf(commitNode,'Attribute12')
  ,P_ATTRIBUTE13                 => valueOf(commitNode,'Attribute13')
  ,P_ATTRIBUTE14                 => valueOf(commitNode,'Attribute14')
  ,P_ATTRIBUTE15                 => valueOf(commitNode,'Attribute15')
  ,P_ATTRIBUTE16                 => valueOf(commitNode,'Attribute16')
  ,P_ATTRIBUTE17                 => valueOf(commitNode,'Attribute17')
  ,P_ATTRIBUTE18                 => valueOf(commitNode,'Attribute18')
  ,P_ATTRIBUTE19                 => valueOf(commitNode,'Attribute19')
  ,P_ATTRIBUTE20                 => valueOf(commitNode,'Attribute20')
  ,P_POSTING_CONTENT_ID          => valueOf(commitNode,'PostingContentId')
  ,P_STATUS                      => valueOf(commitNode,'Status')
  ,P_OBJECT_VERSION_NUMBER       => l_object_version_number
  ,P_RETURN_STATUS               => l_return_status
  ,P_VALIDATE                    => g_validate
  ,P_RECRUITING_SITE_ID          => valueOf(commitNode,'RecruitingSiteId')
  ,P_RECRUITING_SITE_RESPONSE    => valueOf(commitNode,'RecruitingSiteResponse'));

Line: 2253


irc_posting_content_swi.delete_posting_content (
   P_POSTING_CONTENT_ID    => valueOf(commitNode,'PostingContentId')
  ,P_OBJECT_VERSION_NUMBER => l_object_version_number
  ,P_RETURN_STATUS          => l_return_status
  ,P_VALIDATE              => g_validate);

Line: 2285


irc_posting_content_swi.update_posting_content (
   P_POSTING_CONTENT_ID     => valueOf(commitNode,'PostingContentId')
  ,P_DISPLAY_MANAGER_INFO   => valueOf(commitNode,'DisplayManagerInfo')
  ,P_DISPLAY_RECRUITER_INFO => valueOf(commitNode,'DisplayRecruiterInfo')
  ,P_NAME                   => valueOf(commitNode,'Name')
  ,P_ORG_NAME               => valueOf(commitNode,'OrgName')
  ,P_ORG_DESCRIPTION        => valueOf(commitNode,'OrgDescription')
  ,P_JOB_TITLE              => valueOf(commitNode,'JobTitle')
  ,P_BRIEF_DESCRIPTION      => valueOf(commitNode,'BriefDescription')
  ,P_DETAILED_DESCRIPTION   => valueOf(commitNode,'DetailedDescription')
  ,P_JOB_REQUIREMENTS       => valueOf(commitNode,'JobRequirements')
  ,P_ADDITIONAL_DETAILS     => valueOf(commitNode,'AdditionalDetails')
  ,P_HOW_TO_APPLY           => valueOf(commitNode,'HowToApply')
  ,P_BENEFIT_INFO           => valueOf(commitNode,'BenefitInfo')
  ,P_IMAGE_URL              => valueOf(commitNode,'ImageUrl')
  ,P_ALT_IMAGE_URL          => valueOf(commitNode,'ImageUrlAlt')
  ,P_ATTRIBUTE_CATEGORY     => valueOf(commitNode,'AttributeCategory')
  ,P_ATTRIBUTE1             => valueOf(commitNode,'Attribute1')
  ,P_ATTRIBUTE2             => valueOf(commitNode,'Attribute2')
  ,P_ATTRIBUTE3             => valueOf(commitNode,'Attribute3')
  ,P_ATTRIBUTE4             => valueOf(commitNode,'Attribute4')
  ,P_ATTRIBUTE5             => valueOf(commitNode,'Attribute5')
  ,P_ATTRIBUTE6             => valueOf(commitNode,'Attribute6')
  ,P_ATTRIBUTE7             => valueOf(commitNode,'Attribute7')
  ,P_ATTRIBUTE8             => valueOf(commitNode,'Attribute8')
  ,P_ATTRIBUTE9             => valueOf(commitNode,'Attribute9')
  ,P_ATTRIBUTE10            => valueOf(commitNode,'Attribute10')
  ,P_ATTRIBUTE11            => valueOf(commitNode,'Attribute11')
  ,P_ATTRIBUTE12            => valueOf(commitNode,'Attribute12')
  ,P_ATTRIBUTE13            => valueOf(commitNode,'Attribute13')
  ,P_ATTRIBUTE14            => valueOf(commitNode,'Attribute14')
  ,P_ATTRIBUTE15            => valueOf(commitNode,'Attribute15')
  ,P_ATTRIBUTE16            => valueOf(commitNode,'Attribute16')
  ,P_ATTRIBUTE17            => valueOf(commitNode,'Attribute17')
  ,P_ATTRIBUTE18            => valueOf(commitNode,'Attribute18')
  ,P_ATTRIBUTE19            => valueOf(commitNode,'Attribute19')
  ,P_ATTRIBUTE20            => valueOf(commitNode,'Attribute20')
  ,P_ATTRIBUTE21            => valueOf(commitNode,'Attribute21')
  ,P_ATTRIBUTE22            => valueOf(commitNode,'Attribute22')
  ,P_ATTRIBUTE23            => valueOf(commitNode,'Attribute23')
  ,P_ATTRIBUTE24            => valueOf(commitNode,'Attribute24')
  ,P_ATTRIBUTE25            => valueOf(commitNode,'Attribute25')
  ,P_ATTRIBUTE26            => valueOf(commitNode,'Attribute26')
  ,P_ATTRIBUTE27            => valueOf(commitNode,'Attribute27')
  ,P_ATTRIBUTE28            => valueOf(commitNode,'Attribute28')
  ,P_ATTRIBUTE29            => valueOf(commitNode,'Attribute29')
  ,P_ATTRIBUTE30            => valueOf(commitNode,'Attribute30')
  ,P_IPC_INFORMATION_CATEGORY => valueOf(commitNode,' IpcInformationCategory')
  ,P_IPC_INFORMATION1       => valueOf(commitNode,'IpcInformation1')
  ,P_IPC_INFORMATION2       => valueOf(commitNode,'IpcInformation2')
  ,P_IPC_INFORMATION3       => valueOf(commitNode,'IpcInformation3')
  ,P_IPC_INFORMATION4       => valueOf(commitNode,'IpcInformation4')
  ,P_IPC_INFORMATION5       => valueOf(commitNode,'IpcInformation5')
  ,P_IPC_INFORMATION6       => valueOf(commitNode,'IpcInformation6')
  ,P_IPC_INFORMATION7       => valueOf(commitNode,'IpcInformation7')
  ,P_IPC_INFORMATION8       => valueOf(commitNode,'IpcInformation8')
  ,P_IPC_INFORMATION9       => valueOf(commitNode,'IpcInformation9')
  ,P_IPC_INFORMATION10      => valueOf(commitNode,'IpcInformation10')
  ,P_IPC_INFORMATION11      => valueOf(commitNode,'IpcInformation11')
  ,P_IPC_INFORMATION12      => valueOf(commitNode,'IpcInformation12')
  ,P_IPC_INFORMATION13      => valueOf(commitNode,'IpcInformation13')
  ,P_IPC_INFORMATION14      => valueOf(commitNode,'IpcInformation14')
  ,P_IPC_INFORMATION15      => valueOf(commitNode,'IpcInformation15')
  ,P_IPC_INFORMATION16      => valueOf(commitNode,'IpcInformation16')
  ,P_IPC_INFORMATION17      => valueOf(commitNode,'IpcInformation17')
  ,P_IPC_INFORMATION18      => valueOf(commitNode,'IpcInformation18')
  ,P_IPC_INFORMATION19      => valueOf(commitNode,'IpcInformation19')
  ,P_IPC_INFORMATION20      => valueOf(commitNode,'IpcInformation20')
  ,P_IPC_INFORMATION21      => valueOf(commitNode,'IpcInformation21')
  ,P_IPC_INFORMATION22      => valueOf(commitNode,'IpcInformation22')
  ,P_IPC_INFORMATION23      => valueOf(commitNode,'IpcInformation23')
  ,P_IPC_INFORMATION24      => valueOf(commitNode,'IpcInformation24')
  ,P_IPC_INFORMATION25      => valueOf(commitNode,'IpcInformation25')
  ,P_IPC_INFORMATION26      => valueOf(commitNode,'IpcInformation26')
  ,P_IPC_INFORMATION27      => valueOf(commitNode,'IpcInformation27')
  ,P_IPC_INFORMATION28      => valueOf(commitNode,'IpcInformation28')
  ,P_IPC_INFORMATION29      => valueOf(commitNode,'IpcInformation29')
  ,P_IPC_INFORMATION30      => valueOf(commitNode,'IpcInformation30')
  ,P_OBJECT_VERSION_NUMBER  => l_object_version_number
  ,P_RETURN_STATUS          => l_return_status
  ,P_VALIDATE               => g_validate
  ,P_DATE_APPROVED          => date_value(valueOf(commitNode,'DateApproved')));

Line: 2431


  select count(*)
    into l_row_count
    from per_competence_elements
   where competence_element_id = l_competence_element_id;

Line: 2460


  select count(*)
    into l_row_count
    from irc_rec_team_members
   where party_id   = l_party_id
     and vacancy_id = l_vacancy_id;

Line: 2486


  select count(*)
    into l_row_count
    from IRC_AGENCY_VACANCIES
   where agency_vacancy_id = l_agency_vacancy_id;

Line: 2513


  select count(*)
    into l_row_count
    from irc_variable_comp_elements
   where vacancy_id   = l_vacancy_id
     and variable_comp_lookup = l_lookup_code;

Line: 2541


  select count(*)
    into l_row_count
    from per_recruitment_activities
   where recruitment_activity_id   = l_recruitment_activity_id;

Line: 2568


  select count(*)
    into l_row_count
    from per_recruitment_activity_for
   where recruitment_activity_for_id   = l_recruitment_activity_for_id;

Line: 2595


  select count(*)
    into l_row_count
    from irc_search_criteria
   where search_criteria_id = l_search_criteria_id;

Line: 2622


  select count(*)
    into l_row_count
    from irc_posting_contents
   where posting_content_id   = l_posting_content_id;

Line: 2672


 select INTERNAL, EXTERNAL, THIRD_PARTY
  from irc_all_recruiting_sites
 where RECRUITING_SITE_ID = c_site_id;