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.AHL_RA_ANALYSER_PVT dependencies on FND_GLOBAL

Line 1466: l_forecast_interface_tbl(l_fct_index).LAST_UPDATED_BY := fnd_global.USER_ID;

1462: l_forecast_interface_tbl(l_fct_index).FORECAST_DESIGNATOR := l_fct_designator;
1463: l_forecast_interface_tbl(l_fct_index).ORGANIZATION_ID := l_fs_arr_org_id_tbl(i);
1464: l_forecast_interface_tbl(l_fct_index).FORECAST_DATE := l_fs_arrival_date_tbl(i);
1465: l_forecast_interface_tbl(l_fct_index).LAST_UPDATE_DATE := sysdate;
1466: l_forecast_interface_tbl(l_fct_index).LAST_UPDATED_BY := fnd_global.USER_ID;
1467: l_forecast_interface_tbl(l_fct_index).CREATION_DATE := sysdate;
1468: l_forecast_interface_tbl(l_fct_index).CREATED_BY := fnd_global.USER_ID;
1469: l_forecast_interface_tbl(l_fct_index).LAST_UPDATE_LOGIN := fnd_global.LOGIN_ID;
1470: l_forecast_interface_tbl(l_fct_index).QUANTITY := l_dtls_quantity_tbl(j);

Line 1468: l_forecast_interface_tbl(l_fct_index).CREATED_BY := fnd_global.USER_ID;

1464: l_forecast_interface_tbl(l_fct_index).FORECAST_DATE := l_fs_arrival_date_tbl(i);
1465: l_forecast_interface_tbl(l_fct_index).LAST_UPDATE_DATE := sysdate;
1466: l_forecast_interface_tbl(l_fct_index).LAST_UPDATED_BY := fnd_global.USER_ID;
1467: l_forecast_interface_tbl(l_fct_index).CREATION_DATE := sysdate;
1468: l_forecast_interface_tbl(l_fct_index).CREATED_BY := fnd_global.USER_ID;
1469: l_forecast_interface_tbl(l_fct_index).LAST_UPDATE_LOGIN := fnd_global.LOGIN_ID;
1470: l_forecast_interface_tbl(l_fct_index).QUANTITY := l_dtls_quantity_tbl(j);
1471: l_forecast_interface_tbl(l_fct_index).PROCESS_STATUS := 2;
1472: l_forecast_interface_tbl(l_fct_index).CONFIDENCE_PERCENTAGE := 100;

Line 1469: l_forecast_interface_tbl(l_fct_index).LAST_UPDATE_LOGIN := fnd_global.LOGIN_ID;

1465: l_forecast_interface_tbl(l_fct_index).LAST_UPDATE_DATE := sysdate;
1466: l_forecast_interface_tbl(l_fct_index).LAST_UPDATED_BY := fnd_global.USER_ID;
1467: l_forecast_interface_tbl(l_fct_index).CREATION_DATE := sysdate;
1468: l_forecast_interface_tbl(l_fct_index).CREATED_BY := fnd_global.USER_ID;
1469: l_forecast_interface_tbl(l_fct_index).LAST_UPDATE_LOGIN := fnd_global.LOGIN_ID;
1470: l_forecast_interface_tbl(l_fct_index).QUANTITY := l_dtls_quantity_tbl(j);
1471: l_forecast_interface_tbl(l_fct_index).PROCESS_STATUS := 2;
1472: l_forecast_interface_tbl(l_fct_index).CONFIDENCE_PERCENTAGE := 100;
1473: l_forecast_interface_tbl(l_fct_index).COMMENTS := null;

Line 1859: l_forecast_interface_tbl(l_fct_index).LAST_UPDATED_BY := fnd_global.USER_ID;

1855: l_forecast_interface_tbl(l_fct_index).FORECAST_DESIGNATOR := l_dummy_fct_desg_tbl(f);
1856: l_forecast_interface_tbl(l_fct_index).ORGANIZATION_ID := l_fs_arr_org_id_tbl(i);
1857: l_forecast_interface_tbl(l_fct_index).FORECAST_DATE := l_fs_arrival_date_tbl(i);
1858: l_forecast_interface_tbl(l_fct_index).LAST_UPDATE_DATE := sysdate;
1859: l_forecast_interface_tbl(l_fct_index).LAST_UPDATED_BY := fnd_global.USER_ID;
1860: l_forecast_interface_tbl(l_fct_index).CREATION_DATE := sysdate;
1861: l_forecast_interface_tbl(l_fct_index).CREATED_BY := fnd_global.USER_ID;
1862: l_forecast_interface_tbl(l_fct_index).LAST_UPDATE_LOGIN := fnd_global.LOGIN_ID;
1863: l_forecast_interface_tbl(l_fct_index).QUANTITY := 0;

Line 1861: l_forecast_interface_tbl(l_fct_index).CREATED_BY := fnd_global.USER_ID;

1857: l_forecast_interface_tbl(l_fct_index).FORECAST_DATE := l_fs_arrival_date_tbl(i);
1858: l_forecast_interface_tbl(l_fct_index).LAST_UPDATE_DATE := sysdate;
1859: l_forecast_interface_tbl(l_fct_index).LAST_UPDATED_BY := fnd_global.USER_ID;
1860: l_forecast_interface_tbl(l_fct_index).CREATION_DATE := sysdate;
1861: l_forecast_interface_tbl(l_fct_index).CREATED_BY := fnd_global.USER_ID;
1862: l_forecast_interface_tbl(l_fct_index).LAST_UPDATE_LOGIN := fnd_global.LOGIN_ID;
1863: l_forecast_interface_tbl(l_fct_index).QUANTITY := 0;
1864: l_forecast_interface_tbl(l_fct_index).PROCESS_STATUS := 2;
1865: l_forecast_interface_tbl(l_fct_index).CONFIDENCE_PERCENTAGE := 100;

Line 1862: l_forecast_interface_tbl(l_fct_index).LAST_UPDATE_LOGIN := fnd_global.LOGIN_ID;

1858: l_forecast_interface_tbl(l_fct_index).LAST_UPDATE_DATE := sysdate;
1859: l_forecast_interface_tbl(l_fct_index).LAST_UPDATED_BY := fnd_global.USER_ID;
1860: l_forecast_interface_tbl(l_fct_index).CREATION_DATE := sysdate;
1861: l_forecast_interface_tbl(l_fct_index).CREATED_BY := fnd_global.USER_ID;
1862: l_forecast_interface_tbl(l_fct_index).LAST_UPDATE_LOGIN := fnd_global.LOGIN_ID;
1863: l_forecast_interface_tbl(l_fct_index).QUANTITY := 0;
1864: l_forecast_interface_tbl(l_fct_index).PROCESS_STATUS := 2;
1865: l_forecast_interface_tbl(l_fct_index).CONFIDENCE_PERCENTAGE := 100;
1866: l_forecast_interface_tbl(l_fct_index).COMMENTS := null;

Line 2076: mpothuku Added fnd_global.local_chr(10) (or new line) for the Bug 5724555 on 21-Dec-06. FND_FILE.put has a restriction of 32K characters.

2072:
2073: -- XML generated with dbms_xmlgen doesnt have encoding information. so we need to manually insert into the resultant CLOB.
2074: dbms_lob.write(l_fct_data_lob,length(''),1,'');
2075: /*
2076: mpothuku Added fnd_global.local_chr(10) (or new line) for the Bug 5724555 on 21-Dec-06. FND_FILE.put has a restriction of 32K characters.
2077: If there is no new-line in these 32K characters, it fails. So ensuring that there are new-line characters after every line
2078: of the XML
2079: */
2080: dbms_lob.write(l_fct_data_lob,length(fnd_global.local_chr(10)),length(l_fct_data_lob)+1,fnd_global.local_chr(10));

Line 2080: dbms_lob.write(l_fct_data_lob,length(fnd_global.local_chr(10)),length(l_fct_data_lob)+1,fnd_global.local_chr(10));

2076: mpothuku Added fnd_global.local_chr(10) (or new line) for the Bug 5724555 on 21-Dec-06. FND_FILE.put has a restriction of 32K characters.
2077: If there is no new-line in these 32K characters, it fails. So ensuring that there are new-line characters after every line
2078: of the XML
2079: */
2080: dbms_lob.write(l_fct_data_lob,length(fnd_global.local_chr(10)),length(l_fct_data_lob)+1,fnd_global.local_chr(10));
2081: --Put the root node to maintain the XML completeness.
2082: dbms_lob.write(l_fct_data_lob, length(''),length(l_fct_data_lob)+1, '');
2083: dbms_lob.write(l_fct_data_lob,length(fnd_global.local_chr(10)),length(l_fct_data_lob)+1,fnd_global.local_chr(10));
2084: --Put the Start Date and the End Date

Line 2083: dbms_lob.write(l_fct_data_lob,length(fnd_global.local_chr(10)),length(l_fct_data_lob)+1,fnd_global.local_chr(10));

2079: */
2080: dbms_lob.write(l_fct_data_lob,length(fnd_global.local_chr(10)),length(l_fct_data_lob)+1,fnd_global.local_chr(10));
2081: --Put the root node to maintain the XML completeness.
2082: dbms_lob.write(l_fct_data_lob, length(''),length(l_fct_data_lob)+1, '');
2083: dbms_lob.write(l_fct_data_lob,length(fnd_global.local_chr(10)),length(l_fct_data_lob)+1,fnd_global.local_chr(10));
2084: --Put the Start Date and the End Date
2085: --mpothuku Added to_char on 23 Aug, 06 for XSL canonical date format to be used by the XMLP report for the Bug 5460793
2086: l_dummy_string := '' || to_char(p_start_date,'YYYY-MM-DD') || ''||fnd_global.local_chr(10);
2087: l_dummy_string := l_dummy_string || '' || to_char(p_end_date,'YYYY-MM-DD') || '' ||fnd_global.local_chr(10);

Line 2086: l_dummy_string := '' || to_char(p_start_date,'YYYY-MM-DD') || ''||fnd_global.local_chr(10);

2082: dbms_lob.write(l_fct_data_lob, length(''),length(l_fct_data_lob)+1, '');
2083: dbms_lob.write(l_fct_data_lob,length(fnd_global.local_chr(10)),length(l_fct_data_lob)+1,fnd_global.local_chr(10));
2084: --Put the Start Date and the End Date
2085: --mpothuku Added to_char on 23 Aug, 06 for XSL canonical date format to be used by the XMLP report for the Bug 5460793
2086: l_dummy_string := '' || to_char(p_start_date,'YYYY-MM-DD') || ''||fnd_global.local_chr(10);
2087: l_dummy_string := l_dummy_string || '' || to_char(p_end_date,'YYYY-MM-DD') || '' ||fnd_global.local_chr(10);
2088: dbms_lob.write(l_fct_data_lob, length(l_dummy_string),length(l_fct_data_lob)+1, l_dummy_string);
2089:
2090: IF l_forecast_interface_tbl.COUNT > 0 THEN

Line 2087: l_dummy_string := l_dummy_string || '' || to_char(p_end_date,'YYYY-MM-DD') || '' ||fnd_global.local_chr(10);

2083: dbms_lob.write(l_fct_data_lob,length(fnd_global.local_chr(10)),length(l_fct_data_lob)+1,fnd_global.local_chr(10));
2084: --Put the Start Date and the End Date
2085: --mpothuku Added to_char on 23 Aug, 06 for XSL canonical date format to be used by the XMLP report for the Bug 5460793
2086: l_dummy_string := '' || to_char(p_start_date,'YYYY-MM-DD') || ''||fnd_global.local_chr(10);
2087: l_dummy_string := l_dummy_string || '' || to_char(p_end_date,'YYYY-MM-DD') || '' ||fnd_global.local_chr(10);
2088: dbms_lob.write(l_fct_data_lob, length(l_dummy_string),length(l_fct_data_lob)+1, l_dummy_string);
2089:
2090: IF l_forecast_interface_tbl.COUNT > 0 THEN
2091: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

Line 2106: l_dummy_string := ''||fnd_global.local_chr(10);

2102: */
2103: FOR c in l_forecast_interface_tbl.FIRST .. l_forecast_interface_tbl.LAST LOOP
2104: IF l_incl_in_rpt_flag_tbl(c) = 'Y' THEN -- Check if Interface rec is candidate for Output report.
2105: l_row_count := l_row_count + 1;
2106: l_dummy_string := ''||fnd_global.local_chr(10);
2107: l_dummy_string := l_dummy_string || '' ||l_forecast_interface_tbl(c).ORGANIZATION_ID ||''||fnd_global.local_chr(10);
2108: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_org_code_tbl(c)) ||''||fnd_global.local_chr(10);
2109: l_dummy_string := l_dummy_string || '' ||l_forecast_interface_tbl(c).INVENTORY_ITEM_ID ||''||fnd_global.local_chr(10);
2110: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_item_name_tbl(c)) ||''||fnd_global.local_chr(10);

Line 2107: l_dummy_string := l_dummy_string || '' ||l_forecast_interface_tbl(c).ORGANIZATION_ID ||''||fnd_global.local_chr(10);

2103: FOR c in l_forecast_interface_tbl.FIRST .. l_forecast_interface_tbl.LAST LOOP
2104: IF l_incl_in_rpt_flag_tbl(c) = 'Y' THEN -- Check if Interface rec is candidate for Output report.
2105: l_row_count := l_row_count + 1;
2106: l_dummy_string := ''||fnd_global.local_chr(10);
2107: l_dummy_string := l_dummy_string || '' ||l_forecast_interface_tbl(c).ORGANIZATION_ID ||''||fnd_global.local_chr(10);
2108: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_org_code_tbl(c)) ||''||fnd_global.local_chr(10);
2109: l_dummy_string := l_dummy_string || '' ||l_forecast_interface_tbl(c).INVENTORY_ITEM_ID ||''||fnd_global.local_chr(10);
2110: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_item_name_tbl(c)) ||''||fnd_global.local_chr(10);
2111: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_item_desc_tbl(c)) ||''||fnd_global.local_chr(10);

Line 2108: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_org_code_tbl(c)) ||''||fnd_global.local_chr(10);

2104: IF l_incl_in_rpt_flag_tbl(c) = 'Y' THEN -- Check if Interface rec is candidate for Output report.
2105: l_row_count := l_row_count + 1;
2106: l_dummy_string := ''||fnd_global.local_chr(10);
2107: l_dummy_string := l_dummy_string || '' ||l_forecast_interface_tbl(c).ORGANIZATION_ID ||''||fnd_global.local_chr(10);
2108: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_org_code_tbl(c)) ||''||fnd_global.local_chr(10);
2109: l_dummy_string := l_dummy_string || '' ||l_forecast_interface_tbl(c).INVENTORY_ITEM_ID ||''||fnd_global.local_chr(10);
2110: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_item_name_tbl(c)) ||''||fnd_global.local_chr(10);
2111: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_item_desc_tbl(c)) ||''||fnd_global.local_chr(10);
2112: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_srl_no_tbl(c)) ||''||fnd_global.local_chr(10);

Line 2109: l_dummy_string := l_dummy_string || '' ||l_forecast_interface_tbl(c).INVENTORY_ITEM_ID ||''||fnd_global.local_chr(10);

2105: l_row_count := l_row_count + 1;
2106: l_dummy_string := ''||fnd_global.local_chr(10);
2107: l_dummy_string := l_dummy_string || '' ||l_forecast_interface_tbl(c).ORGANIZATION_ID ||''||fnd_global.local_chr(10);
2108: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_org_code_tbl(c)) ||''||fnd_global.local_chr(10);
2109: l_dummy_string := l_dummy_string || '' ||l_forecast_interface_tbl(c).INVENTORY_ITEM_ID ||''||fnd_global.local_chr(10);
2110: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_item_name_tbl(c)) ||''||fnd_global.local_chr(10);
2111: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_item_desc_tbl(c)) ||''||fnd_global.local_chr(10);
2112: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_srl_no_tbl(c)) ||''||fnd_global.local_chr(10);
2113: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_interface_tbl(c).FORECAST_DESIGNATOR) ||''||fnd_global.local_chr(10);

Line 2110: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_item_name_tbl(c)) ||''||fnd_global.local_chr(10);

2106: l_dummy_string := ''||fnd_global.local_chr(10);
2107: l_dummy_string := l_dummy_string || '' ||l_forecast_interface_tbl(c).ORGANIZATION_ID ||''||fnd_global.local_chr(10);
2108: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_org_code_tbl(c)) ||''||fnd_global.local_chr(10);
2109: l_dummy_string := l_dummy_string || '' ||l_forecast_interface_tbl(c).INVENTORY_ITEM_ID ||''||fnd_global.local_chr(10);
2110: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_item_name_tbl(c)) ||''||fnd_global.local_chr(10);
2111: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_item_desc_tbl(c)) ||''||fnd_global.local_chr(10);
2112: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_srl_no_tbl(c)) ||''||fnd_global.local_chr(10);
2113: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_interface_tbl(c).FORECAST_DESIGNATOR) ||''||fnd_global.local_chr(10);
2114: --mpothuku Added to_char on 23 Aug, 06 for XSL canonical date format to be used by the XMLP report for the Bug 5460793

Line 2111: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_item_desc_tbl(c)) ||''||fnd_global.local_chr(10);

2107: l_dummy_string := l_dummy_string || '' ||l_forecast_interface_tbl(c).ORGANIZATION_ID ||''||fnd_global.local_chr(10);
2108: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_org_code_tbl(c)) ||''||fnd_global.local_chr(10);
2109: l_dummy_string := l_dummy_string || '' ||l_forecast_interface_tbl(c).INVENTORY_ITEM_ID ||''||fnd_global.local_chr(10);
2110: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_item_name_tbl(c)) ||''||fnd_global.local_chr(10);
2111: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_item_desc_tbl(c)) ||''||fnd_global.local_chr(10);
2112: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_srl_no_tbl(c)) ||''||fnd_global.local_chr(10);
2113: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_interface_tbl(c).FORECAST_DESIGNATOR) ||''||fnd_global.local_chr(10);
2114: --mpothuku Added to_char on 23 Aug, 06 for XSL canonical date format to be used by the XMLP report for the Bug 5460793
2115: l_dummy_string := l_dummy_string || '' ||to_char(l_forecast_interface_tbl(c).FORECAST_DATE,'YYYY-MM-DD')||''||fnd_global.local_chr(10);

Line 2112: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_srl_no_tbl(c)) ||''||fnd_global.local_chr(10);

2108: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_org_code_tbl(c)) ||''||fnd_global.local_chr(10);
2109: l_dummy_string := l_dummy_string || '' ||l_forecast_interface_tbl(c).INVENTORY_ITEM_ID ||''||fnd_global.local_chr(10);
2110: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_item_name_tbl(c)) ||''||fnd_global.local_chr(10);
2111: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_item_desc_tbl(c)) ||''||fnd_global.local_chr(10);
2112: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_srl_no_tbl(c)) ||''||fnd_global.local_chr(10);
2113: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_interface_tbl(c).FORECAST_DESIGNATOR) ||''||fnd_global.local_chr(10);
2114: --mpothuku Added to_char on 23 Aug, 06 for XSL canonical date format to be used by the XMLP report for the Bug 5460793
2115: l_dummy_string := l_dummy_string || '' ||to_char(l_forecast_interface_tbl(c).FORECAST_DATE,'YYYY-MM-DD')||''||fnd_global.local_chr(10);
2116: l_dummy_string := l_dummy_string || '' ||to_char(l_forecast_interface_tbl(c).FORECAST_DATE,'MON-YYYY')||''||fnd_global.local_chr(10);

Line 2113: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_interface_tbl(c).FORECAST_DESIGNATOR) ||''||fnd_global.local_chr(10);

2109: l_dummy_string := l_dummy_string || '' ||l_forecast_interface_tbl(c).INVENTORY_ITEM_ID ||''||fnd_global.local_chr(10);
2110: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_item_name_tbl(c)) ||''||fnd_global.local_chr(10);
2111: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_item_desc_tbl(c)) ||''||fnd_global.local_chr(10);
2112: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_srl_no_tbl(c)) ||''||fnd_global.local_chr(10);
2113: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_interface_tbl(c).FORECAST_DESIGNATOR) ||''||fnd_global.local_chr(10);
2114: --mpothuku Added to_char on 23 Aug, 06 for XSL canonical date format to be used by the XMLP report for the Bug 5460793
2115: l_dummy_string := l_dummy_string || '' ||to_char(l_forecast_interface_tbl(c).FORECAST_DATE,'YYYY-MM-DD')||''||fnd_global.local_chr(10);
2116: l_dummy_string := l_dummy_string || '' ||to_char(l_forecast_interface_tbl(c).FORECAST_DATE,'MON-YYYY')||''||fnd_global.local_chr(10);
2117: l_dummy_string := l_dummy_string || '' ||l_forecast_interface_tbl(c).QUANTITY ||''||fnd_global.local_chr(10);

Line 2115: l_dummy_string := l_dummy_string || '' ||to_char(l_forecast_interface_tbl(c).FORECAST_DATE,'YYYY-MM-DD')||''||fnd_global.local_chr(10);

2111: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_item_desc_tbl(c)) ||''||fnd_global.local_chr(10);
2112: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_srl_no_tbl(c)) ||''||fnd_global.local_chr(10);
2113: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_interface_tbl(c).FORECAST_DESIGNATOR) ||''||fnd_global.local_chr(10);
2114: --mpothuku Added to_char on 23 Aug, 06 for XSL canonical date format to be used by the XMLP report for the Bug 5460793
2115: l_dummy_string := l_dummy_string || '' ||to_char(l_forecast_interface_tbl(c).FORECAST_DATE,'YYYY-MM-DD')||''||fnd_global.local_chr(10);
2116: l_dummy_string := l_dummy_string || '' ||to_char(l_forecast_interface_tbl(c).FORECAST_DATE,'MON-YYYY')||''||fnd_global.local_chr(10);
2117: l_dummy_string := l_dummy_string || '' ||l_forecast_interface_tbl(c).QUANTITY ||''||fnd_global.local_chr(10);
2118: l_dummy_string := l_dummy_string || '' ||l_forecast_req_prob_tbl(c) ||''||fnd_global.local_chr(10);
2119: l_dummy_string := l_dummy_string || '' ||l_forecast_onhand_qty_tbl(c) ||''||fnd_global.local_chr(10);

Line 2116: l_dummy_string := l_dummy_string || '' ||to_char(l_forecast_interface_tbl(c).FORECAST_DATE,'MON-YYYY')||''||fnd_global.local_chr(10);

2112: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_srl_no_tbl(c)) ||''||fnd_global.local_chr(10);
2113: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_interface_tbl(c).FORECAST_DESIGNATOR) ||''||fnd_global.local_chr(10);
2114: --mpothuku Added to_char on 23 Aug, 06 for XSL canonical date format to be used by the XMLP report for the Bug 5460793
2115: l_dummy_string := l_dummy_string || '' ||to_char(l_forecast_interface_tbl(c).FORECAST_DATE,'YYYY-MM-DD')||''||fnd_global.local_chr(10);
2116: l_dummy_string := l_dummy_string || '' ||to_char(l_forecast_interface_tbl(c).FORECAST_DATE,'MON-YYYY')||''||fnd_global.local_chr(10);
2117: l_dummy_string := l_dummy_string || '' ||l_forecast_interface_tbl(c).QUANTITY ||''||fnd_global.local_chr(10);
2118: l_dummy_string := l_dummy_string || '' ||l_forecast_req_prob_tbl(c) ||''||fnd_global.local_chr(10);
2119: l_dummy_string := l_dummy_string || '' ||l_forecast_onhand_qty_tbl(c) ||''||fnd_global.local_chr(10);
2120: l_dummy_string := l_dummy_string || '' ||l_forecast_osp_qty_tbl(c) ||''||fnd_global.local_chr(10);

Line 2117: l_dummy_string := l_dummy_string || '' ||l_forecast_interface_tbl(c).QUANTITY ||''||fnd_global.local_chr(10);

2113: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_interface_tbl(c).FORECAST_DESIGNATOR) ||''||fnd_global.local_chr(10);
2114: --mpothuku Added to_char on 23 Aug, 06 for XSL canonical date format to be used by the XMLP report for the Bug 5460793
2115: l_dummy_string := l_dummy_string || '' ||to_char(l_forecast_interface_tbl(c).FORECAST_DATE,'YYYY-MM-DD')||''||fnd_global.local_chr(10);
2116: l_dummy_string := l_dummy_string || '' ||to_char(l_forecast_interface_tbl(c).FORECAST_DATE,'MON-YYYY')||''||fnd_global.local_chr(10);
2117: l_dummy_string := l_dummy_string || '' ||l_forecast_interface_tbl(c).QUANTITY ||''||fnd_global.local_chr(10);
2118: l_dummy_string := l_dummy_string || '' ||l_forecast_req_prob_tbl(c) ||''||fnd_global.local_chr(10);
2119: l_dummy_string := l_dummy_string || '' ||l_forecast_onhand_qty_tbl(c) ||''||fnd_global.local_chr(10);
2120: l_dummy_string := l_dummy_string || '' ||l_forecast_osp_qty_tbl(c) ||''||fnd_global.local_chr(10);
2121: l_dummy_string := l_dummy_string || '' ||l_forecast_vwp_qty_tbl(c) ||''||fnd_global.local_chr(10);

Line 2118: l_dummy_string := l_dummy_string || '' ||l_forecast_req_prob_tbl(c) ||''||fnd_global.local_chr(10);

2114: --mpothuku Added to_char on 23 Aug, 06 for XSL canonical date format to be used by the XMLP report for the Bug 5460793
2115: l_dummy_string := l_dummy_string || '' ||to_char(l_forecast_interface_tbl(c).FORECAST_DATE,'YYYY-MM-DD')||''||fnd_global.local_chr(10);
2116: l_dummy_string := l_dummy_string || '' ||to_char(l_forecast_interface_tbl(c).FORECAST_DATE,'MON-YYYY')||''||fnd_global.local_chr(10);
2117: l_dummy_string := l_dummy_string || '' ||l_forecast_interface_tbl(c).QUANTITY ||''||fnd_global.local_chr(10);
2118: l_dummy_string := l_dummy_string || '' ||l_forecast_req_prob_tbl(c) ||''||fnd_global.local_chr(10);
2119: l_dummy_string := l_dummy_string || '' ||l_forecast_onhand_qty_tbl(c) ||''||fnd_global.local_chr(10);
2120: l_dummy_string := l_dummy_string || '' ||l_forecast_osp_qty_tbl(c) ||''||fnd_global.local_chr(10);
2121: l_dummy_string := l_dummy_string || '' ||l_forecast_vwp_qty_tbl(c) ||''||fnd_global.local_chr(10);
2122: l_dummy_string := l_dummy_string || '' ||l_forecast_non_qty_tbl(c) ||''||fnd_global.local_chr(10);

Line 2119: l_dummy_string := l_dummy_string || '' ||l_forecast_onhand_qty_tbl(c) ||''||fnd_global.local_chr(10);

2115: l_dummy_string := l_dummy_string || '' ||to_char(l_forecast_interface_tbl(c).FORECAST_DATE,'YYYY-MM-DD')||''||fnd_global.local_chr(10);
2116: l_dummy_string := l_dummy_string || '' ||to_char(l_forecast_interface_tbl(c).FORECAST_DATE,'MON-YYYY')||''||fnd_global.local_chr(10);
2117: l_dummy_string := l_dummy_string || '' ||l_forecast_interface_tbl(c).QUANTITY ||''||fnd_global.local_chr(10);
2118: l_dummy_string := l_dummy_string || '' ||l_forecast_req_prob_tbl(c) ||''||fnd_global.local_chr(10);
2119: l_dummy_string := l_dummy_string || '' ||l_forecast_onhand_qty_tbl(c) ||''||fnd_global.local_chr(10);
2120: l_dummy_string := l_dummy_string || '' ||l_forecast_osp_qty_tbl(c) ||''||fnd_global.local_chr(10);
2121: l_dummy_string := l_dummy_string || '' ||l_forecast_vwp_qty_tbl(c) ||''||fnd_global.local_chr(10);
2122: l_dummy_string := l_dummy_string || '' ||l_forecast_non_qty_tbl(c) ||''||fnd_global.local_chr(10);
2123: l_dummy_string := l_dummy_string || '' ||l_forecast_interface_tbl(c).PROCESS_STATUS ||''||fnd_global.local_chr(10);

Line 2120: l_dummy_string := l_dummy_string || '' ||l_forecast_osp_qty_tbl(c) ||''||fnd_global.local_chr(10);

2116: l_dummy_string := l_dummy_string || '' ||to_char(l_forecast_interface_tbl(c).FORECAST_DATE,'MON-YYYY')||''||fnd_global.local_chr(10);
2117: l_dummy_string := l_dummy_string || '' ||l_forecast_interface_tbl(c).QUANTITY ||''||fnd_global.local_chr(10);
2118: l_dummy_string := l_dummy_string || '' ||l_forecast_req_prob_tbl(c) ||''||fnd_global.local_chr(10);
2119: l_dummy_string := l_dummy_string || '' ||l_forecast_onhand_qty_tbl(c) ||''||fnd_global.local_chr(10);
2120: l_dummy_string := l_dummy_string || '' ||l_forecast_osp_qty_tbl(c) ||''||fnd_global.local_chr(10);
2121: l_dummy_string := l_dummy_string || '' ||l_forecast_vwp_qty_tbl(c) ||''||fnd_global.local_chr(10);
2122: l_dummy_string := l_dummy_string || '' ||l_forecast_non_qty_tbl(c) ||''||fnd_global.local_chr(10);
2123: l_dummy_string := l_dummy_string || '' ||l_forecast_interface_tbl(c).PROCESS_STATUS ||''||fnd_global.local_chr(10);
2124: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_interface_tbl(c).ERROR_MESSAGE) ||''||fnd_global.local_chr(10);

Line 2121: l_dummy_string := l_dummy_string || '' ||l_forecast_vwp_qty_tbl(c) ||''||fnd_global.local_chr(10);

2117: l_dummy_string := l_dummy_string || '' ||l_forecast_interface_tbl(c).QUANTITY ||''||fnd_global.local_chr(10);
2118: l_dummy_string := l_dummy_string || '' ||l_forecast_req_prob_tbl(c) ||''||fnd_global.local_chr(10);
2119: l_dummy_string := l_dummy_string || '' ||l_forecast_onhand_qty_tbl(c) ||''||fnd_global.local_chr(10);
2120: l_dummy_string := l_dummy_string || '' ||l_forecast_osp_qty_tbl(c) ||''||fnd_global.local_chr(10);
2121: l_dummy_string := l_dummy_string || '' ||l_forecast_vwp_qty_tbl(c) ||''||fnd_global.local_chr(10);
2122: l_dummy_string := l_dummy_string || '' ||l_forecast_non_qty_tbl(c) ||''||fnd_global.local_chr(10);
2123: l_dummy_string := l_dummy_string || '' ||l_forecast_interface_tbl(c).PROCESS_STATUS ||''||fnd_global.local_chr(10);
2124: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_interface_tbl(c).ERROR_MESSAGE) ||''||fnd_global.local_chr(10);
2125: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_interface_tbl(c).SOURCE_CODE) ||''||fnd_global.local_chr(10);

Line 2122: l_dummy_string := l_dummy_string || '' ||l_forecast_non_qty_tbl(c) ||''||fnd_global.local_chr(10);

2118: l_dummy_string := l_dummy_string || '' ||l_forecast_req_prob_tbl(c) ||''||fnd_global.local_chr(10);
2119: l_dummy_string := l_dummy_string || '' ||l_forecast_onhand_qty_tbl(c) ||''||fnd_global.local_chr(10);
2120: l_dummy_string := l_dummy_string || '' ||l_forecast_osp_qty_tbl(c) ||''||fnd_global.local_chr(10);
2121: l_dummy_string := l_dummy_string || '' ||l_forecast_vwp_qty_tbl(c) ||''||fnd_global.local_chr(10);
2122: l_dummy_string := l_dummy_string || '' ||l_forecast_non_qty_tbl(c) ||''||fnd_global.local_chr(10);
2123: l_dummy_string := l_dummy_string || '' ||l_forecast_interface_tbl(c).PROCESS_STATUS ||''||fnd_global.local_chr(10);
2124: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_interface_tbl(c).ERROR_MESSAGE) ||''||fnd_global.local_chr(10);
2125: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_interface_tbl(c).SOURCE_CODE) ||''||fnd_global.local_chr(10);
2126: l_dummy_string := l_dummy_string || '' ||l_forecast_interface_tbl(c).SOURCE_LINE_ID ||''||fnd_global.local_chr(10);

Line 2123: l_dummy_string := l_dummy_string || '' ||l_forecast_interface_tbl(c).PROCESS_STATUS ||''||fnd_global.local_chr(10);

2119: l_dummy_string := l_dummy_string || '' ||l_forecast_onhand_qty_tbl(c) ||''||fnd_global.local_chr(10);
2120: l_dummy_string := l_dummy_string || '' ||l_forecast_osp_qty_tbl(c) ||''||fnd_global.local_chr(10);
2121: l_dummy_string := l_dummy_string || '' ||l_forecast_vwp_qty_tbl(c) ||''||fnd_global.local_chr(10);
2122: l_dummy_string := l_dummy_string || '' ||l_forecast_non_qty_tbl(c) ||''||fnd_global.local_chr(10);
2123: l_dummy_string := l_dummy_string || '' ||l_forecast_interface_tbl(c).PROCESS_STATUS ||''||fnd_global.local_chr(10);
2124: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_interface_tbl(c).ERROR_MESSAGE) ||''||fnd_global.local_chr(10);
2125: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_interface_tbl(c).SOURCE_CODE) ||''||fnd_global.local_chr(10);
2126: l_dummy_string := l_dummy_string || '' ||l_forecast_interface_tbl(c).SOURCE_LINE_ID ||''||fnd_global.local_chr(10);
2127:

Line 2124: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_interface_tbl(c).ERROR_MESSAGE) ||''||fnd_global.local_chr(10);

2120: l_dummy_string := l_dummy_string || '' ||l_forecast_osp_qty_tbl(c) ||''||fnd_global.local_chr(10);
2121: l_dummy_string := l_dummy_string || '' ||l_forecast_vwp_qty_tbl(c) ||''||fnd_global.local_chr(10);
2122: l_dummy_string := l_dummy_string || '' ||l_forecast_non_qty_tbl(c) ||''||fnd_global.local_chr(10);
2123: l_dummy_string := l_dummy_string || '' ||l_forecast_interface_tbl(c).PROCESS_STATUS ||''||fnd_global.local_chr(10);
2124: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_interface_tbl(c).ERROR_MESSAGE) ||''||fnd_global.local_chr(10);
2125: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_interface_tbl(c).SOURCE_CODE) ||''||fnd_global.local_chr(10);
2126: l_dummy_string := l_dummy_string || '' ||l_forecast_interface_tbl(c).SOURCE_LINE_ID ||''||fnd_global.local_chr(10);
2127:
2128: -- This 'Hard Coded' Data will be replaced by Lookups / Messages -- Pending

Line 2125: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_interface_tbl(c).SOURCE_CODE) ||''||fnd_global.local_chr(10);

2121: l_dummy_string := l_dummy_string || '' ||l_forecast_vwp_qty_tbl(c) ||''||fnd_global.local_chr(10);
2122: l_dummy_string := l_dummy_string || '' ||l_forecast_non_qty_tbl(c) ||''||fnd_global.local_chr(10);
2123: l_dummy_string := l_dummy_string || '' ||l_forecast_interface_tbl(c).PROCESS_STATUS ||''||fnd_global.local_chr(10);
2124: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_interface_tbl(c).ERROR_MESSAGE) ||''||fnd_global.local_chr(10);
2125: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_interface_tbl(c).SOURCE_CODE) ||''||fnd_global.local_chr(10);
2126: l_dummy_string := l_dummy_string || '' ||l_forecast_interface_tbl(c).SOURCE_LINE_ID ||''||fnd_global.local_chr(10);
2127:
2128: -- This 'Hard Coded' Data will be replaced by Lookups / Messages -- Pending
2129: IF l_forecast_interface_tbl(c).PROCESS_STATUS = 1 THEN

Line 2126: l_dummy_string := l_dummy_string || '' ||l_forecast_interface_tbl(c).SOURCE_LINE_ID ||''||fnd_global.local_chr(10);

2122: l_dummy_string := l_dummy_string || '' ||l_forecast_non_qty_tbl(c) ||''||fnd_global.local_chr(10);
2123: l_dummy_string := l_dummy_string || '' ||l_forecast_interface_tbl(c).PROCESS_STATUS ||''||fnd_global.local_chr(10);
2124: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_interface_tbl(c).ERROR_MESSAGE) ||''||fnd_global.local_chr(10);
2125: l_dummy_string := l_dummy_string || '' ||dbms_xmlgen.convert(l_forecast_interface_tbl(c).SOURCE_CODE) ||''||fnd_global.local_chr(10);
2126: l_dummy_string := l_dummy_string || '' ||l_forecast_interface_tbl(c).SOURCE_LINE_ID ||''||fnd_global.local_chr(10);
2127:
2128: -- This 'Hard Coded' Data will be replaced by Lookups / Messages -- Pending
2129: IF l_forecast_interface_tbl(c).PROCESS_STATUS = 1 THEN
2130: l_dummy_string := l_dummy_string || '' || ' Do Not Process ' ||''||fnd_global.local_chr(10);

Line 2130: l_dummy_string := l_dummy_string || '' || ' Do Not Process ' ||''||fnd_global.local_chr(10);

2126: l_dummy_string := l_dummy_string || '' ||l_forecast_interface_tbl(c).SOURCE_LINE_ID ||''||fnd_global.local_chr(10);
2127:
2128: -- This 'Hard Coded' Data will be replaced by Lookups / Messages -- Pending
2129: IF l_forecast_interface_tbl(c).PROCESS_STATUS = 1 THEN
2130: l_dummy_string := l_dummy_string || '' || ' Do Not Process ' ||''||fnd_global.local_chr(10);
2131: ELSIF l_forecast_interface_tbl(c).PROCESS_STATUS = 2 THEN
2132: l_dummy_string := l_dummy_string || '' || ' Waiting to be processed ' ||''||fnd_global.local_chr(10);
2133: ELSIF l_forecast_interface_tbl(c).PROCESS_STATUS = 3 THEN
2134: l_dummy_string := l_dummy_string || '' || ' Being Processed ' ||''||fnd_global.local_chr(10);

Line 2132: l_dummy_string := l_dummy_string || '' || ' Waiting to be processed ' ||''||fnd_global.local_chr(10);

2128: -- This 'Hard Coded' Data will be replaced by Lookups / Messages -- Pending
2129: IF l_forecast_interface_tbl(c).PROCESS_STATUS = 1 THEN
2130: l_dummy_string := l_dummy_string || '' || ' Do Not Process ' ||''||fnd_global.local_chr(10);
2131: ELSIF l_forecast_interface_tbl(c).PROCESS_STATUS = 2 THEN
2132: l_dummy_string := l_dummy_string || '' || ' Waiting to be processed ' ||''||fnd_global.local_chr(10);
2133: ELSIF l_forecast_interface_tbl(c).PROCESS_STATUS = 3 THEN
2134: l_dummy_string := l_dummy_string || '' || ' Being Processed ' ||''||fnd_global.local_chr(10);
2135: ELSIF l_forecast_interface_tbl(c).PROCESS_STATUS = 4 THEN
2136: l_dummy_string := l_dummy_string || '' || ' Error ' ||''||fnd_global.local_chr(10);

Line 2134: l_dummy_string := l_dummy_string || '' || ' Being Processed ' ||''||fnd_global.local_chr(10);

2130: l_dummy_string := l_dummy_string || '' || ' Do Not Process ' ||''||fnd_global.local_chr(10);
2131: ELSIF l_forecast_interface_tbl(c).PROCESS_STATUS = 2 THEN
2132: l_dummy_string := l_dummy_string || '' || ' Waiting to be processed ' ||''||fnd_global.local_chr(10);
2133: ELSIF l_forecast_interface_tbl(c).PROCESS_STATUS = 3 THEN
2134: l_dummy_string := l_dummy_string || '' || ' Being Processed ' ||''||fnd_global.local_chr(10);
2135: ELSIF l_forecast_interface_tbl(c).PROCESS_STATUS = 4 THEN
2136: l_dummy_string := l_dummy_string || '' || ' Error ' ||''||fnd_global.local_chr(10);
2137: ELSIF l_forecast_interface_tbl(c).PROCESS_STATUS = 5 THEN
2138: l_dummy_string := l_dummy_string || '' || ' Processed ' ||''||fnd_global.local_chr(10);

Line 2136: l_dummy_string := l_dummy_string || '' || ' Error ' ||''||fnd_global.local_chr(10);

2132: l_dummy_string := l_dummy_string || '' || ' Waiting to be processed ' ||''||fnd_global.local_chr(10);
2133: ELSIF l_forecast_interface_tbl(c).PROCESS_STATUS = 3 THEN
2134: l_dummy_string := l_dummy_string || '' || ' Being Processed ' ||''||fnd_global.local_chr(10);
2135: ELSIF l_forecast_interface_tbl(c).PROCESS_STATUS = 4 THEN
2136: l_dummy_string := l_dummy_string || '' || ' Error ' ||''||fnd_global.local_chr(10);
2137: ELSIF l_forecast_interface_tbl(c).PROCESS_STATUS = 5 THEN
2138: l_dummy_string := l_dummy_string || '' || ' Processed ' ||''||fnd_global.local_chr(10);
2139: END IF;
2140:

Line 2138: l_dummy_string := l_dummy_string || '' || ' Processed ' ||''||fnd_global.local_chr(10);

2134: l_dummy_string := l_dummy_string || '' || ' Being Processed ' ||''||fnd_global.local_chr(10);
2135: ELSIF l_forecast_interface_tbl(c).PROCESS_STATUS = 4 THEN
2136: l_dummy_string := l_dummy_string || '' || ' Error ' ||''||fnd_global.local_chr(10);
2137: ELSIF l_forecast_interface_tbl(c).PROCESS_STATUS = 5 THEN
2138: l_dummy_string := l_dummy_string || '' || ' Processed ' ||''||fnd_global.local_chr(10);
2139: END IF;
2140:
2141: l_dummy_string := l_dummy_string || ''||fnd_global.local_chr(10);
2142: dbms_lob.write(l_fct_data_lob, length(l_dummy_string),length(l_fct_data_lob)+1, l_dummy_string);

Line 2141: l_dummy_string := l_dummy_string || ''||fnd_global.local_chr(10);

2137: ELSIF l_forecast_interface_tbl(c).PROCESS_STATUS = 5 THEN
2138: l_dummy_string := l_dummy_string || '' || ' Processed ' ||''||fnd_global.local_chr(10);
2139: END IF;
2140:
2141: l_dummy_string := l_dummy_string || ''||fnd_global.local_chr(10);
2142: dbms_lob.write(l_fct_data_lob, length(l_dummy_string),length(l_fct_data_lob)+1, l_dummy_string);
2143: END IF;
2144: END LOOP;
2145:

Line 2155: l_dummy_string := '' || l_row_count || ''||fnd_global.local_chr(10);

2151: fnd_file.put_line(fnd_file.log, ' -- Clob content empty for Output File ---- ');
2152: END IF;
2153: END IF;
2154:
2155: l_dummy_string := '' || l_row_count || ''||fnd_global.local_chr(10);
2156: dbms_lob.write(l_fct_data_lob, length(l_dummy_string),length(l_fct_data_lob)+1, l_dummy_string);
2157:
2158: dbms_lob.write(l_fct_data_lob, length(''),length(l_fct_data_lob)+1, '');
2159: