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