[Home] [Help]
PACKAGE: APPS.OKS_BILLING_PUB
Source
1 Package OKS_BILLING_PUB as
2 /* $Header: OKSPBILS.pls 120.1.12000000.1 2007/01/16 22:05:25 appldev ship $ */
3
4 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
5 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
6 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
7 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
8 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
9 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
10 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
11 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
12 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UPPERCASE_REQUIRED';
13
14
15 ------------------------------------------------------------------------------------
16
17 -- GLOBAL EXCEPTION
18
19 ---------------------------------------------------------------------------
20
21 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
22 G_EXCEPTION_ROLLBACK EXCEPTION;
23
24 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKS_BILLING_PUB';
25 G_APP_NAME CONSTANT VARCHAR2(3) := 'OKS';
26 G_NUM_DAYS_WEEK CONSTANT NUMBER := 7;
27 G_QUATERLY CONSTANT NUMBER := 3;
28 G_HALFYEARLY CONSTANT NUMBER := 6;
29 G_YEARLY CONSTANT NUMBER := 12;
30 G_SERVICE_LINE_STYLE CONSTANT NUMBER := 1;
31 G_COVERAGE_LEVEL_STYLE CONSTANT NUMBER := 2;
32 G_USAGE_LINE_STYLE CONSTANT NUMBER := 3;
33 G_INSTALLED_ITEM_STYLE CONSTANT NUMBER := 4;
34 G_REGULAR CONSTANT NUMBER := 1;
35 G_NONREGULAR CONSTANT NUMBER := 2;
36 G_STAT_REG_INV_TO_AR CONSTANT NUMBER := 1;
37 G_STAT_TER_CR_INV_TO_AR CONSTANT NUMBER :=2;
38 G_BILLACTION_TR CONSTANT VARCHAR2(9) := 'TR';
39 G_BILLACTION_RI CONSTANT VARCHAR2(9) := 'RI';
40
41 l_write_log BOOLEAN;
42 l_write_report BOOLEAN;
43 l_yes_no VARCHAR2(10);
44
45 Type l_calc_rec_type is Record
46 (
47 l_calc_sdate Date,
48 l_calc_edate Date,
49 l_bill_stdt date,
50 l_bill_eddt Date,
51 l_bcl_id Number,
52 l_bcl_amount Number,
53 l_stat Varchar2(3)
54 );
55
56 l_calc_rec l_calc_rec_type;
57
58
59 l_cov_tbl OKS_BILL_REC_PUB.COVERED_TBL;
60 l_line_rec OKS_QP_PKG.INPUT_DETAILS ;
61 l_price_rec OKS_QP_PKG.PRICE_DETAILS ;
62 l_modifier_details QP_PREQ_GRP.LINE_DETAIL_TBL_TYPE;
63 l_price_break_details OKS_QP_PKG.G_PRICE_BREAK_TBL_TYPE;
64
65 --l_line_tbl OKS_QP_INT_PVT.G_SLINE_TBL_TYPE ;
66
67
68
69
70 PROCEDURE Billing_Main
71 (
72 ERRBUF OUT NOCOPY VARCHAR2,
73 RETCODE OUT NOCOPY NUMBER,
74 p_contract_hdr_id IN NUMBER,
75 --P_cont_modifier IN VARCHAR2,
76 -- nechatur 29-Nov-2005 bug#4459229 Changing the type of P-default_date to VARCHAR2
77 -- P_default_date IN DATE,
78 P_default_date IN VARCHAR2,
79 -- end bug#4459229
80 p_org_id IN NUMBER,
81 P_Customer_id IN NUMBER,
82 P_category IN VARCHAR2,
83 P_Grp_Id IN NUMBER,
84 P_Process IN VARCHAR2
85 );
86
87 Procedure Calculate_bill
88 (
89 ERRBUF OUT NOCOPY VARCHAR2
90 ,RETCODE OUT NOCOPY NUMBER
91 ,P_calledfrom IN NUMBER
92 ,P_flag IN NUMBER
93 ,P_date IN DATE
94 ,p_process_from IN NUMBER
95 ,p_process_to IN NUMBER
96 ,P_Prv IN NUMBER
97 );
98
99
100
101 Procedure Process_Suppress_Credits
102 (
103 ERRBUF OUT NOCOPY VARCHAR2,
104 RETCODE OUT NOCOPY NUMBER,
105 P_CONTRACT_HDR_ID IN NUMBER,
106 P_ORG_ID IN NUMBER,
107 P_CATEGORY IN VARCHAR2
108 );
109
110
111
112 end OKS_BILLING_PUB;
113
114