DBA Data[Home] [Help]

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 clob;
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 clob;
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 clob;
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: c_text CLOB;
1322: l_size NUMBER := 0;

Line 1593: -- FND_DOCUMENTS, FND_DOCUMENTS_LONG_TEXT, FND_ATTACHED_DOCUMENTS

1589: --Name: convert_text_to_attachment
1590: --Pre-reqs:
1591: -- None.
1592: --Modifies:
1593: -- FND_DOCUMENTS, FND_DOCUMENTS_LONG_TEXT, FND_ATTACHED_DOCUMENTS
1594: --Locks:
1595: -- None.
1596: --Function:
1597: -- Converts a LONG text to an Attachment.

Line 1637: -- Insert into FND_DOCUMENTS ----------------------------------------------

1633:
1634: BEGIN
1635:
1636: l_security_id := po_moac_utils_pvt.get_current_org_id; --
1637: -- Insert into FND_DOCUMENTS ----------------------------------------------
1638:
1639: if (p_to_entity_name = 'PO_HEADERS' or
1640: p_to_entity_name = 'PO_LINES' or
1641: p_to_entity_name = 'PO_SHIPMENTS') then

Line 1646: FND_DOCUMENTS_PKG.insert_row

1642: l_pk2 := -1;
1643: else
1644: l_pk2 := null;
1645: end if;
1646: FND_DOCUMENTS_PKG.insert_row
1647: ( x_rowid => l_rowid -- IN/OUT
1648: , x_document_id => l_document_id -- IN/OUT
1649: , x_creation_date => nvl(p_who_rec.creation_date, sysdate)
1650: , x_created_by => nvl(p_who_rec.created_by, 0)

Line 1666: -- Insert into FND_DOCUMENTS_LONG_TEXT ------------------------------------

1662: , x_description => p_description
1663: , x_media_id => l_media_id -- IN/OUT
1664: );
1665:
1666: -- Insert into FND_DOCUMENTS_LONG_TEXT ------------------------------------
1667:
1668: INSERT INTO fnd_documents_long_text
1669: ( media_id
1670: , long_text

Line 1668: INSERT INTO fnd_documents_long_text

1664: );
1665:
1666: -- Insert into FND_DOCUMENTS_LONG_TEXT ------------------------------------
1667:
1668: INSERT INTO fnd_documents_long_text
1669: ( media_id
1670: , long_text
1671: )
1672: VALUES

Line 1733: -- FND_DOCUMENTS, FND_LOBS, FND_ATTACHED_DOCUMENTS

1729: --Name: convert_text_to_attach_clob
1730: --Pre-reqs:
1731: -- None.
1732: --Modifies:
1733: -- FND_DOCUMENTS, FND_LOBS, FND_ATTACHED_DOCUMENTS
1734: --Locks:
1735: -- None.
1736: --Function:
1737: -- Converts a CLOB to an Attachment.

Line 1788: -- Insert into FND_DOCUMENTS ----------------------------------------------

1784: l_security_id := po_moac_utils_pvt.get_current_org_id; --
1785: IF (p_from_entity_name = 'PON_BID_HEADER_ATTRIBUTES') THEN
1786: l_file_name := 'Requirements_And_Quote_Values' || '.' || l_file_extn;
1787: END IF;
1788: -- Insert into FND_DOCUMENTS ----------------------------------------------
1789:
1790: if (p_to_entity_name = 'PO_HEADERS' or
1791: p_to_entity_name = 'PO_LINES' or
1792: p_to_entity_name = 'PO_SHIPMENTS') then

Line 1798: FND_DOCUMENTS_PKG.insert_row

1794: else
1795: l_pk2 := null;
1796: end if;
1797:
1798: FND_DOCUMENTS_PKG.insert_row
1799: ( x_rowid => l_rowid -- IN/OUT
1800: , x_document_id => l_document_id -- IN/OUT
1801: , x_creation_date => nvl(p_who_rec.creation_date, sysdate)
1802: , x_created_by => nvl(p_who_rec.created_by, 0)