[Home] [Help]
PACKAGE: APPS.AHL_VISIT_TYPE_PVT
Source
1 PACKAGE AHL_VISIT_TYPE_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVVTPS.pls 120.0.12020000.2 2012/12/11 05:40:18 prakkum noship $ */
3
4 -------------------------------------------------------------------
5 -- Procedure name : Delete_Visit_Type
6 -- Function : To delete a visit type
7 -- Parameters : p_visit_type_id
8 ----------------------------------------------------------------------
9 PROCEDURE Delete_Visit_Type (
10 p_api_version IN NUMBER,
11 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
12 p_commit IN VARCHAR2 := Fnd_Api.g_false,
13 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
14 p_module_type IN VARCHAR2 := NULL,
15 p_visit_type_id IN NUMBER,
16 x_return_status OUT NOCOPY VARCHAR2,
17 x_msg_count OUT NOCOPY NUMBER,
18 x_msg_data OUT NOCOPY VARCHAR2
19 );
20
21
22 -------------------------------------------------------------------
23 -- Procedure name : Complete_Visit_Type
24 -- Function : To complete a visit type
25 -- Parameters : p_visit_type_id
26 -- Parameters : p_obj_version_num
27 --------------------------------------------------------------------
28 PROCEDURE Complete_Visit_Type (
29 p_api_version IN NUMBER,
30 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
31 p_commit IN VARCHAR2 := Fnd_Api.g_false,
32 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
33 p_module_type IN VARCHAR2 := NULL,
34 p_visit_type_id IN NUMBER,
35 p_obj_version_num IN NUMBER,
36 x_return_status OUT NOCOPY VARCHAR2,
37 x_msg_count OUT NOCOPY NUMBER,
38 x_msg_data OUT NOCOPY VARCHAR2
39 );
40
41 -------------------------------------------------------------------
42 -- Procedure name : Create_Rev_Visit_Type
43 -- Function : To Create a revision of the complete visit type
44 -- Parameters : p_par_visit_type_id
45 -- Parameters : p_visit_type_id
46 ----------------------------------------------------------------------
47 PROCEDURE Create_Rev_Visit_Type (
48 p_api_version IN NUMBER,
49 p_init_msg_list IN VARCHAR2 := Fnd_Api.g_false,
50 p_commit IN VARCHAR2 := Fnd_Api.g_false,
51 p_validation_level IN NUMBER := Fnd_Api.g_valid_level_full,
52 p_module_type IN VARCHAR2 := NULL,
53 p_visit_type_id IN NUMBER,
54 p_par_visit_type_id IN NUMBER,
55 x_return_status OUT NOCOPY VARCHAR2,
56 x_msg_count OUT NOCOPY NUMBER,
57 x_msg_data OUT NOCOPY VARCHAR2
58 );
59
60 -------------------------------------------------------------------
61 -- Procedure name : Get_Last_Update_Type
62 -- Function : To get the last update date for a Visit Type among header, stages, stage types & stage rules
63 -- Parameters : p_visit_type_id
64 ----------------------------------------------------------------------
65 FUNCTION Get_Last_Update_Date (
66 p_visit_type_id IN NUMBER
67 ) RETURN DATE;
68
69 END AHL_VISIT_TYPE_PVT;