APPS.PO_APPROVAL_ACTION dependencies on PO_ONLINE_REPORT_TEXT

Line 336: select PO_ONLINE_REPORT_TEXT_S.nextval

332: set_currency_rate(l_user_id,
333: l_last_update_login,
334: l_document_id);
335:
336: select PO_ONLINE_REPORT_TEXT_S.nextval
337: into l_online_report_id
338: from SYS.DUAL;
339:
340: x_progress := 'req_complete_check 004, report id '|| to_char(l_online_report_id);

Line 367: INSERT INTO po_online_report_text (online_report_id, last_update_login,

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

Line 406: INSERT INTO po_online_report_text (online_report_id, last_update_login,

402:
403:
404: if(l_error_occur = 'Y') then
405:
406: INSERT INTO po_online_report_text (online_report_id, last_update_login,
407: last_updated_by, last_update_date, created_by, creation_date, line_num,
408: shipment_num, distribution_num, sequence, text_line)
409: SELECT
410: l_online_report_id, l_last_update_login, l_user_id, sysdate,

Line 478: INSERT INTO po_online_report_text(online_report_id,last_update_login,

474:
475:
476: if(l_error_occur = 'Y') then
477:
478: INSERT INTO po_online_report_text(online_report_id,last_update_login,
479: last_updated_by,last_update_date,created_by,creation_date,line_num,
480: shipment_num,distribution_num,sequence,text_line)
481: SELECT l_online_report_id, l_last_update_login, l_user_id, sysdate,
482: l_user_id,sysdate,PRL.line_num,0,0,l_sequence,

Line 508: INSERT INTO po_online_report_text (online_report_id, last_update_login,

504:
505: l_sequence := 4;
506: l_msg_text := 'Lines with source type of INVENTORY must have only one distribution';
507:
508: INSERT INTO po_online_report_text (online_report_id, last_update_login,
509: last_updated_by, last_update_date, created_by, creation_date, line_num,
510: shipment_num, distribution_num, sequence, text_line) SELECT
511: l_online_report_id,l_last_update_login,l_last_user_id, sysdate,
512: l_user_id,sysdate,PRL.line_num,0,0,l_sequence,

Line 527: INSERT INTO po_online_report_text (online_report_id, last_update_login,

523:
524: l_sequence := 5;
525: l_msg_text := 'No foreign currency exchange rate';
526:
527: INSERT INTO po_online_report_text (online_report_id, last_update_login,
528: last_updated_by, last_update_date, created_by, creation_date, line_num,
529: shipment_num, distribution_num, sequence, text_line)
530: SELECT
531: l_online_report_id,l_last_update_login,l_user_id, sysdate,

Line 556: INSERT INTO po_online_report_text

552: --
553: -- Reformatted the following SQL.
554: -- Added transferred_to_oe/source_type conditions.
555:
556: INSERT INTO po_online_report_text
557: ( online_report_id
558: , last_update_login
559: , last_updated_by
560: , last_update_date

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

629:
630: l_error_occur := 'N';
631:
632: /* Bug# 2959296: kagarwal
633: ** Desc: If the po_online_report_text has more than one record for the
634: ** given online_report_id, the following SQL will error out.
635: ** Since all we want to know is if there is any row, appending the where
636: ** clause rownum = 1
637: */

Line 642: from po_online_report_text

638:
639: begin
640: select 'Y'
641: into l_error_occur
642: from po_online_report_text
643: where online_report_id = l_online_report_id
644: and rownum = 1;
645:
646: EXCEPTION

Line 684: select text_line from po_online_report_text where online_report_id = p_online_report_id

680:
681: PROCEDURE get_online_report_text(itemtype VARCHAR2, itemkey VARCHAR2, p_online_report_id NUMBER) is
682:
683: cursor C1(p_online_report_id NUMBER) is
684: select text_line from po_online_report_text where online_report_id = p_online_report_id
685: order by sequence;
686:
687: l_report_text varchar2(240);
688: l_concat_report_text varchar2(2000);