[Home] [Help]
PACKAGE: APPS.AMS_ATTACHMENT_PVT
Source
1 PACKAGE AMS_Attachment_PVT AUTHID CURRENT_USER AS
2 /* $Header: amsvatcs.pls 115.8 2004/03/27 02:24:29 julou ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_Attachment_PVT
7 -- Purpose
8 -- This package is used by Sales and Marketing Attachments starting
9 -- 11.5.6. It provides methods to tamper FND Attachments.
10 -- It bridges the gap between the java layer and the actual table
11 -- handlers that FND provides.It makes assumptions on how Sales
12 -- and Marketing use Attachments. Henceforth should not be used by other apps.
13 -- History
14 --
15 -- NOTE
16 --
17 -- End of Comments
18 -- ===============================================================
19
20 -- Default number of records fetch per call
21 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
22 --===================================================================
23 -- Start of Comments
24 -- -------------------------------------------------------
25 -- Record name
26 -- fnd_attachment_rec_type
27 -- -------------------------------------------------------
28
29 --===================================================================
30 TYPE fnd_attachment_rec_type IS RECORD
31 (
32 rowid varchar2(100),
33 document_id NUMBER,
34 datatype_id Number,
35 category_id Number := 1,/* default 1 => Misc */
36 security_type Number:= 4,/* default 4 => None */
37 publish_flag Varchar(1):= 'Y',/*default Y */
38 description VARCHAR2(255),
39 file_name VARCHAR2(255),
40 media_id Number,
41 file_size Varchar2(150),/* doc_attribute2 is used */
42 attached_document_id Number,
43 seq_num Number,
44 entity_name Varchar2(150),/* doc_attribute2 is used */
45 PK1_VALUE Varchar2(100),
46 automatically_added_flag Varchar2(1) := 'N',
47 short_text Varchar2(2000),
48 last_update_date Date,
49 last_updated_by NUMBER,
50 creation_date DATE,
51 created_by NUMBER,
52 last_update_login NUMBER,
53 attachment_type VARCHAR2(30),
54 language varchar2(30) := 'US',
55 usage_type varchar2(30) := 'O' ,
56 concur_last_update_date DATE
57 );
58
59
60 -- ==============================================================================
61 -- Start of Comments
62 -- ==============================================================================
63 -- API Name
64 -- Create_Fnd_Attachment
65 -- Type
66 -- Private
67 -- Pre-Req
68 --
69 -- Parameters
70 --
71 -- IN
72 -- p_api_version_number IN NUMBER Required
73 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
74 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
75 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
76 -- p_Fnd_Attachment_rec IN prompt_setup_rec_type Required
77 --
78 -- OUT
79 -- x_return_status OUT VARCHAR2
80 -- x_msg_count OUT NUMBER
81 -- x_msg_data OUT VARCHAR2
82 -- Version : Current version 1.0
83 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
84 -- and basic operation, developer must manually add parameters and business logic as necessary.
85 --
86 -- End of Comments
87 -- ==============================================================================
88 --
89
90 PROCEDURE Create_Fnd_Attachment(
91 p_api_version_number IN NUMBER,
92 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
93 p_commit IN VARCHAR2 := FND_API.G_FALSE,
94 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
95 x_return_status OUT NOCOPY VARCHAR2,
96 x_msg_count OUT NOCOPY NUMBER,
97 x_msg_data OUT NOCOPY VARCHAR2,
98 p_fnd_attachment_rec IN fnd_attachment_rec_type,
99 x_document_id OUT NOCOPY NUMBER,
100 x_attached_document_id OUT NOCOPY NUMBER
101 );
102
103 -- ==============================================================================
104 -- Start of Comments
105 -- ==============================================================================
106 -- API Name
107 -- Update_Fnd_Attachment
108 -- Type
109 -- Private
110 -- Pre-Req
111 --
112 -- Parameters
113 --
114 -- ==============================================================================
115 --
116
117 PROCEDURE Update_Fnd_Attachment(
118 p_api_version_number IN NUMBER,
119 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
120 p_commit IN VARCHAR2 := FND_API.G_FALSE,
121 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
122 x_return_status OUT NOCOPY VARCHAR2,
123 x_msg_count OUT NOCOPY NUMBER,
124 x_msg_data OUT NOCOPY VARCHAR2,
125 p_fnd_attachment_rec IN fnd_attachment_rec_type
126 );
127
128 -- ==============================================================================
129 -- Start of Comments
130 -- ==============================================================================
131 -- API Name
132 -- Delete_Fnd_Attachment
133 -- Type
134 -- Private
135 -- Pre-Req
136 --
137 -- End of Comments
138 -- ==============================================================================
139 --
140
141 PROCEDURE Delete_Fnd_Attachment(
142 p_api_version_number IN NUMBER,
143 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
144 p_commit IN VARCHAR2 := FND_API.G_FALSE,
145 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
146 x_return_status OUT NOCOPY VARCHAR2,
147 x_msg_count OUT NOCOPY NUMBER,
148 x_msg_data OUT NOCOPY VARCHAR2,
149 p_document_id IN NUMBER,
150 p_datatype_id IN NUMBER,
151 p_delete_attachment_ref_flag IN VARCHAR2
152 );
153
154 END AMS_Attachment_PVT;