DBA Data[Home] [Help]

APPS.OKS_BRL_PVT dependencies on OKS_BATCH_RULES_V

Line 6: -- OKS_BATCH_RULES_V Record Spec

2: /* $Header: OKSSBRLS.pls 120.3 2006/09/11 23:20:42 dneetha noship $ */
3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKS_BATCH_RULES_V Record Spec
7: TYPE oks_batch_rules_v_rec_type IS RECORD (
8: batch_id NUMBER := OKC_API.G_MISS_NUM
9: ,batch_type OKS_BATCH_RULES_V.BATCH_TYPE%TYPE := OKC_API.G_MISS_CHAR
10: ,batch_source OKS_BATCH_RULES_V.BATCH_SOURCE%TYPE := OKC_API.G_MISS_CHAR

Line 7: TYPE oks_batch_rules_v_rec_type IS RECORD (

3: ---------------------------------------------------------------------------
4: -- GLOBAL DATASTRUCTURES
5: ---------------------------------------------------------------------------
6: -- OKS_BATCH_RULES_V Record Spec
7: TYPE oks_batch_rules_v_rec_type IS RECORD (
8: batch_id NUMBER := OKC_API.G_MISS_NUM
9: ,batch_type OKS_BATCH_RULES_V.BATCH_TYPE%TYPE := OKC_API.G_MISS_CHAR
10: ,batch_source OKS_BATCH_RULES_V.BATCH_SOURCE%TYPE := OKC_API.G_MISS_CHAR
11: ,transaction_date OKS_BATCH_RULES_V.TRANSACTION_DATE%TYPE := OKC_API.G_MISS_DATE

Line 9: ,batch_type OKS_BATCH_RULES_V.BATCH_TYPE%TYPE := OKC_API.G_MISS_CHAR

5: ---------------------------------------------------------------------------
6: -- OKS_BATCH_RULES_V Record Spec
7: TYPE oks_batch_rules_v_rec_type IS RECORD (
8: batch_id NUMBER := OKC_API.G_MISS_NUM
9: ,batch_type OKS_BATCH_RULES_V.BATCH_TYPE%TYPE := OKC_API.G_MISS_CHAR
10: ,batch_source OKS_BATCH_RULES_V.BATCH_SOURCE%TYPE := OKC_API.G_MISS_CHAR
11: ,transaction_date OKS_BATCH_RULES_V.TRANSACTION_DATE%TYPE := OKC_API.G_MISS_DATE
12: ,credit_option OKS_BATCH_RULES_V.CREDIT_OPTION%TYPE := OKC_API.G_MISS_CHAR
13: ,termination_reason_code OKS_BATCH_RULES_V.TERMINATION_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR

Line 10: ,batch_source OKS_BATCH_RULES_V.BATCH_SOURCE%TYPE := OKC_API.G_MISS_CHAR

6: -- OKS_BATCH_RULES_V Record Spec
7: TYPE oks_batch_rules_v_rec_type IS RECORD (
8: batch_id NUMBER := OKC_API.G_MISS_NUM
9: ,batch_type OKS_BATCH_RULES_V.BATCH_TYPE%TYPE := OKC_API.G_MISS_CHAR
10: ,batch_source OKS_BATCH_RULES_V.BATCH_SOURCE%TYPE := OKC_API.G_MISS_CHAR
11: ,transaction_date OKS_BATCH_RULES_V.TRANSACTION_DATE%TYPE := OKC_API.G_MISS_DATE
12: ,credit_option OKS_BATCH_RULES_V.CREDIT_OPTION%TYPE := OKC_API.G_MISS_CHAR
13: ,termination_reason_code OKS_BATCH_RULES_V.TERMINATION_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
14: ,billing_profile_id NUMBER := OKC_API.G_MISS_NUM

Line 11: ,transaction_date OKS_BATCH_RULES_V.TRANSACTION_DATE%TYPE := OKC_API.G_MISS_DATE

7: TYPE oks_batch_rules_v_rec_type IS RECORD (
8: batch_id NUMBER := OKC_API.G_MISS_NUM
9: ,batch_type OKS_BATCH_RULES_V.BATCH_TYPE%TYPE := OKC_API.G_MISS_CHAR
10: ,batch_source OKS_BATCH_RULES_V.BATCH_SOURCE%TYPE := OKC_API.G_MISS_CHAR
11: ,transaction_date OKS_BATCH_RULES_V.TRANSACTION_DATE%TYPE := OKC_API.G_MISS_DATE
12: ,credit_option OKS_BATCH_RULES_V.CREDIT_OPTION%TYPE := OKC_API.G_MISS_CHAR
13: ,termination_reason_code OKS_BATCH_RULES_V.TERMINATION_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
14: ,billing_profile_id NUMBER := OKC_API.G_MISS_NUM
15: ,retain_contract_number_flag OKS_BATCH_RULES_V.RETAIN_CONTRACT_NUMBER_FLAG%TYPE := OKC_API.G_MISS_CHAR

Line 12: ,credit_option OKS_BATCH_RULES_V.CREDIT_OPTION%TYPE := OKC_API.G_MISS_CHAR

8: batch_id NUMBER := OKC_API.G_MISS_NUM
9: ,batch_type OKS_BATCH_RULES_V.BATCH_TYPE%TYPE := OKC_API.G_MISS_CHAR
10: ,batch_source OKS_BATCH_RULES_V.BATCH_SOURCE%TYPE := OKC_API.G_MISS_CHAR
11: ,transaction_date OKS_BATCH_RULES_V.TRANSACTION_DATE%TYPE := OKC_API.G_MISS_DATE
12: ,credit_option OKS_BATCH_RULES_V.CREDIT_OPTION%TYPE := OKC_API.G_MISS_CHAR
13: ,termination_reason_code OKS_BATCH_RULES_V.TERMINATION_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
14: ,billing_profile_id NUMBER := OKC_API.G_MISS_NUM
15: ,retain_contract_number_flag OKS_BATCH_RULES_V.RETAIN_CONTRACT_NUMBER_FLAG%TYPE := OKC_API.G_MISS_CHAR
16: ,contract_modifier OKS_BATCH_RULES_V.CONTRACT_MODIFIER%TYPE := OKC_API.G_MISS_CHAR

Line 13: ,termination_reason_code OKS_BATCH_RULES_V.TERMINATION_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR

9: ,batch_type OKS_BATCH_RULES_V.BATCH_TYPE%TYPE := OKC_API.G_MISS_CHAR
10: ,batch_source OKS_BATCH_RULES_V.BATCH_SOURCE%TYPE := OKC_API.G_MISS_CHAR
11: ,transaction_date OKS_BATCH_RULES_V.TRANSACTION_DATE%TYPE := OKC_API.G_MISS_DATE
12: ,credit_option OKS_BATCH_RULES_V.CREDIT_OPTION%TYPE := OKC_API.G_MISS_CHAR
13: ,termination_reason_code OKS_BATCH_RULES_V.TERMINATION_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
14: ,billing_profile_id NUMBER := OKC_API.G_MISS_NUM
15: ,retain_contract_number_flag OKS_BATCH_RULES_V.RETAIN_CONTRACT_NUMBER_FLAG%TYPE := OKC_API.G_MISS_CHAR
16: ,contract_modifier OKS_BATCH_RULES_V.CONTRACT_MODIFIER%TYPE := OKC_API.G_MISS_CHAR
17: ,contract_status OKS_BATCH_RULES_V.CONTRACT_STATUS%TYPE := OKC_API.G_MISS_CHAR

Line 15: ,retain_contract_number_flag OKS_BATCH_RULES_V.RETAIN_CONTRACT_NUMBER_FLAG%TYPE := OKC_API.G_MISS_CHAR

11: ,transaction_date OKS_BATCH_RULES_V.TRANSACTION_DATE%TYPE := OKC_API.G_MISS_DATE
12: ,credit_option OKS_BATCH_RULES_V.CREDIT_OPTION%TYPE := OKC_API.G_MISS_CHAR
13: ,termination_reason_code OKS_BATCH_RULES_V.TERMINATION_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
14: ,billing_profile_id NUMBER := OKC_API.G_MISS_NUM
15: ,retain_contract_number_flag OKS_BATCH_RULES_V.RETAIN_CONTRACT_NUMBER_FLAG%TYPE := OKC_API.G_MISS_CHAR
16: ,contract_modifier OKS_BATCH_RULES_V.CONTRACT_MODIFIER%TYPE := OKC_API.G_MISS_CHAR
17: ,contract_status OKS_BATCH_RULES_V.CONTRACT_STATUS%TYPE := OKC_API.G_MISS_CHAR
18: ,transfer_notes_flag OKS_BATCH_RULES_V.TRANSFER_NOTES_FLAG%TYPE := OKC_API.G_MISS_CHAR
19: ,transfer_attachments_flag OKS_BATCH_RULES_V.TRANSFER_ATTACHMENTS_FLAG%TYPE := OKC_API.G_MISS_CHAR

Line 16: ,contract_modifier OKS_BATCH_RULES_V.CONTRACT_MODIFIER%TYPE := OKC_API.G_MISS_CHAR

12: ,credit_option OKS_BATCH_RULES_V.CREDIT_OPTION%TYPE := OKC_API.G_MISS_CHAR
13: ,termination_reason_code OKS_BATCH_RULES_V.TERMINATION_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
14: ,billing_profile_id NUMBER := OKC_API.G_MISS_NUM
15: ,retain_contract_number_flag OKS_BATCH_RULES_V.RETAIN_CONTRACT_NUMBER_FLAG%TYPE := OKC_API.G_MISS_CHAR
16: ,contract_modifier OKS_BATCH_RULES_V.CONTRACT_MODIFIER%TYPE := OKC_API.G_MISS_CHAR
17: ,contract_status OKS_BATCH_RULES_V.CONTRACT_STATUS%TYPE := OKC_API.G_MISS_CHAR
18: ,transfer_notes_flag OKS_BATCH_RULES_V.TRANSFER_NOTES_FLAG%TYPE := OKC_API.G_MISS_CHAR
19: ,transfer_attachments_flag OKS_BATCH_RULES_V.TRANSFER_ATTACHMENTS_FLAG%TYPE := OKC_API.G_MISS_CHAR
20: ,bill_lines_flag OKS_BATCH_RULES_V.BILL_LINES_FLAG%TYPE := OKC_API.G_MISS_CHAR

Line 17: ,contract_status OKS_BATCH_RULES_V.CONTRACT_STATUS%TYPE := OKC_API.G_MISS_CHAR

13: ,termination_reason_code OKS_BATCH_RULES_V.TERMINATION_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
14: ,billing_profile_id NUMBER := OKC_API.G_MISS_NUM
15: ,retain_contract_number_flag OKS_BATCH_RULES_V.RETAIN_CONTRACT_NUMBER_FLAG%TYPE := OKC_API.G_MISS_CHAR
16: ,contract_modifier OKS_BATCH_RULES_V.CONTRACT_MODIFIER%TYPE := OKC_API.G_MISS_CHAR
17: ,contract_status OKS_BATCH_RULES_V.CONTRACT_STATUS%TYPE := OKC_API.G_MISS_CHAR
18: ,transfer_notes_flag OKS_BATCH_RULES_V.TRANSFER_NOTES_FLAG%TYPE := OKC_API.G_MISS_CHAR
19: ,transfer_attachments_flag OKS_BATCH_RULES_V.TRANSFER_ATTACHMENTS_FLAG%TYPE := OKC_API.G_MISS_CHAR
20: ,bill_lines_flag OKS_BATCH_RULES_V.BILL_LINES_FLAG%TYPE := OKC_API.G_MISS_CHAR
21: ,transfer_option_code OKS_BATCH_RULES_V.TRANSFER_OPTION_CODE%TYPE := OKC_API.G_MISS_CHAR

Line 18: ,transfer_notes_flag OKS_BATCH_RULES_V.TRANSFER_NOTES_FLAG%TYPE := OKC_API.G_MISS_CHAR

14: ,billing_profile_id NUMBER := OKC_API.G_MISS_NUM
15: ,retain_contract_number_flag OKS_BATCH_RULES_V.RETAIN_CONTRACT_NUMBER_FLAG%TYPE := OKC_API.G_MISS_CHAR
16: ,contract_modifier OKS_BATCH_RULES_V.CONTRACT_MODIFIER%TYPE := OKC_API.G_MISS_CHAR
17: ,contract_status OKS_BATCH_RULES_V.CONTRACT_STATUS%TYPE := OKC_API.G_MISS_CHAR
18: ,transfer_notes_flag OKS_BATCH_RULES_V.TRANSFER_NOTES_FLAG%TYPE := OKC_API.G_MISS_CHAR
19: ,transfer_attachments_flag OKS_BATCH_RULES_V.TRANSFER_ATTACHMENTS_FLAG%TYPE := OKC_API.G_MISS_CHAR
20: ,bill_lines_flag OKS_BATCH_RULES_V.BILL_LINES_FLAG%TYPE := OKC_API.G_MISS_CHAR
21: ,transfer_option_code OKS_BATCH_RULES_V.TRANSFER_OPTION_CODE%TYPE := OKC_API.G_MISS_CHAR
22: ,bill_account_id NUMBER := OKC_API.G_MISS_NUM

Line 19: ,transfer_attachments_flag OKS_BATCH_RULES_V.TRANSFER_ATTACHMENTS_FLAG%TYPE := OKC_API.G_MISS_CHAR

15: ,retain_contract_number_flag OKS_BATCH_RULES_V.RETAIN_CONTRACT_NUMBER_FLAG%TYPE := OKC_API.G_MISS_CHAR
16: ,contract_modifier OKS_BATCH_RULES_V.CONTRACT_MODIFIER%TYPE := OKC_API.G_MISS_CHAR
17: ,contract_status OKS_BATCH_RULES_V.CONTRACT_STATUS%TYPE := OKC_API.G_MISS_CHAR
18: ,transfer_notes_flag OKS_BATCH_RULES_V.TRANSFER_NOTES_FLAG%TYPE := OKC_API.G_MISS_CHAR
19: ,transfer_attachments_flag OKS_BATCH_RULES_V.TRANSFER_ATTACHMENTS_FLAG%TYPE := OKC_API.G_MISS_CHAR
20: ,bill_lines_flag OKS_BATCH_RULES_V.BILL_LINES_FLAG%TYPE := OKC_API.G_MISS_CHAR
21: ,transfer_option_code OKS_BATCH_RULES_V.TRANSFER_OPTION_CODE%TYPE := OKC_API.G_MISS_CHAR
22: ,bill_account_id NUMBER := OKC_API.G_MISS_NUM
23: ,ship_account_id NUMBER := OKC_API.G_MISS_NUM

Line 20: ,bill_lines_flag OKS_BATCH_RULES_V.BILL_LINES_FLAG%TYPE := OKC_API.G_MISS_CHAR

16: ,contract_modifier OKS_BATCH_RULES_V.CONTRACT_MODIFIER%TYPE := OKC_API.G_MISS_CHAR
17: ,contract_status OKS_BATCH_RULES_V.CONTRACT_STATUS%TYPE := OKC_API.G_MISS_CHAR
18: ,transfer_notes_flag OKS_BATCH_RULES_V.TRANSFER_NOTES_FLAG%TYPE := OKC_API.G_MISS_CHAR
19: ,transfer_attachments_flag OKS_BATCH_RULES_V.TRANSFER_ATTACHMENTS_FLAG%TYPE := OKC_API.G_MISS_CHAR
20: ,bill_lines_flag OKS_BATCH_RULES_V.BILL_LINES_FLAG%TYPE := OKC_API.G_MISS_CHAR
21: ,transfer_option_code OKS_BATCH_RULES_V.TRANSFER_OPTION_CODE%TYPE := OKC_API.G_MISS_CHAR
22: ,bill_account_id NUMBER := OKC_API.G_MISS_NUM
23: ,ship_account_id NUMBER := OKC_API.G_MISS_NUM
24: ,bill_address_id NUMBER := OKC_API.G_MISS_NUM

Line 21: ,transfer_option_code OKS_BATCH_RULES_V.TRANSFER_OPTION_CODE%TYPE := OKC_API.G_MISS_CHAR

17: ,contract_status OKS_BATCH_RULES_V.CONTRACT_STATUS%TYPE := OKC_API.G_MISS_CHAR
18: ,transfer_notes_flag OKS_BATCH_RULES_V.TRANSFER_NOTES_FLAG%TYPE := OKC_API.G_MISS_CHAR
19: ,transfer_attachments_flag OKS_BATCH_RULES_V.TRANSFER_ATTACHMENTS_FLAG%TYPE := OKC_API.G_MISS_CHAR
20: ,bill_lines_flag OKS_BATCH_RULES_V.BILL_LINES_FLAG%TYPE := OKC_API.G_MISS_CHAR
21: ,transfer_option_code OKS_BATCH_RULES_V.TRANSFER_OPTION_CODE%TYPE := OKC_API.G_MISS_CHAR
22: ,bill_account_id NUMBER := OKC_API.G_MISS_NUM
23: ,ship_account_id NUMBER := OKC_API.G_MISS_NUM
24: ,bill_address_id NUMBER := OKC_API.G_MISS_NUM
25: ,ship_address_id NUMBER := OKC_API.G_MISS_NUM

Line 29: ,creation_date OKS_BATCH_RULES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

25: ,ship_address_id NUMBER := OKC_API.G_MISS_NUM
26: ,bill_contact_id NUMBER := OKC_API.G_MISS_NUM
27: ,new_account_id NUMBER := OKC_API.G_MISS_NUM
28: ,created_by NUMBER := OKC_API.G_MISS_NUM
29: ,creation_date OKS_BATCH_RULES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
30: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
31: ,last_update_date OKS_BATCH_RULES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
32: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
33: ,security_group_id NUMBER := OKC_API.G_MISS_NUM

Line 31: ,last_update_date OKS_BATCH_RULES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

27: ,new_account_id NUMBER := OKC_API.G_MISS_NUM
28: ,created_by NUMBER := OKC_API.G_MISS_NUM
29: ,creation_date OKS_BATCH_RULES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
30: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
31: ,last_update_date OKS_BATCH_RULES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
32: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
33: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
34: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
35: ,request_id NUMBER := OKC_API.G_MISS_NUM);

Line 36: G_MISS_oks_batch_rules_v_rec oks_batch_rules_v_rec_type;

32: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
33: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
34: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
35: ,request_id NUMBER := OKC_API.G_MISS_NUM);
36: G_MISS_oks_batch_rules_v_rec oks_batch_rules_v_rec_type;
37: TYPE oks_batch_rules_v_tbl_type IS TABLE OF oks_batch_rules_v_rec_type
38: INDEX BY BINARY_INTEGER;
39: -- OKS_BATCH_RULES Record Spec
40: TYPE obtr_rec_type IS RECORD (

Line 37: TYPE oks_batch_rules_v_tbl_type IS TABLE OF oks_batch_rules_v_rec_type

33: ,security_group_id NUMBER := OKC_API.G_MISS_NUM
34: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
35: ,request_id NUMBER := OKC_API.G_MISS_NUM);
36: G_MISS_oks_batch_rules_v_rec oks_batch_rules_v_rec_type;
37: TYPE oks_batch_rules_v_tbl_type IS TABLE OF oks_batch_rules_v_rec_type
38: INDEX BY BINARY_INTEGER;
39: -- OKS_BATCH_RULES Record Spec
40: TYPE obtr_rec_type IS RECORD (
41: batch_id NUMBER := OKC_API.G_MISS_NUM

Line 111: p_oks_batch_rules_v_rec IN oks_batch_rules_v_rec_type,

107: p_init_msg_list IN VARCHAR2,
108: x_return_status OUT NOCOPY VARCHAR2,
109: x_msg_count OUT NOCOPY NUMBER,
110: x_msg_data OUT NOCOPY VARCHAR2,
111: p_oks_batch_rules_v_rec IN oks_batch_rules_v_rec_type,
112: x_oks_batch_rules_v_rec OUT NOCOPY oks_batch_rules_v_rec_type);
113: PROCEDURE insert_row(
114: p_api_version IN NUMBER,
115: p_init_msg_list IN VARCHAR2,

Line 112: x_oks_batch_rules_v_rec OUT NOCOPY oks_batch_rules_v_rec_type);

108: x_return_status OUT NOCOPY VARCHAR2,
109: x_msg_count OUT NOCOPY NUMBER,
110: x_msg_data OUT NOCOPY VARCHAR2,
111: p_oks_batch_rules_v_rec IN oks_batch_rules_v_rec_type,
112: x_oks_batch_rules_v_rec OUT NOCOPY oks_batch_rules_v_rec_type);
113: PROCEDURE insert_row(
114: p_api_version IN NUMBER,
115: p_init_msg_list IN VARCHAR2,
116: x_return_status OUT NOCOPY VARCHAR2,

Line 119: p_oks_batch_rules_v_tbl IN oks_batch_rules_v_tbl_type,

115: p_init_msg_list IN VARCHAR2,
116: x_return_status OUT NOCOPY VARCHAR2,
117: x_msg_count OUT NOCOPY NUMBER,
118: x_msg_data OUT NOCOPY VARCHAR2,
119: p_oks_batch_rules_v_tbl IN oks_batch_rules_v_tbl_type,
120: x_oks_batch_rules_v_tbl OUT NOCOPY oks_batch_rules_v_tbl_type,
121: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
122: PROCEDURE insert_row(
123: p_api_version IN NUMBER,

Line 120: x_oks_batch_rules_v_tbl OUT NOCOPY oks_batch_rules_v_tbl_type,

116: x_return_status OUT NOCOPY VARCHAR2,
117: x_msg_count OUT NOCOPY NUMBER,
118: x_msg_data OUT NOCOPY VARCHAR2,
119: p_oks_batch_rules_v_tbl IN oks_batch_rules_v_tbl_type,
120: x_oks_batch_rules_v_tbl OUT NOCOPY oks_batch_rules_v_tbl_type,
121: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
122: PROCEDURE insert_row(
123: p_api_version IN NUMBER,
124: p_init_msg_list IN VARCHAR2,

Line 128: p_oks_batch_rules_v_tbl IN oks_batch_rules_v_tbl_type,

124: p_init_msg_list IN VARCHAR2,
125: x_return_status OUT NOCOPY VARCHAR2,
126: x_msg_count OUT NOCOPY NUMBER,
127: x_msg_data OUT NOCOPY VARCHAR2,
128: p_oks_batch_rules_v_tbl IN oks_batch_rules_v_tbl_type,
129: x_oks_batch_rules_v_tbl OUT NOCOPY oks_batch_rules_v_tbl_type);
130: PROCEDURE lock_row(
131: p_api_version IN NUMBER,
132: p_init_msg_list IN VARCHAR2,

Line 129: x_oks_batch_rules_v_tbl OUT NOCOPY oks_batch_rules_v_tbl_type);

125: x_return_status OUT NOCOPY VARCHAR2,
126: x_msg_count OUT NOCOPY NUMBER,
127: x_msg_data OUT NOCOPY VARCHAR2,
128: p_oks_batch_rules_v_tbl IN oks_batch_rules_v_tbl_type,
129: x_oks_batch_rules_v_tbl OUT NOCOPY oks_batch_rules_v_tbl_type);
130: PROCEDURE lock_row(
131: p_api_version IN NUMBER,
132: p_init_msg_list IN VARCHAR2,
133: x_return_status OUT NOCOPY VARCHAR2,

Line 136: p_oks_batch_rules_v_rec IN oks_batch_rules_v_rec_type);

132: p_init_msg_list IN VARCHAR2,
133: x_return_status OUT NOCOPY VARCHAR2,
134: x_msg_count OUT NOCOPY NUMBER,
135: x_msg_data OUT NOCOPY VARCHAR2,
136: p_oks_batch_rules_v_rec IN oks_batch_rules_v_rec_type);
137: PROCEDURE lock_row(
138: p_api_version IN NUMBER,
139: p_init_msg_list IN VARCHAR2,
140: x_return_status OUT NOCOPY VARCHAR2,

Line 143: p_oks_batch_rules_v_tbl IN oks_batch_rules_v_tbl_type,

139: p_init_msg_list IN VARCHAR2,
140: x_return_status OUT NOCOPY VARCHAR2,
141: x_msg_count OUT NOCOPY NUMBER,
142: x_msg_data OUT NOCOPY VARCHAR2,
143: p_oks_batch_rules_v_tbl IN oks_batch_rules_v_tbl_type,
144: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
145: PROCEDURE lock_row(
146: p_api_version IN NUMBER,
147: p_init_msg_list IN VARCHAR2,

Line 151: p_oks_batch_rules_v_tbl IN oks_batch_rules_v_tbl_type);

147: p_init_msg_list IN VARCHAR2,
148: x_return_status OUT NOCOPY VARCHAR2,
149: x_msg_count OUT NOCOPY NUMBER,
150: x_msg_data OUT NOCOPY VARCHAR2,
151: p_oks_batch_rules_v_tbl IN oks_batch_rules_v_tbl_type);
152: PROCEDURE update_row(
153: p_api_version IN NUMBER,
154: p_init_msg_list IN VARCHAR2,
155: x_return_status OUT NOCOPY VARCHAR2,

Line 158: p_oks_batch_rules_v_rec IN oks_batch_rules_v_rec_type,

154: p_init_msg_list IN VARCHAR2,
155: x_return_status OUT NOCOPY VARCHAR2,
156: x_msg_count OUT NOCOPY NUMBER,
157: x_msg_data OUT NOCOPY VARCHAR2,
158: p_oks_batch_rules_v_rec IN oks_batch_rules_v_rec_type,
159: x_oks_batch_rules_v_rec OUT NOCOPY oks_batch_rules_v_rec_type);
160: PROCEDURE update_row(
161: p_api_version IN NUMBER,
162: p_init_msg_list IN VARCHAR2,

Line 159: x_oks_batch_rules_v_rec OUT NOCOPY oks_batch_rules_v_rec_type);

155: x_return_status OUT NOCOPY VARCHAR2,
156: x_msg_count OUT NOCOPY NUMBER,
157: x_msg_data OUT NOCOPY VARCHAR2,
158: p_oks_batch_rules_v_rec IN oks_batch_rules_v_rec_type,
159: x_oks_batch_rules_v_rec OUT NOCOPY oks_batch_rules_v_rec_type);
160: PROCEDURE update_row(
161: p_api_version IN NUMBER,
162: p_init_msg_list IN VARCHAR2,
163: x_return_status OUT NOCOPY VARCHAR2,

Line 166: p_oks_batch_rules_v_tbl IN oks_batch_rules_v_tbl_type,

162: p_init_msg_list IN VARCHAR2,
163: x_return_status OUT NOCOPY VARCHAR2,
164: x_msg_count OUT NOCOPY NUMBER,
165: x_msg_data OUT NOCOPY VARCHAR2,
166: p_oks_batch_rules_v_tbl IN oks_batch_rules_v_tbl_type,
167: x_oks_batch_rules_v_tbl OUT NOCOPY oks_batch_rules_v_tbl_type,
168: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
169: PROCEDURE update_row(
170: p_api_version IN NUMBER,

Line 167: x_oks_batch_rules_v_tbl OUT NOCOPY oks_batch_rules_v_tbl_type,

163: x_return_status OUT NOCOPY VARCHAR2,
164: x_msg_count OUT NOCOPY NUMBER,
165: x_msg_data OUT NOCOPY VARCHAR2,
166: p_oks_batch_rules_v_tbl IN oks_batch_rules_v_tbl_type,
167: x_oks_batch_rules_v_tbl OUT NOCOPY oks_batch_rules_v_tbl_type,
168: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
169: PROCEDURE update_row(
170: p_api_version IN NUMBER,
171: p_init_msg_list IN VARCHAR2,

Line 175: p_oks_batch_rules_v_tbl IN oks_batch_rules_v_tbl_type,

171: p_init_msg_list IN VARCHAR2,
172: x_return_status OUT NOCOPY VARCHAR2,
173: x_msg_count OUT NOCOPY NUMBER,
174: x_msg_data OUT NOCOPY VARCHAR2,
175: p_oks_batch_rules_v_tbl IN oks_batch_rules_v_tbl_type,
176: x_oks_batch_rules_v_tbl OUT NOCOPY oks_batch_rules_v_tbl_type);
177: PROCEDURE delete_row(
178: p_api_version IN NUMBER,
179: p_init_msg_list IN VARCHAR2,

Line 176: x_oks_batch_rules_v_tbl OUT NOCOPY oks_batch_rules_v_tbl_type);

172: x_return_status OUT NOCOPY VARCHAR2,
173: x_msg_count OUT NOCOPY NUMBER,
174: x_msg_data OUT NOCOPY VARCHAR2,
175: p_oks_batch_rules_v_tbl IN oks_batch_rules_v_tbl_type,
176: x_oks_batch_rules_v_tbl OUT NOCOPY oks_batch_rules_v_tbl_type);
177: PROCEDURE delete_row(
178: p_api_version IN NUMBER,
179: p_init_msg_list IN VARCHAR2,
180: x_return_status OUT NOCOPY VARCHAR2,

Line 183: p_oks_batch_rules_v_rec IN oks_batch_rules_v_rec_type);

179: p_init_msg_list IN VARCHAR2,
180: x_return_status OUT NOCOPY VARCHAR2,
181: x_msg_count OUT NOCOPY NUMBER,
182: x_msg_data OUT NOCOPY VARCHAR2,
183: p_oks_batch_rules_v_rec IN oks_batch_rules_v_rec_type);
184: PROCEDURE delete_row(
185: p_api_version IN NUMBER,
186: p_init_msg_list IN VARCHAR2,
187: x_return_status OUT NOCOPY VARCHAR2,

Line 190: p_oks_batch_rules_v_tbl IN oks_batch_rules_v_tbl_type,

186: p_init_msg_list IN VARCHAR2,
187: x_return_status OUT NOCOPY VARCHAR2,
188: x_msg_count OUT NOCOPY NUMBER,
189: x_msg_data OUT NOCOPY VARCHAR2,
190: p_oks_batch_rules_v_tbl IN oks_batch_rules_v_tbl_type,
191: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
192: PROCEDURE delete_row(
193: p_api_version IN NUMBER,
194: p_init_msg_list IN VARCHAR2,

Line 198: p_oks_batch_rules_v_tbl IN oks_batch_rules_v_tbl_type);

194: p_init_msg_list IN VARCHAR2,
195: x_return_status OUT NOCOPY VARCHAR2,
196: x_msg_count OUT NOCOPY NUMBER,
197: x_msg_data OUT NOCOPY VARCHAR2,
198: p_oks_batch_rules_v_tbl IN oks_batch_rules_v_tbl_type);
199: PROCEDURE validate_row(
200: p_api_version IN NUMBER,
201: p_init_msg_list IN VARCHAR2,
202: x_return_status OUT NOCOPY VARCHAR2,

Line 205: p_oks_batch_rules_v_rec IN oks_batch_rules_v_rec_type);

201: p_init_msg_list IN VARCHAR2,
202: x_return_status OUT NOCOPY VARCHAR2,
203: x_msg_count OUT NOCOPY NUMBER,
204: x_msg_data OUT NOCOPY VARCHAR2,
205: p_oks_batch_rules_v_rec IN oks_batch_rules_v_rec_type);
206: PROCEDURE validate_row(
207: p_api_version IN NUMBER,
208: p_init_msg_list IN VARCHAR2,
209: x_return_status OUT NOCOPY VARCHAR2,

Line 212: p_oks_batch_rules_v_tbl IN oks_batch_rules_v_tbl_type,

208: p_init_msg_list IN VARCHAR2,
209: x_return_status OUT NOCOPY VARCHAR2,
210: x_msg_count OUT NOCOPY NUMBER,
211: x_msg_data OUT NOCOPY VARCHAR2,
212: p_oks_batch_rules_v_tbl IN oks_batch_rules_v_tbl_type,
213: px_error_tbl IN OUT NOCOPY OKC_API.ERROR_TBL_TYPE);
214: PROCEDURE validate_row(
215: p_api_version IN NUMBER,
216: p_init_msg_list IN VARCHAR2,

Line 220: p_oks_batch_rules_v_tbl IN oks_batch_rules_v_tbl_type);

216: p_init_msg_list IN VARCHAR2,
217: x_return_status OUT NOCOPY VARCHAR2,
218: x_msg_count OUT NOCOPY NUMBER,
219: x_msg_data OUT NOCOPY VARCHAR2,
220: p_oks_batch_rules_v_tbl IN oks_batch_rules_v_tbl_type);
221: END OKS_BRL_PVT;