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;