DBA Data[Home] [Help]

APPS.PO_DOCUMENT_CHECKS_PVT dependencies on PO_ONLINE_REPORT_TEXT_S

Line 562: p_sequence po_online_report_text.sequence%TYPE :=0;

558:
559: l_online_report_id NUMBER;
560: l_user_id po_lines.last_updated_by%TYPE := -1;
561: l_login_id po_lines.last_update_login%TYPE := -1;
562: p_sequence po_online_report_text.sequence%TYPE :=0;
563:
564: l_return_status varchar2(1);
565:
566: l_conterms_exist_flag VARCHAR2(1); --

Line 666: SELECT PO_ONLINE_REPORT_TEXT_S.nextval

662: END IF;
663:
664: l_progress := '003';
665: --Get the unique id to be used for this document
666: SELECT PO_ONLINE_REPORT_TEXT_S.nextval
667: INTO l_online_report_id
668: FROM sys.dual;
669:
670: l_progress := '004';

Line 1452: p_sequence PO_ONLINE_REPORT_TEXT.sequence%TYPE :=0;

1448: l_num_errors NUMBER := 0;
1449: l_online_report_id NUMBER;
1450: l_user_id PO_LINES.last_updated_by%TYPE := -1;
1451: l_login_id PO_LINES.last_update_login%TYPE := -1;
1452: p_sequence PO_ONLINE_REPORT_TEXT.sequence%TYPE :=0;
1453:
1454: l_return_status VARCHAR2(1);
1455:
1456: BEGIN

Line 1501: SELECT PO_ONLINE_REPORT_TEXT_S.nextval

1497:
1498: l_progress := '003';
1499:
1500: --Get the unique id to be used for this document
1501: SELECT PO_ONLINE_REPORT_TEXT_S.nextval
1502: INTO l_online_report_id
1503: FROM sys.dual;
1504:
1505: l_progress := '004';