APPS.IRC_APPROVALS SQL Statements

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

Line: 27

select transaction_document
from hr_api_transactions
where transaction_id = p_transaction_id;

Line: 421

select organization_id
from per_all_vacancies
where vacancy_id=p_vacancy_id;

Line: 430

if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then
--
  l_new_id := irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'OrganizationId');

Line: 466

select job_id
from per_all_vacancies
where vacancy_id=p_vacancy_id;

Line: 475

if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then
  l_vacancy_id:=irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'VacancyId');

Line: 509

select grade_id
from per_all_vacancies
where vacancy_id=p_vacancy_id;

Line: 518

if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then
--
  l_new_id:=irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'GradeId');

Line: 555

select position_id
from per_all_vacancies
where vacancy_id=p_vacancy_id;

Line: 564

if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then
--
  l_new_id     := irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'PositionId');

Line: 601

select fnd_number.number_to_canonical(budget_measurement_value)
from per_all_vacancies
where vacancy_id=p_vacancy_id;

Line: 610

if irc_approvals.get_transaction_mode(transaction_id)<>'INSERT' then
--
  l_new_id:=irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'BudgetMeasurementValue');

Line: 647

select budget_measurement_type
from per_all_vacancies
where vacancy_id=p_vacancy_id;

Line: 656

if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then
--
  l_new_value:=irc_approvals.get_vacancy_data_varchar(transaction_id=>transaction_id,data_name=>'BudgetMeasurementType');

Line: 693

select status
from per_all_vacancies
where vacancy_id=p_vacancy_id;

Line: 702

if irc_approvals.get_transaction_mode(transaction_id)<> 'INSERT' then
--
  l_new_value:=irc_approvals.get_vacancy_data_varchar(transaction_id=>transaction_id,data_name=>'Status');

Line: 737

select name
from irc_posting_contents_vl
where posting_content_id=p_posting_content_id;

Line: 746

if irc_approvals.get_transaction_mode(transaction_id)<> 'INSERT' then
--
  l_posting_content_id := irc_approvals.get_posting_data_number
    (transaction_id=>transaction_id, data_name=>'PostingContentId');

Line: 784

select job_title
from irc_posting_contents_vl
where posting_content_id=p_posting_content_id;

Line: 793

if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then
--
  l_posting_content_id := irc_approvals.get_posting_data_number
    (transaction_id=>transaction_id, data_name=>'PostingContentId');

Line: 831

select org_name
from irc_posting_contents_vl
where posting_content_id=p_posting_content_id;

Line: 840

if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then
--
  l_posting_content_id := irc_approvals.get_posting_data_number
    (transaction_id=>transaction_id, data_name=>'PostingContentId');

Line: 879

select org_description
from irc_posting_contents_vl
where posting_content_id=p_posting_content_id;

Line: 888

if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then
--
  l_posting_content_id := irc_approvals.get_posting_data_number
    (transaction_id=>transaction_id, data_name=>'PostingContentId');

Line: 929

select brief_description
from irc_posting_contents_vl
where posting_content_id=p_posting_content_id;

Line: 938

if irc_approvals.get_transaction_mode(transaction_id)<> 'INSERT' then
--
  l_posting_content_id := irc_approvals.get_posting_data_number
    (transaction_id=>transaction_id, data_name=>'PostingContentId');

Line: 979

select detailed_description
from irc_posting_contents_vl
where posting_content_id=p_posting_content_id;

Line: 988

if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then
--
  l_posting_content_id := irc_approvals.get_posting_data_number
    (transaction_id=>transaction_id, data_name=>'PostingContentId');

Line: 1028

select job_requirements
from irc_posting_contents_vl
where posting_content_id=p_posting_content_id;

Line: 1037

if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then
--
  l_posting_content_id := irc_approvals.get_posting_data_number
    (transaction_id=>transaction_id, data_name=>'PostingContentId');

Line: 1077

select additional_details
from irc_posting_contents_vl
where posting_content_id=p_posting_content_id;

Line: 1086

if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then
--
  l_posting_content_id := irc_approvals.get_posting_data_number
    (transaction_id=>transaction_id, data_name=>'PostingContentId');

Line: 1126

select how_to_apply
from irc_posting_contents_vl
where posting_content_id=p_posting_content_id;

Line: 1135

if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then
--
  l_posting_content_id := irc_approvals.get_posting_data_number
    (transaction_id=>transaction_id, data_name=>'PostingContentId');

Line: 1177

select image_url
  from irc_posting_contents_vl
 where posting_content_id=p_posting_content_id;

Line: 1187

if irc_approvals.get_transaction_mode(transaction_id)<> 'INSERT' then
--
  l_new_value := irc_approvals.get_posting_data_varchar
    (transaction_id=>transaction_id ,data_name => 'ImageUrl');

Line: 1228

select object_version_number
from per_all_vacancies
where vacancy_id=p_vacancy_id;

Line: 1237

if irc_approvals.get_transaction_mode(transaction_id) <> 'INSERT' then
--
  l_new_id:=irc_approvals.get_vacancy_data_number(transaction_id=>transaction_id,data_name=>'ObjectVersionNumber');

Line: 1275

select supervisor_id
 from per_all_assignments_f
 where person_id = c_person_id
 and primary_flag = 'Y'
 and trunc(sysdate)
 between effective_start_date
 and effective_end_date;

Line: 1284

select creator_person_id
 from hr_api_transactions
where transaction_id = c_transaction_id;

Line: 1415

      fnd_message.set_name('PER','IRC_VACANCY_APPROVAL_UPDATE');

Line: 1460

  is   select full_name
         from per_all_people_f papf
        where papf.person_id = p_person_id
          and trunc(sysdate) between effective_start_date
          and effective_end_date;

Line: 1515

    ,flowmode      => 'UPDATE');

Line: 1540

      fnd_message.set_name('PER','IRC_UPDATE_OFFER_APPROVAL');

Line: 1586

    select name
    from per_all_vacancies
    where vacancy_id=vac_id;

Line: 1604

    select vacancy_id
    from per_all_assignments_f
    where assignment_id=assn_id;