APPS.PO_ATT dependencies on FND_DOCUMENTS

Line 257: FROM fnd_documents_tl fdt,

253: BEGIN
254:
255: SELECT fd.datatype_id, fd.media_id
256: INTO p_datatype_id, p_media_id
257: FROM fnd_documents_tl fdt,
258: fnd_documents fd
259: WHERE fdt.language = userenv('LANG')
260: AND fdt.document_id = fd.document_id
261: AND fd.document_id = p_document_id;

Line 258: fnd_documents fd

254:
255: SELECT fd.datatype_id, fd.media_id
256: INTO p_datatype_id, p_media_id
257: FROM fnd_documents_tl fdt,
258: fnd_documents fd
259: WHERE fdt.language = userenv('LANG')
260: AND fdt.document_id = fd.document_id
261: AND fd.document_id = p_document_id;
262:

Line 275: FROM fnd_documents_tl fdt,

271: BEGIN
272:
273: SELECT fd.document_id
274: INTO p_document_id
275: FROM fnd_documents_tl fdt,
276: fnd_documents fd
277: WHERE fd.media_id = p_media_id
278: AND fdt.document_id = fd.document_id
279: AND fd.datatype_id = decode (p_datatype_id, 'S', 1, 2) --short/long

Line 276: fnd_documents fd

272:
273: SELECT fd.document_id
274: INTO p_document_id
275: FROM fnd_documents_tl fdt,
276: fnd_documents fd
277: WHERE fd.media_id = p_media_id
278: AND fdt.document_id = fd.document_id
279: AND fd.datatype_id = decode (p_datatype_id, 'S', 1, 2) --short/long
280: AND rownum = 1; -- make sure only one record returns

Line 305: FROM fnd_documents

301: p_document_id := x_num;
302:
303: SELECT category_id, usage_type
304: INTO x_num2, p_note_type
305: FROM fnd_documents
306: WHERE document_id = x_num;
307:
308: p_category_id := x_num2;
309:

Line 429: SELECT fnd_documents_short_text_s.nextval

425: get_category_id (x_usage_id, x_category_id);
426: /* -1 if cannot find corresponding category */
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

Line 433: SELECT fnd_documents_long_text_s.nextval

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;
436: END IF;
437:

Line 439: INSERT INTO fnd_documents (

435: FROM sys.dual;
436: END IF;
437:
438:
439: INSERT INTO fnd_documents (
440: document_id, creation_date,
441: created_by, last_update_date,
442: last_updated_by, last_update_login,
443: datatype_id, category_id,

Line 460: INSERT INTO fnd_documents_tl (

456: x_note_type, p_app_source_version,
457: NULL, x_media_id
458: );
459:
460: INSERT INTO fnd_documents_tl (
461: document_id, creation_date,
462: created_by, last_update_date,
463: last_updated_by, last_update_login,
464: language, description,

Line 491: INSERT INTO fnd_documents_short_text ( media_id, short_text, app_source_version )

487: userenv('LANG'), p_app_source_version
488: );
489:
490: IF x_datatype_id = 1 THEN
491: INSERT INTO fnd_documents_short_text ( media_id, short_text, app_source_version )
492: VALUES ( x_media_id, x_note, p_app_source_version );
493: ELSE
494: INSERT INTO fnd_documents_long_text ( media_id, long_text, app_source_version )
495: VALUES ( x_media_id, x_note, p_app_source_version );

Line 494: INSERT INTO fnd_documents_long_text ( media_id, long_text, app_source_version )

490: IF x_datatype_id = 1 THEN
491: INSERT INTO fnd_documents_short_text ( media_id, short_text, app_source_version )
492: VALUES ( x_media_id, x_note, p_app_source_version );
493: ELSE
494: INSERT INTO fnd_documents_long_text ( media_id, long_text, app_source_version )
495: VALUES ( x_media_id, x_note, p_app_source_version );
496: END IF;
497:
498: END;

Line 601: UPDATE fnd_documents

597:
598: get_category_id (x_usage_id, x_category_id);
599: /* -1 if cannot find corresponding category */
600:
601: UPDATE fnd_documents
602: SET app_source_version = 'PO_R10',
603: category_id = x_category_id
604: WHERE document_id = x_document_id;
605:

Line 606: UPDATE fnd_documents_tl

602: SET app_source_version = 'PO_R10',
603: category_id = x_category_id
604: WHERE document_id = x_document_id;
605:
606: UPDATE fnd_documents_tl
607: SET app_source_version = 'PO_R10',
608: description = x_title,
609: doc_attribute_category = x_attribute_category,
610: doc_attribute1 = x_attribute1,

Line 633: UPDATE fnd_documents_short_text

629:
630: IF x_datatype_id = 1 THEN
631: -- we could check if note >= 2000 even datatype_id=1, and set x_note to
632: -- 'note truncated'|| substr(x_note,1,1900). leave it this way for now.
633: UPDATE fnd_documents_short_text
634: SET app_source_version = 'PO_R10',
635: short_text = substr (x_note, 1, 1998)
636: WHERE media_id = x_media_id;
637: ELSE

Line 638: UPDATE fnd_documents_long_text

634: SET app_source_version = 'PO_R10',
635: short_text = substr (x_note, 1, 1998)
636: WHERE media_id = x_media_id;
637: ELSE
638: UPDATE fnd_documents_long_text
639: SET app_source_version = 'PO_R10',
640: long_text = x_note
641: WHERE media_id = x_media_id;
642: END IF;

Line 658: DELETE FROM fnd_documents

654: BEGIN
655:
656: get_media_id (p_document_id, x_media_id, x_datatype_id);
657:
658: DELETE FROM fnd_documents
659: WHERE document_id = p_document_id;
660:
661: DELETE FROM fnd_documents_tl
662: WHERE document_id = p_document_id;

Line 661: DELETE FROM fnd_documents_tl

657:
658: DELETE FROM fnd_documents
659: WHERE document_id = p_document_id;
660:
661: DELETE FROM fnd_documents_tl
662: WHERE document_id = p_document_id;
663:
664: IF x_datatype_id = 1 THEN
665: DELETE FROM fnd_documents_short_text

Line 665: DELETE FROM fnd_documents_short_text

661: DELETE FROM fnd_documents_tl
662: WHERE document_id = p_document_id;
663:
664: IF x_datatype_id = 1 THEN
665: DELETE FROM fnd_documents_short_text
666: WHERE media_id = x_media_id;
667: ELSE
668: DELETE FROM fnd_documents_long_text
669: WHERE media_id = x_media_id;

Line 668: DELETE FROM fnd_documents_long_text

664: IF x_datatype_id = 1 THEN
665: DELETE FROM fnd_documents_short_text
666: WHERE media_id = x_media_id;
667: ELSE
668: DELETE FROM fnd_documents_long_text
669: WHERE media_id = x_media_id;
670: END IF;
671:
672: END;