DBA Data[Home] [Help]

APPS.PO_ATT dependencies on DUAL

Line 431: FROM sys.dual;

427:
428: IF x_datatype_id = 1 THEN
429: SELECT fnd_documents_short_text_s.nextval
430: INTO x_media_id
431: FROM sys.dual;
432: ELSE
433: SELECT fnd_documents_long_text_s.nextval
434: INTO x_media_id
435: FROM sys.dual;

Line 435: FROM sys.dual;

431: FROM sys.dual;
432: ELSE
433: SELECT fnd_documents_long_text_s.nextval
434: INTO x_media_id
435: FROM sys.dual;
436: END IF;
437:
438:
439: INSERT INTO fnd_documents (

Line 717: FROM sys.dual;

713: x_entity_name := get_entity_name ( p_table_name );
714:
715: SELECT fnd_attached_documents_s.nextval
716: INTO p_attached_doc_id
717: FROM sys.dual;
718:
719: INSERT INTO fnd_attached_documents (
720: attached_document_id, document_id,
721: creation_date, created_by,

Line 796: FROM sys.dual;

792: x_entity_name := get_entity_name ( p_table_name );
793:
794: SELECT fnd_attached_documents_s.nextval
795: INTO p_attached_doc_id
796: FROM sys.dual;
797:
798: /* MDAS In multi org scenario, this may fetch more than one row - Watch out */
799: BEGIN
800: SELECT inventory_organization_id