[Home] [Help]
PACKAGE: APPS.OKL_GTS_PVT
Source
1 PACKAGE OKL_GTS_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLSGTSS.pls 120.4 2007/10/15 16:46:11 dpsingh noship $ */
3 ---------------------------------------------------------------------------
4 -- GLOBAL DATASTRUCTURES
5 ---------------------------------------------------------------------------
6 TYPE gts_rec_type IS RECORD (
7 id OKL_ST_GEN_TMPT_SETS.ID%TYPE DEFAULT Okl_Api.G_MISS_NUM
8 ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM
9 ,name OKL_ST_GEN_TMPT_SETS.NAME%TYPE DEFAULT Okl_Api.G_MISS_CHAR
10 ,description OKL_ST_GEN_TMPT_SETS.DESCRIPTION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
11 ,product_type OKL_ST_GEN_TMPT_SETS.PRODUCT_TYPE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
12 ,tax_owner OKL_ST_GEN_TMPT_SETS.TAX_OWNER%TYPE DEFAULT Okl_Api.G_MISS_CHAR
13 ,deal_type OKL_ST_GEN_TMPT_SETS.DEAL_TYPE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
14 ,pricing_engine OKL_ST_GEN_TMPT_SETS.PRICING_ENGINE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
15 ,org_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
16 ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
17 ,creation_date OKL_ST_GEN_TMPT_SETS.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
18 ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
19 ,last_update_date OKL_ST_GEN_TMPT_SETS.LAST_UPDATE_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
20 ,last_update_login NUMBER DEFAULT Okl_Api.G_MISS_NUM
21 ,interest_calc_meth_code OKL_ST_GEN_TMPT_SETS.INTEREST_CALC_METH_CODE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
22 ,revenue_recog_meth_code OKL_ST_GEN_TMPT_SETS.REVENUE_RECOG_METH_CODE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
23 ,days_in_month_code OKL_ST_GEN_TMPT_SETS.DAYS_IN_MONTH_CODE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
24 ,days_in_yr_code OKL_ST_GEN_TMPT_SETS.DAYS_IN_YR_CODE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
25 ,isg_arrears_pay_dates_option OKL_ST_GEN_TMPT_SETS.ISG_ARREARS_PAY_DATES_OPTION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
26 );
27 G_MISS_GTS_REC gts_rec_type;
28 TYPE gts_tbl_type IS TABLE OF gts_rec_type
29 INDEX BY BINARY_INTEGER;
30
31 TYPE gtsv_rec_type IS RECORD(
32 id OKL_ST_GEN_TMPT_SETS.ID%TYPE DEFAULT Okl_Api.G_MISS_NUM
33 ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM
34 ,name OKL_ST_GEN_TMPT_SETS.NAME%TYPE DEFAULT Okl_Api.G_MISS_CHAR
35 ,description OKL_ST_GEN_TMPT_SETS.DESCRIPTION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
36 ,product_type OKL_ST_GEN_TMPT_SETS.PRODUCT_TYPE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
37 ,tax_owner OKL_ST_GEN_TMPT_SETS.TAX_OWNER%TYPE DEFAULT Okl_Api.G_MISS_CHAR
38 ,deal_type OKL_ST_GEN_TMPT_SETS.DEAL_TYPE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
39 ,pricing_engine OKL_ST_GEN_TMPT_SETS.PRICING_ENGINE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
40 ,org_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
41 ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
42 ,creation_date OKL_ST_GEN_TMPT_SETS.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
43 ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
44 ,last_update_date OKL_ST_GEN_TMPT_SETS.LAST_UPDATE_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
45 ,last_update_login NUMBER DEFAULT Okl_Api.G_MISS_NUM
46 ,interest_calc_meth_code OKL_ST_GEN_TMPT_SETS.INTEREST_CALC_METH_CODE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
47 ,revenue_recog_meth_code OKL_ST_GEN_TMPT_SETS.REVENUE_RECOG_METH_CODE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
48 ,days_in_month_code OKL_ST_GEN_TMPT_SETS.DAYS_IN_MONTH_CODE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
49 ,days_in_yr_code OKL_ST_GEN_TMPT_SETS.DAYS_IN_YR_CODE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
50 ,isg_arrears_pay_dates_option OKL_ST_GEN_TMPT_SETS.ISG_ARREARS_PAY_DATES_OPTION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
51 );
52 G_MISS_GTSV_REC gtsv_rec_type;
53 TYPE gtsv_tbl_type IS TABLE OF gtsv_rec_type
54 INDEX BY BINARY_INTEGER;
55 ---------------------------------------------------------------------------
56 -- GLOBAL VARIABLES
57 ---------------------------------------------------------------------------
58 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_GTS_PVT';
59 G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
60 G_INVESTOR_TYPE CONSTANT VARCHAR2(200) := 'INVESTOR';
61 G_FINANCIAL_TYPE CONSTANT VARCHAR2(200) := 'FINANCIAL';
62 --------------------------------------------------------------------------------
63 -- ERRORS AND EXCEPTIONS
64 --------------------------------------------------------------------------------
65 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
66 ---------------------------------------------------------------------------
67 -- GLOBAL MESSAGE CONSTANTS
68 ---------------------------------------------------------------------------
69 -- Adding MESSAGE CONSTANTs for 'Unique Key Validation','SQLCode', 'SQLErrM'
70 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
71 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
72 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
73 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
74 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
75 G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
76
77
78 ---------------------------------------------------------------------------
79 -- Procedures and Functions
80 ---------------------------------------------------------------------------
81 PROCEDURE qc;
82 PROCEDURE change_version;
83 PROCEDURE api_copy;
84 PROCEDURE insert_row(
85 p_api_version IN NUMBER,
86 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
87 x_return_status OUT NOCOPY VARCHAR2,
88 x_msg_count OUT NOCOPY NUMBER,
89 x_msg_data OUT NOCOPY VARCHAR2,
90 p_gtsv_rec IN gtsv_rec_type,
91 x_gtsv_rec OUT NOCOPY gtsv_rec_type );
92
93 PROCEDURE insert_row(
94 p_api_version IN NUMBER,
95 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
96 x_return_status OUT NOCOPY VARCHAR2,
97 x_msg_count OUT NOCOPY NUMBER,
98 x_msg_data OUT NOCOPY VARCHAR2,
99 p_gtsv_tbl IN gtsv_tbl_type,
100 x_gtsv_tbl OUT NOCOPY gtsv_tbl_type);
101
102 PROCEDURE update_row(
103 p_api_version IN NUMBER,
104 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
105 x_return_status OUT NOCOPY VARCHAR2,
106 x_msg_count OUT NOCOPY NUMBER,
107 x_msg_data OUT NOCOPY VARCHAR2,
108 p_gtsv_rec IN gtsv_rec_type,
109 x_gtsv_rec OUT NOCOPY gtsv_rec_type);
110
111 PROCEDURE update_row(
112 p_api_version IN NUMBER,
113 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
114 x_return_status OUT NOCOPY VARCHAR2,
115 x_msg_count OUT NOCOPY NUMBER,
116 x_msg_data OUT NOCOPY VARCHAR2,
117 p_gtsv_tbl IN gtsv_tbl_type,
118 x_gtsv_tbl OUT NOCOPY gtsv_tbl_type);
119
120 PROCEDURE delete_row(
121 p_api_version IN NUMBER,
122 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
123 x_return_status OUT NOCOPY VARCHAR2,
124 x_msg_count OUT NOCOPY NUMBER,
125 x_msg_data OUT NOCOPY VARCHAR2,
126 p_gtsv_rec IN gtsv_rec_type);
127
128 PROCEDURE delete_row(
129 p_api_version IN NUMBER,
130 p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
131 x_return_status OUT NOCOPY VARCHAR2,
132 x_msg_count OUT NOCOPY NUMBER,
133 x_msg_data OUT NOCOPY VARCHAR2,
134 p_gtsv_tbl IN gtsv_tbl_type);
135
136 END okl_gts_pvt;