APPS.IRC_VACANCY_APPROVALS SQL Statements

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

Line: 25

select transaction_document
from hr_api_transactions
where transaction_id = p_transaction_id;

Line: 218

select organization_id
from per_all_vacancies
where vacancy_id=p_vacancy_id;

Line: 227

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

Line: 263

select job_id
from per_all_vacancies
where vacancy_id=p_vacancy_id;

Line: 272

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

Line: 306

select grade_id
from per_all_vacancies
where vacancy_id=p_vacancy_id;

Line: 315

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

Line: 352

select position_id
from per_all_vacancies
where vacancy_id=p_vacancy_id;

Line: 361

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

Line: 398

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

Line: 407

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

Line: 444

select budget_measurement_type
from per_all_vacancies
where vacancy_id=p_vacancy_id;

Line: 453

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

Line: 490

select status
from per_all_vacancies
where vacancy_id=p_vacancy_id;

Line: 499

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

Line: 534

select name
from irc_posting_contents_vl
where posting_content_id=p_posting_content_id;

Line: 543

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

Line: 581

select job_title
from irc_posting_contents_vl
where posting_content_id=p_posting_content_id;

Line: 590

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

Line: 628

select org_name
from irc_posting_contents_vl
where posting_content_id=p_posting_content_id;

Line: 637

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

Line: 676

select org_description
from irc_posting_contents_vl
where posting_content_id=p_posting_content_id;

Line: 685

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

Line: 726

select brief_description
from irc_posting_contents_vl
where posting_content_id=p_posting_content_id;

Line: 735

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

Line: 776

select detailed_description
from irc_posting_contents_vl
where posting_content_id=p_posting_content_id;

Line: 785

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

Line: 825

select job_requirements
from irc_posting_contents_vl
where posting_content_id=p_posting_content_id;

Line: 834

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

Line: 874

select additional_details
from irc_posting_contents_vl
where posting_content_id=p_posting_content_id;

Line: 883

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

Line: 923

select how_to_apply
from irc_posting_contents_vl
where posting_content_id=p_posting_content_id;

Line: 932

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

Line: 974

select image_url
  from irc_posting_contents_vl
 where posting_content_id=p_posting_content_id;

Line: 984

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