[Home] [Help]
PACKAGE: APPS.AHL_DI_PRO_TYPE_ASO_PUB
Source
1 PACKAGE AHL_DI_PRO_TYPE_ASO_PUB AUTHID CURRENT_USER AS
2 /* $Header: AHLPPTAS.pls 120.0 2005/05/26 00:58:07 appldev noship $ */
3 /*#
4 * This is the private interface to create, modify and delete document type associations to document sub-types.
5 * @rep:scope private
6 * @rep:product AHL
7 * @rep:displayname Document Type Association
8 * @rep:lifecycle active
9 * @rep:category BUSINESS_ENTITY AHL_DOCUMENT
10 */
11
12 -- Name : doc type association rec
13 -- Type : type definition, group
14 -- Description : Record to hold the attributes of document type and subtype
15 -- associations
16
17 TYPE doc_type_assoc_rec IS RECORD
18 (
19 DOCUMENT_SUB_TYPE_ID NUMBER ,
20 DOC_TYPE_CODE VARCHAR2(30) ,
21 DOC_TYPE_DESC VARCHAR2(80) ,
22 DOC_SUB_TYPE_CODE VARCHAR2(30) ,
23 DOC_SUB_TYPE_DESC VARCHAR2(80) ,
24 ATTRIBUTE_CATEGORY VARCHAR2(30) ,
25 ATTRIBUTE1 VARCHAR2(150) ,
26 ATTRIBUTE2 VARCHAR2(150) ,
27 ATTRIBUTE3 VARCHAR2(150) ,
28 ATTRIBUTE4 VARCHAR2(150) ,
29 ATTRIBUTE5 VARCHAR2(150) ,
30 ATTRIBUTE6 VARCHAR2(150) ,
31 ATTRIBUTE7 VARCHAR2(150) ,
32 ATTRIBUTE8 VARCHAR2(150) ,
33 ATTRIBUTE9 VARCHAR2(150) ,
34 ATTRIBUTE10 VARCHAR2(150) ,
35 ATTRIBUTE11 VARCHAR2(150) ,
36 ATTRIBUTE12 VARCHAR2(150) ,
37 ATTRIBUTE13 VARCHAR2(150) ,
38 ATTRIBUTE14 VARCHAR2(150) ,
39 ATTRIBUTE15 VARCHAR2(150) ,
40 OBJECT_VERSION_NUMBER NUMBER ,
41 DELETE_FLAG VARCHAR2(1) := 'N'
42 );
43 --Declare Table Type
44 TYPE doc_type_assoc_tbl IS TABLE OF doc_type_assoc_rec
45 INDEX BY BINARY_INTEGER;
46
47 /*#
48 * It allows creation of document type associations with document sub-types.
49 * @param p_api_version Api Version Number
50 * @param p_init_msg_list Initialize the message stack, default value FND_API.G_TRUE
51 * @param p_commit To decide whether to commit the transaction, default value FND_API.G_FALSE
52 * @param p_validation_level Validation level, default value FND_API.G_VALID_LEVEL_FULL
53 * @param p_validate_only To decide whether to validate, default value FND_API.G_TRUE
54 * @param p_module_type To indicate whether called 'API' or 'JSP', default value NULL
55 * @param x_return_status Return status
56 * @param x_msg_count Return message count
57 * @param x_msg_data Return message data
58 * @param p_x_doc_type_assoc_tbl Document type associations table of type doc_type_assoc_tbl
59 * @rep:scope private
60 * @rep:lifecycle active
61 * @rep:displayname Create Document Type Association
62 */
63 PROCEDURE CREATE_DOC_TYPE_ASSOC
64 (
65 p_api_version IN NUMBER := 1.0 ,
66 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
67 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
68 p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
69 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
70 p_x_doc_type_assoc_tbl IN OUT NOCOPY doc_type_assoc_tbl ,
71 p_module_type IN VARCHAR2 ,
72 x_return_status OUT NOCOPY VARCHAR2 ,
73 x_msg_count OUT NOCOPY NUMBER ,
74 x_msg_data OUT NOCOPY VARCHAR2);
75
76
77 /*#
78 * It allows modification and deletion of document type associations with document sub-types.
79 * @param p_api_version Api Version Number
80 * @param p_init_msg_list Initialize the message stack, default value FND_API.G_TRUE
81 * @param p_commit To decide whether to commit the transaction, default value FND_API.G_FALSE
82 * @param p_validation_level Validation level, default value FND_API.G_VALID_LEVEL_FULL
83 * @param p_validate_only To decide whether to validate, default value FND_API.G_TRUE
84 * @param p_module_type To indicate whether called 'API' or 'JSP', default value NULL
85 * @param x_return_status Return status
86 * @param x_msg_count Return message count
87 * @param x_msg_data Return message data
88 * @param p_x_doc_type_assoc_tbl Document type associations table of type doc_type_assoc_tbl
89 * @rep:scope private
90 * @rep:lifecycle active
91 * @rep:displayname Modify Document Type Association
92 */
93 PROCEDURE MODIFY_DOC_TYPE_ASSOC
94 (
95 p_api_version IN NUMBER := 1.0 ,
96 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
97 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
98 p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
99 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
100 p_x_doc_type_assoc_tbl IN OUT NOCOPY doc_type_assoc_tbl ,
101 p_module_type IN VARCHAR2 ,
102 x_return_status OUT NOCOPY VARCHAR2 ,
103 x_msg_count OUT NOCOPY NUMBER ,
104 x_msg_data OUT NOCOPY VARCHAR2);
105
106 END AHL_DI_PRO_TYPE_ASO_PUB;