1 PACKAGE AHL_AVF_PRIM_VSTS_PVT AUTHID CURRENT_USER AS
2 /* $Header: AHLVPRVS.pls 120.0.12020000.3 2013/03/19 09:29:46 satrajen noship $ */
3
4
5 --------------------------------------------------------------------
6 -- START: Defining local functions and procedures --
7 --------------------------------------------------------------------
8
9
10 -------------------------------------------------------------------------------------------------------------------------------
11 -- PROCEDURE
12 -- Add_Planned_MRs
13 -- TYPE
14 -- Public
15 -- PURPOSE
16 -- To Add Planned maintainence requirements to the visits.
17 -- PARAMETERS
18 -- p_visit_id Input Number Optional(Any One Required)
19 -- p_snapshot_id Input Number Optional(Any One Required)
20 -------------------------------------------------------------------------------------------------------------------------------
21
22 PROCEDURE Add_Planned_MRs
23 (p_api_version IN NUMBER := 1.0,
24 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
25 p_commit IN VARCHAR2 := FND_API.G_FALSE,
26 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
27 p_visit_id IN NUMBER := NULL,
28 p_snapshot_id IN NUMBER := NULL,
29 x_return_status OUT NOCOPY VARCHAR2,
30 x_msg_count OUT NOCOPY NUMBER,
31 x_msg_data OUT NOCOPY VARCHAR2);
32
33
34 -----------------------------------------------------------------------------------------------
35 -- PROCEDURE
36 -- Cancel_Visits
37 -- TYPE
38 -- Public
39 -- PURPOSE
40 -- To Cancel the existing visits according to the Master configuration provided and the date ranges provided by the user.
41 -- PARAMETERS
42 -- p_snapshot_id Input Number Required
43 -----------------------------------------------------------------------------------------------
44
45 PROCEDURE Cancel_Visits
46 (p_api_version IN NUMBER := 1.0,
47 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
48 p_commit IN VARCHAR2 := FND_API.G_FALSE,
49 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
50 p_snapshot_id IN NUMBER,
51 x_return_status OUT NOCOPY VARCHAR2,
52 x_msg_count OUT NOCOPY NUMBER,
53 x_msg_data OUT NOCOPY VARCHAR2);
54
55
56 -------------------------------------------------------------------
57 -- Procedure name : Create_Primary_Visits
58 -- Type : Private
59 -- Function : Procedure to create primary visits based on auto visit hierarchy and on primary UEs
60 -- Parameters :
61 --
62 -- Standard IN Parameters :
63 -- p_api_version IN NUMBER Required
64 -- p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE
65 -- p_validation_level IN NUMBER Default FND_API.G_VALID_LEVEL_FULL
66 --
67 -- Standard OUT Parameters :
68 -- x_return_status OUT VARCHAR2 Required
69 -- x_msg_count OUT NUMBER Required
70 -- x_msg_data OUT VARCHAR2 Required
71 --
72 -- Create_Primary_Visits Parameters:
73 -- p_snapshot_id IN NUMBER Required
74 --------------------------------------------------------------------------------------------------------------------
75 PROCEDURE Create_Primary_Visits (
76 p_api_version IN NUMBER := 1.0,
77 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
78 p_commit IN VARCHAR2 := FND_API.G_FALSE,
79 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
80 p_snapshot_id IN NUMBER,
81 -- Front Porting to AHL122
82 -- SATRAJEN :: Bug 16048246 :: Added for calling add_planned_mrs from create_primary_visits Procedure :: 28-12-2012
83 p_add_plan_flag IN VARCHAR2 := 'N',
84 x_return_status OUT NOCOPY VARCHAR2,
85 x_msg_count OUT NOCOPY NUMBER,
86 x_msg_data OUT NOCOPY VARCHAR2);
87
88
89
90 --------------------------------------------------------------------
91 -- PROCEDURE
92 -- Process_Primary_visits
93 --
94 -- PURPOSE
95 -- Made as an executable for the P2P CP
96 -- Process_Primary_visits Parameters :
97 -- p_snapshot_id IN NUMBER
98 -- errbuf OUT VARCHAR2 Required
99 -- Defines in pl/sql to store procedure to get error messages into log file
100 -- retcode OUT NUMBER Required
101 -- To get the status of the concurrent program
102
103 --------------------------------------------------------------------
104 PROCEDURE Process_Primary_visits(
105 errbuf OUT NOCOPY VARCHAR2,
106 retcode OUT NOCOPY NUMBER,
107 p_api_version IN NUMBER,
108 p_snapshot_id IN NUMBER
109 );
110
111
112 ---------------------------------------------------------------------------------------------------------------------------
113
114 END AHL_AVF_PRIM_VSTS_PVT;