eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_NEGOTIATIONS_SV2 dependencies on FND_DOCUMENTS

Line 979: fnd_documents_vl fdvl

975: fdvl.doc_attribute13 dattr13, fdvl.doc_attribute14 dattr14,
976: fdvl.doc_attribute15 dattr15,
977: fdvl.title, fdvl.url -- Bug 5000065
978: FROM fnd_attached_documents fad,
979: fnd_documents_vl fdvl
980: WHERE fad.document_id = fdvl.document_id
981: AND fad.entity_name = X_from_entity_name
982: AND fad.pk1_value = X_from_pk1_value
983: AND (X_from_pk2_value IS NULL

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 1008: FROM fnd_documents_long_text

1004: WHERE media_id = mid;
1005:
1006: CURSOR longtext (mid NUMBER) IS
1007: SELECT long_text
1008: FROM fnd_documents_long_text
1009: WHERE media_id = mid;
1010:
1011: CURSOR fnd_lobs_cur (mid NUMBER) IS
1012: SELECT file_id,

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 1032: x_category_id_tmp fnd_documents.category_id%TYPE;

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;
1034: x_progress varchar2(4);
1035:
1036: --

Line 1033: x_language_temp fnd_documents_tl.language%TYPE;

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;
1034: x_progress varchar2(4);
1035:
1036: --
1037: l_intern_sourcing_cat_id fnd_documents.category_id%TYPE;

Line 1037: l_intern_sourcing_cat_id fnd_documents.category_id%TYPE;

1033: x_language_temp fnd_documents_tl.language%TYPE;
1034: x_progress varchar2(4);
1035:
1036: --
1037: l_intern_sourcing_cat_id fnd_documents.category_id%TYPE;
1038:
1039: BEGIN
1040: -- Use cursor loop to get all attachments associated with
1041: -- the from_entity

Line 1096: FND_DOCUMENTS_PKG.Insert_Row(row_id_tmp,

1092: */
1093: --
1094:
1095: x_progress :='002';
1096: FND_DOCUMENTS_PKG.Insert_Row(row_id_tmp,
1097: document_id_tmp,
1098: SYSDATE,
1099: NVL(X_created_by,0),
1100: SYSDATE,

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,

Line 1168: INSERT INTO fnd_documents_long_text (

1164: FETCH longtext INTO long_text_tmp;
1165: CLOSE longtext;
1166:
1167: x_progress :='006';
1168: INSERT INTO fnd_documents_long_text (
1169: media_id,
1170: long_text)
1171: VALUES (
1172: media_id_tmp,

Line 1276: UPDATE fnd_documents

1272: -- was an ole or image that wasn't already a std doc
1273: -- (images should be created as Std, but just in case)
1274: IF (docrec.datatype_id IN (3,4)
1275: AND docrec.usage_type <> 'S') THEN
1276: UPDATE fnd_documents
1277: SET usage_type = 'S'
1278: WHERE document_id = docrec.document_id;
1279: END IF;
1280: --

Line 1313: x_category_id_tmp fnd_documents.category_id%TYPE;

1309:
1310: media_id_tmp NUMBER;
1311: document_id_tmp NUMBER;
1312: row_id_tmp VARCHAR2(30);
1313: x_category_id_tmp fnd_documents.category_id%TYPE;
1314: x_security_id NUMBER;
1315: x_seq_num NUMBER :=0;
1316: x_language_temp fnd_documents_tl.language%TYPE;
1317: x_datatype_id_tmp NUMBER;

Line 1316: x_language_temp fnd_documents_tl.language%TYPE;

1312: row_id_tmp VARCHAR2(30);
1313: x_category_id_tmp fnd_documents.category_id%TYPE;
1314: x_security_id NUMBER;
1315: x_seq_num NUMBER :=0;
1316: x_language_temp fnd_documents_tl.language%TYPE;
1317: x_datatype_id_tmp NUMBER;
1318: x_description_tmp fnd_documents_tl.description%TYPE;
1319: l_text long;
1320: l_who_rec PO_NEGOTIATIONS_SV2.who_rec_type;

Line 1318: x_description_tmp fnd_documents_tl.description%TYPE;

1314: x_security_id NUMBER;
1315: x_seq_num NUMBER :=0;
1316: x_language_temp fnd_documents_tl.language%TYPE;
1317: x_datatype_id_tmp NUMBER;
1318: x_description_tmp fnd_documents_tl.description%TYPE;
1319: l_text long;
1320: l_who_rec PO_NEGOTIATIONS_SV2.who_rec_type;
1321:
1322:

Line 1514: -- FND_DOCUMENTS, FND_DOCUMENTS_LONG_TEXT, FND_ATTACHED_DOCUMENTS

1510: --Name: convert_text_to_attachment
1511: --Pre-reqs:
1512: -- None.
1513: --Modifies:
1514: -- FND_DOCUMENTS, FND_DOCUMENTS_LONG_TEXT, FND_ATTACHED_DOCUMENTS
1515: --Locks:
1516: -- None.
1517: --Function:
1518: -- Converts a LONG text to an Attachment.

Line 1556: -- Insert into FND_DOCUMENTS ----------------------------------------------

1552:
1553: BEGIN
1554:
1555: l_security_id := po_moac_utils_pvt.get_current_org_id; --
1556: -- Insert into FND_DOCUMENTS ----------------------------------------------
1557:
1558: FND_DOCUMENTS_PKG.insert_row
1559: ( x_rowid => l_rowid -- IN/OUT
1560: , x_document_id => l_document_id -- IN/OUT

Line 1558: FND_DOCUMENTS_PKG.insert_row

1554:
1555: l_security_id := po_moac_utils_pvt.get_current_org_id; --
1556: -- Insert into FND_DOCUMENTS ----------------------------------------------
1557:
1558: FND_DOCUMENTS_PKG.insert_row
1559: ( x_rowid => l_rowid -- IN/OUT
1560: , x_document_id => l_document_id -- IN/OUT
1561: , x_creation_date => nvl(p_who_rec.creation_date, sysdate)
1562: , x_created_by => nvl(p_who_rec.created_by, 0)

Line 1578: -- Insert into FND_DOCUMENTS_LONG_TEXT ------------------------------------

1574: , x_description => p_description
1575: , x_media_id => l_media_id -- IN/OUT
1576: );
1577:
1578: -- Insert into FND_DOCUMENTS_LONG_TEXT ------------------------------------
1579:
1580: INSERT INTO fnd_documents_long_text
1581: ( media_id
1582: , long_text

Line 1580: INSERT INTO fnd_documents_long_text

1576: );
1577:
1578: -- Insert into FND_DOCUMENTS_LONG_TEXT ------------------------------------
1579:
1580: INSERT INTO fnd_documents_long_text
1581: ( media_id
1582: , long_text
1583: )
1584: VALUES