[Home] [Help]
PACKAGE: APPS.AHL_DI_ASSO_DOC_GEN_PUB
Source
1 PACKAGE AHL_DI_ASSO_DOC_GEN_PUB AUTHID CURRENT_USER AS
2 /* $Header: AHLPDAGS.pls 120.0 2005/05/25 23:56:49 appldev noship $ */
3 /*#
4 * This is the private interface to associate and dis-associate existing documents and revisions to other CMRO objects.
5 * @rep:scope private
6 * @rep:product AHL
7 * @rep:displayname Document Association
8 * @rep:lifecycle active
9 * @rep:category BUSINESS_ENTITY AHL_DOCUMENT
10 */
11
12 TYPE association_rec IS RECORD
13 (
14 DOC_TITLE_ASSO_ID NUMBER := NULL,
15 DOCUMENT_ID NUMBER := NULL,
16 DOCUMENT_NO VARCHAR2(80) := NULL,
17 DOC_REVISION_ID NUMBER := NULL,
18 REVISION_NO VARCHAR2(30) := NULL,
19 USE_LATEST_REV_FLAG VARCHAR2(1) := NULL,
20 ASO_OBJECT_TYPE_CODE VARCHAR2(30) := NULL,
21 ASO_OBJECT_DESC VARCHAR2(80) := NULL,
22 ASO_OBJECT_ID NUMBER := NULL,
23 SERIAL_NO VARCHAR2(30) := NULL,
24 SOURCE_LANG VARCHAR2(12) := NULL,
25 CHAPTER VARCHAR2(30) := NULL,
26 SECTION VARCHAR2(30) := NULL,
27 SUBJECT VARCHAR2(240) := NULL,
28 PAGE VARCHAR2(5) := NULL,
29 FIGURE VARCHAR2(30) := NULL,
30 NOTE VARCHAR2(2000):= NULL,
31 SOURCE_REF_CODE VARCHAR2(30) := NULL,
32 SOURCE_REF_MEAN VARCHAR2(80) := NULL,
33 OBJECT_VERSION_NUMBER NUMBER := NULL,
34 ATTRIBUTE_CATEGORY VARCHAR2(30) := NULL,
35 ATTRIBUTE1 VARCHAR2(150) := NULL,
36 ATTRIBUTE2 VARCHAR2(150) := NULL,
37 ATTRIBUTE3 VARCHAR2(150) := NULL,
38 ATTRIBUTE4 VARCHAR2(150) := NULL,
39 ATTRIBUTE5 VARCHAR2(150) := NULL,
40 ATTRIBUTE6 VARCHAR2(150) := NULL,
41 ATTRIBUTE7 VARCHAR2(150) := NULL,
42 ATTRIBUTE8 VARCHAR2(150) := NULL,
43 ATTRIBUTE9 VARCHAR2(150) := NULL,
44 ATTRIBUTE10 VARCHAR2(150) := NULL,
45 ATTRIBUTE11 VARCHAR2(150) := NULL,
46 ATTRIBUTE12 VARCHAR2(150) := NULL,
47 ATTRIBUTE13 VARCHAR2(150) := NULL,
48 ATTRIBUTE14 VARCHAR2(150) := NULL,
49 ATTRIBUTE15 VARCHAR2(150) := NULL,
50 DML_OPERATION VARCHAR2(1) := 'N'
51 );
52
53
54 TYPE association_tbl IS TABLE OF association_rec INDEX BY BINARY_INTEGER;
55
56 /*#
57 * It allows association and dis-association of existing documents and revisions to other CMRO objects.
58 * @param p_api_version Api Version Number
59 * @param p_init_msg_list Initialize the message stack, default value FND_API.G_TRUE
60 * @param p_commit To decide whether to commit the transaction, default value FND_API.G_FALSE
61 * @param p_validation_level Validation level, default value FND_API.G_VALID_LEVEL_FULL
62 * @param p_validate_only To decide whether to validate, default value FND_API.G_TRUE
63 * @param p_module_type To indicate whether called 'API' or 'JSP', default value NULL
64 * @param x_return_status Return status
65 * @param x_msg_count Return message count
66 * @param x_msg_data Return message data
67 * @param p_x_association_tbl Document associations table of type association_tbl
68 * @rep:scope private
69 * @rep:lifecycle active
70 * @rep:displayname Process Document Association
71 */
72 PROCEDURE PROCESS_ASSOCIATION
73 (
74 p_api_version IN NUMBER := 1.0,
75 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
76 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
77 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
78 p_validate_only IN VARCHAR2 := FND_API.G_FALSE,
79 p_module_type IN VARCHAR2 ,
80 x_return_status OUT NOCOPY VARCHAR2,
81 x_msg_count OUT NOCOPY NUMBER,
82 x_msg_data OUT NOCOPY VARCHAR2,
83 p_x_association_tbl IN OUT NOCOPY association_tbl
84 );
85
86 END AHL_DI_ASSO_DOC_GEN_PUB;