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_APPROVALS dependencies on IRC_POSTING_CONTENTS_VL

Line 535: from irc_posting_contents_vl

531: l_old_value varchar2(4000);
532: l_retval varchar2(30);
533: cursor get_old_value(p_posting_content_id number) is
534: select name
535: from irc_posting_contents_vl
536: where posting_content_id=p_posting_content_id;
537: begin
538: --
539: irc_vacancy_approvals.show('Entering get_posting_title_changed');

Line 582: from irc_posting_contents_vl

578: l_old_value varchar2(4000);
579: l_retval varchar2(30);
580: cursor get_old_value(p_posting_content_id number) is
581: select job_title
582: from irc_posting_contents_vl
583: where posting_content_id=p_posting_content_id;
584: begin
585: --
586: irc_vacancy_approvals.show('Entering get_posting_job_title_changed');

Line 629: from irc_posting_contents_vl

625: l_old_value varchar2(4000);
626: l_retval varchar2(30);
627: cursor get_old_value(p_posting_content_id number) is
628: select org_name
629: from irc_posting_contents_vl
630: where posting_content_id=p_posting_content_id;
631: begin
632: --
633: irc_vacancy_approvals.show('Entering get_posting_department_changed');

Line 673: l_clob_old_value irc_posting_contents_vl.org_description%type;

669: return varchar2 is
670: l_new_value varchar2(32000);
671: l_posting_content_id number;
672: l_old_value varchar2(32000);
673: l_clob_old_value irc_posting_contents_vl.org_description%type;
674: l_retval varchar2(30);
675: cursor get_old_value(p_posting_content_id number) is
676: select org_description
677: from irc_posting_contents_vl

Line 677: from irc_posting_contents_vl

673: l_clob_old_value irc_posting_contents_vl.org_description%type;
674: l_retval varchar2(30);
675: cursor get_old_value(p_posting_content_id number) is
676: select org_description
677: from irc_posting_contents_vl
678: where posting_content_id=p_posting_content_id;
679: begin
680: --
681: irc_vacancy_approvals.show('Entering get_posting_dept_desc_changed');

Line 723: l_clob_old_value irc_posting_contents_vl.brief_description%type;

719: return varchar2 is
720: l_new_value varchar2(32000);
721: l_posting_content_id number;
722: l_old_value varchar2(32000);
723: l_clob_old_value irc_posting_contents_vl.brief_description%type;
724: l_retval varchar2(30);
725: cursor get_old_value(p_posting_content_id number) is
726: select brief_description
727: from irc_posting_contents_vl

Line 727: from irc_posting_contents_vl

723: l_clob_old_value irc_posting_contents_vl.brief_description%type;
724: l_retval varchar2(30);
725: cursor get_old_value(p_posting_content_id number) is
726: select brief_description
727: from irc_posting_contents_vl
728: where posting_content_id=p_posting_content_id;
729: begin
730: --
731: irc_vacancy_approvals.show('Entering get_brief_description_changed');

Line 773: l_clob_old_value irc_posting_contents_vl.detailed_description%type;

769: return varchar2 is
770: l_new_value varchar2(32000);
771: l_posting_content_id number;
772: l_old_value varchar2(32000);
773: l_clob_old_value irc_posting_contents_vl.detailed_description%type;
774: l_retval varchar2(30);
775: cursor get_old_value(p_posting_content_id number) is
776: select detailed_description
777: from irc_posting_contents_vl

Line 777: from irc_posting_contents_vl

773: l_clob_old_value irc_posting_contents_vl.detailed_description%type;
774: l_retval varchar2(30);
775: cursor get_old_value(p_posting_content_id number) is
776: select detailed_description
777: from irc_posting_contents_vl
778: where posting_content_id=p_posting_content_id;
779: begin
780: --
781: irc_vacancy_approvals.show('Entering get_detailed_desc_changed');

Line 822: l_clob_old_value irc_posting_contents_vl.job_requirements%type;

818: return varchar2 is
819: l_new_value varchar2(32000);
820: l_posting_content_id number;
821: l_old_value varchar2(32000);
822: l_clob_old_value irc_posting_contents_vl.job_requirements%type;
823: l_retval varchar2(30);
824: cursor get_old_value(p_posting_content_id number) is
825: select job_requirements
826: from irc_posting_contents_vl

Line 826: from irc_posting_contents_vl

822: l_clob_old_value irc_posting_contents_vl.job_requirements%type;
823: l_retval varchar2(30);
824: cursor get_old_value(p_posting_content_id number) is
825: select job_requirements
826: from irc_posting_contents_vl
827: where posting_content_id=p_posting_content_id;
828: begin
829: --
830: irc_vacancy_approvals.show('Entering get_job_requirements_changed');

Line 871: l_clob_old_value irc_posting_contents_vl.additional_details%type;

867: return varchar2 is
868: l_new_value varchar2(32000);
869: l_posting_content_id number;
870: l_old_value varchar2(32000);
871: l_clob_old_value irc_posting_contents_vl.additional_details%type;
872: l_retval varchar2(30);
873: cursor get_old_value(p_posting_content_id number) is
874: select additional_details
875: from irc_posting_contents_vl

Line 875: from irc_posting_contents_vl

871: l_clob_old_value irc_posting_contents_vl.additional_details%type;
872: l_retval varchar2(30);
873: cursor get_old_value(p_posting_content_id number) is
874: select additional_details
875: from irc_posting_contents_vl
876: where posting_content_id=p_posting_content_id;
877: begin
878: --
879: irc_vacancy_approvals.show('Entering get_additional_details_changed');

Line 920: l_clob_old_value irc_posting_contents_vl.how_to_apply%type;

916: return varchar2 is
917: l_new_value varchar2(32000);
918: l_posting_content_id number;
919: l_old_value varchar2(32000);
920: l_clob_old_value irc_posting_contents_vl.how_to_apply%type;
921: l_retval varchar2(30);
922: cursor get_old_value(p_posting_content_id number) is
923: select how_to_apply
924: from irc_posting_contents_vl

Line 924: from irc_posting_contents_vl

920: l_clob_old_value irc_posting_contents_vl.how_to_apply%type;
921: l_retval varchar2(30);
922: cursor get_old_value(p_posting_content_id number) is
923: select how_to_apply
924: from irc_posting_contents_vl
925: where posting_content_id=p_posting_content_id;
926: begin
927: --
928: irc_vacancy_approvals.show('Entering get_how_to_apply_changed');

Line 970: l_clob_old_value irc_posting_contents_vl.image_url%type;

966: --
967: l_new_value varchar2(32000);
968: l_posting_content_id number;
969: l_old_value varchar2(32000);
970: l_clob_old_value irc_posting_contents_vl.image_url%type;
971: l_retval varchar2(30);
972: --
973: cursor get_old_value(p_posting_content_id number) is
974: select image_url

Line 975: from irc_posting_contents_vl

971: l_retval varchar2(30);
972: --
973: cursor get_old_value(p_posting_content_id number) is
974: select image_url
975: from irc_posting_contents_vl
976: where posting_content_id=p_posting_content_id;
977: --
978: BEGIN
979: --