[Home] [Help]
PACKAGE: APPS.AHL_FMP_MR_DOC_ASSO_PVT
Source
1 PACKAGE AHL_FMP_MR_DOC_ASSO_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVMRDS.pls 120.0 2005/05/26 01:12:43 appldev noship $ */
3
4 TYPE doc_association_rec IS RECORD
5 (
6 DOC_TITLE_ASSO_ID NUMBER,
7 DOCUMENT_ID NUMBER,
8 DOCUMENT_NO VARCHAR2(80),
9 DOC_REVISION_ID NUMBER,
10 REVISION_NO VARCHAR2(30),
11 USE_LATEST_REV_FLAG VARCHAR2(1),
12 OBJECT_TYPE_CODE VARCHAR2(30),
13 OBJECT_TYPE_DESC VARCHAR2(80),
14 MR_HEADER_ID NUMBER,
15 MR_TITLE VARCHAR2(80),
16 MR_VERSION_NUMBER NUMBER,
17 SERIAL_NO VARCHAR2(30),
18 SOURCE_LANG VARCHAR2(12),
19 CHAPTER VARCHAR2(30),
20 SECTION VARCHAR2(30),
21 SUBJECT VARCHAR2(240),
22 PAGE VARCHAR2(5),
23 FIGURE VARCHAR2(30),
24 NOTE VARCHAR2(2000),
25 SOURCE_REF_CODE VARCHAR2(30),
26 SOURCE_REF_MEAN VARCHAR2(80),
27 OBJECT_VERSION_NUMBER NUMBER,
28 ATTRIBUTE_CATEGORY VARCHAR2(30),
29 ATTRIBUTE1 VARCHAR2(150),
30 ATTRIBUTE2 VARCHAR2(150),
31 ATTRIBUTE3 VARCHAR2(150),
32 ATTRIBUTE4 VARCHAR2(150),
33 ATTRIBUTE5 VARCHAR2(150),
34 ATTRIBUTE6 VARCHAR2(150),
35 ATTRIBUTE7 VARCHAR2(150),
36 ATTRIBUTE8 VARCHAR2(150),
37 ATTRIBUTE9 VARCHAR2(150),
38 ATTRIBUTE10 VARCHAR2(150),
39 ATTRIBUTE11 VARCHAR2(150),
40 ATTRIBUTE12 VARCHAR2(150),
41 ATTRIBUTE13 VARCHAR2(150),
42 ATTRIBUTE14 VARCHAR2(150),
43 ATTRIBUTE15 VARCHAR2(150),
44 DML_OPERATION VARCHAR2(1)
45 );
46
47 TYPE doc_association_tbl IS TABLE OF doc_association_rec INDEX BY BINARY_INTEGER;
48
49 -- Start of Comments
50 -- Procedure name : Process_Doc_Association
51 -- Type : Private
52 -- Pre-reqs :
53 -- Function :
54 -- Parameters :
55 --
56 -- Standard IN Parameters :
57 -- p_api_version NUMBER Required
58 -- p_init_msg_list VARCHAR2 Default FND_API.G_TRUE
59 -- p_commit VARCHAR2 Default FND_API.G_FALSE
60 -- p_validation_level NUMBER Default FND_API.G_VALID_LEVEL_FULL
61 -- p_validate_only VARCHAR2 Default FND_API.G_TRUE
62 -- p_default VARCHAR2 Default FND_API.G_FALSE
63 -- p_module_type VARCHAR2 Default NULL
64 --
65 -- Standard OUT Parameters :
66 -- x_return_status VARCHAR2 Required
67 -- x_msg_count NUMBER Required
68 -- x_msg_data VARCHAR2 Required
69 --
70 -- process_route_operation_as IN parameters:
71 -- None
72 --
73 -- process_route_operation_as IN OUT parameters:
74 -- p_x_association_tbl doc_association_tbl
75 --
76 -- process_route_operation_as OUT parameters:
77 -- None.
78 --
79 -- Version :
80 -- Current version 1.0
81 --
82 -- End of Comments
83
84
85 PROCEDURE Process_Doc_Association
86 (
87 p_api_version IN NUMBER := 1.0,
88 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
89 p_commit IN VARCHAR2 := FND_API.G_FALSE,
90 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
91 p_validate_only IN VARCHAR2 := FND_API.G_TRUE,
92 p_default IN VARCHAR2 := FND_API.G_FALSE,
93 p_module_type IN VARCHAR2 := NULL,
94 x_return_status OUT NOCOPY VARCHAR2,
95 x_msg_count OUT NOCOPY NUMBER,
96 x_msg_data OUT NOCOPY VARCHAR2,
97 p_x_association_tbl IN OUT NOCOPY doc_association_tbl
98 );
99
100 END AHL_FMP_MR_DOC_ASSO_PVT;