DBA Data[Home] [Help]

APPS.OKS_BRS_PVT dependencies on OKS_BILLRATE_SCHEDULES_V

Line 6: -- OKS_BILLRATE_SCHEDULES_V Record Spec

2: /* $Header: OKSSBRSS.pls 120.0 2005/05/25 18:11:16 appldev noship $ */
3: ---------------------------------------------------------------------------
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

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 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 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 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 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 123: p_oks_billrate_schedules_v_rec IN OksBillrateSchedulesVRecType,

119: p_init_msg_list IN VARCHAR2,
120: x_return_status OUT NOCOPY VARCHAR2,
121: x_msg_count OUT NOCOPY NUMBER,
122: x_msg_data OUT NOCOPY VARCHAR2,
123: p_oks_billrate_schedules_v_rec IN OksBillrateSchedulesVRecType,
124: x_oks_billrate_schedules_v_rec OUT NOCOPY OksBillrateSchedulesVRecType);
125: PROCEDURE insert_row(
126: p_api_version IN NUMBER,
127: p_init_msg_list IN VARCHAR2,

Line 124: x_oks_billrate_schedules_v_rec OUT NOCOPY OksBillrateSchedulesVRecType);

120: x_return_status OUT NOCOPY VARCHAR2,
121: x_msg_count OUT NOCOPY NUMBER,
122: x_msg_data OUT NOCOPY VARCHAR2,
123: p_oks_billrate_schedules_v_rec IN OksBillrateSchedulesVRecType,
124: x_oks_billrate_schedules_v_rec OUT NOCOPY OksBillrateSchedulesVRecType);
125: PROCEDURE insert_row(
126: p_api_version IN NUMBER,
127: p_init_msg_list IN VARCHAR2,
128: x_return_status OUT NOCOPY VARCHAR2,

Line 131: p_oks_billrate_schedules_v_tbl IN OksBillrateSchedulesVTblType,

127: p_init_msg_list IN VARCHAR2,
128: x_return_status OUT NOCOPY VARCHAR2,
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,

Line 132: x_oks_billrate_schedules_v_tbl OUT NOCOPY OksBillrateSchedulesVTblType,

128: x_return_status OUT NOCOPY VARCHAR2,
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,

Line 140: p_oks_billrate_schedules_v_tbl IN OksBillrateSchedulesVTblType,

136: p_init_msg_list IN VARCHAR2,
137: x_return_status OUT NOCOPY VARCHAR2,
138: x_msg_count OUT NOCOPY NUMBER,
139: x_msg_data OUT NOCOPY VARCHAR2,
140: p_oks_billrate_schedules_v_tbl IN OksBillrateSchedulesVTblType,
141: x_oks_billrate_schedules_v_tbl OUT NOCOPY OksBillrateSchedulesVTblType);
142: PROCEDURE lock_row(
143: p_api_version IN NUMBER,
144: p_init_msg_list IN VARCHAR2,

Line 141: x_oks_billrate_schedules_v_tbl OUT NOCOPY OksBillrateSchedulesVTblType);

137: x_return_status OUT NOCOPY VARCHAR2,
138: x_msg_count OUT NOCOPY NUMBER,
139: x_msg_data OUT NOCOPY VARCHAR2,
140: p_oks_billrate_schedules_v_tbl IN OksBillrateSchedulesVTblType,
141: x_oks_billrate_schedules_v_tbl OUT NOCOPY OksBillrateSchedulesVTblType);
142: PROCEDURE lock_row(
143: p_api_version IN NUMBER,
144: p_init_msg_list IN VARCHAR2,
145: x_return_status OUT NOCOPY VARCHAR2,

Line 148: p_oks_billrate_schedules_v_rec IN OksBillrateSchedulesVRecType);

144: p_init_msg_list IN VARCHAR2,
145: x_return_status OUT NOCOPY VARCHAR2,
146: x_msg_count OUT NOCOPY NUMBER,
147: x_msg_data OUT NOCOPY VARCHAR2,
148: p_oks_billrate_schedules_v_rec IN OksBillrateSchedulesVRecType);
149: PROCEDURE lock_row(
150: p_api_version IN NUMBER,
151: p_init_msg_list IN VARCHAR2,
152: x_return_status OUT NOCOPY VARCHAR2,

Line 155: p_oks_billrate_schedules_v_tbl IN OksBillrateSchedulesVTblType,

151: p_init_msg_list IN VARCHAR2,
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,

Line 163: p_oks_billrate_schedules_v_tbl IN OksBillrateSchedulesVTblType);

159: p_init_msg_list IN VARCHAR2,
160: x_return_status OUT NOCOPY VARCHAR2,
161: x_msg_count OUT NOCOPY NUMBER,
162: x_msg_data OUT NOCOPY VARCHAR2,
163: p_oks_billrate_schedules_v_tbl IN OksBillrateSchedulesVTblType);
164: PROCEDURE update_row(
165: p_api_version IN NUMBER,
166: p_init_msg_list IN VARCHAR2,
167: x_return_status OUT NOCOPY VARCHAR2,

Line 170: p_oks_billrate_schedules_v_rec IN OksBillrateSchedulesVRecType,

166: p_init_msg_list IN VARCHAR2,
167: x_return_status OUT NOCOPY VARCHAR2,
168: x_msg_count OUT NOCOPY NUMBER,
169: x_msg_data OUT NOCOPY VARCHAR2,
170: p_oks_billrate_schedules_v_rec IN OksBillrateSchedulesVRecType,
171: x_oks_billrate_schedules_v_rec OUT NOCOPY OksBillrateSchedulesVRecType);
172: PROCEDURE update_row(
173: p_api_version IN NUMBER,
174: p_init_msg_list IN VARCHAR2,

Line 171: x_oks_billrate_schedules_v_rec OUT NOCOPY OksBillrateSchedulesVRecType);

167: x_return_status OUT NOCOPY VARCHAR2,
168: x_msg_count OUT NOCOPY NUMBER,
169: x_msg_data OUT NOCOPY VARCHAR2,
170: p_oks_billrate_schedules_v_rec IN OksBillrateSchedulesVRecType,
171: x_oks_billrate_schedules_v_rec OUT NOCOPY OksBillrateSchedulesVRecType);
172: PROCEDURE update_row(
173: p_api_version IN NUMBER,
174: p_init_msg_list IN VARCHAR2,
175: x_return_status OUT NOCOPY VARCHAR2,

Line 178: p_oks_billrate_schedules_v_tbl IN OksBillrateSchedulesVTblType,

174: p_init_msg_list IN VARCHAR2,
175: x_return_status OUT NOCOPY VARCHAR2,
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,

Line 179: x_oks_billrate_schedules_v_tbl OUT NOCOPY OksBillrateSchedulesVTblType,

175: x_return_status OUT NOCOPY VARCHAR2,
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,

Line 187: p_oks_billrate_schedules_v_tbl IN OksBillrateSchedulesVTblType,

183: p_init_msg_list IN VARCHAR2,
184: x_return_status OUT NOCOPY VARCHAR2,
185: x_msg_count OUT NOCOPY NUMBER,
186: x_msg_data OUT NOCOPY VARCHAR2,
187: p_oks_billrate_schedules_v_tbl IN OksBillrateSchedulesVTblType,
188: x_oks_billrate_schedules_v_tbl OUT NOCOPY OksBillrateSchedulesVTblType);
189: PROCEDURE delete_row(
190: p_api_version IN NUMBER,
191: p_init_msg_list IN VARCHAR2,

Line 188: x_oks_billrate_schedules_v_tbl OUT NOCOPY OksBillrateSchedulesVTblType);

184: x_return_status OUT NOCOPY VARCHAR2,
185: x_msg_count OUT NOCOPY NUMBER,
186: x_msg_data OUT NOCOPY VARCHAR2,
187: p_oks_billrate_schedules_v_tbl IN OksBillrateSchedulesVTblType,
188: x_oks_billrate_schedules_v_tbl OUT NOCOPY OksBillrateSchedulesVTblType);
189: PROCEDURE delete_row(
190: p_api_version IN NUMBER,
191: p_init_msg_list IN VARCHAR2,
192: x_return_status OUT NOCOPY VARCHAR2,

Line 195: p_oks_billrate_schedules_v_rec IN OksBillrateSchedulesVRecType);

191: p_init_msg_list IN VARCHAR2,
192: x_return_status OUT NOCOPY VARCHAR2,
193: x_msg_count OUT NOCOPY NUMBER,
194: x_msg_data OUT NOCOPY VARCHAR2,
195: p_oks_billrate_schedules_v_rec IN OksBillrateSchedulesVRecType);
196: PROCEDURE delete_row(
197: p_api_version IN NUMBER,
198: p_init_msg_list IN VARCHAR2,
199: x_return_status OUT NOCOPY VARCHAR2,

Line 202: p_oks_billrate_schedules_v_tbl IN OksBillrateSchedulesVTblType,

198: p_init_msg_list IN VARCHAR2,
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,

Line 210: p_oks_billrate_schedules_v_tbl IN OksBillrateSchedulesVTblType);

206: p_init_msg_list IN VARCHAR2,
207: x_return_status OUT NOCOPY VARCHAR2,
208: x_msg_count OUT NOCOPY NUMBER,
209: x_msg_data OUT NOCOPY VARCHAR2,
210: p_oks_billrate_schedules_v_tbl IN OksBillrateSchedulesVTblType);
211: PROCEDURE validate_row(
212: p_api_version IN NUMBER,
213: p_init_msg_list IN VARCHAR2,
214: x_return_status OUT NOCOPY VARCHAR2,

Line 217: p_oks_billrate_schedules_v_rec IN OksBillrateSchedulesVRecType);

213: p_init_msg_list IN VARCHAR2,
214: x_return_status OUT NOCOPY VARCHAR2,
215: x_msg_count OUT NOCOPY NUMBER,
216: x_msg_data OUT NOCOPY VARCHAR2,
217: p_oks_billrate_schedules_v_rec IN OksBillrateSchedulesVRecType);
218: PROCEDURE validate_row(
219: p_api_version IN NUMBER,
220: p_init_msg_list IN VARCHAR2,
221: x_return_status OUT NOCOPY VARCHAR2,

Line 224: p_oks_billrate_schedules_v_tbl IN OksBillrateSchedulesVTblType,

220: p_init_msg_list IN VARCHAR2,
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,

Line 232: p_oks_billrate_schedules_v_tbl IN OksBillrateSchedulesVTblType);

228: p_init_msg_list IN VARCHAR2,
229: x_return_status OUT NOCOPY VARCHAR2,
230: x_msg_count OUT NOCOPY NUMBER,
231: x_msg_data OUT NOCOPY VARCHAR2,
232: p_oks_billrate_schedules_v_tbl IN OksBillrateSchedulesVTblType);
233:
234:
235: FUNCTION Create_Version(
236: p_id IN NUMBER,