DBA Data[Home] [Help]

APPS.PON_ATTACHMENTS dependencies on DUAL

Line 150: FROM sys.dual;

146:
147: -- Attached Document Id has to be populated from the sequence.
148: SELECT fnd_attached_documents_s.nextval
149: INTO l_attached_document_id
150: FROM sys.dual;
151:
152: -- Set the language parameter
153: SELECT USERENV('LANG')
154: INTO l_lang

Line 155: FROM dual;

151:
152: -- Set the language parameter
153: SELECT USERENV('LANG')
154: INTO l_lang
155: FROM dual;
156:
157: -- Call the server side package for adding the attachment and documents.
158: fnd_attached_documents_pkg.insert_row (
159: x_rowid => l_rowid ,

Line 286: FROM sys.dual;

282: -- Attached Document Id has to be populated from the sequence.
283: l_progress := 3;
284: SELECT fnd_attached_documents_s.nextval
285: INTO l_attached_document_id
286: FROM sys.dual;
287:
288: -- Set the language parameter
289: l_progress := 4;
290: SELECT USERENV('LANG')

Line 292: FROM dual;

288: -- Set the language parameter
289: l_progress := 4;
290: SELECT USERENV('LANG')
291: INTO l_lang
292: FROM dual;
293:
294: -- Call the server side package for adding the attachment and documents.
295: l_progress := 5;
296: fnd_attached_documents_pkg.insert_row (

Line 448: From Dual;

444:
445: -- Select Language.
446: l_progress := 1;
447: Select USERENV('LANG') into l_lang
448: From Dual;
449:
450: -- Attached Document ID population from sequence.
451: l_progress := 2;
452: Select FND_ATTACHED_DOCUMENTS_S.nextval

Line 454: From Dual

450: -- Attached Document ID population from sequence.
451: l_progress := 2;
452: Select FND_ATTACHED_DOCUMENTS_S.nextval
453: Into l_attached_document_id
454: From Dual
455: ;
456:
457: -- Select Document Properties
458: l_progress := 3;