[Home] [Help]
PACKAGE: APPS.AHL_DI_ASSO_DOC_ASO_PVT
Source
1 PACKAGE AHL_DI_ASSO_DOC_ASO_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVDASS.pls 115.12 2002/12/03 12:30:39 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 := FND_API.G_MISS_NUM,
10 DOCUMENT_ID NUMBER := FND_API.G_MISS_NUM,
11 DOC_REVISION_ID NUMBER := FND_API.G_MISS_NUM,
12 USE_LATEST_REV_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
13 ASO_OBJECT_TYPE_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
14 ASO_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
15 SERIAL_NO VARCHAR2(30) := FND_API.G_MISS_CHAR,
16 SOURCE_LANG VARCHAR2(4) := FND_API.G_MISS_CHAR,
17 LANGUAGE VARCHAR2(4) := FND_API.G_MISS_CHAR,
18 CHAPTER VARCHAR2(30) := FND_API.G_MISS_CHAR,
19 SECTION VARCHAR2(30) := FND_API.G_MISS_CHAR,
20 SUBJECT VARCHAR2(240) := FND_API.G_MISS_CHAR,
21 PAGE VARCHAR2(5) := FND_API.G_MISS_CHAR,
22 FIGURE VARCHAR2(30) := FND_API.G_MISS_CHAR,
23 NOTE VARCHAR2(2000) := FND_API.G_MISS_CHAR,
24 SOURCE_REF_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
25 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
26 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
27 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33 ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34 ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35 ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36 ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37 ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38 ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
39 ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
40 ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
41 ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
42 DELETE_FLAG VARCHAR2(1) := 'N'
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 CREATE_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 update, removes association record
62 PROCEDURE MODIFY_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_x_association_tbl IN OUT NOCOPY association_tbl ,
70 x_return_status OUT NOCOPY VARCHAR2 ,
71 x_msg_count OUT NOCOPY NUMBER ,
72 x_msg_data OUT NOCOPY VARCHAR2);
73
74 --Procedure to copy new association record
75 Procedure COPY_ASSOCIATION
76 (
77 p_api_version IN NUMBER := 1.0 ,
78 p_init_msg_list IN VARCHAR2 := Fnd_Api.G_TRUE ,
79 p_commit IN VARCHAR2 := Fnd_Api.G_FALSE ,
80 p_validate_only IN VARCHAR2 := Fnd_Api.G_TRUE ,
81 p_validation_level IN NUMBER := Fnd_Api.G_VALID_LEVEL_FULL,
82 p_from_object_id IN NUMBER,
83 p_from_object_type IN VARCHAR2,
84 p_to_object_id IN NUMBER,
85 p_to_object_type IN VARCHAR2,
86 x_return_status OUT NOCOPY VARCHAR2 ,
87 x_msg_count OUT NOCOPY NUMBER ,
88 x_msg_data OUT NOCOPY VARCHAR2);
89
90 END AHL_DI_ASSO_DOC_ASO_PVT;