5: -- GLOBAL DATASTRUCTURES
6: ---------------------------------------------------------------------------
7:
8: TYPE gtp_rec_type IS RECORD (
9: id NUMBER DEFAULT Okl_Api.G_MISS_NUM
10: ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM
11: ,name OKL_ST_GEN_PRC_PARAMS.NAME%TYPE DEFAULT Okl_Api.G_MISS_CHAR
12: ,description OKL_ST_GEN_PRC_PARAMS.DESCRIPTION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
13: ,display_yn OKL_ST_GEN_PRC_PARAMS.DISPLAY_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
6: ---------------------------------------------------------------------------
7:
8: TYPE gtp_rec_type IS RECORD (
9: id NUMBER DEFAULT Okl_Api.G_MISS_NUM
10: ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM
11: ,name OKL_ST_GEN_PRC_PARAMS.NAME%TYPE DEFAULT Okl_Api.G_MISS_CHAR
12: ,description OKL_ST_GEN_PRC_PARAMS.DESCRIPTION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
13: ,display_yn OKL_ST_GEN_PRC_PARAMS.DISPLAY_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
14: ,update_yn OKL_ST_GEN_PRC_PARAMS.UPDATE_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
7:
8: TYPE gtp_rec_type IS RECORD (
9: id NUMBER DEFAULT Okl_Api.G_MISS_NUM
10: ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM
11: ,name OKL_ST_GEN_PRC_PARAMS.NAME%TYPE DEFAULT Okl_Api.G_MISS_CHAR
12: ,description OKL_ST_GEN_PRC_PARAMS.DESCRIPTION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
13: ,display_yn OKL_ST_GEN_PRC_PARAMS.DISPLAY_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
14: ,update_yn OKL_ST_GEN_PRC_PARAMS.UPDATE_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
15: ,prc_eng_ident OKL_ST_GEN_PRC_PARAMS.PRC_ENG_IDENT%TYPE DEFAULT Okl_Api.G_MISS_CHAR
8: TYPE gtp_rec_type IS RECORD (
9: id NUMBER DEFAULT Okl_Api.G_MISS_NUM
10: ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM
11: ,name OKL_ST_GEN_PRC_PARAMS.NAME%TYPE DEFAULT Okl_Api.G_MISS_CHAR
12: ,description OKL_ST_GEN_PRC_PARAMS.DESCRIPTION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
13: ,display_yn OKL_ST_GEN_PRC_PARAMS.DISPLAY_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
14: ,update_yn OKL_ST_GEN_PRC_PARAMS.UPDATE_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
15: ,prc_eng_ident OKL_ST_GEN_PRC_PARAMS.PRC_ENG_IDENT%TYPE DEFAULT Okl_Api.G_MISS_CHAR
16: ,default_value OKL_ST_GEN_PRC_PARAMS.DEFAULT_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
9: id NUMBER DEFAULT Okl_Api.G_MISS_NUM
10: ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM
11: ,name OKL_ST_GEN_PRC_PARAMS.NAME%TYPE DEFAULT Okl_Api.G_MISS_CHAR
12: ,description OKL_ST_GEN_PRC_PARAMS.DESCRIPTION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
13: ,display_yn OKL_ST_GEN_PRC_PARAMS.DISPLAY_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
14: ,update_yn OKL_ST_GEN_PRC_PARAMS.UPDATE_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
15: ,prc_eng_ident OKL_ST_GEN_PRC_PARAMS.PRC_ENG_IDENT%TYPE DEFAULT Okl_Api.G_MISS_CHAR
16: ,default_value OKL_ST_GEN_PRC_PARAMS.DEFAULT_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
17: ,org_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
10: ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM
11: ,name OKL_ST_GEN_PRC_PARAMS.NAME%TYPE DEFAULT Okl_Api.G_MISS_CHAR
12: ,description OKL_ST_GEN_PRC_PARAMS.DESCRIPTION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
13: ,display_yn OKL_ST_GEN_PRC_PARAMS.DISPLAY_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
14: ,update_yn OKL_ST_GEN_PRC_PARAMS.UPDATE_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
15: ,prc_eng_ident OKL_ST_GEN_PRC_PARAMS.PRC_ENG_IDENT%TYPE DEFAULT Okl_Api.G_MISS_CHAR
16: ,default_value OKL_ST_GEN_PRC_PARAMS.DEFAULT_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
17: ,org_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
18: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
11: ,name OKL_ST_GEN_PRC_PARAMS.NAME%TYPE DEFAULT Okl_Api.G_MISS_CHAR
12: ,description OKL_ST_GEN_PRC_PARAMS.DESCRIPTION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
13: ,display_yn OKL_ST_GEN_PRC_PARAMS.DISPLAY_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
14: ,update_yn OKL_ST_GEN_PRC_PARAMS.UPDATE_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
15: ,prc_eng_ident OKL_ST_GEN_PRC_PARAMS.PRC_ENG_IDENT%TYPE DEFAULT Okl_Api.G_MISS_CHAR
16: ,default_value OKL_ST_GEN_PRC_PARAMS.DEFAULT_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
17: ,org_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
18: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
19: ,creation_date OKL_ST_GEN_PRC_PARAMS.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
12: ,description OKL_ST_GEN_PRC_PARAMS.DESCRIPTION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
13: ,display_yn OKL_ST_GEN_PRC_PARAMS.DISPLAY_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
14: ,update_yn OKL_ST_GEN_PRC_PARAMS.UPDATE_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
15: ,prc_eng_ident OKL_ST_GEN_PRC_PARAMS.PRC_ENG_IDENT%TYPE DEFAULT Okl_Api.G_MISS_CHAR
16: ,default_value OKL_ST_GEN_PRC_PARAMS.DEFAULT_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
17: ,org_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
18: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
19: ,creation_date OKL_ST_GEN_PRC_PARAMS.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
20: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
13: ,display_yn OKL_ST_GEN_PRC_PARAMS.DISPLAY_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
14: ,update_yn OKL_ST_GEN_PRC_PARAMS.UPDATE_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
15: ,prc_eng_ident OKL_ST_GEN_PRC_PARAMS.PRC_ENG_IDENT%TYPE DEFAULT Okl_Api.G_MISS_CHAR
16: ,default_value OKL_ST_GEN_PRC_PARAMS.DEFAULT_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
17: ,org_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
18: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
19: ,creation_date OKL_ST_GEN_PRC_PARAMS.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
20: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
21: ,last_update_date OKL_ST_GEN_PRC_PARAMS.LAST_UPDATE_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
14: ,update_yn OKL_ST_GEN_PRC_PARAMS.UPDATE_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
15: ,prc_eng_ident OKL_ST_GEN_PRC_PARAMS.PRC_ENG_IDENT%TYPE DEFAULT Okl_Api.G_MISS_CHAR
16: ,default_value OKL_ST_GEN_PRC_PARAMS.DEFAULT_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
17: ,org_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
18: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
19: ,creation_date OKL_ST_GEN_PRC_PARAMS.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
20: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
21: ,last_update_date OKL_ST_GEN_PRC_PARAMS.LAST_UPDATE_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
22: ,last_update_login NUMBER DEFAULT Okl_Api.G_MISS_NUM
15: ,prc_eng_ident OKL_ST_GEN_PRC_PARAMS.PRC_ENG_IDENT%TYPE DEFAULT Okl_Api.G_MISS_CHAR
16: ,default_value OKL_ST_GEN_PRC_PARAMS.DEFAULT_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
17: ,org_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
18: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
19: ,creation_date OKL_ST_GEN_PRC_PARAMS.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
20: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
21: ,last_update_date OKL_ST_GEN_PRC_PARAMS.LAST_UPDATE_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
22: ,last_update_login NUMBER DEFAULT Okl_Api.G_MISS_NUM
23: ,gtt_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
16: ,default_value OKL_ST_GEN_PRC_PARAMS.DEFAULT_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
17: ,org_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
18: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
19: ,creation_date OKL_ST_GEN_PRC_PARAMS.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
20: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
21: ,last_update_date OKL_ST_GEN_PRC_PARAMS.LAST_UPDATE_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
22: ,last_update_login NUMBER DEFAULT Okl_Api.G_MISS_NUM
23: ,gtt_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
24: );
17: ,org_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
18: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
19: ,creation_date OKL_ST_GEN_PRC_PARAMS.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
20: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
21: ,last_update_date OKL_ST_GEN_PRC_PARAMS.LAST_UPDATE_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
22: ,last_update_login NUMBER DEFAULT Okl_Api.G_MISS_NUM
23: ,gtt_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
24: );
25:
18: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
19: ,creation_date OKL_ST_GEN_PRC_PARAMS.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
20: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
21: ,last_update_date OKL_ST_GEN_PRC_PARAMS.LAST_UPDATE_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
22: ,last_update_login NUMBER DEFAULT Okl_Api.G_MISS_NUM
23: ,gtt_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
24: );
25:
26:
19: ,creation_date OKL_ST_GEN_PRC_PARAMS.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
20: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
21: ,last_update_date OKL_ST_GEN_PRC_PARAMS.LAST_UPDATE_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
22: ,last_update_login NUMBER DEFAULT Okl_Api.G_MISS_NUM
23: ,gtt_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
24: );
25:
26:
27: G_MISS_gtp_REC gtp_rec_type;
28: TYPE gtp_tbl_type IS TABLE OF gtp_rec_type
29: INDEX BY BINARY_INTEGER;
30:
31: TYPE gtpv_rec_type IS RECORD (
32: id NUMBER DEFAULT Okl_Api.G_MISS_NUM
33: ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM
34: ,name OKL_ST_GEN_PRC_PARAMS.NAME%TYPE DEFAULT Okl_Api.G_MISS_CHAR
35: ,description OKL_ST_GEN_PRC_PARAMS.DESCRIPTION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
36: ,display_yn OKL_ST_GEN_PRC_PARAMS.DISPLAY_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
29: INDEX BY BINARY_INTEGER;
30:
31: TYPE gtpv_rec_type IS RECORD (
32: id NUMBER DEFAULT Okl_Api.G_MISS_NUM
33: ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM
34: ,name OKL_ST_GEN_PRC_PARAMS.NAME%TYPE DEFAULT Okl_Api.G_MISS_CHAR
35: ,description OKL_ST_GEN_PRC_PARAMS.DESCRIPTION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
36: ,display_yn OKL_ST_GEN_PRC_PARAMS.DISPLAY_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
37: ,update_yn OKL_ST_GEN_PRC_PARAMS.UPDATE_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
30:
31: TYPE gtpv_rec_type IS RECORD (
32: id NUMBER DEFAULT Okl_Api.G_MISS_NUM
33: ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM
34: ,name OKL_ST_GEN_PRC_PARAMS.NAME%TYPE DEFAULT Okl_Api.G_MISS_CHAR
35: ,description OKL_ST_GEN_PRC_PARAMS.DESCRIPTION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
36: ,display_yn OKL_ST_GEN_PRC_PARAMS.DISPLAY_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
37: ,update_yn OKL_ST_GEN_PRC_PARAMS.UPDATE_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
38: ,prc_eng_ident OKL_ST_GEN_PRC_PARAMS.PRC_ENG_IDENT%TYPE DEFAULT Okl_Api.G_MISS_CHAR
31: TYPE gtpv_rec_type IS RECORD (
32: id NUMBER DEFAULT Okl_Api.G_MISS_NUM
33: ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM
34: ,name OKL_ST_GEN_PRC_PARAMS.NAME%TYPE DEFAULT Okl_Api.G_MISS_CHAR
35: ,description OKL_ST_GEN_PRC_PARAMS.DESCRIPTION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
36: ,display_yn OKL_ST_GEN_PRC_PARAMS.DISPLAY_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
37: ,update_yn OKL_ST_GEN_PRC_PARAMS.UPDATE_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
38: ,prc_eng_ident OKL_ST_GEN_PRC_PARAMS.PRC_ENG_IDENT%TYPE DEFAULT Okl_Api.G_MISS_CHAR
39: ,default_value OKL_ST_GEN_PRC_PARAMS.DEFAULT_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
32: id NUMBER DEFAULT Okl_Api.G_MISS_NUM
33: ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM
34: ,name OKL_ST_GEN_PRC_PARAMS.NAME%TYPE DEFAULT Okl_Api.G_MISS_CHAR
35: ,description OKL_ST_GEN_PRC_PARAMS.DESCRIPTION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
36: ,display_yn OKL_ST_GEN_PRC_PARAMS.DISPLAY_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
37: ,update_yn OKL_ST_GEN_PRC_PARAMS.UPDATE_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
38: ,prc_eng_ident OKL_ST_GEN_PRC_PARAMS.PRC_ENG_IDENT%TYPE DEFAULT Okl_Api.G_MISS_CHAR
39: ,default_value OKL_ST_GEN_PRC_PARAMS.DEFAULT_VALUE%TYPE DEFAULT Okl_Api.G_MISS_CHAR
40: ,org_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
33: ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM
34: ,name OKL_ST_GEN_PRC_PARAMS.NAME%TYPE DEFAULT Okl_Api.G_MISS_CHAR
35: ,description OKL_ST_GEN_PRC_PARAMS.DESCRIPTION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
36: ,display_yn OKL_ST_GEN_PRC_PARAMS.DISPLAY_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
37: ,update_yn OKL_ST_GEN_PRC_PARAMS.UPDATE_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
38: ,prc_eng_ident OKL_ST_GEN_PRC_PARAMS.PRC_ENG_IDENT%TYPE DEFAULT Okl_Api.G_MISS_CHAR
39: ,default_value OKL_ST_GEN_PRC_PARAMS.DEFAULT_VALUE%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
34: ,name OKL_ST_GEN_PRC_PARAMS.NAME%TYPE DEFAULT Okl_Api.G_MISS_CHAR
35: ,description OKL_ST_GEN_PRC_PARAMS.DESCRIPTION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
36: ,display_yn OKL_ST_GEN_PRC_PARAMS.DISPLAY_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
37: ,update_yn OKL_ST_GEN_PRC_PARAMS.UPDATE_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
38: ,prc_eng_ident OKL_ST_GEN_PRC_PARAMS.PRC_ENG_IDENT%TYPE DEFAULT Okl_Api.G_MISS_CHAR
39: ,default_value OKL_ST_GEN_PRC_PARAMS.DEFAULT_VALUE%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_PRC_PARAMS.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
35: ,description OKL_ST_GEN_PRC_PARAMS.DESCRIPTION%TYPE DEFAULT Okl_Api.G_MISS_CHAR
36: ,display_yn OKL_ST_GEN_PRC_PARAMS.DISPLAY_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
37: ,update_yn OKL_ST_GEN_PRC_PARAMS.UPDATE_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
38: ,prc_eng_ident OKL_ST_GEN_PRC_PARAMS.PRC_ENG_IDENT%TYPE DEFAULT Okl_Api.G_MISS_CHAR
39: ,default_value OKL_ST_GEN_PRC_PARAMS.DEFAULT_VALUE%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_PRC_PARAMS.CREATION_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
43: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
36: ,display_yn OKL_ST_GEN_PRC_PARAMS.DISPLAY_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
37: ,update_yn OKL_ST_GEN_PRC_PARAMS.UPDATE_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
38: ,prc_eng_ident OKL_ST_GEN_PRC_PARAMS.PRC_ENG_IDENT%TYPE DEFAULT Okl_Api.G_MISS_CHAR
39: ,default_value OKL_ST_GEN_PRC_PARAMS.DEFAULT_VALUE%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_PRC_PARAMS.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_PRC_PARAMS.LAST_UPDATE_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
37: ,update_yn OKL_ST_GEN_PRC_PARAMS.UPDATE_YN%TYPE DEFAULT Okl_Api.G_MISS_CHAR
38: ,prc_eng_ident OKL_ST_GEN_PRC_PARAMS.PRC_ENG_IDENT%TYPE DEFAULT Okl_Api.G_MISS_CHAR
39: ,default_value OKL_ST_GEN_PRC_PARAMS.DEFAULT_VALUE%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_PRC_PARAMS.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_PRC_PARAMS.LAST_UPDATE_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
45: ,last_update_login NUMBER DEFAULT Okl_Api.G_MISS_NUM
38: ,prc_eng_ident OKL_ST_GEN_PRC_PARAMS.PRC_ENG_IDENT%TYPE DEFAULT Okl_Api.G_MISS_CHAR
39: ,default_value OKL_ST_GEN_PRC_PARAMS.DEFAULT_VALUE%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_PRC_PARAMS.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_PRC_PARAMS.LAST_UPDATE_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
45: ,last_update_login NUMBER DEFAULT Okl_Api.G_MISS_NUM
46: ,gtt_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
39: ,default_value OKL_ST_GEN_PRC_PARAMS.DEFAULT_VALUE%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_PRC_PARAMS.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_PRC_PARAMS.LAST_UPDATE_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
45: ,last_update_login NUMBER DEFAULT Okl_Api.G_MISS_NUM
46: ,gtt_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
47: );
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_PRC_PARAMS.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_PRC_PARAMS.LAST_UPDATE_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
45: ,last_update_login NUMBER DEFAULT Okl_Api.G_MISS_NUM
46: ,gtt_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
47: );
48:
41: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
42: ,creation_date OKL_ST_GEN_PRC_PARAMS.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_PRC_PARAMS.LAST_UPDATE_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
45: ,last_update_login NUMBER DEFAULT Okl_Api.G_MISS_NUM
46: ,gtt_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
47: );
48:
49:
42: ,creation_date OKL_ST_GEN_PRC_PARAMS.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_PRC_PARAMS.LAST_UPDATE_DATE%TYPE DEFAULT Okl_Api.G_MISS_DATE
45: ,last_update_login NUMBER DEFAULT Okl_Api.G_MISS_NUM
46: ,gtt_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
47: );
48:
49:
50: G_MISS_gtpv_REC gtpv_rec_type;
54: ---------------------------------------------------------------------------
55: -- GLOBAL VARIABLES
56: ---------------------------------------------------------------------------
57: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_GTP_PVT';
58: G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
59: --------------------------------------------------------------------------------
60: -- ERRORS AND EXCEPTIONS
61: --------------------------------------------------------------------------------
62: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
66: -- Adding MESSAGE CONSTANTs for 'Unique Key Validation','SQLCode', 'SQLErrM'
67: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
68: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
69: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
70: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
71: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
72: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
73: ---------------------------------------------------------------------------
74: -- Procedures and Functions
67: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
68: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
69: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
70: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
71: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
72: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
73: ---------------------------------------------------------------------------
74: -- Procedures and Functions
75: ---------------------------------------------------------------------------
68: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
69: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
70: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
71: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
72: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
73: ---------------------------------------------------------------------------
74: -- Procedures and Functions
75: ---------------------------------------------------------------------------
76: PROCEDURE qc;
79:
80:
81: PROCEDURE insert_row(
82: p_api_version IN NUMBER,
83: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
84: x_return_status OUT NOCOPY VARCHAR2,
85: x_msg_count OUT NOCOPY NUMBER,
86: x_msg_data OUT NOCOPY VARCHAR2,
87: p_gtpv_rec IN gtpv_rec_type,
88: x_gtpv_rec OUT NOCOPY gtpv_rec_type );
89:
90: PROCEDURE insert_row(
91: p_api_version IN NUMBER,
92: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
93: x_return_status OUT NOCOPY VARCHAR2,
94: x_msg_count OUT NOCOPY NUMBER,
95: x_msg_data OUT NOCOPY VARCHAR2,
96: p_gtpv_tbl IN gtpv_tbl_type,
97: x_gtpv_tbl OUT NOCOPY gtpv_tbl_type);
98:
99: PROCEDURE update_row(
100: p_api_version IN NUMBER,
101: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
102: x_return_status OUT NOCOPY VARCHAR2,
103: x_msg_count OUT NOCOPY NUMBER,
104: x_msg_data OUT NOCOPY VARCHAR2,
105: p_gtpv_rec IN gtpv_rec_type,
106: x_gtpv_rec OUT NOCOPY gtpv_rec_type);
107:
108: PROCEDURE update_row(
109: p_api_version IN NUMBER,
110: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
111: x_return_status OUT NOCOPY VARCHAR2,
112: x_msg_count OUT NOCOPY NUMBER,
113: x_msg_data OUT NOCOPY VARCHAR2,
114: p_gtpv_tbl IN gtpv_tbl_type,
115: x_gtpv_tbl OUT NOCOPY gtpv_tbl_type);
116:
117: PROCEDURE delete_row(
118: p_api_version IN NUMBER,
119: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
120: x_return_status OUT NOCOPY VARCHAR2,
121: x_msg_count OUT NOCOPY NUMBER,
122: x_msg_data OUT NOCOPY VARCHAR2,
123: p_gtpv_rec IN gtpv_rec_type);
123: p_gtpv_rec IN gtpv_rec_type);
124:
125: PROCEDURE delete_row(
126: p_api_version IN NUMBER,
127: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
128: x_return_status OUT NOCOPY VARCHAR2,
129: x_msg_count OUT NOCOPY NUMBER,
130: x_msg_data OUT NOCOPY VARCHAR2,
131: p_gtpv_tbl IN gtpv_tbl_type);