[Home] [Help]
PACKAGE: APPS.OKS_COVERAGES_MIGRATION
Source
1 PACKAGE OKS_COVERAGES_MIGRATION AUTHID CURRENT_USER AS
2 /* $Header: OKSIMCVS.pls 115.2 2003/02/04 23:53:18 hmedheka noship $ */
3
4
5 l_clev_tbl_in okc_cle_pvt.clev_tbl_type;
6 x_clev_tbl_in okc_cle_pvt.clev_tbl_type;
7
8 l_cimv_tbl_in okc_cim_pvt.cimv_tbl_type;
9 x_cimv_tbl_in okc_cim_pvt.cimv_tbl_type;
10
11 l_rgpv_tbl_in okc_rgp_pvt.rgpv_tbl_type;
12 x_rgpv_tbl_in okc_rgp_pvt.rgpv_tbl_type;
13
14 l_isev_ext_tbl_in okc_time_pvt.isev_ext_tbl_type;
15 x_isev_ext_tbl_in okc_time_pvt.isev_ext_tbl_type;
16
17 l_isev_rel_tbl_in okc_time_pvt.isev_rel_tbl_type;
18 x_isev_rel_tbl_in okc_time_pvt.isev_rel_tbl_type;
19
20 l_rulv_tbl_in okc_rul_pvt.rulv_tbl_type;
21 x_rulv_tbl_in okc_rul_pvt.rulv_tbl_type;
22
23 l_igsv_ext_tbl_in okc_time_pvt.igsv_ext_tbl_type;
24 x_igsv_ext_tbl_in okc_time_pvt.igsv_ext_tbl_type;
25
26 l_ctiv_tbl_in okc_cti_pvt.ctiv_tbl_type;
27 x_ctiv_tbl_in okc_cti_pvt.ctiv_tbl_type;
28
29 l_cplv_tbl_in okc_cpl_pvt.cplv_tbl_type;
30 x_cplv_tbl_in okc_cpl_pvt.cplv_tbl_type;
31
32 l_ctcv_tbl_in okc_ctc_pvt.ctcv_tbl_type;
33 x_ctcv_tbl_in okc_ctc_pvt.ctcv_tbl_type;
34
35 l_tgdv_ext_tbl_in okc_time_pvt.tgdv_ext_tbl_Type;
36 x_tgdv_ext_tbl_in okc_time_pvt.tgdv_ext_tbl_Type;
37
38 l_tgdv_rcn_tbl_in okc_time_pvt.tgdv_ext_tbl_Type;
39 x_tgdv_rcn_tbl_in okc_time_pvt.tgdv_ext_tbl_Type;
40
41 l_rilv_tbl_in okc_ril_pvt.rilv_tbl_type;
42 x_rilv_tbl_in okc_ril_pvt.rilv_tbl_type;
43
44 l_rilt_tbl_in okc_ril_pvt.rilv_tbl_type;
45 x_rilt_tbl_in okc_ril_pvt.rilv_tbl_type;
46
47 g_timezone_id NUMBER := nvl(FND_PROFILE.VALUE('CS_UPG_CONTRACTS_TIMEZONE'),47);
48
49 g_CREATION_DATE date := sysdate;
50 g_CREATED_BY number := -1;
51 g_LAST_UPDATE_DATE date := sysdate;
52 g_LAST_UPDATED_BY number := -1;
53 g_LAST_UPDATE_LOGIN number := -1;
54
55 l_api_version Number := 1;
56 l_init_msg_list varchar2(200);
57 L_MSG_INDEX_OUT number;
58 l_msg_count number;
59 l_msg_data varchar2(2000);
60
61 PROCEDURE COVERAGE_MIGRATE (P_FromId IN NUMBER,
62 P_ToId IN NUMBER,
63 P_VALIDATE_FLAG IN VARCHAR2,
64 P_LOG_PARAMETER IN VARCHAR2);
65
66
67 PROCEDURE BUSINESS_PROCESSES_MIGRATE( P_FromId IN NUMBER,
68 P_ToId IN NUMBER,
69 P_VALIDATE_FLAG IN VARCHAR2,
70 P_LOG_PARAMETER IN VARCHAR2);
71
72
73
74 PROCEDURE BILL_TYPES_MIGRATE( P_FromId IN NUMBER,
75 P_ToId IN NUMBER,
76 P_VALIDATE_FLAG IN VARCHAR2,
77 P_LOG_PARAMETER IN VARCHAR2);
78
79
80 PROCEDURE BILL_RATES_MIGRATE( P_FromId IN NUMBER,
81 P_ToId IN NUMBER,
82 P_VALIDATE_FLAG IN VARCHAR2,
83 P_LOG_PARAMETER IN VARCHAR2);
84
85 PROCEDURE PRINT_REPORT ( P_FromId IN NUMBER,
86 P_ToId IN NUMBER);
87
88 TYPE Num_Tbl_Type IS VARRAY(1000) OF NUMBER ;
89 TYPE Date_Tbl_Type IS VARRAY(1000) OF DATE ;
90 TYPE Vc150_Tbl_Type IS VARRAY(1000) OF VARCHAR2(150);
91 TYPE Vc15_Tbl_Type IS VARRAY(1000) OF VARCHAR2(15);
92 TYPE Vc1_Tbl_Type IS VARRAY(1000) OF VARCHAR2(1);
93 TYPE Vc30_Tbl_Type IS VARRAY(1000) OF VARCHAR2(30);
94 g_line_ref VARCHAR2(30) := 'OKS_CON_LINES_INT_ALL'; --'Int_Contract_Line';
95 g_covline_ref VARCHAR2(30) := 'OKS_COVERAGES_INT_ALL';
96 g_bpline_ref VARCHAR2(30) := 'OKS_COV_TXN_GROUPS_INT_ALL';
97 g_btline_ref VARCHAR2(30) := 'OKS_COV_BILL_TYPES_INT_ALL';
98 rulv_ctr NUMBER := 0;
99 time_ctr NUMBER := 0;
100
101
102 END OKS_COVERAGES_MIGRATION;