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 598: DBMS_LOB.CREATETEMPORARY(p_xml_string,FALSE,DBMS_LOB.CALL);

594: line_count := line_count + 1;
595: END LOOP;
596:
597: /* Added the below code for Bug # 11780976 */
598: DBMS_LOB.CREATETEMPORARY(p_xml_string,FALSE,DBMS_LOB.CALL);
599: DBMS_LOB.OPEN(p_xml_string,dbms_lob.lob_readwrite);
600: l_xml_string := '';
601: DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string);
602: l_xml_string := l_new_line_sep || '';

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

595: END LOOP;
596:
597: /* Added the below code for Bug # 11780976 */
598: DBMS_LOB.CREATETEMPORARY(p_xml_string,FALSE,DBMS_LOB.CALL);
599: DBMS_LOB.OPEN(p_xml_string,dbms_lob.lob_readwrite);
600: l_xml_string := '';
601: DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string);
602: l_xml_string := l_new_line_sep || '';
603: DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string);

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

597: /* Added the below code for Bug # 11780976 */
598: DBMS_LOB.CREATETEMPORARY(p_xml_string,FALSE,DBMS_LOB.CALL);
599: DBMS_LOB.OPEN(p_xml_string,dbms_lob.lob_readwrite);
600: l_xml_string := '';
601: DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string);
602: l_xml_string := l_new_line_sep || '';
603: DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string);
604:
605:

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

599: DBMS_LOB.OPEN(p_xml_string,dbms_lob.lob_readwrite);
600: l_xml_string := '';
601: DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string);
602: l_xml_string := l_new_line_sep || '';
603: DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string);
604:
605:
606: for i in 1..line_count - 2 LOOP
607: conti_remarks_concat := conti_remarks_concat || w_all_remarks(i) || l_new_line_sep;

Line 626: DBMS_LOB.WRITEAPPEND(p_xml_string, length(x_xml_string), x_xml_string);

622: l_rpa_page_count := l_rpa_page_count + 1;
623: l_rem_ctr := 0;
624: Populate_RPAtags(l_pa_request_rec_out,l_rpa_misc_fields,l_signature_rec,conti_remarks_concat,displayCRemarks);
625: WritetoXML('RPA', x_xml_string);
626: DBMS_LOB.WRITEAPPEND(p_xml_string, length(x_xml_string), x_xml_string);
627: conti_remarks_concat := null;
628: end if;
629:
630: /* Bug # 11780976 */

Line 647: DBMS_LOB.WRITEAPPEND(p_xml_string, length(x_xml_string), x_xml_string);

643: end if;
644:
645: Populate_RPAtags(l_pa_request_rec_out,l_rpa_misc_fields,l_signature_rec,conti_remarks_concat,displayCRemarks);
646: WritetoXML('RPA', x_xml_string);
647: DBMS_LOB.WRITEAPPEND(p_xml_string, length(x_xml_string), x_xml_string);
648: end if;
649:
650:
651:

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

649:
650:
651:
652: l_xml_string := l_new_line_sep || '';
653: DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string);
654:
655: /* Bug # 11780976 */
656:
657: END LOOP;

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

1247: BEGIN
1248:
1249: /* Commented for Bug # 11780976. Moved the XML creation to main procedure Generate_NPA/Generate_RPA
1250:
1251: DBMS_LOB.CREATETEMPORARY(p_xml_string,FALSE,DBMS_LOB.CALL);
1252: DBMS_LOB.OPEN(p_xml_string,dbms_lob.lob_readwrite);
1253: l_xml_string := '';
1254: DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string);
1255: l_xml_string := l_new_line_sep || '';

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

1248:
1249: /* Commented for Bug # 11780976. Moved the XML creation to main procedure Generate_NPA/Generate_RPA
1250:
1251: DBMS_LOB.CREATETEMPORARY(p_xml_string,FALSE,DBMS_LOB.CALL);
1252: DBMS_LOB.OPEN(p_xml_string,dbms_lob.lob_readwrite);
1253: l_xml_string := '';
1254: DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string);
1255: l_xml_string := l_new_line_sep || '';
1256: DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string);

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

1250:
1251: DBMS_LOB.CREATETEMPORARY(p_xml_string,FALSE,DBMS_LOB.CALL);
1252: DBMS_LOB.OPEN(p_xml_string,dbms_lob.lob_readwrite);
1253: l_xml_string := '';
1254: DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string);
1255: l_xml_string := l_new_line_sep || '';
1256: DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string);
1257: */
1258: l_xml_string := l_new_line_sep || '';

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

1252: DBMS_LOB.OPEN(p_xml_string,dbms_lob.lob_readwrite);
1253: l_xml_string := '';
1254: DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string);
1255: l_xml_string := l_new_line_sep || '';
1256: DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string);
1257: */
1258: l_xml_string := l_new_line_sep || '';
1259: -- DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string); -- Fix For Bug # 11780976
1260:

Line 1259: -- DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string); -- Fix For Bug # 11780976

1255: l_xml_string := l_new_line_sep || '';
1256: DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string);
1257: */
1258: l_xml_string := l_new_line_sep || '';
1259: -- DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string); -- Fix For Bug # 11780976
1260:
1261: IF p_report_name = 'RPA' THEN
1262: FOR ctr_rec IN l_rpa_report_tags.FIRST .. l_rpa_report_tags.LAST LOOP
1263: IF (l_rpa_report_tags(ctr_rec).tag_name <> 'RemarkSF') and (l_rpa_report_tags(ctr_rec).tag_name <> 'ContRemarkSF') THEN -- Fix For Bug # 11780976

Line 1281: -- DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string); -- Fix For Bug # 11780976

1277: l_rpa_report_tags(ctr_rec).par_field_value := REPLACE(l_rpa_report_tags(ctr_rec).par_field_value,'''',''');
1278: END IF;
1279: END IF;
1280: l_xml_string := l_xml_string || '' || l_rpa_report_tags(ctr_rec).par_field_value || ''; -- Fix For Bug # 11780976
1281: -- DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string); -- Fix For Bug # 11780976
1282: END LOOP;
1283: ELSIF p_report_name = 'NPA' THEN
1284: FOR ctr_rec IN l_npa_report_tags.FIRST .. l_npa_report_tags.LAST LOOP
1285: IF l_npa_report_tags(ctr_rec).tag_name <> 'RemarkSF' THEN

Line 1303: -- DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string); -- Fix For Bug # 11780976

1299: l_npa_report_tags(ctr_rec).par_field_value := REPLACE(l_npa_report_tags(ctr_rec).par_field_value,'''',''');
1300: END IF;
1301: END IF;
1302: l_xml_string := l_xml_string || '' || l_npa_report_tags(ctr_rec).par_field_value || ''; -- Fix For Bug # 11780976
1303: -- DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string); -- Fix For Bug # 11780976
1304: END LOOP;
1305: END IF;
1306: l_xml_string := l_xml_string || l_new_line_sep || ''; -- Fix For Bug # 11780976
1307: -- DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string); -- Fix For Bug # 11780976

Line 1307: -- DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string); -- Fix For Bug # 11780976

1303: -- DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string); -- Fix For Bug # 11780976
1304: END LOOP;
1305: END IF;
1306: l_xml_string := l_xml_string || l_new_line_sep || ''; -- Fix For Bug # 11780976
1307: -- DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string); -- Fix For Bug # 11780976
1308:
1309: p_xml_string:= l_xml_string; -- Fix For Bug # 11780976
1310: END;
1311:

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

2004: line_count := line_count + 1;
2005: END LOOP;
2006:
2007: /* Added the below code for Bug # 11780976 */
2008: DBMS_LOB.CREATETEMPORARY(p_xml_string,FALSE,DBMS_LOB.CALL);
2009: DBMS_LOB.OPEN(p_xml_string,dbms_lob.lob_readwrite);
2010: l_xml_string := '';
2011: DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string);
2012: l_xml_string := l_new_line_sep || '';

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

2005: END LOOP;
2006:
2007: /* Added the below code for Bug # 11780976 */
2008: DBMS_LOB.CREATETEMPORARY(p_xml_string,FALSE,DBMS_LOB.CALL);
2009: DBMS_LOB.OPEN(p_xml_string,dbms_lob.lob_readwrite);
2010: l_xml_string := '';
2011: DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string);
2012: l_xml_string := l_new_line_sep || '';
2013: DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string);

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

2007: /* Added the below code for Bug # 11780976 */
2008: DBMS_LOB.CREATETEMPORARY(p_xml_string,FALSE,DBMS_LOB.CALL);
2009: DBMS_LOB.OPEN(p_xml_string,dbms_lob.lob_readwrite);
2010: l_xml_string := '';
2011: DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string);
2012: l_xml_string := l_new_line_sep || '';
2013: DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string);
2014:
2015:

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

2009: DBMS_LOB.OPEN(p_xml_string,dbms_lob.lob_readwrite);
2010: l_xml_string := '';
2011: DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string);
2012: l_xml_string := l_new_line_sep || '';
2013: DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string);
2014:
2015:
2016: /* Bug # 11780976 */
2017: for i in 1..line_count - 2

Line 2026: DBMS_LOB.WRITEAPPEND(p_xml_string, length(x_xml_string), x_xml_string);

2022: l_npa_page_count := l_npa_page_count + 1;
2023: l_rem_ctr := 0;
2024: Populate_NPAtags(l_pa_request_rec_out,l_npa_misc_fields);
2025: WritetoXML('NPA', x_xml_string);
2026: DBMS_LOB.WRITEAPPEND(p_xml_string, length(x_xml_string), x_xml_string);
2027: l_npa_misc_fields(1).remarks_concat := null;
2028: end if;
2029:
2030: l_rem_ctr := (l_rem_ctr) + 1;

Line 2039: DBMS_LOB.WRITEAPPEND(p_xml_string, length(x_xml_string), x_xml_string);

2035: /* Added the below code for Bug # 11780976 */
2036: if l_rem_ctr > 1 or l_npa_page_count = 1 then
2037: Populate_NPAtags(l_pa_request_rec_out,l_npa_misc_fields);
2038: WritetoXML('NPA', x_xml_string);
2039: DBMS_LOB.WRITEAPPEND(p_xml_string, length(x_xml_string), x_xml_string);
2040: end if;
2041:
2042:
2043: l_xml_string := l_new_line_sep || '';

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

2040: end if;
2041:
2042:
2043: l_xml_string := l_new_line_sep || '';
2044: DBMS_LOB.WRITEAPPEND(p_xml_string, length(l_xml_string), l_xml_string);
2045:
2046:
2047: END LOOP;
2048: