[Home] [Help]
PACKAGE: APPS.OKS_COVERAGES_PUB
Source
1 PACKAGE OKS_COVERAGES_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKSPMCVS.pls 120.0 2005/05/25 18:27:00 appldev noship $*/
3 --------------------------------------------------------------------------
4 -- Global Variables
5 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_COVERAGES_PUB';
6 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
7 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
8 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
9 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
10 --------------------------------------------------------------------------
11 --Global Exception
12 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
13
14 subtype ac_rec_type IS oks_coverages_pvt.ac_rec_type;
15
16 PROCEDURE CREATE_ACTUAL_COVERAGE(
17 p_api_version IN NUMBER,
18 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
19 x_return_status OUT NOCOPY VARCHAR2,
20 x_msg_count OUT NOCOPY NUMBER,
21 x_msg_data OUT NOCOPY VARCHAR2,
22 P_ac_rec_in IN ac_rec_type,
23 p_restricted_update IN VARCHAR2 DEFAULT 'F',
24 x_Actual_coverage_id OUT NOCOPY NUMBER);
25
26 PROCEDURE Undo_Header(
27 p_api_version IN NUMBER,
28 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
29 x_return_status OUT NOCOPY VARCHAR2,
30 x_msg_count OUT NOCOPY NUMBER,
31 x_msg_data OUT NOCOPY VARCHAR2,
32 P_Header_id IN NUMBER);
33 PROCEDURE Undo_Line(
34 p_api_version IN NUMBER,
35 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
36 x_return_status OUT NOCOPY VARCHAR2,
37 x_msg_count OUT NOCOPY NUMBER,
38 x_msg_data OUT NOCOPY VARCHAR2,
39 P_Line_Id IN NUMBER);
40
41 PROCEDURE Update_cov_eff(
42 p_api_version IN NUMBER,
43 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
44 x_return_status OUT NOCOPY VARCHAR2,
45 x_msg_count OUT NOCOPY NUMBER,
46 x_msg_data OUT NOCOPY VARCHAR2,
47 P_service_Line_Id IN NUMBER,
48 p_new_start_date IN DATE,
49 p_new_end_date IN DATE);
50
51 PROCEDURE Instantiate_coverage(
52 p_api_version IN NUMBER,
53 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
54 x_return_status OUT NOCOPY VARCHAR2,
55 x_msg_count OUT NOCOPY NUMBER,
56 x_msg_data OUT NOCOPY VARCHAR2,
57 P_service_Line_Id IN NUMBER,
58 x_actual_coverage_id OUT NOCOPY NUMBER);
59
60 PROCEDURE Delete_coverage(
61 p_api_version IN NUMBER,
62 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
63 x_return_status OUT NOCOPY VARCHAR2,
64 x_msg_count OUT NOCOPY NUMBER,
65 x_msg_data OUT NOCOPY VARCHAR2,
66 P_service_Line_Id IN NUMBER);
67
68 Procedure CHECK_COVERAGE_MATCH
69 ( p_api_version IN NUMBER,
70 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
71 x_return_status OUT NOCOPY VARCHAR2,
72 x_msg_count OUT NOCOPY NUMBER,
73 x_msg_data OUT NOCOPY VARCHAR2,
74 P_Source_contract_Line_Id IN NUMBER,
75 P_Target_contract_Line_Id IN NUMBER,
76 x_coverage_match OUT NOCOPY VARCHAR2);
77
78 PROCEDURE CREATE_ADJUSTED_COVERAGE(
79 p_api_version IN NUMBER,
80 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
81 x_return_status OUT NOCOPY VARCHAR2,
82 x_msg_count OUT NOCOPY NUMBER,
83 x_msg_data OUT NOCOPY VARCHAR2,
84 P_Source_contract_Line_Id IN NUMBER,
85 P_Target_contract_Line_Id IN NUMBER,
86 x_Actual_coverage_id OUT NOCOPY NUMBER);
87
88 PROCEDURE OKS_BILLRATE_MAPPING(
89 p_api_version IN NUMBER ,
90 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
91 p_business_process_id IN NUMBER,
92 p_time_labor_tbl_in IN OKS_COVERAGES_PVT.time_labor_tbl,
93 x_return_status OUT NOCOPY VARCHAR2,
94 x_msg_count OUT NOCOPY NUMBER,
95 x_msg_data OUT NOCOPY VARCHAR2);
96
97
98
99 PROCEDURE Version_Coverage(
100 p_api_version IN NUMBER,
101 p_init_msg_list IN VARCHAR2,
102 x_return_status OUT NOCOPY VARCHAR2,
103 x_msg_count OUT NOCOPY NUMBER,
104 x_msg_data OUT NOCOPY VARCHAR2,
105 p_chr_id IN NUMBER,
106 p_major_version IN NUMBER);
107
108
109 PROCEDURE Restore_Coverage(
110 p_api_version IN NUMBER,
111 p_init_msg_list IN VARCHAR2,
112 x_return_status OUT NOCOPY VARCHAR2,
113 x_msg_count OUT NOCOPY NUMBER,
114 x_msg_data OUT NOCOPY VARCHAR2,
115 p_chr_id IN NUMBER);
116
117
118 PROCEDURE Delete_History(
119 p_api_version IN NUMBER,
120 p_init_msg_list IN VARCHAR2,
121 x_return_status OUT NOCOPY VARCHAR2,
122 x_msg_count OUT NOCOPY NUMBER,
123 x_msg_data OUT NOCOPY VARCHAR2,
124 p_chr_id IN NUMBER);
125
126 PROCEDURE Delete_Saved_Version(
127 p_api_version IN NUMBER,
128 p_init_msg_list IN VARCHAR2,
129 x_return_status OUT NOCOPY VARCHAR2,
130 x_msg_count OUT NOCOPY NUMBER,
131 x_msg_data OUT NOCOPY VARCHAR2,
132 p_chr_id IN NUMBER);
133
134
135
136 END OKS_COVERAGES_PUB;