[Home] [Help]
PACKAGE: APPS.AMW_ATTACHMENT_PVT
Source
1 PACKAGE AMW_Attachment_PVT AUTHID CURRENT_USER AS
2 /* $Header: amwvatcs.pls 120.0 2005/05/31 22:19:31 appldev noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMW_Attachment_PVT
7 -- Purpose
8 -- This package is used by Internal Controls Manager starting
9 -- 11.5.10.
10 -- History
11 --
12 -- NOTE
13 --
14 -- End of Comments
15 -- ===============================================================
16
17 -- Default number of records fetch per call
18 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
19 --===================================================================
20 -- Start of Comments
21 -- -------------------------------------------------------
22 -- Record name
23 -- fnd_attachment_rec_type
24 -- -------------------------------------------------------
25
26 --===================================================================
27 TYPE fnd_attachment_rec_type IS RECORD
28 (
29 rowid varchar2(100),
30 document_id NUMBER,
31 datatype_id Number,
32 category_id Number := 1,/* default 1 => Misc */
33 security_type Number := 4,/* default 4 => None */
34 publish_flag Varchar(1):= 'Y',/*default Y */
35 description VARCHAR2(255),
36 file_name VARCHAR2(2048),
37 media_id Number,
38 file_size Varchar2(150),/* doc_attribute2 is used */
39 attached_document_id Number,
40 seq_num Number,
41 entity_name Varchar2(40),/* doc_attribute2 is used */
42 PK1_VALUE Varchar2(100),
43 automatically_added_flag Varchar2(1) := 'N',
44 short_text Varchar2(2000),
45 last_update_date Date,
46 last_updated_by NUMBER,
47 creation_date DATE,
48 created_by NUMBER,
49 last_update_login NUMBER,
50 attachment_type VARCHAR2(30),
51 language varchar2(30) := 'US',
52 usage_type varchar2(30) := 'O'
53 );
54
55
56 -- ==============================================================================
57 -- Start of Comments
58 -- ==============================================================================
59 -- API Name
60 -- Create_Fnd_Attachment
61 -- Type
62 -- Private
63 -- Pre-Req
64 --
65 -- Parameters
66 --
67 -- IN
68 -- p_api_version_number IN NUMBER Required
69 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
70 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
71 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
72 -- p_Fnd_Attachment_rec IN prompt_setup_rec_type Required
73 --
74 -- OUT
75 -- x_return_status OUT VARCHAR2
76 -- x_msg_count OUT NUMBER
77 -- x_msg_data OUT VARCHAR2
78 -- Version : Current version 1.0
79 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
80 -- and basic operation, developer must manually add parameters and business logic as necessary.
81 --
82 -- End of Comments
83 -- ==============================================================================
84 --
85
86 PROCEDURE Create_Fnd_Attachment(
87 p_api_version_number IN NUMBER,
88 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
89 p_commit IN VARCHAR2 := FND_API.G_FALSE,
90 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
91 x_return_status OUT NOCOPY VARCHAR2,
92 x_msg_count OUT NOCOPY NUMBER,
93 x_msg_data OUT NOCOPY VARCHAR2,
94 p_fnd_attachment_rec IN fnd_attachment_rec_type,
95 x_document_id OUT NOCOPY NUMBER,
96 x_attached_document_id OUT NOCOPY NUMBER
97 );
98
99 END AMW_Attachment_PVT;