APPS.PO_ONLINE_REPORT dependencies on PO_ONLINE_REPORT_TEXT

Line 215: l_textline po_online_report_text.text_line%TYPE;

211: p_return_code IN OUT NOCOPY VARCHAR2) RETURN BOOLEAN IS
212:
213: l_userid po_lines.last_updated_by%TYPE;
214: l_loginid po_lines.last_update_login%TYPE;
215: l_textline po_online_report_text.text_line%TYPE;
216:
217: l_shipmsg VARCHAR2(25);
218: l_linemsg VARCHAR2(25);
219: l_tokennam1 VARCHAR2(10);

Line 302: insert into po_online_report_text(online_report_id,

298: l_textline := replace(l_textline, l_tokennam2, p_linenum);
299: l_textline := replace(l_textline, l_tokennam3, l_shipmsg);
300: l_textline := replace(l_textline, l_tokennam4, p_shipnum);
301:
302: insert into po_online_report_text(online_report_id,
303: last_update_login,
304: last_updated_by,
305: last_update_date,
306: created_by,

Line 376: l_textline po_online_report_text.text_line%TYPE;

372: l_tokenval1 po_distributions.quantity_delivered%TYPE;
373: l_tokenval2 po_line_locations.quantity%TYPE;
374: l_userid po_lines.last_updated_by%TYPE;
375: l_loginid po_lines.last_update_login%TYPE;
376: l_textline po_online_report_text.text_line%TYPE;
377:
378: l_tokennam1 VARCHAR2(10);
379: l_tokennam2 VARCHAR2(10);
380: l_message VARCHAR2(2000);

Line 522: insert into po_online_report_text

518: else
519: l_textline := l_message;
520: end if;
521:
522: insert into po_online_report_text
523: (online_report_id,
524: last_update_login,
525: last_updated_by,
526: last_update_date,

Line 606: l_textline po_online_report_text.text_line%TYPE;

602:
603: l_docid po_lines.line_num%TYPE;
604: l_userid po_lines.last_updated_by%TYPE;
605: l_loginid po_lines.last_update_login%TYPE;
606: l_textline po_online_report_text.text_line%TYPE;
607:
608: l_distmsg VARCHAR2(25);
609: l_shipmsg VARCHAR2(25);
610: l_linemsg VARCHAR2(25);

Line 697: sql_insert := 'insert into po_online_report_text ' ||

693:
694:
695: -- Setup the SQL Statement
696:
697: sql_insert := 'insert into po_online_report_text ' ||
698: '(online_report_id, ' ||
699: 'last_update_login, ' ||
700: 'last_updated_by, ' ||
701: 'last_update_date, ' ||