APPS.GMD_EBI_RECIPE_PUB dependencies on FND_ATTACHED_DOCUMENTS

Line 1101: l_attached_doc fnd_attached_documents%ROWTYPE;

1097: l_row_id2 varchar2(255);
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;

Line 1210: SELECT fnd_attached_documents_s.NEXTVAL

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,
1214: X_attached_document_id => l_att_doc_id,

Line 1213: FND_Attached_Documents_PKG.Insert_Row(X_Rowid => l_row_id2,

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,
1214: X_attached_document_id => l_att_doc_id,
1215: X_document_id => l_document_id,
1216: X_creation_date => sysdate,
1217: X_created_by => FND_GLOBAL.USER_ID,

Line 1257: FROM FND_ATTACHED_DOCUMENTS

1253: X_doc_attribute15 => NULL);
1254: ELSE
1255:
1256: SELECT * INTO l_attached_doc
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

Line 1268: FND_Attached_Documents_PKG.Update_Row(X_Rowid => l_row_id1

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;
1266:
1267:
1268: FND_Attached_Documents_PKG.Update_Row(X_Rowid => l_row_id1
1269: ,X_attached_document_id => l_attached_doc.attached_document_id
1270: ,X_document_id =>l_attached_doc.document_id
1271: ,X_last_update_date => sysdate
1272: ,X_last_updated_by => FND_GLOBAL.USER_ID