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.GHR_GEN_RPA_NPA dependencies on DBMS_LOB

Line 1027: DBMS_LOB.CREATETEMPORARY(p_xml_string,FALSE,DBMS_LOB.CALL);

1023: l_audit_log_dir varchar2(200);
1024: l_file_name varchar2(50);
1025: p_l_fp UTL_FILE.FILE_TYPE;
1026: BEGIN
1027: DBMS_LOB.CREATETEMPORARY(p_xml_string,FALSE,DBMS_LOB.CALL);
1028: DBMS_LOB.OPEN(p_xml_string,dbms_lob.lob_readwrite);
1029: l_xml_string := '';
1030: DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string);
1031: l_xml_string := l_new_line_sep || '';

Line 1028: DBMS_LOB.OPEN(p_xml_string,dbms_lob.lob_readwrite);

1024: l_file_name varchar2(50);
1025: p_l_fp UTL_FILE.FILE_TYPE;
1026: BEGIN
1027: DBMS_LOB.CREATETEMPORARY(p_xml_string,FALSE,DBMS_LOB.CALL);
1028: DBMS_LOB.OPEN(p_xml_string,dbms_lob.lob_readwrite);
1029: l_xml_string := '';
1030: DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string);
1031: l_xml_string := l_new_line_sep || '';
1032: DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string);

Line 1030: DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string);

1026: BEGIN
1027: DBMS_LOB.CREATETEMPORARY(p_xml_string,FALSE,DBMS_LOB.CALL);
1028: DBMS_LOB.OPEN(p_xml_string,dbms_lob.lob_readwrite);
1029: l_xml_string := '';
1030: DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string);
1031: l_xml_string := l_new_line_sep || '';
1032: DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string);
1033: l_xml_string := l_new_line_sep || '';
1034: DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string);

Line 1032: DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string);

1028: DBMS_LOB.OPEN(p_xml_string,dbms_lob.lob_readwrite);
1029: l_xml_string := '';
1030: DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string);
1031: l_xml_string := l_new_line_sep || '';
1032: DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string);
1033: l_xml_string := l_new_line_sep || '';
1034: DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string);
1035:
1036: IF p_report_name = 'RPA' THEN

Line 1034: DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string);

1030: DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string);
1031: l_xml_string := l_new_line_sep || '';
1032: DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string);
1033: l_xml_string := l_new_line_sep || '';
1034: DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string);
1035:
1036: IF p_report_name = 'RPA' THEN
1037: FOR ctr_rec IN l_rpa_report_tags.FIRST .. l_rpa_report_tags.LAST LOOP
1038: IF l_rpa_report_tags(ctr_rec).tag_name <> 'RemarkSF' THEN

Line 1056: DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string);

1052: l_rpa_report_tags(ctr_rec).par_field_value := REPLACE(l_rpa_report_tags(ctr_rec).par_field_value,'''',''');
1053: END IF;
1054: END IF;
1055: l_xml_string := '' || l_rpa_report_tags(ctr_rec).par_field_value || '';
1056: DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string);
1057: END LOOP;
1058: ELSIF p_report_name = 'NPA' THEN
1059: FOR ctr_rec IN l_npa_report_tags.FIRST .. l_npa_report_tags.LAST LOOP
1060: IF l_npa_report_tags(ctr_rec).tag_name <> 'RemarkSF' THEN

Line 1078: DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string);

1074: l_npa_report_tags(ctr_rec).par_field_value := REPLACE(l_npa_report_tags(ctr_rec).par_field_value,'''',''');
1075: END IF;
1076: END IF;
1077: l_xml_string := '' || l_npa_report_tags(ctr_rec).par_field_value || '';
1078: DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string);
1079: END LOOP;
1080: END IF;
1081: l_xml_string := l_new_line_sep || '';
1082: DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string);

Line 1082: DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string);

1078: DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string);
1079: END LOOP;
1080: END IF;
1081: l_xml_string := l_new_line_sep || '';
1082: DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string);
1083: END;
1084:
1085: PROCEDURE CondPrinting_RPA(p_pa_request_rec_in IN ghr_pa_requests%rowtype,
1086: p_pa_request_rec_out OUT NOCOPY ghr_pa_requests%rowtype)