[Home] [Help]
PACKAGE: APPS.ZX_TDS_PROCESS_CEC_PVT
Source
1 PACKAGE ZX_TDS_PROCESS_CEC_PVT as
2 /* $Header: zxdilcecevalpvs.pls 120.7 2006/12/27 18:45:29 svaze ship $ */
3
4 TYPE action_rec_type is RECORD(
5 tax_condition_id AR_TAX_CONDITIONS_ALL.tax_condition_id%type,
6 action_type AR_TAX_CONDITION_ACTIONS_ALL.TAX_CONDITION_ACTION_TYPE%type,
7 action_code AR_TAX_CONDITION_ACTIONS_ALL.TAX_CONDITION_ACTION_CODE%type,
8 action_value AR_TAX_CONDITION_ACTIONS_ALL.TAX_CONDITION_ACTION_VALUE%type); -- Bug 5128566
9
10 TYPE action_rec_tbl_type is table of action_rec_type
11 index by BINARY_INTEGER;
12
13
14 PROCEDURE evaluate_cec (p_constraint_id IN NUMBER DEFAULT NULL,
15 p_condition_set_id IN NUMBER DEFAULT NULL,
16 p_exception_set_id IN NUMBER DEFAULT NULL,
17 p_cec_ship_to_party_site_id IN NUMBER,
18 p_cec_bill_to_party_site_id IN NUMBER,
19 p_cec_ship_to_party_id IN NUMBER,
20 p_cec_bill_to_party_id IN NUMBER,
21 p_cec_poo_location_id IN NUMBER,
22 p_cec_poa_location_id IN NUMBER,
23 p_cec_trx_id IN NUMBER,
24 p_cec_trx_line_id IN NUMBER,
25 p_cec_ledger_id IN NUMBER,
26 p_cec_internal_organization_id IN NUMBER,
27 p_cec_so_organization_id IN NUMBER,
28 p_cec_product_org_id IN NUMBER,
29 p_cec_product_id IN NUMBER,
30 p_cec_trx_type_id IN NUMBER,
31 p_cec_trx_line_date IN DATE,
32 p_cec_fob_point IN VARCHAR2,
33 p_cec_ship_to_site_use_id IN VARCHAR2,
34 p_cec_bill_to_site_use_id IN VARCHAR2,
35 p_cec_result OUT NOCOPY BOOLEAN,
36 p_action_rec_tbl OUT NOCOPY action_rec_tbl_type,
37 p_return_status OUT NOCOPY VARCHAR2,
38 p_error_buffer OUT NOCOPY VARCHAR2);
39
40
41
42 FUNCTION ship_to (p_classification IN VARCHAR2 Default NULL,
43 p_operator IN VARCHAR2 Default NULL,
44 p_value IN VARCHAR2 DEFAULT NULL)
45 return BOOLEAN;
46
47 FUNCTION bill_to (p_classification IN VARCHAR2 Default NULL,
48 p_operator IN VARCHAR2 Default NULL,
49 p_value IN VARCHAR2 DEFAULT NULL)
50 return BOOLEAN;
51
52 FUNCTION ship_from (p_classification IN VARCHAR2 Default NULL,
53 p_operator IN VARCHAR2 Default NULL,
54 p_value IN VARCHAR2 DEFAULT NULL)
55 return BOOLEAN;
56
57 FUNCTION poo
58 (p_classification IN VARCHAR2 Default NULL,
59 p_operator IN VARCHAR2 Default NULL,
60 p_value IN VARCHAR2 DEFAULT NULL)
61 return BOOLEAN;
62
63 FUNCTION poa (p_classification IN VARCHAR2 Default NULL,
64 p_operator IN VARCHAR2 Default NULL,
65 p_value IN VARCHAR2 DEFAULT NULL)
66 return BOOLEAN;
67
68 FUNCTION trx (p_classification IN VARCHAR2 Default NULL,
69 p_operator IN VARCHAR2 Default NULL,
70 p_value IN VARCHAR2 DEFAULT NULL)
71 return BOOLEAN;
72
73 FUNCTION item (p_classification IN VARCHAR2 Default NULL,
74 p_operator IN VARCHAR2 Default NULL,
75 p_value IN VARCHAR2 DEFAULT NULL)
76 return BOOLEAN;
77
78 FUNCTION tax_code (p_classification IN VARCHAR2 Default NULL,
79 p_operator IN VARCHAR2 Default NULL,
80 p_value IN VARCHAR2 DEFAULT NULL)
81 return BOOLEAN;
82
83 PROCEDURE user_message (p_msg IN VARCHAR2 DEFAULT NULL);
84
85 PROCEDURE system_message(p_msg IN VARCHAR2 DEFAULT NULL);
86
87 PROCEDURE apply_exception (p_exception IN VARCHAR2 DEFAULT NULL);
88 PROCEDURE do_not_apply_exception(p_exception IN VARCHAR2 DEFAULT NULL);
89 PROCEDURE use_tax_code (p_tax_code IN VARCHAR2 DEFAULT NULL);
90
91 PROCEDURE use_this_tax_code (p_tax_code IN VARCHAR2 DEFAULT NULL);
92 PROCEDURE default_tax_code (p_tax_code IN VARCHAR2 DEFAULT NULL); --Bug 5730672
93 PROCEDURE use_this_tax_group(p_tax_group_code IN VARCHAR2 DEFAULT NULL);
94
95 PROCEDURE do_not_use_this_tax_code (p_param IN VARCHAR2 DEFAULT NULL);
96 PROCEDURE do_not_use_this_tax_group(p_param IN VARCHAR2 DEFAULT NULL);
97
98 FUNCTION get_location_column(p_style IN VARCHAR2,
99 p_classification IN VARCHAR2) return VARCHAR2;
100
101 FUNCTION get_site_location (p_site_use_id IN NUMBER,
102 p_classification IN VARCHAR2)
103 return VARCHAR2;
104
105 FUNCTION get_hr_location (p_organization_id IN NUMBER,
106 p_location_id IN NUMBER,
107 p_classification IN VARCHAR2)
108 return VARCHAR2;
109
110 END ZX_TDS_PROCESS_CEC_PVT;