APPS.IRC_APPROVALS dependencies on PER_ALL_VACANCIES

Line 422: from per_all_vacancies

418: --
419: l_retval varchar2(30);
420: cursor get_old_id(p_vacancy_id number) is
421: select organization_id
422: from per_all_vacancies
423: where vacancy_id=p_vacancy_id;
424: begin
425: --
426: irc_approvals.log('Entering get_vac_organization_changed');

Line 467: from per_all_vacancies

463: --
464: l_retval varchar2(30);
465: cursor get_old_id(p_vacancy_id number) is
466: select job_id
467: from per_all_vacancies
468: where vacancy_id=p_vacancy_id;
469: begin
470: --
471: irc_approvals.log('Entering get_vac_job_changed');

Line 510: from per_all_vacancies

506: --
507: l_retval varchar2(30);
508: cursor get_old_id(p_vacancy_id number) is
509: select grade_id
510: from per_all_vacancies
511: where vacancy_id=p_vacancy_id;
512: begin
513: --
514: irc_approvals.log('Entering get_vac_grade_changed');

Line 556: from per_all_vacancies

552: --
553: l_retval varchar2(30);
554: cursor get_old_id(p_vacancy_id number) is
555: select position_id
556: from per_all_vacancies
557: where vacancy_id=p_vacancy_id;
558: begin
559: --
560: irc_approvals.log('Entering get_vac_position_changed');

Line 602: from per_all_vacancies

598: --
599: l_retval varchar2(30);
600: cursor get_old_id(p_vacancy_id number) is
601: select fnd_number.number_to_canonical(budget_measurement_value)
602: from per_all_vacancies
603: where vacancy_id=p_vacancy_id;
604: begin
605: --
606: irc_approvals.log('Entering get_vac_budget_value_changed');

Line 648: from per_all_vacancies

644: --
645: l_retval varchar2(30);
646: cursor get_old_value(p_vacancy_id number) is
647: select budget_measurement_type
648: from per_all_vacancies
649: where vacancy_id=p_vacancy_id;
650: begin
651: --
652: irc_approvals.log('Entering get_vac_budget_type_changed');

Line 694: from per_all_vacancies

690: --
691: l_retval varchar2(30);
692: cursor get_old_value(p_vacancy_id number) is
693: select status
694: from per_all_vacancies
695: where vacancy_id=p_vacancy_id;
696: begin
697: --
698: irc_approvals.log('Entering get_vac_status_changed');

Line 1229: from per_all_vacancies

1225: --
1226: l_retval varchar2(30);
1227: cursor get_old_id(p_vacancy_id number) is
1228: select object_version_number
1229: from per_all_vacancies
1230: where vacancy_id=p_vacancy_id;
1231: begin
1232: --
1233: irc_approvals.log('Entering get_ovn_changed');

Line 1422: l_vacancy_name per_all_vacancies.name%type;

1418: document in out nocopy varchar2,
1419: document_type in out nocopy varchar2,
1420: flowmode in varchar2) is
1421: --
1422: l_vacancy_name per_all_vacancies.name%type;
1423: l_transaction_id hr_api_transactions.transaction_id%type;
1424: l_originators_name per_all_people_f.full_name%type;
1425: --
1426: Begin

Line 1539: l_vacancy_name per_all_vacancies.name%type;

1535: document in out nocopy varchar2,
1536: document_type in out nocopy varchar2,
1537: flowmode in varchar2) is
1538: --
1539: l_vacancy_name per_all_vacancies.name%type;
1540: l_transaction_id hr_api_transactions.transaction_id%type;
1541: l_applicant_name per_all_people_f.full_name%type;
1542: --
1543: Begin

Line 1590: vac_name per_all_vacancies.name%type;

1586:
1587: function getVacancyNameFromId(vacancy_id number)
1588: return varchar
1589: is
1590: vac_name per_all_vacancies.name%type;
1591: cursor vac_name_from_id (vac_id number) is
1592: select name
1593: from per_all_vacancies
1594: where vacancy_id=vac_id;

Line 1593: from per_all_vacancies

1589: is
1590: vac_name per_all_vacancies.name%type;
1591: cursor vac_name_from_id (vac_id number) is
1592: select name
1593: from per_all_vacancies
1594: where vacancy_id=vac_id;
1595: begin
1596:
1597: open vac_name_from_id(vacancy_id);

Line 1608: vac_id per_all_vacancies.vacancy_id%type;

1604:
1605: function getVacancyIdFromAssignmentId(assignment_id number)
1606: return number
1607: is
1608: vac_id per_all_vacancies.vacancy_id%type;
1609: cursor vac_id_from_assn_id (assn_id number) is
1610: select vacancy_id
1611: from per_all_assignments_f
1612: where assignment_id=assn_id;