DBA Data[Home] [Help]

APPS.PO_NEGOTIATIONS_SV2 dependencies on FND_DOCUMENTS_SHORT_TEXT

Line 1003: FROM fnd_documents_short_text

999: ));
1000:
1001: CURSOR shorttext (mid NUMBER) IS
1002: SELECT short_text
1003: FROM fnd_documents_short_text
1004: WHERE media_id = mid;
1005:
1006: CURSOR longtext (mid NUMBER) IS
1007: SELECT long_text

Line 1029: short_text_tmp Fnd_Documents_Short_Text.short_text%type ; /* Bug 4522511 */

1025:
1026: media_id_tmp NUMBER;
1027: document_id_tmp NUMBER;
1028: row_id_tmp VARCHAR2(30);
1029: short_text_tmp Fnd_Documents_Short_Text.short_text%type ; /* Bug 4522511 */
1030: long_text_tmp LONG;
1031: fnd_lobs_rec fnd_lobs_cur%ROWTYPE;
1032: x_category_id_tmp fnd_documents.category_id%TYPE;
1033: x_language_temp fnd_documents_tl.language%TYPE;

Line 1153: INSERT INTO fnd_documents_short_text (

1149: FETCH shorttext INTO short_text_tmp;
1150: CLOSE shorttext;
1151:
1152: x_progress :='004';
1153: INSERT INTO fnd_documents_short_text (
1154: media_id,
1155: short_text)
1156: VALUES (
1157: media_id_tmp,