[Home] [Help]
90: null;
91: END api_copy;
92:
93: ---------------------------------------------------------------------------
94: -- FUNCTION get_rec for: OKS_BILLRATE_SCHEDULES_V
95: ---------------------------------------------------------------------------
96: FUNCTION get_rec (
97: p_oks_billrate_schedules_v_rec IN OksBillrateSchedulesVRecType,
98: x_no_data_found OUT NOCOPY BOOLEAN
93: ---------------------------------------------------------------------------
94: -- FUNCTION get_rec for: OKS_BILLRATE_SCHEDULES_V
95: ---------------------------------------------------------------------------
96: FUNCTION get_rec (
97: p_oks_billrate_schedules_v_rec IN OksBillrateSchedulesVRecType,
98: x_no_data_found OUT NOCOPY BOOLEAN
99: ) RETURN OksBillrateSchedulesVRecType IS
100: CURSOR oks_brsv_pk_csr (p_id IN NUMBER) IS
101: SELECT
132: LAST_UPDATE_DATE,
133: LAST_UPDATE_LOGIN,
134: OBJECT_VERSION_NUMBER,
135: SECURITY_GROUP_ID
136: FROM Oks_Billrate_Schedules_V
137: WHERE oks_billrate_schedules_v.id = p_id;
138: l_oks_brsv_pk oks_brsv_pk_csr%ROWTYPE;
139: l_oks_billrate_schedules_v_rec OksBillrateSchedulesVRecType;
140: BEGIN
133: LAST_UPDATE_LOGIN,
134: OBJECT_VERSION_NUMBER,
135: SECURITY_GROUP_ID
136: FROM Oks_Billrate_Schedules_V
137: WHERE oks_billrate_schedules_v.id = p_id;
138: l_oks_brsv_pk oks_brsv_pk_csr%ROWTYPE;
139: l_oks_billrate_schedules_v_rec OksBillrateSchedulesVRecType;
140: BEGIN
141: x_no_data_found := TRUE;
135: SECURITY_GROUP_ID
136: FROM Oks_Billrate_Schedules_V
137: WHERE oks_billrate_schedules_v.id = p_id;
138: l_oks_brsv_pk oks_brsv_pk_csr%ROWTYPE;
139: l_oks_billrate_schedules_v_rec OksBillrateSchedulesVRecType;
140: BEGIN
141: x_no_data_found := TRUE;
142: -- Get current database values
143: OPEN oks_brsv_pk_csr (p_oks_billrate_schedules_v_rec.id);
139: l_oks_billrate_schedules_v_rec OksBillrateSchedulesVRecType;
140: BEGIN
141: x_no_data_found := TRUE;
142: -- Get current database values
143: OPEN oks_brsv_pk_csr (p_oks_billrate_schedules_v_rec.id);
144: FETCH oks_brsv_pk_csr INTO
145: l_oks_billrate_schedules_v_rec.id,
146: l_oks_billrate_schedules_v_rec.cle_id,
147: l_oks_billrate_schedules_v_rec.bt_cle_id,
141: x_no_data_found := TRUE;
142: -- Get current database values
143: OPEN oks_brsv_pk_csr (p_oks_billrate_schedules_v_rec.id);
144: FETCH oks_brsv_pk_csr INTO
145: l_oks_billrate_schedules_v_rec.id,
146: l_oks_billrate_schedules_v_rec.cle_id,
147: l_oks_billrate_schedules_v_rec.bt_cle_id,
148: l_oks_billrate_schedules_v_rec.dnz_chr_id,
149: l_oks_billrate_schedules_v_rec.start_hour,
142: -- Get current database values
143: OPEN oks_brsv_pk_csr (p_oks_billrate_schedules_v_rec.id);
144: FETCH oks_brsv_pk_csr INTO
145: l_oks_billrate_schedules_v_rec.id,
146: l_oks_billrate_schedules_v_rec.cle_id,
147: l_oks_billrate_schedules_v_rec.bt_cle_id,
148: l_oks_billrate_schedules_v_rec.dnz_chr_id,
149: l_oks_billrate_schedules_v_rec.start_hour,
150: l_oks_billrate_schedules_v_rec.start_minute,
143: OPEN oks_brsv_pk_csr (p_oks_billrate_schedules_v_rec.id);
144: FETCH oks_brsv_pk_csr INTO
145: l_oks_billrate_schedules_v_rec.id,
146: l_oks_billrate_schedules_v_rec.cle_id,
147: l_oks_billrate_schedules_v_rec.bt_cle_id,
148: l_oks_billrate_schedules_v_rec.dnz_chr_id,
149: l_oks_billrate_schedules_v_rec.start_hour,
150: l_oks_billrate_schedules_v_rec.start_minute,
151: l_oks_billrate_schedules_v_rec.end_hour,
144: FETCH oks_brsv_pk_csr INTO
145: l_oks_billrate_schedules_v_rec.id,
146: l_oks_billrate_schedules_v_rec.cle_id,
147: l_oks_billrate_schedules_v_rec.bt_cle_id,
148: l_oks_billrate_schedules_v_rec.dnz_chr_id,
149: l_oks_billrate_schedules_v_rec.start_hour,
150: l_oks_billrate_schedules_v_rec.start_minute,
151: l_oks_billrate_schedules_v_rec.end_hour,
152: l_oks_billrate_schedules_v_rec.end_minute,
145: l_oks_billrate_schedules_v_rec.id,
146: l_oks_billrate_schedules_v_rec.cle_id,
147: l_oks_billrate_schedules_v_rec.bt_cle_id,
148: l_oks_billrate_schedules_v_rec.dnz_chr_id,
149: l_oks_billrate_schedules_v_rec.start_hour,
150: l_oks_billrate_schedules_v_rec.start_minute,
151: l_oks_billrate_schedules_v_rec.end_hour,
152: l_oks_billrate_schedules_v_rec.end_minute,
153: l_oks_billrate_schedules_v_rec.monday_flag,
146: l_oks_billrate_schedules_v_rec.cle_id,
147: l_oks_billrate_schedules_v_rec.bt_cle_id,
148: l_oks_billrate_schedules_v_rec.dnz_chr_id,
149: l_oks_billrate_schedules_v_rec.start_hour,
150: l_oks_billrate_schedules_v_rec.start_minute,
151: l_oks_billrate_schedules_v_rec.end_hour,
152: l_oks_billrate_schedules_v_rec.end_minute,
153: l_oks_billrate_schedules_v_rec.monday_flag,
154: l_oks_billrate_schedules_v_rec.tuesday_flag,
147: l_oks_billrate_schedules_v_rec.bt_cle_id,
148: l_oks_billrate_schedules_v_rec.dnz_chr_id,
149: l_oks_billrate_schedules_v_rec.start_hour,
150: l_oks_billrate_schedules_v_rec.start_minute,
151: l_oks_billrate_schedules_v_rec.end_hour,
152: l_oks_billrate_schedules_v_rec.end_minute,
153: l_oks_billrate_schedules_v_rec.monday_flag,
154: l_oks_billrate_schedules_v_rec.tuesday_flag,
155: l_oks_billrate_schedules_v_rec.wednesday_flag,
148: l_oks_billrate_schedules_v_rec.dnz_chr_id,
149: l_oks_billrate_schedules_v_rec.start_hour,
150: l_oks_billrate_schedules_v_rec.start_minute,
151: l_oks_billrate_schedules_v_rec.end_hour,
152: l_oks_billrate_schedules_v_rec.end_minute,
153: l_oks_billrate_schedules_v_rec.monday_flag,
154: l_oks_billrate_schedules_v_rec.tuesday_flag,
155: l_oks_billrate_schedules_v_rec.wednesday_flag,
156: l_oks_billrate_schedules_v_rec.thursday_flag,
149: l_oks_billrate_schedules_v_rec.start_hour,
150: l_oks_billrate_schedules_v_rec.start_minute,
151: l_oks_billrate_schedules_v_rec.end_hour,
152: l_oks_billrate_schedules_v_rec.end_minute,
153: l_oks_billrate_schedules_v_rec.monday_flag,
154: l_oks_billrate_schedules_v_rec.tuesday_flag,
155: l_oks_billrate_schedules_v_rec.wednesday_flag,
156: l_oks_billrate_schedules_v_rec.thursday_flag,
157: l_oks_billrate_schedules_v_rec.friday_flag,
150: l_oks_billrate_schedules_v_rec.start_minute,
151: l_oks_billrate_schedules_v_rec.end_hour,
152: l_oks_billrate_schedules_v_rec.end_minute,
153: l_oks_billrate_schedules_v_rec.monday_flag,
154: l_oks_billrate_schedules_v_rec.tuesday_flag,
155: l_oks_billrate_schedules_v_rec.wednesday_flag,
156: l_oks_billrate_schedules_v_rec.thursday_flag,
157: l_oks_billrate_schedules_v_rec.friday_flag,
158: l_oks_billrate_schedules_v_rec.saturday_flag,
151: l_oks_billrate_schedules_v_rec.end_hour,
152: l_oks_billrate_schedules_v_rec.end_minute,
153: l_oks_billrate_schedules_v_rec.monday_flag,
154: l_oks_billrate_schedules_v_rec.tuesday_flag,
155: l_oks_billrate_schedules_v_rec.wednesday_flag,
156: l_oks_billrate_schedules_v_rec.thursday_flag,
157: l_oks_billrate_schedules_v_rec.friday_flag,
158: l_oks_billrate_schedules_v_rec.saturday_flag,
159: l_oks_billrate_schedules_v_rec.sunday_flag,
152: l_oks_billrate_schedules_v_rec.end_minute,
153: l_oks_billrate_schedules_v_rec.monday_flag,
154: l_oks_billrate_schedules_v_rec.tuesday_flag,
155: l_oks_billrate_schedules_v_rec.wednesday_flag,
156: l_oks_billrate_schedules_v_rec.thursday_flag,
157: l_oks_billrate_schedules_v_rec.friday_flag,
158: l_oks_billrate_schedules_v_rec.saturday_flag,
159: l_oks_billrate_schedules_v_rec.sunday_flag,
160: l_oks_billrate_schedules_v_rec.object1_id1,
153: l_oks_billrate_schedules_v_rec.monday_flag,
154: l_oks_billrate_schedules_v_rec.tuesday_flag,
155: l_oks_billrate_schedules_v_rec.wednesday_flag,
156: l_oks_billrate_schedules_v_rec.thursday_flag,
157: l_oks_billrate_schedules_v_rec.friday_flag,
158: l_oks_billrate_schedules_v_rec.saturday_flag,
159: l_oks_billrate_schedules_v_rec.sunday_flag,
160: l_oks_billrate_schedules_v_rec.object1_id1,
161: l_oks_billrate_schedules_v_rec.object1_id2,
154: l_oks_billrate_schedules_v_rec.tuesday_flag,
155: l_oks_billrate_schedules_v_rec.wednesday_flag,
156: l_oks_billrate_schedules_v_rec.thursday_flag,
157: l_oks_billrate_schedules_v_rec.friday_flag,
158: l_oks_billrate_schedules_v_rec.saturday_flag,
159: l_oks_billrate_schedules_v_rec.sunday_flag,
160: l_oks_billrate_schedules_v_rec.object1_id1,
161: l_oks_billrate_schedules_v_rec.object1_id2,
162: l_oks_billrate_schedules_v_rec.jtot_object1_code,
155: l_oks_billrate_schedules_v_rec.wednesday_flag,
156: l_oks_billrate_schedules_v_rec.thursday_flag,
157: l_oks_billrate_schedules_v_rec.friday_flag,
158: l_oks_billrate_schedules_v_rec.saturday_flag,
159: l_oks_billrate_schedules_v_rec.sunday_flag,
160: l_oks_billrate_schedules_v_rec.object1_id1,
161: l_oks_billrate_schedules_v_rec.object1_id2,
162: l_oks_billrate_schedules_v_rec.jtot_object1_code,
163: l_oks_billrate_schedules_v_rec.bill_rate_code,
156: l_oks_billrate_schedules_v_rec.thursday_flag,
157: l_oks_billrate_schedules_v_rec.friday_flag,
158: l_oks_billrate_schedules_v_rec.saturday_flag,
159: l_oks_billrate_schedules_v_rec.sunday_flag,
160: l_oks_billrate_schedules_v_rec.object1_id1,
161: l_oks_billrate_schedules_v_rec.object1_id2,
162: l_oks_billrate_schedules_v_rec.jtot_object1_code,
163: l_oks_billrate_schedules_v_rec.bill_rate_code,
164: l_oks_billrate_schedules_v_rec.uom,
157: l_oks_billrate_schedules_v_rec.friday_flag,
158: l_oks_billrate_schedules_v_rec.saturday_flag,
159: l_oks_billrate_schedules_v_rec.sunday_flag,
160: l_oks_billrate_schedules_v_rec.object1_id1,
161: l_oks_billrate_schedules_v_rec.object1_id2,
162: l_oks_billrate_schedules_v_rec.jtot_object1_code,
163: l_oks_billrate_schedules_v_rec.bill_rate_code,
164: l_oks_billrate_schedules_v_rec.uom,
165: l_oks_billrate_schedules_v_rec.flat_rate,
158: l_oks_billrate_schedules_v_rec.saturday_flag,
159: l_oks_billrate_schedules_v_rec.sunday_flag,
160: l_oks_billrate_schedules_v_rec.object1_id1,
161: l_oks_billrate_schedules_v_rec.object1_id2,
162: l_oks_billrate_schedules_v_rec.jtot_object1_code,
163: l_oks_billrate_schedules_v_rec.bill_rate_code,
164: l_oks_billrate_schedules_v_rec.uom,
165: l_oks_billrate_schedules_v_rec.flat_rate,
166: l_oks_billrate_schedules_v_rec.holiday_yn,
159: l_oks_billrate_schedules_v_rec.sunday_flag,
160: l_oks_billrate_schedules_v_rec.object1_id1,
161: l_oks_billrate_schedules_v_rec.object1_id2,
162: l_oks_billrate_schedules_v_rec.jtot_object1_code,
163: l_oks_billrate_schedules_v_rec.bill_rate_code,
164: l_oks_billrate_schedules_v_rec.uom,
165: l_oks_billrate_schedules_v_rec.flat_rate,
166: l_oks_billrate_schedules_v_rec.holiday_yn,
167: l_oks_billrate_schedules_v_rec.percent_over_list_price,
160: l_oks_billrate_schedules_v_rec.object1_id1,
161: l_oks_billrate_schedules_v_rec.object1_id2,
162: l_oks_billrate_schedules_v_rec.jtot_object1_code,
163: l_oks_billrate_schedules_v_rec.bill_rate_code,
164: l_oks_billrate_schedules_v_rec.uom,
165: l_oks_billrate_schedules_v_rec.flat_rate,
166: l_oks_billrate_schedules_v_rec.holiday_yn,
167: l_oks_billrate_schedules_v_rec.percent_over_list_price,
168: l_oks_billrate_schedules_v_rec.program_application_id,
161: l_oks_billrate_schedules_v_rec.object1_id2,
162: l_oks_billrate_schedules_v_rec.jtot_object1_code,
163: l_oks_billrate_schedules_v_rec.bill_rate_code,
164: l_oks_billrate_schedules_v_rec.uom,
165: l_oks_billrate_schedules_v_rec.flat_rate,
166: l_oks_billrate_schedules_v_rec.holiday_yn,
167: l_oks_billrate_schedules_v_rec.percent_over_list_price,
168: l_oks_billrate_schedules_v_rec.program_application_id,
169: l_oks_billrate_schedules_v_rec.program_id,
162: l_oks_billrate_schedules_v_rec.jtot_object1_code,
163: l_oks_billrate_schedules_v_rec.bill_rate_code,
164: l_oks_billrate_schedules_v_rec.uom,
165: l_oks_billrate_schedules_v_rec.flat_rate,
166: l_oks_billrate_schedules_v_rec.holiday_yn,
167: l_oks_billrate_schedules_v_rec.percent_over_list_price,
168: l_oks_billrate_schedules_v_rec.program_application_id,
169: l_oks_billrate_schedules_v_rec.program_id,
170: l_oks_billrate_schedules_v_rec.program_update_date,
163: l_oks_billrate_schedules_v_rec.bill_rate_code,
164: l_oks_billrate_schedules_v_rec.uom,
165: l_oks_billrate_schedules_v_rec.flat_rate,
166: l_oks_billrate_schedules_v_rec.holiday_yn,
167: l_oks_billrate_schedules_v_rec.percent_over_list_price,
168: l_oks_billrate_schedules_v_rec.program_application_id,
169: l_oks_billrate_schedules_v_rec.program_id,
170: l_oks_billrate_schedules_v_rec.program_update_date,
171: l_oks_billrate_schedules_v_rec.request_id,
164: l_oks_billrate_schedules_v_rec.uom,
165: l_oks_billrate_schedules_v_rec.flat_rate,
166: l_oks_billrate_schedules_v_rec.holiday_yn,
167: l_oks_billrate_schedules_v_rec.percent_over_list_price,
168: l_oks_billrate_schedules_v_rec.program_application_id,
169: l_oks_billrate_schedules_v_rec.program_id,
170: l_oks_billrate_schedules_v_rec.program_update_date,
171: l_oks_billrate_schedules_v_rec.request_id,
172: l_oks_billrate_schedules_v_rec.created_by,
165: l_oks_billrate_schedules_v_rec.flat_rate,
166: l_oks_billrate_schedules_v_rec.holiday_yn,
167: l_oks_billrate_schedules_v_rec.percent_over_list_price,
168: l_oks_billrate_schedules_v_rec.program_application_id,
169: l_oks_billrate_schedules_v_rec.program_id,
170: l_oks_billrate_schedules_v_rec.program_update_date,
171: l_oks_billrate_schedules_v_rec.request_id,
172: l_oks_billrate_schedules_v_rec.created_by,
173: l_oks_billrate_schedules_v_rec.creation_date,
166: l_oks_billrate_schedules_v_rec.holiday_yn,
167: l_oks_billrate_schedules_v_rec.percent_over_list_price,
168: l_oks_billrate_schedules_v_rec.program_application_id,
169: l_oks_billrate_schedules_v_rec.program_id,
170: l_oks_billrate_schedules_v_rec.program_update_date,
171: l_oks_billrate_schedules_v_rec.request_id,
172: l_oks_billrate_schedules_v_rec.created_by,
173: l_oks_billrate_schedules_v_rec.creation_date,
174: l_oks_billrate_schedules_v_rec.last_updated_by,
167: l_oks_billrate_schedules_v_rec.percent_over_list_price,
168: l_oks_billrate_schedules_v_rec.program_application_id,
169: l_oks_billrate_schedules_v_rec.program_id,
170: l_oks_billrate_schedules_v_rec.program_update_date,
171: l_oks_billrate_schedules_v_rec.request_id,
172: l_oks_billrate_schedules_v_rec.created_by,
173: l_oks_billrate_schedules_v_rec.creation_date,
174: l_oks_billrate_schedules_v_rec.last_updated_by,
175: l_oks_billrate_schedules_v_rec.last_update_date,
168: l_oks_billrate_schedules_v_rec.program_application_id,
169: l_oks_billrate_schedules_v_rec.program_id,
170: l_oks_billrate_schedules_v_rec.program_update_date,
171: l_oks_billrate_schedules_v_rec.request_id,
172: l_oks_billrate_schedules_v_rec.created_by,
173: l_oks_billrate_schedules_v_rec.creation_date,
174: l_oks_billrate_schedules_v_rec.last_updated_by,
175: l_oks_billrate_schedules_v_rec.last_update_date,
176: l_oks_billrate_schedules_v_rec.last_update_login,
169: l_oks_billrate_schedules_v_rec.program_id,
170: l_oks_billrate_schedules_v_rec.program_update_date,
171: l_oks_billrate_schedules_v_rec.request_id,
172: l_oks_billrate_schedules_v_rec.created_by,
173: l_oks_billrate_schedules_v_rec.creation_date,
174: l_oks_billrate_schedules_v_rec.last_updated_by,
175: l_oks_billrate_schedules_v_rec.last_update_date,
176: l_oks_billrate_schedules_v_rec.last_update_login,
177: l_oks_billrate_schedules_v_rec.object_version_number,
170: l_oks_billrate_schedules_v_rec.program_update_date,
171: l_oks_billrate_schedules_v_rec.request_id,
172: l_oks_billrate_schedules_v_rec.created_by,
173: l_oks_billrate_schedules_v_rec.creation_date,
174: l_oks_billrate_schedules_v_rec.last_updated_by,
175: l_oks_billrate_schedules_v_rec.last_update_date,
176: l_oks_billrate_schedules_v_rec.last_update_login,
177: l_oks_billrate_schedules_v_rec.object_version_number,
178: l_oks_billrate_schedules_v_rec.security_group_id;
171: l_oks_billrate_schedules_v_rec.request_id,
172: l_oks_billrate_schedules_v_rec.created_by,
173: l_oks_billrate_schedules_v_rec.creation_date,
174: l_oks_billrate_schedules_v_rec.last_updated_by,
175: l_oks_billrate_schedules_v_rec.last_update_date,
176: l_oks_billrate_schedules_v_rec.last_update_login,
177: l_oks_billrate_schedules_v_rec.object_version_number,
178: l_oks_billrate_schedules_v_rec.security_group_id;
179: x_no_data_found := oks_brsv_pk_csr%NOTFOUND;
172: l_oks_billrate_schedules_v_rec.created_by,
173: l_oks_billrate_schedules_v_rec.creation_date,
174: l_oks_billrate_schedules_v_rec.last_updated_by,
175: l_oks_billrate_schedules_v_rec.last_update_date,
176: l_oks_billrate_schedules_v_rec.last_update_login,
177: l_oks_billrate_schedules_v_rec.object_version_number,
178: l_oks_billrate_schedules_v_rec.security_group_id;
179: x_no_data_found := oks_brsv_pk_csr%NOTFOUND;
180: CLOSE oks_brsv_pk_csr;
173: l_oks_billrate_schedules_v_rec.creation_date,
174: l_oks_billrate_schedules_v_rec.last_updated_by,
175: l_oks_billrate_schedules_v_rec.last_update_date,
176: l_oks_billrate_schedules_v_rec.last_update_login,
177: l_oks_billrate_schedules_v_rec.object_version_number,
178: l_oks_billrate_schedules_v_rec.security_group_id;
179: x_no_data_found := oks_brsv_pk_csr%NOTFOUND;
180: CLOSE oks_brsv_pk_csr;
181: RETURN(l_oks_billrate_schedules_v_rec);
174: l_oks_billrate_schedules_v_rec.last_updated_by,
175: l_oks_billrate_schedules_v_rec.last_update_date,
176: l_oks_billrate_schedules_v_rec.last_update_login,
177: l_oks_billrate_schedules_v_rec.object_version_number,
178: l_oks_billrate_schedules_v_rec.security_group_id;
179: x_no_data_found := oks_brsv_pk_csr%NOTFOUND;
180: CLOSE oks_brsv_pk_csr;
181: RETURN(l_oks_billrate_schedules_v_rec);
182: END get_rec;
177: l_oks_billrate_schedules_v_rec.object_version_number,
178: l_oks_billrate_schedules_v_rec.security_group_id;
179: x_no_data_found := oks_brsv_pk_csr%NOTFOUND;
180: CLOSE oks_brsv_pk_csr;
181: RETURN(l_oks_billrate_schedules_v_rec);
182: END get_rec;
183:
184: ------------------------------------------------------------------
185: -- This version of get_rec sets error messages if no data found --
184: ------------------------------------------------------------------
185: -- This version of get_rec sets error messages if no data found --
186: ------------------------------------------------------------------
187: FUNCTION get_rec (
188: p_oks_billrate_schedules_v_rec IN OksBillrateSchedulesVRecType,
189: x_return_status OUT NOCOPY VARCHAR2
190: ) RETURN OksBillrateSchedulesVRecType IS
191: l_oks_billrate_schedules_v_rec OksBillrateSchedulesVRecType;
192: l_row_notfound BOOLEAN := TRUE;
187: FUNCTION get_rec (
188: p_oks_billrate_schedules_v_rec IN OksBillrateSchedulesVRecType,
189: x_return_status OUT NOCOPY VARCHAR2
190: ) RETURN OksBillrateSchedulesVRecType IS
191: l_oks_billrate_schedules_v_rec OksBillrateSchedulesVRecType;
192: l_row_notfound BOOLEAN := TRUE;
193: BEGIN
194: x_return_status := OKC_API.G_RET_STS_SUCCESS;
195: l_oks_billrate_schedules_v_rec := get_rec(p_oks_billrate_schedules_v_rec, l_row_notfound);
191: l_oks_billrate_schedules_v_rec OksBillrateSchedulesVRecType;
192: l_row_notfound BOOLEAN := TRUE;
193: BEGIN
194: x_return_status := OKC_API.G_RET_STS_SUCCESS;
195: l_oks_billrate_schedules_v_rec := get_rec(p_oks_billrate_schedules_v_rec, l_row_notfound);
196: IF (l_row_notfound) THEN
197: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
198: x_return_status := OKC_API.G_RET_STS_ERROR;
199: END IF;
196: IF (l_row_notfound) THEN
197: OKC_API.set_message(G_APP_NAME,G_INVALID_VALUE,G_COL_NAME_TOKEN,'ID');
198: x_return_status := OKC_API.G_RET_STS_ERROR;
199: END IF;
200: RETURN(l_oks_billrate_schedules_v_rec);
201: END get_rec;
202: -----------------------------------------------------------
203: -- So we don't have to pass an "l_row_notfound" variable --
204: -----------------------------------------------------------
202: -----------------------------------------------------------
203: -- So we don't have to pass an "l_row_notfound" variable --
204: -----------------------------------------------------------
205: FUNCTION get_rec (
206: p_oks_billrate_schedules_v_rec IN OksBillrateSchedulesVRecType
207: ) RETURN OksBillrateSchedulesVRecType IS
208: l_row_not_found BOOLEAN := TRUE;
209: BEGIN
210: RETURN(get_rec(p_oks_billrate_schedules_v_rec, l_row_not_found));
206: p_oks_billrate_schedules_v_rec IN OksBillrateSchedulesVRecType
207: ) RETURN OksBillrateSchedulesVRecType IS
208: l_row_not_found BOOLEAN := TRUE;
209: BEGIN
210: RETURN(get_rec(p_oks_billrate_schedules_v_rec, l_row_not_found));
211: END get_rec;
212: ---------------------------------------------------------------------------
213: -- FUNCTION get_rec for: OKS_BILLRATE_SCHEDULES
214: ---------------------------------------------------------------------------
326: BEGIN
327: RETURN(get_rec(p_oks_billrate_schedules_rec, l_row_not_found));
328: END get_rec;
329: ---------------------------------------------------------------------------
330: -- FUNCTION null_out_defaults for: OKS_BILLRATE_SCHEDULES_V
331: ---------------------------------------------------------------------------
332: FUNCTION null_out_defaults (
333: p_oks_billrate_schedules_v_rec IN OksBillrateSchedulesVRecType
334: ) RETURN OksBillrateSchedulesVRecType IS
329: ---------------------------------------------------------------------------
330: -- FUNCTION null_out_defaults for: OKS_BILLRATE_SCHEDULES_V
331: ---------------------------------------------------------------------------
332: FUNCTION null_out_defaults (
333: p_oks_billrate_schedules_v_rec IN OksBillrateSchedulesVRecType
334: ) RETURN OksBillrateSchedulesVRecType IS
335: l_oks_billrate_schedules_v_rec OksBillrateSchedulesVRecType := p_oks_billrate_schedules_v_rec;
336: BEGIN
337: IF (l_oks_billrate_schedules_v_rec.id = OKC_API.G_MISS_NUM ) THEN
331: ---------------------------------------------------------------------------
332: FUNCTION null_out_defaults (
333: p_oks_billrate_schedules_v_rec IN OksBillrateSchedulesVRecType
334: ) RETURN OksBillrateSchedulesVRecType IS
335: l_oks_billrate_schedules_v_rec OksBillrateSchedulesVRecType := p_oks_billrate_schedules_v_rec;
336: BEGIN
337: IF (l_oks_billrate_schedules_v_rec.id = OKC_API.G_MISS_NUM ) THEN
338: l_oks_billrate_schedules_v_rec.id := NULL;
339: END IF;
333: p_oks_billrate_schedules_v_rec IN OksBillrateSchedulesVRecType
334: ) RETURN OksBillrateSchedulesVRecType IS
335: l_oks_billrate_schedules_v_rec OksBillrateSchedulesVRecType := p_oks_billrate_schedules_v_rec;
336: BEGIN
337: IF (l_oks_billrate_schedules_v_rec.id = OKC_API.G_MISS_NUM ) THEN
338: l_oks_billrate_schedules_v_rec.id := NULL;
339: END IF;
340: IF (l_oks_billrate_schedules_v_rec.cle_id = OKC_API.G_MISS_NUM ) THEN
341: l_oks_billrate_schedules_v_rec.cle_id := NULL;
334: ) RETURN OksBillrateSchedulesVRecType IS
335: l_oks_billrate_schedules_v_rec OksBillrateSchedulesVRecType := p_oks_billrate_schedules_v_rec;
336: BEGIN
337: IF (l_oks_billrate_schedules_v_rec.id = OKC_API.G_MISS_NUM ) THEN
338: l_oks_billrate_schedules_v_rec.id := NULL;
339: END IF;
340: IF (l_oks_billrate_schedules_v_rec.cle_id = OKC_API.G_MISS_NUM ) THEN
341: l_oks_billrate_schedules_v_rec.cle_id := NULL;
342: END IF;
336: BEGIN
337: IF (l_oks_billrate_schedules_v_rec.id = OKC_API.G_MISS_NUM ) THEN
338: l_oks_billrate_schedules_v_rec.id := NULL;
339: END IF;
340: IF (l_oks_billrate_schedules_v_rec.cle_id = OKC_API.G_MISS_NUM ) THEN
341: l_oks_billrate_schedules_v_rec.cle_id := NULL;
342: END IF;
343: IF (l_oks_billrate_schedules_v_rec.bt_cle_id = OKC_API.G_MISS_NUM ) THEN
344: l_oks_billrate_schedules_v_rec.bt_cle_id := NULL;
337: IF (l_oks_billrate_schedules_v_rec.id = OKC_API.G_MISS_NUM ) THEN
338: l_oks_billrate_schedules_v_rec.id := NULL;
339: END IF;
340: IF (l_oks_billrate_schedules_v_rec.cle_id = OKC_API.G_MISS_NUM ) THEN
341: l_oks_billrate_schedules_v_rec.cle_id := NULL;
342: END IF;
343: IF (l_oks_billrate_schedules_v_rec.bt_cle_id = OKC_API.G_MISS_NUM ) THEN
344: l_oks_billrate_schedules_v_rec.bt_cle_id := NULL;
345: END IF;
339: END IF;
340: IF (l_oks_billrate_schedules_v_rec.cle_id = OKC_API.G_MISS_NUM ) THEN
341: l_oks_billrate_schedules_v_rec.cle_id := NULL;
342: END IF;
343: IF (l_oks_billrate_schedules_v_rec.bt_cle_id = OKC_API.G_MISS_NUM ) THEN
344: l_oks_billrate_schedules_v_rec.bt_cle_id := NULL;
345: END IF;
346: IF (l_oks_billrate_schedules_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM ) THEN
347: l_oks_billrate_schedules_v_rec.dnz_chr_id := NULL;
340: IF (l_oks_billrate_schedules_v_rec.cle_id = OKC_API.G_MISS_NUM ) THEN
341: l_oks_billrate_schedules_v_rec.cle_id := NULL;
342: END IF;
343: IF (l_oks_billrate_schedules_v_rec.bt_cle_id = OKC_API.G_MISS_NUM ) THEN
344: l_oks_billrate_schedules_v_rec.bt_cle_id := NULL;
345: END IF;
346: IF (l_oks_billrate_schedules_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM ) THEN
347: l_oks_billrate_schedules_v_rec.dnz_chr_id := NULL;
348: END IF;
342: END IF;
343: IF (l_oks_billrate_schedules_v_rec.bt_cle_id = OKC_API.G_MISS_NUM ) THEN
344: l_oks_billrate_schedules_v_rec.bt_cle_id := NULL;
345: END IF;
346: IF (l_oks_billrate_schedules_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM ) THEN
347: l_oks_billrate_schedules_v_rec.dnz_chr_id := NULL;
348: END IF;
349: IF (l_oks_billrate_schedules_v_rec.start_hour = OKC_API.G_MISS_NUM ) THEN
350: l_oks_billrate_schedules_v_rec.start_hour := NULL;
343: IF (l_oks_billrate_schedules_v_rec.bt_cle_id = OKC_API.G_MISS_NUM ) THEN
344: l_oks_billrate_schedules_v_rec.bt_cle_id := NULL;
345: END IF;
346: IF (l_oks_billrate_schedules_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM ) THEN
347: l_oks_billrate_schedules_v_rec.dnz_chr_id := NULL;
348: END IF;
349: IF (l_oks_billrate_schedules_v_rec.start_hour = OKC_API.G_MISS_NUM ) THEN
350: l_oks_billrate_schedules_v_rec.start_hour := NULL;
351: END IF;
345: END IF;
346: IF (l_oks_billrate_schedules_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM ) THEN
347: l_oks_billrate_schedules_v_rec.dnz_chr_id := NULL;
348: END IF;
349: IF (l_oks_billrate_schedules_v_rec.start_hour = OKC_API.G_MISS_NUM ) THEN
350: l_oks_billrate_schedules_v_rec.start_hour := NULL;
351: END IF;
352: IF (l_oks_billrate_schedules_v_rec.start_minute = OKC_API.G_MISS_NUM ) THEN
353: l_oks_billrate_schedules_v_rec.start_minute := NULL;
346: IF (l_oks_billrate_schedules_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM ) THEN
347: l_oks_billrate_schedules_v_rec.dnz_chr_id := NULL;
348: END IF;
349: IF (l_oks_billrate_schedules_v_rec.start_hour = OKC_API.G_MISS_NUM ) THEN
350: l_oks_billrate_schedules_v_rec.start_hour := NULL;
351: END IF;
352: IF (l_oks_billrate_schedules_v_rec.start_minute = OKC_API.G_MISS_NUM ) THEN
353: l_oks_billrate_schedules_v_rec.start_minute := NULL;
354: END IF;
348: END IF;
349: IF (l_oks_billrate_schedules_v_rec.start_hour = OKC_API.G_MISS_NUM ) THEN
350: l_oks_billrate_schedules_v_rec.start_hour := NULL;
351: END IF;
352: IF (l_oks_billrate_schedules_v_rec.start_minute = OKC_API.G_MISS_NUM ) THEN
353: l_oks_billrate_schedules_v_rec.start_minute := NULL;
354: END IF;
355: IF (l_oks_billrate_schedules_v_rec.end_hour = OKC_API.G_MISS_NUM ) THEN
356: l_oks_billrate_schedules_v_rec.end_hour := NULL;
349: IF (l_oks_billrate_schedules_v_rec.start_hour = OKC_API.G_MISS_NUM ) THEN
350: l_oks_billrate_schedules_v_rec.start_hour := NULL;
351: END IF;
352: IF (l_oks_billrate_schedules_v_rec.start_minute = OKC_API.G_MISS_NUM ) THEN
353: l_oks_billrate_schedules_v_rec.start_minute := NULL;
354: END IF;
355: IF (l_oks_billrate_schedules_v_rec.end_hour = OKC_API.G_MISS_NUM ) THEN
356: l_oks_billrate_schedules_v_rec.end_hour := NULL;
357: END IF;
351: END IF;
352: IF (l_oks_billrate_schedules_v_rec.start_minute = OKC_API.G_MISS_NUM ) THEN
353: l_oks_billrate_schedules_v_rec.start_minute := NULL;
354: END IF;
355: IF (l_oks_billrate_schedules_v_rec.end_hour = OKC_API.G_MISS_NUM ) THEN
356: l_oks_billrate_schedules_v_rec.end_hour := NULL;
357: END IF;
358: IF (l_oks_billrate_schedules_v_rec.end_minute = OKC_API.G_MISS_NUM ) THEN
359: l_oks_billrate_schedules_v_rec.end_minute := NULL;
352: IF (l_oks_billrate_schedules_v_rec.start_minute = OKC_API.G_MISS_NUM ) THEN
353: l_oks_billrate_schedules_v_rec.start_minute := NULL;
354: END IF;
355: IF (l_oks_billrate_schedules_v_rec.end_hour = OKC_API.G_MISS_NUM ) THEN
356: l_oks_billrate_schedules_v_rec.end_hour := NULL;
357: END IF;
358: IF (l_oks_billrate_schedules_v_rec.end_minute = OKC_API.G_MISS_NUM ) THEN
359: l_oks_billrate_schedules_v_rec.end_minute := NULL;
360: END IF;
354: END IF;
355: IF (l_oks_billrate_schedules_v_rec.end_hour = OKC_API.G_MISS_NUM ) THEN
356: l_oks_billrate_schedules_v_rec.end_hour := NULL;
357: END IF;
358: IF (l_oks_billrate_schedules_v_rec.end_minute = OKC_API.G_MISS_NUM ) THEN
359: l_oks_billrate_schedules_v_rec.end_minute := NULL;
360: END IF;
361: IF (l_oks_billrate_schedules_v_rec.monday_flag = OKC_API.G_MISS_CHAR ) THEN
362: l_oks_billrate_schedules_v_rec.monday_flag := NULL;
355: IF (l_oks_billrate_schedules_v_rec.end_hour = OKC_API.G_MISS_NUM ) THEN
356: l_oks_billrate_schedules_v_rec.end_hour := NULL;
357: END IF;
358: IF (l_oks_billrate_schedules_v_rec.end_minute = OKC_API.G_MISS_NUM ) THEN
359: l_oks_billrate_schedules_v_rec.end_minute := NULL;
360: END IF;
361: IF (l_oks_billrate_schedules_v_rec.monday_flag = OKC_API.G_MISS_CHAR ) THEN
362: l_oks_billrate_schedules_v_rec.monday_flag := NULL;
363: END IF;
357: END IF;
358: IF (l_oks_billrate_schedules_v_rec.end_minute = OKC_API.G_MISS_NUM ) THEN
359: l_oks_billrate_schedules_v_rec.end_minute := NULL;
360: END IF;
361: IF (l_oks_billrate_schedules_v_rec.monday_flag = OKC_API.G_MISS_CHAR ) THEN
362: l_oks_billrate_schedules_v_rec.monday_flag := NULL;
363: END IF;
364: IF (l_oks_billrate_schedules_v_rec.tuesday_flag = OKC_API.G_MISS_CHAR ) THEN
365: l_oks_billrate_schedules_v_rec.tuesday_flag := NULL;
358: IF (l_oks_billrate_schedules_v_rec.end_minute = OKC_API.G_MISS_NUM ) THEN
359: l_oks_billrate_schedules_v_rec.end_minute := NULL;
360: END IF;
361: IF (l_oks_billrate_schedules_v_rec.monday_flag = OKC_API.G_MISS_CHAR ) THEN
362: l_oks_billrate_schedules_v_rec.monday_flag := NULL;
363: END IF;
364: IF (l_oks_billrate_schedules_v_rec.tuesday_flag = OKC_API.G_MISS_CHAR ) THEN
365: l_oks_billrate_schedules_v_rec.tuesday_flag := NULL;
366: END IF;
360: END IF;
361: IF (l_oks_billrate_schedules_v_rec.monday_flag = OKC_API.G_MISS_CHAR ) THEN
362: l_oks_billrate_schedules_v_rec.monday_flag := NULL;
363: END IF;
364: IF (l_oks_billrate_schedules_v_rec.tuesday_flag = OKC_API.G_MISS_CHAR ) THEN
365: l_oks_billrate_schedules_v_rec.tuesday_flag := NULL;
366: END IF;
367: IF (l_oks_billrate_schedules_v_rec.wednesday_flag = OKC_API.G_MISS_CHAR ) THEN
368: l_oks_billrate_schedules_v_rec.wednesday_flag := NULL;
361: IF (l_oks_billrate_schedules_v_rec.monday_flag = OKC_API.G_MISS_CHAR ) THEN
362: l_oks_billrate_schedules_v_rec.monday_flag := NULL;
363: END IF;
364: IF (l_oks_billrate_schedules_v_rec.tuesday_flag = OKC_API.G_MISS_CHAR ) THEN
365: l_oks_billrate_schedules_v_rec.tuesday_flag := NULL;
366: END IF;
367: IF (l_oks_billrate_schedules_v_rec.wednesday_flag = OKC_API.G_MISS_CHAR ) THEN
368: l_oks_billrate_schedules_v_rec.wednesday_flag := NULL;
369: END IF;
363: END IF;
364: IF (l_oks_billrate_schedules_v_rec.tuesday_flag = OKC_API.G_MISS_CHAR ) THEN
365: l_oks_billrate_schedules_v_rec.tuesday_flag := NULL;
366: END IF;
367: IF (l_oks_billrate_schedules_v_rec.wednesday_flag = OKC_API.G_MISS_CHAR ) THEN
368: l_oks_billrate_schedules_v_rec.wednesday_flag := NULL;
369: END IF;
370: IF (l_oks_billrate_schedules_v_rec.thursday_flag = OKC_API.G_MISS_CHAR ) THEN
371: l_oks_billrate_schedules_v_rec.thursday_flag := NULL;
364: IF (l_oks_billrate_schedules_v_rec.tuesday_flag = OKC_API.G_MISS_CHAR ) THEN
365: l_oks_billrate_schedules_v_rec.tuesday_flag := NULL;
366: END IF;
367: IF (l_oks_billrate_schedules_v_rec.wednesday_flag = OKC_API.G_MISS_CHAR ) THEN
368: l_oks_billrate_schedules_v_rec.wednesday_flag := NULL;
369: END IF;
370: IF (l_oks_billrate_schedules_v_rec.thursday_flag = OKC_API.G_MISS_CHAR ) THEN
371: l_oks_billrate_schedules_v_rec.thursday_flag := NULL;
372: END IF;
366: END IF;
367: IF (l_oks_billrate_schedules_v_rec.wednesday_flag = OKC_API.G_MISS_CHAR ) THEN
368: l_oks_billrate_schedules_v_rec.wednesday_flag := NULL;
369: END IF;
370: IF (l_oks_billrate_schedules_v_rec.thursday_flag = OKC_API.G_MISS_CHAR ) THEN
371: l_oks_billrate_schedules_v_rec.thursday_flag := NULL;
372: END IF;
373: IF (l_oks_billrate_schedules_v_rec.friday_flag = OKC_API.G_MISS_CHAR ) THEN
374: l_oks_billrate_schedules_v_rec.friday_flag := NULL;
367: IF (l_oks_billrate_schedules_v_rec.wednesday_flag = OKC_API.G_MISS_CHAR ) THEN
368: l_oks_billrate_schedules_v_rec.wednesday_flag := NULL;
369: END IF;
370: IF (l_oks_billrate_schedules_v_rec.thursday_flag = OKC_API.G_MISS_CHAR ) THEN
371: l_oks_billrate_schedules_v_rec.thursday_flag := NULL;
372: END IF;
373: IF (l_oks_billrate_schedules_v_rec.friday_flag = OKC_API.G_MISS_CHAR ) THEN
374: l_oks_billrate_schedules_v_rec.friday_flag := NULL;
375: END IF;
369: END IF;
370: IF (l_oks_billrate_schedules_v_rec.thursday_flag = OKC_API.G_MISS_CHAR ) THEN
371: l_oks_billrate_schedules_v_rec.thursday_flag := NULL;
372: END IF;
373: IF (l_oks_billrate_schedules_v_rec.friday_flag = OKC_API.G_MISS_CHAR ) THEN
374: l_oks_billrate_schedules_v_rec.friday_flag := NULL;
375: END IF;
376: IF (l_oks_billrate_schedules_v_rec.saturday_flag = OKC_API.G_MISS_CHAR ) THEN
377: l_oks_billrate_schedules_v_rec.saturday_flag := NULL;
370: IF (l_oks_billrate_schedules_v_rec.thursday_flag = OKC_API.G_MISS_CHAR ) THEN
371: l_oks_billrate_schedules_v_rec.thursday_flag := NULL;
372: END IF;
373: IF (l_oks_billrate_schedules_v_rec.friday_flag = OKC_API.G_MISS_CHAR ) THEN
374: l_oks_billrate_schedules_v_rec.friday_flag := NULL;
375: END IF;
376: IF (l_oks_billrate_schedules_v_rec.saturday_flag = OKC_API.G_MISS_CHAR ) THEN
377: l_oks_billrate_schedules_v_rec.saturday_flag := NULL;
378: END IF;
372: END IF;
373: IF (l_oks_billrate_schedules_v_rec.friday_flag = OKC_API.G_MISS_CHAR ) THEN
374: l_oks_billrate_schedules_v_rec.friday_flag := NULL;
375: END IF;
376: IF (l_oks_billrate_schedules_v_rec.saturday_flag = OKC_API.G_MISS_CHAR ) THEN
377: l_oks_billrate_schedules_v_rec.saturday_flag := NULL;
378: END IF;
379: IF (l_oks_billrate_schedules_v_rec.sunday_flag = OKC_API.G_MISS_CHAR ) THEN
380: l_oks_billrate_schedules_v_rec.sunday_flag := NULL;
373: IF (l_oks_billrate_schedules_v_rec.friday_flag = OKC_API.G_MISS_CHAR ) THEN
374: l_oks_billrate_schedules_v_rec.friday_flag := NULL;
375: END IF;
376: IF (l_oks_billrate_schedules_v_rec.saturday_flag = OKC_API.G_MISS_CHAR ) THEN
377: l_oks_billrate_schedules_v_rec.saturday_flag := NULL;
378: END IF;
379: IF (l_oks_billrate_schedules_v_rec.sunday_flag = OKC_API.G_MISS_CHAR ) THEN
380: l_oks_billrate_schedules_v_rec.sunday_flag := NULL;
381: END IF;
375: END IF;
376: IF (l_oks_billrate_schedules_v_rec.saturday_flag = OKC_API.G_MISS_CHAR ) THEN
377: l_oks_billrate_schedules_v_rec.saturday_flag := NULL;
378: END IF;
379: IF (l_oks_billrate_schedules_v_rec.sunday_flag = OKC_API.G_MISS_CHAR ) THEN
380: l_oks_billrate_schedules_v_rec.sunday_flag := NULL;
381: END IF;
382: IF (l_oks_billrate_schedules_v_rec.object1_id1 = OKC_API.G_MISS_CHAR ) THEN
383: l_oks_billrate_schedules_v_rec.object1_id1 := NULL;
376: IF (l_oks_billrate_schedules_v_rec.saturday_flag = OKC_API.G_MISS_CHAR ) THEN
377: l_oks_billrate_schedules_v_rec.saturday_flag := NULL;
378: END IF;
379: IF (l_oks_billrate_schedules_v_rec.sunday_flag = OKC_API.G_MISS_CHAR ) THEN
380: l_oks_billrate_schedules_v_rec.sunday_flag := NULL;
381: END IF;
382: IF (l_oks_billrate_schedules_v_rec.object1_id1 = OKC_API.G_MISS_CHAR ) THEN
383: l_oks_billrate_schedules_v_rec.object1_id1 := NULL;
384: END IF;
378: END IF;
379: IF (l_oks_billrate_schedules_v_rec.sunday_flag = OKC_API.G_MISS_CHAR ) THEN
380: l_oks_billrate_schedules_v_rec.sunday_flag := NULL;
381: END IF;
382: IF (l_oks_billrate_schedules_v_rec.object1_id1 = OKC_API.G_MISS_CHAR ) THEN
383: l_oks_billrate_schedules_v_rec.object1_id1 := NULL;
384: END IF;
385: IF (l_oks_billrate_schedules_v_rec.object1_id2 = OKC_API.G_MISS_CHAR ) THEN
386: l_oks_billrate_schedules_v_rec.object1_id2 := NULL;
379: IF (l_oks_billrate_schedules_v_rec.sunday_flag = OKC_API.G_MISS_CHAR ) THEN
380: l_oks_billrate_schedules_v_rec.sunday_flag := NULL;
381: END IF;
382: IF (l_oks_billrate_schedules_v_rec.object1_id1 = OKC_API.G_MISS_CHAR ) THEN
383: l_oks_billrate_schedules_v_rec.object1_id1 := NULL;
384: END IF;
385: IF (l_oks_billrate_schedules_v_rec.object1_id2 = OKC_API.G_MISS_CHAR ) THEN
386: l_oks_billrate_schedules_v_rec.object1_id2 := NULL;
387: END IF;
381: END IF;
382: IF (l_oks_billrate_schedules_v_rec.object1_id1 = OKC_API.G_MISS_CHAR ) THEN
383: l_oks_billrate_schedules_v_rec.object1_id1 := NULL;
384: END IF;
385: IF (l_oks_billrate_schedules_v_rec.object1_id2 = OKC_API.G_MISS_CHAR ) THEN
386: l_oks_billrate_schedules_v_rec.object1_id2 := NULL;
387: END IF;
388: IF (l_oks_billrate_schedules_v_rec.jtot_object1_code = OKC_API.G_MISS_CHAR ) THEN
389: l_oks_billrate_schedules_v_rec.jtot_object1_code := NULL;
382: IF (l_oks_billrate_schedules_v_rec.object1_id1 = OKC_API.G_MISS_CHAR ) THEN
383: l_oks_billrate_schedules_v_rec.object1_id1 := NULL;
384: END IF;
385: IF (l_oks_billrate_schedules_v_rec.object1_id2 = OKC_API.G_MISS_CHAR ) THEN
386: l_oks_billrate_schedules_v_rec.object1_id2 := NULL;
387: END IF;
388: IF (l_oks_billrate_schedules_v_rec.jtot_object1_code = OKC_API.G_MISS_CHAR ) THEN
389: l_oks_billrate_schedules_v_rec.jtot_object1_code := NULL;
390: END IF;
384: END IF;
385: IF (l_oks_billrate_schedules_v_rec.object1_id2 = OKC_API.G_MISS_CHAR ) THEN
386: l_oks_billrate_schedules_v_rec.object1_id2 := NULL;
387: END IF;
388: IF (l_oks_billrate_schedules_v_rec.jtot_object1_code = OKC_API.G_MISS_CHAR ) THEN
389: l_oks_billrate_schedules_v_rec.jtot_object1_code := NULL;
390: END IF;
391: IF (l_oks_billrate_schedules_v_rec.bill_rate_code = OKC_API.G_MISS_CHAR ) THEN
392: l_oks_billrate_schedules_v_rec.bill_rate_code := NULL;
385: IF (l_oks_billrate_schedules_v_rec.object1_id2 = OKC_API.G_MISS_CHAR ) THEN
386: l_oks_billrate_schedules_v_rec.object1_id2 := NULL;
387: END IF;
388: IF (l_oks_billrate_schedules_v_rec.jtot_object1_code = OKC_API.G_MISS_CHAR ) THEN
389: l_oks_billrate_schedules_v_rec.jtot_object1_code := NULL;
390: END IF;
391: IF (l_oks_billrate_schedules_v_rec.bill_rate_code = OKC_API.G_MISS_CHAR ) THEN
392: l_oks_billrate_schedules_v_rec.bill_rate_code := NULL;
393: END IF;
387: END IF;
388: IF (l_oks_billrate_schedules_v_rec.jtot_object1_code = OKC_API.G_MISS_CHAR ) THEN
389: l_oks_billrate_schedules_v_rec.jtot_object1_code := NULL;
390: END IF;
391: IF (l_oks_billrate_schedules_v_rec.bill_rate_code = OKC_API.G_MISS_CHAR ) THEN
392: l_oks_billrate_schedules_v_rec.bill_rate_code := NULL;
393: END IF;
394: IF (l_oks_billrate_schedules_v_rec.uom = OKC_API.G_MISS_CHAR ) THEN
395: l_oks_billrate_schedules_v_rec.uom := NULL;
388: IF (l_oks_billrate_schedules_v_rec.jtot_object1_code = OKC_API.G_MISS_CHAR ) THEN
389: l_oks_billrate_schedules_v_rec.jtot_object1_code := NULL;
390: END IF;
391: IF (l_oks_billrate_schedules_v_rec.bill_rate_code = OKC_API.G_MISS_CHAR ) THEN
392: l_oks_billrate_schedules_v_rec.bill_rate_code := NULL;
393: END IF;
394: IF (l_oks_billrate_schedules_v_rec.uom = OKC_API.G_MISS_CHAR ) THEN
395: l_oks_billrate_schedules_v_rec.uom := NULL;
396: END IF;
390: END IF;
391: IF (l_oks_billrate_schedules_v_rec.bill_rate_code = OKC_API.G_MISS_CHAR ) THEN
392: l_oks_billrate_schedules_v_rec.bill_rate_code := NULL;
393: END IF;
394: IF (l_oks_billrate_schedules_v_rec.uom = OKC_API.G_MISS_CHAR ) THEN
395: l_oks_billrate_schedules_v_rec.uom := NULL;
396: END IF;
397: IF (l_oks_billrate_schedules_v_rec.flat_rate = OKC_API.G_MISS_NUM ) THEN
398: l_oks_billrate_schedules_v_rec.flat_rate := NULL;
391: IF (l_oks_billrate_schedules_v_rec.bill_rate_code = OKC_API.G_MISS_CHAR ) THEN
392: l_oks_billrate_schedules_v_rec.bill_rate_code := NULL;
393: END IF;
394: IF (l_oks_billrate_schedules_v_rec.uom = OKC_API.G_MISS_CHAR ) THEN
395: l_oks_billrate_schedules_v_rec.uom := NULL;
396: END IF;
397: IF (l_oks_billrate_schedules_v_rec.flat_rate = OKC_API.G_MISS_NUM ) THEN
398: l_oks_billrate_schedules_v_rec.flat_rate := NULL;
399: END IF;
393: END IF;
394: IF (l_oks_billrate_schedules_v_rec.uom = OKC_API.G_MISS_CHAR ) THEN
395: l_oks_billrate_schedules_v_rec.uom := NULL;
396: END IF;
397: IF (l_oks_billrate_schedules_v_rec.flat_rate = OKC_API.G_MISS_NUM ) THEN
398: l_oks_billrate_schedules_v_rec.flat_rate := NULL;
399: END IF;
400: IF (l_oks_billrate_schedules_v_rec.holiday_yn = OKC_API.G_MISS_CHAR ) THEN
401: l_oks_billrate_schedules_v_rec.holiday_yn := NULL;
394: IF (l_oks_billrate_schedules_v_rec.uom = OKC_API.G_MISS_CHAR ) THEN
395: l_oks_billrate_schedules_v_rec.uom := NULL;
396: END IF;
397: IF (l_oks_billrate_schedules_v_rec.flat_rate = OKC_API.G_MISS_NUM ) THEN
398: l_oks_billrate_schedules_v_rec.flat_rate := NULL;
399: END IF;
400: IF (l_oks_billrate_schedules_v_rec.holiday_yn = OKC_API.G_MISS_CHAR ) THEN
401: l_oks_billrate_schedules_v_rec.holiday_yn := NULL;
402: END IF;
396: END IF;
397: IF (l_oks_billrate_schedules_v_rec.flat_rate = OKC_API.G_MISS_NUM ) THEN
398: l_oks_billrate_schedules_v_rec.flat_rate := NULL;
399: END IF;
400: IF (l_oks_billrate_schedules_v_rec.holiday_yn = OKC_API.G_MISS_CHAR ) THEN
401: l_oks_billrate_schedules_v_rec.holiday_yn := NULL;
402: END IF;
403: IF (l_oks_billrate_schedules_v_rec.percent_over_list_price = OKC_API.G_MISS_NUM ) THEN
404: l_oks_billrate_schedules_v_rec.percent_over_list_price := NULL;
397: IF (l_oks_billrate_schedules_v_rec.flat_rate = OKC_API.G_MISS_NUM ) THEN
398: l_oks_billrate_schedules_v_rec.flat_rate := NULL;
399: END IF;
400: IF (l_oks_billrate_schedules_v_rec.holiday_yn = OKC_API.G_MISS_CHAR ) THEN
401: l_oks_billrate_schedules_v_rec.holiday_yn := NULL;
402: END IF;
403: IF (l_oks_billrate_schedules_v_rec.percent_over_list_price = OKC_API.G_MISS_NUM ) THEN
404: l_oks_billrate_schedules_v_rec.percent_over_list_price := NULL;
405: END IF;
399: END IF;
400: IF (l_oks_billrate_schedules_v_rec.holiday_yn = OKC_API.G_MISS_CHAR ) THEN
401: l_oks_billrate_schedules_v_rec.holiday_yn := NULL;
402: END IF;
403: IF (l_oks_billrate_schedules_v_rec.percent_over_list_price = OKC_API.G_MISS_NUM ) THEN
404: l_oks_billrate_schedules_v_rec.percent_over_list_price := NULL;
405: END IF;
406: IF (l_oks_billrate_schedules_v_rec.program_application_id = OKC_API.G_MISS_NUM ) THEN
407: l_oks_billrate_schedules_v_rec.program_application_id := NULL;
400: IF (l_oks_billrate_schedules_v_rec.holiday_yn = OKC_API.G_MISS_CHAR ) THEN
401: l_oks_billrate_schedules_v_rec.holiday_yn := NULL;
402: END IF;
403: IF (l_oks_billrate_schedules_v_rec.percent_over_list_price = OKC_API.G_MISS_NUM ) THEN
404: l_oks_billrate_schedules_v_rec.percent_over_list_price := NULL;
405: END IF;
406: IF (l_oks_billrate_schedules_v_rec.program_application_id = OKC_API.G_MISS_NUM ) THEN
407: l_oks_billrate_schedules_v_rec.program_application_id := NULL;
408: END IF;
402: END IF;
403: IF (l_oks_billrate_schedules_v_rec.percent_over_list_price = OKC_API.G_MISS_NUM ) THEN
404: l_oks_billrate_schedules_v_rec.percent_over_list_price := NULL;
405: END IF;
406: IF (l_oks_billrate_schedules_v_rec.program_application_id = OKC_API.G_MISS_NUM ) THEN
407: l_oks_billrate_schedules_v_rec.program_application_id := NULL;
408: END IF;
409: IF (l_oks_billrate_schedules_v_rec.program_id = OKC_API.G_MISS_NUM ) THEN
410: l_oks_billrate_schedules_v_rec.program_id := NULL;
403: IF (l_oks_billrate_schedules_v_rec.percent_over_list_price = OKC_API.G_MISS_NUM ) THEN
404: l_oks_billrate_schedules_v_rec.percent_over_list_price := NULL;
405: END IF;
406: IF (l_oks_billrate_schedules_v_rec.program_application_id = OKC_API.G_MISS_NUM ) THEN
407: l_oks_billrate_schedules_v_rec.program_application_id := NULL;
408: END IF;
409: IF (l_oks_billrate_schedules_v_rec.program_id = OKC_API.G_MISS_NUM ) THEN
410: l_oks_billrate_schedules_v_rec.program_id := NULL;
411: END IF;
405: END IF;
406: IF (l_oks_billrate_schedules_v_rec.program_application_id = OKC_API.G_MISS_NUM ) THEN
407: l_oks_billrate_schedules_v_rec.program_application_id := NULL;
408: END IF;
409: IF (l_oks_billrate_schedules_v_rec.program_id = OKC_API.G_MISS_NUM ) THEN
410: l_oks_billrate_schedules_v_rec.program_id := NULL;
411: END IF;
412: IF (l_oks_billrate_schedules_v_rec.program_update_date = OKC_API.G_MISS_DATE ) THEN
413: l_oks_billrate_schedules_v_rec.program_update_date := NULL;
406: IF (l_oks_billrate_schedules_v_rec.program_application_id = OKC_API.G_MISS_NUM ) THEN
407: l_oks_billrate_schedules_v_rec.program_application_id := NULL;
408: END IF;
409: IF (l_oks_billrate_schedules_v_rec.program_id = OKC_API.G_MISS_NUM ) THEN
410: l_oks_billrate_schedules_v_rec.program_id := NULL;
411: END IF;
412: IF (l_oks_billrate_schedules_v_rec.program_update_date = OKC_API.G_MISS_DATE ) THEN
413: l_oks_billrate_schedules_v_rec.program_update_date := NULL;
414: END IF;
408: END IF;
409: IF (l_oks_billrate_schedules_v_rec.program_id = OKC_API.G_MISS_NUM ) THEN
410: l_oks_billrate_schedules_v_rec.program_id := NULL;
411: END IF;
412: IF (l_oks_billrate_schedules_v_rec.program_update_date = OKC_API.G_MISS_DATE ) THEN
413: l_oks_billrate_schedules_v_rec.program_update_date := NULL;
414: END IF;
415: IF (l_oks_billrate_schedules_v_rec.request_id = OKC_API.G_MISS_NUM ) THEN
416: l_oks_billrate_schedules_v_rec.request_id := NULL;
409: IF (l_oks_billrate_schedules_v_rec.program_id = OKC_API.G_MISS_NUM ) THEN
410: l_oks_billrate_schedules_v_rec.program_id := NULL;
411: END IF;
412: IF (l_oks_billrate_schedules_v_rec.program_update_date = OKC_API.G_MISS_DATE ) THEN
413: l_oks_billrate_schedules_v_rec.program_update_date := NULL;
414: END IF;
415: IF (l_oks_billrate_schedules_v_rec.request_id = OKC_API.G_MISS_NUM ) THEN
416: l_oks_billrate_schedules_v_rec.request_id := NULL;
417: END IF;
411: END IF;
412: IF (l_oks_billrate_schedules_v_rec.program_update_date = OKC_API.G_MISS_DATE ) THEN
413: l_oks_billrate_schedules_v_rec.program_update_date := NULL;
414: END IF;
415: IF (l_oks_billrate_schedules_v_rec.request_id = OKC_API.G_MISS_NUM ) THEN
416: l_oks_billrate_schedules_v_rec.request_id := NULL;
417: END IF;
418: IF (l_oks_billrate_schedules_v_rec.created_by = OKC_API.G_MISS_NUM ) THEN
419: l_oks_billrate_schedules_v_rec.created_by := NULL;
412: IF (l_oks_billrate_schedules_v_rec.program_update_date = OKC_API.G_MISS_DATE ) THEN
413: l_oks_billrate_schedules_v_rec.program_update_date := NULL;
414: END IF;
415: IF (l_oks_billrate_schedules_v_rec.request_id = OKC_API.G_MISS_NUM ) THEN
416: l_oks_billrate_schedules_v_rec.request_id := NULL;
417: END IF;
418: IF (l_oks_billrate_schedules_v_rec.created_by = OKC_API.G_MISS_NUM ) THEN
419: l_oks_billrate_schedules_v_rec.created_by := NULL;
420: END IF;
414: END IF;
415: IF (l_oks_billrate_schedules_v_rec.request_id = OKC_API.G_MISS_NUM ) THEN
416: l_oks_billrate_schedules_v_rec.request_id := NULL;
417: END IF;
418: IF (l_oks_billrate_schedules_v_rec.created_by = OKC_API.G_MISS_NUM ) THEN
419: l_oks_billrate_schedules_v_rec.created_by := NULL;
420: END IF;
421: IF (l_oks_billrate_schedules_v_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
422: l_oks_billrate_schedules_v_rec.creation_date := NULL;
415: IF (l_oks_billrate_schedules_v_rec.request_id = OKC_API.G_MISS_NUM ) THEN
416: l_oks_billrate_schedules_v_rec.request_id := NULL;
417: END IF;
418: IF (l_oks_billrate_schedules_v_rec.created_by = OKC_API.G_MISS_NUM ) THEN
419: l_oks_billrate_schedules_v_rec.created_by := NULL;
420: END IF;
421: IF (l_oks_billrate_schedules_v_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
422: l_oks_billrate_schedules_v_rec.creation_date := NULL;
423: END IF;
417: END IF;
418: IF (l_oks_billrate_schedules_v_rec.created_by = OKC_API.G_MISS_NUM ) THEN
419: l_oks_billrate_schedules_v_rec.created_by := NULL;
420: END IF;
421: IF (l_oks_billrate_schedules_v_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
422: l_oks_billrate_schedules_v_rec.creation_date := NULL;
423: END IF;
424: IF (l_oks_billrate_schedules_v_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
425: l_oks_billrate_schedules_v_rec.last_updated_by := NULL;
418: IF (l_oks_billrate_schedules_v_rec.created_by = OKC_API.G_MISS_NUM ) THEN
419: l_oks_billrate_schedules_v_rec.created_by := NULL;
420: END IF;
421: IF (l_oks_billrate_schedules_v_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
422: l_oks_billrate_schedules_v_rec.creation_date := NULL;
423: END IF;
424: IF (l_oks_billrate_schedules_v_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
425: l_oks_billrate_schedules_v_rec.last_updated_by := NULL;
426: END IF;
420: END IF;
421: IF (l_oks_billrate_schedules_v_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
422: l_oks_billrate_schedules_v_rec.creation_date := NULL;
423: END IF;
424: IF (l_oks_billrate_schedules_v_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
425: l_oks_billrate_schedules_v_rec.last_updated_by := NULL;
426: END IF;
427: IF (l_oks_billrate_schedules_v_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
428: l_oks_billrate_schedules_v_rec.last_update_date := NULL;
421: IF (l_oks_billrate_schedules_v_rec.creation_date = OKC_API.G_MISS_DATE ) THEN
422: l_oks_billrate_schedules_v_rec.creation_date := NULL;
423: END IF;
424: IF (l_oks_billrate_schedules_v_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
425: l_oks_billrate_schedules_v_rec.last_updated_by := NULL;
426: END IF;
427: IF (l_oks_billrate_schedules_v_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
428: l_oks_billrate_schedules_v_rec.last_update_date := NULL;
429: END IF;
423: END IF;
424: IF (l_oks_billrate_schedules_v_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
425: l_oks_billrate_schedules_v_rec.last_updated_by := NULL;
426: END IF;
427: IF (l_oks_billrate_schedules_v_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
428: l_oks_billrate_schedules_v_rec.last_update_date := NULL;
429: END IF;
430: IF (l_oks_billrate_schedules_v_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
431: l_oks_billrate_schedules_v_rec.last_update_login := NULL;
424: IF (l_oks_billrate_schedules_v_rec.last_updated_by = OKC_API.G_MISS_NUM ) THEN
425: l_oks_billrate_schedules_v_rec.last_updated_by := NULL;
426: END IF;
427: IF (l_oks_billrate_schedules_v_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
428: l_oks_billrate_schedules_v_rec.last_update_date := NULL;
429: END IF;
430: IF (l_oks_billrate_schedules_v_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
431: l_oks_billrate_schedules_v_rec.last_update_login := NULL;
432: END IF;
426: END IF;
427: IF (l_oks_billrate_schedules_v_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
428: l_oks_billrate_schedules_v_rec.last_update_date := NULL;
429: END IF;
430: IF (l_oks_billrate_schedules_v_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
431: l_oks_billrate_schedules_v_rec.last_update_login := NULL;
432: END IF;
433: IF (l_oks_billrate_schedules_v_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
434: l_oks_billrate_schedules_v_rec.object_version_number := NULL;
427: IF (l_oks_billrate_schedules_v_rec.last_update_date = OKC_API.G_MISS_DATE ) THEN
428: l_oks_billrate_schedules_v_rec.last_update_date := NULL;
429: END IF;
430: IF (l_oks_billrate_schedules_v_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
431: l_oks_billrate_schedules_v_rec.last_update_login := NULL;
432: END IF;
433: IF (l_oks_billrate_schedules_v_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
434: l_oks_billrate_schedules_v_rec.object_version_number := NULL;
435: END IF;
429: END IF;
430: IF (l_oks_billrate_schedules_v_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
431: l_oks_billrate_schedules_v_rec.last_update_login := NULL;
432: END IF;
433: IF (l_oks_billrate_schedules_v_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
434: l_oks_billrate_schedules_v_rec.object_version_number := NULL;
435: END IF;
436: IF (l_oks_billrate_schedules_v_rec.security_group_id = OKC_API.G_MISS_NUM ) THEN
437: l_oks_billrate_schedules_v_rec.security_group_id := NULL;
430: IF (l_oks_billrate_schedules_v_rec.last_update_login = OKC_API.G_MISS_NUM ) THEN
431: l_oks_billrate_schedules_v_rec.last_update_login := NULL;
432: END IF;
433: IF (l_oks_billrate_schedules_v_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
434: l_oks_billrate_schedules_v_rec.object_version_number := NULL;
435: END IF;
436: IF (l_oks_billrate_schedules_v_rec.security_group_id = OKC_API.G_MISS_NUM ) THEN
437: l_oks_billrate_schedules_v_rec.security_group_id := NULL;
438: END IF;
432: END IF;
433: IF (l_oks_billrate_schedules_v_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
434: l_oks_billrate_schedules_v_rec.object_version_number := NULL;
435: END IF;
436: IF (l_oks_billrate_schedules_v_rec.security_group_id = OKC_API.G_MISS_NUM ) THEN
437: l_oks_billrate_schedules_v_rec.security_group_id := NULL;
438: END IF;
439: RETURN(l_oks_billrate_schedules_v_rec);
440: END null_out_defaults;
433: IF (l_oks_billrate_schedules_v_rec.object_version_number = OKC_API.G_MISS_NUM ) THEN
434: l_oks_billrate_schedules_v_rec.object_version_number := NULL;
435: END IF;
436: IF (l_oks_billrate_schedules_v_rec.security_group_id = OKC_API.G_MISS_NUM ) THEN
437: l_oks_billrate_schedules_v_rec.security_group_id := NULL;
438: END IF;
439: RETURN(l_oks_billrate_schedules_v_rec);
440: END null_out_defaults;
441: ---------------------------------
435: END IF;
436: IF (l_oks_billrate_schedules_v_rec.security_group_id = OKC_API.G_MISS_NUM ) THEN
437: l_oks_billrate_schedules_v_rec.security_group_id := NULL;
438: END IF;
439: RETURN(l_oks_billrate_schedules_v_rec);
440: END null_out_defaults;
441: ---------------------------------
442: -- Validate_Attributes for: ID --
443: ---------------------------------
468: ---------------------------------------------------------------------------
469: -- FUNCTION Validate_Attributes
470: ---------------------------------------------------------------------------
471: ------------------------------------------------------
472: -- Validate_Attributes for:OKS_BILLRATE_SCHEDULES_V --
473: ------------------------------------------------------
474: FUNCTION Validate_Attributes (
475: p_oks_billrate_schedules_v_rec IN OksBillrateSchedulesVRecType
476: ) RETURN VARCHAR2 IS
471: ------------------------------------------------------
472: -- Validate_Attributes for:OKS_BILLRATE_SCHEDULES_V --
473: ------------------------------------------------------
474: FUNCTION Validate_Attributes (
475: p_oks_billrate_schedules_v_rec IN OksBillrateSchedulesVRecType
476: ) RETURN VARCHAR2 IS
477: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
478: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
479: BEGIN
482: -----------------------------
483: -- ***
484: -- id
485: -- ***
486: validate_id(x_return_status, p_oks_billrate_schedules_v_rec.id);
487: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
488: l_return_status := x_return_status;
489: RAISE G_EXCEPTION_HALT_VALIDATION;
490: END IF;
506: ---------------------------------------------------------------------------
507: -- PROCEDURE Validate_Record
508: ---------------------------------------------------------------------------
509: --------------------------------------------------
510: -- Validate Record for:OKS_BILLRATE_SCHEDULES_V --
511: --------------------------------------------------
512: FUNCTION Validate_Record (
513: p_oks_billrate_schedules_v_rec IN OksBillrateSchedulesVRecType,
514: p_db_oks_billrate_sch1 IN OksBillrateSchedulesVRecType
509: --------------------------------------------------
510: -- Validate Record for:OKS_BILLRATE_SCHEDULES_V --
511: --------------------------------------------------
512: FUNCTION Validate_Record (
513: p_oks_billrate_schedules_v_rec IN OksBillrateSchedulesVRecType,
514: p_db_oks_billrate_sch1 IN OksBillrateSchedulesVRecType
515: ) RETURN VARCHAR2 IS
516: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
517: BEGIN
517: BEGIN
518: RETURN (l_return_status);
519: END Validate_Record;
520: FUNCTION Validate_Record (
521: p_oks_billrate_schedules_v_rec IN OksBillrateSchedulesVRecType
522: ) RETURN VARCHAR2 IS
523: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
524: l_db_oks_billrate_sch1 OksBillrateSchedulesVRecType := get_rec(p_oks_billrate_schedules_v_rec);
525: BEGIN
520: FUNCTION Validate_Record (
521: p_oks_billrate_schedules_v_rec IN OksBillrateSchedulesVRecType
522: ) RETURN VARCHAR2 IS
523: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
524: l_db_oks_billrate_sch1 OksBillrateSchedulesVRecType := get_rec(p_oks_billrate_schedules_v_rec);
525: BEGIN
526: l_return_status := Validate_Record(p_oks_billrate_schedules_v_rec => p_oks_billrate_schedules_v_rec,
527: p_db_oks_billrate_sch1 => l_db_oks_billrate_sch1);
528: RETURN (l_return_status);
522: ) RETURN VARCHAR2 IS
523: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
524: l_db_oks_billrate_sch1 OksBillrateSchedulesVRecType := get_rec(p_oks_billrate_schedules_v_rec);
525: BEGIN
526: l_return_status := Validate_Record(p_oks_billrate_schedules_v_rec => p_oks_billrate_schedules_v_rec,
527: p_db_oks_billrate_sch1 => l_db_oks_billrate_sch1);
528: RETURN (l_return_status);
529: END Validate_Record;
530:
612: ---------------------------------------------------------------------------
613: -- PROCEDURE validate_row
614: ---------------------------------------------------------------------------
615: -----------------------------------------------
616: -- validate_row for:OKS_BILLRATE_SCHEDULES_V --
617: -----------------------------------------------
618: PROCEDURE validate_row(
619: p_api_version IN NUMBER,
620: p_init_msg_list IN VARCHAR2,
620: p_init_msg_list IN VARCHAR2,
621: x_return_status OUT NOCOPY VARCHAR2,
622: x_msg_count OUT NOCOPY NUMBER,
623: x_msg_data OUT NOCOPY VARCHAR2,
624: p_oks_billrate_schedules_v_rec IN OksBillrateSchedulesVRecType) IS
625:
626: l_api_version CONSTANT NUMBER := 1;
627: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
628: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
625:
626: l_api_version CONSTANT NUMBER := 1;
627: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
628: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
629: l_oks_billrate_schedules_v_rec OksBillrateSchedulesVRecType := p_oks_billrate_schedules_v_rec;
630: l_oks_billrate_schedules_rec OksBillrateSchedulesRecType;
631: l_oks_billrate_schedules_rec OksBillrateSchedulesRecType;
632: BEGIN
633: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
642: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
643: RAISE OKC_API.G_EXCEPTION_ERROR;
644: END IF;
645: --- Validate all non-missing attributes (Item Level Validation)
646: l_return_status := Validate_Attributes(l_oks_billrate_schedules_v_rec);
647: --- If any errors happen abort API
648: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
649: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
650: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
649: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
650: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
651: RAISE OKC_API.G_EXCEPTION_ERROR;
652: END IF;
653: l_return_status := Validate_Record(l_oks_billrate_schedules_v_rec);
654: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
655: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
656: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
657: RAISE OKC_API.G_EXCEPTION_ERROR;
689: '_PVT'
690: );
691: END validate_row;
692: ----------------------------------------------------------
693: -- PL/SQL TBL validate_row for:OKS_BILLRATE_SCHEDULES_V --
694: ----------------------------------------------------------
695: PROCEDURE validate_row(
696: p_api_version IN NUMBER,
697: p_init_msg_list IN VARCHAR2,
697: p_init_msg_list IN VARCHAR2,
698: x_return_status OUT NOCOPY VARCHAR2,
699: x_msg_count OUT NOCOPY NUMBER,
700: x_msg_data OUT NOCOPY VARCHAR2,
701: p_oks_billrate_schedules_v_tbl IN OksBillrateSchedulesVTblType,
702: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
703:
704: l_api_version CONSTANT NUMBER := 1;
705: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_validate_row';
706: i NUMBER := 0;
707: BEGIN
708: OKC_API.init_msg_list(p_init_msg_list);
709: -- Make sure PL/SQL table has records in it before passing
710: IF (p_oks_billrate_schedules_v_tbl.COUNT > 0) THEN
711: i := p_oks_billrate_schedules_v_tbl.FIRST;
712: LOOP
713: DECLARE
714: l_error_rec OKC_API.ERROR_REC_TYPE;
707: BEGIN
708: OKC_API.init_msg_list(p_init_msg_list);
709: -- Make sure PL/SQL table has records in it before passing
710: IF (p_oks_billrate_schedules_v_tbl.COUNT > 0) THEN
711: i := p_oks_billrate_schedules_v_tbl.FIRST;
712: LOOP
713: DECLARE
714: l_error_rec OKC_API.ERROR_REC_TYPE;
715: BEGIN
721: p_init_msg_list => OKC_API.G_FALSE,
722: x_return_status => l_error_rec.error_type,
723: x_msg_count => l_error_rec.msg_count,
724: x_msg_data => l_error_rec.msg_data,
725: p_oks_billrate_schedules_v_rec => p_oks_billrate_schedules_v_tbl(i));
726: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
727: l_error_rec.sqlcode := SQLCODE;
728: load_error_tbl(l_error_rec, px_error_tbl);
729: ELSE
743: l_error_rec.error_type := 'OTHERS';
744: l_error_rec.sqlcode := SQLCODE;
745: load_error_tbl(l_error_rec, px_error_tbl);
746: END;
747: EXIT WHEN (i = p_oks_billrate_schedules_v_tbl.LAST);
748: i := p_oks_billrate_schedules_v_tbl.NEXT(i);
749: END LOOP;
750: END IF;
751: -- Loop through the error_tbl to find the error with the highest severity
744: l_error_rec.sqlcode := SQLCODE;
745: load_error_tbl(l_error_rec, px_error_tbl);
746: END;
747: EXIT WHEN (i = p_oks_billrate_schedules_v_tbl.LAST);
748: i := p_oks_billrate_schedules_v_tbl.NEXT(i);
749: END LOOP;
750: END IF;
751: -- Loop through the error_tbl to find the error with the highest severity
752: -- and return it.
785: );
786: END validate_row;
787:
788: ----------------------------------------------------------
789: -- PL/SQL TBL validate_row for:OKS_BILLRATE_SCHEDULES_V --
790: ----------------------------------------------------------
791: PROCEDURE validate_row(
792: p_api_version IN NUMBER,
793: p_init_msg_list IN VARCHAR2,
793: p_init_msg_list IN VARCHAR2,
794: x_return_status OUT NOCOPY VARCHAR2,
795: x_msg_count OUT NOCOPY NUMBER,
796: x_msg_data OUT NOCOPY VARCHAR2,
797: p_oks_billrate_schedules_v_tbl IN OksBillrateSchedulesVTblType) IS
798:
799: l_api_version CONSTANT NUMBER := 1;
800: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
801: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
802: l_error_tbl OKC_API.ERROR_TBL_TYPE;
803: BEGIN
804: OKC_API.init_msg_list(p_init_msg_list);
805: -- Make sure PL/SQL table has records in it before passing
806: IF (p_oks_billrate_schedules_v_tbl.COUNT > 0) THEN
807: validate_row (
808: p_api_version => p_api_version,
809: p_init_msg_list => OKC_API.G_FALSE,
810: x_return_status => x_return_status,
809: p_init_msg_list => OKC_API.G_FALSE,
810: x_return_status => x_return_status,
811: x_msg_count => x_msg_count,
812: x_msg_data => x_msg_data,
813: p_oks_billrate_schedules_v_tbl => p_oks_billrate_schedules_v_tbl,
814: px_error_tbl => l_error_tbl);
815: END IF;
816: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
817: EXCEPTION
1002: '_PVT'
1003: );
1004: END insert_row;
1005: ----------------------------------------------
1006: -- insert_row for :OKS_BILLRATE_SCHEDULES_V --
1007: ----------------------------------------------
1008: PROCEDURE insert_row(
1009: p_api_version IN NUMBER,
1010: p_init_msg_list IN VARCHAR2,
1010: p_init_msg_list IN VARCHAR2,
1011: x_return_status OUT NOCOPY VARCHAR2,
1012: x_msg_count OUT NOCOPY NUMBER,
1013: x_msg_data OUT NOCOPY VARCHAR2,
1014: p_oks_billrate_schedules_v_rec IN OksBillrateSchedulesVRecType,
1015: x_oks_billrate_schedules_v_rec OUT NOCOPY OksBillrateSchedulesVRecType) IS
1016:
1017: l_api_version CONSTANT NUMBER := 1;
1018: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
1011: x_return_status OUT NOCOPY VARCHAR2,
1012: x_msg_count OUT NOCOPY NUMBER,
1013: x_msg_data OUT NOCOPY VARCHAR2,
1014: p_oks_billrate_schedules_v_rec IN OksBillrateSchedulesVRecType,
1015: x_oks_billrate_schedules_v_rec OUT NOCOPY OksBillrateSchedulesVRecType) IS
1016:
1017: l_api_version CONSTANT NUMBER := 1;
1018: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
1019: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1016:
1017: l_api_version CONSTANT NUMBER := 1;
1018: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
1019: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1020: l_oks_billrate_schedules_v_rec OksBillrateSchedulesVRecType := p_oks_billrate_schedules_v_rec;
1021: LDefOksBillrateSchedulesVRec OksBillrateSchedulesVRecType;
1022: l_oks_billrate_schedules_rec OksBillrateSchedulesRecType;
1023: lx_oks_billrate_schedules_rec OksBillrateSchedulesRecType;
1024: -------------------------------
1024: -------------------------------
1025: -- FUNCTION fill_who_columns --
1026: -------------------------------
1027: FUNCTION fill_who_columns (
1028: p_oks_billrate_schedules_v_rec IN OksBillrateSchedulesVRecType
1029: ) RETURN OksBillrateSchedulesVRecType IS
1030: l_oks_billrate_schedules_v_rec OksBillrateSchedulesVRecType := p_oks_billrate_schedules_v_rec;
1031: BEGIN
1032: l_oks_billrate_schedules_v_rec.CREATION_DATE := SYSDATE;
1026: -------------------------------
1027: FUNCTION fill_who_columns (
1028: p_oks_billrate_schedules_v_rec IN OksBillrateSchedulesVRecType
1029: ) RETURN OksBillrateSchedulesVRecType IS
1030: l_oks_billrate_schedules_v_rec OksBillrateSchedulesVRecType := p_oks_billrate_schedules_v_rec;
1031: BEGIN
1032: l_oks_billrate_schedules_v_rec.CREATION_DATE := SYSDATE;
1033: l_oks_billrate_schedules_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1034: l_oks_billrate_schedules_v_rec.LAST_UPDATE_DATE := l_oks_billrate_schedules_v_rec.CREATION_DATE;
1028: p_oks_billrate_schedules_v_rec IN OksBillrateSchedulesVRecType
1029: ) RETURN OksBillrateSchedulesVRecType IS
1030: l_oks_billrate_schedules_v_rec OksBillrateSchedulesVRecType := p_oks_billrate_schedules_v_rec;
1031: BEGIN
1032: l_oks_billrate_schedules_v_rec.CREATION_DATE := SYSDATE;
1033: l_oks_billrate_schedules_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1034: l_oks_billrate_schedules_v_rec.LAST_UPDATE_DATE := l_oks_billrate_schedules_v_rec.CREATION_DATE;
1035: l_oks_billrate_schedules_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1036: l_oks_billrate_schedules_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1029: ) RETURN OksBillrateSchedulesVRecType IS
1030: l_oks_billrate_schedules_v_rec OksBillrateSchedulesVRecType := p_oks_billrate_schedules_v_rec;
1031: BEGIN
1032: l_oks_billrate_schedules_v_rec.CREATION_DATE := SYSDATE;
1033: l_oks_billrate_schedules_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1034: l_oks_billrate_schedules_v_rec.LAST_UPDATE_DATE := l_oks_billrate_schedules_v_rec.CREATION_DATE;
1035: l_oks_billrate_schedules_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1036: l_oks_billrate_schedules_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1037: RETURN(l_oks_billrate_schedules_v_rec);
1030: l_oks_billrate_schedules_v_rec OksBillrateSchedulesVRecType := p_oks_billrate_schedules_v_rec;
1031: BEGIN
1032: l_oks_billrate_schedules_v_rec.CREATION_DATE := SYSDATE;
1033: l_oks_billrate_schedules_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1034: l_oks_billrate_schedules_v_rec.LAST_UPDATE_DATE := l_oks_billrate_schedules_v_rec.CREATION_DATE;
1035: l_oks_billrate_schedules_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1036: l_oks_billrate_schedules_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1037: RETURN(l_oks_billrate_schedules_v_rec);
1038: END fill_who_columns;
1031: BEGIN
1032: l_oks_billrate_schedules_v_rec.CREATION_DATE := SYSDATE;
1033: l_oks_billrate_schedules_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1034: l_oks_billrate_schedules_v_rec.LAST_UPDATE_DATE := l_oks_billrate_schedules_v_rec.CREATION_DATE;
1035: l_oks_billrate_schedules_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1036: l_oks_billrate_schedules_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1037: RETURN(l_oks_billrate_schedules_v_rec);
1038: END fill_who_columns;
1039: -------------------------------------------------
1032: l_oks_billrate_schedules_v_rec.CREATION_DATE := SYSDATE;
1033: l_oks_billrate_schedules_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1034: l_oks_billrate_schedules_v_rec.LAST_UPDATE_DATE := l_oks_billrate_schedules_v_rec.CREATION_DATE;
1035: l_oks_billrate_schedules_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1036: l_oks_billrate_schedules_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1037: RETURN(l_oks_billrate_schedules_v_rec);
1038: END fill_who_columns;
1039: -------------------------------------------------
1040: -- Set_Attributes for:OKS_BILLRATE_SCHEDULES_V --
1033: l_oks_billrate_schedules_v_rec.CREATED_BY := FND_GLOBAL.USER_ID;
1034: l_oks_billrate_schedules_v_rec.LAST_UPDATE_DATE := l_oks_billrate_schedules_v_rec.CREATION_DATE;
1035: l_oks_billrate_schedules_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1036: l_oks_billrate_schedules_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1037: RETURN(l_oks_billrate_schedules_v_rec);
1038: END fill_who_columns;
1039: -------------------------------------------------
1040: -- Set_Attributes for:OKS_BILLRATE_SCHEDULES_V --
1041: -------------------------------------------------
1036: l_oks_billrate_schedules_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1037: RETURN(l_oks_billrate_schedules_v_rec);
1038: END fill_who_columns;
1039: -------------------------------------------------
1040: -- Set_Attributes for:OKS_BILLRATE_SCHEDULES_V --
1041: -------------------------------------------------
1042: FUNCTION Set_Attributes (
1043: p_oks_billrate_schedules_v_rec IN OksBillrateSchedulesVRecType,
1044: x_oks_billrate_schedules_v_rec OUT NOCOPY OksBillrateSchedulesVRecType
1039: -------------------------------------------------
1040: -- Set_Attributes for:OKS_BILLRATE_SCHEDULES_V --
1041: -------------------------------------------------
1042: FUNCTION Set_Attributes (
1043: p_oks_billrate_schedules_v_rec IN OksBillrateSchedulesVRecType,
1044: x_oks_billrate_schedules_v_rec OUT NOCOPY OksBillrateSchedulesVRecType
1045: ) RETURN VARCHAR2 IS
1046: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1047: BEGIN
1040: -- Set_Attributes for:OKS_BILLRATE_SCHEDULES_V --
1041: -------------------------------------------------
1042: FUNCTION Set_Attributes (
1043: p_oks_billrate_schedules_v_rec IN OksBillrateSchedulesVRecType,
1044: x_oks_billrate_schedules_v_rec OUT NOCOPY OksBillrateSchedulesVRecType
1045: ) RETURN VARCHAR2 IS
1046: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1047: BEGIN
1048: x_oks_billrate_schedules_v_rec := p_oks_billrate_schedules_v_rec;
1044: x_oks_billrate_schedules_v_rec OUT NOCOPY OksBillrateSchedulesVRecType
1045: ) RETURN VARCHAR2 IS
1046: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1047: BEGIN
1048: x_oks_billrate_schedules_v_rec := p_oks_billrate_schedules_v_rec;
1049: x_oks_billrate_schedules_v_rec.OBJECT_VERSION_NUMBER := 1;
1050: RETURN(l_return_status);
1051: END Set_Attributes;
1052: BEGIN
1045: ) RETURN VARCHAR2 IS
1046: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1047: BEGIN
1048: x_oks_billrate_schedules_v_rec := p_oks_billrate_schedules_v_rec;
1049: x_oks_billrate_schedules_v_rec.OBJECT_VERSION_NUMBER := 1;
1050: RETURN(l_return_status);
1051: END Set_Attributes;
1052: BEGIN
1053: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1061: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1062: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1063: RAISE OKC_API.G_EXCEPTION_ERROR;
1064: END IF;
1065: l_oks_billrate_schedules_v_rec := null_out_defaults(p_oks_billrate_schedules_v_rec);
1066: -- Set primary key value
1067: l_oks_billrate_schedules_v_rec.ID := get_seq_id;
1068: -- Setting item attributes
1069: l_return_Status := Set_Attributes(
1063: RAISE OKC_API.G_EXCEPTION_ERROR;
1064: END IF;
1065: l_oks_billrate_schedules_v_rec := null_out_defaults(p_oks_billrate_schedules_v_rec);
1066: -- Set primary key value
1067: l_oks_billrate_schedules_v_rec.ID := get_seq_id;
1068: -- Setting item attributes
1069: l_return_Status := Set_Attributes(
1070: l_oks_billrate_schedules_v_rec, -- IN
1071: LDefOksBillrateSchedulesVRec); -- OUT
1066: -- Set primary key value
1067: l_oks_billrate_schedules_v_rec.ID := get_seq_id;
1068: -- Setting item attributes
1069: l_return_Status := Set_Attributes(
1070: l_oks_billrate_schedules_v_rec, -- IN
1071: LDefOksBillrateSchedulesVRec); -- OUT
1072: --- If any errors happen abort API
1073: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1074: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1111: RAISE OKC_API.G_EXCEPTION_ERROR;
1112: END IF;
1113: migrate(lx_oks_billrate_schedules_rec, LDefOksBillrateSchedulesVRec);
1114: -- Set OUT values
1115: x_oks_billrate_schedules_v_rec := LDefOksBillrateSchedulesVRec;
1116: x_return_status := l_return_status;
1117: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1118: EXCEPTION
1119: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1147: '_PVT'
1148: );
1149: END insert_row;
1150: ------------------------------------------------------------
1151: -- PL/SQL TBL insert_row for:OKS_BILLRATE_SCHEDULES_V_TBL --
1152: ------------------------------------------------------------
1153: PROCEDURE insert_row(
1154: p_api_version IN NUMBER,
1155: p_init_msg_list IN VARCHAR2,
1155: p_init_msg_list IN VARCHAR2,
1156: x_return_status OUT NOCOPY VARCHAR2,
1157: x_msg_count OUT NOCOPY NUMBER,
1158: x_msg_data OUT NOCOPY VARCHAR2,
1159: p_oks_billrate_schedules_v_tbl IN OksBillrateSchedulesVTblType,
1160: x_oks_billrate_schedules_v_tbl OUT NOCOPY OksBillrateSchedulesVTblType,
1161: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
1162:
1163: l_api_version CONSTANT NUMBER := 1;
1156: x_return_status OUT NOCOPY VARCHAR2,
1157: x_msg_count OUT NOCOPY NUMBER,
1158: x_msg_data OUT NOCOPY VARCHAR2,
1159: p_oks_billrate_schedules_v_tbl IN OksBillrateSchedulesVTblType,
1160: x_oks_billrate_schedules_v_tbl OUT NOCOPY OksBillrateSchedulesVTblType,
1161: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
1162:
1163: l_api_version CONSTANT NUMBER := 1;
1164: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_insert_row';
1165: i NUMBER := 0;
1166: BEGIN
1167: OKC_API.init_msg_list(p_init_msg_list);
1168: -- Make sure PL/SQL table has records in it before passing
1169: IF (p_oks_billrate_schedules_v_tbl.COUNT > 0) THEN
1170: i := p_oks_billrate_schedules_v_tbl.FIRST;
1171: LOOP
1172: DECLARE
1173: l_error_rec OKC_API.ERROR_REC_TYPE;
1166: BEGIN
1167: OKC_API.init_msg_list(p_init_msg_list);
1168: -- Make sure PL/SQL table has records in it before passing
1169: IF (p_oks_billrate_schedules_v_tbl.COUNT > 0) THEN
1170: i := p_oks_billrate_schedules_v_tbl.FIRST;
1171: LOOP
1172: DECLARE
1173: l_error_rec OKC_API.ERROR_REC_TYPE;
1174: BEGIN
1180: p_init_msg_list => OKC_API.G_FALSE,
1181: x_return_status => l_error_rec.error_type,
1182: x_msg_count => l_error_rec.msg_count,
1183: x_msg_data => l_error_rec.msg_data,
1184: p_oks_billrate_schedules_v_rec => p_oks_billrate_schedules_v_tbl(i),
1185: x_oks_billrate_schedules_v_rec => x_oks_billrate_schedules_v_tbl(i));
1186: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
1187: l_error_rec.sqlcode := SQLCODE;
1188: load_error_tbl(l_error_rec, px_error_tbl);
1181: x_return_status => l_error_rec.error_type,
1182: x_msg_count => l_error_rec.msg_count,
1183: x_msg_data => l_error_rec.msg_data,
1184: p_oks_billrate_schedules_v_rec => p_oks_billrate_schedules_v_tbl(i),
1185: x_oks_billrate_schedules_v_rec => x_oks_billrate_schedules_v_tbl(i));
1186: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
1187: l_error_rec.sqlcode := SQLCODE;
1188: load_error_tbl(l_error_rec, px_error_tbl);
1189: ELSE
1203: l_error_rec.error_type := 'OTHERS';
1204: l_error_rec.sqlcode := SQLCODE;
1205: load_error_tbl(l_error_rec, px_error_tbl);
1206: END;
1207: EXIT WHEN (i = p_oks_billrate_schedules_v_tbl.LAST);
1208: i := p_oks_billrate_schedules_v_tbl.NEXT(i);
1209: END LOOP;
1210: END IF;
1211: -- Loop through the error_tbl to find the error with the highest severity
1204: l_error_rec.sqlcode := SQLCODE;
1205: load_error_tbl(l_error_rec, px_error_tbl);
1206: END;
1207: EXIT WHEN (i = p_oks_billrate_schedules_v_tbl.LAST);
1208: i := p_oks_billrate_schedules_v_tbl.NEXT(i);
1209: END LOOP;
1210: END IF;
1211: -- Loop through the error_tbl to find the error with the highest severity
1212: -- and return it.
1245: );
1246: END insert_row;
1247:
1248: ------------------------------------------------------------
1249: -- PL/SQL TBL insert_row for:OKS_BILLRATE_SCHEDULES_V_TBL --
1250: ------------------------------------------------------------
1251: -- This procedure is the same as the one above except it does not have a "px_error_tbl" argument.
1252: -- This procedure was create for backward compatibility and simply is a wrapper for the one above.
1253: PROCEDURE insert_row(
1255: p_init_msg_list IN VARCHAR2,
1256: x_return_status OUT NOCOPY VARCHAR2,
1257: x_msg_count OUT NOCOPY NUMBER,
1258: x_msg_data OUT NOCOPY VARCHAR2,
1259: p_oks_billrate_schedules_v_tbl IN OksBillrateSchedulesVTblType,
1260: x_oks_billrate_schedules_v_tbl OUT NOCOPY OksBillrateSchedulesVTblType) IS
1261:
1262: l_api_version CONSTANT NUMBER := 1;
1263: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1256: x_return_status OUT NOCOPY VARCHAR2,
1257: x_msg_count OUT NOCOPY NUMBER,
1258: x_msg_data OUT NOCOPY VARCHAR2,
1259: p_oks_billrate_schedules_v_tbl IN OksBillrateSchedulesVTblType,
1260: x_oks_billrate_schedules_v_tbl OUT NOCOPY OksBillrateSchedulesVTblType) IS
1261:
1262: l_api_version CONSTANT NUMBER := 1;
1263: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1264: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1265: l_error_tbl OKC_API.ERROR_TBL_TYPE;
1266: BEGIN
1267: OKC_API.init_msg_list(p_init_msg_list);
1268: -- Make sure PL/SQL table has records in it before passing
1269: IF (p_oks_billrate_schedules_v_tbl.COUNT > 0) THEN
1270: insert_row (
1271: p_api_version => p_api_version,
1272: p_init_msg_list => OKC_API.G_FALSE,
1273: x_return_status => x_return_status,
1272: p_init_msg_list => OKC_API.G_FALSE,
1273: x_return_status => x_return_status,
1274: x_msg_count => x_msg_count,
1275: x_msg_data => x_msg_data,
1276: p_oks_billrate_schedules_v_tbl => p_oks_billrate_schedules_v_tbl,
1277: x_oks_billrate_schedules_v_tbl => x_oks_billrate_schedules_v_tbl,
1278: px_error_tbl => l_error_tbl);
1279: END IF;
1280: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1273: x_return_status => x_return_status,
1274: x_msg_count => x_msg_count,
1275: x_msg_data => x_msg_data,
1276: p_oks_billrate_schedules_v_tbl => p_oks_billrate_schedules_v_tbl,
1277: x_oks_billrate_schedules_v_tbl => x_oks_billrate_schedules_v_tbl,
1278: px_error_tbl => l_error_tbl);
1279: END IF;
1280: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1281: EXCEPTION
1421: '_PVT'
1422: );
1423: END lock_row;
1424: --------------------------------------------
1425: -- lock_row for: OKS_BILLRATE_SCHEDULES_V --
1426: --------------------------------------------
1427: PROCEDURE lock_row(
1428: p_api_version IN NUMBER,
1429: p_init_msg_list IN VARCHAR2,
1429: p_init_msg_list IN VARCHAR2,
1430: x_return_status OUT NOCOPY VARCHAR2,
1431: x_msg_count OUT NOCOPY NUMBER,
1432: x_msg_data OUT NOCOPY VARCHAR2,
1433: p_oks_billrate_schedules_v_rec IN OksBillrateSchedulesVRecType) IS
1434:
1435: l_api_version CONSTANT NUMBER := 1;
1436: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1437: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1451: END IF;
1452: -----------------------------------------
1453: -- Move VIEW record to "Child" records --
1454: -----------------------------------------
1455: migrate(p_oks_billrate_schedules_v_rec, l_oks_billrate_schedules_rec);
1456: ---------------------------------------------
1457: -- Call the LOCK_ROW for each child record --
1458: ---------------------------------------------
1459: lock_row(
1502: '_PVT'
1503: );
1504: END lock_row;
1505: ----------------------------------------------------------
1506: -- PL/SQL TBL lock_row for:OKS_BILLRATE_SCHEDULES_V_TBL --
1507: ----------------------------------------------------------
1508: PROCEDURE lock_row(
1509: p_api_version IN NUMBER,
1510: p_init_msg_list IN VARCHAR2,
1510: p_init_msg_list IN VARCHAR2,
1511: x_return_status OUT NOCOPY VARCHAR2,
1512: x_msg_count OUT NOCOPY NUMBER,
1513: x_msg_data OUT NOCOPY VARCHAR2,
1514: p_oks_billrate_schedules_v_tbl IN OksBillrateSchedulesVTblType,
1515: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
1516:
1517: l_api_version CONSTANT NUMBER := 1;
1518: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_lock_row';
1519: i NUMBER := 0;
1520: BEGIN
1521: OKC_API.init_msg_list(p_init_msg_list);
1522: -- Make sure PL/SQL table has recrods in it before passing
1523: IF (p_oks_billrate_schedules_v_tbl.COUNT > 0) THEN
1524: i := p_oks_billrate_schedules_v_tbl.FIRST;
1525: LOOP
1526: DECLARE
1527: l_error_rec OKC_API.ERROR_REC_TYPE;
1520: BEGIN
1521: OKC_API.init_msg_list(p_init_msg_list);
1522: -- Make sure PL/SQL table has recrods in it before passing
1523: IF (p_oks_billrate_schedules_v_tbl.COUNT > 0) THEN
1524: i := p_oks_billrate_schedules_v_tbl.FIRST;
1525: LOOP
1526: DECLARE
1527: l_error_rec OKC_API.ERROR_REC_TYPE;
1528: BEGIN
1534: p_init_msg_list => OKC_API.G_FALSE,
1535: x_return_status => l_error_rec.error_type,
1536: x_msg_count => l_error_rec.msg_count,
1537: x_msg_data => l_error_rec.msg_data,
1538: p_oks_billrate_schedules_v_rec => p_oks_billrate_schedules_v_tbl(i));
1539: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
1540: l_error_rec.sqlcode := SQLCODE;
1541: load_error_tbl(l_error_rec, px_error_tbl);
1542: ELSE
1556: l_error_rec.error_type := 'OTHERS';
1557: l_error_rec.sqlcode := SQLCODE;
1558: load_error_tbl(l_error_rec, px_error_tbl);
1559: END;
1560: EXIT WHEN (i = p_oks_billrate_schedules_v_tbl.LAST);
1561: i := p_oks_billrate_schedules_v_tbl.NEXT(i);
1562: END LOOP;
1563: END IF;
1564: -- Loop through the error_tbl to find the error with the highest severity
1557: l_error_rec.sqlcode := SQLCODE;
1558: load_error_tbl(l_error_rec, px_error_tbl);
1559: END;
1560: EXIT WHEN (i = p_oks_billrate_schedules_v_tbl.LAST);
1561: i := p_oks_billrate_schedules_v_tbl.NEXT(i);
1562: END LOOP;
1563: END IF;
1564: -- Loop through the error_tbl to find the error with the highest severity
1565: -- and return it.
1597: '_PVT'
1598: );
1599: END lock_row;
1600: ----------------------------------------------------------
1601: -- PL/SQL TBL lock_row for:OKS_BILLRATE_SCHEDULES_V_TBL --
1602: ----------------------------------------------------------
1603: PROCEDURE lock_row(
1604: p_api_version IN NUMBER,
1605: p_init_msg_list IN VARCHAR2,
1605: p_init_msg_list IN VARCHAR2,
1606: x_return_status OUT NOCOPY VARCHAR2,
1607: x_msg_count OUT NOCOPY NUMBER,
1608: x_msg_data OUT NOCOPY VARCHAR2,
1609: p_oks_billrate_schedules_v_tbl IN OksBillrateSchedulesVTblType) IS
1610:
1611: l_api_version CONSTANT NUMBER := 1;
1612: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1613: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1614: l_error_tbl OKC_API.ERROR_TBL_TYPE;
1615: BEGIN
1616: OKC_API.init_msg_list(p_init_msg_list);
1617: -- Make sure PL/SQL table has recrods in it before passing
1618: IF (p_oks_billrate_schedules_v_tbl.COUNT > 0) THEN
1619: lock_row(
1620: p_api_version => p_api_version,
1621: p_init_msg_list => OKC_API.G_FALSE,
1622: x_return_status => x_return_status,
1621: p_init_msg_list => OKC_API.G_FALSE,
1622: x_return_status => x_return_status,
1623: x_msg_count => x_msg_count,
1624: x_msg_data => x_msg_data,
1625: p_oks_billrate_schedules_v_tbl => p_oks_billrate_schedules_v_tbl,
1626: px_error_tbl => l_error_tbl);
1627: END IF;
1628: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1629: EXCEPTION
1937: '_PVT'
1938: );
1939: END update_row;
1940: ---------------------------------------------
1941: -- update_row for:OKS_BILLRATE_SCHEDULES_V --
1942: ---------------------------------------------
1943: PROCEDURE update_row(
1944: p_api_version IN NUMBER,
1945: p_init_msg_list IN VARCHAR2,
1945: p_init_msg_list IN VARCHAR2,
1946: x_return_status OUT NOCOPY VARCHAR2,
1947: x_msg_count OUT NOCOPY NUMBER,
1948: x_msg_data OUT NOCOPY VARCHAR2,
1949: p_oks_billrate_schedules_v_rec IN OksBillrateSchedulesVRecType,
1950: x_oks_billrate_schedules_v_rec OUT NOCOPY OksBillrateSchedulesVRecType) IS
1951:
1952: l_api_version CONSTANT NUMBER := 1;
1953: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
1946: x_return_status OUT NOCOPY VARCHAR2,
1947: x_msg_count OUT NOCOPY NUMBER,
1948: x_msg_data OUT NOCOPY VARCHAR2,
1949: p_oks_billrate_schedules_v_rec IN OksBillrateSchedulesVRecType,
1950: x_oks_billrate_schedules_v_rec OUT NOCOPY OksBillrateSchedulesVRecType) IS
1951:
1952: l_api_version CONSTANT NUMBER := 1;
1953: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
1954: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1951:
1952: l_api_version CONSTANT NUMBER := 1;
1953: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
1954: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1955: l_oks_billrate_schedules_v_rec OksBillrateSchedulesVRecType := p_oks_billrate_schedules_v_rec;
1956: LDefOksBillrateSchedulesVRec OksBillrateSchedulesVRecType;
1957: l_db_oks_billrate_sch1 OksBillrateSchedulesVRecType;
1958: l_oks_billrate_schedules_rec OksBillrateSchedulesRecType;
1959: lx_oks_billrate_schedules_rec OksBillrateSchedulesRecType;
1960: -------------------------------
1961: -- FUNCTION fill_who_columns --
1962: -------------------------------
1963: FUNCTION fill_who_columns (
1964: p_oks_billrate_schedules_v_rec IN OksBillrateSchedulesVRecType
1965: ) RETURN OksBillrateSchedulesVRecType IS
1966: l_oks_billrate_schedules_v_rec OksBillrateSchedulesVRecType := p_oks_billrate_schedules_v_rec;
1967: BEGIN
1968: l_oks_billrate_schedules_v_rec.LAST_UPDATE_DATE := SYSDATE;
1962: -------------------------------
1963: FUNCTION fill_who_columns (
1964: p_oks_billrate_schedules_v_rec IN OksBillrateSchedulesVRecType
1965: ) RETURN OksBillrateSchedulesVRecType IS
1966: l_oks_billrate_schedules_v_rec OksBillrateSchedulesVRecType := p_oks_billrate_schedules_v_rec;
1967: BEGIN
1968: l_oks_billrate_schedules_v_rec.LAST_UPDATE_DATE := SYSDATE;
1969: l_oks_billrate_schedules_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1970: l_oks_billrate_schedules_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1964: p_oks_billrate_schedules_v_rec IN OksBillrateSchedulesVRecType
1965: ) RETURN OksBillrateSchedulesVRecType IS
1966: l_oks_billrate_schedules_v_rec OksBillrateSchedulesVRecType := p_oks_billrate_schedules_v_rec;
1967: BEGIN
1968: l_oks_billrate_schedules_v_rec.LAST_UPDATE_DATE := SYSDATE;
1969: l_oks_billrate_schedules_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1970: l_oks_billrate_schedules_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1971: RETURN(l_oks_billrate_schedules_v_rec);
1972: END fill_who_columns;
1965: ) RETURN OksBillrateSchedulesVRecType IS
1966: l_oks_billrate_schedules_v_rec OksBillrateSchedulesVRecType := p_oks_billrate_schedules_v_rec;
1967: BEGIN
1968: l_oks_billrate_schedules_v_rec.LAST_UPDATE_DATE := SYSDATE;
1969: l_oks_billrate_schedules_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1970: l_oks_billrate_schedules_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1971: RETURN(l_oks_billrate_schedules_v_rec);
1972: END fill_who_columns;
1973: ----------------------------------
1966: l_oks_billrate_schedules_v_rec OksBillrateSchedulesVRecType := p_oks_billrate_schedules_v_rec;
1967: BEGIN
1968: l_oks_billrate_schedules_v_rec.LAST_UPDATE_DATE := SYSDATE;
1969: l_oks_billrate_schedules_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1970: l_oks_billrate_schedules_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1971: RETURN(l_oks_billrate_schedules_v_rec);
1972: END fill_who_columns;
1973: ----------------------------------
1974: -- FUNCTION populate_new_record --
1967: BEGIN
1968: l_oks_billrate_schedules_v_rec.LAST_UPDATE_DATE := SYSDATE;
1969: l_oks_billrate_schedules_v_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;
1970: l_oks_billrate_schedules_v_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;
1971: RETURN(l_oks_billrate_schedules_v_rec);
1972: END fill_who_columns;
1973: ----------------------------------
1974: -- FUNCTION populate_new_record --
1975: ----------------------------------
1973: ----------------------------------
1974: -- FUNCTION populate_new_record --
1975: ----------------------------------
1976: FUNCTION populate_new_record (
1977: p_oks_billrate_schedules_v_rec IN OksBillrateSchedulesVRecType,
1978: x_oks_billrate_schedules_v_rec OUT NOCOPY OksBillrateSchedulesVRecType
1979: ) RETURN VARCHAR2 IS
1980: l_row_notfound BOOLEAN := TRUE;
1981: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1974: -- FUNCTION populate_new_record --
1975: ----------------------------------
1976: FUNCTION populate_new_record (
1977: p_oks_billrate_schedules_v_rec IN OksBillrateSchedulesVRecType,
1978: x_oks_billrate_schedules_v_rec OUT NOCOPY OksBillrateSchedulesVRecType
1979: ) RETURN VARCHAR2 IS
1980: l_row_notfound BOOLEAN := TRUE;
1981: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1982: BEGIN
1979: ) RETURN VARCHAR2 IS
1980: l_row_notfound BOOLEAN := TRUE;
1981: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1982: BEGIN
1983: x_oks_billrate_schedules_v_rec := p_oks_billrate_schedules_v_rec;
1984: -- Get current database values
1985: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it
1986: -- so it may be verified through LOCK_ROW.
1987: l_db_oks_billrate_sch1 := get_rec(p_oks_billrate_schedules_v_rec, l_return_status);
1983: x_oks_billrate_schedules_v_rec := p_oks_billrate_schedules_v_rec;
1984: -- Get current database values
1985: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it
1986: -- so it may be verified through LOCK_ROW.
1987: l_db_oks_billrate_sch1 := get_rec(p_oks_billrate_schedules_v_rec, l_return_status);
1988: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1989: IF (x_oks_billrate_schedules_v_rec.id = OKC_API.G_MISS_NUM)
1990: THEN
1991: x_oks_billrate_schedules_v_rec.id := l_db_oks_billrate_sch1.id;
1985: -- NOTE: Never assign the OBJECT_VERSION_NUMBER. Force the user to pass it
1986: -- so it may be verified through LOCK_ROW.
1987: l_db_oks_billrate_sch1 := get_rec(p_oks_billrate_schedules_v_rec, l_return_status);
1988: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1989: IF (x_oks_billrate_schedules_v_rec.id = OKC_API.G_MISS_NUM)
1990: THEN
1991: x_oks_billrate_schedules_v_rec.id := l_db_oks_billrate_sch1.id;
1992: END IF;
1993: IF (x_oks_billrate_schedules_v_rec.cle_id = OKC_API.G_MISS_NUM)
1987: l_db_oks_billrate_sch1 := get_rec(p_oks_billrate_schedules_v_rec, l_return_status);
1988: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1989: IF (x_oks_billrate_schedules_v_rec.id = OKC_API.G_MISS_NUM)
1990: THEN
1991: x_oks_billrate_schedules_v_rec.id := l_db_oks_billrate_sch1.id;
1992: END IF;
1993: IF (x_oks_billrate_schedules_v_rec.cle_id = OKC_API.G_MISS_NUM)
1994: THEN
1995: x_oks_billrate_schedules_v_rec.cle_id := l_db_oks_billrate_sch1.cle_id;
1989: IF (x_oks_billrate_schedules_v_rec.id = OKC_API.G_MISS_NUM)
1990: THEN
1991: x_oks_billrate_schedules_v_rec.id := l_db_oks_billrate_sch1.id;
1992: END IF;
1993: IF (x_oks_billrate_schedules_v_rec.cle_id = OKC_API.G_MISS_NUM)
1994: THEN
1995: x_oks_billrate_schedules_v_rec.cle_id := l_db_oks_billrate_sch1.cle_id;
1996: END IF;
1997: IF (x_oks_billrate_schedules_v_rec.bt_cle_id = OKC_API.G_MISS_NUM)
1991: x_oks_billrate_schedules_v_rec.id := l_db_oks_billrate_sch1.id;
1992: END IF;
1993: IF (x_oks_billrate_schedules_v_rec.cle_id = OKC_API.G_MISS_NUM)
1994: THEN
1995: x_oks_billrate_schedules_v_rec.cle_id := l_db_oks_billrate_sch1.cle_id;
1996: END IF;
1997: IF (x_oks_billrate_schedules_v_rec.bt_cle_id = OKC_API.G_MISS_NUM)
1998: THEN
1999: x_oks_billrate_schedules_v_rec.bt_cle_id := l_db_oks_billrate_sch1.bt_cle_id;
1993: IF (x_oks_billrate_schedules_v_rec.cle_id = OKC_API.G_MISS_NUM)
1994: THEN
1995: x_oks_billrate_schedules_v_rec.cle_id := l_db_oks_billrate_sch1.cle_id;
1996: END IF;
1997: IF (x_oks_billrate_schedules_v_rec.bt_cle_id = OKC_API.G_MISS_NUM)
1998: THEN
1999: x_oks_billrate_schedules_v_rec.bt_cle_id := l_db_oks_billrate_sch1.bt_cle_id;
2000: END IF;
2001: IF (x_oks_billrate_schedules_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM)
1995: x_oks_billrate_schedules_v_rec.cle_id := l_db_oks_billrate_sch1.cle_id;
1996: END IF;
1997: IF (x_oks_billrate_schedules_v_rec.bt_cle_id = OKC_API.G_MISS_NUM)
1998: THEN
1999: x_oks_billrate_schedules_v_rec.bt_cle_id := l_db_oks_billrate_sch1.bt_cle_id;
2000: END IF;
2001: IF (x_oks_billrate_schedules_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM)
2002: THEN
2003: x_oks_billrate_schedules_v_rec.dnz_chr_id := l_db_oks_billrate_sch1.dnz_chr_id;
1997: IF (x_oks_billrate_schedules_v_rec.bt_cle_id = OKC_API.G_MISS_NUM)
1998: THEN
1999: x_oks_billrate_schedules_v_rec.bt_cle_id := l_db_oks_billrate_sch1.bt_cle_id;
2000: END IF;
2001: IF (x_oks_billrate_schedules_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM)
2002: THEN
2003: x_oks_billrate_schedules_v_rec.dnz_chr_id := l_db_oks_billrate_sch1.dnz_chr_id;
2004: END IF;
2005: IF (x_oks_billrate_schedules_v_rec.start_hour = OKC_API.G_MISS_NUM)
1999: x_oks_billrate_schedules_v_rec.bt_cle_id := l_db_oks_billrate_sch1.bt_cle_id;
2000: END IF;
2001: IF (x_oks_billrate_schedules_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM)
2002: THEN
2003: x_oks_billrate_schedules_v_rec.dnz_chr_id := l_db_oks_billrate_sch1.dnz_chr_id;
2004: END IF;
2005: IF (x_oks_billrate_schedules_v_rec.start_hour = OKC_API.G_MISS_NUM)
2006: THEN
2007: x_oks_billrate_schedules_v_rec.start_hour := l_db_oks_billrate_sch1.start_hour;
2001: IF (x_oks_billrate_schedules_v_rec.dnz_chr_id = OKC_API.G_MISS_NUM)
2002: THEN
2003: x_oks_billrate_schedules_v_rec.dnz_chr_id := l_db_oks_billrate_sch1.dnz_chr_id;
2004: END IF;
2005: IF (x_oks_billrate_schedules_v_rec.start_hour = OKC_API.G_MISS_NUM)
2006: THEN
2007: x_oks_billrate_schedules_v_rec.start_hour := l_db_oks_billrate_sch1.start_hour;
2008: END IF;
2009: IF (x_oks_billrate_schedules_v_rec.start_minute = OKC_API.G_MISS_NUM)
2003: x_oks_billrate_schedules_v_rec.dnz_chr_id := l_db_oks_billrate_sch1.dnz_chr_id;
2004: END IF;
2005: IF (x_oks_billrate_schedules_v_rec.start_hour = OKC_API.G_MISS_NUM)
2006: THEN
2007: x_oks_billrate_schedules_v_rec.start_hour := l_db_oks_billrate_sch1.start_hour;
2008: END IF;
2009: IF (x_oks_billrate_schedules_v_rec.start_minute = OKC_API.G_MISS_NUM)
2010: THEN
2011: x_oks_billrate_schedules_v_rec.start_minute := l_db_oks_billrate_sch1.start_minute;
2005: IF (x_oks_billrate_schedules_v_rec.start_hour = OKC_API.G_MISS_NUM)
2006: THEN
2007: x_oks_billrate_schedules_v_rec.start_hour := l_db_oks_billrate_sch1.start_hour;
2008: END IF;
2009: IF (x_oks_billrate_schedules_v_rec.start_minute = OKC_API.G_MISS_NUM)
2010: THEN
2011: x_oks_billrate_schedules_v_rec.start_minute := l_db_oks_billrate_sch1.start_minute;
2012: END IF;
2013: IF (x_oks_billrate_schedules_v_rec.end_hour = OKC_API.G_MISS_NUM)
2007: x_oks_billrate_schedules_v_rec.start_hour := l_db_oks_billrate_sch1.start_hour;
2008: END IF;
2009: IF (x_oks_billrate_schedules_v_rec.start_minute = OKC_API.G_MISS_NUM)
2010: THEN
2011: x_oks_billrate_schedules_v_rec.start_minute := l_db_oks_billrate_sch1.start_minute;
2012: END IF;
2013: IF (x_oks_billrate_schedules_v_rec.end_hour = OKC_API.G_MISS_NUM)
2014: THEN
2015: x_oks_billrate_schedules_v_rec.end_hour := l_db_oks_billrate_sch1.end_hour;
2009: IF (x_oks_billrate_schedules_v_rec.start_minute = OKC_API.G_MISS_NUM)
2010: THEN
2011: x_oks_billrate_schedules_v_rec.start_minute := l_db_oks_billrate_sch1.start_minute;
2012: END IF;
2013: IF (x_oks_billrate_schedules_v_rec.end_hour = OKC_API.G_MISS_NUM)
2014: THEN
2015: x_oks_billrate_schedules_v_rec.end_hour := l_db_oks_billrate_sch1.end_hour;
2016: END IF;
2017: IF (x_oks_billrate_schedules_v_rec.end_minute = OKC_API.G_MISS_NUM)
2011: x_oks_billrate_schedules_v_rec.start_minute := l_db_oks_billrate_sch1.start_minute;
2012: END IF;
2013: IF (x_oks_billrate_schedules_v_rec.end_hour = OKC_API.G_MISS_NUM)
2014: THEN
2015: x_oks_billrate_schedules_v_rec.end_hour := l_db_oks_billrate_sch1.end_hour;
2016: END IF;
2017: IF (x_oks_billrate_schedules_v_rec.end_minute = OKC_API.G_MISS_NUM)
2018: THEN
2019: x_oks_billrate_schedules_v_rec.end_minute := l_db_oks_billrate_sch1.end_minute;
2013: IF (x_oks_billrate_schedules_v_rec.end_hour = OKC_API.G_MISS_NUM)
2014: THEN
2015: x_oks_billrate_schedules_v_rec.end_hour := l_db_oks_billrate_sch1.end_hour;
2016: END IF;
2017: IF (x_oks_billrate_schedules_v_rec.end_minute = OKC_API.G_MISS_NUM)
2018: THEN
2019: x_oks_billrate_schedules_v_rec.end_minute := l_db_oks_billrate_sch1.end_minute;
2020: END IF;
2021: IF (x_oks_billrate_schedules_v_rec.monday_flag = OKC_API.G_MISS_CHAR)
2015: x_oks_billrate_schedules_v_rec.end_hour := l_db_oks_billrate_sch1.end_hour;
2016: END IF;
2017: IF (x_oks_billrate_schedules_v_rec.end_minute = OKC_API.G_MISS_NUM)
2018: THEN
2019: x_oks_billrate_schedules_v_rec.end_minute := l_db_oks_billrate_sch1.end_minute;
2020: END IF;
2021: IF (x_oks_billrate_schedules_v_rec.monday_flag = OKC_API.G_MISS_CHAR)
2022: THEN
2023: x_oks_billrate_schedules_v_rec.monday_flag := l_db_oks_billrate_sch1.monday_flag;
2017: IF (x_oks_billrate_schedules_v_rec.end_minute = OKC_API.G_MISS_NUM)
2018: THEN
2019: x_oks_billrate_schedules_v_rec.end_minute := l_db_oks_billrate_sch1.end_minute;
2020: END IF;
2021: IF (x_oks_billrate_schedules_v_rec.monday_flag = OKC_API.G_MISS_CHAR)
2022: THEN
2023: x_oks_billrate_schedules_v_rec.monday_flag := l_db_oks_billrate_sch1.monday_flag;
2024: END IF;
2025: IF (x_oks_billrate_schedules_v_rec.tuesday_flag = OKC_API.G_MISS_CHAR)
2019: x_oks_billrate_schedules_v_rec.end_minute := l_db_oks_billrate_sch1.end_minute;
2020: END IF;
2021: IF (x_oks_billrate_schedules_v_rec.monday_flag = OKC_API.G_MISS_CHAR)
2022: THEN
2023: x_oks_billrate_schedules_v_rec.monday_flag := l_db_oks_billrate_sch1.monday_flag;
2024: END IF;
2025: IF (x_oks_billrate_schedules_v_rec.tuesday_flag = OKC_API.G_MISS_CHAR)
2026: THEN
2027: x_oks_billrate_schedules_v_rec.tuesday_flag := l_db_oks_billrate_sch1.tuesday_flag;
2021: IF (x_oks_billrate_schedules_v_rec.monday_flag = OKC_API.G_MISS_CHAR)
2022: THEN
2023: x_oks_billrate_schedules_v_rec.monday_flag := l_db_oks_billrate_sch1.monday_flag;
2024: END IF;
2025: IF (x_oks_billrate_schedules_v_rec.tuesday_flag = OKC_API.G_MISS_CHAR)
2026: THEN
2027: x_oks_billrate_schedules_v_rec.tuesday_flag := l_db_oks_billrate_sch1.tuesday_flag;
2028: END IF;
2029: IF (x_oks_billrate_schedules_v_rec.wednesday_flag = OKC_API.G_MISS_CHAR)
2023: x_oks_billrate_schedules_v_rec.monday_flag := l_db_oks_billrate_sch1.monday_flag;
2024: END IF;
2025: IF (x_oks_billrate_schedules_v_rec.tuesday_flag = OKC_API.G_MISS_CHAR)
2026: THEN
2027: x_oks_billrate_schedules_v_rec.tuesday_flag := l_db_oks_billrate_sch1.tuesday_flag;
2028: END IF;
2029: IF (x_oks_billrate_schedules_v_rec.wednesday_flag = OKC_API.G_MISS_CHAR)
2030: THEN
2031: x_oks_billrate_schedules_v_rec.wednesday_flag := l_db_oks_billrate_sch1.wednesday_flag;
2025: IF (x_oks_billrate_schedules_v_rec.tuesday_flag = OKC_API.G_MISS_CHAR)
2026: THEN
2027: x_oks_billrate_schedules_v_rec.tuesday_flag := l_db_oks_billrate_sch1.tuesday_flag;
2028: END IF;
2029: IF (x_oks_billrate_schedules_v_rec.wednesday_flag = OKC_API.G_MISS_CHAR)
2030: THEN
2031: x_oks_billrate_schedules_v_rec.wednesday_flag := l_db_oks_billrate_sch1.wednesday_flag;
2032: END IF;
2033: IF (x_oks_billrate_schedules_v_rec.thursday_flag = OKC_API.G_MISS_CHAR)
2027: x_oks_billrate_schedules_v_rec.tuesday_flag := l_db_oks_billrate_sch1.tuesday_flag;
2028: END IF;
2029: IF (x_oks_billrate_schedules_v_rec.wednesday_flag = OKC_API.G_MISS_CHAR)
2030: THEN
2031: x_oks_billrate_schedules_v_rec.wednesday_flag := l_db_oks_billrate_sch1.wednesday_flag;
2032: END IF;
2033: IF (x_oks_billrate_schedules_v_rec.thursday_flag = OKC_API.G_MISS_CHAR)
2034: THEN
2035: x_oks_billrate_schedules_v_rec.thursday_flag := l_db_oks_billrate_sch1.thursday_flag;
2029: IF (x_oks_billrate_schedules_v_rec.wednesday_flag = OKC_API.G_MISS_CHAR)
2030: THEN
2031: x_oks_billrate_schedules_v_rec.wednesday_flag := l_db_oks_billrate_sch1.wednesday_flag;
2032: END IF;
2033: IF (x_oks_billrate_schedules_v_rec.thursday_flag = OKC_API.G_MISS_CHAR)
2034: THEN
2035: x_oks_billrate_schedules_v_rec.thursday_flag := l_db_oks_billrate_sch1.thursday_flag;
2036: END IF;
2037: IF (x_oks_billrate_schedules_v_rec.friday_flag = OKC_API.G_MISS_CHAR)
2031: x_oks_billrate_schedules_v_rec.wednesday_flag := l_db_oks_billrate_sch1.wednesday_flag;
2032: END IF;
2033: IF (x_oks_billrate_schedules_v_rec.thursday_flag = OKC_API.G_MISS_CHAR)
2034: THEN
2035: x_oks_billrate_schedules_v_rec.thursday_flag := l_db_oks_billrate_sch1.thursday_flag;
2036: END IF;
2037: IF (x_oks_billrate_schedules_v_rec.friday_flag = OKC_API.G_MISS_CHAR)
2038: THEN
2039: x_oks_billrate_schedules_v_rec.friday_flag := l_db_oks_billrate_sch1.friday_flag;
2033: IF (x_oks_billrate_schedules_v_rec.thursday_flag = OKC_API.G_MISS_CHAR)
2034: THEN
2035: x_oks_billrate_schedules_v_rec.thursday_flag := l_db_oks_billrate_sch1.thursday_flag;
2036: END IF;
2037: IF (x_oks_billrate_schedules_v_rec.friday_flag = OKC_API.G_MISS_CHAR)
2038: THEN
2039: x_oks_billrate_schedules_v_rec.friday_flag := l_db_oks_billrate_sch1.friday_flag;
2040: END IF;
2041: IF (x_oks_billrate_schedules_v_rec.saturday_flag = OKC_API.G_MISS_CHAR)
2035: x_oks_billrate_schedules_v_rec.thursday_flag := l_db_oks_billrate_sch1.thursday_flag;
2036: END IF;
2037: IF (x_oks_billrate_schedules_v_rec.friday_flag = OKC_API.G_MISS_CHAR)
2038: THEN
2039: x_oks_billrate_schedules_v_rec.friday_flag := l_db_oks_billrate_sch1.friday_flag;
2040: END IF;
2041: IF (x_oks_billrate_schedules_v_rec.saturday_flag = OKC_API.G_MISS_CHAR)
2042: THEN
2043: x_oks_billrate_schedules_v_rec.saturday_flag := l_db_oks_billrate_sch1.saturday_flag;
2037: IF (x_oks_billrate_schedules_v_rec.friday_flag = OKC_API.G_MISS_CHAR)
2038: THEN
2039: x_oks_billrate_schedules_v_rec.friday_flag := l_db_oks_billrate_sch1.friday_flag;
2040: END IF;
2041: IF (x_oks_billrate_schedules_v_rec.saturday_flag = OKC_API.G_MISS_CHAR)
2042: THEN
2043: x_oks_billrate_schedules_v_rec.saturday_flag := l_db_oks_billrate_sch1.saturday_flag;
2044: END IF;
2045: IF (x_oks_billrate_schedules_v_rec.sunday_flag = OKC_API.G_MISS_CHAR)
2039: x_oks_billrate_schedules_v_rec.friday_flag := l_db_oks_billrate_sch1.friday_flag;
2040: END IF;
2041: IF (x_oks_billrate_schedules_v_rec.saturday_flag = OKC_API.G_MISS_CHAR)
2042: THEN
2043: x_oks_billrate_schedules_v_rec.saturday_flag := l_db_oks_billrate_sch1.saturday_flag;
2044: END IF;
2045: IF (x_oks_billrate_schedules_v_rec.sunday_flag = OKC_API.G_MISS_CHAR)
2046: THEN
2047: x_oks_billrate_schedules_v_rec.sunday_flag := l_db_oks_billrate_sch1.sunday_flag;
2041: IF (x_oks_billrate_schedules_v_rec.saturday_flag = OKC_API.G_MISS_CHAR)
2042: THEN
2043: x_oks_billrate_schedules_v_rec.saturday_flag := l_db_oks_billrate_sch1.saturday_flag;
2044: END IF;
2045: IF (x_oks_billrate_schedules_v_rec.sunday_flag = OKC_API.G_MISS_CHAR)
2046: THEN
2047: x_oks_billrate_schedules_v_rec.sunday_flag := l_db_oks_billrate_sch1.sunday_flag;
2048: END IF;
2049: IF (x_oks_billrate_schedules_v_rec.object1_id1 = OKC_API.G_MISS_CHAR)
2043: x_oks_billrate_schedules_v_rec.saturday_flag := l_db_oks_billrate_sch1.saturday_flag;
2044: END IF;
2045: IF (x_oks_billrate_schedules_v_rec.sunday_flag = OKC_API.G_MISS_CHAR)
2046: THEN
2047: x_oks_billrate_schedules_v_rec.sunday_flag := l_db_oks_billrate_sch1.sunday_flag;
2048: END IF;
2049: IF (x_oks_billrate_schedules_v_rec.object1_id1 = OKC_API.G_MISS_CHAR)
2050: THEN
2051: x_oks_billrate_schedules_v_rec.object1_id1 := l_db_oks_billrate_sch1.object1_id1;
2045: IF (x_oks_billrate_schedules_v_rec.sunday_flag = OKC_API.G_MISS_CHAR)
2046: THEN
2047: x_oks_billrate_schedules_v_rec.sunday_flag := l_db_oks_billrate_sch1.sunday_flag;
2048: END IF;
2049: IF (x_oks_billrate_schedules_v_rec.object1_id1 = OKC_API.G_MISS_CHAR)
2050: THEN
2051: x_oks_billrate_schedules_v_rec.object1_id1 := l_db_oks_billrate_sch1.object1_id1;
2052: END IF;
2053: IF (x_oks_billrate_schedules_v_rec.object1_id2 = OKC_API.G_MISS_CHAR)
2047: x_oks_billrate_schedules_v_rec.sunday_flag := l_db_oks_billrate_sch1.sunday_flag;
2048: END IF;
2049: IF (x_oks_billrate_schedules_v_rec.object1_id1 = OKC_API.G_MISS_CHAR)
2050: THEN
2051: x_oks_billrate_schedules_v_rec.object1_id1 := l_db_oks_billrate_sch1.object1_id1;
2052: END IF;
2053: IF (x_oks_billrate_schedules_v_rec.object1_id2 = OKC_API.G_MISS_CHAR)
2054: THEN
2055: x_oks_billrate_schedules_v_rec.object1_id2 := l_db_oks_billrate_sch1.object1_id2;
2049: IF (x_oks_billrate_schedules_v_rec.object1_id1 = OKC_API.G_MISS_CHAR)
2050: THEN
2051: x_oks_billrate_schedules_v_rec.object1_id1 := l_db_oks_billrate_sch1.object1_id1;
2052: END IF;
2053: IF (x_oks_billrate_schedules_v_rec.object1_id2 = OKC_API.G_MISS_CHAR)
2054: THEN
2055: x_oks_billrate_schedules_v_rec.object1_id2 := l_db_oks_billrate_sch1.object1_id2;
2056: END IF;
2057: IF (x_oks_billrate_schedules_v_rec.jtot_object1_code = OKC_API.G_MISS_CHAR)
2051: x_oks_billrate_schedules_v_rec.object1_id1 := l_db_oks_billrate_sch1.object1_id1;
2052: END IF;
2053: IF (x_oks_billrate_schedules_v_rec.object1_id2 = OKC_API.G_MISS_CHAR)
2054: THEN
2055: x_oks_billrate_schedules_v_rec.object1_id2 := l_db_oks_billrate_sch1.object1_id2;
2056: END IF;
2057: IF (x_oks_billrate_schedules_v_rec.jtot_object1_code = OKC_API.G_MISS_CHAR)
2058: THEN
2059: x_oks_billrate_schedules_v_rec.jtot_object1_code := l_db_oks_billrate_sch1.jtot_object1_code;
2053: IF (x_oks_billrate_schedules_v_rec.object1_id2 = OKC_API.G_MISS_CHAR)
2054: THEN
2055: x_oks_billrate_schedules_v_rec.object1_id2 := l_db_oks_billrate_sch1.object1_id2;
2056: END IF;
2057: IF (x_oks_billrate_schedules_v_rec.jtot_object1_code = OKC_API.G_MISS_CHAR)
2058: THEN
2059: x_oks_billrate_schedules_v_rec.jtot_object1_code := l_db_oks_billrate_sch1.jtot_object1_code;
2060: END IF;
2061: IF (x_oks_billrate_schedules_v_rec.bill_rate_code = OKC_API.G_MISS_CHAR)
2055: x_oks_billrate_schedules_v_rec.object1_id2 := l_db_oks_billrate_sch1.object1_id2;
2056: END IF;
2057: IF (x_oks_billrate_schedules_v_rec.jtot_object1_code = OKC_API.G_MISS_CHAR)
2058: THEN
2059: x_oks_billrate_schedules_v_rec.jtot_object1_code := l_db_oks_billrate_sch1.jtot_object1_code;
2060: END IF;
2061: IF (x_oks_billrate_schedules_v_rec.bill_rate_code = OKC_API.G_MISS_CHAR)
2062: THEN
2063: x_oks_billrate_schedules_v_rec.bill_rate_code := l_db_oks_billrate_sch1.bill_rate_code;
2057: IF (x_oks_billrate_schedules_v_rec.jtot_object1_code = OKC_API.G_MISS_CHAR)
2058: THEN
2059: x_oks_billrate_schedules_v_rec.jtot_object1_code := l_db_oks_billrate_sch1.jtot_object1_code;
2060: END IF;
2061: IF (x_oks_billrate_schedules_v_rec.bill_rate_code = OKC_API.G_MISS_CHAR)
2062: THEN
2063: x_oks_billrate_schedules_v_rec.bill_rate_code := l_db_oks_billrate_sch1.bill_rate_code;
2064: END IF;
2065: IF (x_oks_billrate_schedules_v_rec.uom = OKC_API.G_MISS_CHAR)
2059: x_oks_billrate_schedules_v_rec.jtot_object1_code := l_db_oks_billrate_sch1.jtot_object1_code;
2060: END IF;
2061: IF (x_oks_billrate_schedules_v_rec.bill_rate_code = OKC_API.G_MISS_CHAR)
2062: THEN
2063: x_oks_billrate_schedules_v_rec.bill_rate_code := l_db_oks_billrate_sch1.bill_rate_code;
2064: END IF;
2065: IF (x_oks_billrate_schedules_v_rec.uom = OKC_API.G_MISS_CHAR)
2066: THEN
2067: x_oks_billrate_schedules_v_rec.uom := l_db_oks_billrate_sch1.uom;
2061: IF (x_oks_billrate_schedules_v_rec.bill_rate_code = OKC_API.G_MISS_CHAR)
2062: THEN
2063: x_oks_billrate_schedules_v_rec.bill_rate_code := l_db_oks_billrate_sch1.bill_rate_code;
2064: END IF;
2065: IF (x_oks_billrate_schedules_v_rec.uom = OKC_API.G_MISS_CHAR)
2066: THEN
2067: x_oks_billrate_schedules_v_rec.uom := l_db_oks_billrate_sch1.uom;
2068: END IF;
2069: IF (x_oks_billrate_schedules_v_rec.flat_rate = OKC_API.G_MISS_NUM)
2063: x_oks_billrate_schedules_v_rec.bill_rate_code := l_db_oks_billrate_sch1.bill_rate_code;
2064: END IF;
2065: IF (x_oks_billrate_schedules_v_rec.uom = OKC_API.G_MISS_CHAR)
2066: THEN
2067: x_oks_billrate_schedules_v_rec.uom := l_db_oks_billrate_sch1.uom;
2068: END IF;
2069: IF (x_oks_billrate_schedules_v_rec.flat_rate = OKC_API.G_MISS_NUM)
2070: THEN
2071: x_oks_billrate_schedules_v_rec.flat_rate := l_db_oks_billrate_sch1.flat_rate;
2065: IF (x_oks_billrate_schedules_v_rec.uom = OKC_API.G_MISS_CHAR)
2066: THEN
2067: x_oks_billrate_schedules_v_rec.uom := l_db_oks_billrate_sch1.uom;
2068: END IF;
2069: IF (x_oks_billrate_schedules_v_rec.flat_rate = OKC_API.G_MISS_NUM)
2070: THEN
2071: x_oks_billrate_schedules_v_rec.flat_rate := l_db_oks_billrate_sch1.flat_rate;
2072: END IF;
2073: IF (x_oks_billrate_schedules_v_rec.holiday_yn = OKC_API.G_MISS_CHAR)
2067: x_oks_billrate_schedules_v_rec.uom := l_db_oks_billrate_sch1.uom;
2068: END IF;
2069: IF (x_oks_billrate_schedules_v_rec.flat_rate = OKC_API.G_MISS_NUM)
2070: THEN
2071: x_oks_billrate_schedules_v_rec.flat_rate := l_db_oks_billrate_sch1.flat_rate;
2072: END IF;
2073: IF (x_oks_billrate_schedules_v_rec.holiday_yn = OKC_API.G_MISS_CHAR)
2074: THEN
2075: x_oks_billrate_schedules_v_rec.holiday_yn := l_db_oks_billrate_sch1.holiday_yn;
2069: IF (x_oks_billrate_schedules_v_rec.flat_rate = OKC_API.G_MISS_NUM)
2070: THEN
2071: x_oks_billrate_schedules_v_rec.flat_rate := l_db_oks_billrate_sch1.flat_rate;
2072: END IF;
2073: IF (x_oks_billrate_schedules_v_rec.holiday_yn = OKC_API.G_MISS_CHAR)
2074: THEN
2075: x_oks_billrate_schedules_v_rec.holiday_yn := l_db_oks_billrate_sch1.holiday_yn;
2076: END IF;
2077: IF (x_oks_billrate_schedules_v_rec.percent_over_list_price = OKC_API.G_MISS_NUM)
2071: x_oks_billrate_schedules_v_rec.flat_rate := l_db_oks_billrate_sch1.flat_rate;
2072: END IF;
2073: IF (x_oks_billrate_schedules_v_rec.holiday_yn = OKC_API.G_MISS_CHAR)
2074: THEN
2075: x_oks_billrate_schedules_v_rec.holiday_yn := l_db_oks_billrate_sch1.holiday_yn;
2076: END IF;
2077: IF (x_oks_billrate_schedules_v_rec.percent_over_list_price = OKC_API.G_MISS_NUM)
2078: THEN
2079: x_oks_billrate_schedules_v_rec.percent_over_list_price := l_db_oks_billrate_sch1.percent_over_list_price;
2073: IF (x_oks_billrate_schedules_v_rec.holiday_yn = OKC_API.G_MISS_CHAR)
2074: THEN
2075: x_oks_billrate_schedules_v_rec.holiday_yn := l_db_oks_billrate_sch1.holiday_yn;
2076: END IF;
2077: IF (x_oks_billrate_schedules_v_rec.percent_over_list_price = OKC_API.G_MISS_NUM)
2078: THEN
2079: x_oks_billrate_schedules_v_rec.percent_over_list_price := l_db_oks_billrate_sch1.percent_over_list_price;
2080: END IF;
2081: IF (x_oks_billrate_schedules_v_rec.program_application_id = OKC_API.G_MISS_NUM)
2075: x_oks_billrate_schedules_v_rec.holiday_yn := l_db_oks_billrate_sch1.holiday_yn;
2076: END IF;
2077: IF (x_oks_billrate_schedules_v_rec.percent_over_list_price = OKC_API.G_MISS_NUM)
2078: THEN
2079: x_oks_billrate_schedules_v_rec.percent_over_list_price := l_db_oks_billrate_sch1.percent_over_list_price;
2080: END IF;
2081: IF (x_oks_billrate_schedules_v_rec.program_application_id = OKC_API.G_MISS_NUM)
2082: THEN
2083: x_oks_billrate_schedules_v_rec.program_application_id := l_db_oks_billrate_sch1.program_application_id;
2077: IF (x_oks_billrate_schedules_v_rec.percent_over_list_price = OKC_API.G_MISS_NUM)
2078: THEN
2079: x_oks_billrate_schedules_v_rec.percent_over_list_price := l_db_oks_billrate_sch1.percent_over_list_price;
2080: END IF;
2081: IF (x_oks_billrate_schedules_v_rec.program_application_id = OKC_API.G_MISS_NUM)
2082: THEN
2083: x_oks_billrate_schedules_v_rec.program_application_id := l_db_oks_billrate_sch1.program_application_id;
2084: END IF;
2085: IF (x_oks_billrate_schedules_v_rec.program_id = OKC_API.G_MISS_NUM)
2079: x_oks_billrate_schedules_v_rec.percent_over_list_price := l_db_oks_billrate_sch1.percent_over_list_price;
2080: END IF;
2081: IF (x_oks_billrate_schedules_v_rec.program_application_id = OKC_API.G_MISS_NUM)
2082: THEN
2083: x_oks_billrate_schedules_v_rec.program_application_id := l_db_oks_billrate_sch1.program_application_id;
2084: END IF;
2085: IF (x_oks_billrate_schedules_v_rec.program_id = OKC_API.G_MISS_NUM)
2086: THEN
2087: x_oks_billrate_schedules_v_rec.program_id := l_db_oks_billrate_sch1.program_id;
2081: IF (x_oks_billrate_schedules_v_rec.program_application_id = OKC_API.G_MISS_NUM)
2082: THEN
2083: x_oks_billrate_schedules_v_rec.program_application_id := l_db_oks_billrate_sch1.program_application_id;
2084: END IF;
2085: IF (x_oks_billrate_schedules_v_rec.program_id = OKC_API.G_MISS_NUM)
2086: THEN
2087: x_oks_billrate_schedules_v_rec.program_id := l_db_oks_billrate_sch1.program_id;
2088: END IF;
2089: IF (x_oks_billrate_schedules_v_rec.program_update_date = OKC_API.G_MISS_DATE)
2083: x_oks_billrate_schedules_v_rec.program_application_id := l_db_oks_billrate_sch1.program_application_id;
2084: END IF;
2085: IF (x_oks_billrate_schedules_v_rec.program_id = OKC_API.G_MISS_NUM)
2086: THEN
2087: x_oks_billrate_schedules_v_rec.program_id := l_db_oks_billrate_sch1.program_id;
2088: END IF;
2089: IF (x_oks_billrate_schedules_v_rec.program_update_date = OKC_API.G_MISS_DATE)
2090: THEN
2091: x_oks_billrate_schedules_v_rec.program_update_date := l_db_oks_billrate_sch1.program_update_date;
2085: IF (x_oks_billrate_schedules_v_rec.program_id = OKC_API.G_MISS_NUM)
2086: THEN
2087: x_oks_billrate_schedules_v_rec.program_id := l_db_oks_billrate_sch1.program_id;
2088: END IF;
2089: IF (x_oks_billrate_schedules_v_rec.program_update_date = OKC_API.G_MISS_DATE)
2090: THEN
2091: x_oks_billrate_schedules_v_rec.program_update_date := l_db_oks_billrate_sch1.program_update_date;
2092: END IF;
2093: IF (x_oks_billrate_schedules_v_rec.request_id = OKC_API.G_MISS_NUM)
2087: x_oks_billrate_schedules_v_rec.program_id := l_db_oks_billrate_sch1.program_id;
2088: END IF;
2089: IF (x_oks_billrate_schedules_v_rec.program_update_date = OKC_API.G_MISS_DATE)
2090: THEN
2091: x_oks_billrate_schedules_v_rec.program_update_date := l_db_oks_billrate_sch1.program_update_date;
2092: END IF;
2093: IF (x_oks_billrate_schedules_v_rec.request_id = OKC_API.G_MISS_NUM)
2094: THEN
2095: x_oks_billrate_schedules_v_rec.request_id := l_db_oks_billrate_sch1.request_id;
2089: IF (x_oks_billrate_schedules_v_rec.program_update_date = OKC_API.G_MISS_DATE)
2090: THEN
2091: x_oks_billrate_schedules_v_rec.program_update_date := l_db_oks_billrate_sch1.program_update_date;
2092: END IF;
2093: IF (x_oks_billrate_schedules_v_rec.request_id = OKC_API.G_MISS_NUM)
2094: THEN
2095: x_oks_billrate_schedules_v_rec.request_id := l_db_oks_billrate_sch1.request_id;
2096: END IF;
2097: IF (x_oks_billrate_schedules_v_rec.created_by = OKC_API.G_MISS_NUM)
2091: x_oks_billrate_schedules_v_rec.program_update_date := l_db_oks_billrate_sch1.program_update_date;
2092: END IF;
2093: IF (x_oks_billrate_schedules_v_rec.request_id = OKC_API.G_MISS_NUM)
2094: THEN
2095: x_oks_billrate_schedules_v_rec.request_id := l_db_oks_billrate_sch1.request_id;
2096: END IF;
2097: IF (x_oks_billrate_schedules_v_rec.created_by = OKC_API.G_MISS_NUM)
2098: THEN
2099: x_oks_billrate_schedules_v_rec.created_by := l_db_oks_billrate_sch1.created_by;
2093: IF (x_oks_billrate_schedules_v_rec.request_id = OKC_API.G_MISS_NUM)
2094: THEN
2095: x_oks_billrate_schedules_v_rec.request_id := l_db_oks_billrate_sch1.request_id;
2096: END IF;
2097: IF (x_oks_billrate_schedules_v_rec.created_by = OKC_API.G_MISS_NUM)
2098: THEN
2099: x_oks_billrate_schedules_v_rec.created_by := l_db_oks_billrate_sch1.created_by;
2100: END IF;
2101: IF (x_oks_billrate_schedules_v_rec.creation_date = OKC_API.G_MISS_DATE)
2095: x_oks_billrate_schedules_v_rec.request_id := l_db_oks_billrate_sch1.request_id;
2096: END IF;
2097: IF (x_oks_billrate_schedules_v_rec.created_by = OKC_API.G_MISS_NUM)
2098: THEN
2099: x_oks_billrate_schedules_v_rec.created_by := l_db_oks_billrate_sch1.created_by;
2100: END IF;
2101: IF (x_oks_billrate_schedules_v_rec.creation_date = OKC_API.G_MISS_DATE)
2102: THEN
2103: x_oks_billrate_schedules_v_rec.creation_date := l_db_oks_billrate_sch1.creation_date;
2097: IF (x_oks_billrate_schedules_v_rec.created_by = OKC_API.G_MISS_NUM)
2098: THEN
2099: x_oks_billrate_schedules_v_rec.created_by := l_db_oks_billrate_sch1.created_by;
2100: END IF;
2101: IF (x_oks_billrate_schedules_v_rec.creation_date = OKC_API.G_MISS_DATE)
2102: THEN
2103: x_oks_billrate_schedules_v_rec.creation_date := l_db_oks_billrate_sch1.creation_date;
2104: END IF;
2105: IF (x_oks_billrate_schedules_v_rec.last_updated_by = OKC_API.G_MISS_NUM)
2099: x_oks_billrate_schedules_v_rec.created_by := l_db_oks_billrate_sch1.created_by;
2100: END IF;
2101: IF (x_oks_billrate_schedules_v_rec.creation_date = OKC_API.G_MISS_DATE)
2102: THEN
2103: x_oks_billrate_schedules_v_rec.creation_date := l_db_oks_billrate_sch1.creation_date;
2104: END IF;
2105: IF (x_oks_billrate_schedules_v_rec.last_updated_by = OKC_API.G_MISS_NUM)
2106: THEN
2107: x_oks_billrate_schedules_v_rec.last_updated_by := l_db_oks_billrate_sch1.last_updated_by;
2101: IF (x_oks_billrate_schedules_v_rec.creation_date = OKC_API.G_MISS_DATE)
2102: THEN
2103: x_oks_billrate_schedules_v_rec.creation_date := l_db_oks_billrate_sch1.creation_date;
2104: END IF;
2105: IF (x_oks_billrate_schedules_v_rec.last_updated_by = OKC_API.G_MISS_NUM)
2106: THEN
2107: x_oks_billrate_schedules_v_rec.last_updated_by := l_db_oks_billrate_sch1.last_updated_by;
2108: END IF;
2109: IF (x_oks_billrate_schedules_v_rec.last_update_date = OKC_API.G_MISS_DATE)
2103: x_oks_billrate_schedules_v_rec.creation_date := l_db_oks_billrate_sch1.creation_date;
2104: END IF;
2105: IF (x_oks_billrate_schedules_v_rec.last_updated_by = OKC_API.G_MISS_NUM)
2106: THEN
2107: x_oks_billrate_schedules_v_rec.last_updated_by := l_db_oks_billrate_sch1.last_updated_by;
2108: END IF;
2109: IF (x_oks_billrate_schedules_v_rec.last_update_date = OKC_API.G_MISS_DATE)
2110: THEN
2111: x_oks_billrate_schedules_v_rec.last_update_date := l_db_oks_billrate_sch1.last_update_date;
2105: IF (x_oks_billrate_schedules_v_rec.last_updated_by = OKC_API.G_MISS_NUM)
2106: THEN
2107: x_oks_billrate_schedules_v_rec.last_updated_by := l_db_oks_billrate_sch1.last_updated_by;
2108: END IF;
2109: IF (x_oks_billrate_schedules_v_rec.last_update_date = OKC_API.G_MISS_DATE)
2110: THEN
2111: x_oks_billrate_schedules_v_rec.last_update_date := l_db_oks_billrate_sch1.last_update_date;
2112: END IF;
2113: IF (x_oks_billrate_schedules_v_rec.last_update_login = OKC_API.G_MISS_NUM)
2107: x_oks_billrate_schedules_v_rec.last_updated_by := l_db_oks_billrate_sch1.last_updated_by;
2108: END IF;
2109: IF (x_oks_billrate_schedules_v_rec.last_update_date = OKC_API.G_MISS_DATE)
2110: THEN
2111: x_oks_billrate_schedules_v_rec.last_update_date := l_db_oks_billrate_sch1.last_update_date;
2112: END IF;
2113: IF (x_oks_billrate_schedules_v_rec.last_update_login = OKC_API.G_MISS_NUM)
2114: THEN
2115: x_oks_billrate_schedules_v_rec.last_update_login := l_db_oks_billrate_sch1.last_update_login;
2109: IF (x_oks_billrate_schedules_v_rec.last_update_date = OKC_API.G_MISS_DATE)
2110: THEN
2111: x_oks_billrate_schedules_v_rec.last_update_date := l_db_oks_billrate_sch1.last_update_date;
2112: END IF;
2113: IF (x_oks_billrate_schedules_v_rec.last_update_login = OKC_API.G_MISS_NUM)
2114: THEN
2115: x_oks_billrate_schedules_v_rec.last_update_login := l_db_oks_billrate_sch1.last_update_login;
2116: END IF;
2117: IF (x_oks_billrate_schedules_v_rec.security_group_id = OKC_API.G_MISS_NUM)
2111: x_oks_billrate_schedules_v_rec.last_update_date := l_db_oks_billrate_sch1.last_update_date;
2112: END IF;
2113: IF (x_oks_billrate_schedules_v_rec.last_update_login = OKC_API.G_MISS_NUM)
2114: THEN
2115: x_oks_billrate_schedules_v_rec.last_update_login := l_db_oks_billrate_sch1.last_update_login;
2116: END IF;
2117: IF (x_oks_billrate_schedules_v_rec.security_group_id = OKC_API.G_MISS_NUM)
2118: THEN
2119: x_oks_billrate_schedules_v_rec.security_group_id := l_db_oks_billrate_sch1.security_group_id;
2113: IF (x_oks_billrate_schedules_v_rec.last_update_login = OKC_API.G_MISS_NUM)
2114: THEN
2115: x_oks_billrate_schedules_v_rec.last_update_login := l_db_oks_billrate_sch1.last_update_login;
2116: END IF;
2117: IF (x_oks_billrate_schedules_v_rec.security_group_id = OKC_API.G_MISS_NUM)
2118: THEN
2119: x_oks_billrate_schedules_v_rec.security_group_id := l_db_oks_billrate_sch1.security_group_id;
2120: END IF;
2121: END IF;
2115: x_oks_billrate_schedules_v_rec.last_update_login := l_db_oks_billrate_sch1.last_update_login;
2116: END IF;
2117: IF (x_oks_billrate_schedules_v_rec.security_group_id = OKC_API.G_MISS_NUM)
2118: THEN
2119: x_oks_billrate_schedules_v_rec.security_group_id := l_db_oks_billrate_sch1.security_group_id;
2120: END IF;
2121: END IF;
2122: RETURN(l_return_status);
2123: END populate_new_record;
2121: END IF;
2122: RETURN(l_return_status);
2123: END populate_new_record;
2124: -------------------------------------------------
2125: -- Set_Attributes for:OKS_BILLRATE_SCHEDULES_V --
2126: -------------------------------------------------
2127: FUNCTION Set_Attributes (
2128: p_oks_billrate_schedules_v_rec IN OksBillrateSchedulesVRecType,
2129: x_oks_billrate_schedules_v_rec OUT NOCOPY OksBillrateSchedulesVRecType
2124: -------------------------------------------------
2125: -- Set_Attributes for:OKS_BILLRATE_SCHEDULES_V --
2126: -------------------------------------------------
2127: FUNCTION Set_Attributes (
2128: p_oks_billrate_schedules_v_rec IN OksBillrateSchedulesVRecType,
2129: x_oks_billrate_schedules_v_rec OUT NOCOPY OksBillrateSchedulesVRecType
2130: ) RETURN VARCHAR2 IS
2131: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2132: BEGIN
2125: -- Set_Attributes for:OKS_BILLRATE_SCHEDULES_V --
2126: -------------------------------------------------
2127: FUNCTION Set_Attributes (
2128: p_oks_billrate_schedules_v_rec IN OksBillrateSchedulesVRecType,
2129: x_oks_billrate_schedules_v_rec OUT NOCOPY OksBillrateSchedulesVRecType
2130: ) RETURN VARCHAR2 IS
2131: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2132: BEGIN
2133: x_oks_billrate_schedules_v_rec := p_oks_billrate_schedules_v_rec;
2129: x_oks_billrate_schedules_v_rec OUT NOCOPY OksBillrateSchedulesVRecType
2130: ) RETURN VARCHAR2 IS
2131: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2132: BEGIN
2133: x_oks_billrate_schedules_v_rec := p_oks_billrate_schedules_v_rec;
2134: RETURN(l_return_status);
2135: END Set_Attributes;
2136: BEGIN
2137: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2147: RAISE OKC_API.G_EXCEPTION_ERROR;
2148: END IF;
2149: --- Setting item attributes
2150: l_return_status := Set_Attributes(
2151: p_oks_billrate_schedules_v_rec, -- IN
2152: x_oks_billrate_schedules_v_rec); -- OUT
2153: --- If any errors happen abort API
2154: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2155: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2148: END IF;
2149: --- Setting item attributes
2150: l_return_status := Set_Attributes(
2151: p_oks_billrate_schedules_v_rec, -- IN
2152: x_oks_billrate_schedules_v_rec); -- OUT
2153: --- If any errors happen abort API
2154: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2155: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2156: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2155: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2156: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2157: RAISE OKC_API.G_EXCEPTION_ERROR;
2158: END IF;
2159: l_return_status := populate_new_record(l_oks_billrate_schedules_v_rec, LDefOksBillrateSchedulesVRec);
2160: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2161: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2162: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2163: RAISE OKC_API.G_EXCEPTION_ERROR;
2184: p_init_msg_list => p_init_msg_list,
2185: x_return_status => l_return_status,
2186: x_msg_count => x_msg_count,
2187: x_msg_data => x_msg_data,
2188: p_oks_billrate_schedules_v_rec => p_oks_billrate_schedules_v_rec);
2189: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2190: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2191: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2192: RAISE OKC_API.G_EXCEPTION_ERROR;
2212: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2213: RAISE OKC_API.G_EXCEPTION_ERROR;
2214: END IF;
2215: migrate(lx_oks_billrate_schedules_rec, LDefOksBillrateSchedulesVRec);
2216: x_oks_billrate_schedules_v_rec := LDefOksBillrateSchedulesVRec;
2217: x_return_status := l_return_status;
2218: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2219: EXCEPTION
2220: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2248: '_PVT'
2249: );
2250: END update_row;
2251: ------------------------------------------------------------
2252: -- PL/SQL TBL update_row for:oks_billrate_schedules_v_tbl --
2253: ------------------------------------------------------------
2254: PROCEDURE update_row(
2255: p_api_version IN NUMBER,
2256: p_init_msg_list IN VARCHAR2,
2256: p_init_msg_list IN VARCHAR2,
2257: x_return_status OUT NOCOPY VARCHAR2,
2258: x_msg_count OUT NOCOPY NUMBER,
2259: x_msg_data OUT NOCOPY VARCHAR2,
2260: p_oks_billrate_schedules_v_tbl IN OksBillrateSchedulesVTblType,
2261: x_oks_billrate_schedules_v_tbl OUT NOCOPY OksBillrateSchedulesVTblType,
2262: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
2263:
2264: l_api_version CONSTANT NUMBER := 1;
2257: x_return_status OUT NOCOPY VARCHAR2,
2258: x_msg_count OUT NOCOPY NUMBER,
2259: x_msg_data OUT NOCOPY VARCHAR2,
2260: p_oks_billrate_schedules_v_tbl IN OksBillrateSchedulesVTblType,
2261: x_oks_billrate_schedules_v_tbl OUT NOCOPY OksBillrateSchedulesVTblType,
2262: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
2263:
2264: l_api_version CONSTANT NUMBER := 1;
2265: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_update_row';
2266: i NUMBER := 0;
2267: BEGIN
2268: OKC_API.init_msg_list(p_init_msg_list);
2269: -- Make sure PL/SQL table has records in it before passing
2270: IF (p_oks_billrate_schedules_v_tbl.COUNT > 0) THEN
2271: i := p_oks_billrate_schedules_v_tbl.FIRST;
2272: LOOP
2273: DECLARE
2274: l_error_rec OKC_API.ERROR_REC_TYPE;
2267: BEGIN
2268: OKC_API.init_msg_list(p_init_msg_list);
2269: -- Make sure PL/SQL table has records in it before passing
2270: IF (p_oks_billrate_schedules_v_tbl.COUNT > 0) THEN
2271: i := p_oks_billrate_schedules_v_tbl.FIRST;
2272: LOOP
2273: DECLARE
2274: l_error_rec OKC_API.ERROR_REC_TYPE;
2275: BEGIN
2281: p_init_msg_list => OKC_API.G_FALSE,
2282: x_return_status => l_error_rec.error_type,
2283: x_msg_count => l_error_rec.msg_count,
2284: x_msg_data => l_error_rec.msg_data,
2285: p_oks_billrate_schedules_v_rec => p_oks_billrate_schedules_v_tbl(i),
2286: x_oks_billrate_schedules_v_rec => x_oks_billrate_schedules_v_tbl(i));
2287: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
2288: l_error_rec.sqlcode := SQLCODE;
2289: load_error_tbl(l_error_rec, px_error_tbl);
2282: x_return_status => l_error_rec.error_type,
2283: x_msg_count => l_error_rec.msg_count,
2284: x_msg_data => l_error_rec.msg_data,
2285: p_oks_billrate_schedules_v_rec => p_oks_billrate_schedules_v_tbl(i),
2286: x_oks_billrate_schedules_v_rec => x_oks_billrate_schedules_v_tbl(i));
2287: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
2288: l_error_rec.sqlcode := SQLCODE;
2289: load_error_tbl(l_error_rec, px_error_tbl);
2290: ELSE
2304: l_error_rec.error_type := 'OTHERS';
2305: l_error_rec.sqlcode := SQLCODE;
2306: load_error_tbl(l_error_rec, px_error_tbl);
2307: END;
2308: EXIT WHEN (i = p_oks_billrate_schedules_v_tbl.LAST);
2309: i := p_oks_billrate_schedules_v_tbl.NEXT(i);
2310: END LOOP;
2311: END IF;
2312: -- Loop through the error_tbl to find the error with the highest severity
2305: l_error_rec.sqlcode := SQLCODE;
2306: load_error_tbl(l_error_rec, px_error_tbl);
2307: END;
2308: EXIT WHEN (i = p_oks_billrate_schedules_v_tbl.LAST);
2309: i := p_oks_billrate_schedules_v_tbl.NEXT(i);
2310: END LOOP;
2311: END IF;
2312: -- Loop through the error_tbl to find the error with the highest severity
2313: -- and return it.
2346: );
2347: END update_row;
2348:
2349: ------------------------------------------------------------
2350: -- PL/SQL TBL update_row for:OKS_BILLRATE_SCHEDULES_V_TBL --
2351: ------------------------------------------------------------
2352: -- This procedure is the same as the one above except it does not have a "px_error_tbl" argument.
2353: -- This procedure was create for backward compatibility and simply is a wrapper for the one above.
2354: PROCEDURE update_row(
2356: p_init_msg_list IN VARCHAR2,
2357: x_return_status OUT NOCOPY VARCHAR2,
2358: x_msg_count OUT NOCOPY NUMBER,
2359: x_msg_data OUT NOCOPY VARCHAR2,
2360: p_oks_billrate_schedules_v_tbl IN OksBillrateSchedulesVTblType,
2361: x_oks_billrate_schedules_v_tbl OUT NOCOPY OksBillrateSchedulesVTblType) IS
2362:
2363: l_api_version CONSTANT NUMBER := 1;
2364: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2357: x_return_status OUT NOCOPY VARCHAR2,
2358: x_msg_count OUT NOCOPY NUMBER,
2359: x_msg_data OUT NOCOPY VARCHAR2,
2360: p_oks_billrate_schedules_v_tbl IN OksBillrateSchedulesVTblType,
2361: x_oks_billrate_schedules_v_tbl OUT NOCOPY OksBillrateSchedulesVTblType) IS
2362:
2363: l_api_version CONSTANT NUMBER := 1;
2364: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2365: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2366: l_error_tbl OKC_API.ERROR_TBL_TYPE;
2367: BEGIN
2368: OKC_API.init_msg_list(p_init_msg_list);
2369: -- Make sure PL/SQL table has records in it before passing
2370: IF (p_oks_billrate_schedules_v_tbl.COUNT > 0) THEN
2371: update_row (
2372: p_api_version => p_api_version,
2373: p_init_msg_list => OKC_API.G_FALSE,
2374: x_return_status => x_return_status,
2373: p_init_msg_list => OKC_API.G_FALSE,
2374: x_return_status => x_return_status,
2375: x_msg_count => x_msg_count,
2376: x_msg_data => x_msg_data,
2377: p_oks_billrate_schedules_v_tbl => p_oks_billrate_schedules_v_tbl,
2378: x_oks_billrate_schedules_v_tbl => x_oks_billrate_schedules_v_tbl,
2379: px_error_tbl => l_error_tbl);
2380: END IF;
2381: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2374: x_return_status => x_return_status,
2375: x_msg_count => x_msg_count,
2376: x_msg_data => x_msg_data,
2377: p_oks_billrate_schedules_v_tbl => p_oks_billrate_schedules_v_tbl,
2378: x_oks_billrate_schedules_v_tbl => x_oks_billrate_schedules_v_tbl,
2379: px_error_tbl => l_error_tbl);
2380: END IF;
2381: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2382: EXCEPTION
2478: '_PVT'
2479: );
2480: END delete_row;
2481: ---------------------------------------------
2482: -- delete_row for:OKS_BILLRATE_SCHEDULES_V --
2483: ---------------------------------------------
2484: PROCEDURE delete_row(
2485: p_api_version IN NUMBER,
2486: p_init_msg_list IN VARCHAR2,
2486: p_init_msg_list IN VARCHAR2,
2487: x_return_status OUT NOCOPY VARCHAR2,
2488: x_msg_count OUT NOCOPY NUMBER,
2489: x_msg_data OUT NOCOPY VARCHAR2,
2490: p_oks_billrate_schedules_v_rec IN OksBillrateSchedulesVRecType) IS
2491:
2492: l_api_version CONSTANT NUMBER := 1;
2493: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
2494: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2491:
2492: l_api_version CONSTANT NUMBER := 1;
2493: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
2494: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2495: l_oks_billrate_schedules_v_rec OksBillrateSchedulesVRecType := p_oks_billrate_schedules_v_rec;
2496: l_oks_billrate_schedules_rec OksBillrateSchedulesRecType;
2497: BEGIN
2498: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
2499: G_PKG_NAME,
2509: END IF;
2510: -----------------------------------------
2511: -- Move VIEW record to "Child" records --
2512: -----------------------------------------
2513: migrate(l_oks_billrate_schedules_v_rec, l_oks_billrate_schedules_rec);
2514: -----------------------------------------------
2515: -- Call the DELETE_ROW for each child record --
2516: -----------------------------------------------
2517: delete_row(
2560: '_PVT'
2561: );
2562: END delete_row;
2563: --------------------------------------------------------
2564: -- PL/SQL TBL delete_row for:OKS_BILLRATE_SCHEDULES_V --
2565: --------------------------------------------------------
2566: PROCEDURE delete_row(
2567: p_api_version IN NUMBER,
2568: p_init_msg_list IN VARCHAR2,
2568: p_init_msg_list IN VARCHAR2,
2569: x_return_status OUT NOCOPY VARCHAR2,
2570: x_msg_count OUT NOCOPY NUMBER,
2571: x_msg_data OUT NOCOPY VARCHAR2,
2572: p_oks_billrate_schedules_v_tbl IN OksBillrateSchedulesVTblType,
2573: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE) IS
2574:
2575: l_api_version CONSTANT NUMBER := 1;
2576: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_delete_row';
2577: i NUMBER := 0;
2578: BEGIN
2579: OKC_API.init_msg_list(p_init_msg_list);
2580: -- Make sure PL/SQL table has records in it before passing
2581: IF (p_oks_billrate_schedules_v_tbl.COUNT > 0) THEN
2582: i := p_oks_billrate_schedules_v_tbl.FIRST;
2583: LOOP
2584: DECLARE
2585: l_error_rec OKC_API.ERROR_REC_TYPE;
2578: BEGIN
2579: OKC_API.init_msg_list(p_init_msg_list);
2580: -- Make sure PL/SQL table has records in it before passing
2581: IF (p_oks_billrate_schedules_v_tbl.COUNT > 0) THEN
2582: i := p_oks_billrate_schedules_v_tbl.FIRST;
2583: LOOP
2584: DECLARE
2585: l_error_rec OKC_API.ERROR_REC_TYPE;
2586: BEGIN
2592: p_init_msg_list => OKC_API.G_FALSE,
2593: x_return_status => l_error_rec.error_type,
2594: x_msg_count => l_error_rec.msg_count,
2595: x_msg_data => l_error_rec.msg_data,
2596: p_oks_billrate_schedules_v_rec => p_oks_billrate_schedules_v_tbl(i));
2597: IF (l_error_rec.error_type <> OKC_API.G_RET_STS_SUCCESS) THEN
2598: l_error_rec.sqlcode := SQLCODE;
2599: load_error_tbl(l_error_rec, px_error_tbl);
2600: ELSE
2614: l_error_rec.error_type := 'OTHERS';
2615: l_error_rec.sqlcode := SQLCODE;
2616: load_error_tbl(l_error_rec, px_error_tbl);
2617: END;
2618: EXIT WHEN (i = p_oks_billrate_schedules_v_tbl.LAST);
2619: i := p_oks_billrate_schedules_v_tbl.NEXT(i);
2620: END LOOP;
2621: END IF;
2622: -- Loop through the error_tbl to find the error with the highest severity
2615: l_error_rec.sqlcode := SQLCODE;
2616: load_error_tbl(l_error_rec, px_error_tbl);
2617: END;
2618: EXIT WHEN (i = p_oks_billrate_schedules_v_tbl.LAST);
2619: i := p_oks_billrate_schedules_v_tbl.NEXT(i);
2620: END LOOP;
2621: END IF;
2622: -- Loop through the error_tbl to find the error with the highest severity
2623: -- and return it.
2656: );
2657: END delete_row;
2658:
2659: --------------------------------------------------------
2660: -- PL/SQL TBL delete_row for:OKS_BILLRATE_SCHEDULES_V --
2661: --------------------------------------------------------
2662: PROCEDURE delete_row(
2663: p_api_version IN NUMBER,
2664: p_init_msg_list IN VARCHAR2,
2664: p_init_msg_list IN VARCHAR2,
2665: x_return_status OUT NOCOPY VARCHAR2,
2666: x_msg_count OUT NOCOPY NUMBER,
2667: x_msg_data OUT NOCOPY VARCHAR2,
2668: p_oks_billrate_schedules_v_tbl IN OksBillrateSchedulesVTblType) IS
2669:
2670: l_api_version CONSTANT NUMBER := 1;
2671: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
2672: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2673: l_error_tbl OKC_API.ERROR_TBL_TYPE;
2674: BEGIN
2675: OKC_API.init_msg_list(p_init_msg_list);
2676: -- Make sure PL/SQL table has records in it before passing
2677: IF (p_oks_billrate_schedules_v_tbl.COUNT > 0) THEN
2678: delete_row (
2679: p_api_version => p_api_version,
2680: p_init_msg_list => OKC_API.G_FALSE,
2681: x_return_status => x_return_status,
2680: p_init_msg_list => OKC_API.G_FALSE,
2681: x_return_status => x_return_status,
2682: x_msg_count => x_msg_count,
2683: x_msg_data => x_msg_data,
2684: p_oks_billrate_schedules_v_tbl => p_oks_billrate_schedules_v_tbl,
2685: px_error_tbl => l_error_tbl);
2686: END IF;
2687: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2688: EXCEPTION