5: -- GLOBAL DATASTRUCTURES
6: ---------------------------------------------------------------------------
7:
8: TYPE gtl_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: ,gtt_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
12: ,primary_yn OKL_ST_GEN_TMPT_LNS.primary_yn%TYPE DEFAULT Okl_Api.G_MISS_CHAR
13: ,primary_sty_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
6: ---------------------------------------------------------------------------
7:
8: TYPE gtl_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: ,gtt_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
12: ,primary_yn OKL_ST_GEN_TMPT_LNS.primary_yn%TYPE DEFAULT Okl_Api.G_MISS_CHAR
13: ,primary_sty_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
14: ,dependent_sty_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
7:
8: TYPE gtl_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: ,gtt_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
12: ,primary_yn OKL_ST_GEN_TMPT_LNS.primary_yn%TYPE DEFAULT Okl_Api.G_MISS_CHAR
13: ,primary_sty_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
14: ,dependent_sty_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
15: ,pricing_name OKL_ST_GEN_TMPT_LNS.pricing_name%TYPE DEFAULT Okl_Api.G_MISS_CHAR
8: TYPE gtl_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: ,gtt_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
12: ,primary_yn OKL_ST_GEN_TMPT_LNS.primary_yn%TYPE DEFAULT Okl_Api.G_MISS_CHAR
13: ,primary_sty_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
14: ,dependent_sty_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
15: ,pricing_name OKL_ST_GEN_TMPT_LNS.pricing_name%TYPE DEFAULT Okl_Api.G_MISS_CHAR
16: ,org_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
9: id NUMBER DEFAULT Okl_Api.G_MISS_NUM
10: ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM
11: ,gtt_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
12: ,primary_yn OKL_ST_GEN_TMPT_LNS.primary_yn%TYPE DEFAULT Okl_Api.G_MISS_CHAR
13: ,primary_sty_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
14: ,dependent_sty_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
15: ,pricing_name OKL_ST_GEN_TMPT_LNS.pricing_name%TYPE DEFAULT Okl_Api.G_MISS_CHAR
16: ,org_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
17: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
10: ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM
11: ,gtt_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
12: ,primary_yn OKL_ST_GEN_TMPT_LNS.primary_yn%TYPE DEFAULT Okl_Api.G_MISS_CHAR
13: ,primary_sty_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
14: ,dependent_sty_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
15: ,pricing_name OKL_ST_GEN_TMPT_LNS.pricing_name%TYPE DEFAULT Okl_Api.G_MISS_CHAR
16: ,org_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
17: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
18: ,creation_date OKL_ST_GEN_TMPT_LNS.creation_date%TYPE DEFAULT Okl_Api.G_MISS_DATE
11: ,gtt_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
12: ,primary_yn OKL_ST_GEN_TMPT_LNS.primary_yn%TYPE DEFAULT Okl_Api.G_MISS_CHAR
13: ,primary_sty_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
14: ,dependent_sty_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
15: ,pricing_name OKL_ST_GEN_TMPT_LNS.pricing_name%TYPE DEFAULT Okl_Api.G_MISS_CHAR
16: ,org_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
17: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
18: ,creation_date OKL_ST_GEN_TMPT_LNS.creation_date%TYPE DEFAULT Okl_Api.G_MISS_DATE
19: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
12: ,primary_yn OKL_ST_GEN_TMPT_LNS.primary_yn%TYPE DEFAULT Okl_Api.G_MISS_CHAR
13: ,primary_sty_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
14: ,dependent_sty_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
15: ,pricing_name OKL_ST_GEN_TMPT_LNS.pricing_name%TYPE DEFAULT Okl_Api.G_MISS_CHAR
16: ,org_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
17: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
18: ,creation_date OKL_ST_GEN_TMPT_LNS.creation_date%TYPE DEFAULT Okl_Api.G_MISS_DATE
19: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
20: ,last_update_date OKL_ST_GEN_TMPT_LNS.last_update_date%TYPE DEFAULT Okl_Api.G_MISS_DATE
13: ,primary_sty_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
14: ,dependent_sty_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
15: ,pricing_name OKL_ST_GEN_TMPT_LNS.pricing_name%TYPE DEFAULT Okl_Api.G_MISS_CHAR
16: ,org_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
17: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
18: ,creation_date OKL_ST_GEN_TMPT_LNS.creation_date%TYPE DEFAULT Okl_Api.G_MISS_DATE
19: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
20: ,last_update_date OKL_ST_GEN_TMPT_LNS.last_update_date%TYPE DEFAULT Okl_Api.G_MISS_DATE
21: ,last_update_login NUMBER DEFAULT Okl_Api.G_MISS_NUM
14: ,dependent_sty_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
15: ,pricing_name OKL_ST_GEN_TMPT_LNS.pricing_name%TYPE DEFAULT Okl_Api.G_MISS_CHAR
16: ,org_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
17: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
18: ,creation_date OKL_ST_GEN_TMPT_LNS.creation_date%TYPE DEFAULT Okl_Api.G_MISS_DATE
19: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
20: ,last_update_date OKL_ST_GEN_TMPT_LNS.last_update_date%TYPE DEFAULT Okl_Api.G_MISS_DATE
21: ,last_update_login NUMBER DEFAULT Okl_Api.G_MISS_NUM
22: );
15: ,pricing_name OKL_ST_GEN_TMPT_LNS.pricing_name%TYPE DEFAULT Okl_Api.G_MISS_CHAR
16: ,org_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
17: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
18: ,creation_date OKL_ST_GEN_TMPT_LNS.creation_date%TYPE DEFAULT Okl_Api.G_MISS_DATE
19: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
20: ,last_update_date OKL_ST_GEN_TMPT_LNS.last_update_date%TYPE DEFAULT Okl_Api.G_MISS_DATE
21: ,last_update_login NUMBER DEFAULT Okl_Api.G_MISS_NUM
22: );
23:
16: ,org_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
17: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
18: ,creation_date OKL_ST_GEN_TMPT_LNS.creation_date%TYPE DEFAULT Okl_Api.G_MISS_DATE
19: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
20: ,last_update_date OKL_ST_GEN_TMPT_LNS.last_update_date%TYPE DEFAULT Okl_Api.G_MISS_DATE
21: ,last_update_login NUMBER DEFAULT Okl_Api.G_MISS_NUM
22: );
23:
24:
17: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
18: ,creation_date OKL_ST_GEN_TMPT_LNS.creation_date%TYPE DEFAULT Okl_Api.G_MISS_DATE
19: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
20: ,last_update_date OKL_ST_GEN_TMPT_LNS.last_update_date%TYPE DEFAULT Okl_Api.G_MISS_DATE
21: ,last_update_login NUMBER DEFAULT Okl_Api.G_MISS_NUM
22: );
23:
24:
25: G_MISS_GTL_REC gtl_rec_type;
26: TYPE gtl_tbl_type IS TABLE OF gtl_rec_type
27: INDEX BY BINARY_INTEGER;
28:
29: TYPE gtlv_rec_type IS RECORD (
30: id NUMBER DEFAULT Okl_Api.G_MISS_NUM
31: ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM
32: ,gtt_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
33: ,primary_yn OKL_ST_GEN_TMPT_LNS.primary_yn%TYPE DEFAULT Okl_Api.G_MISS_CHAR
34: ,primary_sty_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
27: INDEX BY BINARY_INTEGER;
28:
29: TYPE gtlv_rec_type IS RECORD (
30: id NUMBER DEFAULT Okl_Api.G_MISS_NUM
31: ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM
32: ,gtt_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
33: ,primary_yn OKL_ST_GEN_TMPT_LNS.primary_yn%TYPE DEFAULT Okl_Api.G_MISS_CHAR
34: ,primary_sty_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
35: ,dependent_sty_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
28:
29: TYPE gtlv_rec_type IS RECORD (
30: id NUMBER DEFAULT Okl_Api.G_MISS_NUM
31: ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM
32: ,gtt_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
33: ,primary_yn OKL_ST_GEN_TMPT_LNS.primary_yn%TYPE DEFAULT Okl_Api.G_MISS_CHAR
34: ,primary_sty_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
35: ,dependent_sty_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
36: ,pricing_name OKL_ST_GEN_TMPT_LNS.pricing_name%TYPE DEFAULT Okl_Api.G_MISS_CHAR
29: TYPE gtlv_rec_type IS RECORD (
30: id NUMBER DEFAULT Okl_Api.G_MISS_NUM
31: ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM
32: ,gtt_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
33: ,primary_yn OKL_ST_GEN_TMPT_LNS.primary_yn%TYPE DEFAULT Okl_Api.G_MISS_CHAR
34: ,primary_sty_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
35: ,dependent_sty_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
36: ,pricing_name OKL_ST_GEN_TMPT_LNS.pricing_name%TYPE DEFAULT Okl_Api.G_MISS_CHAR
37: ,org_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
30: id NUMBER DEFAULT Okl_Api.G_MISS_NUM
31: ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM
32: ,gtt_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
33: ,primary_yn OKL_ST_GEN_TMPT_LNS.primary_yn%TYPE DEFAULT Okl_Api.G_MISS_CHAR
34: ,primary_sty_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
35: ,dependent_sty_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
36: ,pricing_name OKL_ST_GEN_TMPT_LNS.pricing_name%TYPE DEFAULT Okl_Api.G_MISS_CHAR
37: ,org_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
38: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
31: ,object_version_number NUMBER DEFAULT Okl_Api.G_MISS_NUM
32: ,gtt_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
33: ,primary_yn OKL_ST_GEN_TMPT_LNS.primary_yn%TYPE DEFAULT Okl_Api.G_MISS_CHAR
34: ,primary_sty_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
35: ,dependent_sty_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
36: ,pricing_name OKL_ST_GEN_TMPT_LNS.pricing_name%TYPE DEFAULT Okl_Api.G_MISS_CHAR
37: ,org_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
38: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
39: ,creation_date OKL_ST_GEN_TMPT_LNS.creation_date%TYPE DEFAULT Okl_Api.G_MISS_DATE
32: ,gtt_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
33: ,primary_yn OKL_ST_GEN_TMPT_LNS.primary_yn%TYPE DEFAULT Okl_Api.G_MISS_CHAR
34: ,primary_sty_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
35: ,dependent_sty_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
36: ,pricing_name OKL_ST_GEN_TMPT_LNS.pricing_name%TYPE DEFAULT Okl_Api.G_MISS_CHAR
37: ,org_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
38: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
39: ,creation_date OKL_ST_GEN_TMPT_LNS.creation_date%TYPE DEFAULT Okl_Api.G_MISS_DATE
40: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
33: ,primary_yn OKL_ST_GEN_TMPT_LNS.primary_yn%TYPE DEFAULT Okl_Api.G_MISS_CHAR
34: ,primary_sty_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
35: ,dependent_sty_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
36: ,pricing_name OKL_ST_GEN_TMPT_LNS.pricing_name%TYPE DEFAULT Okl_Api.G_MISS_CHAR
37: ,org_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
38: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
39: ,creation_date OKL_ST_GEN_TMPT_LNS.creation_date%TYPE DEFAULT Okl_Api.G_MISS_DATE
40: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
41: ,last_update_date OKL_ST_GEN_TMPT_LNS.last_update_date%TYPE DEFAULT Okl_Api.G_MISS_DATE
34: ,primary_sty_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
35: ,dependent_sty_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
36: ,pricing_name OKL_ST_GEN_TMPT_LNS.pricing_name%TYPE DEFAULT Okl_Api.G_MISS_CHAR
37: ,org_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
38: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
39: ,creation_date OKL_ST_GEN_TMPT_LNS.creation_date%TYPE DEFAULT Okl_Api.G_MISS_DATE
40: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
41: ,last_update_date OKL_ST_GEN_TMPT_LNS.last_update_date%TYPE DEFAULT Okl_Api.G_MISS_DATE
42: ,last_update_login NUMBER DEFAULT Okl_Api.G_MISS_NUM
35: ,dependent_sty_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
36: ,pricing_name OKL_ST_GEN_TMPT_LNS.pricing_name%TYPE DEFAULT Okl_Api.G_MISS_CHAR
37: ,org_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
38: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
39: ,creation_date OKL_ST_GEN_TMPT_LNS.creation_date%TYPE DEFAULT Okl_Api.G_MISS_DATE
40: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
41: ,last_update_date OKL_ST_GEN_TMPT_LNS.last_update_date%TYPE DEFAULT Okl_Api.G_MISS_DATE
42: ,last_update_login NUMBER DEFAULT Okl_Api.G_MISS_NUM
43: );
36: ,pricing_name OKL_ST_GEN_TMPT_LNS.pricing_name%TYPE DEFAULT Okl_Api.G_MISS_CHAR
37: ,org_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
38: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
39: ,creation_date OKL_ST_GEN_TMPT_LNS.creation_date%TYPE DEFAULT Okl_Api.G_MISS_DATE
40: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
41: ,last_update_date OKL_ST_GEN_TMPT_LNS.last_update_date%TYPE DEFAULT Okl_Api.G_MISS_DATE
42: ,last_update_login NUMBER DEFAULT Okl_Api.G_MISS_NUM
43: );
44:
37: ,org_id NUMBER DEFAULT Okl_Api.G_MISS_NUM
38: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
39: ,creation_date OKL_ST_GEN_TMPT_LNS.creation_date%TYPE DEFAULT Okl_Api.G_MISS_DATE
40: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
41: ,last_update_date OKL_ST_GEN_TMPT_LNS.last_update_date%TYPE DEFAULT Okl_Api.G_MISS_DATE
42: ,last_update_login NUMBER DEFAULT Okl_Api.G_MISS_NUM
43: );
44:
45:
38: ,created_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
39: ,creation_date OKL_ST_GEN_TMPT_LNS.creation_date%TYPE DEFAULT Okl_Api.G_MISS_DATE
40: ,last_updated_by NUMBER DEFAULT Okl_Api.G_MISS_NUM
41: ,last_update_date OKL_ST_GEN_TMPT_LNS.last_update_date%TYPE DEFAULT Okl_Api.G_MISS_DATE
42: ,last_update_login NUMBER DEFAULT Okl_Api.G_MISS_NUM
43: );
44:
45:
46: G_MISS_GTLV_REC gtlv_rec_type;
50: ---------------------------------------------------------------------------
51: -- GLOBAL VARIABLES
52: ---------------------------------------------------------------------------
53: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_GTL_PVT';
54: G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
55: --------------------------------------------------------------------------------
56: -- ERRORS AND EXCEPTIONS
57: --------------------------------------------------------------------------------
58: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
62: -- Adding MESSAGE CONSTANTs for 'Unique Key Validation','SQLCode', 'SQLErrM'
63: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
64: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
65: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
66: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
67: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
68: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
69: ---------------------------------------------------------------------------
70: -- Procedures and Functions
63: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
64: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
65: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
66: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
67: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
68: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
69: ---------------------------------------------------------------------------
70: -- Procedures and Functions
71: ---------------------------------------------------------------------------
64: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
65: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
66: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
67: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
68: G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
69: ---------------------------------------------------------------------------
70: -- Procedures and Functions
71: ---------------------------------------------------------------------------
72: PROCEDURE qc;
75:
76:
77: PROCEDURE insert_row(
78: p_api_version IN NUMBER,
79: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
80: x_return_status OUT NOCOPY VARCHAR2,
81: x_msg_count OUT NOCOPY NUMBER,
82: x_msg_data OUT NOCOPY VARCHAR2,
83: p_gtlv_rec IN gtlv_rec_type,
84: x_gtlv_rec OUT NOCOPY gtlv_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_gtlv_tbl IN gtlv_tbl_type,
93: x_gtlv_tbl OUT NOCOPY gtlv_tbl_type);
94:
95: PROCEDURE update_row(
96: p_api_version IN NUMBER,
97: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
98: x_return_status OUT NOCOPY VARCHAR2,
99: x_msg_count OUT NOCOPY NUMBER,
100: x_msg_data OUT NOCOPY VARCHAR2,
101: p_gtlv_rec IN gtlv_rec_type,
102: x_gtlv_rec OUT NOCOPY gtlv_rec_type);
103:
104: PROCEDURE update_row(
105: p_api_version IN NUMBER,
106: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
107: x_return_status OUT NOCOPY VARCHAR2,
108: x_msg_count OUT NOCOPY NUMBER,
109: x_msg_data OUT NOCOPY VARCHAR2,
110: p_gtlv_tbl IN gtlv_tbl_type,
111: x_gtlv_tbl OUT NOCOPY gtlv_tbl_type);
112:
113: PROCEDURE delete_row(
114: p_api_version IN NUMBER,
115: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
116: x_return_status OUT NOCOPY VARCHAR2,
117: x_msg_count OUT NOCOPY NUMBER,
118: x_msg_data OUT NOCOPY VARCHAR2,
119: p_gtlv_rec IN gtlv_rec_type);
119: p_gtlv_rec IN gtlv_rec_type);
120:
121: PROCEDURE delete_row(
122: p_api_version IN NUMBER,
123: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
124: x_return_status OUT NOCOPY VARCHAR2,
125: x_msg_count OUT NOCOPY NUMBER,
126: x_msg_data OUT NOCOPY VARCHAR2,
127: p_gtlv_tbl IN gtlv_tbl_type);