APPS.SO_ATT dependencies on DUAL

Line 76: FROM sys.dual

72: WHERE document_id = p_document_id
73: AND language = x_language;
74: CURSOR check_unique IS
75: SELECT 1
76: FROM sys.dual
77: WHERE EXISTS (SELECT 1
78: FROM so_notes
79: WHERE name = x_doc_desc);
80: BEGIN

Line 484: FROM dual;

480: 4, NULL,
481: 'N', NULL,
482: x_document_usage_type, p_app_source_version,
483: x_start_date_active, x_end_date_active
484: FROM dual;
485:
486: IF x_datatype_id = 1 THEN
487: SELECT fnd_documents_short_text_s.nextval
488: INTO x_media_id

Line 489: FROM dual;

485:
486: IF x_datatype_id = 1 THEN
487: SELECT fnd_documents_short_text_s.nextval
488: INTO x_media_id
489: FROM dual;
490: ELSE
491: SELECT fnd_documents_long_text_s.nextval
492: INTO x_media_id
493: FROM dual;

Line 493: FROM dual;

489: FROM dual;
490: ELSE
491: SELECT fnd_documents_long_text_s.nextval
492: INTO x_media_id
493: FROM dual;
494: END IF;
495:
496: INSERT INTO fnd_documents_tl (
497: document_id, creation_date,

Line 526: FROM dual;

522: x_attribute10, x_attribute11,
523: x_attribute12, x_attribute13,
524: x_attribute14, x_attribute15,
525: p_app_source_version, fnd_global.current_language
526: FROM dual;
527:
528: IF x_datatype_id = 1 THEN
529: INSERT INTO fnd_documents_short_text (
530: media_id, short_text, app_source_version )

Line 533: FROM dual;

529: INSERT INTO fnd_documents_short_text (
530: media_id, short_text, app_source_version )
531: SELECT
532: x_media_id, x_note, p_app_source_version
533: FROM dual;
534: ELSE
535: INSERT INTO fnd_documents_long_text (
536: media_id, long_text, app_source_version )
537: VALUES (

Line 763: FROM dual;

759: x_entity_name := get_entity_name(p_header_id, p_line_id);
760:
761: SELECT fnd_attached_documents_s.nextval
762: INTO p_attached_document_id
763: FROM dual;
764:
765: INSERT INTO fnd_attached_documents (
766: attached_document_id, document_id,
767: creation_date, created_by,

Line 801: FROM dual;

797: p_attribute9, p_attribute10,
798: p_attribute11, p_attribute12,
799: p_attribute13, p_attribute14,
800: p_attribute15, p_app_source_version
801: FROM dual;
802:
803: END;
804:
805: PROCEDURE update_attached_document (

Line 919: FROM dual;

915: BEGIN
916:
917: SELECT fnd_document_categories_s.nextval
918: INTO p_category_id
919: FROM dual;
920:
921: INSERT INTO fnd_document_categories (
922: category_id,
923: application_id, creation_date,

Line 955: FROM dual;

951: p_attribute9, p_attribute10,
952: p_attribute11, p_attribute12,
953: p_attribute13, p_attribute14,
954: p_attribute15
955: FROM dual;
956:
957: INSERT INTO fnd_document_categories_tl (
958: category_id, language,
959: name, user_name,

Line 971: FROM dual;

967: p_creation_date,
968: p_created_by, p_last_update_date,
969: p_last_updated_by, p_last_update_login,
970: p_app_source_version, fnd_global.current_language
971: FROM dual;
972:
973: -- lookup the attachment_function_id of the OEXOEMOE form
974: SELECT attachment_function_id
975: INTO attach_function_id

Line 1098: FROM dual;

1094:
1095: CLOSE C;
1096: SELECT so_note_usages_s.nextval
1097: INTO p_usage_id
1098: FROM dual;
1099:
1100:
1101:
1102: INSERT INTO so_note_usages (