PACKAGE: APPS.OKS_INSERT_ROW_UPG

Source

1 PACKAGE  OKS_Insert_Row_Upg  AUTHID CURRENT_USER AS
2 /* $Header: OKSCOVUS.pls 120.0 2005/05/25 18:38:07 appldev noship $ */
3 
4 
5         G_APP_NAME              CONSTANT VARCHAR2(3)   :=  OKC_API.G_APP_NAME;
6         G_UNEXPECTED_ERROR CONSTANT	VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
7         G_SQLERRM_TOKEN	 CONSTANT	VARCHAR2(200) := 'ERROR_MESSAGE';
8         G_SQLCODE_TOKEN	 CONSTANT	VARCHAR2(200) := 'ERROR_CODE';
9 
10 
11 
12     PROCEDURE INSERT_ROW_UPG_KLNV_TBL
13                         (x_return_status OUT NOCOPY VARCHAR2,
14                          P_KLNV_TBL  OKS_KLN_PVT.klnv_tbl_type) ;
15 
16     PROCEDURE INSERT_ROW_UPG_CTZV_TBL
17 						(x_return_status OUT NOCOPY VARCHAR2,
18 						 P_CTZV_TBL  OKS_CTZ_PVT.OksCoverageTimezonesVTblType);
19     PROCEDURE INSERT_ROW_UPG_CVTV_TBL
20 						(x_return_status OUT NOCOPY VARCHAR2,
21 						 P_CVTV_TBL  OKS_CVT_PVT.oks_coverage_times_v_tbl_type);
22     PROCEDURE INSERT_ROW_UPG_ACMV_TBL
23 						(x_return_status OUT NOCOPY VARCHAR2,
24 						 P_ACMV_TBL  OKS_ACM_PVT.oks_action_times_v_tbl_type);
25     PROCEDURE INSERT_ROW_UPG_ACTV_TBL
26 						(x_return_status OUT NOCOPY VARCHAR2,
27 						 P_ACTV_TBL  OKS_ACT_PVT.OksActionTimeTypesVTblType);
28 
29     PROCEDURE INSERT_ROW_UPG_KHRV_TBL
30                         (x_return_status OUT NOCOPY VARCHAR2,
31                          P_KHRV_TBL  OKS_KHR_PVT.khrv_tbl_type) ;
32 
33     PROCEDURE INSERT_ROW_UPG_sllv_tbl (x_return_status OUT NOCOPY VARCHAR2,
34                          p_sllv_tbl  OKS_SLL_PVT.sllv_tbl_type);
35 
36     PROCEDURE INSERT_ROW_UPG_letv_tbl (x_return_status OUT NOCOPY VARCHAR2,
37                          p_letv_tbl  OKS_BILL_LEVEL_ELEMENTS_PVT.letv_tbl_type);
38 
39 
40     PROCEDURE INSERT_ROW_UPG_bill_sch
41 	(x_return_status OUT NOCOPY VARCHAR2,
42 	p_oks_billrate_schedules_v_tbl  OKS_BRS_PVT.OksBillrateSchedulesVTblType) ;
43 
44   -----------------------------------------------------------------------------
45   -- Added by AVReddy for Subscription bulk insert - on Dec 02 03
46   -----------------------------------------------------------------------------
47 
48     PROCEDURE INSERT_BY_TBL_SUBHDR(
49                  x_return_status OUT NOCOPY VARCHAR2
50                 ,P_SUBHDR_TBL  OKS_SUBSCR_HDR_PVT.schv_tbl_type) ;
51 
52 
53     PROCEDURE INSERT_BY_TBL_SUBPTNS(
54                x_return_status OUT NOCOPY VARCHAR2
55               ,P_SUBPTN_TBL  OKS_SUBSCR_PTRNS_PVT.scpv_tbl_type);
56 
57 
58     PROCEDURE INSERT_BY_TBL_SUBELMNTS(
59                x_return_status OUT NOCOPY VARCHAR2
60               ,P_SUBELMNTS_TBL  OKS_SUBSCR_ELEMS_PVT.scev_tbl_type);
61 
62 END OKS_Insert_Row_Upg;
63