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

Line 982: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);

978: WHEN OTHERS THEN
979: NULL;
980: END;
981: END IF;
982: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
983: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
984: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
985: clob_to_blob(l_xfdf_string,l_xfdf_blob);
986: --Populate parameter labels and values

Line 983: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);

979: NULL;
980: END;
981: END IF;
982: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
983: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
984: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
985: clob_to_blob(l_xfdf_string,l_xfdf_blob);
986: --Populate parameter labels and values
987: /********** COMMENTED ON 3-NOV-05 FOR RTF FORMAT

Line 984: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);

980: END;
981: END IF;
982: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
983: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
984: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
985: clob_to_blob(l_xfdf_string,l_xfdf_blob);
986: --Populate parameter labels and values
987: /********** COMMENTED ON 3-NOV-05 FOR RTF FORMAT
988: gxmltable(gCtr).tagName := 'report_date_label';

Line 993: dbms_lob.writeAppend( l_xfdf_string, length(''),'');

989: gxmltable(gCtr).tagValue := get_lookup_meaning('AE_FORM_LABELS','REPORT_DATE_LABEL');
990: gctr := gctr + 1;
991: etc. etc.
992: END OF COMMENTED ON 3-NOV-05 FOR RTF FORMAT******************************/
993: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
994: l_rep_date_label := '' ||get_lookup_meaning('AE_FORM_LABELS','REPORT_DATE_LABEL')||'';
995: l_rep_date := '' ||fnd_date.date_to_displaydate(sysdate)||'';
996: l_rep_page := ''||get_lookup_meaning('AE_FORM_LABELS','PAGE_NO_LABEL')||'';
997: l_one_value := '' || '1' || '';

Line 1013: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_date_label), l_rep_date_label);

1009: l_str_1 := ''||get_lookup_meaning('AE_FORM_LABELS','DURATION_UNITS_LABEL')||'';
1010: l_str_0 := ''||l_units||'';
1011: l_str_0a := ''||get_lookup_meaning('AE_FORM_LABELS','EFFECTIVE_DATE_LABEL')||'';
1012: l_str_0bb := ''||fnd_date.date_to_displaydate(l_date)||'';
1013: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_date_label), l_rep_date_label);
1014: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_date), l_rep_date);
1015: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_page), l_rep_page);
1016: dbms_lob.writeAppend( l_xfdf_string, length(l_one_value), l_one_value);
1017: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_param_name), l_rep_param_name);

Line 1014: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_date), l_rep_date);

1010: l_str_0 := ''||l_units||'';
1011: l_str_0a := ''||get_lookup_meaning('AE_FORM_LABELS','EFFECTIVE_DATE_LABEL')||'';
1012: l_str_0bb := ''||fnd_date.date_to_displaydate(l_date)||'';
1013: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_date_label), l_rep_date_label);
1014: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_date), l_rep_date);
1015: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_page), l_rep_page);
1016: dbms_lob.writeAppend( l_xfdf_string, length(l_one_value), l_one_value);
1017: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_param_name), l_rep_param_name);
1018: dbms_lob.writeAppend( l_xfdf_string, length(l_str_9), l_str_9);

Line 1015: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_page), l_rep_page);

1011: l_str_0a := ''||get_lookup_meaning('AE_FORM_LABELS','EFFECTIVE_DATE_LABEL')||'';
1012: l_str_0bb := ''||fnd_date.date_to_displaydate(l_date)||'';
1013: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_date_label), l_rep_date_label);
1014: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_date), l_rep_date);
1015: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_page), l_rep_page);
1016: dbms_lob.writeAppend( l_xfdf_string, length(l_one_value), l_one_value);
1017: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_param_name), l_rep_param_name);
1018: dbms_lob.writeAppend( l_xfdf_string, length(l_str_9), l_str_9);
1019: dbms_lob.writeAppend( l_xfdf_string, length(l_str_8), l_str_8);

Line 1016: dbms_lob.writeAppend( l_xfdf_string, length(l_one_value), l_one_value);

1012: l_str_0bb := ''||fnd_date.date_to_displaydate(l_date)||'';
1013: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_date_label), l_rep_date_label);
1014: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_date), l_rep_date);
1015: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_page), l_rep_page);
1016: dbms_lob.writeAppend( l_xfdf_string, length(l_one_value), l_one_value);
1017: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_param_name), l_rep_param_name);
1018: dbms_lob.writeAppend( l_xfdf_string, length(l_str_9), l_str_9);
1019: dbms_lob.writeAppend( l_xfdf_string, length(l_str_8), l_str_8);
1020: dbms_lob.writeAppend( l_xfdf_string, length(l_str_7), l_str_7);

Line 1017: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_param_name), l_rep_param_name);

1013: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_date_label), l_rep_date_label);
1014: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_date), l_rep_date);
1015: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_page), l_rep_page);
1016: dbms_lob.writeAppend( l_xfdf_string, length(l_one_value), l_one_value);
1017: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_param_name), l_rep_param_name);
1018: dbms_lob.writeAppend( l_xfdf_string, length(l_str_9), l_str_9);
1019: dbms_lob.writeAppend( l_xfdf_string, length(l_str_8), l_str_8);
1020: dbms_lob.writeAppend( l_xfdf_string, length(l_str_7), l_str_7);
1021: dbms_lob.writeAppend( l_xfdf_string, length(l_str_6), l_str_6);

Line 1018: dbms_lob.writeAppend( l_xfdf_string, length(l_str_9), l_str_9);

1014: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_date), l_rep_date);
1015: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_page), l_rep_page);
1016: dbms_lob.writeAppend( l_xfdf_string, length(l_one_value), l_one_value);
1017: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_param_name), l_rep_param_name);
1018: dbms_lob.writeAppend( l_xfdf_string, length(l_str_9), l_str_9);
1019: dbms_lob.writeAppend( l_xfdf_string, length(l_str_8), l_str_8);
1020: dbms_lob.writeAppend( l_xfdf_string, length(l_str_7), l_str_7);
1021: dbms_lob.writeAppend( l_xfdf_string, length(l_str_6), l_str_6);
1022: dbms_lob.writeAppend( l_xfdf_string, length(l_str_5), l_str_5);

Line 1019: dbms_lob.writeAppend( l_xfdf_string, length(l_str_8), l_str_8);

1015: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_page), l_rep_page);
1016: dbms_lob.writeAppend( l_xfdf_string, length(l_one_value), l_one_value);
1017: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_param_name), l_rep_param_name);
1018: dbms_lob.writeAppend( l_xfdf_string, length(l_str_9), l_str_9);
1019: dbms_lob.writeAppend( l_xfdf_string, length(l_str_8), l_str_8);
1020: dbms_lob.writeAppend( l_xfdf_string, length(l_str_7), l_str_7);
1021: dbms_lob.writeAppend( l_xfdf_string, length(l_str_6), l_str_6);
1022: dbms_lob.writeAppend( l_xfdf_string, length(l_str_5), l_str_5);
1023: dbms_lob.writeAppend( l_xfdf_string, length(l_str_4), l_str_4);

Line 1020: dbms_lob.writeAppend( l_xfdf_string, length(l_str_7), l_str_7);

1016: dbms_lob.writeAppend( l_xfdf_string, length(l_one_value), l_one_value);
1017: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_param_name), l_rep_param_name);
1018: dbms_lob.writeAppend( l_xfdf_string, length(l_str_9), l_str_9);
1019: dbms_lob.writeAppend( l_xfdf_string, length(l_str_8), l_str_8);
1020: dbms_lob.writeAppend( l_xfdf_string, length(l_str_7), l_str_7);
1021: dbms_lob.writeAppend( l_xfdf_string, length(l_str_6), l_str_6);
1022: dbms_lob.writeAppend( l_xfdf_string, length(l_str_5), l_str_5);
1023: dbms_lob.writeAppend( l_xfdf_string, length(l_str_4), l_str_4);
1024: dbms_lob.writeAppend( l_xfdf_string, length(l_str_3), l_str_3);

Line 1021: dbms_lob.writeAppend( l_xfdf_string, length(l_str_6), l_str_6);

1017: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_param_name), l_rep_param_name);
1018: dbms_lob.writeAppend( l_xfdf_string, length(l_str_9), l_str_9);
1019: dbms_lob.writeAppend( l_xfdf_string, length(l_str_8), l_str_8);
1020: dbms_lob.writeAppend( l_xfdf_string, length(l_str_7), l_str_7);
1021: dbms_lob.writeAppend( l_xfdf_string, length(l_str_6), l_str_6);
1022: dbms_lob.writeAppend( l_xfdf_string, length(l_str_5), l_str_5);
1023: dbms_lob.writeAppend( l_xfdf_string, length(l_str_4), l_str_4);
1024: dbms_lob.writeAppend( l_xfdf_string, length(l_str_3), l_str_3);
1025: dbms_lob.writeAppend( l_xfdf_string, length(l_str_2), l_str_2);

Line 1022: dbms_lob.writeAppend( l_xfdf_string, length(l_str_5), l_str_5);

1018: dbms_lob.writeAppend( l_xfdf_string, length(l_str_9), l_str_9);
1019: dbms_lob.writeAppend( l_xfdf_string, length(l_str_8), l_str_8);
1020: dbms_lob.writeAppend( l_xfdf_string, length(l_str_7), l_str_7);
1021: dbms_lob.writeAppend( l_xfdf_string, length(l_str_6), l_str_6);
1022: dbms_lob.writeAppend( l_xfdf_string, length(l_str_5), l_str_5);
1023: dbms_lob.writeAppend( l_xfdf_string, length(l_str_4), l_str_4);
1024: dbms_lob.writeAppend( l_xfdf_string, length(l_str_3), l_str_3);
1025: dbms_lob.writeAppend( l_xfdf_string, length(l_str_2), l_str_2);
1026: dbms_lob.writeAppend( l_xfdf_string, length(l_str_1), l_str_1);

Line 1023: dbms_lob.writeAppend( l_xfdf_string, length(l_str_4), l_str_4);

1019: dbms_lob.writeAppend( l_xfdf_string, length(l_str_8), l_str_8);
1020: dbms_lob.writeAppend( l_xfdf_string, length(l_str_7), l_str_7);
1021: dbms_lob.writeAppend( l_xfdf_string, length(l_str_6), l_str_6);
1022: dbms_lob.writeAppend( l_xfdf_string, length(l_str_5), l_str_5);
1023: dbms_lob.writeAppend( l_xfdf_string, length(l_str_4), l_str_4);
1024: dbms_lob.writeAppend( l_xfdf_string, length(l_str_3), l_str_3);
1025: dbms_lob.writeAppend( l_xfdf_string, length(l_str_2), l_str_2);
1026: dbms_lob.writeAppend( l_xfdf_string, length(l_str_1), l_str_1);
1027: dbms_lob.writeAppend( l_xfdf_string, length(l_str_0), l_str_0);

Line 1024: dbms_lob.writeAppend( l_xfdf_string, length(l_str_3), l_str_3);

1020: dbms_lob.writeAppend( l_xfdf_string, length(l_str_7), l_str_7);
1021: dbms_lob.writeAppend( l_xfdf_string, length(l_str_6), l_str_6);
1022: dbms_lob.writeAppend( l_xfdf_string, length(l_str_5), l_str_5);
1023: dbms_lob.writeAppend( l_xfdf_string, length(l_str_4), l_str_4);
1024: dbms_lob.writeAppend( l_xfdf_string, length(l_str_3), l_str_3);
1025: dbms_lob.writeAppend( l_xfdf_string, length(l_str_2), l_str_2);
1026: dbms_lob.writeAppend( l_xfdf_string, length(l_str_1), l_str_1);
1027: dbms_lob.writeAppend( l_xfdf_string, length(l_str_0), l_str_0);
1028: dbms_lob.writeAppend( l_xfdf_string, length(l_str_0a), l_str_0a);

Line 1025: dbms_lob.writeAppend( l_xfdf_string, length(l_str_2), l_str_2);

1021: dbms_lob.writeAppend( l_xfdf_string, length(l_str_6), l_str_6);
1022: dbms_lob.writeAppend( l_xfdf_string, length(l_str_5), l_str_5);
1023: dbms_lob.writeAppend( l_xfdf_string, length(l_str_4), l_str_4);
1024: dbms_lob.writeAppend( l_xfdf_string, length(l_str_3), l_str_3);
1025: dbms_lob.writeAppend( l_xfdf_string, length(l_str_2), l_str_2);
1026: dbms_lob.writeAppend( l_xfdf_string, length(l_str_1), l_str_1);
1027: dbms_lob.writeAppend( l_xfdf_string, length(l_str_0), l_str_0);
1028: dbms_lob.writeAppend( l_xfdf_string, length(l_str_0a), l_str_0a);
1029: dbms_lob.writeAppend( l_xfdf_string, length(l_str_0bb), l_str_0bb);

Line 1026: dbms_lob.writeAppend( l_xfdf_string, length(l_str_1), l_str_1);

1022: dbms_lob.writeAppend( l_xfdf_string, length(l_str_5), l_str_5);
1023: dbms_lob.writeAppend( l_xfdf_string, length(l_str_4), l_str_4);
1024: dbms_lob.writeAppend( l_xfdf_string, length(l_str_3), l_str_3);
1025: dbms_lob.writeAppend( l_xfdf_string, length(l_str_2), l_str_2);
1026: dbms_lob.writeAppend( l_xfdf_string, length(l_str_1), l_str_1);
1027: dbms_lob.writeAppend( l_xfdf_string, length(l_str_0), l_str_0);
1028: dbms_lob.writeAppend( l_xfdf_string, length(l_str_0a), l_str_0a);
1029: dbms_lob.writeAppend( l_xfdf_string, length(l_str_0bb), l_str_0bb);
1030: OPEN csr_get_bg_id;

Line 1027: dbms_lob.writeAppend( l_xfdf_string, length(l_str_0), l_str_0);

1023: dbms_lob.writeAppend( l_xfdf_string, length(l_str_4), l_str_4);
1024: dbms_lob.writeAppend( l_xfdf_string, length(l_str_3), l_str_3);
1025: dbms_lob.writeAppend( l_xfdf_string, length(l_str_2), l_str_2);
1026: dbms_lob.writeAppend( l_xfdf_string, length(l_str_1), l_str_1);
1027: dbms_lob.writeAppend( l_xfdf_string, length(l_str_0), l_str_0);
1028: dbms_lob.writeAppend( l_xfdf_string, length(l_str_0a), l_str_0a);
1029: dbms_lob.writeAppend( l_xfdf_string, length(l_str_0bb), l_str_0bb);
1030: OPEN csr_get_bg_id;
1031: LOOP

Line 1028: dbms_lob.writeAppend( l_xfdf_string, length(l_str_0a), l_str_0a);

1024: dbms_lob.writeAppend( l_xfdf_string, length(l_str_3), l_str_3);
1025: dbms_lob.writeAppend( l_xfdf_string, length(l_str_2), l_str_2);
1026: dbms_lob.writeAppend( l_xfdf_string, length(l_str_1), l_str_1);
1027: dbms_lob.writeAppend( l_xfdf_string, length(l_str_0), l_str_0);
1028: dbms_lob.writeAppend( l_xfdf_string, length(l_str_0a), l_str_0a);
1029: dbms_lob.writeAppend( l_xfdf_string, length(l_str_0bb), l_str_0bb);
1030: OPEN csr_get_bg_id;
1031: LOOP
1032: FETCH csr_get_bg_id INTO rec_get_bg_id;

Line 1029: dbms_lob.writeAppend( l_xfdf_string, length(l_str_0bb), l_str_0bb);

1025: dbms_lob.writeAppend( l_xfdf_string, length(l_str_2), l_str_2);
1026: dbms_lob.writeAppend( l_xfdf_string, length(l_str_1), l_str_1);
1027: dbms_lob.writeAppend( l_xfdf_string, length(l_str_0), l_str_0);
1028: dbms_lob.writeAppend( l_xfdf_string, length(l_str_0a), l_str_0a);
1029: dbms_lob.writeAppend( l_xfdf_string, length(l_str_0bb), l_str_0bb);
1030: OPEN csr_get_bg_id;
1031: LOOP
1032: FETCH csr_get_bg_id INTO rec_get_bg_id;
1033: EXIT WHEN csr_get_bg_id%NOTFOUND;

Line 1049: dbms_lob.writeAppend( l_xfdf_string, length(''),'');

1045: IF i = 10 THEN
1046: i := 1;
1047: END IF;
1048: IF l_emp_found = 0 OR i = 1 THEN
1049: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1050: l_pg_count := l_pg_count + 1;
1051: l_rep_date_label := '' ||get_lookup_meaning('AE_FORM_LABELS','REPORT_DATE_LABEL')||'';
1052: l_rep_date := '' ||fnd_date.date_to_displaydate(sysdate)||'';
1053: l_rep_page := ''||get_lookup_meaning('AE_FORM_LABELS','PAGE_NO_LABEL')||'';

Line 1069: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_date_label), l_rep_date_label);

1065: l_str_1b := ''||get_lookup_meaning('AE_FORM_LABELS','START_DATE_LABEL')||'';
1066: l_str_0b := ''||get_lookup_meaning('AE_FORM_LABELS','EXPIRY_DATE')||'';
1067: fnd_file.put_line(fnd_file.log,'Test1');
1068:
1069: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_date_label), l_rep_date_label);
1070: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_date), l_rep_date);
1071: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_page), l_rep_page);
1072: dbms_lob.writeAppend( l_xfdf_string, length(l_page_num), l_page_num);
1073: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_label), l_rep_label);

Line 1070: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_date), l_rep_date);

1066: l_str_0b := ''||get_lookup_meaning('AE_FORM_LABELS','EXPIRY_DATE')||'';
1067: fnd_file.put_line(fnd_file.log,'Test1');
1068:
1069: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_date_label), l_rep_date_label);
1070: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_date), l_rep_date);
1071: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_page), l_rep_page);
1072: dbms_lob.writeAppend( l_xfdf_string, length(l_page_num), l_page_num);
1073: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_label), l_rep_label);
1074: dbms_lob.writeAppend( l_xfdf_string, length(l_str_9b), l_str_9b);

Line 1071: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_page), l_rep_page);

1067: fnd_file.put_line(fnd_file.log,'Test1');
1068:
1069: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_date_label), l_rep_date_label);
1070: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_date), l_rep_date);
1071: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_page), l_rep_page);
1072: dbms_lob.writeAppend( l_xfdf_string, length(l_page_num), l_page_num);
1073: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_label), l_rep_label);
1074: dbms_lob.writeAppend( l_xfdf_string, length(l_str_9b), l_str_9b);
1075: dbms_lob.writeAppend( l_xfdf_string, length(l_str_8b), l_str_8b);

Line 1072: dbms_lob.writeAppend( l_xfdf_string, length(l_page_num), l_page_num);

1068:
1069: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_date_label), l_rep_date_label);
1070: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_date), l_rep_date);
1071: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_page), l_rep_page);
1072: dbms_lob.writeAppend( l_xfdf_string, length(l_page_num), l_page_num);
1073: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_label), l_rep_label);
1074: dbms_lob.writeAppend( l_xfdf_string, length(l_str_9b), l_str_9b);
1075: dbms_lob.writeAppend( l_xfdf_string, length(l_str_8b), l_str_8b);
1076: dbms_lob.writeAppend( l_xfdf_string, length(l_str_7b), l_str_7b);

Line 1073: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_label), l_rep_label);

1069: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_date_label), l_rep_date_label);
1070: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_date), l_rep_date);
1071: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_page), l_rep_page);
1072: dbms_lob.writeAppend( l_xfdf_string, length(l_page_num), l_page_num);
1073: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_label), l_rep_label);
1074: dbms_lob.writeAppend( l_xfdf_string, length(l_str_9b), l_str_9b);
1075: dbms_lob.writeAppend( l_xfdf_string, length(l_str_8b), l_str_8b);
1076: dbms_lob.writeAppend( l_xfdf_string, length(l_str_7b), l_str_7b);
1077: dbms_lob.writeAppend( l_xfdf_string, length(l_str_6b), l_str_6b);

Line 1074: dbms_lob.writeAppend( l_xfdf_string, length(l_str_9b), l_str_9b);

1070: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_date), l_rep_date);
1071: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_page), l_rep_page);
1072: dbms_lob.writeAppend( l_xfdf_string, length(l_page_num), l_page_num);
1073: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_label), l_rep_label);
1074: dbms_lob.writeAppend( l_xfdf_string, length(l_str_9b), l_str_9b);
1075: dbms_lob.writeAppend( l_xfdf_string, length(l_str_8b), l_str_8b);
1076: dbms_lob.writeAppend( l_xfdf_string, length(l_str_7b), l_str_7b);
1077: dbms_lob.writeAppend( l_xfdf_string, length(l_str_6b), l_str_6b);
1078: dbms_lob.writeAppend( l_xfdf_string, length(l_str_5b), l_str_5b);

Line 1075: dbms_lob.writeAppend( l_xfdf_string, length(l_str_8b), l_str_8b);

1071: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_page), l_rep_page);
1072: dbms_lob.writeAppend( l_xfdf_string, length(l_page_num), l_page_num);
1073: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_label), l_rep_label);
1074: dbms_lob.writeAppend( l_xfdf_string, length(l_str_9b), l_str_9b);
1075: dbms_lob.writeAppend( l_xfdf_string, length(l_str_8b), l_str_8b);
1076: dbms_lob.writeAppend( l_xfdf_string, length(l_str_7b), l_str_7b);
1077: dbms_lob.writeAppend( l_xfdf_string, length(l_str_6b), l_str_6b);
1078: dbms_lob.writeAppend( l_xfdf_string, length(l_str_5b), l_str_5b);
1079: dbms_lob.writeAppend( l_xfdf_string, length(l_str_4b), l_str_4b);

Line 1076: dbms_lob.writeAppend( l_xfdf_string, length(l_str_7b), l_str_7b);

1072: dbms_lob.writeAppend( l_xfdf_string, length(l_page_num), l_page_num);
1073: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_label), l_rep_label);
1074: dbms_lob.writeAppend( l_xfdf_string, length(l_str_9b), l_str_9b);
1075: dbms_lob.writeAppend( l_xfdf_string, length(l_str_8b), l_str_8b);
1076: dbms_lob.writeAppend( l_xfdf_string, length(l_str_7b), l_str_7b);
1077: dbms_lob.writeAppend( l_xfdf_string, length(l_str_6b), l_str_6b);
1078: dbms_lob.writeAppend( l_xfdf_string, length(l_str_5b), l_str_5b);
1079: dbms_lob.writeAppend( l_xfdf_string, length(l_str_4b), l_str_4b);
1080: dbms_lob.writeAppend( l_xfdf_string, length(l_str_3b), l_str_3b);

Line 1077: dbms_lob.writeAppend( l_xfdf_string, length(l_str_6b), l_str_6b);

1073: dbms_lob.writeAppend( l_xfdf_string, length(l_rep_label), l_rep_label);
1074: dbms_lob.writeAppend( l_xfdf_string, length(l_str_9b), l_str_9b);
1075: dbms_lob.writeAppend( l_xfdf_string, length(l_str_8b), l_str_8b);
1076: dbms_lob.writeAppend( l_xfdf_string, length(l_str_7b), l_str_7b);
1077: dbms_lob.writeAppend( l_xfdf_string, length(l_str_6b), l_str_6b);
1078: dbms_lob.writeAppend( l_xfdf_string, length(l_str_5b), l_str_5b);
1079: dbms_lob.writeAppend( l_xfdf_string, length(l_str_4b), l_str_4b);
1080: dbms_lob.writeAppend( l_xfdf_string, length(l_str_3b), l_str_3b);
1081: dbms_lob.writeAppend( l_xfdf_string, length(l_str_2b), l_str_2b);

Line 1078: dbms_lob.writeAppend( l_xfdf_string, length(l_str_5b), l_str_5b);

1074: dbms_lob.writeAppend( l_xfdf_string, length(l_str_9b), l_str_9b);
1075: dbms_lob.writeAppend( l_xfdf_string, length(l_str_8b), l_str_8b);
1076: dbms_lob.writeAppend( l_xfdf_string, length(l_str_7b), l_str_7b);
1077: dbms_lob.writeAppend( l_xfdf_string, length(l_str_6b), l_str_6b);
1078: dbms_lob.writeAppend( l_xfdf_string, length(l_str_5b), l_str_5b);
1079: dbms_lob.writeAppend( l_xfdf_string, length(l_str_4b), l_str_4b);
1080: dbms_lob.writeAppend( l_xfdf_string, length(l_str_3b), l_str_3b);
1081: dbms_lob.writeAppend( l_xfdf_string, length(l_str_2b), l_str_2b);
1082: dbms_lob.writeAppend( l_xfdf_string, length(l_str_1b), l_str_1b);

Line 1079: dbms_lob.writeAppend( l_xfdf_string, length(l_str_4b), l_str_4b);

1075: dbms_lob.writeAppend( l_xfdf_string, length(l_str_8b), l_str_8b);
1076: dbms_lob.writeAppend( l_xfdf_string, length(l_str_7b), l_str_7b);
1077: dbms_lob.writeAppend( l_xfdf_string, length(l_str_6b), l_str_6b);
1078: dbms_lob.writeAppend( l_xfdf_string, length(l_str_5b), l_str_5b);
1079: dbms_lob.writeAppend( l_xfdf_string, length(l_str_4b), l_str_4b);
1080: dbms_lob.writeAppend( l_xfdf_string, length(l_str_3b), l_str_3b);
1081: dbms_lob.writeAppend( l_xfdf_string, length(l_str_2b), l_str_2b);
1082: dbms_lob.writeAppend( l_xfdf_string, length(l_str_1b), l_str_1b);
1083: dbms_lob.writeAppend( l_xfdf_string, length(l_str_0b), l_str_0b);

Line 1080: dbms_lob.writeAppend( l_xfdf_string, length(l_str_3b), l_str_3b);

1076: dbms_lob.writeAppend( l_xfdf_string, length(l_str_7b), l_str_7b);
1077: dbms_lob.writeAppend( l_xfdf_string, length(l_str_6b), l_str_6b);
1078: dbms_lob.writeAppend( l_xfdf_string, length(l_str_5b), l_str_5b);
1079: dbms_lob.writeAppend( l_xfdf_string, length(l_str_4b), l_str_4b);
1080: dbms_lob.writeAppend( l_xfdf_string, length(l_str_3b), l_str_3b);
1081: dbms_lob.writeAppend( l_xfdf_string, length(l_str_2b), l_str_2b);
1082: dbms_lob.writeAppend( l_xfdf_string, length(l_str_1b), l_str_1b);
1083: dbms_lob.writeAppend( l_xfdf_string, length(l_str_0b), l_str_0b);
1084: fnd_file.put_line(fnd_file.log,'Test2');

Line 1081: dbms_lob.writeAppend( l_xfdf_string, length(l_str_2b), l_str_2b);

1077: dbms_lob.writeAppend( l_xfdf_string, length(l_str_6b), l_str_6b);
1078: dbms_lob.writeAppend( l_xfdf_string, length(l_str_5b), l_str_5b);
1079: dbms_lob.writeAppend( l_xfdf_string, length(l_str_4b), l_str_4b);
1080: dbms_lob.writeAppend( l_xfdf_string, length(l_str_3b), l_str_3b);
1081: dbms_lob.writeAppend( l_xfdf_string, length(l_str_2b), l_str_2b);
1082: dbms_lob.writeAppend( l_xfdf_string, length(l_str_1b), l_str_1b);
1083: dbms_lob.writeAppend( l_xfdf_string, length(l_str_0b), l_str_0b);
1084: fnd_file.put_line(fnd_file.log,'Test2');
1085: /********* COMMENTED ON 3-NOV-05 FOR RTF FORMAT

Line 1082: dbms_lob.writeAppend( l_xfdf_string, length(l_str_1b), l_str_1b);

1078: dbms_lob.writeAppend( l_xfdf_string, length(l_str_5b), l_str_5b);
1079: dbms_lob.writeAppend( l_xfdf_string, length(l_str_4b), l_str_4b);
1080: dbms_lob.writeAppend( l_xfdf_string, length(l_str_3b), l_str_3b);
1081: dbms_lob.writeAppend( l_xfdf_string, length(l_str_2b), l_str_2b);
1082: dbms_lob.writeAppend( l_xfdf_string, length(l_str_1b), l_str_1b);
1083: dbms_lob.writeAppend( l_xfdf_string, length(l_str_0b), l_str_0b);
1084: fnd_file.put_line(fnd_file.log,'Test2');
1085: /********* COMMENTED ON 3-NOV-05 FOR RTF FORMAT
1086: gxmltable(gCtr).tagName := 'report_label';

Line 1083: dbms_lob.writeAppend( l_xfdf_string, length(l_str_0b), l_str_0b);

1079: dbms_lob.writeAppend( l_xfdf_string, length(l_str_4b), l_str_4b);
1080: dbms_lob.writeAppend( l_xfdf_string, length(l_str_3b), l_str_3b);
1081: dbms_lob.writeAppend( l_xfdf_string, length(l_str_2b), l_str_2b);
1082: dbms_lob.writeAppend( l_xfdf_string, length(l_str_1b), l_str_1b);
1083: dbms_lob.writeAppend( l_xfdf_string, length(l_str_0b), l_str_0b);
1084: fnd_file.put_line(fnd_file.log,'Test2');
1085: /********* COMMENTED ON 3-NOV-05 FOR RTF FORMAT
1086: gxmltable(gCtr).tagName := 'report_label';
1087: gxmltable(gCtr).tagValue := get_lookup_meaning('AE_FORM_LABELS','REPORT_LABEL_CTR');

Line 1111: dbms_lob.writeAppend( l_xfdf_string, length(l_eno), l_eno);

1107: l_type := ''||'' ||'';
1108: l_status := ''|| (rec_get_contract_det.employment_status) ||'';
1109: l_appdate := ''||fnd_date.date_to_displaydate(rec_get_contract_det.date_start)||'';
1110: l_edate := ''|| fnd_date.date_to_displaydate(rec_get_contract_det.expiry_date) ||'';
1111: dbms_lob.writeAppend( l_xfdf_string, length(l_eno), l_eno);
1112: dbms_lob.writeAppend( l_xfdf_string, length(l_fname), l_fname);
1113: dbms_lob.writeAppend( l_xfdf_string, length(l_job), l_job);
1114: dbms_lob.writeAppend( l_xfdf_string, length(l_ref), l_ref);
1115: dbms_lob.writeAppend( l_xfdf_string, length(l_type), l_type);

Line 1112: dbms_lob.writeAppend( l_xfdf_string, length(l_fname), l_fname);

1108: l_status := ''|| (rec_get_contract_det.employment_status) ||'';
1109: l_appdate := ''||fnd_date.date_to_displaydate(rec_get_contract_det.date_start)||'';
1110: l_edate := ''|| fnd_date.date_to_displaydate(rec_get_contract_det.expiry_date) ||'';
1111: dbms_lob.writeAppend( l_xfdf_string, length(l_eno), l_eno);
1112: dbms_lob.writeAppend( l_xfdf_string, length(l_fname), l_fname);
1113: dbms_lob.writeAppend( l_xfdf_string, length(l_job), l_job);
1114: dbms_lob.writeAppend( l_xfdf_string, length(l_ref), l_ref);
1115: dbms_lob.writeAppend( l_xfdf_string, length(l_type), l_type);
1116: dbms_lob.writeAppend( l_xfdf_string, length(l_status), l_status);

Line 1113: dbms_lob.writeAppend( l_xfdf_string, length(l_job), l_job);

1109: l_appdate := ''||fnd_date.date_to_displaydate(rec_get_contract_det.date_start)||'';
1110: l_edate := ''|| fnd_date.date_to_displaydate(rec_get_contract_det.expiry_date) ||'';
1111: dbms_lob.writeAppend( l_xfdf_string, length(l_eno), l_eno);
1112: dbms_lob.writeAppend( l_xfdf_string, length(l_fname), l_fname);
1113: dbms_lob.writeAppend( l_xfdf_string, length(l_job), l_job);
1114: dbms_lob.writeAppend( l_xfdf_string, length(l_ref), l_ref);
1115: dbms_lob.writeAppend( l_xfdf_string, length(l_type), l_type);
1116: dbms_lob.writeAppend( l_xfdf_string, length(l_status), l_status);
1117: dbms_lob.writeAppend( l_xfdf_string, length(l_appdate), l_appdate);

Line 1114: dbms_lob.writeAppend( l_xfdf_string, length(l_ref), l_ref);

1110: l_edate := ''|| fnd_date.date_to_displaydate(rec_get_contract_det.expiry_date) ||'';
1111: dbms_lob.writeAppend( l_xfdf_string, length(l_eno), l_eno);
1112: dbms_lob.writeAppend( l_xfdf_string, length(l_fname), l_fname);
1113: dbms_lob.writeAppend( l_xfdf_string, length(l_job), l_job);
1114: dbms_lob.writeAppend( l_xfdf_string, length(l_ref), l_ref);
1115: dbms_lob.writeAppend( l_xfdf_string, length(l_type), l_type);
1116: dbms_lob.writeAppend( l_xfdf_string, length(l_status), l_status);
1117: dbms_lob.writeAppend( l_xfdf_string, length(l_appdate), l_appdate);
1118: dbms_lob.writeAppend( l_xfdf_string, length(l_edate), l_edate);

Line 1115: dbms_lob.writeAppend( l_xfdf_string, length(l_type), l_type);

1111: dbms_lob.writeAppend( l_xfdf_string, length(l_eno), l_eno);
1112: dbms_lob.writeAppend( l_xfdf_string, length(l_fname), l_fname);
1113: dbms_lob.writeAppend( l_xfdf_string, length(l_job), l_job);
1114: dbms_lob.writeAppend( l_xfdf_string, length(l_ref), l_ref);
1115: dbms_lob.writeAppend( l_xfdf_string, length(l_type), l_type);
1116: dbms_lob.writeAppend( l_xfdf_string, length(l_status), l_status);
1117: dbms_lob.writeAppend( l_xfdf_string, length(l_appdate), l_appdate);
1118: dbms_lob.writeAppend( l_xfdf_string, length(l_edate), l_edate);
1119: i := i + 1;

Line 1116: dbms_lob.writeAppend( l_xfdf_string, length(l_status), l_status);

1112: dbms_lob.writeAppend( l_xfdf_string, length(l_fname), l_fname);
1113: dbms_lob.writeAppend( l_xfdf_string, length(l_job), l_job);
1114: dbms_lob.writeAppend( l_xfdf_string, length(l_ref), l_ref);
1115: dbms_lob.writeAppend( l_xfdf_string, length(l_type), l_type);
1116: dbms_lob.writeAppend( l_xfdf_string, length(l_status), l_status);
1117: dbms_lob.writeAppend( l_xfdf_string, length(l_appdate), l_appdate);
1118: dbms_lob.writeAppend( l_xfdf_string, length(l_edate), l_edate);
1119: i := i + 1;
1120: IF i = 10 then

Line 1117: dbms_lob.writeAppend( l_xfdf_string, length(l_appdate), l_appdate);

1113: dbms_lob.writeAppend( l_xfdf_string, length(l_job), l_job);
1114: dbms_lob.writeAppend( l_xfdf_string, length(l_ref), l_ref);
1115: dbms_lob.writeAppend( l_xfdf_string, length(l_type), l_type);
1116: dbms_lob.writeAppend( l_xfdf_string, length(l_status), l_status);
1117: dbms_lob.writeAppend( l_xfdf_string, length(l_appdate), l_appdate);
1118: dbms_lob.writeAppend( l_xfdf_string, length(l_edate), l_edate);
1119: i := i + 1;
1120: IF i = 10 then
1121: dbms_lob.writeAppend( l_xfdf_string, length(''),'');

Line 1118: dbms_lob.writeAppend( l_xfdf_string, length(l_edate), l_edate);

1114: dbms_lob.writeAppend( l_xfdf_string, length(l_ref), l_ref);
1115: dbms_lob.writeAppend( l_xfdf_string, length(l_type), l_type);
1116: dbms_lob.writeAppend( l_xfdf_string, length(l_status), l_status);
1117: dbms_lob.writeAppend( l_xfdf_string, length(l_appdate), l_appdate);
1118: dbms_lob.writeAppend( l_xfdf_string, length(l_edate), l_edate);
1119: i := i + 1;
1120: IF i = 10 then
1121: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1122: END IF;

Line 1121: dbms_lob.writeAppend( l_xfdf_string, length(''),'');

1117: dbms_lob.writeAppend( l_xfdf_string, length(l_appdate), l_appdate);
1118: dbms_lob.writeAppend( l_xfdf_string, length(l_edate), l_edate);
1119: i := i + 1;
1120: IF i = 10 then
1121: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1122: END IF;
1123: END LOOP;
1124: CLOSE csr_get_contract_det;
1125: IF i < 9 AND l_emp_found = 1 THEN

Line 1141: dbms_lob.writeAppend( l_xfdf_string, length(l_b_eno), l_b_eno);

1137: l_b_type := ''|| null ||'';
1138: l_b_status := ''|| null ||'';
1139: l_b_appdate := ''|| null ||'';
1140: l_b_edate := ''|| null ||'';
1141: dbms_lob.writeAppend( l_xfdf_string, length(l_b_eno), l_b_eno);
1142: dbms_lob.writeAppend( l_xfdf_string, length(l_b_fname), l_b_fname);
1143: dbms_lob.writeAppend( l_xfdf_string, length(l_b_job), l_b_job);
1144: dbms_lob.writeAppend( l_xfdf_string, length(l_b_ref), l_b_ref);
1145: dbms_lob.writeAppend( l_xfdf_string, length(l_b_type), l_b_type);

Line 1142: dbms_lob.writeAppend( l_xfdf_string, length(l_b_fname), l_b_fname);

1138: l_b_status := ''|| null ||'';
1139: l_b_appdate := ''|| null ||'';
1140: l_b_edate := ''|| null ||'';
1141: dbms_lob.writeAppend( l_xfdf_string, length(l_b_eno), l_b_eno);
1142: dbms_lob.writeAppend( l_xfdf_string, length(l_b_fname), l_b_fname);
1143: dbms_lob.writeAppend( l_xfdf_string, length(l_b_job), l_b_job);
1144: dbms_lob.writeAppend( l_xfdf_string, length(l_b_ref), l_b_ref);
1145: dbms_lob.writeAppend( l_xfdf_string, length(l_b_type), l_b_type);
1146: dbms_lob.writeAppend( l_xfdf_string, length(l_b_status), l_b_status);

Line 1143: dbms_lob.writeAppend( l_xfdf_string, length(l_b_job), l_b_job);

1139: l_b_appdate := ''|| null ||'';
1140: l_b_edate := ''|| null ||'';
1141: dbms_lob.writeAppend( l_xfdf_string, length(l_b_eno), l_b_eno);
1142: dbms_lob.writeAppend( l_xfdf_string, length(l_b_fname), l_b_fname);
1143: dbms_lob.writeAppend( l_xfdf_string, length(l_b_job), l_b_job);
1144: dbms_lob.writeAppend( l_xfdf_string, length(l_b_ref), l_b_ref);
1145: dbms_lob.writeAppend( l_xfdf_string, length(l_b_type), l_b_type);
1146: dbms_lob.writeAppend( l_xfdf_string, length(l_b_status), l_b_status);
1147: dbms_lob.writeAppend( l_xfdf_string, length(l_b_appdate), l_b_appdate);

Line 1144: dbms_lob.writeAppend( l_xfdf_string, length(l_b_ref), l_b_ref);

1140: l_b_edate := ''|| null ||'';
1141: dbms_lob.writeAppend( l_xfdf_string, length(l_b_eno), l_b_eno);
1142: dbms_lob.writeAppend( l_xfdf_string, length(l_b_fname), l_b_fname);
1143: dbms_lob.writeAppend( l_xfdf_string, length(l_b_job), l_b_job);
1144: dbms_lob.writeAppend( l_xfdf_string, length(l_b_ref), l_b_ref);
1145: dbms_lob.writeAppend( l_xfdf_string, length(l_b_type), l_b_type);
1146: dbms_lob.writeAppend( l_xfdf_string, length(l_b_status), l_b_status);
1147: dbms_lob.writeAppend( l_xfdf_string, length(l_b_appdate), l_b_appdate);
1148: dbms_lob.writeAppend( l_xfdf_string, length(l_b_edate), l_b_edate);

Line 1145: dbms_lob.writeAppend( l_xfdf_string, length(l_b_type), l_b_type);

1141: dbms_lob.writeAppend( l_xfdf_string, length(l_b_eno), l_b_eno);
1142: dbms_lob.writeAppend( l_xfdf_string, length(l_b_fname), l_b_fname);
1143: dbms_lob.writeAppend( l_xfdf_string, length(l_b_job), l_b_job);
1144: dbms_lob.writeAppend( l_xfdf_string, length(l_b_ref), l_b_ref);
1145: dbms_lob.writeAppend( l_xfdf_string, length(l_b_type), l_b_type);
1146: dbms_lob.writeAppend( l_xfdf_string, length(l_b_status), l_b_status);
1147: dbms_lob.writeAppend( l_xfdf_string, length(l_b_appdate), l_b_appdate);
1148: dbms_lob.writeAppend( l_xfdf_string, length(l_b_edate), l_b_edate);
1149: END LOOP;

Line 1146: dbms_lob.writeAppend( l_xfdf_string, length(l_b_status), l_b_status);

1142: dbms_lob.writeAppend( l_xfdf_string, length(l_b_fname), l_b_fname);
1143: dbms_lob.writeAppend( l_xfdf_string, length(l_b_job), l_b_job);
1144: dbms_lob.writeAppend( l_xfdf_string, length(l_b_ref), l_b_ref);
1145: dbms_lob.writeAppend( l_xfdf_string, length(l_b_type), l_b_type);
1146: dbms_lob.writeAppend( l_xfdf_string, length(l_b_status), l_b_status);
1147: dbms_lob.writeAppend( l_xfdf_string, length(l_b_appdate), l_b_appdate);
1148: dbms_lob.writeAppend( l_xfdf_string, length(l_b_edate), l_b_edate);
1149: END LOOP;
1150: dbms_lob.writeAppend( l_xfdf_string, length(''),'');

Line 1147: dbms_lob.writeAppend( l_xfdf_string, length(l_b_appdate), l_b_appdate);

1143: dbms_lob.writeAppend( l_xfdf_string, length(l_b_job), l_b_job);
1144: dbms_lob.writeAppend( l_xfdf_string, length(l_b_ref), l_b_ref);
1145: dbms_lob.writeAppend( l_xfdf_string, length(l_b_type), l_b_type);
1146: dbms_lob.writeAppend( l_xfdf_string, length(l_b_status), l_b_status);
1147: dbms_lob.writeAppend( l_xfdf_string, length(l_b_appdate), l_b_appdate);
1148: dbms_lob.writeAppend( l_xfdf_string, length(l_b_edate), l_b_edate);
1149: END LOOP;
1150: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1151: END IF;

Line 1148: dbms_lob.writeAppend( l_xfdf_string, length(l_b_edate), l_b_edate);

1144: dbms_lob.writeAppend( l_xfdf_string, length(l_b_ref), l_b_ref);
1145: dbms_lob.writeAppend( l_xfdf_string, length(l_b_type), l_b_type);
1146: dbms_lob.writeAppend( l_xfdf_string, length(l_b_status), l_b_status);
1147: dbms_lob.writeAppend( l_xfdf_string, length(l_b_appdate), l_b_appdate);
1148: dbms_lob.writeAppend( l_xfdf_string, length(l_b_edate), l_b_edate);
1149: END LOOP;
1150: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1151: END IF;
1152: END LOOP;

Line 1150: dbms_lob.writeAppend( l_xfdf_string, length(''),'');

1146: dbms_lob.writeAppend( l_xfdf_string, length(l_b_status), l_b_status);
1147: dbms_lob.writeAppend( l_xfdf_string, length(l_b_appdate), l_b_appdate);
1148: dbms_lob.writeAppend( l_xfdf_string, length(l_b_edate), l_b_edate);
1149: END LOOP;
1150: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1151: END IF;
1152: END LOOP;
1153: CLOSE csr_get_org_id;
1154: END LOOP;

Line 1156: dbms_lob.writeAppend( l_xfdf_string, length(''),'');

1152: END LOOP;
1153: CLOSE csr_get_org_id;
1154: END LOOP;
1155: CLOSE csr_get_bg_id;
1156: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1157: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
1158: clob_to_blob(l_xfdf_string,l_xfdf_blob);
1159: /* WritetoCLOB ( l_xfdf_blob, l_pg_count );*/
1160: END get_contract_data;

Line 1157: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);

1153: CLOSE csr_get_org_id;
1154: END LOOP;
1155: CLOSE csr_get_bg_id;
1156: dbms_lob.writeAppend( l_xfdf_string, length(''),'');
1157: DBMS_LOB.CREATETEMPORARY(l_xfdf_blob,TRUE);
1158: clob_to_blob(l_xfdf_string,l_xfdf_blob);
1159: /* WritetoCLOB ( l_xfdf_blob, l_pg_count );*/
1160: END get_contract_data;
1161: --------------------------------------------------------------------------------------------------------

Line 1189: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);

1185: l_str7 := '
1186:
1187:
1188: ';
1189: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
1190: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
1191: if gxmltable.count > 0 then
1192: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
1193: FOR ctr_table IN gxmltable.FIRST .. gxmltable.LAST LOOP

Line 1190: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);

1186:
1187:
1188: ';
1189: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
1190: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
1191: if gxmltable.count > 0 then
1192: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
1193: FOR ctr_table IN gxmltable.FIRST .. gxmltable.LAST LOOP
1194: l_str8 := gxmltable(ctr_table).tagName;

Line 1192: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );

1188: ';
1189: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
1190: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
1191: if gxmltable.count > 0 then
1192: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
1193: FOR ctr_table IN gxmltable.FIRST .. gxmltable.LAST LOOP
1194: l_str8 := gxmltable(ctr_table).tagName;
1195: l_str9 := gxmltable(ctr_table).tagValue;
1196: IF gxmltable(ctr_table).tagName IN ('count_body_value', 'count_value') THEN

Line 1202: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );

1198: END IF;
1199: IF (l_str9 is not null) THEN
1200: /* Added new check for bug:6721310 */
1201: l_str9 := '';
1202: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
1203: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
1204: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
1205: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
1206: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);

Line 1203: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);

1199: IF (l_str9 is not null) THEN
1200: /* Added new check for bug:6721310 */
1201: l_str9 := '';
1202: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
1203: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
1204: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
1205: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
1206: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1207: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );

Line 1204: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );

1200: /* Added new check for bug:6721310 */
1201: l_str9 := '';
1202: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
1203: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
1204: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
1205: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
1206: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1207: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
1208: ELSIF (l_str9 IS NULL AND l_str8 IS NOT NULL) THEN

Line 1205: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );

1201: l_str9 := '';
1202: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
1203: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
1204: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
1205: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
1206: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1207: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
1208: ELSIF (l_str9 IS NULL AND l_str8 IS NOT NULL) THEN
1209: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);

Line 1206: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);

1202: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );
1203: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
1204: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
1205: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
1206: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1207: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
1208: ELSIF (l_str9 IS NULL AND l_str8 IS NOT NULL) THEN
1209: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
1210: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);

Line 1207: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );

1203: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);
1204: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );
1205: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
1206: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1207: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
1208: ELSIF (l_str9 IS NULL AND l_str8 IS NOT NULL) THEN
1209: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
1210: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
1211: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);

Line 1209: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);

1205: dbms_lob.writeAppend( l_xfdf_string, length(l_str4), l_str4 );
1206: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1207: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
1208: ELSIF (l_str9 IS NULL AND l_str8 IS NOT NULL) THEN
1209: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
1210: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
1211: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
1212: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
1213: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);

Line 1210: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);

1206: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);
1207: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
1208: ELSIF (l_str9 IS NULL AND l_str8 IS NOT NULL) THEN
1209: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
1210: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
1211: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
1212: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
1213: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
1214: ELSE

Line 1211: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);

1207: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );
1208: ELSIF (l_str9 IS NULL AND l_str8 IS NOT NULL) THEN
1209: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
1210: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
1211: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
1212: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
1213: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
1214: ELSE
1215: NULL;

Line 1212: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);

1208: ELSIF (l_str9 IS NULL AND l_str8 IS NOT NULL) THEN
1209: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
1210: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
1211: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
1212: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
1213: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
1214: ELSE
1215: NULL;
1216: END IF;

Line 1213: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);

1209: dbms_lob.writeAppend(l_xfdf_string,length(l_str2),l_str2);
1210: dbms_lob.writeAppend(l_xfdf_string,length(l_str8),l_str8);
1211: dbms_lob.writeAppend(l_xfdf_string,length(l_str3),l_str3);
1212: dbms_lob.writeAppend(l_xfdf_string,length(l_str4),l_str4);
1213: dbms_lob.writeAppend(l_xfdf_string,length(l_str5),l_str5);
1214: ELSE
1215: NULL;
1216: END IF;
1217: END LOOP;

Line 1218: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6 );

1214: ELSE
1215: NULL;
1216: END IF;
1217: END LOOP;
1218: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6 );
1219: ELSE
1220: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );
1221: END IF;
1222: DBMS_LOB.CREATETEMPORARY(p_xfdf_blob,TRUE);

Line 1220: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );

1216: END IF;
1217: END LOOP;
1218: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6 );
1219: ELSE
1220: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );
1221: END IF;
1222: DBMS_LOB.CREATETEMPORARY(p_xfdf_blob,TRUE);
1223: clob_to_blob(l_xfdf_string,p_xfdf_blob);
1224: hr_utility.set_location('Finished Procedure Write to CLOB ,Before clob to blob ',110);

Line 1222: DBMS_LOB.CREATETEMPORARY(p_xfdf_blob,TRUE);

1218: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6 );
1219: ELSE
1220: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );
1221: END IF;
1222: DBMS_LOB.CREATETEMPORARY(p_xfdf_blob,TRUE);
1223: clob_to_blob(l_xfdf_string,p_xfdf_blob);
1224: hr_utility.set_location('Finished Procedure Write to CLOB ,Before clob to blob ',110);
1225: EXCEPTION
1226: WHEN OTHERS then

Line 1247: l_length_clob := dbms_lob.getlength(p_clob);

1243: l_blob_offset pls_integer := 1;
1244: begin
1245: hr_utility.set_location('Entered Procedure clob to blob',120);
1246: select userenv('LANGUAGE') into g_nls_db_char from dual;
1247: l_length_clob := dbms_lob.getlength(p_clob);
1248: l_offset := 1;
1249: while l_length_clob > 0 loop
1250: hr_utility.trace('l_length_clob '|| l_length_clob);
1251: if l_length_clob < l_buffer_len then

Line 1256: DBMS_LOB.READ(p_clob,l_chunk_len,l_offset,l_varchar_buffer);

1252: l_chunk_len := l_length_clob;
1253: else
1254: l_chunk_len := l_buffer_len;
1255: end if;
1256: DBMS_LOB.READ(p_clob,l_chunk_len,l_offset,l_varchar_buffer);
1257: fnd_file.put_line(fnd_file.log,l_varchar_buffer);
1258: --l_raw_buffer := utl_raw.cast_to_raw(l_varchar_buffer);
1259: l_raw_buffer := utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char);
1260: l_raw_buffer_len := utl_raw.length(utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char));

Line 1262: --dbms_lob.write(p_blob,l_chunk_len, l_offset, l_raw_buffer);

1258: --l_raw_buffer := utl_raw.cast_to_raw(l_varchar_buffer);
1259: l_raw_buffer := utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char);
1260: l_raw_buffer_len := utl_raw.length(utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char));
1261: hr_utility.trace('l_varchar_buffer '|| l_varchar_buffer);
1262: --dbms_lob.write(p_blob,l_chunk_len, l_offset, l_raw_buffer);
1263: dbms_lob.write(p_blob,l_raw_buffer_len, l_blob_offset, l_raw_buffer);
1264: l_blob_offset := l_blob_offset + l_raw_buffer_len;
1265: l_offset := l_offset + l_chunk_len;
1266: l_length_clob := l_length_clob - l_chunk_len;

Line 1263: dbms_lob.write(p_blob,l_raw_buffer_len, l_blob_offset, l_raw_buffer);

1259: l_raw_buffer := utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char);
1260: l_raw_buffer_len := utl_raw.length(utl_raw.convert(utl_raw.cast_to_raw(l_varchar_buffer),'American_America.UTF8',g_nls_db_char));
1261: hr_utility.trace('l_varchar_buffer '|| l_varchar_buffer);
1262: --dbms_lob.write(p_blob,l_chunk_len, l_offset, l_raw_buffer);
1263: dbms_lob.write(p_blob,l_raw_buffer_len, l_blob_offset, l_raw_buffer);
1264: l_blob_offset := l_blob_offset + l_raw_buffer_len;
1265: l_offset := l_offset + l_chunk_len;
1266: l_length_clob := l_length_clob - l_chunk_len;
1267: hr_utility.trace('l_length_blob '|| dbms_lob.getlength(p_blob));

Line 1267: hr_utility.trace('l_length_blob '|| dbms_lob.getlength(p_blob));

1263: dbms_lob.write(p_blob,l_raw_buffer_len, l_blob_offset, l_raw_buffer);
1264: l_blob_offset := l_blob_offset + l_raw_buffer_len;
1265: l_offset := l_offset + l_chunk_len;
1266: l_length_clob := l_length_clob - l_chunk_len;
1267: hr_utility.trace('l_length_blob '|| dbms_lob.getlength(p_blob));
1268: end loop;
1269: hr_utility.set_location('Finished Procedure clob to blob ',130);
1270: end;
1271: ------------------------------------------------------------------