DBA Data[Home] [Help]

APPS.ZX_PROCESS_RESULTS_PKG dependencies on ZX_PROCESS_RESULTS

Line 1: package ZX_PROCESS_RESULTS_PKG as

1: package ZX_PROCESS_RESULTS_PKG as
2: /* $Header: zxdprocessrsltss.pls 120.3 2003/12/19 03:51:43 ssekuri ship $ */
3:
4: TYPE T_CONTENT_OWNER_ID is TABLE of zx_process_results.content_owner_id%type
5: index by binary_integer;

Line 4: TYPE T_CONTENT_OWNER_ID is TABLE of zx_process_results.content_owner_id%type

1: package ZX_PROCESS_RESULTS_PKG as
2: /* $Header: zxdprocessrsltss.pls 120.3 2003/12/19 03:51:43 ssekuri ship $ */
3:
4: TYPE T_CONTENT_OWNER_ID is TABLE of zx_process_results.content_owner_id%type
5: index by binary_integer;
6: TYPE T_CONDITION_GROUP_ID is TABLE of zx_process_results.condition_group_id%type
7: index by binary_integer;
8: TYPE T_CONDITION_GROUP_CODE

Line 6: TYPE T_CONDITION_GROUP_ID is TABLE of zx_process_results.condition_group_id%type

2: /* $Header: zxdprocessrsltss.pls 120.3 2003/12/19 03:51:43 ssekuri ship $ */
3:
4: TYPE T_CONTENT_OWNER_ID is TABLE of zx_process_results.content_owner_id%type
5: index by binary_integer;
6: TYPE T_CONDITION_GROUP_ID is TABLE of zx_process_results.condition_group_id%type
7: index by binary_integer;
8: TYPE T_CONDITION_GROUP_CODE
9: is TABLE of zx_process_results.condition_group_code%type
10: index by binary_integer;

Line 9: is TABLE of zx_process_results.condition_group_code%type

5: index by binary_integer;
6: TYPE T_CONDITION_GROUP_ID is TABLE of zx_process_results.condition_group_id%type
7: index by binary_integer;
8: TYPE T_CONDITION_GROUP_CODE
9: is TABLE of zx_process_results.condition_group_code%type
10: index by binary_integer;
11: TYPE T_TAX_RULE_ID is TABLE of zx_process_results.tax_rule_id%type
12: index by binary_integer;
13: TYPE T_PRIORITY is TABLE of zx_process_results.priority%type

Line 11: TYPE T_TAX_RULE_ID is TABLE of zx_process_results.tax_rule_id%type

7: index by binary_integer;
8: TYPE T_CONDITION_GROUP_CODE
9: is TABLE of zx_process_results.condition_group_code%type
10: index by binary_integer;
11: TYPE T_TAX_RULE_ID is TABLE of zx_process_results.tax_rule_id%type
12: index by binary_integer;
13: TYPE T_PRIORITY is TABLE of zx_process_results.priority%type
14: index by binary_integer;
15: TYPE T_RESULT_TYPE is TABLE of zx_process_results.Result_Type_Code%type

Line 13: TYPE T_PRIORITY is TABLE of zx_process_results.priority%type

9: is TABLE of zx_process_results.condition_group_code%type
10: index by binary_integer;
11: TYPE T_TAX_RULE_ID is TABLE of zx_process_results.tax_rule_id%type
12: index by binary_integer;
13: TYPE T_PRIORITY is TABLE of zx_process_results.priority%type
14: index by binary_integer;
15: TYPE T_RESULT_TYPE is TABLE of zx_process_results.Result_Type_Code%type
16: index by binary_integer;
17: TYPE T_TAX_STATUS_CODE is TABLE of zx_process_results.tax_status_code%type

Line 15: TYPE T_RESULT_TYPE is TABLE of zx_process_results.Result_Type_Code%type

11: TYPE T_TAX_RULE_ID is TABLE of zx_process_results.tax_rule_id%type
12: index by binary_integer;
13: TYPE T_PRIORITY is TABLE of zx_process_results.priority%type
14: index by binary_integer;
15: TYPE T_RESULT_TYPE is TABLE of zx_process_results.Result_Type_Code%type
16: index by binary_integer;
17: TYPE T_TAX_STATUS_CODE is TABLE of zx_process_results.tax_status_code%type
18: index by binary_integer;
19: TYPE T_NUMERIC_RESULT is TABLE of zx_process_results.numeric_result%type

Line 17: TYPE T_TAX_STATUS_CODE is TABLE of zx_process_results.tax_status_code%type

13: TYPE T_PRIORITY is TABLE of zx_process_results.priority%type
14: index by binary_integer;
15: TYPE T_RESULT_TYPE is TABLE of zx_process_results.Result_Type_Code%type
16: index by binary_integer;
17: TYPE T_TAX_STATUS_CODE is TABLE of zx_process_results.tax_status_code%type
18: index by binary_integer;
19: TYPE T_NUMERIC_RESULT is TABLE of zx_process_results.numeric_result%type
20: index by binary_integer;
21: TYPE T_ALPHANUMERIC_RESULT

Line 19: TYPE T_NUMERIC_RESULT is TABLE of zx_process_results.numeric_result%type

15: TYPE T_RESULT_TYPE is TABLE of zx_process_results.Result_Type_Code%type
16: index by binary_integer;
17: TYPE T_TAX_STATUS_CODE is TABLE of zx_process_results.tax_status_code%type
18: index by binary_integer;
19: TYPE T_NUMERIC_RESULT is TABLE of zx_process_results.numeric_result%type
20: index by binary_integer;
21: TYPE T_ALPHANUMERIC_RESULT
22: is TABLE of zx_process_results.alphanumeric_result%type
23: index by binary_integer;

Line 22: is TABLE of zx_process_results.alphanumeric_result%type

18: index by binary_integer;
19: TYPE T_NUMERIC_RESULT is TABLE of zx_process_results.numeric_result%type
20: index by binary_integer;
21: TYPE T_ALPHANUMERIC_RESULT
22: is TABLE of zx_process_results.alphanumeric_result%type
23: index by binary_integer;
24: TYPE T_RESULT_API is TABLE of zx_process_results.result_api%type
25: index by binary_integer;
26: TYPE T_STATUS_RESULT is TABLE of zx_process_results.status_result%type

Line 24: TYPE T_RESULT_API is TABLE of zx_process_results.result_api%type

20: index by binary_integer;
21: TYPE T_ALPHANUMERIC_RESULT
22: is TABLE of zx_process_results.alphanumeric_result%type
23: index by binary_integer;
24: TYPE T_RESULT_API is TABLE of zx_process_results.result_api%type
25: index by binary_integer;
26: TYPE T_STATUS_RESULT is TABLE of zx_process_results.status_result%type
27: index by binary_integer;
28: TYPE T_RATE_RESULT is TABLE of zx_process_results.rate_result%type

Line 26: TYPE T_STATUS_RESULT is TABLE of zx_process_results.status_result%type

22: is TABLE of zx_process_results.alphanumeric_result%type
23: index by binary_integer;
24: TYPE T_RESULT_API is TABLE of zx_process_results.result_api%type
25: index by binary_integer;
26: TYPE T_STATUS_RESULT is TABLE of zx_process_results.status_result%type
27: index by binary_integer;
28: TYPE T_RATE_RESULT is TABLE of zx_process_results.rate_result%type
29: index by binary_integer;
30: TYPE T_LEGAL_MESSAGE_CODE is TABLE of zx_process_results.legal_message_code%type

Line 28: TYPE T_RATE_RESULT is TABLE of zx_process_results.rate_result%type

24: TYPE T_RESULT_API is TABLE of zx_process_results.result_api%type
25: index by binary_integer;
26: TYPE T_STATUS_RESULT is TABLE of zx_process_results.status_result%type
27: index by binary_integer;
28: TYPE T_RATE_RESULT is TABLE of zx_process_results.rate_result%type
29: index by binary_integer;
30: TYPE T_LEGAL_MESSAGE_CODE is TABLE of zx_process_results.legal_message_code%type
31: index by binary_integer;
32: TYPE T_MIN_TAX_AMT is TABLE of zx_process_results.min_tax_amt%type

Line 30: TYPE T_LEGAL_MESSAGE_CODE is TABLE of zx_process_results.legal_message_code%type

26: TYPE T_STATUS_RESULT is TABLE of zx_process_results.status_result%type
27: index by binary_integer;
28: TYPE T_RATE_RESULT is TABLE of zx_process_results.rate_result%type
29: index by binary_integer;
30: TYPE T_LEGAL_MESSAGE_CODE is TABLE of zx_process_results.legal_message_code%type
31: index by binary_integer;
32: TYPE T_MIN_TAX_AMT is TABLE of zx_process_results.min_tax_amt%type
33: index by binary_integer;
34: TYPE T_MAX_TAX_AMT is TABLE of zx_process_results.max_tax_amt%type

Line 32: TYPE T_MIN_TAX_AMT is TABLE of zx_process_results.min_tax_amt%type

28: TYPE T_RATE_RESULT is TABLE of zx_process_results.rate_result%type
29: index by binary_integer;
30: TYPE T_LEGAL_MESSAGE_CODE is TABLE of zx_process_results.legal_message_code%type
31: index by binary_integer;
32: TYPE T_MIN_TAX_AMT is TABLE of zx_process_results.min_tax_amt%type
33: index by binary_integer;
34: TYPE T_MAX_TAX_AMT is TABLE of zx_process_results.max_tax_amt%type
35: index by binary_integer;
36: TYPE T_MIN_TAXABLE_BASIS is TABLE of zx_process_results.min_taxable_basis%type

Line 34: TYPE T_MAX_TAX_AMT is TABLE of zx_process_results.max_tax_amt%type

30: TYPE T_LEGAL_MESSAGE_CODE is TABLE of zx_process_results.legal_message_code%type
31: index by binary_integer;
32: TYPE T_MIN_TAX_AMT is TABLE of zx_process_results.min_tax_amt%type
33: index by binary_integer;
34: TYPE T_MAX_TAX_AMT is TABLE of zx_process_results.max_tax_amt%type
35: index by binary_integer;
36: TYPE T_MIN_TAXABLE_BASIS is TABLE of zx_process_results.min_taxable_basis%type
37: index by binary_integer;
38: TYPE T_MAX_TAXABLE_BASIS is TABLE of zx_process_results.max_taxable_basis%type

Line 36: TYPE T_MIN_TAXABLE_BASIS is TABLE of zx_process_results.min_taxable_basis%type

32: TYPE T_MIN_TAX_AMT is TABLE of zx_process_results.min_tax_amt%type
33: index by binary_integer;
34: TYPE T_MAX_TAX_AMT is TABLE of zx_process_results.max_tax_amt%type
35: index by binary_integer;
36: TYPE T_MIN_TAXABLE_BASIS is TABLE of zx_process_results.min_taxable_basis%type
37: index by binary_integer;
38: TYPE T_MAX_TAXABLE_BASIS is TABLE of zx_process_results.max_taxable_basis%type
39: index by binary_integer;
40: TYPE T_MIN_TAX_RATE is TABLE of zx_process_results.min_tax_rate%type

Line 38: TYPE T_MAX_TAXABLE_BASIS is TABLE of zx_process_results.max_taxable_basis%type

34: TYPE T_MAX_TAX_AMT is TABLE of zx_process_results.max_tax_amt%type
35: index by binary_integer;
36: TYPE T_MIN_TAXABLE_BASIS is TABLE of zx_process_results.min_taxable_basis%type
37: index by binary_integer;
38: TYPE T_MAX_TAXABLE_BASIS is TABLE of zx_process_results.max_taxable_basis%type
39: index by binary_integer;
40: TYPE T_MIN_TAX_RATE is TABLE of zx_process_results.min_tax_rate%type
41: index by binary_integer;
42: TYPE T_MAX_TAX_RATE is TABLE of zx_process_results.max_tax_rate%type

Line 40: TYPE T_MIN_TAX_RATE is TABLE of zx_process_results.min_tax_rate%type

36: TYPE T_MIN_TAXABLE_BASIS is TABLE of zx_process_results.min_taxable_basis%type
37: index by binary_integer;
38: TYPE T_MAX_TAXABLE_BASIS is TABLE of zx_process_results.max_taxable_basis%type
39: index by binary_integer;
40: TYPE T_MIN_TAX_RATE is TABLE of zx_process_results.min_tax_rate%type
41: index by binary_integer;
42: TYPE T_MAX_TAX_RATE is TABLE of zx_process_results.max_tax_rate%type
43: index by binary_integer;
44: TYPE T_ENABLED_FLG is TABLE of zx_process_results.Enabled_Flag%type

Line 42: TYPE T_MAX_TAX_RATE is TABLE of zx_process_results.max_tax_rate%type

38: TYPE T_MAX_TAXABLE_BASIS is TABLE of zx_process_results.max_taxable_basis%type
39: index by binary_integer;
40: TYPE T_MIN_TAX_RATE is TABLE of zx_process_results.min_tax_rate%type
41: index by binary_integer;
42: TYPE T_MAX_TAX_RATE is TABLE of zx_process_results.max_tax_rate%type
43: index by binary_integer;
44: TYPE T_ENABLED_FLG is TABLE of zx_process_results.Enabled_Flag%type
45: index by binary_integer;
46: TYPE T_ALLOW_EXEMPTIONS is TABLE of zx_process_results.Allow_Exemptions_Flag%type

Line 44: TYPE T_ENABLED_FLG is TABLE of zx_process_results.Enabled_Flag%type

40: TYPE T_MIN_TAX_RATE is TABLE of zx_process_results.min_tax_rate%type
41: index by binary_integer;
42: TYPE T_MAX_TAX_RATE is TABLE of zx_process_results.max_tax_rate%type
43: index by binary_integer;
44: TYPE T_ENABLED_FLG is TABLE of zx_process_results.Enabled_Flag%type
45: index by binary_integer;
46: TYPE T_ALLOW_EXEMPTIONS is TABLE of zx_process_results.Allow_Exemptions_Flag%type
47: index by binary_integer;
48: TYPE T_ALLOW_EXCEPTIONS is TABLE of zx_process_results.Allow_Exceptions_Flag%type

Line 46: TYPE T_ALLOW_EXEMPTIONS is TABLE of zx_process_results.Allow_Exemptions_Flag%type

42: TYPE T_MAX_TAX_RATE is TABLE of zx_process_results.max_tax_rate%type
43: index by binary_integer;
44: TYPE T_ENABLED_FLG is TABLE of zx_process_results.Enabled_Flag%type
45: index by binary_integer;
46: TYPE T_ALLOW_EXEMPTIONS is TABLE of zx_process_results.Allow_Exemptions_Flag%type
47: index by binary_integer;
48: TYPE T_ALLOW_EXCEPTIONS is TABLE of zx_process_results.Allow_Exceptions_Flag%type
49: index by binary_integer;
50: TYPE T_RECORD_TYPE is TABLE of zx_process_results.Record_Type_Code%type

Line 48: TYPE T_ALLOW_EXCEPTIONS is TABLE of zx_process_results.Allow_Exceptions_Flag%type

44: TYPE T_ENABLED_FLG is TABLE of zx_process_results.Enabled_Flag%type
45: index by binary_integer;
46: TYPE T_ALLOW_EXEMPTIONS is TABLE of zx_process_results.Allow_Exemptions_Flag%type
47: index by binary_integer;
48: TYPE T_ALLOW_EXCEPTIONS is TABLE of zx_process_results.Allow_Exceptions_Flag%type
49: index by binary_integer;
50: TYPE T_RECORD_TYPE is TABLE of zx_process_results.Record_Type_Code%type
51: index by binary_integer;
52:

Line 50: TYPE T_RECORD_TYPE is TABLE of zx_process_results.Record_Type_Code%type

46: TYPE T_ALLOW_EXEMPTIONS is TABLE of zx_process_results.Allow_Exemptions_Flag%type
47: index by binary_integer;
48: TYPE T_ALLOW_EXCEPTIONS is TABLE of zx_process_results.Allow_Exceptions_Flag%type
49: index by binary_integer;
50: TYPE T_RECORD_TYPE is TABLE of zx_process_results.Record_Type_Code%type
51: index by binary_integer;
52:
53: PROCEDURE bulk_insert_process_results (
54: X_CONTENT_OWNER_ID IN t_content_owner_id,

Line 78: end ZX_PROCESS_RESULTS_PKG;

74: X_Allow_Exemptions_Flag IN t_allow_exemptions,
75: X_Allow_Exceptions_Flag IN t_allow_exceptions,
76: X_Record_Type_Code IN t_record_type) ;
77:
78: end ZX_PROCESS_RESULTS_PKG;