[Home] [Help]
PACKAGE: APPS.AHL_DI_ASSO_DOC_GEN_PVT
Source
1 PACKAGE AHL_DI_ASSO_DOC_GEN_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVDAGS.pls 115.0 2003/07/02 11:45:49 pbarman noship $ */
3 -- Name : association_rec
4 -- Type : type definition, group
5 -- Description : Record to hold the attributes of the document associations
6
7 TYPE association_rec IS RECORD
8 (
9 DOC_TITLE_ASSO_ID NUMBER := NULL,
10 DOCUMENT_ID NUMBER := NULL,
11 DOC_REVISION_ID NUMBER := NULL,
12 USE_LATEST_REV_FLAG VARCHAR2(1) := NULL,
13 ASO_OBJECT_TYPE_CODE VARCHAR2(30) := NULL,
14 ASO_OBJECT_ID NUMBER := NULL,
15 SERIAL_NO VARCHAR2(30) := NULL,
16 SOURCE_LANG VARCHAR2(4) := NULL,
17 LANGUAGE VARCHAR2(4) := NULL,
18 CHAPTER VARCHAR2(30) := NULL,
19 SECTION VARCHAR2(30) := NULL,
20 SUBJECT VARCHAR2(240) := NULL,
21 PAGE VARCHAR2(5) := NULL,
22 FIGURE VARCHAR2(30) := NULL,
23 NOTE VARCHAR2(2000) := NULL,
24 SOURCE_REF_CODE VARCHAR2(30) := NULL,
25 OBJECT_VERSION_NUMBER NUMBER := NULL,
26 ATTRIBUTE_CATEGORY VARCHAR2(30) := NULL,
27 ATTRIBUTE1 VARCHAR2(150) := NULL,
28 ATTRIBUTE2 VARCHAR2(150) := NULL,
29 ATTRIBUTE3 VARCHAR2(150) := NULL,
30 ATTRIBUTE4 VARCHAR2(150) := NULL,
31 ATTRIBUTE5 VARCHAR2(150) := NULL,
32 ATTRIBUTE6 VARCHAR2(150) := NULL,
33 ATTRIBUTE7 VARCHAR2(150) := NULL,
34 ATTRIBUTE8 VARCHAR2(150) := NULL,
35 ATTRIBUTE9 VARCHAR2(150) := NULL,
36 ATTRIBUTE10 VARCHAR2(150) := NULL,
37 ATTRIBUTE11 VARCHAR2(150) := NULL,
38 ATTRIBUTE12 VARCHAR2(150) := NULL,
39 ATTRIBUTE13 VARCHAR2(150) := NULL,
40 ATTRIBUTE14 VARCHAR2(150) := NULL,
41 ATTRIBUTE15 VARCHAR2(150) := NULL,
42 DML_OPERATION VARCHAR2(1)
43 );
44
45 --Declare table type
46 TYPE association_tbl IS TABLE OF association_rec INDEX BY BINARY_INTEGER;
47
48 -- Procedure to create association record
49 PROCEDURE PROCESS_ASSOCIATION
50 (
51 p_api_version IN NUMBER := 1.0 ,
52 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
53 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
54 p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
55 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
56 p_x_association_tbl IN OUT NOCOPY association_tbl ,
57 x_return_status OUT NOCOPY VARCHAR2 ,
58 x_msg_count OUT NOCOPY NUMBER ,
59 x_msg_data OUT NOCOPY VARCHAR2);
60
61 --Procedure to copy new association record
62 Procedure COPY_ASSOCIATION
63 (
64 p_api_version IN NUMBER := 1.0 ,
65 p_init_msg_list IN VARCHAR2 := Fnd_Api.G_TRUE ,
66 p_commit IN VARCHAR2 := Fnd_Api.G_FALSE ,
67 p_validate_only IN VARCHAR2 := Fnd_Api.G_TRUE ,
68 p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
69 p_from_object_id IN NUMBER,
70 p_from_object_type IN VARCHAR2,
71 p_to_object_id IN NUMBER,
72 p_to_object_type IN VARCHAR2,
73 x_return_status OUT NOCOPY VARCHAR2 ,
74 x_msg_count OUT NOCOPY NUMBER ,
75 x_msg_data OUT NOCOPY VARCHAR2);
76
77
78 -- Procedure to delete all associations to a particular ASO object
79 Procedure DELETE_ALL_ASSOCIATIONS
80 (
81 p_api_version IN NUMBER := 1.0 ,
82 p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
83 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
84 p_validate_only IN VARCHAR2 := FND_API.G_TRUE ,
85 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
86 p_aso_object_type_code IN VARCHAR2 ,
87 p_aso_object_id IN NUMBER ,
88 x_return_status OUT NOCOPY VARCHAR2 ,
89 x_msg_count OUT NOCOPY NUMBER ,
90 x_msg_data OUT NOCOPY VARCHAR2
91
92
93 );
94
95
96 END AHL_DI_ASSO_DOC_GEN_PVT;