PACKAGE: APPS.AHL_FMP_MR_VISIT_TYPES_PVT

Source

1 PACKAGE AHL_FMP_MR_VISIT_TYPES_PVT AS
2 /* $Header: AHLVMRVS.pls 120.0 2005/05/25 23:58:37 appldev noship $ */
3 TYPE MR_VISIT_TYPE_REC_TYPE IS RECORD
4 (
5 MR_VISIT_TYPE_ID                        NUMBER,         -- Unique id for the table
6 OBJECT_VERSION_NUMBER                   NUMBER,         -- Used for handling concurrent users transacting
7 MR_HEADER_ID                            NUMBER,         -- Fkey for AHL_MR_HEADERS_B.MR_HEADER_ID
8 MR_VISIT_TYPE_CODE                      VARCHAR2(30),   -- LOOKUP_CODE from fnd_lookup_values_vl for LOOKUP_TYPE='AHL_LTP_SERVICE_TYPE LOOKUP_TYPE'
9 MR_VISIT_TYPE                           VARCHAR2(80),   -- Meaning for the code
10 ATTRIBUTE_CATEGORY                      VARCHAR2(30),
11 ATTRIBUTE1                              VARCHAR2(150),  -- Customizable descriptive flexfield columns 1-15
12 ATTRIBUTE2                              VARCHAR2(150),
13 ATTRIBUTE3                              VARCHAR2(150),
14 ATTRIBUTE4                              VARCHAR2(150),
15 ATTRIBUTE5                              VARCHAR2(150),
16 ATTRIBUTE6                              VARCHAR2(150),
17 ATTRIBUTE7                              VARCHAR2(150),
18 ATTRIBUTE8                              VARCHAR2(150),
19 ATTRIBUTE9                              VARCHAR2(150),
20 ATTRIBUTE10                             VARCHAR2(150),
21 ATTRIBUTE11                             VARCHAR2(150),
22 ATTRIBUTE12                             VARCHAR2(150),
23 ATTRIBUTE13                             VARCHAR2(150),
24 ATTRIBUTE14                             VARCHAR2(150),
25 ATTRIBUTE15                             VARCHAR2(150),
26 LAST_UPDATE_DATE                        DATE,
27 LAST_UPDATED_BY                         NUMBER(15),
28 CREATION_DATE                           DATE,
29 CREATED_BY                              NUMBER(15),     -- Default application transacting user
30 LAST_UPDATE_LOGIN                       NUMBER(15),     -- Last updated application transacting user
31 DML_OPERATION                           VARCHAR2(1)     -- DML operation 'C'/'U'/'D' for Create/Update/Delete dml operations
32 );
33 
34 TYPE MR_VISIT_TYPE_TBL_TYPE IS TABLE OF MR_VISIT_TYPE_REC_TYPE INDEX BY BINARY_INTEGER;
35 
36 PROCEDURE PROCESS_MR_VISIT_TYPES
37  (
38  p_api_version IN NUMBER,
39  p_init_msg_list                IN  		VARCHAR2   := FND_API.G_FALSE,
40  p_commit                       IN  		VARCHAR2   := FND_API.G_FALSE,
41  p_validation_level             IN  		NUMBER     := FND_API.G_VALID_LEVEL_FULL,
42  p_default                      IN  		VARCHAR2   := FND_API.G_FALSE,
43  p_module_type                  IN              VARCHAR2,
44  x_return_status                OUT NOCOPY      VARCHAR2,
45  x_msg_count                    OUT NOCOPY      NUMBER,
46  x_msg_data                     OUT NOCOPY      VARCHAR2,
47  p_x_mr_visit_type_tbl          IN OUT NOCOPY   MR_VISIT_TYPE_TBL_TYPE
48  );
49 END  AHL_FMP_MR_VISIT_TYPES_PVT;