eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_BRS_PVT dependencies on OKC_API

Line 8: id NUMBER := OKC_API.G_MISS_NUM

4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKS_BILLRATE_SCHEDULES_V Record Spec
7: TYPE OksBillrateSchedulesVRecType IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,cle_id NUMBER := OKC_API.G_MISS_NUM
10: ,bt_cle_id NUMBER := OKC_API.G_MISS_NUM
11: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
12: ,start_hour NUMBER := OKC_API.G_MISS_NUM

Line 9: ,cle_id NUMBER := OKC_API.G_MISS_NUM

5: ---------------------------------------------------------------------------
6: -- OKS_BILLRATE_SCHEDULES_V Record Spec
7: TYPE OksBillrateSchedulesVRecType IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,cle_id NUMBER := OKC_API.G_MISS_NUM
10: ,bt_cle_id NUMBER := OKC_API.G_MISS_NUM
11: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
12: ,start_hour NUMBER := OKC_API.G_MISS_NUM
13: ,start_minute NUMBER := OKC_API.G_MISS_NUM

Line 10: ,bt_cle_id NUMBER := OKC_API.G_MISS_NUM

6: -- OKS_BILLRATE_SCHEDULES_V Record Spec
7: TYPE OksBillrateSchedulesVRecType IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,cle_id NUMBER := OKC_API.G_MISS_NUM
10: ,bt_cle_id NUMBER := OKC_API.G_MISS_NUM
11: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
12: ,start_hour NUMBER := OKC_API.G_MISS_NUM
13: ,start_minute NUMBER := OKC_API.G_MISS_NUM
14: ,end_hour NUMBER := OKC_API.G_MISS_NUM

Line 11: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM

7: TYPE OksBillrateSchedulesVRecType IS RECORD (
8: id NUMBER := OKC_API.G_MISS_NUM
9: ,cle_id NUMBER := OKC_API.G_MISS_NUM
10: ,bt_cle_id NUMBER := OKC_API.G_MISS_NUM
11: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
12: ,start_hour NUMBER := OKC_API.G_MISS_NUM
13: ,start_minute NUMBER := OKC_API.G_MISS_NUM
14: ,end_hour NUMBER := OKC_API.G_MISS_NUM
15: ,end_minute NUMBER := OKC_API.G_MISS_NUM

Line 12: ,start_hour NUMBER := OKC_API.G_MISS_NUM

8: id NUMBER := OKC_API.G_MISS_NUM
9: ,cle_id NUMBER := OKC_API.G_MISS_NUM
10: ,bt_cle_id NUMBER := OKC_API.G_MISS_NUM
11: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
12: ,start_hour NUMBER := OKC_API.G_MISS_NUM
13: ,start_minute NUMBER := OKC_API.G_MISS_NUM
14: ,end_hour NUMBER := OKC_API.G_MISS_NUM
15: ,end_minute NUMBER := OKC_API.G_MISS_NUM
16: ,monday_flag OKS_BILLRATE_SCHEDULES_V.MONDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR

Line 13: ,start_minute NUMBER := OKC_API.G_MISS_NUM

9: ,cle_id NUMBER := OKC_API.G_MISS_NUM
10: ,bt_cle_id NUMBER := OKC_API.G_MISS_NUM
11: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
12: ,start_hour NUMBER := OKC_API.G_MISS_NUM
13: ,start_minute NUMBER := OKC_API.G_MISS_NUM
14: ,end_hour NUMBER := OKC_API.G_MISS_NUM
15: ,end_minute NUMBER := OKC_API.G_MISS_NUM
16: ,monday_flag OKS_BILLRATE_SCHEDULES_V.MONDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
17: ,tuesday_flag OKS_BILLRATE_SCHEDULES_V.TUESDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR

Line 14: ,end_hour NUMBER := OKC_API.G_MISS_NUM

10: ,bt_cle_id NUMBER := OKC_API.G_MISS_NUM
11: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
12: ,start_hour NUMBER := OKC_API.G_MISS_NUM
13: ,start_minute NUMBER := OKC_API.G_MISS_NUM
14: ,end_hour NUMBER := OKC_API.G_MISS_NUM
15: ,end_minute NUMBER := OKC_API.G_MISS_NUM
16: ,monday_flag OKS_BILLRATE_SCHEDULES_V.MONDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
17: ,tuesday_flag OKS_BILLRATE_SCHEDULES_V.TUESDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
18: ,wednesday_flag OKS_BILLRATE_SCHEDULES_V.WEDNESDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR

Line 15: ,end_minute NUMBER := OKC_API.G_MISS_NUM

11: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
12: ,start_hour NUMBER := OKC_API.G_MISS_NUM
13: ,start_minute NUMBER := OKC_API.G_MISS_NUM
14: ,end_hour NUMBER := OKC_API.G_MISS_NUM
15: ,end_minute NUMBER := OKC_API.G_MISS_NUM
16: ,monday_flag OKS_BILLRATE_SCHEDULES_V.MONDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
17: ,tuesday_flag OKS_BILLRATE_SCHEDULES_V.TUESDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
18: ,wednesday_flag OKS_BILLRATE_SCHEDULES_V.WEDNESDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
19: ,thursday_flag OKS_BILLRATE_SCHEDULES_V.THURSDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR

Line 16: ,monday_flag OKS_BILLRATE_SCHEDULES_V.MONDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR

12: ,start_hour NUMBER := OKC_API.G_MISS_NUM
13: ,start_minute NUMBER := OKC_API.G_MISS_NUM
14: ,end_hour NUMBER := OKC_API.G_MISS_NUM
15: ,end_minute NUMBER := OKC_API.G_MISS_NUM
16: ,monday_flag OKS_BILLRATE_SCHEDULES_V.MONDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
17: ,tuesday_flag OKS_BILLRATE_SCHEDULES_V.TUESDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
18: ,wednesday_flag OKS_BILLRATE_SCHEDULES_V.WEDNESDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
19: ,thursday_flag OKS_BILLRATE_SCHEDULES_V.THURSDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
20: ,friday_flag OKS_BILLRATE_SCHEDULES_V.FRIDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR

Line 17: ,tuesday_flag OKS_BILLRATE_SCHEDULES_V.TUESDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR

13: ,start_minute NUMBER := OKC_API.G_MISS_NUM
14: ,end_hour NUMBER := OKC_API.G_MISS_NUM
15: ,end_minute NUMBER := OKC_API.G_MISS_NUM
16: ,monday_flag OKS_BILLRATE_SCHEDULES_V.MONDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
17: ,tuesday_flag OKS_BILLRATE_SCHEDULES_V.TUESDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
18: ,wednesday_flag OKS_BILLRATE_SCHEDULES_V.WEDNESDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
19: ,thursday_flag OKS_BILLRATE_SCHEDULES_V.THURSDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
20: ,friday_flag OKS_BILLRATE_SCHEDULES_V.FRIDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
21: ,saturday_flag OKS_BILLRATE_SCHEDULES_V.SATURDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR

Line 18: ,wednesday_flag OKS_BILLRATE_SCHEDULES_V.WEDNESDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR

14: ,end_hour NUMBER := OKC_API.G_MISS_NUM
15: ,end_minute NUMBER := OKC_API.G_MISS_NUM
16: ,monday_flag OKS_BILLRATE_SCHEDULES_V.MONDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
17: ,tuesday_flag OKS_BILLRATE_SCHEDULES_V.TUESDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
18: ,wednesday_flag OKS_BILLRATE_SCHEDULES_V.WEDNESDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
19: ,thursday_flag OKS_BILLRATE_SCHEDULES_V.THURSDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
20: ,friday_flag OKS_BILLRATE_SCHEDULES_V.FRIDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
21: ,saturday_flag OKS_BILLRATE_SCHEDULES_V.SATURDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
22: ,sunday_flag OKS_BILLRATE_SCHEDULES_V.SUNDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR

Line 19: ,thursday_flag OKS_BILLRATE_SCHEDULES_V.THURSDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR

15: ,end_minute NUMBER := OKC_API.G_MISS_NUM
16: ,monday_flag OKS_BILLRATE_SCHEDULES_V.MONDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
17: ,tuesday_flag OKS_BILLRATE_SCHEDULES_V.TUESDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
18: ,wednesday_flag OKS_BILLRATE_SCHEDULES_V.WEDNESDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
19: ,thursday_flag OKS_BILLRATE_SCHEDULES_V.THURSDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
20: ,friday_flag OKS_BILLRATE_SCHEDULES_V.FRIDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
21: ,saturday_flag OKS_BILLRATE_SCHEDULES_V.SATURDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
22: ,sunday_flag OKS_BILLRATE_SCHEDULES_V.SUNDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
23: ,object1_id1 OKS_BILLRATE_SCHEDULES_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR

Line 20: ,friday_flag OKS_BILLRATE_SCHEDULES_V.FRIDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR

16: ,monday_flag OKS_BILLRATE_SCHEDULES_V.MONDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
17: ,tuesday_flag OKS_BILLRATE_SCHEDULES_V.TUESDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
18: ,wednesday_flag OKS_BILLRATE_SCHEDULES_V.WEDNESDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
19: ,thursday_flag OKS_BILLRATE_SCHEDULES_V.THURSDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
20: ,friday_flag OKS_BILLRATE_SCHEDULES_V.FRIDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
21: ,saturday_flag OKS_BILLRATE_SCHEDULES_V.SATURDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
22: ,sunday_flag OKS_BILLRATE_SCHEDULES_V.SUNDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
23: ,object1_id1 OKS_BILLRATE_SCHEDULES_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
24: ,object1_id2 OKS_BILLRATE_SCHEDULES_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR

Line 21: ,saturday_flag OKS_BILLRATE_SCHEDULES_V.SATURDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR

17: ,tuesday_flag OKS_BILLRATE_SCHEDULES_V.TUESDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
18: ,wednesday_flag OKS_BILLRATE_SCHEDULES_V.WEDNESDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
19: ,thursday_flag OKS_BILLRATE_SCHEDULES_V.THURSDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
20: ,friday_flag OKS_BILLRATE_SCHEDULES_V.FRIDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
21: ,saturday_flag OKS_BILLRATE_SCHEDULES_V.SATURDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
22: ,sunday_flag OKS_BILLRATE_SCHEDULES_V.SUNDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
23: ,object1_id1 OKS_BILLRATE_SCHEDULES_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
24: ,object1_id2 OKS_BILLRATE_SCHEDULES_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
25: ,jtot_object1_code OKS_BILLRATE_SCHEDULES_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR

Line 22: ,sunday_flag OKS_BILLRATE_SCHEDULES_V.SUNDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR

18: ,wednesday_flag OKS_BILLRATE_SCHEDULES_V.WEDNESDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
19: ,thursday_flag OKS_BILLRATE_SCHEDULES_V.THURSDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
20: ,friday_flag OKS_BILLRATE_SCHEDULES_V.FRIDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
21: ,saturday_flag OKS_BILLRATE_SCHEDULES_V.SATURDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
22: ,sunday_flag OKS_BILLRATE_SCHEDULES_V.SUNDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
23: ,object1_id1 OKS_BILLRATE_SCHEDULES_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
24: ,object1_id2 OKS_BILLRATE_SCHEDULES_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
25: ,jtot_object1_code OKS_BILLRATE_SCHEDULES_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
26: ,bill_rate_code OKS_BILLRATE_SCHEDULES_V.BILL_RATE_CODE%TYPE := OKC_API.G_MISS_CHAR

Line 23: ,object1_id1 OKS_BILLRATE_SCHEDULES_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR

19: ,thursday_flag OKS_BILLRATE_SCHEDULES_V.THURSDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
20: ,friday_flag OKS_BILLRATE_SCHEDULES_V.FRIDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
21: ,saturday_flag OKS_BILLRATE_SCHEDULES_V.SATURDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
22: ,sunday_flag OKS_BILLRATE_SCHEDULES_V.SUNDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
23: ,object1_id1 OKS_BILLRATE_SCHEDULES_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
24: ,object1_id2 OKS_BILLRATE_SCHEDULES_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
25: ,jtot_object1_code OKS_BILLRATE_SCHEDULES_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
26: ,bill_rate_code OKS_BILLRATE_SCHEDULES_V.BILL_RATE_CODE%TYPE := OKC_API.G_MISS_CHAR
27: ,uom OKS_BILLRATE_SCHEDULES_V.UOM%TYPE := OKC_API.G_MISS_CHAR

Line 24: ,object1_id2 OKS_BILLRATE_SCHEDULES_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR

20: ,friday_flag OKS_BILLRATE_SCHEDULES_V.FRIDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
21: ,saturday_flag OKS_BILLRATE_SCHEDULES_V.SATURDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
22: ,sunday_flag OKS_BILLRATE_SCHEDULES_V.SUNDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
23: ,object1_id1 OKS_BILLRATE_SCHEDULES_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
24: ,object1_id2 OKS_BILLRATE_SCHEDULES_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
25: ,jtot_object1_code OKS_BILLRATE_SCHEDULES_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
26: ,bill_rate_code OKS_BILLRATE_SCHEDULES_V.BILL_RATE_CODE%TYPE := OKC_API.G_MISS_CHAR
27: ,uom OKS_BILLRATE_SCHEDULES_V.UOM%TYPE := OKC_API.G_MISS_CHAR
28: ,flat_rate NUMBER := OKC_API.G_MISS_NUM

Line 25: ,jtot_object1_code OKS_BILLRATE_SCHEDULES_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR

21: ,saturday_flag OKS_BILLRATE_SCHEDULES_V.SATURDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
22: ,sunday_flag OKS_BILLRATE_SCHEDULES_V.SUNDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
23: ,object1_id1 OKS_BILLRATE_SCHEDULES_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
24: ,object1_id2 OKS_BILLRATE_SCHEDULES_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
25: ,jtot_object1_code OKS_BILLRATE_SCHEDULES_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
26: ,bill_rate_code OKS_BILLRATE_SCHEDULES_V.BILL_RATE_CODE%TYPE := OKC_API.G_MISS_CHAR
27: ,uom OKS_BILLRATE_SCHEDULES_V.UOM%TYPE := OKC_API.G_MISS_CHAR
28: ,flat_rate NUMBER := OKC_API.G_MISS_NUM
29: ,holiday_yn OKS_BILLRATE_SCHEDULES_V.HOLIDAY_YN%TYPE := OKC_API.G_MISS_CHAR

Line 26: ,bill_rate_code OKS_BILLRATE_SCHEDULES_V.BILL_RATE_CODE%TYPE := OKC_API.G_MISS_CHAR

22: ,sunday_flag OKS_BILLRATE_SCHEDULES_V.SUNDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
23: ,object1_id1 OKS_BILLRATE_SCHEDULES_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
24: ,object1_id2 OKS_BILLRATE_SCHEDULES_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
25: ,jtot_object1_code OKS_BILLRATE_SCHEDULES_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
26: ,bill_rate_code OKS_BILLRATE_SCHEDULES_V.BILL_RATE_CODE%TYPE := OKC_API.G_MISS_CHAR
27: ,uom OKS_BILLRATE_SCHEDULES_V.UOM%TYPE := OKC_API.G_MISS_CHAR
28: ,flat_rate NUMBER := OKC_API.G_MISS_NUM
29: ,holiday_yn OKS_BILLRATE_SCHEDULES_V.HOLIDAY_YN%TYPE := OKC_API.G_MISS_CHAR
30: ,percent_over_list_price NUMBER := OKC_API.G_MISS_NUM

Line 27: ,uom OKS_BILLRATE_SCHEDULES_V.UOM%TYPE := OKC_API.G_MISS_CHAR

23: ,object1_id1 OKS_BILLRATE_SCHEDULES_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
24: ,object1_id2 OKS_BILLRATE_SCHEDULES_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
25: ,jtot_object1_code OKS_BILLRATE_SCHEDULES_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
26: ,bill_rate_code OKS_BILLRATE_SCHEDULES_V.BILL_RATE_CODE%TYPE := OKC_API.G_MISS_CHAR
27: ,uom OKS_BILLRATE_SCHEDULES_V.UOM%TYPE := OKC_API.G_MISS_CHAR
28: ,flat_rate NUMBER := OKC_API.G_MISS_NUM
29: ,holiday_yn OKS_BILLRATE_SCHEDULES_V.HOLIDAY_YN%TYPE := OKC_API.G_MISS_CHAR
30: ,percent_over_list_price NUMBER := OKC_API.G_MISS_NUM
31: ,program_application_id NUMBER := OKC_API.G_MISS_NUM

Line 28: ,flat_rate NUMBER := OKC_API.G_MISS_NUM

24: ,object1_id2 OKS_BILLRATE_SCHEDULES_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
25: ,jtot_object1_code OKS_BILLRATE_SCHEDULES_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
26: ,bill_rate_code OKS_BILLRATE_SCHEDULES_V.BILL_RATE_CODE%TYPE := OKC_API.G_MISS_CHAR
27: ,uom OKS_BILLRATE_SCHEDULES_V.UOM%TYPE := OKC_API.G_MISS_CHAR
28: ,flat_rate NUMBER := OKC_API.G_MISS_NUM
29: ,holiday_yn OKS_BILLRATE_SCHEDULES_V.HOLIDAY_YN%TYPE := OKC_API.G_MISS_CHAR
30: ,percent_over_list_price NUMBER := OKC_API.G_MISS_NUM
31: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
32: ,program_id NUMBER := OKC_API.G_MISS_NUM

Line 29: ,holiday_yn OKS_BILLRATE_SCHEDULES_V.HOLIDAY_YN%TYPE := OKC_API.G_MISS_CHAR

25: ,jtot_object1_code OKS_BILLRATE_SCHEDULES_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
26: ,bill_rate_code OKS_BILLRATE_SCHEDULES_V.BILL_RATE_CODE%TYPE := OKC_API.G_MISS_CHAR
27: ,uom OKS_BILLRATE_SCHEDULES_V.UOM%TYPE := OKC_API.G_MISS_CHAR
28: ,flat_rate NUMBER := OKC_API.G_MISS_NUM
29: ,holiday_yn OKS_BILLRATE_SCHEDULES_V.HOLIDAY_YN%TYPE := OKC_API.G_MISS_CHAR
30: ,percent_over_list_price NUMBER := OKC_API.G_MISS_NUM
31: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
32: ,program_id NUMBER := OKC_API.G_MISS_NUM
33: ,program_update_date OKS_BILLRATE_SCHEDULES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 30: ,percent_over_list_price NUMBER := OKC_API.G_MISS_NUM

26: ,bill_rate_code OKS_BILLRATE_SCHEDULES_V.BILL_RATE_CODE%TYPE := OKC_API.G_MISS_CHAR
27: ,uom OKS_BILLRATE_SCHEDULES_V.UOM%TYPE := OKC_API.G_MISS_CHAR
28: ,flat_rate NUMBER := OKC_API.G_MISS_NUM
29: ,holiday_yn OKS_BILLRATE_SCHEDULES_V.HOLIDAY_YN%TYPE := OKC_API.G_MISS_CHAR
30: ,percent_over_list_price NUMBER := OKC_API.G_MISS_NUM
31: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
32: ,program_id NUMBER := OKC_API.G_MISS_NUM
33: ,program_update_date OKS_BILLRATE_SCHEDULES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
34: ,request_id NUMBER := OKC_API.G_MISS_NUM

Line 31: ,program_application_id NUMBER := OKC_API.G_MISS_NUM

27: ,uom OKS_BILLRATE_SCHEDULES_V.UOM%TYPE := OKC_API.G_MISS_CHAR
28: ,flat_rate NUMBER := OKC_API.G_MISS_NUM
29: ,holiday_yn OKS_BILLRATE_SCHEDULES_V.HOLIDAY_YN%TYPE := OKC_API.G_MISS_CHAR
30: ,percent_over_list_price NUMBER := OKC_API.G_MISS_NUM
31: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
32: ,program_id NUMBER := OKC_API.G_MISS_NUM
33: ,program_update_date OKS_BILLRATE_SCHEDULES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
34: ,request_id NUMBER := OKC_API.G_MISS_NUM
35: ,created_by NUMBER := OKC_API.G_MISS_NUM

Line 32: ,program_id NUMBER := OKC_API.G_MISS_NUM

28: ,flat_rate NUMBER := OKC_API.G_MISS_NUM
29: ,holiday_yn OKS_BILLRATE_SCHEDULES_V.HOLIDAY_YN%TYPE := OKC_API.G_MISS_CHAR
30: ,percent_over_list_price NUMBER := OKC_API.G_MISS_NUM
31: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
32: ,program_id NUMBER := OKC_API.G_MISS_NUM
33: ,program_update_date OKS_BILLRATE_SCHEDULES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
34: ,request_id NUMBER := OKC_API.G_MISS_NUM
35: ,created_by NUMBER := OKC_API.G_MISS_NUM
36: ,creation_date OKS_BILLRATE_SCHEDULES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

Line 33: ,program_update_date OKS_BILLRATE_SCHEDULES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

29: ,holiday_yn OKS_BILLRATE_SCHEDULES_V.HOLIDAY_YN%TYPE := OKC_API.G_MISS_CHAR
30: ,percent_over_list_price NUMBER := OKC_API.G_MISS_NUM
31: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
32: ,program_id NUMBER := OKC_API.G_MISS_NUM
33: ,program_update_date OKS_BILLRATE_SCHEDULES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
34: ,request_id NUMBER := OKC_API.G_MISS_NUM
35: ,created_by NUMBER := OKC_API.G_MISS_NUM
36: ,creation_date OKS_BILLRATE_SCHEDULES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
37: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

Line 34: ,request_id NUMBER := OKC_API.G_MISS_NUM

30: ,percent_over_list_price NUMBER := OKC_API.G_MISS_NUM
31: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
32: ,program_id NUMBER := OKC_API.G_MISS_NUM
33: ,program_update_date OKS_BILLRATE_SCHEDULES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
34: ,request_id NUMBER := OKC_API.G_MISS_NUM
35: ,created_by NUMBER := OKC_API.G_MISS_NUM
36: ,creation_date OKS_BILLRATE_SCHEDULES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
37: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
38: ,last_update_date OKS_BILLRATE_SCHEDULES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 35: ,created_by NUMBER := OKC_API.G_MISS_NUM

31: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
32: ,program_id NUMBER := OKC_API.G_MISS_NUM
33: ,program_update_date OKS_BILLRATE_SCHEDULES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
34: ,request_id NUMBER := OKC_API.G_MISS_NUM
35: ,created_by NUMBER := OKC_API.G_MISS_NUM
36: ,creation_date OKS_BILLRATE_SCHEDULES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
37: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
38: ,last_update_date OKS_BILLRATE_SCHEDULES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
39: ,last_update_login NUMBER := OKC_API.G_MISS_NUM

Line 36: ,creation_date OKS_BILLRATE_SCHEDULES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

32: ,program_id NUMBER := OKC_API.G_MISS_NUM
33: ,program_update_date OKS_BILLRATE_SCHEDULES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
34: ,request_id NUMBER := OKC_API.G_MISS_NUM
35: ,created_by NUMBER := OKC_API.G_MISS_NUM
36: ,creation_date OKS_BILLRATE_SCHEDULES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
37: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
38: ,last_update_date OKS_BILLRATE_SCHEDULES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
39: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
40: ,object_version_number NUMBER := OKC_API.G_MISS_NUM

Line 37: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

33: ,program_update_date OKS_BILLRATE_SCHEDULES_V.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
34: ,request_id NUMBER := OKC_API.G_MISS_NUM
35: ,created_by NUMBER := OKC_API.G_MISS_NUM
36: ,creation_date OKS_BILLRATE_SCHEDULES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
37: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
38: ,last_update_date OKS_BILLRATE_SCHEDULES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
39: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
40: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
41: ,security_group_id NUMBER := OKC_API.G_MISS_NUM);

Line 38: ,last_update_date OKS_BILLRATE_SCHEDULES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

34: ,request_id NUMBER := OKC_API.G_MISS_NUM
35: ,created_by NUMBER := OKC_API.G_MISS_NUM
36: ,creation_date OKS_BILLRATE_SCHEDULES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
37: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
38: ,last_update_date OKS_BILLRATE_SCHEDULES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
39: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
40: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
41: ,security_group_id NUMBER := OKC_API.G_MISS_NUM);
42: GMissOksBillrateSchedulesVRec OksBillrateSchedulesVRecType;

Line 39: ,last_update_login NUMBER := OKC_API.G_MISS_NUM

35: ,created_by NUMBER := OKC_API.G_MISS_NUM
36: ,creation_date OKS_BILLRATE_SCHEDULES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
37: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
38: ,last_update_date OKS_BILLRATE_SCHEDULES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
39: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
40: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
41: ,security_group_id NUMBER := OKC_API.G_MISS_NUM);
42: GMissOksBillrateSchedulesVRec OksBillrateSchedulesVRecType;
43: TYPE OksBillrateSchedulesVTblType IS TABLE OF OksBillrateSchedulesVRecType

Line 40: ,object_version_number NUMBER := OKC_API.G_MISS_NUM

36: ,creation_date OKS_BILLRATE_SCHEDULES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
37: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
38: ,last_update_date OKS_BILLRATE_SCHEDULES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
39: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
40: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
41: ,security_group_id NUMBER := OKC_API.G_MISS_NUM);
42: GMissOksBillrateSchedulesVRec OksBillrateSchedulesVRecType;
43: TYPE OksBillrateSchedulesVTblType IS TABLE OF OksBillrateSchedulesVRecType
44: INDEX BY BINARY_INTEGER;

Line 41: ,security_group_id NUMBER := OKC_API.G_MISS_NUM);

37: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
38: ,last_update_date OKS_BILLRATE_SCHEDULES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
39: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
40: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
41: ,security_group_id NUMBER := OKC_API.G_MISS_NUM);
42: GMissOksBillrateSchedulesVRec OksBillrateSchedulesVRecType;
43: TYPE OksBillrateSchedulesVTblType IS TABLE OF OksBillrateSchedulesVRecType
44: INDEX BY BINARY_INTEGER;
45: -- OKS_BILLRATE_SCHEDULES Record Spec

Line 47: id NUMBER := OKC_API.G_MISS_NUM

43: TYPE OksBillrateSchedulesVTblType IS TABLE OF OksBillrateSchedulesVRecType
44: INDEX BY BINARY_INTEGER;
45: -- OKS_BILLRATE_SCHEDULES Record Spec
46: TYPE OksBillrateSchedulesRecType IS RECORD (
47: id NUMBER := OKC_API.G_MISS_NUM
48: ,cle_id NUMBER := OKC_API.G_MISS_NUM
49: ,bt_cle_id NUMBER := OKC_API.G_MISS_NUM
50: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
51: ,start_hour NUMBER := OKC_API.G_MISS_NUM

Line 48: ,cle_id NUMBER := OKC_API.G_MISS_NUM

44: INDEX BY BINARY_INTEGER;
45: -- OKS_BILLRATE_SCHEDULES Record Spec
46: TYPE OksBillrateSchedulesRecType IS RECORD (
47: id NUMBER := OKC_API.G_MISS_NUM
48: ,cle_id NUMBER := OKC_API.G_MISS_NUM
49: ,bt_cle_id NUMBER := OKC_API.G_MISS_NUM
50: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
51: ,start_hour NUMBER := OKC_API.G_MISS_NUM
52: ,start_minute NUMBER := OKC_API.G_MISS_NUM

Line 49: ,bt_cle_id NUMBER := OKC_API.G_MISS_NUM

45: -- OKS_BILLRATE_SCHEDULES Record Spec
46: TYPE OksBillrateSchedulesRecType IS RECORD (
47: id NUMBER := OKC_API.G_MISS_NUM
48: ,cle_id NUMBER := OKC_API.G_MISS_NUM
49: ,bt_cle_id NUMBER := OKC_API.G_MISS_NUM
50: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
51: ,start_hour NUMBER := OKC_API.G_MISS_NUM
52: ,start_minute NUMBER := OKC_API.G_MISS_NUM
53: ,end_hour NUMBER := OKC_API.G_MISS_NUM

Line 50: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM

46: TYPE OksBillrateSchedulesRecType IS RECORD (
47: id NUMBER := OKC_API.G_MISS_NUM
48: ,cle_id NUMBER := OKC_API.G_MISS_NUM
49: ,bt_cle_id NUMBER := OKC_API.G_MISS_NUM
50: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
51: ,start_hour NUMBER := OKC_API.G_MISS_NUM
52: ,start_minute NUMBER := OKC_API.G_MISS_NUM
53: ,end_hour NUMBER := OKC_API.G_MISS_NUM
54: ,end_minute NUMBER := OKC_API.G_MISS_NUM

Line 51: ,start_hour NUMBER := OKC_API.G_MISS_NUM

47: id NUMBER := OKC_API.G_MISS_NUM
48: ,cle_id NUMBER := OKC_API.G_MISS_NUM
49: ,bt_cle_id NUMBER := OKC_API.G_MISS_NUM
50: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
51: ,start_hour NUMBER := OKC_API.G_MISS_NUM
52: ,start_minute NUMBER := OKC_API.G_MISS_NUM
53: ,end_hour NUMBER := OKC_API.G_MISS_NUM
54: ,end_minute NUMBER := OKC_API.G_MISS_NUM
55: ,monday_flag OKS_BILLRATE_SCHEDULES.MONDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR

Line 52: ,start_minute NUMBER := OKC_API.G_MISS_NUM

48: ,cle_id NUMBER := OKC_API.G_MISS_NUM
49: ,bt_cle_id NUMBER := OKC_API.G_MISS_NUM
50: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
51: ,start_hour NUMBER := OKC_API.G_MISS_NUM
52: ,start_minute NUMBER := OKC_API.G_MISS_NUM
53: ,end_hour NUMBER := OKC_API.G_MISS_NUM
54: ,end_minute NUMBER := OKC_API.G_MISS_NUM
55: ,monday_flag OKS_BILLRATE_SCHEDULES.MONDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
56: ,tuesday_flag OKS_BILLRATE_SCHEDULES.TUESDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR

Line 53: ,end_hour NUMBER := OKC_API.G_MISS_NUM

49: ,bt_cle_id NUMBER := OKC_API.G_MISS_NUM
50: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
51: ,start_hour NUMBER := OKC_API.G_MISS_NUM
52: ,start_minute NUMBER := OKC_API.G_MISS_NUM
53: ,end_hour NUMBER := OKC_API.G_MISS_NUM
54: ,end_minute NUMBER := OKC_API.G_MISS_NUM
55: ,monday_flag OKS_BILLRATE_SCHEDULES.MONDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
56: ,tuesday_flag OKS_BILLRATE_SCHEDULES.TUESDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
57: ,wednesday_flag OKS_BILLRATE_SCHEDULES.WEDNESDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR

Line 54: ,end_minute NUMBER := OKC_API.G_MISS_NUM

50: ,dnz_chr_id NUMBER := OKC_API.G_MISS_NUM
51: ,start_hour NUMBER := OKC_API.G_MISS_NUM
52: ,start_minute NUMBER := OKC_API.G_MISS_NUM
53: ,end_hour NUMBER := OKC_API.G_MISS_NUM
54: ,end_minute NUMBER := OKC_API.G_MISS_NUM
55: ,monday_flag OKS_BILLRATE_SCHEDULES.MONDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
56: ,tuesday_flag OKS_BILLRATE_SCHEDULES.TUESDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
57: ,wednesday_flag OKS_BILLRATE_SCHEDULES.WEDNESDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
58: ,thursday_flag OKS_BILLRATE_SCHEDULES.THURSDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR

Line 55: ,monday_flag OKS_BILLRATE_SCHEDULES.MONDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR

51: ,start_hour NUMBER := OKC_API.G_MISS_NUM
52: ,start_minute NUMBER := OKC_API.G_MISS_NUM
53: ,end_hour NUMBER := OKC_API.G_MISS_NUM
54: ,end_minute NUMBER := OKC_API.G_MISS_NUM
55: ,monday_flag OKS_BILLRATE_SCHEDULES.MONDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
56: ,tuesday_flag OKS_BILLRATE_SCHEDULES.TUESDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
57: ,wednesday_flag OKS_BILLRATE_SCHEDULES.WEDNESDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
58: ,thursday_flag OKS_BILLRATE_SCHEDULES.THURSDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
59: ,friday_flag OKS_BILLRATE_SCHEDULES.FRIDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR

Line 56: ,tuesday_flag OKS_BILLRATE_SCHEDULES.TUESDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR

52: ,start_minute NUMBER := OKC_API.G_MISS_NUM
53: ,end_hour NUMBER := OKC_API.G_MISS_NUM
54: ,end_minute NUMBER := OKC_API.G_MISS_NUM
55: ,monday_flag OKS_BILLRATE_SCHEDULES.MONDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
56: ,tuesday_flag OKS_BILLRATE_SCHEDULES.TUESDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
57: ,wednesday_flag OKS_BILLRATE_SCHEDULES.WEDNESDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
58: ,thursday_flag OKS_BILLRATE_SCHEDULES.THURSDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
59: ,friday_flag OKS_BILLRATE_SCHEDULES.FRIDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
60: ,saturday_flag OKS_BILLRATE_SCHEDULES.SATURDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR

Line 57: ,wednesday_flag OKS_BILLRATE_SCHEDULES.WEDNESDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR

53: ,end_hour NUMBER := OKC_API.G_MISS_NUM
54: ,end_minute NUMBER := OKC_API.G_MISS_NUM
55: ,monday_flag OKS_BILLRATE_SCHEDULES.MONDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
56: ,tuesday_flag OKS_BILLRATE_SCHEDULES.TUESDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
57: ,wednesday_flag OKS_BILLRATE_SCHEDULES.WEDNESDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
58: ,thursday_flag OKS_BILLRATE_SCHEDULES.THURSDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
59: ,friday_flag OKS_BILLRATE_SCHEDULES.FRIDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
60: ,saturday_flag OKS_BILLRATE_SCHEDULES.SATURDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
61: ,sunday_flag OKS_BILLRATE_SCHEDULES.SUNDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR

Line 58: ,thursday_flag OKS_BILLRATE_SCHEDULES.THURSDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR

54: ,end_minute NUMBER := OKC_API.G_MISS_NUM
55: ,monday_flag OKS_BILLRATE_SCHEDULES.MONDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
56: ,tuesday_flag OKS_BILLRATE_SCHEDULES.TUESDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
57: ,wednesday_flag OKS_BILLRATE_SCHEDULES.WEDNESDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
58: ,thursday_flag OKS_BILLRATE_SCHEDULES.THURSDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
59: ,friday_flag OKS_BILLRATE_SCHEDULES.FRIDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
60: ,saturday_flag OKS_BILLRATE_SCHEDULES.SATURDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
61: ,sunday_flag OKS_BILLRATE_SCHEDULES.SUNDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
62: ,object1_id1 OKS_BILLRATE_SCHEDULES.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR

Line 59: ,friday_flag OKS_BILLRATE_SCHEDULES.FRIDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR

55: ,monday_flag OKS_BILLRATE_SCHEDULES.MONDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
56: ,tuesday_flag OKS_BILLRATE_SCHEDULES.TUESDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
57: ,wednesday_flag OKS_BILLRATE_SCHEDULES.WEDNESDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
58: ,thursday_flag OKS_BILLRATE_SCHEDULES.THURSDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
59: ,friday_flag OKS_BILLRATE_SCHEDULES.FRIDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
60: ,saturday_flag OKS_BILLRATE_SCHEDULES.SATURDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
61: ,sunday_flag OKS_BILLRATE_SCHEDULES.SUNDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
62: ,object1_id1 OKS_BILLRATE_SCHEDULES.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
63: ,object1_id2 OKS_BILLRATE_SCHEDULES.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR

Line 60: ,saturday_flag OKS_BILLRATE_SCHEDULES.SATURDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR

56: ,tuesday_flag OKS_BILLRATE_SCHEDULES.TUESDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
57: ,wednesday_flag OKS_BILLRATE_SCHEDULES.WEDNESDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
58: ,thursday_flag OKS_BILLRATE_SCHEDULES.THURSDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
59: ,friday_flag OKS_BILLRATE_SCHEDULES.FRIDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
60: ,saturday_flag OKS_BILLRATE_SCHEDULES.SATURDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
61: ,sunday_flag OKS_BILLRATE_SCHEDULES.SUNDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
62: ,object1_id1 OKS_BILLRATE_SCHEDULES.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
63: ,object1_id2 OKS_BILLRATE_SCHEDULES.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
64: ,jtot_object1_code OKS_BILLRATE_SCHEDULES.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR

Line 61: ,sunday_flag OKS_BILLRATE_SCHEDULES.SUNDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR

57: ,wednesday_flag OKS_BILLRATE_SCHEDULES.WEDNESDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
58: ,thursday_flag OKS_BILLRATE_SCHEDULES.THURSDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
59: ,friday_flag OKS_BILLRATE_SCHEDULES.FRIDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
60: ,saturday_flag OKS_BILLRATE_SCHEDULES.SATURDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
61: ,sunday_flag OKS_BILLRATE_SCHEDULES.SUNDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
62: ,object1_id1 OKS_BILLRATE_SCHEDULES.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
63: ,object1_id2 OKS_BILLRATE_SCHEDULES.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
64: ,jtot_object1_code OKS_BILLRATE_SCHEDULES.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
65: ,bill_rate_code OKS_BILLRATE_SCHEDULES.BILL_RATE_CODE%TYPE := OKC_API.G_MISS_CHAR

Line 62: ,object1_id1 OKS_BILLRATE_SCHEDULES.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR

58: ,thursday_flag OKS_BILLRATE_SCHEDULES.THURSDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
59: ,friday_flag OKS_BILLRATE_SCHEDULES.FRIDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
60: ,saturday_flag OKS_BILLRATE_SCHEDULES.SATURDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
61: ,sunday_flag OKS_BILLRATE_SCHEDULES.SUNDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
62: ,object1_id1 OKS_BILLRATE_SCHEDULES.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
63: ,object1_id2 OKS_BILLRATE_SCHEDULES.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
64: ,jtot_object1_code OKS_BILLRATE_SCHEDULES.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
65: ,bill_rate_code OKS_BILLRATE_SCHEDULES.BILL_RATE_CODE%TYPE := OKC_API.G_MISS_CHAR
66: ,flat_rate NUMBER := OKC_API.G_MISS_NUM

Line 63: ,object1_id2 OKS_BILLRATE_SCHEDULES.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR

59: ,friday_flag OKS_BILLRATE_SCHEDULES.FRIDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
60: ,saturday_flag OKS_BILLRATE_SCHEDULES.SATURDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
61: ,sunday_flag OKS_BILLRATE_SCHEDULES.SUNDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
62: ,object1_id1 OKS_BILLRATE_SCHEDULES.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
63: ,object1_id2 OKS_BILLRATE_SCHEDULES.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
64: ,jtot_object1_code OKS_BILLRATE_SCHEDULES.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
65: ,bill_rate_code OKS_BILLRATE_SCHEDULES.BILL_RATE_CODE%TYPE := OKC_API.G_MISS_CHAR
66: ,flat_rate NUMBER := OKC_API.G_MISS_NUM
67: ,uom OKS_BILLRATE_SCHEDULES.UOM%TYPE := OKC_API.G_MISS_CHAR

Line 64: ,jtot_object1_code OKS_BILLRATE_SCHEDULES.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR

60: ,saturday_flag OKS_BILLRATE_SCHEDULES.SATURDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
61: ,sunday_flag OKS_BILLRATE_SCHEDULES.SUNDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
62: ,object1_id1 OKS_BILLRATE_SCHEDULES.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
63: ,object1_id2 OKS_BILLRATE_SCHEDULES.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
64: ,jtot_object1_code OKS_BILLRATE_SCHEDULES.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
65: ,bill_rate_code OKS_BILLRATE_SCHEDULES.BILL_RATE_CODE%TYPE := OKC_API.G_MISS_CHAR
66: ,flat_rate NUMBER := OKC_API.G_MISS_NUM
67: ,uom OKS_BILLRATE_SCHEDULES.UOM%TYPE := OKC_API.G_MISS_CHAR
68: ,holiday_yn OKS_BILLRATE_SCHEDULES.HOLIDAY_YN%TYPE := OKC_API.G_MISS_CHAR

Line 65: ,bill_rate_code OKS_BILLRATE_SCHEDULES.BILL_RATE_CODE%TYPE := OKC_API.G_MISS_CHAR

61: ,sunday_flag OKS_BILLRATE_SCHEDULES.SUNDAY_FLAG%TYPE := OKC_API.G_MISS_CHAR
62: ,object1_id1 OKS_BILLRATE_SCHEDULES.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
63: ,object1_id2 OKS_BILLRATE_SCHEDULES.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
64: ,jtot_object1_code OKS_BILLRATE_SCHEDULES.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
65: ,bill_rate_code OKS_BILLRATE_SCHEDULES.BILL_RATE_CODE%TYPE := OKC_API.G_MISS_CHAR
66: ,flat_rate NUMBER := OKC_API.G_MISS_NUM
67: ,uom OKS_BILLRATE_SCHEDULES.UOM%TYPE := OKC_API.G_MISS_CHAR
68: ,holiday_yn OKS_BILLRATE_SCHEDULES.HOLIDAY_YN%TYPE := OKC_API.G_MISS_CHAR
69: ,percent_over_list_price NUMBER := OKC_API.G_MISS_NUM

Line 66: ,flat_rate NUMBER := OKC_API.G_MISS_NUM

62: ,object1_id1 OKS_BILLRATE_SCHEDULES.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR
63: ,object1_id2 OKS_BILLRATE_SCHEDULES.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
64: ,jtot_object1_code OKS_BILLRATE_SCHEDULES.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
65: ,bill_rate_code OKS_BILLRATE_SCHEDULES.BILL_RATE_CODE%TYPE := OKC_API.G_MISS_CHAR
66: ,flat_rate NUMBER := OKC_API.G_MISS_NUM
67: ,uom OKS_BILLRATE_SCHEDULES.UOM%TYPE := OKC_API.G_MISS_CHAR
68: ,holiday_yn OKS_BILLRATE_SCHEDULES.HOLIDAY_YN%TYPE := OKC_API.G_MISS_CHAR
69: ,percent_over_list_price NUMBER := OKC_API.G_MISS_NUM
70: ,program_application_id NUMBER := OKC_API.G_MISS_NUM

Line 67: ,uom OKS_BILLRATE_SCHEDULES.UOM%TYPE := OKC_API.G_MISS_CHAR

63: ,object1_id2 OKS_BILLRATE_SCHEDULES.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR
64: ,jtot_object1_code OKS_BILLRATE_SCHEDULES.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
65: ,bill_rate_code OKS_BILLRATE_SCHEDULES.BILL_RATE_CODE%TYPE := OKC_API.G_MISS_CHAR
66: ,flat_rate NUMBER := OKC_API.G_MISS_NUM
67: ,uom OKS_BILLRATE_SCHEDULES.UOM%TYPE := OKC_API.G_MISS_CHAR
68: ,holiday_yn OKS_BILLRATE_SCHEDULES.HOLIDAY_YN%TYPE := OKC_API.G_MISS_CHAR
69: ,percent_over_list_price NUMBER := OKC_API.G_MISS_NUM
70: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
71: ,program_id NUMBER := OKC_API.G_MISS_NUM

Line 68: ,holiday_yn OKS_BILLRATE_SCHEDULES.HOLIDAY_YN%TYPE := OKC_API.G_MISS_CHAR

64: ,jtot_object1_code OKS_BILLRATE_SCHEDULES.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR
65: ,bill_rate_code OKS_BILLRATE_SCHEDULES.BILL_RATE_CODE%TYPE := OKC_API.G_MISS_CHAR
66: ,flat_rate NUMBER := OKC_API.G_MISS_NUM
67: ,uom OKS_BILLRATE_SCHEDULES.UOM%TYPE := OKC_API.G_MISS_CHAR
68: ,holiday_yn OKS_BILLRATE_SCHEDULES.HOLIDAY_YN%TYPE := OKC_API.G_MISS_CHAR
69: ,percent_over_list_price NUMBER := OKC_API.G_MISS_NUM
70: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
71: ,program_id NUMBER := OKC_API.G_MISS_NUM
72: ,program_update_date OKS_BILLRATE_SCHEDULES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 69: ,percent_over_list_price NUMBER := OKC_API.G_MISS_NUM

65: ,bill_rate_code OKS_BILLRATE_SCHEDULES.BILL_RATE_CODE%TYPE := OKC_API.G_MISS_CHAR
66: ,flat_rate NUMBER := OKC_API.G_MISS_NUM
67: ,uom OKS_BILLRATE_SCHEDULES.UOM%TYPE := OKC_API.G_MISS_CHAR
68: ,holiday_yn OKS_BILLRATE_SCHEDULES.HOLIDAY_YN%TYPE := OKC_API.G_MISS_CHAR
69: ,percent_over_list_price NUMBER := OKC_API.G_MISS_NUM
70: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
71: ,program_id NUMBER := OKC_API.G_MISS_NUM
72: ,program_update_date OKS_BILLRATE_SCHEDULES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
73: ,request_id NUMBER := OKC_API.G_MISS_NUM

Line 70: ,program_application_id NUMBER := OKC_API.G_MISS_NUM

66: ,flat_rate NUMBER := OKC_API.G_MISS_NUM
67: ,uom OKS_BILLRATE_SCHEDULES.UOM%TYPE := OKC_API.G_MISS_CHAR
68: ,holiday_yn OKS_BILLRATE_SCHEDULES.HOLIDAY_YN%TYPE := OKC_API.G_MISS_CHAR
69: ,percent_over_list_price NUMBER := OKC_API.G_MISS_NUM
70: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
71: ,program_id NUMBER := OKC_API.G_MISS_NUM
72: ,program_update_date OKS_BILLRATE_SCHEDULES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
73: ,request_id NUMBER := OKC_API.G_MISS_NUM
74: ,created_by NUMBER := OKC_API.G_MISS_NUM

Line 71: ,program_id NUMBER := OKC_API.G_MISS_NUM

67: ,uom OKS_BILLRATE_SCHEDULES.UOM%TYPE := OKC_API.G_MISS_CHAR
68: ,holiday_yn OKS_BILLRATE_SCHEDULES.HOLIDAY_YN%TYPE := OKC_API.G_MISS_CHAR
69: ,percent_over_list_price NUMBER := OKC_API.G_MISS_NUM
70: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
71: ,program_id NUMBER := OKC_API.G_MISS_NUM
72: ,program_update_date OKS_BILLRATE_SCHEDULES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
73: ,request_id NUMBER := OKC_API.G_MISS_NUM
74: ,created_by NUMBER := OKC_API.G_MISS_NUM
75: ,creation_date OKS_BILLRATE_SCHEDULES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

Line 72: ,program_update_date OKS_BILLRATE_SCHEDULES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

68: ,holiday_yn OKS_BILLRATE_SCHEDULES.HOLIDAY_YN%TYPE := OKC_API.G_MISS_CHAR
69: ,percent_over_list_price NUMBER := OKC_API.G_MISS_NUM
70: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
71: ,program_id NUMBER := OKC_API.G_MISS_NUM
72: ,program_update_date OKS_BILLRATE_SCHEDULES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
73: ,request_id NUMBER := OKC_API.G_MISS_NUM
74: ,created_by NUMBER := OKC_API.G_MISS_NUM
75: ,creation_date OKS_BILLRATE_SCHEDULES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
76: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

Line 73: ,request_id NUMBER := OKC_API.G_MISS_NUM

69: ,percent_over_list_price NUMBER := OKC_API.G_MISS_NUM
70: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
71: ,program_id NUMBER := OKC_API.G_MISS_NUM
72: ,program_update_date OKS_BILLRATE_SCHEDULES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
73: ,request_id NUMBER := OKC_API.G_MISS_NUM
74: ,created_by NUMBER := OKC_API.G_MISS_NUM
75: ,creation_date OKS_BILLRATE_SCHEDULES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
76: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
77: ,last_update_date OKS_BILLRATE_SCHEDULES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 74: ,created_by NUMBER := OKC_API.G_MISS_NUM

70: ,program_application_id NUMBER := OKC_API.G_MISS_NUM
71: ,program_id NUMBER := OKC_API.G_MISS_NUM
72: ,program_update_date OKS_BILLRATE_SCHEDULES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
73: ,request_id NUMBER := OKC_API.G_MISS_NUM
74: ,created_by NUMBER := OKC_API.G_MISS_NUM
75: ,creation_date OKS_BILLRATE_SCHEDULES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
76: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
77: ,last_update_date OKS_BILLRATE_SCHEDULES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
78: ,last_update_login NUMBER := OKC_API.G_MISS_NUM

Line 75: ,creation_date OKS_BILLRATE_SCHEDULES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

71: ,program_id NUMBER := OKC_API.G_MISS_NUM
72: ,program_update_date OKS_BILLRATE_SCHEDULES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
73: ,request_id NUMBER := OKC_API.G_MISS_NUM
74: ,created_by NUMBER := OKC_API.G_MISS_NUM
75: ,creation_date OKS_BILLRATE_SCHEDULES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
76: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
77: ,last_update_date OKS_BILLRATE_SCHEDULES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
78: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
79: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);

Line 76: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM

72: ,program_update_date OKS_BILLRATE_SCHEDULES.PROGRAM_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
73: ,request_id NUMBER := OKC_API.G_MISS_NUM
74: ,created_by NUMBER := OKC_API.G_MISS_NUM
75: ,creation_date OKS_BILLRATE_SCHEDULES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
76: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
77: ,last_update_date OKS_BILLRATE_SCHEDULES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
78: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
79: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);
80: GMissOksBillrateSchedulesRec OksBillrateSchedulesRecType;

Line 77: ,last_update_date OKS_BILLRATE_SCHEDULES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

73: ,request_id NUMBER := OKC_API.G_MISS_NUM
74: ,created_by NUMBER := OKC_API.G_MISS_NUM
75: ,creation_date OKS_BILLRATE_SCHEDULES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
76: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
77: ,last_update_date OKS_BILLRATE_SCHEDULES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
78: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
79: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);
80: GMissOksBillrateSchedulesRec OksBillrateSchedulesRecType;
81: TYPE OksBillrateSchedulesTblType IS TABLE OF OksBillrateSchedulesRecType

Line 78: ,last_update_login NUMBER := OKC_API.G_MISS_NUM

74: ,created_by NUMBER := OKC_API.G_MISS_NUM
75: ,creation_date OKS_BILLRATE_SCHEDULES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
76: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
77: ,last_update_date OKS_BILLRATE_SCHEDULES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
78: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
79: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);
80: GMissOksBillrateSchedulesRec OksBillrateSchedulesRecType;
81: TYPE OksBillrateSchedulesTblType IS TABLE OF OksBillrateSchedulesRecType
82: INDEX BY BINARY_INTEGER;

Line 79: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);

75: ,creation_date OKS_BILLRATE_SCHEDULES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
76: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
77: ,last_update_date OKS_BILLRATE_SCHEDULES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
78: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
79: ,object_version_number NUMBER := OKC_API.G_MISS_NUM);
80: GMissOksBillrateSchedulesRec OksBillrateSchedulesRecType;
81: TYPE OksBillrateSchedulesTblType IS TABLE OF OksBillrateSchedulesRecType
82: INDEX BY BINARY_INTEGER;
83: ---------------------------------------------------------------------------

Line 86: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;

82: INDEX BY BINARY_INTEGER;
83: ---------------------------------------------------------------------------
84: -- GLOBAL MESSAGE CONSTANTS
85: ---------------------------------------------------------------------------
86: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
87: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
88: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
89: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
90: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

Line 87: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;

83: ---------------------------------------------------------------------------
84: -- GLOBAL MESSAGE CONSTANTS
85: ---------------------------------------------------------------------------
86: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
87: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
88: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
89: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
90: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
91: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

Line 88: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;

84: -- GLOBAL MESSAGE CONSTANTS
85: ---------------------------------------------------------------------------
86: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
87: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
88: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
89: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
90: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
91: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
92: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

Line 89: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;

85: ---------------------------------------------------------------------------
86: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
87: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
88: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
89: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
90: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
91: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
92: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
93: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

Line 90: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

86: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
87: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
88: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
89: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
90: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
91: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
92: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
93: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
94: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

Line 91: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

87: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
88: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
89: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
90: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
91: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
92: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
93: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
94: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
95: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

Line 92: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

88: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
89: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
90: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
91: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
92: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
93: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
94: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
95: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
96: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';

Line 93: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

89: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
90: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
91: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
92: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
93: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
94: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
95: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
96: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
97: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';

Line 94: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;

90: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
91: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
92: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
93: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
94: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
95: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
96: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
97: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
98: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';

Line 95: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

91: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
92: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
93: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
94: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
95: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
96: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_SERVICE_AVAILABILITY_UNEXPECTED_ERROR';
97: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
98: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
99:

Line 109: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

105: ---------------------------------------------------------------------------
106: -- GLOBAL VARIABLES
107: ---------------------------------------------------------------------------
108: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_BRS_PVT';
109: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
110: ---------------------------------------------------------------------------
111: -- Procedures and Functions
112: ---------------------------------------------------------------------------
113:

Line 133: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);

129: x_msg_count OUT NOCOPY NUMBER,
130: x_msg_data OUT NOCOPY VARCHAR2,
131: p_oks_billrate_schedules_v_tbl IN OksBillrateSchedulesVTblType,
132: x_oks_billrate_schedules_v_tbl OUT NOCOPY OksBillrateSchedulesVTblType,
133: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
134: PROCEDURE insert_row(
135: p_api_version IN NUMBER,
136: p_init_msg_list IN VARCHAR2,
137: x_return_status OUT NOCOPY VARCHAR2,

Line 156: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);

152: x_return_status OUT NOCOPY VARCHAR2,
153: x_msg_count OUT NOCOPY NUMBER,
154: x_msg_data OUT NOCOPY VARCHAR2,
155: p_oks_billrate_schedules_v_tbl IN OksBillrateSchedulesVTblType,
156: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
157: PROCEDURE lock_row(
158: p_api_version IN NUMBER,
159: p_init_msg_list IN VARCHAR2,
160: x_return_status OUT NOCOPY VARCHAR2,

Line 180: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);

176: x_msg_count OUT NOCOPY NUMBER,
177: x_msg_data OUT NOCOPY VARCHAR2,
178: p_oks_billrate_schedules_v_tbl IN OksBillrateSchedulesVTblType,
179: x_oks_billrate_schedules_v_tbl OUT NOCOPY OksBillrateSchedulesVTblType,
180: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
181: PROCEDURE update_row(
182: p_api_version IN NUMBER,
183: p_init_msg_list IN VARCHAR2,
184: x_return_status OUT NOCOPY VARCHAR2,

Line 203: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);

199: x_return_status OUT NOCOPY VARCHAR2,
200: x_msg_count OUT NOCOPY NUMBER,
201: x_msg_data OUT NOCOPY VARCHAR2,
202: p_oks_billrate_schedules_v_tbl IN OksBillrateSchedulesVTblType,
203: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
204: PROCEDURE delete_row(
205: p_api_version IN NUMBER,
206: p_init_msg_list IN VARCHAR2,
207: x_return_status OUT NOCOPY VARCHAR2,

Line 225: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);

221: x_return_status OUT NOCOPY VARCHAR2,
222: x_msg_count OUT NOCOPY NUMBER,
223: x_msg_data OUT NOCOPY VARCHAR2,
224: p_oks_billrate_schedules_v_tbl IN OksBillrateSchedulesVTblType,
225: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
226: PROCEDURE validate_row(
227: p_api_version IN NUMBER,
228: p_init_msg_list IN VARCHAR2,
229: x_return_status OUT NOCOPY VARCHAR2,