[Home] [Help]
PACKAGE: APPS.ZX_SIM_CONDITIONS1_PKG
Source
1 PACKAGE ZX_SIM_CONDITIONS1_PKG AS
2 /* $Header: zxrisimcondspkgs.pls 120.0 2004/06/16 17:44:25 opedrega ship $ */
3
4 PROCEDURE Insert_Row
5 (p_sim_condition_id NUMBER,
6 p_trx_id NUMBER,
7 p_trx_line_id NUMBER,
8 p_tax_line_number NUMBER,
9 p_det_factor_class_code VARCHAR2, --p_determining_factor_class_code
10 p_determining_factor_code VARCHAR2,
11 p_data_type_code VARCHAR2,
12 p_operator_code VARCHAR2,
13 p_tax_parameter_code VARCHAR2,
14 p_determining_factor_cq_code VARCHAR2,
15 p_numeric_value NUMBER,
16 p_date_value DATE,
17 p_alphanumeric_value VARCHAR2,
18 p_value_low VARCHAR2,
19 p_value_high VARCHAR2,
20 p_applicability_flag VARCHAR2,
21 p_status_determine_flag VARCHAR2,
22 p_default_status_code VARCHAR2,
23 p_rate_determine_flag VARCHAR2,
24 p_direct_rate_determine_flag VARCHAR2,
25 p_taxable_basis_determine_flag VARCHAR2,
26 p_calculate_tax_determine_flag VARCHAR2,
27 p_place_of_supply_det_flag VARCHAR2, --p_place_of_supply_determine_flag
28 p_registration_determine_flag VARCHAR2,
29 p_created_by NUMBER,
30 p_creation_date DATE,
31 p_last_updated_by NUMBER,
32 p_last_update_date DATE,
33 p_last_update_login NUMBER);
34
35 PROCEDURE Update_Row
36 (p_sim_condition_id NUMBER,
37 p_trx_id NUMBER,
38 p_trx_line_id NUMBER,
39 p_tax_line_number NUMBER,
40 p_det_factor_class_code VARCHAR2, --p_determining_factor_class_code
41 p_determining_factor_code VARCHAR2,
42 p_data_type_code VARCHAR2,
43 p_operator_code VARCHAR2,
44 p_tax_parameter_code VARCHAR2,
45 p_determining_factor_cq_code VARCHAR2,
46 p_numeric_value NUMBER,
47 p_date_value DATE,
48 p_alphanumeric_value VARCHAR2,
49 p_value_low VARCHAR2,
50 p_value_high VARCHAR2,
51 p_applicability_flag VARCHAR2,
52 p_status_determine_flag VARCHAR2,
53 p_default_status_code VARCHAR2,
54 p_rate_determine_flag VARCHAR2,
55 p_direct_rate_determine_flag VARCHAR2,
56 p_taxable_basis_determine_flag VARCHAR2,
57 p_calculate_tax_determine_flag VARCHAR2,
58 p_place_of_supply_det_flag VARCHAR2, --p_place_of_supply_determine_flag
59 p_registration_determine_flag VARCHAR2,
60 p_created_by NUMBER,
61 p_creation_date DATE,
62 p_last_updated_by NUMBER,
63 p_last_update_date DATE,
64 p_last_update_login NUMBER);
65
66 PROCEDURE Delete_Row
67 (p_sim_condition_id NUMBER,
68 p_trx_id NUMBER,
69 p_trx_line_id NUMBER,
70 p_tax_line_number NUMBER,
71 p_det_factor_class_code VARCHAR2, --p_determining_factor_class_code
72 p_determining_factor_code VARCHAR2,
73 p_data_type_code VARCHAR2,
74 p_operator_code VARCHAR2,
75 p_tax_parameter_code VARCHAR2,
76 p_determining_factor_cq_code VARCHAR2,
77 p_numeric_value NUMBER,
78 p_date_value DATE,
79 p_alphanumeric_value VARCHAR2,
80 p_value_low VARCHAR2,
81 p_value_high VARCHAR2,
82 p_applicability_flag VARCHAR2,
83 p_status_determine_flag VARCHAR2,
84 p_default_status_code VARCHAR2,
85 p_rate_determine_flag VARCHAR2,
86 p_direct_rate_determine_flag VARCHAR2,
87 p_taxable_basis_determine_flag VARCHAR2,
88 p_calculate_tax_determine_flag VARCHAR2,
89 p_place_of_supply_det_flag VARCHAR2, --p_place_of_supply_determine_flag
90 p_registration_determine_flag VARCHAR2,
91 p_created_by NUMBER,
92 p_creation_date DATE,
93 p_last_updated_by NUMBER,
94 p_last_update_date DATE,
95 p_last_update_login NUMBER);
96
97 PROCEDURE Lock_Row
98 (p_sim_condition_id NUMBER,
99 p_trx_id NUMBER,
100 p_trx_line_id NUMBER,
101 p_tax_line_number NUMBER,
102 p_det_factor_class_code VARCHAR2, --p_determining_factor_class_code
103 p_determining_factor_code VARCHAR2,
104 p_data_type_code VARCHAR2,
105 p_operator_code VARCHAR2,
106 p_tax_parameter_code VARCHAR2,
107 p_determining_factor_cq_code VARCHAR2,
108 p_numeric_value NUMBER,
109 p_date_value DATE,
110 p_alphanumeric_value VARCHAR2,
111 p_value_low VARCHAR2,
112 p_value_high VARCHAR2,
113 p_applicability_flag VARCHAR2,
114 p_status_determine_flag VARCHAR2,
115 p_default_status_code VARCHAR2,
116 p_rate_determine_flag VARCHAR2,
117 p_direct_rate_determine_flag VARCHAR2,
118 p_taxable_basis_determine_flag VARCHAR2,
119 p_calculate_tax_determine_flag VARCHAR2,
120 p_place_of_supply_det_flag VARCHAR2, --p_place_of_supply_determine_flag
121 p_registration_determine_flag VARCHAR2,
122 p_created_by NUMBER,
123 p_creation_date DATE,
124 p_last_updated_by NUMBER,
125 p_last_update_date DATE,
126 p_last_update_login NUMBER);
127
128 END ZX_SIM_CONDITIONS1_PKG;