200:
201:
202:
203: TYPE brs_rec_type IS RECORD
204: (START_HOUR OKS_BILLRATE_SCHEDULES.START_HOUR%TYPE,
205: START_MINUTE OKS_BILLRATE_SCHEDULES.START_MINUTE%TYPE,
206: END_HOUR OKS_BILLRATE_SCHEDULES.END_MINUTE%TYPE,
207: END_MINUTE OKS_BILLRATE_SCHEDULES.END_MINUTE%TYPE,
208: MONDAY_FLAG OKS_BILLRATE_SCHEDULES.MONDAY_FLAG%TYPE,
201:
202:
203: TYPE brs_rec_type IS RECORD
204: (START_HOUR OKS_BILLRATE_SCHEDULES.START_HOUR%TYPE,
205: START_MINUTE OKS_BILLRATE_SCHEDULES.START_MINUTE%TYPE,
206: END_HOUR OKS_BILLRATE_SCHEDULES.END_MINUTE%TYPE,
207: END_MINUTE OKS_BILLRATE_SCHEDULES.END_MINUTE%TYPE,
208: MONDAY_FLAG OKS_BILLRATE_SCHEDULES.MONDAY_FLAG%TYPE,
209: TUESDAY_FLAG OKS_BILLRATE_SCHEDULES.TUESDAY_FLAG%TYPE,
202:
203: TYPE brs_rec_type IS RECORD
204: (START_HOUR OKS_BILLRATE_SCHEDULES.START_HOUR%TYPE,
205: START_MINUTE OKS_BILLRATE_SCHEDULES.START_MINUTE%TYPE,
206: END_HOUR OKS_BILLRATE_SCHEDULES.END_MINUTE%TYPE,
207: END_MINUTE OKS_BILLRATE_SCHEDULES.END_MINUTE%TYPE,
208: MONDAY_FLAG OKS_BILLRATE_SCHEDULES.MONDAY_FLAG%TYPE,
209: TUESDAY_FLAG OKS_BILLRATE_SCHEDULES.TUESDAY_FLAG%TYPE,
210: WEDNESDAY_FLAG OKS_BILLRATE_SCHEDULES.WEDNESDAY_FLAG%TYPE,
203: TYPE brs_rec_type IS RECORD
204: (START_HOUR OKS_BILLRATE_SCHEDULES.START_HOUR%TYPE,
205: START_MINUTE OKS_BILLRATE_SCHEDULES.START_MINUTE%TYPE,
206: END_HOUR OKS_BILLRATE_SCHEDULES.END_MINUTE%TYPE,
207: END_MINUTE OKS_BILLRATE_SCHEDULES.END_MINUTE%TYPE,
208: MONDAY_FLAG OKS_BILLRATE_SCHEDULES.MONDAY_FLAG%TYPE,
209: TUESDAY_FLAG OKS_BILLRATE_SCHEDULES.TUESDAY_FLAG%TYPE,
210: WEDNESDAY_FLAG OKS_BILLRATE_SCHEDULES.WEDNESDAY_FLAG%TYPE,
211: THURSDAY_FLAG OKS_BILLRATE_SCHEDULES.THURSDAY_FLAG%TYPE,
204: (START_HOUR OKS_BILLRATE_SCHEDULES.START_HOUR%TYPE,
205: START_MINUTE OKS_BILLRATE_SCHEDULES.START_MINUTE%TYPE,
206: END_HOUR OKS_BILLRATE_SCHEDULES.END_MINUTE%TYPE,
207: END_MINUTE OKS_BILLRATE_SCHEDULES.END_MINUTE%TYPE,
208: MONDAY_FLAG OKS_BILLRATE_SCHEDULES.MONDAY_FLAG%TYPE,
209: TUESDAY_FLAG OKS_BILLRATE_SCHEDULES.TUESDAY_FLAG%TYPE,
210: WEDNESDAY_FLAG OKS_BILLRATE_SCHEDULES.WEDNESDAY_FLAG%TYPE,
211: THURSDAY_FLAG OKS_BILLRATE_SCHEDULES.THURSDAY_FLAG%TYPE,
212: FRIDAY_FLAG OKS_BILLRATE_SCHEDULES.FRIDAY_FLAG%TYPE,
205: START_MINUTE OKS_BILLRATE_SCHEDULES.START_MINUTE%TYPE,
206: END_HOUR OKS_BILLRATE_SCHEDULES.END_MINUTE%TYPE,
207: END_MINUTE OKS_BILLRATE_SCHEDULES.END_MINUTE%TYPE,
208: MONDAY_FLAG OKS_BILLRATE_SCHEDULES.MONDAY_FLAG%TYPE,
209: TUESDAY_FLAG OKS_BILLRATE_SCHEDULES.TUESDAY_FLAG%TYPE,
210: WEDNESDAY_FLAG OKS_BILLRATE_SCHEDULES.WEDNESDAY_FLAG%TYPE,
211: THURSDAY_FLAG OKS_BILLRATE_SCHEDULES.THURSDAY_FLAG%TYPE,
212: FRIDAY_FLAG OKS_BILLRATE_SCHEDULES.FRIDAY_FLAG%TYPE,
213: SATURDAY_FLAG OKS_BILLRATE_SCHEDULES.SATURDAY_FLAG%TYPE,
206: END_HOUR OKS_BILLRATE_SCHEDULES.END_MINUTE%TYPE,
207: END_MINUTE OKS_BILLRATE_SCHEDULES.END_MINUTE%TYPE,
208: MONDAY_FLAG OKS_BILLRATE_SCHEDULES.MONDAY_FLAG%TYPE,
209: TUESDAY_FLAG OKS_BILLRATE_SCHEDULES.TUESDAY_FLAG%TYPE,
210: WEDNESDAY_FLAG OKS_BILLRATE_SCHEDULES.WEDNESDAY_FLAG%TYPE,
211: THURSDAY_FLAG OKS_BILLRATE_SCHEDULES.THURSDAY_FLAG%TYPE,
212: FRIDAY_FLAG OKS_BILLRATE_SCHEDULES.FRIDAY_FLAG%TYPE,
213: SATURDAY_FLAG OKS_BILLRATE_SCHEDULES.SATURDAY_FLAG%TYPE,
214: SUNDAY_FLAG OKS_BILLRATE_SCHEDULES.SUNDAY_FLAG%TYPE,
207: END_MINUTE OKS_BILLRATE_SCHEDULES.END_MINUTE%TYPE,
208: MONDAY_FLAG OKS_BILLRATE_SCHEDULES.MONDAY_FLAG%TYPE,
209: TUESDAY_FLAG OKS_BILLRATE_SCHEDULES.TUESDAY_FLAG%TYPE,
210: WEDNESDAY_FLAG OKS_BILLRATE_SCHEDULES.WEDNESDAY_FLAG%TYPE,
211: THURSDAY_FLAG OKS_BILLRATE_SCHEDULES.THURSDAY_FLAG%TYPE,
212: FRIDAY_FLAG OKS_BILLRATE_SCHEDULES.FRIDAY_FLAG%TYPE,
213: SATURDAY_FLAG OKS_BILLRATE_SCHEDULES.SATURDAY_FLAG%TYPE,
214: SUNDAY_FLAG OKS_BILLRATE_SCHEDULES.SUNDAY_FLAG%TYPE,
215: OBJECT1_ID1 OKS_BILLRATE_SCHEDULES.OBJECT1_ID1%TYPE,
208: MONDAY_FLAG OKS_BILLRATE_SCHEDULES.MONDAY_FLAG%TYPE,
209: TUESDAY_FLAG OKS_BILLRATE_SCHEDULES.TUESDAY_FLAG%TYPE,
210: WEDNESDAY_FLAG OKS_BILLRATE_SCHEDULES.WEDNESDAY_FLAG%TYPE,
211: THURSDAY_FLAG OKS_BILLRATE_SCHEDULES.THURSDAY_FLAG%TYPE,
212: FRIDAY_FLAG OKS_BILLRATE_SCHEDULES.FRIDAY_FLAG%TYPE,
213: SATURDAY_FLAG OKS_BILLRATE_SCHEDULES.SATURDAY_FLAG%TYPE,
214: SUNDAY_FLAG OKS_BILLRATE_SCHEDULES.SUNDAY_FLAG%TYPE,
215: OBJECT1_ID1 OKS_BILLRATE_SCHEDULES.OBJECT1_ID1%TYPE,
216: OBJECT1_ID2 OKS_BILLRATE_SCHEDULES.OBJECT1_ID2%TYPE,
209: TUESDAY_FLAG OKS_BILLRATE_SCHEDULES.TUESDAY_FLAG%TYPE,
210: WEDNESDAY_FLAG OKS_BILLRATE_SCHEDULES.WEDNESDAY_FLAG%TYPE,
211: THURSDAY_FLAG OKS_BILLRATE_SCHEDULES.THURSDAY_FLAG%TYPE,
212: FRIDAY_FLAG OKS_BILLRATE_SCHEDULES.FRIDAY_FLAG%TYPE,
213: SATURDAY_FLAG OKS_BILLRATE_SCHEDULES.SATURDAY_FLAG%TYPE,
214: SUNDAY_FLAG OKS_BILLRATE_SCHEDULES.SUNDAY_FLAG%TYPE,
215: OBJECT1_ID1 OKS_BILLRATE_SCHEDULES.OBJECT1_ID1%TYPE,
216: OBJECT1_ID2 OKS_BILLRATE_SCHEDULES.OBJECT1_ID2%TYPE,
217: JTOT_OBJECT1_CODE OKS_BILLRATE_SCHEDULES.JTOT_OBJECT1_CODE%TYPE,
210: WEDNESDAY_FLAG OKS_BILLRATE_SCHEDULES.WEDNESDAY_FLAG%TYPE,
211: THURSDAY_FLAG OKS_BILLRATE_SCHEDULES.THURSDAY_FLAG%TYPE,
212: FRIDAY_FLAG OKS_BILLRATE_SCHEDULES.FRIDAY_FLAG%TYPE,
213: SATURDAY_FLAG OKS_BILLRATE_SCHEDULES.SATURDAY_FLAG%TYPE,
214: SUNDAY_FLAG OKS_BILLRATE_SCHEDULES.SUNDAY_FLAG%TYPE,
215: OBJECT1_ID1 OKS_BILLRATE_SCHEDULES.OBJECT1_ID1%TYPE,
216: OBJECT1_ID2 OKS_BILLRATE_SCHEDULES.OBJECT1_ID2%TYPE,
217: JTOT_OBJECT1_CODE OKS_BILLRATE_SCHEDULES.JTOT_OBJECT1_CODE%TYPE,
218: BILL_RATE_CODE OKS_BILLRATE_SCHEDULES.BILL_RATE_CODE%TYPE,
211: THURSDAY_FLAG OKS_BILLRATE_SCHEDULES.THURSDAY_FLAG%TYPE,
212: FRIDAY_FLAG OKS_BILLRATE_SCHEDULES.FRIDAY_FLAG%TYPE,
213: SATURDAY_FLAG OKS_BILLRATE_SCHEDULES.SATURDAY_FLAG%TYPE,
214: SUNDAY_FLAG OKS_BILLRATE_SCHEDULES.SUNDAY_FLAG%TYPE,
215: OBJECT1_ID1 OKS_BILLRATE_SCHEDULES.OBJECT1_ID1%TYPE,
216: OBJECT1_ID2 OKS_BILLRATE_SCHEDULES.OBJECT1_ID2%TYPE,
217: JTOT_OBJECT1_CODE OKS_BILLRATE_SCHEDULES.JTOT_OBJECT1_CODE%TYPE,
218: BILL_RATE_CODE OKS_BILLRATE_SCHEDULES.BILL_RATE_CODE%TYPE,
219: FLAT_RATE OKS_BILLRATE_SCHEDULES.FLAT_RATE%TYPE,
212: FRIDAY_FLAG OKS_BILLRATE_SCHEDULES.FRIDAY_FLAG%TYPE,
213: SATURDAY_FLAG OKS_BILLRATE_SCHEDULES.SATURDAY_FLAG%TYPE,
214: SUNDAY_FLAG OKS_BILLRATE_SCHEDULES.SUNDAY_FLAG%TYPE,
215: OBJECT1_ID1 OKS_BILLRATE_SCHEDULES.OBJECT1_ID1%TYPE,
216: OBJECT1_ID2 OKS_BILLRATE_SCHEDULES.OBJECT1_ID2%TYPE,
217: JTOT_OBJECT1_CODE OKS_BILLRATE_SCHEDULES.JTOT_OBJECT1_CODE%TYPE,
218: BILL_RATE_CODE OKS_BILLRATE_SCHEDULES.BILL_RATE_CODE%TYPE,
219: FLAT_RATE OKS_BILLRATE_SCHEDULES.FLAT_RATE%TYPE,
220: UOM OKS_BILLRATE_SCHEDULES.UOM%TYPE,
213: SATURDAY_FLAG OKS_BILLRATE_SCHEDULES.SATURDAY_FLAG%TYPE,
214: SUNDAY_FLAG OKS_BILLRATE_SCHEDULES.SUNDAY_FLAG%TYPE,
215: OBJECT1_ID1 OKS_BILLRATE_SCHEDULES.OBJECT1_ID1%TYPE,
216: OBJECT1_ID2 OKS_BILLRATE_SCHEDULES.OBJECT1_ID2%TYPE,
217: JTOT_OBJECT1_CODE OKS_BILLRATE_SCHEDULES.JTOT_OBJECT1_CODE%TYPE,
218: BILL_RATE_CODE OKS_BILLRATE_SCHEDULES.BILL_RATE_CODE%TYPE,
219: FLAT_RATE OKS_BILLRATE_SCHEDULES.FLAT_RATE%TYPE,
220: UOM OKS_BILLRATE_SCHEDULES.UOM%TYPE,
221: HOLIDAY_YN OKS_BILLRATE_SCHEDULES.HOLIDAY_YN%TYPE,
214: SUNDAY_FLAG OKS_BILLRATE_SCHEDULES.SUNDAY_FLAG%TYPE,
215: OBJECT1_ID1 OKS_BILLRATE_SCHEDULES.OBJECT1_ID1%TYPE,
216: OBJECT1_ID2 OKS_BILLRATE_SCHEDULES.OBJECT1_ID2%TYPE,
217: JTOT_OBJECT1_CODE OKS_BILLRATE_SCHEDULES.JTOT_OBJECT1_CODE%TYPE,
218: BILL_RATE_CODE OKS_BILLRATE_SCHEDULES.BILL_RATE_CODE%TYPE,
219: FLAT_RATE OKS_BILLRATE_SCHEDULES.FLAT_RATE%TYPE,
220: UOM OKS_BILLRATE_SCHEDULES.UOM%TYPE,
221: HOLIDAY_YN OKS_BILLRATE_SCHEDULES.HOLIDAY_YN%TYPE,
222: PERCENT_OVER_LIST_PRICE OKS_BILLRATE_SCHEDULES.PERCENT_OVER_LIST_PRICE%TYPE);
215: OBJECT1_ID1 OKS_BILLRATE_SCHEDULES.OBJECT1_ID1%TYPE,
216: OBJECT1_ID2 OKS_BILLRATE_SCHEDULES.OBJECT1_ID2%TYPE,
217: JTOT_OBJECT1_CODE OKS_BILLRATE_SCHEDULES.JTOT_OBJECT1_CODE%TYPE,
218: BILL_RATE_CODE OKS_BILLRATE_SCHEDULES.BILL_RATE_CODE%TYPE,
219: FLAT_RATE OKS_BILLRATE_SCHEDULES.FLAT_RATE%TYPE,
220: UOM OKS_BILLRATE_SCHEDULES.UOM%TYPE,
221: HOLIDAY_YN OKS_BILLRATE_SCHEDULES.HOLIDAY_YN%TYPE,
222: PERCENT_OVER_LIST_PRICE OKS_BILLRATE_SCHEDULES.PERCENT_OVER_LIST_PRICE%TYPE);
223:
216: OBJECT1_ID2 OKS_BILLRATE_SCHEDULES.OBJECT1_ID2%TYPE,
217: JTOT_OBJECT1_CODE OKS_BILLRATE_SCHEDULES.JTOT_OBJECT1_CODE%TYPE,
218: BILL_RATE_CODE OKS_BILLRATE_SCHEDULES.BILL_RATE_CODE%TYPE,
219: FLAT_RATE OKS_BILLRATE_SCHEDULES.FLAT_RATE%TYPE,
220: UOM OKS_BILLRATE_SCHEDULES.UOM%TYPE,
221: HOLIDAY_YN OKS_BILLRATE_SCHEDULES.HOLIDAY_YN%TYPE,
222: PERCENT_OVER_LIST_PRICE OKS_BILLRATE_SCHEDULES.PERCENT_OVER_LIST_PRICE%TYPE);
223:
224: TYPE brs_tbl_type IS TABLE OF brs_rec_type
217: JTOT_OBJECT1_CODE OKS_BILLRATE_SCHEDULES.JTOT_OBJECT1_CODE%TYPE,
218: BILL_RATE_CODE OKS_BILLRATE_SCHEDULES.BILL_RATE_CODE%TYPE,
219: FLAT_RATE OKS_BILLRATE_SCHEDULES.FLAT_RATE%TYPE,
220: UOM OKS_BILLRATE_SCHEDULES.UOM%TYPE,
221: HOLIDAY_YN OKS_BILLRATE_SCHEDULES.HOLIDAY_YN%TYPE,
222: PERCENT_OVER_LIST_PRICE OKS_BILLRATE_SCHEDULES.PERCENT_OVER_LIST_PRICE%TYPE);
223:
224: TYPE brs_tbl_type IS TABLE OF brs_rec_type
225: INDEX BY BINARY_INTEGER;
218: BILL_RATE_CODE OKS_BILLRATE_SCHEDULES.BILL_RATE_CODE%TYPE,
219: FLAT_RATE OKS_BILLRATE_SCHEDULES.FLAT_RATE%TYPE,
220: UOM OKS_BILLRATE_SCHEDULES.UOM%TYPE,
221: HOLIDAY_YN OKS_BILLRATE_SCHEDULES.HOLIDAY_YN%TYPE,
222: PERCENT_OVER_LIST_PRICE OKS_BILLRATE_SCHEDULES.PERCENT_OVER_LIST_PRICE%TYPE);
223:
224: TYPE brs_tbl_type IS TABLE OF brs_rec_type
225: INDEX BY BINARY_INTEGER;
226: