DBA Data[Home] [Help]

APPS.PON_ATTACHMENTS dependencies on PON_ATTACHMENTS

Line 1: PACKAGE BODY PON_ATTACHMENTS AS

1: PACKAGE BODY PON_ATTACHMENTS AS
2: /* $Header: PONATCHB.pls 120.2 2007/06/28 20:25:31 sssahai ship $ */
3:
4: FUNCTION check_attachment_exists(p_entity_name IN VARCHAR2,
5: p_pk1_value IN VARCHAR2 DEFAULT NULL,

Line 78: PON_ATTACHMENTS.add_attachment(

74: x_attached_document_id out nocopy NUMBER,
75: x_file_id out nocopy NUMBER
76: ) IS
77: BEGIN
78: PON_ATTACHMENTS.add_attachment(
79: p_seq_num => p_seq_num ,
80: p_category_id => p_category_id ,
81: p_document_description => p_document_description ,
82: p_datatype_id => p_datatype_id ,

Line 226: IF (p_datatype_id = PON_ATTACHMENTS.SHORT_TEXT) THEN

222: x_doc_attribute14 => NULL ,
223: x_doc_attribute15 => NULL
224: );
225:
226: IF (p_datatype_id = PON_ATTACHMENTS.SHORT_TEXT) THEN
227: INSERT INTO fnd_documents_short_text(
228: media_id,
229: short_text)
230: VALUES (

Line 334: x_datatype_id => PON_ATTACHMENTS.LONG_TEXT ,

330: x_attribute12 => NULL ,
331: x_attribute13 => NULL ,
332: x_attribute14 => NULL ,
333: x_attribute15 => NULL ,
334: x_datatype_id => PON_ATTACHMENTS.LONG_TEXT ,
335: x_category_id => p_category_id ,
336: x_security_type => 4 ,
337: x_security_id => NULL ,
338: x_publish_flag => 'Y' ,

Line 616: PON_ATTACHMENTS.add_attachment_frm_ui(

612: x_attached_document_id out nocopy NUMBER,
613: x_file_id out nocopy NUMBER
614: ) IS
615: BEGIN
616: PON_ATTACHMENTS.add_attachment_frm_ui(
617: p_seq_num => p_seq_num ,
618: p_category_id => p_category_id ,
619: p_document_description => p_document_description ,
620: p_datatype_id => p_datatype_id ,

Line 679: PON_ATTACHMENTS.add_attachment_frm_doc_catalog(

675:
676: -- Call the procedure to create attachment from Document Catalog
677:
678: l_progress := 1;
679: PON_ATTACHMENTS.add_attachment_frm_doc_catalog(
680: p_seq_num => p_seq_num ,
681: p_entity_name => p_entity_name ,
682: p_pk1_value => p_pk1_value ,
683: p_pk2_value => p_pk2_value ,

Line 692: ElsIf ( l_datatype_id = PON_ATTACHMENTS.LONG_TEXT ) Then

688: p_column1 => p_column1 ,
689: x_attached_document_id => l_attached_document_id
690: );
691:
692: ElsIf ( l_datatype_id = PON_ATTACHMENTS.LONG_TEXT ) Then
693:
694: -- Call procedure to create a long text attachment
695:
696: l_progress := 2;

Line 697: PON_ATTACHMENTS.add_long_text_attachment (

693:
694: -- Call procedure to create a long text attachment
695:
696: l_progress := 2;
697: PON_ATTACHMENTS.add_long_text_attachment (
698: p_seq_num => p_seq_num ,
699: p_category_id => p_category_id ,
700: p_document_description => p_document_description ,
701: p_long_text => p_long_text ,

Line 722: PON_ATTACHMENTS.add_attachment(

718:
719: -- Default situation : create URL/Short Text/File type of attachment.
720:
721: l_progress := 3;
722: PON_ATTACHMENTS.add_attachment(
723: p_seq_num => p_seq_num ,
724: p_category_id => p_category_id ,
725: p_document_description => p_document_description ,
726: p_datatype_id => p_datatype_id ,

Line 821: END PON_ATTACHMENTS;

817:
818: END delete_attachment;
819:
820:
821: END PON_ATTACHMENTS;