[Home] [Help]
PACKAGE: APPS.OKS_CON_COVERAGE_PVT
Source
1 PACKAGE OKS_CON_COVERAGE_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKSRACCS.pls 120.1 2005/07/05 12:13:56 jvarghes noship $ */
3
4 -- GLOBAL_MESSAGE_CONSTANTS
5 -- GLOBAL_MESSAGE_CONSTANTS
6 ---------------------------------------------------------------------------------------------
7 G_TRUE CONSTANT VARCHAR2(200) := OKC_API.G_TRUE;
8 G_FALSE CONSTANT VARCHAR2(200) := OKC_API.G_FALSE;
9 G_RET_STS_SUCCESS CONSTANT VARCHAR2(200) := OKC_API.G_RET_STS_SUCCESS;
10 G_RET_STS_ERROR CONSTANT VARCHAR2(200) := OKC_API.G_RET_STS_ERROR;
11 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(200) := OKC_API.G_RET_STS_UNEXP_ERROR;
12 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
13 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
14 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
15 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
16 G_NO_PARENT_RECORD CONSTANT VARCHAR2(200) := 'OKS_NO_PARENT_RECORD';
17 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
18 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
19 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
20 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
21 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UPPERCASE_REQUIRED';
22 ---------------------------------------------------------------------------------------------
23
24 -- GLOBAL EXCEPTION
25 ---------------------------------------
26 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
27 ---------------------------------------
28
29 -- GLOBAL VARIABLES
30 -------------------------------------------------------------------------------
31 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_CON_COVERAGE_PVT';
32 G_APP_NAME CONSTANT VARCHAR2(3) := 'OKC';
33 -------------------------------------------------------------------------------
34
35 G_GRACE_PROFILE_SET CONSTANT VARCHAR2(1) := fnd_profile.value('OKS_ENABLE_GRACE_PERIOD'); --'Y'; --'N';
36
37
38
39 SUBTYPE Gx_Boolean IS VARCHAR2(1);
40 SUBTYPE Gx_YesNo IS VARCHAR2(1);
41 SUBTYPE Gx_Ret_Sts IS VARCHAR2(1);
42 SUBTYPE Gx_ExceptionMsg IS VARCHAR2(200);
43
44 SUBTYPE ser_tbl_type IS OKS_CON_COVERAGE_PUB.ser_tbl_type;
45 SUBTYPE cov_tbl_type IS OKS_CON_COVERAGE_PUB.cov_tbl_type;
46 SUBTYPE pricing_tbl_type IS OKS_CON_COVERAGE_PUB.pricing_tbl_type;
47 SUBTYPE input_br_rec IS OKS_CON_COVERAGE_PUB.input_br_rec;
48 SUBTYPE labor_sch_tbl_type IS OKS_CON_COVERAGE_PUB.labor_sch_tbl_type;
49 SUBTYPE bill_rate_tbl_type IS OKS_CON_COVERAGE_PUB.bill_rate_tbl_type;
50
51 TYPE g_work_rec IS RECORD(
52 seq_no Number,
53 charges_line_number Number,
54 estimate_detail_id Number,
55 contract_line_id Number,
56 txn_group_id Number,
57 billing_type_id Number,
58 charge_amount Number,
59 discounted_amount Number,
60 status Varchar2(1),
61 warranty_flag Varchar2(1),
62 business_process_id number, --11.5.9 changes
63 request_date date, --11.5.9 changes
64 allow_full_discount Varchar2(1)
65 );
66
67 TYPE g_work_tbl IS TABLE of g_work_rec INDEX BY BINARY_INTEGER;
68
69 TYPE g_out_rec IS RECORD(
70 txngrp_id Number,
71 btype_id Number,
72 upto_amt Number,
73 per_cvd Number,
74 status Varchar2(1));
75 TYPE g_out_tbl IS TABLE OF g_out_rec INDEX BY BINARY_INTEGER;
76
77
78 PROCEDURE apply_contract_coverage
79 (p_api_version IN Number
80 ,p_init_msg_list IN Varchar2
81 ,p_est_amt_tbl IN ser_tbl_type
82 ,x_return_status OUT NOCOPY Varchar2
83 ,x_msg_count OUT NOCOPY Number
84 ,x_msg_data OUT NOCOPY Varchar2
85 ,x_est_discounted_amt_tbl OUT NOCOPY cov_tbl_type);
86
87 PROCEDURE get_bp_pricelist
88 (p_api_version IN Number
89 ,p_init_msg_list IN Varchar2
90 ,p_Contract_line_id IN NUMBER
91 ,p_business_process_id IN NUMBER
92 ,p_request_date IN DATE
93 ,x_return_status OUT NOCOPY Varchar2
94 ,x_msg_count OUT NOCOPY Number
95 ,x_msg_data OUT NOCOPY Varchar2
96 ,x_pricing_tbl OUT NOCOPY PRICING_TBL_TYPE );
97
98 PROCEDURE get_bill_rates
99 (p_api_version IN Number
100 ,p_init_msg_list IN Varchar2
101 ,P_input_br_rec IN INPUT_BR_REC
102 ,P_labor_sch_tbl IN LABOR_SCH_TBL_TYPE
103 ,x_return_status OUT NOCOPY Varchar2
104 ,x_msg_count OUT NOCOPY Number
105 ,x_msg_data OUT NOCOPY Varchar2
106 ,X_bill_rate_tbl OUT NOCOPY BILL_RATE_TBL_TYPE );
107
108 FUNCTION get_next_wkday
109 (p_today IN Varchar2) RETURN Varchar2;
110
111 --Bug# 4194507 (JVARGHES)
112
113 PROCEDURE Remove_Zero_Duration_Billrates
114 (p_Input_Tab IN BILL_RATE_TBL_TYPE
115 ,x_Output_Tab OUT NOCOPY BILL_RATE_TBL_TYPE
116 ,x_Return_Status OUT NOCOPY Gx_Ret_Sts);
117
118 --
119
120 PROCEDURE Sort_Billrates_datetime
121 (P_Input_Tab IN BILL_RATE_TBL_TYPE
122 ,X_Output_Tab out nocopy BILL_RATE_TBL_TYPE
123 ,X_Result out nocopy Gx_Boolean
124 ,X_Return_Status out nocopy Gx_Ret_Sts);
125
126 FUNCTION Get_Final_End_Date(
127 P_Contract_Id IN number,
128 P_Enddate IN DATE) Return Date;
129
130 --
131 -- Added for 12.0 Coverage Rearch project (JVARGHES)
132 --
133
134 FUNCTION Get_BP_Line_Start_Offset
135 (P_BPL_Id IN NUMBER
136 ,P_SVL_Start IN DATE
137 ,P_BPL_Start IN DATE
138 ,p_Std_Cov_YN IN VARCHAR2) RETURN DATE;
139
140 --
141 -- Added for 12.0 Coverage Rearch project (JVARGHES)
142 --
143
144 FUNCTION Get_grace_end_Date
145 (P_dnz_chr_Id IN NUMBER
146 ,P_SVL_end IN DATE
147 ,P_BPL_end IN DATE
148 ,p_Std_Cov_YN IN VARCHAR2) RETURN DATE;
149
150 --
151 --
152
153 END OKS_CON_COVERAGE_PVT;