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_SPM_PVT dependencies on OKL_API

Line 8: id NUMBER DEFAULT Okl_Api.G_MISS_NUM

4: ---------------------------------------------------------------------------
5: -- GLOBAL DATASTRUCTURES
6: ---------------------------------------------------------------------------
7: TYPE spm_rec_type IS RECORD (
8: id NUMBER DEFAULT Okl_Api.G_MISS_NUM
9: ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM
10: ,sif_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
11: ,khr_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
12: ,name OKL_SIF_PRICING_PARAMS.NAME%TYPE DEFAULT Okl_Api.G_MISS_CHAR

Line 9: ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM

5: -- GLOBAL DATASTRUCTURES
6: ---------------------------------------------------------------------------
7: TYPE spm_rec_type IS RECORD (
8: id NUMBER DEFAULT Okl_Api.G_MISS_NUM
9: ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM
10: ,sif_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
11: ,khr_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
12: ,name OKL_SIF_PRICING_PARAMS.NAME%TYPE DEFAULT Okl_Api.G_MISS_CHAR
13: ,display_yn OKL_SIF_PRICING_PARAMS.DISPLAY_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR

Line 10: ,sif_id NUMBER DEFAULT Okl_Api.G_MISS_NUM

6: ---------------------------------------------------------------------------
7: TYPE spm_rec_type IS RECORD (
8: id NUMBER DEFAULT Okl_Api.G_MISS_NUM
9: ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM
10: ,sif_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
11: ,khr_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
12: ,name OKL_SIF_PRICING_PARAMS.NAME%TYPE DEFAULT Okl_Api.G_MISS_CHAR
13: ,display_yn OKL_SIF_PRICING_PARAMS.DISPLAY_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
14: ,update_yn OKL_SIF_PRICING_PARAMS.UPDATE_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR

Line 11: ,khr_id NUMBER DEFAULT Okl_Api.G_MISS_NUM

7: TYPE spm_rec_type IS RECORD (
8: id NUMBER DEFAULT Okl_Api.G_MISS_NUM
9: ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM
10: ,sif_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
11: ,khr_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
12: ,name OKL_SIF_PRICING_PARAMS.NAME%TYPE DEFAULT Okl_Api.G_MISS_CHAR
13: ,display_yn OKL_SIF_PRICING_PARAMS.DISPLAY_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
14: ,update_yn OKL_SIF_PRICING_PARAMS.UPDATE_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
15: ,default_value OKL_SIF_PRICING_PARAMS.DEFAULT_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR

Line 12: ,name OKL_SIF_PRICING_PARAMS.NAME%TYPE DEFAULT Okl_Api.G_MISS_CHAR

8: id NUMBER DEFAULT Okl_Api.G_MISS_NUM
9: ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM
10: ,sif_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
11: ,khr_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
12: ,name OKL_SIF_PRICING_PARAMS.NAME%TYPE DEFAULT Okl_Api.G_MISS_CHAR
13: ,display_yn OKL_SIF_PRICING_PARAMS.DISPLAY_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
14: ,update_yn OKL_SIF_PRICING_PARAMS.UPDATE_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
15: ,default_value OKL_SIF_PRICING_PARAMS.DEFAULT_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
16: ,parameter_value OKL_SIF_PRICING_PARAMS.PARAMETER_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR

Line 13: ,display_yn OKL_SIF_PRICING_PARAMS.DISPLAY_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR

9: ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM
10: ,sif_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
11: ,khr_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
12: ,name OKL_SIF_PRICING_PARAMS.NAME%TYPE DEFAULT Okl_Api.G_MISS_CHAR
13: ,display_yn OKL_SIF_PRICING_PARAMS.DISPLAY_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
14: ,update_yn OKL_SIF_PRICING_PARAMS.UPDATE_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
15: ,default_value OKL_SIF_PRICING_PARAMS.DEFAULT_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
16: ,parameter_value OKL_SIF_PRICING_PARAMS.PARAMETER_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
17: ,prc_eng_ident OKL_SIF_PRICING_PARAMS.PRC_ENG_IDENT%TYPE DEFAULT Okl_Api.G_MISS_CHAR

Line 14: ,update_yn OKL_SIF_PRICING_PARAMS.UPDATE_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR

10: ,sif_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
11: ,khr_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
12: ,name OKL_SIF_PRICING_PARAMS.NAME%TYPE DEFAULT Okl_Api.G_MISS_CHAR
13: ,display_yn OKL_SIF_PRICING_PARAMS.DISPLAY_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
14: ,update_yn OKL_SIF_PRICING_PARAMS.UPDATE_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
15: ,default_value OKL_SIF_PRICING_PARAMS.DEFAULT_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
16: ,parameter_value OKL_SIF_PRICING_PARAMS.PARAMETER_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
17: ,prc_eng_ident OKL_SIF_PRICING_PARAMS.PRC_ENG_IDENT%TYPE DEFAULT Okl_Api.G_MISS_CHAR
18: ,description OKL_ST_GEN_PRC_PARAMS.DESCRIPTION%TYPE DEFAULT Okl_Api.G_MISS_CHAR

Line 15: ,default_value OKL_SIF_PRICING_PARAMS.DEFAULT_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR

11: ,khr_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
12: ,name OKL_SIF_PRICING_PARAMS.NAME%TYPE DEFAULT Okl_Api.G_MISS_CHAR
13: ,display_yn OKL_SIF_PRICING_PARAMS.DISPLAY_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
14: ,update_yn OKL_SIF_PRICING_PARAMS.UPDATE_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
15: ,default_value OKL_SIF_PRICING_PARAMS.DEFAULT_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
16: ,parameter_value OKL_SIF_PRICING_PARAMS.PARAMETER_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
17: ,prc_eng_ident OKL_SIF_PRICING_PARAMS.PRC_ENG_IDENT%TYPE DEFAULT Okl_Api.G_MISS_CHAR
18: ,description OKL_ST_GEN_PRC_PARAMS.DESCRIPTION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
19: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM

Line 16: ,parameter_value OKL_SIF_PRICING_PARAMS.PARAMETER_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR

12: ,name OKL_SIF_PRICING_PARAMS.NAME%TYPE DEFAULT Okl_Api.G_MISS_CHAR
13: ,display_yn OKL_SIF_PRICING_PARAMS.DISPLAY_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
14: ,update_yn OKL_SIF_PRICING_PARAMS.UPDATE_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
15: ,default_value OKL_SIF_PRICING_PARAMS.DEFAULT_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
16: ,parameter_value OKL_SIF_PRICING_PARAMS.PARAMETER_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
17: ,prc_eng_ident OKL_SIF_PRICING_PARAMS.PRC_ENG_IDENT%TYPE DEFAULT Okl_Api.G_MISS_CHAR
18: ,description OKL_ST_GEN_PRC_PARAMS.DESCRIPTION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
19: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
20: ,creation_date OKL_SIF_PRICING_PARAMS.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE

Line 17: ,prc_eng_ident OKL_SIF_PRICING_PARAMS.PRC_ENG_IDENT%TYPE DEFAULT Okl_Api.G_MISS_CHAR

13: ,display_yn OKL_SIF_PRICING_PARAMS.DISPLAY_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
14: ,update_yn OKL_SIF_PRICING_PARAMS.UPDATE_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
15: ,default_value OKL_SIF_PRICING_PARAMS.DEFAULT_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
16: ,parameter_value OKL_SIF_PRICING_PARAMS.PARAMETER_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
17: ,prc_eng_ident OKL_SIF_PRICING_PARAMS.PRC_ENG_IDENT%TYPE DEFAULT Okl_Api.G_MISS_CHAR
18: ,description OKL_ST_GEN_PRC_PARAMS.DESCRIPTION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
19: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
20: ,creation_date OKL_SIF_PRICING_PARAMS.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
21: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM

Line 18: ,description OKL_ST_GEN_PRC_PARAMS.DESCRIPTION%TYPE DEFAULT Okl_Api.G_MISS_CHAR

14: ,update_yn OKL_SIF_PRICING_PARAMS.UPDATE_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
15: ,default_value OKL_SIF_PRICING_PARAMS.DEFAULT_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
16: ,parameter_value OKL_SIF_PRICING_PARAMS.PARAMETER_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
17: ,prc_eng_ident OKL_SIF_PRICING_PARAMS.PRC_ENG_IDENT%TYPE DEFAULT Okl_Api.G_MISS_CHAR
18: ,description OKL_ST_GEN_PRC_PARAMS.DESCRIPTION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
19: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
20: ,creation_date OKL_SIF_PRICING_PARAMS.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
21: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
22: ,last_update_date OKL_SIF_PRICING_PARAMS.LAST_UPDATE_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE

Line 19: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM

15: ,default_value OKL_SIF_PRICING_PARAMS.DEFAULT_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
16: ,parameter_value OKL_SIF_PRICING_PARAMS.PARAMETER_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
17: ,prc_eng_ident OKL_SIF_PRICING_PARAMS.PRC_ENG_IDENT%TYPE DEFAULT Okl_Api.G_MISS_CHAR
18: ,description OKL_ST_GEN_PRC_PARAMS.DESCRIPTION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
19: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
20: ,creation_date OKL_SIF_PRICING_PARAMS.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
21: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
22: ,last_update_date OKL_SIF_PRICING_PARAMS.LAST_UPDATE_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
23: ,last_update_login NUMBER DEFAULT Okl_Api.G_MISS_NUM

Line 20: ,creation_date OKL_SIF_PRICING_PARAMS.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE

16: ,parameter_value OKL_SIF_PRICING_PARAMS.PARAMETER_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
17: ,prc_eng_ident OKL_SIF_PRICING_PARAMS.PRC_ENG_IDENT%TYPE DEFAULT Okl_Api.G_MISS_CHAR
18: ,description OKL_ST_GEN_PRC_PARAMS.DESCRIPTION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
19: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
20: ,creation_date OKL_SIF_PRICING_PARAMS.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
21: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
22: ,last_update_date OKL_SIF_PRICING_PARAMS.LAST_UPDATE_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
23: ,last_update_login NUMBER DEFAULT Okl_Api.G_MISS_NUM
24: );

Line 21: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM

17: ,prc_eng_ident OKL_SIF_PRICING_PARAMS.PRC_ENG_IDENT%TYPE DEFAULT Okl_Api.G_MISS_CHAR
18: ,description OKL_ST_GEN_PRC_PARAMS.DESCRIPTION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
19: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
20: ,creation_date OKL_SIF_PRICING_PARAMS.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
21: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
22: ,last_update_date OKL_SIF_PRICING_PARAMS.LAST_UPDATE_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
23: ,last_update_login NUMBER DEFAULT Okl_Api.G_MISS_NUM
24: );
25:

Line 22: ,last_update_date OKL_SIF_PRICING_PARAMS.LAST_UPDATE_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE

18: ,description OKL_ST_GEN_PRC_PARAMS.DESCRIPTION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
19: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
20: ,creation_date OKL_SIF_PRICING_PARAMS.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
21: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
22: ,last_update_date OKL_SIF_PRICING_PARAMS.LAST_UPDATE_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
23: ,last_update_login NUMBER DEFAULT Okl_Api.G_MISS_NUM
24: );
25:
26: G_MISS_spm_REC spm_rec_type;

Line 23: ,last_update_login NUMBER DEFAULT Okl_Api.G_MISS_NUM

19: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
20: ,creation_date OKL_SIF_PRICING_PARAMS.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
21: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
22: ,last_update_date OKL_SIF_PRICING_PARAMS.LAST_UPDATE_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
23: ,last_update_login NUMBER DEFAULT Okl_Api.G_MISS_NUM
24: );
25:
26: G_MISS_spm_REC spm_rec_type;
27: TYPE spm_tbl_type IS TABLE OF spm_rec_type

Line 31: id NUMBER DEFAULT Okl_Api.G_MISS_NUM

27: TYPE spm_tbl_type IS TABLE OF spm_rec_type
28: INDEX BY BINARY_INTEGER;
29:
30: TYPE spmv_rec_type IS RECORD (
31: id NUMBER DEFAULT Okl_Api.G_MISS_NUM
32: ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM
33: ,sif_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
34: ,khr_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
35: ,name OKL_SIF_PRICING_PARAMS_V.NAME%TYPE DEFAULT Okl_Api.G_MISS_CHAR

Line 32: ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM

28: INDEX BY BINARY_INTEGER;
29:
30: TYPE spmv_rec_type IS RECORD (
31: id NUMBER DEFAULT Okl_Api.G_MISS_NUM
32: ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM
33: ,sif_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
34: ,khr_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
35: ,name OKL_SIF_PRICING_PARAMS_V.NAME%TYPE DEFAULT Okl_Api.G_MISS_CHAR
36: ,display_yn OKL_SIF_PRICING_PARAMS_V.DISPLAY_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR

Line 33: ,sif_id NUMBER DEFAULT Okl_Api.G_MISS_NUM

29:
30: TYPE spmv_rec_type IS RECORD (
31: id NUMBER DEFAULT Okl_Api.G_MISS_NUM
32: ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM
33: ,sif_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
34: ,khr_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
35: ,name OKL_SIF_PRICING_PARAMS_V.NAME%TYPE DEFAULT Okl_Api.G_MISS_CHAR
36: ,display_yn OKL_SIF_PRICING_PARAMS_V.DISPLAY_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
37: ,update_yn OKL_SIF_PRICING_PARAMS_V.UPDATE_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR

Line 34: ,khr_id NUMBER DEFAULT Okl_Api.G_MISS_NUM

30: TYPE spmv_rec_type IS RECORD (
31: id NUMBER DEFAULT Okl_Api.G_MISS_NUM
32: ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM
33: ,sif_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
34: ,khr_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
35: ,name OKL_SIF_PRICING_PARAMS_V.NAME%TYPE DEFAULT Okl_Api.G_MISS_CHAR
36: ,display_yn OKL_SIF_PRICING_PARAMS_V.DISPLAY_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
37: ,update_yn OKL_SIF_PRICING_PARAMS_V.UPDATE_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
38: ,default_value OKL_SIF_PRICING_PARAMS_V.DEFAULT_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR

Line 35: ,name OKL_SIF_PRICING_PARAMS_V.NAME%TYPE DEFAULT Okl_Api.G_MISS_CHAR

31: id NUMBER DEFAULT Okl_Api.G_MISS_NUM
32: ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM
33: ,sif_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
34: ,khr_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
35: ,name OKL_SIF_PRICING_PARAMS_V.NAME%TYPE DEFAULT Okl_Api.G_MISS_CHAR
36: ,display_yn OKL_SIF_PRICING_PARAMS_V.DISPLAY_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
37: ,update_yn OKL_SIF_PRICING_PARAMS_V.UPDATE_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
38: ,default_value OKL_SIF_PRICING_PARAMS_V.DEFAULT_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
39: ,parameter_value OKL_SIF_PRICING_PARAMS_V.PARAMETER_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR

Line 36: ,display_yn OKL_SIF_PRICING_PARAMS_V.DISPLAY_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR

32: ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM
33: ,sif_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
34: ,khr_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
35: ,name OKL_SIF_PRICING_PARAMS_V.NAME%TYPE DEFAULT Okl_Api.G_MISS_CHAR
36: ,display_yn OKL_SIF_PRICING_PARAMS_V.DISPLAY_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
37: ,update_yn OKL_SIF_PRICING_PARAMS_V.UPDATE_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
38: ,default_value OKL_SIF_PRICING_PARAMS_V.DEFAULT_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
39: ,parameter_value OKL_SIF_PRICING_PARAMS_V.PARAMETER_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
40: ,prc_eng_ident OKL_SIF_PRICING_PARAMS_V.PRC_ENG_IDENT%TYPE DEFAULT Okl_Api.G_MISS_CHAR

Line 37: ,update_yn OKL_SIF_PRICING_PARAMS_V.UPDATE_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR

33: ,sif_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
34: ,khr_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
35: ,name OKL_SIF_PRICING_PARAMS_V.NAME%TYPE DEFAULT Okl_Api.G_MISS_CHAR
36: ,display_yn OKL_SIF_PRICING_PARAMS_V.DISPLAY_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
37: ,update_yn OKL_SIF_PRICING_PARAMS_V.UPDATE_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
38: ,default_value OKL_SIF_PRICING_PARAMS_V.DEFAULT_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
39: ,parameter_value OKL_SIF_PRICING_PARAMS_V.PARAMETER_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
40: ,prc_eng_ident OKL_SIF_PRICING_PARAMS_V.PRC_ENG_IDENT%TYPE DEFAULT Okl_Api.G_MISS_CHAR
41: ,description OKL_ST_GEN_PRC_PARAMS.DESCRIPTION%TYPE DEFAULT Okl_Api.G_MISS_CHAR

Line 38: ,default_value OKL_SIF_PRICING_PARAMS_V.DEFAULT_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR

34: ,khr_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
35: ,name OKL_SIF_PRICING_PARAMS_V.NAME%TYPE DEFAULT Okl_Api.G_MISS_CHAR
36: ,display_yn OKL_SIF_PRICING_PARAMS_V.DISPLAY_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
37: ,update_yn OKL_SIF_PRICING_PARAMS_V.UPDATE_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
38: ,default_value OKL_SIF_PRICING_PARAMS_V.DEFAULT_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
39: ,parameter_value OKL_SIF_PRICING_PARAMS_V.PARAMETER_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
40: ,prc_eng_ident OKL_SIF_PRICING_PARAMS_V.PRC_ENG_IDENT%TYPE DEFAULT Okl_Api.G_MISS_CHAR
41: ,description OKL_ST_GEN_PRC_PARAMS.DESCRIPTION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
42: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM

Line 39: ,parameter_value OKL_SIF_PRICING_PARAMS_V.PARAMETER_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR

35: ,name OKL_SIF_PRICING_PARAMS_V.NAME%TYPE DEFAULT Okl_Api.G_MISS_CHAR
36: ,display_yn OKL_SIF_PRICING_PARAMS_V.DISPLAY_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
37: ,update_yn OKL_SIF_PRICING_PARAMS_V.UPDATE_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
38: ,default_value OKL_SIF_PRICING_PARAMS_V.DEFAULT_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
39: ,parameter_value OKL_SIF_PRICING_PARAMS_V.PARAMETER_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
40: ,prc_eng_ident OKL_SIF_PRICING_PARAMS_V.PRC_ENG_IDENT%TYPE DEFAULT Okl_Api.G_MISS_CHAR
41: ,description OKL_ST_GEN_PRC_PARAMS.DESCRIPTION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
42: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
43: ,creation_date OKL_SIF_PRICING_PARAMS_V.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE

Line 40: ,prc_eng_ident OKL_SIF_PRICING_PARAMS_V.PRC_ENG_IDENT%TYPE DEFAULT Okl_Api.G_MISS_CHAR

36: ,display_yn OKL_SIF_PRICING_PARAMS_V.DISPLAY_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
37: ,update_yn OKL_SIF_PRICING_PARAMS_V.UPDATE_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
38: ,default_value OKL_SIF_PRICING_PARAMS_V.DEFAULT_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
39: ,parameter_value OKL_SIF_PRICING_PARAMS_V.PARAMETER_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
40: ,prc_eng_ident OKL_SIF_PRICING_PARAMS_V.PRC_ENG_IDENT%TYPE DEFAULT Okl_Api.G_MISS_CHAR
41: ,description OKL_ST_GEN_PRC_PARAMS.DESCRIPTION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
42: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
43: ,creation_date OKL_SIF_PRICING_PARAMS_V.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
44: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM

Line 41: ,description OKL_ST_GEN_PRC_PARAMS.DESCRIPTION%TYPE DEFAULT Okl_Api.G_MISS_CHAR

37: ,update_yn OKL_SIF_PRICING_PARAMS_V.UPDATE_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
38: ,default_value OKL_SIF_PRICING_PARAMS_V.DEFAULT_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
39: ,parameter_value OKL_SIF_PRICING_PARAMS_V.PARAMETER_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
40: ,prc_eng_ident OKL_SIF_PRICING_PARAMS_V.PRC_ENG_IDENT%TYPE DEFAULT Okl_Api.G_MISS_CHAR
41: ,description OKL_ST_GEN_PRC_PARAMS.DESCRIPTION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
42: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
43: ,creation_date OKL_SIF_PRICING_PARAMS_V.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
44: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
45: ,last_update_date OKL_SIF_PRICING_PARAMS_V.LAST_UPDATE_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE

Line 42: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM

38: ,default_value OKL_SIF_PRICING_PARAMS_V.DEFAULT_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
39: ,parameter_value OKL_SIF_PRICING_PARAMS_V.PARAMETER_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
40: ,prc_eng_ident OKL_SIF_PRICING_PARAMS_V.PRC_ENG_IDENT%TYPE DEFAULT Okl_Api.G_MISS_CHAR
41: ,description OKL_ST_GEN_PRC_PARAMS.DESCRIPTION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
42: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
43: ,creation_date OKL_SIF_PRICING_PARAMS_V.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
44: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
45: ,last_update_date OKL_SIF_PRICING_PARAMS_V.LAST_UPDATE_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
46: ,last_update_login NUMBER DEFAULT Okl_Api.G_MISS_NUM

Line 43: ,creation_date OKL_SIF_PRICING_PARAMS_V.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE

39: ,parameter_value OKL_SIF_PRICING_PARAMS_V.PARAMETER_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
40: ,prc_eng_ident OKL_SIF_PRICING_PARAMS_V.PRC_ENG_IDENT%TYPE DEFAULT Okl_Api.G_MISS_CHAR
41: ,description OKL_ST_GEN_PRC_PARAMS.DESCRIPTION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
42: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
43: ,creation_date OKL_SIF_PRICING_PARAMS_V.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
44: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
45: ,last_update_date OKL_SIF_PRICING_PARAMS_V.LAST_UPDATE_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
46: ,last_update_login NUMBER DEFAULT Okl_Api.G_MISS_NUM
47: );

Line 44: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM

40: ,prc_eng_ident OKL_SIF_PRICING_PARAMS_V.PRC_ENG_IDENT%TYPE DEFAULT Okl_Api.G_MISS_CHAR
41: ,description OKL_ST_GEN_PRC_PARAMS.DESCRIPTION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
42: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
43: ,creation_date OKL_SIF_PRICING_PARAMS_V.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
44: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
45: ,last_update_date OKL_SIF_PRICING_PARAMS_V.LAST_UPDATE_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
46: ,last_update_login NUMBER DEFAULT Okl_Api.G_MISS_NUM
47: );
48:

Line 45: ,last_update_date OKL_SIF_PRICING_PARAMS_V.LAST_UPDATE_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE

41: ,description OKL_ST_GEN_PRC_PARAMS.DESCRIPTION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
42: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
43: ,creation_date OKL_SIF_PRICING_PARAMS_V.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
44: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
45: ,last_update_date OKL_SIF_PRICING_PARAMS_V.LAST_UPDATE_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
46: ,last_update_login NUMBER DEFAULT Okl_Api.G_MISS_NUM
47: );
48:
49: G_MISS_spmv_REC spmv_rec_type;

Line 46: ,last_update_login NUMBER DEFAULT Okl_Api.G_MISS_NUM

42: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
43: ,creation_date OKL_SIF_PRICING_PARAMS_V.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
44: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
45: ,last_update_date OKL_SIF_PRICING_PARAMS_V.LAST_UPDATE_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
46: ,last_update_login NUMBER DEFAULT Okl_Api.G_MISS_NUM
47: );
48:
49: G_MISS_spmv_REC spmv_rec_type;
50: TYPE spmv_tbl_type IS TABLE OF spmv_rec_type

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

53: ---------------------------------------------------------------------------
54: -- GLOBAL VARIABLES
55: ---------------------------------------------------------------------------
56: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_SPM_PVT';
57: G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
58: ---------------------------------------------------------------------------
59: -- ERRORS AND EXCEPTIONS
60: ---------------------------------------------------------------------------
61: G_EXCEPTION_HALT_VALIDATION EXCEPTION;

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

65: -- Adding MESSAGE CONSTANTs for 'Unique Key Validation','SQLCode', 'SQLErrM'
66: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
67: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
68: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
69: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
70: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
71: ---------------------------------------------------------------------------
72: -- Procedures and Functions
73: ---------------------------------------------------------------------------

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

66: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
67: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
68: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
69: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
70: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
71: ---------------------------------------------------------------------------
72: -- Procedures and Functions
73: ---------------------------------------------------------------------------
74: PROCEDURE qc;

Line 80: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

76: PROCEDURE api_copy;
77:
78: PROCEDURE insert_row(
79: p_api_version IN NUMBER,
80: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
81: x_return_status OUT NOCOPY VARCHAR2,
82: x_msg_count OUT NOCOPY NUMBER,
83: x_msg_data OUT NOCOPY VARCHAR2,
84: p_spmv_rec IN spmv_rec_type);

Line 88: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

84: p_spmv_rec IN spmv_rec_type);
85:
86: PROCEDURE insert_row(
87: p_api_version IN NUMBER,
88: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
89: x_return_status OUT NOCOPY VARCHAR2,
90: x_msg_count OUT NOCOPY NUMBER,
91: x_msg_data OUT NOCOPY VARCHAR2,
92: p_spmv_tbl IN spmv_tbl_type);

Line 96: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

92: p_spmv_tbl IN spmv_tbl_type);
93:
94: PROCEDURE update_row(
95: p_api_version IN NUMBER,
96: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
97: x_return_status OUT NOCOPY VARCHAR2,
98: x_msg_count OUT NOCOPY NUMBER,
99: x_msg_data OUT NOCOPY VARCHAR2,
100: p_spmv_rec IN spmv_rec_type);

Line 105: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,

101:
102:
103: PROCEDURE update_row(
104: p_api_version IN NUMBER,
105: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
106: x_return_status OUT NOCOPY VARCHAR2,
107: x_msg_count OUT NOCOPY NUMBER,
108: x_msg_data OUT NOCOPY VARCHAR2,
109: p_spmv_tbl IN spmv_tbl_type);