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
12: ,credit_option OKS_BATCH_RULES_V.CREDIT_OPTION%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
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
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
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
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
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
18: ,transfer_notes_flag OKS_BATCH_RULES_V.TRANSFER_NOTES_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
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
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
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
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
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
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
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
26: ,bill_contact_id NUMBER := OKC_API.G_MISS_NUM
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
26: ,bill_contact_id NUMBER := OKC_API.G_MISS_NUM
27: ,new_account_id NUMBER := OKC_API.G_MISS_NUM
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
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
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
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
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
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
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
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
24: ,bill_address_id NUMBER := OKC_API.G_MISS_NUM
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
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
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
34: ,object_version_number 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
34: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
35: ,request_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);
36: G_MISS_oks_batch_rules_v_rec oks_batch_rules_v_rec_type;
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);
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
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);
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;
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);
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
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
42: ,batch_type OKS_BATCH_RULES.BATCH_TYPE%TYPE := OKC_API.G_MISS_CHAR
43: ,batch_source OKS_BATCH_RULES.BATCH_SOURCE%TYPE := OKC_API.G_MISS_CHAR
44: ,transaction_date OKS_BATCH_RULES.TRANSACTION_DATE%TYPE := OKC_API.G_MISS_DATE
45: ,credit_option OKS_BATCH_RULES.CREDIT_OPTION%TYPE := OKC_API.G_MISS_CHAR
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
42: ,batch_type OKS_BATCH_RULES.BATCH_TYPE%TYPE := OKC_API.G_MISS_CHAR
43: ,batch_source OKS_BATCH_RULES.BATCH_SOURCE%TYPE := OKC_API.G_MISS_CHAR
44: ,transaction_date OKS_BATCH_RULES.TRANSACTION_DATE%TYPE := OKC_API.G_MISS_DATE
45: ,credit_option OKS_BATCH_RULES.CREDIT_OPTION%TYPE := OKC_API.G_MISS_CHAR
46: ,termination_reason_code OKS_BATCH_RULES.TERMINATION_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
39: -- OKS_BATCH_RULES Record Spec
40: TYPE obtr_rec_type IS RECORD (
41: batch_id NUMBER := OKC_API.G_MISS_NUM
42: ,batch_type OKS_BATCH_RULES.BATCH_TYPE%TYPE := OKC_API.G_MISS_CHAR
43: ,batch_source OKS_BATCH_RULES.BATCH_SOURCE%TYPE := OKC_API.G_MISS_CHAR
44: ,transaction_date OKS_BATCH_RULES.TRANSACTION_DATE%TYPE := OKC_API.G_MISS_DATE
45: ,credit_option OKS_BATCH_RULES.CREDIT_OPTION%TYPE := OKC_API.G_MISS_CHAR
46: ,termination_reason_code OKS_BATCH_RULES.TERMINATION_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
47: ,billing_profile_id NUMBER := OKC_API.G_MISS_NUM
40: TYPE obtr_rec_type IS RECORD (
41: batch_id NUMBER := OKC_API.G_MISS_NUM
42: ,batch_type OKS_BATCH_RULES.BATCH_TYPE%TYPE := OKC_API.G_MISS_CHAR
43: ,batch_source OKS_BATCH_RULES.BATCH_SOURCE%TYPE := OKC_API.G_MISS_CHAR
44: ,transaction_date OKS_BATCH_RULES.TRANSACTION_DATE%TYPE := OKC_API.G_MISS_DATE
45: ,credit_option OKS_BATCH_RULES.CREDIT_OPTION%TYPE := OKC_API.G_MISS_CHAR
46: ,termination_reason_code OKS_BATCH_RULES.TERMINATION_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
47: ,billing_profile_id NUMBER := OKC_API.G_MISS_NUM
48: ,retain_contract_number_flag OKS_BATCH_RULES.RETAIN_CONTRACT_NUMBER_FLAG%TYPE := OKC_API.G_MISS_CHAR
41: batch_id NUMBER := OKC_API.G_MISS_NUM
42: ,batch_type OKS_BATCH_RULES.BATCH_TYPE%TYPE := OKC_API.G_MISS_CHAR
43: ,batch_source OKS_BATCH_RULES.BATCH_SOURCE%TYPE := OKC_API.G_MISS_CHAR
44: ,transaction_date OKS_BATCH_RULES.TRANSACTION_DATE%TYPE := OKC_API.G_MISS_DATE
45: ,credit_option OKS_BATCH_RULES.CREDIT_OPTION%TYPE := OKC_API.G_MISS_CHAR
46: ,termination_reason_code OKS_BATCH_RULES.TERMINATION_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
47: ,billing_profile_id NUMBER := OKC_API.G_MISS_NUM
48: ,retain_contract_number_flag OKS_BATCH_RULES.RETAIN_CONTRACT_NUMBER_FLAG%TYPE := OKC_API.G_MISS_CHAR
49: ,contract_modifier OKS_BATCH_RULES.CONTRACT_MODIFIER%TYPE := OKC_API.G_MISS_CHAR
42: ,batch_type OKS_BATCH_RULES.BATCH_TYPE%TYPE := OKC_API.G_MISS_CHAR
43: ,batch_source OKS_BATCH_RULES.BATCH_SOURCE%TYPE := OKC_API.G_MISS_CHAR
44: ,transaction_date OKS_BATCH_RULES.TRANSACTION_DATE%TYPE := OKC_API.G_MISS_DATE
45: ,credit_option OKS_BATCH_RULES.CREDIT_OPTION%TYPE := OKC_API.G_MISS_CHAR
46: ,termination_reason_code OKS_BATCH_RULES.TERMINATION_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
47: ,billing_profile_id NUMBER := OKC_API.G_MISS_NUM
48: ,retain_contract_number_flag OKS_BATCH_RULES.RETAIN_CONTRACT_NUMBER_FLAG%TYPE := OKC_API.G_MISS_CHAR
49: ,contract_modifier OKS_BATCH_RULES.CONTRACT_MODIFIER%TYPE := OKC_API.G_MISS_CHAR
50: ,contract_status OKS_BATCH_RULES.CONTRACT_STATUS%TYPE := OKC_API.G_MISS_CHAR
43: ,batch_source OKS_BATCH_RULES.BATCH_SOURCE%TYPE := OKC_API.G_MISS_CHAR
44: ,transaction_date OKS_BATCH_RULES.TRANSACTION_DATE%TYPE := OKC_API.G_MISS_DATE
45: ,credit_option OKS_BATCH_RULES.CREDIT_OPTION%TYPE := OKC_API.G_MISS_CHAR
46: ,termination_reason_code OKS_BATCH_RULES.TERMINATION_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
47: ,billing_profile_id NUMBER := OKC_API.G_MISS_NUM
48: ,retain_contract_number_flag OKS_BATCH_RULES.RETAIN_CONTRACT_NUMBER_FLAG%TYPE := OKC_API.G_MISS_CHAR
49: ,contract_modifier OKS_BATCH_RULES.CONTRACT_MODIFIER%TYPE := OKC_API.G_MISS_CHAR
50: ,contract_status OKS_BATCH_RULES.CONTRACT_STATUS%TYPE := OKC_API.G_MISS_CHAR
51: ,transfer_notes_flag OKS_BATCH_RULES.TRANSFER_NOTES_FLAG%TYPE := OKC_API.G_MISS_CHAR
44: ,transaction_date OKS_BATCH_RULES.TRANSACTION_DATE%TYPE := OKC_API.G_MISS_DATE
45: ,credit_option OKS_BATCH_RULES.CREDIT_OPTION%TYPE := OKC_API.G_MISS_CHAR
46: ,termination_reason_code OKS_BATCH_RULES.TERMINATION_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
47: ,billing_profile_id NUMBER := OKC_API.G_MISS_NUM
48: ,retain_contract_number_flag OKS_BATCH_RULES.RETAIN_CONTRACT_NUMBER_FLAG%TYPE := OKC_API.G_MISS_CHAR
49: ,contract_modifier OKS_BATCH_RULES.CONTRACT_MODIFIER%TYPE := OKC_API.G_MISS_CHAR
50: ,contract_status OKS_BATCH_RULES.CONTRACT_STATUS%TYPE := OKC_API.G_MISS_CHAR
51: ,transfer_notes_flag OKS_BATCH_RULES.TRANSFER_NOTES_FLAG%TYPE := OKC_API.G_MISS_CHAR
52: ,transfer_attachments_flag OKS_BATCH_RULES.TRANSFER_ATTACHMENTS_FLAG%TYPE := OKC_API.G_MISS_CHAR
45: ,credit_option OKS_BATCH_RULES.CREDIT_OPTION%TYPE := OKC_API.G_MISS_CHAR
46: ,termination_reason_code OKS_BATCH_RULES.TERMINATION_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
47: ,billing_profile_id NUMBER := OKC_API.G_MISS_NUM
48: ,retain_contract_number_flag OKS_BATCH_RULES.RETAIN_CONTRACT_NUMBER_FLAG%TYPE := OKC_API.G_MISS_CHAR
49: ,contract_modifier OKS_BATCH_RULES.CONTRACT_MODIFIER%TYPE := OKC_API.G_MISS_CHAR
50: ,contract_status OKS_BATCH_RULES.CONTRACT_STATUS%TYPE := OKC_API.G_MISS_CHAR
51: ,transfer_notes_flag OKS_BATCH_RULES.TRANSFER_NOTES_FLAG%TYPE := OKC_API.G_MISS_CHAR
52: ,transfer_attachments_flag OKS_BATCH_RULES.TRANSFER_ATTACHMENTS_FLAG%TYPE := OKC_API.G_MISS_CHAR
53: ,bill_lines_flag OKS_BATCH_RULES.BILL_LINES_FLAG%TYPE := OKC_API.G_MISS_CHAR
46: ,termination_reason_code OKS_BATCH_RULES.TERMINATION_REASON_CODE%TYPE := OKC_API.G_MISS_CHAR
47: ,billing_profile_id NUMBER := OKC_API.G_MISS_NUM
48: ,retain_contract_number_flag OKS_BATCH_RULES.RETAIN_CONTRACT_NUMBER_FLAG%TYPE := OKC_API.G_MISS_CHAR
49: ,contract_modifier OKS_BATCH_RULES.CONTRACT_MODIFIER%TYPE := OKC_API.G_MISS_CHAR
50: ,contract_status OKS_BATCH_RULES.CONTRACT_STATUS%TYPE := OKC_API.G_MISS_CHAR
51: ,transfer_notes_flag OKS_BATCH_RULES.TRANSFER_NOTES_FLAG%TYPE := OKC_API.G_MISS_CHAR
52: ,transfer_attachments_flag OKS_BATCH_RULES.TRANSFER_ATTACHMENTS_FLAG%TYPE := OKC_API.G_MISS_CHAR
53: ,bill_lines_flag OKS_BATCH_RULES.BILL_LINES_FLAG%TYPE := OKC_API.G_MISS_CHAR
54: ,transfer_option_code OKS_BATCH_RULES.TRANSFER_OPTION_CODE%TYPE := OKC_API.G_MISS_CHAR
47: ,billing_profile_id NUMBER := OKC_API.G_MISS_NUM
48: ,retain_contract_number_flag OKS_BATCH_RULES.RETAIN_CONTRACT_NUMBER_FLAG%TYPE := OKC_API.G_MISS_CHAR
49: ,contract_modifier OKS_BATCH_RULES.CONTRACT_MODIFIER%TYPE := OKC_API.G_MISS_CHAR
50: ,contract_status OKS_BATCH_RULES.CONTRACT_STATUS%TYPE := OKC_API.G_MISS_CHAR
51: ,transfer_notes_flag OKS_BATCH_RULES.TRANSFER_NOTES_FLAG%TYPE := OKC_API.G_MISS_CHAR
52: ,transfer_attachments_flag OKS_BATCH_RULES.TRANSFER_ATTACHMENTS_FLAG%TYPE := OKC_API.G_MISS_CHAR
53: ,bill_lines_flag OKS_BATCH_RULES.BILL_LINES_FLAG%TYPE := OKC_API.G_MISS_CHAR
54: ,transfer_option_code OKS_BATCH_RULES.TRANSFER_OPTION_CODE%TYPE := OKC_API.G_MISS_CHAR
55: ,bill_account_id NUMBER := OKC_API.G_MISS_NUM
48: ,retain_contract_number_flag OKS_BATCH_RULES.RETAIN_CONTRACT_NUMBER_FLAG%TYPE := OKC_API.G_MISS_CHAR
49: ,contract_modifier OKS_BATCH_RULES.CONTRACT_MODIFIER%TYPE := OKC_API.G_MISS_CHAR
50: ,contract_status OKS_BATCH_RULES.CONTRACT_STATUS%TYPE := OKC_API.G_MISS_CHAR
51: ,transfer_notes_flag OKS_BATCH_RULES.TRANSFER_NOTES_FLAG%TYPE := OKC_API.G_MISS_CHAR
52: ,transfer_attachments_flag OKS_BATCH_RULES.TRANSFER_ATTACHMENTS_FLAG%TYPE := OKC_API.G_MISS_CHAR
53: ,bill_lines_flag OKS_BATCH_RULES.BILL_LINES_FLAG%TYPE := OKC_API.G_MISS_CHAR
54: ,transfer_option_code OKS_BATCH_RULES.TRANSFER_OPTION_CODE%TYPE := OKC_API.G_MISS_CHAR
55: ,bill_account_id NUMBER := OKC_API.G_MISS_NUM
56: ,ship_account_id NUMBER := OKC_API.G_MISS_NUM
49: ,contract_modifier OKS_BATCH_RULES.CONTRACT_MODIFIER%TYPE := OKC_API.G_MISS_CHAR
50: ,contract_status OKS_BATCH_RULES.CONTRACT_STATUS%TYPE := OKC_API.G_MISS_CHAR
51: ,transfer_notes_flag OKS_BATCH_RULES.TRANSFER_NOTES_FLAG%TYPE := OKC_API.G_MISS_CHAR
52: ,transfer_attachments_flag OKS_BATCH_RULES.TRANSFER_ATTACHMENTS_FLAG%TYPE := OKC_API.G_MISS_CHAR
53: ,bill_lines_flag OKS_BATCH_RULES.BILL_LINES_FLAG%TYPE := OKC_API.G_MISS_CHAR
54: ,transfer_option_code OKS_BATCH_RULES.TRANSFER_OPTION_CODE%TYPE := OKC_API.G_MISS_CHAR
55: ,bill_account_id NUMBER := OKC_API.G_MISS_NUM
56: ,ship_account_id NUMBER := OKC_API.G_MISS_NUM
57: ,bill_address_id NUMBER := OKC_API.G_MISS_NUM
50: ,contract_status OKS_BATCH_RULES.CONTRACT_STATUS%TYPE := OKC_API.G_MISS_CHAR
51: ,transfer_notes_flag OKS_BATCH_RULES.TRANSFER_NOTES_FLAG%TYPE := OKC_API.G_MISS_CHAR
52: ,transfer_attachments_flag OKS_BATCH_RULES.TRANSFER_ATTACHMENTS_FLAG%TYPE := OKC_API.G_MISS_CHAR
53: ,bill_lines_flag OKS_BATCH_RULES.BILL_LINES_FLAG%TYPE := OKC_API.G_MISS_CHAR
54: ,transfer_option_code OKS_BATCH_RULES.TRANSFER_OPTION_CODE%TYPE := OKC_API.G_MISS_CHAR
55: ,bill_account_id NUMBER := OKC_API.G_MISS_NUM
56: ,ship_account_id NUMBER := OKC_API.G_MISS_NUM
57: ,bill_address_id NUMBER := OKC_API.G_MISS_NUM
58: ,ship_address_id NUMBER := OKC_API.G_MISS_NUM
51: ,transfer_notes_flag OKS_BATCH_RULES.TRANSFER_NOTES_FLAG%TYPE := OKC_API.G_MISS_CHAR
52: ,transfer_attachments_flag OKS_BATCH_RULES.TRANSFER_ATTACHMENTS_FLAG%TYPE := OKC_API.G_MISS_CHAR
53: ,bill_lines_flag OKS_BATCH_RULES.BILL_LINES_FLAG%TYPE := OKC_API.G_MISS_CHAR
54: ,transfer_option_code OKS_BATCH_RULES.TRANSFER_OPTION_CODE%TYPE := OKC_API.G_MISS_CHAR
55: ,bill_account_id NUMBER := OKC_API.G_MISS_NUM
56: ,ship_account_id NUMBER := OKC_API.G_MISS_NUM
57: ,bill_address_id NUMBER := OKC_API.G_MISS_NUM
58: ,ship_address_id NUMBER := OKC_API.G_MISS_NUM
59: ,bill_contact_id NUMBER := OKC_API.G_MISS_NUM
52: ,transfer_attachments_flag OKS_BATCH_RULES.TRANSFER_ATTACHMENTS_FLAG%TYPE := OKC_API.G_MISS_CHAR
53: ,bill_lines_flag OKS_BATCH_RULES.BILL_LINES_FLAG%TYPE := OKC_API.G_MISS_CHAR
54: ,transfer_option_code OKS_BATCH_RULES.TRANSFER_OPTION_CODE%TYPE := OKC_API.G_MISS_CHAR
55: ,bill_account_id NUMBER := OKC_API.G_MISS_NUM
56: ,ship_account_id NUMBER := OKC_API.G_MISS_NUM
57: ,bill_address_id NUMBER := OKC_API.G_MISS_NUM
58: ,ship_address_id NUMBER := OKC_API.G_MISS_NUM
59: ,bill_contact_id NUMBER := OKC_API.G_MISS_NUM
60: ,new_account_id NUMBER := OKC_API.G_MISS_NUM
53: ,bill_lines_flag OKS_BATCH_RULES.BILL_LINES_FLAG%TYPE := OKC_API.G_MISS_CHAR
54: ,transfer_option_code OKS_BATCH_RULES.TRANSFER_OPTION_CODE%TYPE := OKC_API.G_MISS_CHAR
55: ,bill_account_id NUMBER := OKC_API.G_MISS_NUM
56: ,ship_account_id NUMBER := OKC_API.G_MISS_NUM
57: ,bill_address_id NUMBER := OKC_API.G_MISS_NUM
58: ,ship_address_id NUMBER := OKC_API.G_MISS_NUM
59: ,bill_contact_id NUMBER := OKC_API.G_MISS_NUM
60: ,new_account_id NUMBER := OKC_API.G_MISS_NUM
61: ,created_by NUMBER := OKC_API.G_MISS_NUM
54: ,transfer_option_code OKS_BATCH_RULES.TRANSFER_OPTION_CODE%TYPE := OKC_API.G_MISS_CHAR
55: ,bill_account_id NUMBER := OKC_API.G_MISS_NUM
56: ,ship_account_id NUMBER := OKC_API.G_MISS_NUM
57: ,bill_address_id NUMBER := OKC_API.G_MISS_NUM
58: ,ship_address_id NUMBER := OKC_API.G_MISS_NUM
59: ,bill_contact_id NUMBER := OKC_API.G_MISS_NUM
60: ,new_account_id NUMBER := OKC_API.G_MISS_NUM
61: ,created_by NUMBER := OKC_API.G_MISS_NUM
62: ,creation_date OKS_BATCH_RULES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
55: ,bill_account_id NUMBER := OKC_API.G_MISS_NUM
56: ,ship_account_id NUMBER := OKC_API.G_MISS_NUM
57: ,bill_address_id NUMBER := OKC_API.G_MISS_NUM
58: ,ship_address_id NUMBER := OKC_API.G_MISS_NUM
59: ,bill_contact_id NUMBER := OKC_API.G_MISS_NUM
60: ,new_account_id NUMBER := OKC_API.G_MISS_NUM
61: ,created_by NUMBER := OKC_API.G_MISS_NUM
62: ,creation_date OKS_BATCH_RULES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
63: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
56: ,ship_account_id NUMBER := OKC_API.G_MISS_NUM
57: ,bill_address_id NUMBER := OKC_API.G_MISS_NUM
58: ,ship_address_id NUMBER := OKC_API.G_MISS_NUM
59: ,bill_contact_id NUMBER := OKC_API.G_MISS_NUM
60: ,new_account_id NUMBER := OKC_API.G_MISS_NUM
61: ,created_by NUMBER := OKC_API.G_MISS_NUM
62: ,creation_date OKS_BATCH_RULES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
63: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
64: ,last_update_date OKS_BATCH_RULES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
57: ,bill_address_id NUMBER := OKC_API.G_MISS_NUM
58: ,ship_address_id NUMBER := OKC_API.G_MISS_NUM
59: ,bill_contact_id NUMBER := OKC_API.G_MISS_NUM
60: ,new_account_id NUMBER := OKC_API.G_MISS_NUM
61: ,created_by NUMBER := OKC_API.G_MISS_NUM
62: ,creation_date OKS_BATCH_RULES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
63: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
64: ,last_update_date OKS_BATCH_RULES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
65: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
58: ,ship_address_id NUMBER := OKC_API.G_MISS_NUM
59: ,bill_contact_id NUMBER := OKC_API.G_MISS_NUM
60: ,new_account_id NUMBER := OKC_API.G_MISS_NUM
61: ,created_by NUMBER := OKC_API.G_MISS_NUM
62: ,creation_date OKS_BATCH_RULES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
63: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
64: ,last_update_date OKS_BATCH_RULES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
65: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
66: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
59: ,bill_contact_id NUMBER := OKC_API.G_MISS_NUM
60: ,new_account_id NUMBER := OKC_API.G_MISS_NUM
61: ,created_by NUMBER := OKC_API.G_MISS_NUM
62: ,creation_date OKS_BATCH_RULES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
63: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
64: ,last_update_date OKS_BATCH_RULES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
65: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
66: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
67: ,request_id NUMBER := OKC_API.G_MISS_NUM);
60: ,new_account_id NUMBER := OKC_API.G_MISS_NUM
61: ,created_by NUMBER := OKC_API.G_MISS_NUM
62: ,creation_date OKS_BATCH_RULES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
63: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
64: ,last_update_date OKS_BATCH_RULES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
65: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
66: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
67: ,request_id NUMBER := OKC_API.G_MISS_NUM);
68: G_MISS_obtr_rec obtr_rec_type;
61: ,created_by NUMBER := OKC_API.G_MISS_NUM
62: ,creation_date OKS_BATCH_RULES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
63: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
64: ,last_update_date OKS_BATCH_RULES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
65: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
66: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
67: ,request_id NUMBER := OKC_API.G_MISS_NUM);
68: G_MISS_obtr_rec obtr_rec_type;
69: TYPE obtr_tbl_type IS TABLE OF obtr_rec_type
62: ,creation_date OKS_BATCH_RULES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE
63: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
64: ,last_update_date OKS_BATCH_RULES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
65: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
66: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
67: ,request_id NUMBER := OKC_API.G_MISS_NUM);
68: G_MISS_obtr_rec obtr_rec_type;
69: TYPE obtr_tbl_type IS TABLE OF obtr_rec_type
70: INDEX BY BINARY_INTEGER;
63: ,last_updated_by NUMBER := OKC_API.G_MISS_NUM
64: ,last_update_date OKS_BATCH_RULES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE
65: ,last_update_login NUMBER := OKC_API.G_MISS_NUM
66: ,object_version_number NUMBER := OKC_API.G_MISS_NUM
67: ,request_id NUMBER := OKC_API.G_MISS_NUM);
68: G_MISS_obtr_rec obtr_rec_type;
69: TYPE obtr_tbl_type IS TABLE OF obtr_rec_type
70: INDEX BY BINARY_INTEGER;
71: ---------------------------------------------------------------------------
70: INDEX BY BINARY_INTEGER;
71: ---------------------------------------------------------------------------
72: -- GLOBAL MESSAGE CONSTANTS
73: ---------------------------------------------------------------------------
74: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
75: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
76: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
77: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
78: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
71: ---------------------------------------------------------------------------
72: -- GLOBAL MESSAGE CONSTANTS
73: ---------------------------------------------------------------------------
74: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
75: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
76: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
77: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
78: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
79: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
72: -- GLOBAL MESSAGE CONSTANTS
73: ---------------------------------------------------------------------------
74: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
75: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
76: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
77: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
78: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
79: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
80: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
73: ---------------------------------------------------------------------------
74: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
75: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
76: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
77: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
78: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
79: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
80: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
81: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
74: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
75: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
76: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
77: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
78: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
79: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
80: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
81: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
82: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
75: G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
76: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
77: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
78: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
79: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
80: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
81: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
82: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
83: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
76: G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
77: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
78: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
79: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
80: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
81: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
82: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
83: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
84: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_UNEXPECTED_ERROR';
77: G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
78: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
79: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
80: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
81: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
82: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
83: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
84: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_UNEXPECTED_ERROR';
85: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
78: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
79: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
80: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
81: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
82: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
83: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
84: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_UNEXPECTED_ERROR';
85: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
86: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
79: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
80: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
81: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
82: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
83: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
84: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKS_UNEXPECTED_ERROR';
85: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
86: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
87:
93: ---------------------------------------------------------------------------
94: -- GLOBAL VARIABLES
95: ---------------------------------------------------------------------------
96: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKS_BRL_PVT';
97: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
98: ---------------------------------------------------------------------------
99: -- Procedures and Functions
100: ---------------------------------------------------------------------------
101:
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,
125: x_return_status OUT NOCOPY 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,
148: 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,
172: x_return_status OUT NOCOPY 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,
195: x_return_status OUT NOCOPY 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,
217: x_return_status OUT NOCOPY VARCHAR2,