APPS.GMD_EBI_RECIPE_PUB dependencies on FND_DOCUMENTS

Line 1102: l_doc fnd_documents%ROWTYPE;

1098: l_document_id number;
1099: l_att_doc_id number;
1100: l_media_id NUMBER;
1101: l_attached_doc fnd_attached_documents%ROWTYPE;
1102: l_doc fnd_documents%ROWTYPE;
1103: l_item_no VARCHAR2(100);
1104: l_item_desc VARCHAR2(1000);
1105: l_org_id NUMBER;
1106:

Line 1194: FND_Documents_PKG.Insert_Row(X_Rowid => l_row_id1,

1190: ,l_pkey5 => null
1191: ,l_function_name => 'GMDFRMED_F'
1192: ,l_function_type => 'F');
1193: IF(l_attchmt_exits <> 'Y') THEN
1194: FND_Documents_PKG.Insert_Row(X_Rowid => l_row_id1,
1195: X_document_id => l_document_id,
1196: X_creation_date => sysdate,
1197: X_created_by => FND_GLOBAL.USER_ID,
1198: X_last_update_date => sysdate,

Line 1209: INSERT INTO fnd_documents_long_text(Media_id,long_text) VALUES ( l_media_id,l_text);

1205: X_language => userenv('LANG'),
1206: X_description => l_description,
1207: X_file_name => null,
1208: X_media_id => l_media_id);
1209: INSERT INTO fnd_documents_long_text(Media_id,long_text) VALUES ( l_media_id,l_text);
1210: SELECT fnd_attached_documents_s.NEXTVAL
1211: INTO l_att_doc_id
1212: FROM dual;
1213: FND_Attached_Documents_PKG.Insert_Row(X_Rowid => l_row_id2,

Line 1261: FROM fnd_documents

1257: FROM FND_ATTACHED_DOCUMENTS
1258: WHERE ENTITY_NAME ='FM_FORM_MST_B' AND PK1_VALUE = l_formula_id;
1259:
1260: SELECT * INTO l_doc
1261: FROM fnd_documents
1262: WHERE document_id = l_attached_doc.document_id;
1263:
1264: SELECT DISTINCT row_id INTO l_row_id1 FROM FND_ATTACHED_DOCS_FORM_VL
1265: WHERE attached_document_id = l_attached_doc.attached_document_id;

Line 1335: UPDATE fnd_documents_long_text

1331: ,x_attribute13 => NULL
1332: ,x_attribute14 => NULL
1333: ,x_attribute15 => NULL
1334: );
1335: UPDATE fnd_documents_long_text
1336: SET long_text = l_text
1337: WHERE media_id = l_doc.media_id;
1338: END IF;
1339: END IF;