[Home] [Help]
PACKAGE: APPS.AHL_DI_ASSO_DOC_ASO_PUB
Source
1 PACKAGE AHL_DI_ASSO_DOC_ASO_PUB AUTHID CURRENT_USER AS
2 /* $Header: AHLPDASS.pls 115.13 2002/12/03 12:28:29 pbarman noship $ */
3 TYPE association_rec IS RECORD
4 (
5 DOC_TITLE_ASSO_ID NUMBER := FND_API.G_MISS_NUM,
6 DOCUMENT_ID NUMBER := FND_API.G_MISS_NUM,
7 DOCUMENT_NO VARCHAR2(80) := FND_API.G_MISS_CHAR,
8 DOC_REVISION_ID NUMBER := FND_API.G_MISS_NUM,
9 REVISION_NO VARCHAR2(30) := FND_API.G_MISS_CHAR,
10 USE_LATEST_REV_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
11 ASO_OBJECT_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
12 ASO_OBJECT_DESC VARCHAR2(80) := FND_API.G_MISS_CHAR,
13 ASO_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
14 SERIAL_NO VARCHAR2(30) := FND_API.G_MISS_CHAR,
15 SOURCE_LANG VARCHAR2(12) := FND_API.G_MISS_CHAR,
16 CHAPTER VARCHAR2(30) := FND_API.G_MISS_CHAR,
17 SECTION VARCHAR2(30) := FND_API.G_MISS_CHAR,
18 SUBJECT VARCHAR2(240) := FND_API.G_MISS_CHAR,
19 PAGE VARCHAR2(5) := FND_API.G_MISS_CHAR,
20 FIGURE VARCHAR2(30) := FND_API.G_MISS_CHAR,
21 NOTE VARCHAR2(2000) := FND_API.G_MISS_CHAR,
22 SOURCE_REF_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
23 SOURCE_REF_MEAN VARCHAR2(80) := FND_API.G_MISS_CHAR,
24 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
25 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
26 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32 ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33 ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34 ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35 ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36 ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37 ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38 ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39 ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40 ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41 DELETE_FLAG VARCHAR2(1) := 'N'
42 );
43
44
45 TYPE association_tbl IS TABLE OF association_rec INDEX BY BINARY_INTEGER;
46
47 PROCEDURE CREATE_ASSOCIATION
48 (
49 p_api_version IN NUMBER := 1.0 ,
50 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
51 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
52 p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
53 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
54 p_x_association_tbl IN OUT NOCOPY association_tbl ,
55 p_module_type IN VARCHAR2 ,
56 x_return_status OUT NOCOPY VARCHAR2 ,
57 x_msg_count OUT NOCOPY NUMBER ,
58 x_msg_data OUT NOCOPY VARCHAR2);
59
60
61 PROCEDURE MODIFY_ASSOCIATION
62 (
63 p_api_version IN NUMBER := 1.0 ,
64 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
65 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
66 p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
67 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
68 p_x_association_tbl IN OUT NOCOPY association_tbl ,
69 p_module_type IN VARCHAR2 ,
70 x_return_status OUT NOCOPY VARCHAR2 ,
71 x_msg_count OUT NOCOPY NUMBER ,
72 x_msg_data OUT NOCOPY VARCHAR2);
73
74 PROCEDURE PROCESS_ASSOCIATION
75 (
76 p_api_version IN NUMBER := 1.0 ,
77 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
78 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
79 p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
80 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
81 p_x_association_tblm IN OUT NOCOPY association_tbl ,
82 p_x_association_tblc IN OUT NOCOPY association_tbl ,
83 p_module_type IN VARCHAR2 ,
84 x_return_status OUT NOCOPY VARCHAR2 ,
85 x_msg_count OUT NOCOPY NUMBER ,
86 x_msg_data OUT NOCOPY VARCHAR2);
87
88
89
90 END AHL_DI_ASSO_DOC_ASO_PUB;