eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_GTS_PVT dependencies on OKL_API

Line 7: id OKL_ST_GEN_TMPT_SETS.ID%TYPE DEFAULT Okl_Api.G_MISS_NUM

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

Line 8: ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM

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

Line 9: ,name OKL_ST_GEN_TMPT_SETS.NAME%TYPE DEFAULT Okl_Api.G_MISS_CHAR

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

Line 10: ,description OKL_ST_GEN_TMPT_SETS.DESCRIPTION%TYPE DEFAULT Okl_Api.G_MISS_CHAR

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

Line 11: ,product_type OKL_ST_GEN_TMPT_SETS.PRODUCT_TYPE%TYPE DEFAULT Okl_Api.G_MISS_CHAR

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

Line 12: ,tax_owner OKL_ST_GEN_TMPT_SETS.TAX_OWNER%TYPE DEFAULT Okl_Api.G_MISS_CHAR

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

Line 13: ,deal_type OKL_ST_GEN_TMPT_SETS.DEAL_TYPE%TYPE DEFAULT Okl_Api.G_MISS_CHAR

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

Line 14: ,pricing_engine OKL_ST_GEN_TMPT_SETS.PRICING_ENGINE%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

Line 15: ,org_id NUMBER DEFAULT Okl_Api.G_MISS_NUM

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

Line 16: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM

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

Line 17: ,creation_date OKL_ST_GEN_TMPT_SETS.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE

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

Line 18: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM

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

Line 19: ,last_update_date OKL_ST_GEN_TMPT_SETS.LAST_UPDATE_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE

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

Line 20: ,last_update_login 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

Line 21: ,interest_calc_meth_code OKL_ST_GEN_TMPT_SETS.INTEREST_CALC_METH_CODE%TYPE DEFAULT Okl_Api.G_MISS_CHAR

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

Line 22: ,revenue_recog_meth_code OKL_ST_GEN_TMPT_SETS.REVENUE_RECOG_METH_CODE%TYPE DEFAULT Okl_Api.G_MISS_CHAR

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: );

Line 23: ,days_in_month_code OKL_ST_GEN_TMPT_SETS.DAYS_IN_MONTH_CODE%TYPE DEFAULT Okl_Api.G_MISS_CHAR

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;

Line 24: ,days_in_yr_code OKL_ST_GEN_TMPT_SETS.DAYS_IN_YR_CODE%TYPE DEFAULT Okl_Api.G_MISS_CHAR

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

Line 25: ,isg_arrears_pay_dates_option OKL_ST_GEN_TMPT_SETS.ISG_ARREARS_PAY_DATES_OPTION%TYPE DEFAULT Okl_Api.G_MISS_CHAR

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;

Line 32: id OKL_ST_GEN_TMPT_SETS.ID%TYPE DEFAULT Okl_Api.G_MISS_NUM

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

Line 33: ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM

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

Line 34: ,name OKL_ST_GEN_TMPT_SETS.NAME%TYPE DEFAULT Okl_Api.G_MISS_CHAR

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

Line 35: ,description OKL_ST_GEN_TMPT_SETS.DESCRIPTION%TYPE DEFAULT Okl_Api.G_MISS_CHAR

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

Line 36: ,product_type OKL_ST_GEN_TMPT_SETS.PRODUCT_TYPE%TYPE DEFAULT Okl_Api.G_MISS_CHAR

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

Line 37: ,tax_owner OKL_ST_GEN_TMPT_SETS.TAX_OWNER%TYPE DEFAULT Okl_Api.G_MISS_CHAR

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

Line 38: ,deal_type OKL_ST_GEN_TMPT_SETS.DEAL_TYPE%TYPE DEFAULT Okl_Api.G_MISS_CHAR

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

Line 39: ,pricing_engine OKL_ST_GEN_TMPT_SETS.PRICING_ENGINE%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

Line 40: ,org_id NUMBER DEFAULT Okl_Api.G_MISS_NUM

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

Line 41: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM

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

Line 42: ,creation_date OKL_ST_GEN_TMPT_SETS.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE

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

Line 43: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM

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

Line 44: ,last_update_date OKL_ST_GEN_TMPT_SETS.LAST_UPDATE_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE

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

Line 45: ,last_update_login 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

Line 46: ,interest_calc_meth_code OKL_ST_GEN_TMPT_SETS.INTEREST_CALC_METH_CODE%TYPE DEFAULT Okl_Api.G_MISS_CHAR

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

Line 47: ,revenue_recog_meth_code OKL_ST_GEN_TMPT_SETS.REVENUE_RECOG_METH_CODE%TYPE DEFAULT Okl_Api.G_MISS_CHAR

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: );

Line 48: ,days_in_month_code OKL_ST_GEN_TMPT_SETS.DAYS_IN_MONTH_CODE%TYPE DEFAULT Okl_Api.G_MISS_CHAR

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;

Line 49: ,days_in_yr_code OKL_ST_GEN_TMPT_SETS.DAYS_IN_YR_CODE%TYPE DEFAULT Okl_Api.G_MISS_CHAR

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

Line 50: ,isg_arrears_pay_dates_option OKL_ST_GEN_TMPT_SETS.ISG_ARREARS_PAY_DATES_OPTION%TYPE DEFAULT Okl_Api.G_MISS_CHAR

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;

Line 59: G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;

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

Line 73: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;

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:

Line 74: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;

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: ---------------------------------------------------------------------------

Line 75: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;

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

Line 86: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

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,

Line 95: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

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,

Line 104: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

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,

Line 113: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

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,

Line 122: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

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);

Line 130: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

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);