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 1400: l_vacancy_name per_all_vacancies.name%type;

1396: document in out nocopy varchar2,
1397: document_type in out nocopy varchar2,
1398: flowmode in varchar2) is
1399: --
1400: l_vacancy_name per_all_vacancies.name%type;
1401: l_transaction_id hr_api_transactions.transaction_id%type;
1402: l_originators_name per_all_people_f.full_name%type;
1403: --
1404: Begin

Line 1525: l_vacancy_name per_all_vacancies.name%type;

1521: document in out nocopy varchar2,
1522: document_type in out nocopy varchar2,
1523: flowmode in varchar2) is
1524: --
1525: l_vacancy_name per_all_vacancies.name%type;
1526: l_transaction_id hr_api_transactions.transaction_id%type;
1527: l_applicant_name per_all_people_f.full_name%type;
1528: --
1529: Begin

Line 1584: vac_name per_all_vacancies.name%type;

1580:
1581: function getVacancyNameFromId(vacancy_id number)
1582: return varchar
1583: is
1584: vac_name per_all_vacancies.name%type;
1585: cursor vac_name_from_id (vac_id number) is
1586: select name
1587: from per_all_vacancies
1588: where vacancy_id=vac_id;

Line 1587: from per_all_vacancies

1583: is
1584: vac_name per_all_vacancies.name%type;
1585: cursor vac_name_from_id (vac_id number) is
1586: select name
1587: from per_all_vacancies
1588: where vacancy_id=vac_id;
1589: begin
1590:
1591: open vac_name_from_id(vacancy_id);

Line 1602: vac_id per_all_vacancies.vacancy_id%type;

1598:
1599: function getVacancyIdFromAssignmentId(assignment_id number)
1600: return number
1601: is
1602: vac_id per_all_vacancies.vacancy_id%type;
1603: cursor vac_id_from_assn_id (assn_id number) is
1604: select vacancy_id
1605: from per_all_assignments_f
1606: where assignment_id=assn_id;