1 PACKAGE OE_Atchmt_UTIL AUTHID CURRENT_USER as
2 /* $Header: OEXUATTS.pls 120.0 2005/06/01 00:53:03 appldev noship $ */
3
4 -- Document Entities - corresponds to data_object_code in fnd_document_entities
5 -- and oe_ak_objects_ext table
6 G_DOC_ENTITY_ORDER_HEADER constant varchar2(30) := 'OE_ORDER_HEADERS';
7 G_DOC_ENTITY_ORDER_LINE constant varchar2(30) := 'OE_ORDER_LINES';
8
9 -- document data types
10 G_DATATYPE_SHORT_TEXT constant number:= 1;
11 G_DATATYPE_LONG_TEXT constant number:= 2;
12 G_DATATYPE_IMAGE constant number:= 3;
13 G_DATATYPE_OLE_OBJECT constant number:= 4;
14 G_DATATYPE_WEB_PAGE constant number:= 5;
15
16 -- document security types
17 G_SECURITY_TYPE_ORG constant number := 1;
18 G_SECURITY_TYPE_SOB constant number := 2;
19 G_SECURITY_TYPE_BU constant number := 3;
20 G_SECURITY_TYPE_NONE constant number := 4;
21
22 -- Start of Comments
23 -- API name Apply_Automatic_Attachments
24 -- Type Util
25 --
26 -- Parameters
27 -- p_entity_code : entity to which automatic attachments are to be applied
28 -- (OE_GLOBALS.G_ENTITY_HEADER/OE_GLOBALS.G_ENTITY_LINE)
29 -- p_entity_id : primary key value for the entity (header_id/line_id)
30 -- p_is_user_action : if 'N', then apply attachments only if profile
31 -- OE_APPLY_AUTOMATIC_ATCHMT = 'Y' and no messages are
32 -- added after attachments are applied
33 -- if 'Y', then apply attachments irrespective of the
34 -- profile and add information messages after
35 -- attachments are applied.
36 -- x_return_status : standard API return status
37 --
38 -- Notes
39 --
40 -- End of Comments
41 ------------------------------------------
42 PROCEDURE Apply_Automatic_Attachments
43 (
44 p_init_msg_list in varchar2 default fnd_api.g_false,
45 p_entity_code in varchar2,
46 p_entity_id in number,
47 p_is_user_action in varchar2 default 'Y',
48 x_attachment_count out nocopy number,
49
50 x_return_status out nocopy varchar2,
51
52 x_msg_count out nocopy number,
53
54 x_msg_data out nocopy varchar2
55
56 );
57 ------------------------------------------
58
59
60 -- Start of Comments
61 -- API name Delete_Attachments
62 -- Type Util
63 --
64 -- Parameters
65 -- p_entity_code : entity for which attachments are to be deleted
66 -- (OE_GLOBALS.G_ENTITY_HEADER/OE_GLOBALS.G_ENTITY_LINE)
67 -- p_entity_id : primary key value for the entity (header_id/line_id)
68 -- x_return_status : standard API return status
69 --
70 -- Notes
71 --
72 -- End of Comments
73 ------------------------------------------
74 PROCEDURE Delete_Attachments
75 (
76 p_entity_code in varchar2,
77 p_entity_id in number,
78 x_return_status out nocopy varchar2
79
80 );
81 ------------------------------------------
82
83
84 -- Start of Comments
85 -- API name Copy_Attachments
86 -- Type Util
87 --
88 -- Parameters
89 -- p_entity_code : copy attachments for this entity
90 -- (OE_GLOBALS.G_ENTITY_HEADER/OE_GLOBALS.G_ENTITY_LINE)
91 -- p_from_entity_id : PK value of entity to be copied FROM (header_id/line_id)
92 -- p_to_entity_id : PK value of entity to be copied TO (header_id/line_id)
93 -- p_manual_attachments_only : if 'Y' only the manual attachments on the
94 -- FROM entity will be copied else ALL are copied
95 -- x_return_status : standard API return status
96 -- End of Comments
97 ------------------------------------------
98 PROCEDURE Copy_Attachments
99 (
100 p_entity_code in varchar2,
101 p_from_entity_id in number ,
102 p_to_entity_id in number ,
103 p_manual_attachments_only in varchar2 default 'N',
104 x_return_status out nocopy varchar2
105
106 );
107 ------------------------------------------
108
109
110 -- Start of Comments
111 -- API name Add_Attachment
112 -- Type Uitl
113 -- Function
114 --
115 -- Pre-reqs
116 --
117 -- Parameters
118 --
119 -- Version Current version = 1.0
120 -- Initial version = 1.0
121 --
122 -- Notes
123 --
124 -- End of Comments
125 ------------------------------------
126 PROCEDURE Add_Attachment
127 (
128 p_api_version in number,
129 p_entity_code in varchar2,
130 p_entity_id in number,
131 p_document_desc in varchar2 default null,
132 p_document_text in varchar2 default null,
133 p_category_id in number default null,
134 p_document_id in number default null,
135 x_attachment_id out nocopy number,
136
137 x_return_status out nocopy varchar2,
138
139 x_msg_count out nocopy number,
140
141 x_msg_data out nocopy varchar2
142
143 );
144 ------------------------------------
145
146
147 END OE_Atchmt_UTIL;