1 PACKAGE oe_fnd_attachments_pvt AUTHID CURRENT_USER as
2 /* $Header: OEXVATTS.pls 120.0.12010000.1 2008/07/25 07:58:26 appldev ship $ */
3
4 -- structure used to store attachment addition rule
5 TYPE Attachment_Rule_Rec_Type IS RECORD
6 (
7 document_id number,
8 group_number number,
9 attribute_code varchar2(30),
10 column_name varchar2(30),
11 data_type varchar2(30),
12 included_in_dSQL boolean default FALSE,
13 include_in_Fetch boolean default FALSE,
14 required_value varchar2(50),
15 actual_value varchar2(50),
16 rule_valid boolean default FALSE
17 );
18
19 TYPE Attachment_Rule_Tbl_Type IS TABLE OF Attachment_Rule_Rec_Type
20 INDEX BY BINARY_INTEGER;
21
22 -- Start of Comments
23 -- API name Add_Attachments_Automatic
24 -- Type Util
25 -- Function
26 --
27 -- Pre-reqs
28 --
29 -- Parameters
30 --
31 -- Version Current version = 1.0
32 -- Initial version = 1.0
33 --
34 -- Notes
35 -- this procedure will evaluvate all attachment additions rules that
36 -- are defined on the enity(p_entity_name) and add all the qualified
37 -- documents as automatic attachments to the entity/pk?_values
38 -- the count of documents that are attached will be returned in
39 -- x_attachment_count.
40 -- End of Comments
41 ---------------------------------------------------------------------
42 PROCEDURE Add_Attachments_Automatic
43 (
44 p_api_version in number,
45 p_entity_name in varchar2,
46 p_pk1_value in varchar2,
47 p_pk2_value in varchar2 default null,
48 p_pk3_value in varchar2 default null,
49 p_pk4_value in varchar2 default null,
50 p_pk5_value in varchar2 default null,
51 p_commit in varchar2 := fnd_api.G_FALSE,
52 x_attachment_count out nocopy number,
53
54 x_return_status out nocopy varchar2,
55
56 x_msg_count out nocopy number,
57
58 x_msg_data out nocopy varchar2
59
60 );
61
62 -- Start of Comments
63 -- API name Add_Attachment
64 -- Type Util
65 -- Function
66 --
67 -- Pre-reqs
68 --
69 -- Parameters
70 --
71 -- Version Current version = 1.0
72 -- Initial version = 1.0
73 --
74 -- Notes
75 -- this procedure will accept a document_id and attach it to the given
76 -- enity/pk?_values
77 -- End of Comments
78 ---------------------------------------------------------------------
79 PROCEDURE Add_Attachment
80 (
81 p_api_version in number,
82 p_entity_name in varchar,
83 p_pk1_value in varchar2,
84 p_pk2_value in varchar2 default null,
85 p_pk3_value in varchar2 default null,
86 p_pk4_value in varchar2 default null,
87 p_pk5_value in varchar2 default null,
88 p_automatic_flag in varchar2 default 'N',
89 p_document_id in number,
90 p_validate_flag in varchar2 default 'Y',
91 x_attachment_id out nocopy number,
92
93 x_return_status out nocopy varchar2,
94
95 x_msg_count out nocopy number,
96
97 x_msg_data out nocopy varchar2
98
99 );
100
101 -- Start of Comments
102 -- API name Delete_Attachments
103 -- Type PRIVATE
104 -- Function
105 --
106 -- Pre-reqs
107 --
108 -- Parameters
109 --
110 -- Version Current version = 1.0
111 -- Initial version = 1.0
112 --
113 -- Notes
114 --
115 -- End of Comments
116 ---------------------------------------------------------------------
117 PROCEDURE Delete_Attachments
118 (
119 p_api_version in number,
120 p_entity_name in varchar2,
121 p_pk1_value in varchar2,
122 p_pk2_value in varchar2 default null,
123 p_pk3_value in varchar2 default null,
124 p_pk4_value in varchar2 default null,
125 p_pk5_value in varchar2 default null,
126 p_automatic_atchmts_only in varchar2 default 'N',
127 x_return_status out nocopy varchar2
128
129 );
130
131 END oe_fnd_attachments_pvt;