DBA Data[Home] [Help]

APPS.OKS_BRL_PVT dependencies on OKC_API

Line 8: batch_id NUMBER := OKC_API.G_MISS_NUM

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

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 14: ,billing_profile_id NUMBER := OKC_API.G_MISS_NUM

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

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 22: ,bill_account_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

Line 23: ,ship_account_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

Line 24: ,bill_address_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

Line 25: ,ship_address_id 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

Line 26: ,bill_contact_id NUMBER := OKC_API.G_MISS_NUM

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

Line 27: ,new_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
31: ,last_update_date OKS_BATCH_RULES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 28: ,created_by 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
32: ,last_update_login 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 30: ,last_updated_by 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

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 32: ,last_update_login 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;

Line 33: ,security_group_id 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;
37: TYPE oks_batch_rules_v_tbl_type IS TABLE OF oks_batch_rules_v_rec_type

Line 34: ,object_version_number NUMBER := OKC_API.G_MISS_NUM

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;

Line 35: ,request_id 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;
39: -- OKS_BATCH_RULES Record Spec

Line 41: batch_id NUMBER := OKC_API.G_MISS_NUM

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

Line 42: ,batch_type OKS_BATCH_RULES.BATCH_TYPE%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

Line 43: ,batch_source OKS_BATCH_RULES.BATCH_SOURCE%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

Line 44: ,transaction_date OKS_BATCH_RULES.TRANSACTION_DATE%TYPE := OKC_API.G_MISS_DATE

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

Line 45: ,credit_option OKS_BATCH_RULES.CREDIT_OPTION%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

Line 46: ,termination_reason_code OKS_BATCH_RULES.TERMINATION_REASON_CODE%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

Line 47: ,billing_profile_id NUMBER := OKC_API.G_MISS_NUM

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

Line 48: ,retain_contract_number_flag OKS_BATCH_RULES.RETAIN_CONTRACT_NUMBER_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

Line 49: ,contract_modifier OKS_BATCH_RULES.CONTRACT_MODIFIER%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

Line 50: ,contract_status OKS_BATCH_RULES.CONTRACT_STATUS%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

Line 51: ,transfer_notes_flag OKS_BATCH_RULES.TRANSFER_NOTES_FLAG%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

Line 52: ,transfer_attachments_flag OKS_BATCH_RULES.TRANSFER_ATTACHMENTS_FLAG%TYPE := OKC_API.G_MISS_CHAR

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

Line 53: ,bill_lines_flag OKS_BATCH_RULES.BILL_LINES_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
57: ,bill_address_id NUMBER := OKC_API.G_MISS_NUM

Line 54: ,transfer_option_code OKS_BATCH_RULES.TRANSFER_OPTION_CODE%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
58: ,ship_address_id NUMBER := OKC_API.G_MISS_NUM

Line 55: ,bill_account_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

Line 56: ,ship_account_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

Line 57: ,bill_address_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

Line 58: ,ship_address_id 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

Line 59: ,bill_contact_id NUMBER := OKC_API.G_MISS_NUM

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

Line 60: ,new_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
64: ,last_update_date OKS_BATCH_RULES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

Line 61: ,created_by 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
65: ,last_update_login NUMBER := OKC_API.G_MISS_NUM

Line 62: ,creation_date OKS_BATCH_RULES.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE

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

Line 63: ,last_updated_by 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);

Line 64: ,last_update_date OKS_BATCH_RULES.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE

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;

Line 65: ,last_update_login 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;
69: TYPE obtr_tbl_type IS TABLE OF obtr_rec_type

Line 66: ,object_version_number 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
70: INDEX BY BINARY_INTEGER;

Line 67: ,request_id NUMBER := OKC_API.G_MISS_NUM);

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: ---------------------------------------------------------------------------

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

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;

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

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;

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

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;

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

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;

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

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;

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

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;

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

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';

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

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';

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

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';

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

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:

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

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:

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

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,

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

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,

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

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,

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

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,

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

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,