[Home] [Help]
PACKAGE: APPS.AHL_DI_ASSO_DOCASO_PVT
Source
1 PACKAGE AHL_DI_ASSO_DOCASO_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVDOAS.pls 115.3 2002/12/03 12:31:32 pbarman noship $ */
3 TYPE association_rec IS RECORD
4 (
5 ROWID VARCHAR2(30),
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 ASO_OBJECT_TYPE_CODE VARCHAR2(30) ,
13 ASO_OBJECT_DESC VARCHAR2(80) ,
14 ASO_OBJECT_ID NUMBER ,
15 SERIAL_NO VARCHAR2(30) ,
16 SOURCE_LANG VARCHAR2(12) ,
17 CHAPTER VARCHAR2(30) ,
18 SECTION VARCHAR2(30) ,
19 SUBJECT VARCHAR2(240) ,
20 PAGE VARCHAR2(5) ,
21 FIGURE VARCHAR2(30) ,
22 NOTE VARCHAR2(2000) ,
23 SOURCE_REF_CODE VARCHAR2(30) ,
24 SOURCE_REF_MEAN VARCHAR2(80) ,
25 OBJECT_VERSION_NUMBER NUMBER ,
26 LAST_UPDATE_DATE DATE ,
27 LAST_UPDATED_BY NUMBER ,
28 CREATION_DATE DATE ,
29 CREATED_BY NUMBER(15) ,
30 LAST_UPDATE_LOGIN NUMBER(15) ,
31 ATTRIBUTE_CATEGORY VARCHAR2(30) ,
32 ATTRIBUTE1 VARCHAR2(150) ,
33 ATTRIBUTE2 VARCHAR2(150) ,
34 ATTRIBUTE3 VARCHAR2(150) ,
35 ATTRIBUTE4 VARCHAR2(150) ,
36 ATTRIBUTE5 VARCHAR2(150) ,
37 ATTRIBUTE6 VARCHAR2(150) ,
38 ATTRIBUTE7 VARCHAR2(150) ,
39 ATTRIBUTE8 VARCHAR2(150) ,
40 ATTRIBUTE9 VARCHAR2(150) ,
41 ATTRIBUTE10 VARCHAR2(150) ,
42 ATTRIBUTE11 VARCHAR2(150) ,
43 ATTRIBUTE12 VARCHAR2(150) ,
44 ATTRIBUTE13 VARCHAR2(150) ,
45 ATTRIBUTE14 VARCHAR2(150) ,
46 ATTRIBUTE15 VARCHAR2(150) ,
47 DML_OPERATION VARCHAR2(1) := 'N'
48 );
49
50 TYPE association_tbl IS TABLE OF association_rec INDEX BY BINARY_INTEGER;
51
52 PROCEDURE PROCESS_ASSOCIATION
53 (
54 p_api_version IN NUMBER := 1.0,
55 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
56 p_commit IN VARCHAR2 := FND_API.G_FALSE,
57 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
58 p_default IN VARCHAR2 := FND_API.G_FALSE,
59 p_module_type IN VARCHAR2,
60 x_return_status OUT NOCOPY VARCHAR2,
61 x_msg_count OUT NOCOPY NUMBER,
62 x_msg_data OUT NOCOPY VARCHAR2,
63 p_x_association_tbl IN OUT NOCOPY association_tbl
64 );
65
66 END AHL_DI_ASSO_DOCASO_PVT;