APPS.PO_DOCUMENT_CHECKS_PVT dependencies on PO_ONLINE_REPORT_TEXT_S

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

1177:
1178: l_online_report_id NUMBER;
1179: l_user_id po_lines.last_updated_by%TYPE := -1;
1180: l_login_id po_lines.last_update_login%TYPE := -1;
1181: p_sequence po_online_report_text.sequence%TYPE :=0;
1182:
1183: l_return_status varchar2(1);
1184:
1185: l_conterms_exist_flag VARCHAR2(1); --

Line 1328: SELECT PO_ONLINE_REPORT_TEXT_S.nextval

1324: END IF;
1325:
1326: l_progress := '003';
1327: --Get the unique id to be used for this document
1328: SELECT PO_ONLINE_REPORT_TEXT_S.nextval
1329: INTO l_online_report_id
1330: FROM sys.dual;
1331:
1332: l_progress := '004';

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

3234: l_num_errors NUMBER := 0;
3235: l_online_report_id NUMBER;
3236: l_user_id PO_LINES.last_updated_by%TYPE := -1;
3237: l_login_id PO_LINES.last_update_login%TYPE := -1;
3238: p_sequence PO_ONLINE_REPORT_TEXT.sequence%TYPE :=0;
3239:
3240: l_return_status VARCHAR2(1);
3241:
3242: BEGIN

Line 3287: SELECT PO_ONLINE_REPORT_TEXT_S.nextval

3283:
3284: l_progress := '003';
3285:
3286: --Get the unique id to be used for this document
3287: SELECT PO_ONLINE_REPORT_TEXT_S.nextval
3288: INTO l_online_report_id
3289: FROM sys.dual;
3290:
3291: l_progress := '004';

Line 22062: SELECT PO_ONLINE_REPORT_TEXT_S.nextval

22058: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
22059:
22060: l_progress := '010';
22061: IF p_online_report_id is NULL or p_online_report_id = 0 THEN
22062: SELECT PO_ONLINE_REPORT_TEXT_S.nextval
22063: INTO p_online_report_id
22064: FROM sys.dual;
22065: p_sequence := 0;
22066: ELSE