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

Line 738: from irc_posting_contents_vl

734: l_old_value varchar2(4000);
735: l_retval varchar2(30);
736: cursor get_old_value(p_posting_content_id number) is
737: select name
738: from irc_posting_contents_vl
739: where posting_content_id=p_posting_content_id;
740: begin
741: --
742: irc_approvals.log('Entering get_posting_title_changed');

Line 785: from irc_posting_contents_vl

781: l_old_value varchar2(4000);
782: l_retval varchar2(30);
783: cursor get_old_value(p_posting_content_id number) is
784: select job_title
785: from irc_posting_contents_vl
786: where posting_content_id=p_posting_content_id;
787: begin
788: --
789: irc_approvals.log('Entering get_posting_job_title_changed');

Line 832: from irc_posting_contents_vl

828: l_old_value varchar2(4000);
829: l_retval varchar2(30);
830: cursor get_old_value(p_posting_content_id number) is
831: select org_name
832: from irc_posting_contents_vl
833: where posting_content_id=p_posting_content_id;
834: begin
835: --
836: irc_approvals.log('Entering get_posting_department_changed');

Line 876: l_clob_old_value irc_posting_contents_vl.org_description%type;

872: return varchar2 is
873: l_new_value varchar2(32000);
874: l_posting_content_id number;
875: l_old_value varchar2(32000);
876: l_clob_old_value irc_posting_contents_vl.org_description%type;
877: l_retval varchar2(30);
878: cursor get_old_value(p_posting_content_id number) is
879: select org_description
880: from irc_posting_contents_vl

Line 880: from irc_posting_contents_vl

876: l_clob_old_value irc_posting_contents_vl.org_description%type;
877: l_retval varchar2(30);
878: cursor get_old_value(p_posting_content_id number) is
879: select org_description
880: from irc_posting_contents_vl
881: where posting_content_id=p_posting_content_id;
882: begin
883: --
884: irc_approvals.log('Entering get_posting_dept_desc_changed');

Line 926: l_clob_old_value irc_posting_contents_vl.brief_description%type;

922: return varchar2 is
923: l_new_value varchar2(32000);
924: l_posting_content_id number;
925: l_old_value varchar2(32000);
926: l_clob_old_value irc_posting_contents_vl.brief_description%type;
927: l_retval varchar2(30);
928: cursor get_old_value(p_posting_content_id number) is
929: select brief_description
930: from irc_posting_contents_vl

Line 930: from irc_posting_contents_vl

926: l_clob_old_value irc_posting_contents_vl.brief_description%type;
927: l_retval varchar2(30);
928: cursor get_old_value(p_posting_content_id number) is
929: select brief_description
930: from irc_posting_contents_vl
931: where posting_content_id=p_posting_content_id;
932: begin
933: --
934: irc_approvals.log('Entering get_brief_description_changed');

Line 976: l_clob_old_value irc_posting_contents_vl.detailed_description%type;

972: return varchar2 is
973: l_new_value varchar2(32000);
974: l_posting_content_id number;
975: l_old_value varchar2(32000);
976: l_clob_old_value irc_posting_contents_vl.detailed_description%type;
977: l_retval varchar2(30);
978: cursor get_old_value(p_posting_content_id number) is
979: select detailed_description
980: from irc_posting_contents_vl

Line 980: from irc_posting_contents_vl

976: l_clob_old_value irc_posting_contents_vl.detailed_description%type;
977: l_retval varchar2(30);
978: cursor get_old_value(p_posting_content_id number) is
979: select detailed_description
980: from irc_posting_contents_vl
981: where posting_content_id=p_posting_content_id;
982: begin
983: --
984: irc_approvals.log('Entering get_detailed_desc_changed');

Line 1025: l_clob_old_value irc_posting_contents_vl.job_requirements%type;

1021: return varchar2 is
1022: l_new_value varchar2(32000);
1023: l_posting_content_id number;
1024: l_old_value varchar2(32000);
1025: l_clob_old_value irc_posting_contents_vl.job_requirements%type;
1026: l_retval varchar2(30);
1027: cursor get_old_value(p_posting_content_id number) is
1028: select job_requirements
1029: from irc_posting_contents_vl

Line 1029: from irc_posting_contents_vl

1025: l_clob_old_value irc_posting_contents_vl.job_requirements%type;
1026: l_retval varchar2(30);
1027: cursor get_old_value(p_posting_content_id number) is
1028: select job_requirements
1029: from irc_posting_contents_vl
1030: where posting_content_id=p_posting_content_id;
1031: begin
1032: --
1033: irc_approvals.log('Entering get_job_requirements_changed');

Line 1074: l_clob_old_value irc_posting_contents_vl.additional_details%type;

1070: return varchar2 is
1071: l_new_value varchar2(32000);
1072: l_posting_content_id number;
1073: l_old_value varchar2(32000);
1074: l_clob_old_value irc_posting_contents_vl.additional_details%type;
1075: l_retval varchar2(30);
1076: cursor get_old_value(p_posting_content_id number) is
1077: select additional_details
1078: from irc_posting_contents_vl

Line 1078: from irc_posting_contents_vl

1074: l_clob_old_value irc_posting_contents_vl.additional_details%type;
1075: l_retval varchar2(30);
1076: cursor get_old_value(p_posting_content_id number) is
1077: select additional_details
1078: from irc_posting_contents_vl
1079: where posting_content_id=p_posting_content_id;
1080: begin
1081: --
1082: irc_approvals.log('Entering get_additional_details_changed');

Line 1123: l_clob_old_value irc_posting_contents_vl.how_to_apply%type;

1119: return varchar2 is
1120: l_new_value varchar2(32000);
1121: l_posting_content_id number;
1122: l_old_value varchar2(32000);
1123: l_clob_old_value irc_posting_contents_vl.how_to_apply%type;
1124: l_retval varchar2(30);
1125: cursor get_old_value(p_posting_content_id number) is
1126: select how_to_apply
1127: from irc_posting_contents_vl

Line 1127: from irc_posting_contents_vl

1123: l_clob_old_value irc_posting_contents_vl.how_to_apply%type;
1124: l_retval varchar2(30);
1125: cursor get_old_value(p_posting_content_id number) is
1126: select how_to_apply
1127: from irc_posting_contents_vl
1128: where posting_content_id=p_posting_content_id;
1129: begin
1130: --
1131: irc_approvals.log('Entering get_how_to_apply_changed');

Line 1173: l_clob_old_value irc_posting_contents_vl.image_url%type;

1169: --
1170: l_new_value varchar2(32000);
1171: l_posting_content_id number;
1172: l_old_value varchar2(32000);
1173: l_clob_old_value irc_posting_contents_vl.image_url%type;
1174: l_retval varchar2(30);
1175: --
1176: cursor get_old_value(p_posting_content_id number) is
1177: select image_url

Line 1178: from irc_posting_contents_vl

1174: l_retval varchar2(30);
1175: --
1176: cursor get_old_value(p_posting_content_id number) is
1177: select image_url
1178: from irc_posting_contents_vl
1179: where posting_content_id=p_posting_content_id;
1180: --
1181: BEGIN
1182: --