APPS.PO_DOCUMENT_CHECKS_GRP dependencies on PO_ONLINE_REPORT_TEXT

Line 1839: SELECT po_online_report_text_s.nextval

1835: d_progress := 10;
1836:
1837: -- SQL What: Get the id from the given nline report sequence
1838: -- SQL Why: Used for the new combined online report below.
1839: SELECT po_online_report_text_s.nextval
1840: INTO x_new_report_id
1841: FROM sys.dual;
1842:
1843: IF (PO_LOG.d_stmt) THEN

Line 1852: INSERT INTO PO_ONLINE_REPORT_TEXT

1848:
1849: -- SQL What: Copy all data rows from the online report 1 to the new combined
1850: -- online report.
1851: -- SQL Why: Construct the 1st part of the new combined online report.
1852: INSERT INTO PO_ONLINE_REPORT_TEXT
1853: (
1854: online_report_id
1855: ,sequence
1856: ,last_updated_by

Line 1908: FROM PO_ONLINE_REPORT_TEXT

1904: ,message_type
1905: ,show_in_psa_flag
1906: ,segment1
1907: ,distribution_type
1908: FROM PO_ONLINE_REPORT_TEXT
1909: WHERE online_report_id = p_report_id1
1910: ORDER BY sequence ASC;
1911:
1912: IF (PO_LOG.d_stmt) THEN

Line 1922: FROM PO_ONLINE_REPORT_TEXT

1918: -- SQL What: Retrieve the max sequence number value from all rows of online report 1.
1919: -- SQL Why: To set the start value for the sequence increment used to add rows from report 2.
1920: SELECT MAX(sequence)
1921: INTO l_id1_max_seq
1922: FROM PO_ONLINE_REPORT_TEXT
1923: WHERE online_report_id = p_report_id1;
1924:
1925: IF (PO_LOG.d_stmt) THEN
1926: PO_LOG.stmt(d_module,d_progress,'After got the max sequence for online report 1 rows as: '||l_id1_max_seq);

Line 1935: FROM PO_ONLINE_REPORT_TEXT

1931: -- SQL What: Retrieve list for all sequence numbers of report 2
1932: -- SQL Why: Used to count how many rows from report 2 need to be added to combined report.
1933: SELECT sequence
1934: BULK COLLECT INTO l_id2_seq_list
1935: FROM PO_ONLINE_REPORT_TEXT
1936: WHERE online_report_id = p_report_id2
1937: ORDER BY sequence ASC;
1938:
1939: IF (PO_LOG.d_stmt) THEN

Line 1951: INSERT INTO PO_ONLINE_REPORT_TEXT

1947: -- the combined report.
1948: -- SQL Why: Construct the 2nd part of the new combined online report.
1949: FOR i IN 1 .. l_id2_seq_list.COUNT
1950: LOOP
1951: INSERT INTO PO_ONLINE_REPORT_TEXT
1952: (
1953: online_report_id
1954: ,sequence
1955: ,last_updated_by

Line 2007: FROM PO_ONLINE_REPORT_TEXT

2003: ,message_type
2004: ,show_in_psa_flag
2005: ,segment1
2006: ,distribution_type
2007: FROM PO_ONLINE_REPORT_TEXT
2008: WHERE online_report_id = p_report_id2 and sequence = l_id2_seq_list(i);
2009: END LOOP;
2010:
2011: IF (PO_LOG.d_stmt) THEN

Line 2236: FROM PO_ONLINE_REPORT_TEXT

2232: -- SQL What: Get the number of data rows generated for report 1
2233: -- SQL Why: Used for the check below.
2234: SELECT COUNT(*)
2235: INTO l_report_id1_rownum
2236: FROM PO_ONLINE_REPORT_TEXT
2237: WHERE online_report_id = p_online_report_id;
2238:
2239: IF (PO_LOG.d_stmt) THEN
2240: 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 2249: FROM PO_ONLINE_REPORT_TEXT

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