APPS.PO_EMAIL_GENERATE dependencies on FND_ATTACHED_DOCS_FORM_VL

Line 117: l_datatype_id fnd_attached_docs_form_vl.datatype_id%TYPE;

113: l_item_short_text FND_DOCUMENTS_SHORT_TEXT.SHORT_TEXT%TYPE := null;
114: l_item_long_text FND_DOCUMENTS_LONG_TEXT.LONG_TEXT%TYPE := null;
115:
116: l_long_text FND_DOCUMENTS_LONG_TEXT.LONG_TEXT%TYPE := null;
117: l_datatype_id fnd_attached_docs_form_vl.datatype_id%TYPE;
118: l_media_id fnd_attached_docs_form_vl.media_id%TYPE;
119: l_item_datatype_id fnd_attached_docs_form_vl.datatype_id%TYPE;
120: l_item_media_id fnd_attached_docs_form_vl.media_id%TYPE;
121: l_cancel_flag po_line_locations_all.cancel_flag%TYPE;

Line 118: l_media_id fnd_attached_docs_form_vl.media_id%TYPE;

114: l_item_long_text FND_DOCUMENTS_LONG_TEXT.LONG_TEXT%TYPE := null;
115:
116: l_long_text FND_DOCUMENTS_LONG_TEXT.LONG_TEXT%TYPE := null;
117: l_datatype_id fnd_attached_docs_form_vl.datatype_id%TYPE;
118: l_media_id fnd_attached_docs_form_vl.media_id%TYPE;
119: l_item_datatype_id fnd_attached_docs_form_vl.datatype_id%TYPE;
120: l_item_media_id fnd_attached_docs_form_vl.media_id%TYPE;
121: l_cancel_flag po_line_locations_all.cancel_flag%TYPE;
122: l_cancel_date po_line_locations_all.cancel_date%TYPE;

Line 119: l_item_datatype_id fnd_attached_docs_form_vl.datatype_id%TYPE;

115:
116: l_long_text FND_DOCUMENTS_LONG_TEXT.LONG_TEXT%TYPE := null;
117: l_datatype_id fnd_attached_docs_form_vl.datatype_id%TYPE;
118: l_media_id fnd_attached_docs_form_vl.media_id%TYPE;
119: l_item_datatype_id fnd_attached_docs_form_vl.datatype_id%TYPE;
120: l_item_media_id fnd_attached_docs_form_vl.media_id%TYPE;
121: l_cancel_flag po_line_locations_all.cancel_flag%TYPE;
122: l_cancel_date po_line_locations_all.cancel_date%TYPE;
123: l_quantity_cancelled po_line_locations_all.quantity_cancelled%TYPE;

Line 120: l_item_media_id fnd_attached_docs_form_vl.media_id%TYPE;

116: l_long_text FND_DOCUMENTS_LONG_TEXT.LONG_TEXT%TYPE := null;
117: l_datatype_id fnd_attached_docs_form_vl.datatype_id%TYPE;
118: l_media_id fnd_attached_docs_form_vl.media_id%TYPE;
119: l_item_datatype_id fnd_attached_docs_form_vl.datatype_id%TYPE;
120: l_item_media_id fnd_attached_docs_form_vl.media_id%TYPE;
121: l_cancel_flag po_line_locations_all.cancel_flag%TYPE;
122: l_cancel_date po_line_locations_all.cancel_date%TYPE;
123: l_quantity_cancelled po_line_locations_all.quantity_cancelled%TYPE;
124:

Line 190: from fnd_attached_docs_form_vl

186: /* bug 4567441 : added the orderby clause, so that the document attachments
187: are ordered by sequence */
188: cursor attachments_cursor(v_entity_name varchar2, v_document_id number) is
189: Select datatype_id, media_id
190: from fnd_attached_docs_form_vl
191: where entity_name = v_entity_name
192: and pk1_value = to_char(v_document_id) /* Bug 5964375 */
193: and function_name = 'PO_PRINTPO'
194: and datatype_id in (1,2)

Line 206: from fnd_attached_docs_form_vl fad, financials_system_parameters fsp

202: /* bug 4567441 : added the orderby clause, so that the document attachments
203: are ordered by sequence */
204: cursor attachments_from_ga_cursor(v_entity_name varchar2, v_document_id number) is
205: Select datatype_id, media_id
206: from fnd_attached_docs_form_vl fad, financials_system_parameters fsp
207: where entity_name = v_entity_name
208: and pk1_value = to_char(v_document_id) /* Bug 5964375 */
209: and function_name = 'PO_PRINTPO'
210: and datatype_id in (1,2)

Line 227: FROM fnd_attached_docs_form_vl

223: are ordered by sequence */
224: cursor item_notes_cursor(v_org_id number, v_item_id number) is
225: SELECT datatype_id,
226: media_id
227: FROM fnd_attached_docs_form_vl
228: WHERE entity_name = 'MTL_SYSTEM_ITEMS' AND
229: pk1_value = to_char(v_org_id) AND
230: pk2_value = to_char(v_item_id) AND
231: function_name = 'PO_PRINTPO' and