1 PACKAGE CSF_Preventive_Maintenance_PVT AUTHID CURRENT_USER as
2 /* $Header: csfvpmts.pls 120.0 2005/05/24 17:36:22 appldev noship $ */
3 -- Start of Comments
4 -- Package name : CSF_Preventive_Maintenance_PVT
5 -- Purpose : Preventive Maintenance concurrent program API
6 -- History : Initial Version for release 11.5.9
7 -- NOTE :
8 -- End of Comments
9 -- *******************************************************
10 -- Start of Comments
11 -- *******************************************************
12 -- Generate_SR_tasks procedure queries ahl_unit_effectivities_b,
13 -- csi_item_instances tables and generates Service Request for each UMP
14 -- record and task for each record in ahl_routes_b corresponding to UMP.
15 -- API Name: Generate_SR_Tasks
16 -- Type : Private
17 -- Pre-Req :
18 -- Parameters:
19 -- IN
20 -- p_api_version_number IN NUMBER Required
21 -- p_period_size IN NUMBER Required
22 -- OUT:
23 -- retcode OUT NOCOPY NUMBER
24 -- errbuf OUT NOCOPY VARCHAR2
25 -- Version : Current version 1.0
26 --
27 -- End of Comments
28 --
29 PROCEDURE Generate_SR_Tasks (
30 errbuf OUT NOCOPY VARCHAR2,
31 retcode OUT NOCOPY NUMBER,
32 P_Api_Version_Number IN NUMBER,
33 p_period_size IN NUMBER
34 );
35
36 -- *******************************************************
37 -- Start of Comments
38 -- *******************************************************
39 -- Update_Ump procedure would update UMP to ACCOMPLISHED status with
40 -- counter values when the Service request generated
41 -- for this UMP is Closed . This procedure is available as a concurrent
42 -- program and it is recommended that this concurrent program run before
43 -- the new UMP generation.
44 -- API Name: Update_Ump
45 -- Type : Private
46 -- Pre-Req :
47 -- Parameters:
48 -- IN
49 -- P_Api_Version_Number IN NUMBER Required
50 -- OUT :
51 -- retcode OUT NOCOPY NUMBER
52 -- errbuf OUT NOCOPY VARCHAR2
53 -- Version : Current version 1.0
54 --
55 -- End of Comments
56 --
57 PROCEDURE update_ump (
58 errbuf OUT NOCOPY VARCHAR2,
59 retcode OUT NOCOPY NUMBER,
60 P_Api_Version_Number IN NUMBER);
61
62 -- *******************************************************
63 -- Start of Comments
64 -- *******************************************************
65 -- Update_Sr_Tasks procedure would cancel the SR and associated tasks
66 -- when the UMP for which the SR is generated is cancelled.
67 -- This procedure would run as a concurrent program and it is recommended
68 -- to run the concurrent program after the UMP generation.
69 -- API Name: update_sr_tasks
70 -- Type : Private
71 -- Pre-Req :
72 -- Parameters:
73 -- IN :
74 -- P_Api_Version_Number IN NUMBER Required
75 -- OUT :
76 -- retcode OUT NOCOPY NUMBER
77 -- errbuf OUT NOCOPY VARCHAR2
78 -- Version : Current version 1.0
79 --
80 -- End of Comments
81 --
82 PROCEDURE update_sr_tasks (
83 errbuf OUT NOCOPY VARCHAR2,
84 retcode OUT NOCOPY NUMBER,
85 P_Api_Version_Number IN NUMBER);
86
87 END CSF_PREVENTIVE_MAINTENANCE_PVT;