APPS.OTA_ILEARNING dependencies on OTA_ILN_XML_PROCESSES

Line 1847: ota_iln_xml_processes

1843: cursor cur_get_record1 is
1844: select
1845: to_date
1846: from
1847: ota_iln_xml_processes
1848: where
1849: executable_name = p_process_name and
1850: business_group_id = l_business_group_id and
1851: site_id = l_site_id;

Line 1858: ota_iln_xml_processes

1854: cursor cur_get_record2 is
1855: select
1856: site_id
1857: from
1858: ota_iln_xml_processes
1859: where
1860: executable_name = p_process_name and
1861: business_group_id = l_business_group_id;
1862:

Line 1868: ota_iln_xml_processes

1864: cursor cur_get_record3 is
1865: select
1866: business_group_id
1867: from
1868: ota_iln_xml_processes
1869: where
1870: executable_name = p_process_name and
1871: site_id = l_site_id;
1872:

Line 1900: insert into ota_iln_xml_processes

1896: open cur_get_record3;
1897: fetch cur_get_record3 into l_2_business_group_id;
1898: if cur_get_record3%NOTFOUND then
1899: close cur_get_record3;
1900: insert into ota_iln_xml_processes
1901: (executable_name,
1902: business_group_id,
1903: site_id,
1904: from_date,

Line 1914: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Record created in ota_iln_xml_processes table for ' ||

1910: pl_end_date);
1911:
1912: l_status := 'S';
1913:
1914: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Record created in ota_iln_xml_processes table for ' ||
1915: -- ' process '|| p_process_name ||
1916: -- ' business group id ' || l_business_group_id ||
1917: -- ' and site id ' || l_site_id || '.');
1918: else

Line 1922: -- ' in ota_iln_xml_processes table. Where as concurrent program is using ' ||

1918: else
1919: close cur_get_record3;
1920: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Process '|| p_process_name || ' for site id ' ||
1921: -- l_site_id || ' is attached to business group id ' || l_business_group_id ||
1922: -- ' in ota_iln_xml_processes table. Where as concurrent program is using ' ||
1923: -- ' business group id ' || l_2_business_group_id || '. Please Correct.');
1924:
1925: FND_FILE.PUT_LINE(FND_FILE.LOG,'The Site ID '|| l_site_id || ' is already mapped to the Business Group ID '||
1926: l_2_business_group_id || '.');

Line 1934: -- ' in ota_iln_xml_processes table. Where as concurrent program is using site id ' ||

1930: else
1931: close cur_get_record2;
1932: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Process '|| p_process_name || ' for business group id ' ||
1933: -- l_business_group_id || ' is attached to site id ' || l_site_id ||
1934: -- ' in ota_iln_xml_processes table. Where as concurrent program is using site id ' ||
1935: -- l_2_site_id || '. Please Correct.');
1936:
1937: FND_FILE.PUT_LINE(FND_FILE.LOG,'The Business Group ID '|| l_business_group_id || ' is already mapped to the Site ID '||
1938: l_2_site_id || '.');

Line 1952: ota_iln_xml_processes

1948: if pl_start_date = l_end_date then
1949:
1950: /* --Do not need to update now. Created new procedure to update the table
1951: update
1952: ota_iln_xml_processes
1953: set
1954: from_date = p_start_date,
1955: to_date = p_end_date
1956: where

Line 1965: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent program will update ota_iln_xml_processes table' ||

1961: */
1962:
1963:
1964: FND_FILE.PUT_LINE(FND_FILE.LOG,'');
1965: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent program will update ota_iln_xml_processes table' ||
1966: -- ' with start and end date. ');
1967: else
1968: l_process_type := 'M';
1969: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent program will not update ota_iln_xml_processes' ||

Line 1969: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent program will not update ota_iln_xml_processes' ||

1965: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent program will update ota_iln_xml_processes table' ||
1966: -- ' with start and end date. ');
1967: else
1968: l_process_type := 'M';
1969: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Concurrent program will not update ota_iln_xml_processes' ||
1970: -- ' with start and end date. ');
1971: end if;
1972:
1973: end if;

Line 2014: ota_iln_xml_processes

2010: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Entering:' || l_proc);
2011:
2012:
2013: update
2014: ota_iln_xml_processes
2015: set
2016: from_date = l_start_date,
2017: to_date = l_end_date
2018: where

Line 2024: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'ota_iln_xml_processes table updated successfully' ||

2020: business_group_id = l_business_group_id and
2021: site_id = l_site_id;
2022:
2023:
2024: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'ota_iln_xml_processes table updated successfully' ||
2025: -- ' with start and end date. ');
2026: p_status := 'S';
2027:
2028: EXCEPTION