APPS.PO_DOCUMENT_CHECKS_GRP dependencies on PO_ONLINE_REPORT_TEXT

Line 1849: SELECT po_online_report_text_s.nextval

1845: d_progress := 10;
1846:
1847: -- SQL What: Get the id from the given nline report sequence
1848: -- SQL Why: Used for the new combined online report below.
1849: SELECT po_online_report_text_s.nextval
1850: INTO x_new_report_id
1851: FROM sys.dual;
1852:
1853: IF (PO_LOG.d_stmt) THEN

Line 1862: INSERT INTO PO_ONLINE_REPORT_TEXT

1858:
1859: -- SQL What: Copy all data rows from the online report 1 to the new combined
1860: -- online report.
1861: -- SQL Why: Construct the 1st part of the new combined online report.
1862: INSERT INTO PO_ONLINE_REPORT_TEXT
1863: (
1864: online_report_id
1865: ,sequence
1866: ,last_updated_by

Line 1918: FROM PO_ONLINE_REPORT_TEXT

1914: ,message_type
1915: ,show_in_psa_flag
1916: ,segment1
1917: ,distribution_type
1918: FROM PO_ONLINE_REPORT_TEXT
1919: WHERE online_report_id = p_report_id1
1920: ORDER BY sequence ASC;
1921:
1922: IF (PO_LOG.d_stmt) THEN

Line 1932: FROM PO_ONLINE_REPORT_TEXT

1928: -- SQL What: Retrieve the max sequence number value from all rows of online report 1.
1929: -- SQL Why: To set the start value for the sequence increment used to add rows from report 2.
1930: SELECT MAX(sequence)
1931: INTO l_id1_max_seq
1932: FROM PO_ONLINE_REPORT_TEXT
1933: WHERE online_report_id = p_report_id1;
1934:
1935: IF (PO_LOG.d_stmt) THEN
1936: PO_LOG.stmt(d_module,d_progress,'After got the max sequence for online report 1 rows as: '||l_id1_max_seq);

Line 1945: FROM PO_ONLINE_REPORT_TEXT

1941: -- SQL What: Retrieve list for all sequence numbers of report 2
1942: -- SQL Why: Used to count how many rows from report 2 need to be added to combined report.
1943: SELECT sequence
1944: BULK COLLECT INTO l_id2_seq_list
1945: FROM PO_ONLINE_REPORT_TEXT
1946: WHERE online_report_id = p_report_id2
1947: ORDER BY sequence ASC;
1948:
1949: IF (PO_LOG.d_stmt) THEN

Line 1961: INSERT INTO PO_ONLINE_REPORT_TEXT

1957: -- the combined report.
1958: -- SQL Why: Construct the 2nd part of the new combined online report.
1959: FOR i IN 1 .. l_id2_seq_list.COUNT
1960: LOOP
1961: INSERT INTO PO_ONLINE_REPORT_TEXT
1962: (
1963: online_report_id
1964: ,sequence
1965: ,last_updated_by

Line 2017: FROM PO_ONLINE_REPORT_TEXT

2013: ,message_type
2014: ,show_in_psa_flag
2015: ,segment1
2016: ,distribution_type
2017: FROM PO_ONLINE_REPORT_TEXT
2018: WHERE online_report_id = p_report_id2 and sequence = l_id2_seq_list(i);
2019: END LOOP;
2020:
2021: IF (PO_LOG.d_stmt) THEN

Line 2248: FROM PO_ONLINE_REPORT_TEXT

2244: -- SQL What: Get the number of data rows generated for report 1
2245: -- SQL Why: Used for the check below.
2246: SELECT COUNT(*)
2247: INTO l_report_id1_rownum
2248: FROM PO_ONLINE_REPORT_TEXT
2249: WHERE online_report_id = p_online_report_id;
2250:
2251: IF (PO_LOG.d_stmt) THEN
2252: PO_LOG.stmt(d_module,d_progress,'After counted the first report rows and get the count as: '|| TO_CHAR(l_report_id1_rownum));

Line 2261: FROM PO_ONLINE_REPORT_TEXT

2257: -- SQL What: Get the number of data rows generated for report 2
2258: -- SQL Why: Used for the check below.
2259: SELECT COUNT(*)
2260: INTO l_report_id2_rownum
2261: FROM PO_ONLINE_REPORT_TEXT
2262: WHERE online_report_id = l_report_id2;
2263:
2264: IF (PO_LOG.d_stmt) THEN
2265: PO_LOG.stmt(d_module,d_progress,'After counted the second report rows and get the count as: '|| TO_CHAR(l_report_id2_rownum));