[Home] [Help]
PACKAGE: APPS.AHL_DI_PRO_TYPE_ASO_PVT
Source
1 PACKAGE AHL_DI_PRO_TYPE_ASO_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVPTAS.pls 115.9 2002/12/03 12:32:13 pbarman noship $ */
3 -- Name : doc type association rec
4 -- Type : type definition, group
5 -- Description : Record to hold the attributes of document type and subtype
6 -- associations
7
8 TYPE doc_type_assoc_rec IS RECORD
9 (
10 DOCUMENT_SUB_TYPE_ID NUMBER ,
11 DOC_TYPE_CODE VARCHAR2(30) ,
12 DOC_SUB_TYPE_CODE VARCHAR2(30) ,
13 ATTRIBUTE_CATEGORY VARCHAR2(30) ,
14 ATTRIBUTE1 VARCHAR2(150) ,
15 ATTRIBUTE2 VARCHAR2(150) ,
16 ATTRIBUTE3 VARCHAR2(150) ,
17 ATTRIBUTE4 VARCHAR2(150) ,
18 ATTRIBUTE5 VARCHAR2(150) ,
19 ATTRIBUTE6 VARCHAR2(150) ,
20 ATTRIBUTE7 VARCHAR2(150) ,
21 ATTRIBUTE8 VARCHAR2(150) ,
22 ATTRIBUTE9 VARCHAR2(150) ,
23 ATTRIBUTE10 VARCHAR2(150) ,
24 ATTRIBUTE11 VARCHAR2(150) ,
25 ATTRIBUTE12 VARCHAR2(150) ,
26 ATTRIBUTE13 VARCHAR2(150) ,
27 ATTRIBUTE14 VARCHAR2(150) ,
28 ATTRIBUTE15 VARCHAR2(150) ,
29 OBJECT_VERSION_NUMBER NUMBER ,
30 DELETE_FLAG VARCHAR2(1) := 'N'
31 );
32
33 --Declare table type
34 TYPE doc_type_assoc_tbl IS TABLE OF doc_type_assoc_rec
35 INDEX BY BINARY_INTEGER;
36
37 -- Procedure to create doc type associations for document index
38 PROCEDURE CREATE_DOC_TYPE_ASSOC
39 (
40 p_api_version IN NUMBER := 1.0 ,
41 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
42 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
43 p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
44 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
45 p_x_doc_type_assoc_tbl IN OUT NOCOPY doc_type_assoc_tbl ,
46 x_return_status OUT NOCOPY VARCHAR2 ,
47 x_msg_count OUT NOCOPY NUMBER ,
48 x_msg_data OUT NOCOPY VARCHAR2);
49
50 -- Procedure to update and delete doc type associations for document index
51 PROCEDURE MODIFY_DOC_TYPE_ASSOC
52 (
53 p_api_version IN NUMBER := 1.0 ,
54 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
55 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
56 p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
57 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
58 p_x_doc_type_assoc_tbl IN OUT NOCOPY doc_type_assoc_tbl ,
59 x_return_status OUT NOCOPY VARCHAR2 ,
60 x_msg_count OUT NOCOPY NUMBER ,
61 x_msg_data OUT NOCOPY VARCHAR2);
62
63 END AHL_DI_PRO_TYPE_ASO_PVT;