[Home] [Help]
PACKAGE: APPS.AHL_VWP_VISITS_PUB
Source
1 PACKAGE AHL_VWP_VISITS_PUB AUTHID CURRENT_USER AS
2 /* $Header: AHLPVSTS.pls 120.3.12020000.2 2012/12/10 16:35:18 prakkum ship $ */
3 /*#
4 * Package containing public APIs to manage CMRO visits.
5 * @rep:scope public
6 * @rep:product AHL
7 * @rep:displayname VWP Visits
8 * @rep:lifecycle active
9 * @rep:category BUSINESS_ENTITY AHL_MAINT_VISIT
10 */
11
12 -------------------------------------------------------------------------------------------
13 -- Start of Comments
14 -- Procedure name : Create_Visit
15 -- Type : Public
16 -- Function : Creates a visit.
17 -- Pre-reqs :
18 -- Parameters :
19 --
20 -- Create_Visit Parameters:
21 -- p_x_visit_rec IN OUT NOCOPY AHL_VWP_VISITS_PVT.Visit_Rec_Type
22 -- Description of some key attributes in p_x_visit_rec:
23 -- VISIT_NAME VARCHAR2(80) Mandatory
24 -- DESCRIPTION VARCHAR2(4000) Optional
25 -- ORGANIZATION_ID NUMBER Optional
26 -- ORG_NAME VARCHAR2(240) Optional
27 -- DEPARTMENT_ID NUMBER Optional
28 -- DEPT_NAME VARCHAR2(240) Optional
29 -- SERVICE_REQUEST_ID NUMBER Optional
30 -- SERVICE_REQUEST_NUMBER VARCHAR2(240) Optional
31 -- START_DATE DATE Mandatory for transit visits.
32 -- START_HOUR NUMBER Optional
33 -- START_MIN NUMBER Optional
34 -- PLAN_END_DATE DATE Optional
35 -- PLAN_END_HOUR NUMBER Optional
36 -- PLAN_END_MIN NUMBER Optional
37 -- VISIT_TYPE_CODE VARCHAR2(30) Optional
38 -- VISIT_TYPE_NAME VARCHAR2(80) Optional
39 -- UNIT_HEADER_ID NUMBER Optional
40 -- UNIT_NAME VARCHAR2(80) Optional
41 -- PROJ_TEMPLATE_ID NUMBER Optional
42 -- PROJ_TEMPLATE_NAME VARCHAR2(30) Optional
43 -- PRIORITY_CODE VARCHAR2(30) Optional
44 -- PRIORITY_VALUE VARCHAR2(80) Optional
45 -- UNIT_SCHEDULE_ID NUMBER Mandatory for transit visits.
46 -- VISIT_CREATE_TYPE VARCHAR2(30) Can be null, PRODUCTION_UNRELEASED or PRODUCTION_RELEASED
47 -- ATTRIBUTE_CATEGORY VARCHAR2(240) Optional
48 -- ATTRIBUTE1..ATTRIBUTE15 are Optional
49 -- Most other input attributes are ignored
50 -- VISIT_ID has the return value: Id of the visit created.
51 --
52 -- End of Comments
53 -------------------------------------------------------------------------------------------
54 /*#
55 * Procedure for creating a new visit.
56 * @param p_api_version API Version Number.
57 * @param p_init_msg_list Initialize the message stack. Standard API parameter, default value FND_API.G_FALSE
58 * @param p_commit Parameter to decide whether to commit the transaction or not. Standard API parameter, default value FND_API.G_FALSE
59 * @param p_validation_level Validation level. Standard API parameter, default value FND_API.G_VALID_LEVEL_FULL
60 * @param x_return_status API Return status. Standard API parameter.
61 * @param x_msg_count API Return message count, if any. Standard API parameter.
62 * @param x_msg_data API Return message data, if any. Standard API parameter.
63 * @param p_x_visit_rec Record of type AHL_VWP_VISITS_PVT.Visit_Rec_Type.
64 * @rep:scope public
65 * @rep:lifecycle active
66 * @rep:displayname Create Visit
67 */
68 PROCEDURE Create_Visit (
69 p_api_version IN NUMBER,
70 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
71 p_commit IN VARCHAR2 := FND_API.G_FALSE,
72 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
73 p_x_visit_rec IN OUT NOCOPY AHL_VWP_VISITS_PVT.Visit_Rec_Type,
74 x_return_status OUT NOCOPY VARCHAR2,
75 x_msg_count OUT NOCOPY NUMBER,
76 x_msg_data OUT NOCOPY VARCHAR2
77 );
78
79 End AHL_VWP_VISITS_PUB;