APPS.PO_APPROVAL_ACTION dependencies on PO_ONLINE_REPORT_TEXT

Line 302: select PO_ONLINE_REPORT_TEXT_S.nextval

298: set_currency_rate(l_user_id,
299: l_last_update_login,
300: l_document_id);
301:
302: select PO_ONLINE_REPORT_TEXT_S.nextval
303: into l_online_report_id
304: from SYS.DUAL;
305:
306: x_progress := 'req_complete_check 004, report id '|| to_char(l_online_report_id);

Line 333: INSERT INTO po_online_report_text (online_report_id, last_update_login,

329:
330:
331: if(l_error_occur = 'Y') then
332:
333: INSERT INTO po_online_report_text (online_report_id, last_update_login,
334: last_updated_by, last_update_date, created_by, creation_date, line_num,
335: shipment_num, distribution_num, sequence, text_line)
336: VALUES (
337: l_online_report_id, l_last_update_login, l_user_id, sysdate,

Line 369: INSERT INTO po_online_report_text (online_report_id, last_update_login,

365:
366:
367: if(l_error_occur = 'Y') then
368:
369: INSERT INTO po_online_report_text (online_report_id, last_update_login,
370: last_updated_by, last_update_date, created_by, creation_date, line_num,
371: shipment_num, distribution_num, sequence, text_line)
372: SELECT
373: l_online_report_id, l_last_update_login, l_user_id, sysdate,

Line 439: INSERT INTO po_online_report_text(online_report_id,last_update_login,

435:
436:
437: if(l_error_occur = 'Y') then
438:
439: INSERT INTO po_online_report_text(online_report_id,last_update_login,
440: last_updated_by,last_update_date,created_by,creation_date,line_num,
441: shipment_num,distribution_num,sequence,text_line)
442: SELECT l_online_report_id, l_last_update_login, l_user_id, sysdate,
443: l_user_id,sysdate,PRL.line_num,0,0,l_sequence,

Line 469: INSERT INTO po_online_report_text (online_report_id, last_update_login,

465:
466: l_sequence := 4;
467: l_msg_text := 'Lines with source type of INVENTORY must have only one distribution';
468:
469: INSERT INTO po_online_report_text (online_report_id, last_update_login,
470: last_updated_by, last_update_date, created_by, creation_date, line_num,
471: shipment_num, distribution_num, sequence, text_line) SELECT
472: l_online_report_id,l_last_update_login,l_last_user_id, sysdate,
473: l_user_id,sysdate,PRL.line_num,0,0,l_sequence,

Line 488: INSERT INTO po_online_report_text (online_report_id, last_update_login,

484:
485: l_sequence := 5;
486: l_msg_text := 'No foreign currency exchange rate';
487:
488: INSERT INTO po_online_report_text (online_report_id, last_update_login,
489: last_updated_by, last_update_date, created_by, creation_date, line_num,
490: shipment_num, distribution_num, sequence, text_line)
491: SELECT
492: l_online_report_id,l_last_update_login,l_user_id, sysdate,

Line 514: INSERT INTO po_online_report_text

510: --
511: -- Reformatted the following SQL.
512: -- Added transferred_to_oe/source_type conditions.
513:
514: INSERT INTO po_online_report_text
515: ( online_report_id
516: , last_update_login
517: , last_updated_by
518: , last_update_date

Line 586: ** Desc: If the po_online_report_text has more than one record for the

582:
583: l_error_occur := 'N';
584:
585: /* Bug# 2959296: kagarwal
586: ** Desc: If the po_online_report_text has more than one record for the
587: ** given online_report_id, the following SQL will error out.
588: ** Since all we want to know is if there is any row, appending the where
589: ** clause rownum = 1
590: */

Line 595: from po_online_report_text

591:
592: begin
593: select 'Y'
594: into l_error_occur
595: from po_online_report_text
596: where online_report_id = l_online_report_id
597: and rownum = 1;
598:
599: EXCEPTION

Line 637: select text_line from po_online_report_text where online_report_id = p_online_report_id

633:
634: PROCEDURE get_online_report_text(itemtype VARCHAR2, itemkey VARCHAR2, p_online_report_id NUMBER) is
635:
636: cursor C1(p_online_report_id NUMBER) is
637: select text_line from po_online_report_text where online_report_id = p_online_report_id
638: order by sequence;
639:
640: l_report_text varchar2(240);
641: l_concat_report_text varchar2(2000);