1 PACKAGE PO_TAX_INTERFACE_PVT AS
2 /* $Header: PO_TAX_INTERFACE_PVT.pls 120.13 2006/11/29 11:59:52 nipagarw noship $ */
3
4 TYPE po_tax_errors_type IS RECORD(
5 error_level PO_TBL_VARCHAR20,
6 document_type_code PO_TBL_VARCHAR25,
7 document_id PO_TBL_NUMBER,
8 document_num PO_TBL_NUMBER,
9 line_id PO_TBL_NUMBER,
10 line_num PO_TBL_NUMBER,
11 line_location_id PO_TBL_NUMBER,
12 shipment_num PO_TBL_NUMBER,
13 distribution_id PO_TBL_NUMBER,
14 distribution_num PO_TBL_NUMBER,
15 message_text PO_TBL_VARCHAR2000);
16
17 G_TAX_ERRORS_TBL po_tax_errors_type;
18
19 PROCEDURE calculate_tax(p_po_header_id_tbl IN PO_TBL_NUMBER,
20 p_po_release_id_tbl IN PO_TBL_NUMBER,
21 p_calling_program IN VARCHAR2,
22 x_return_status OUT NOCOPY VARCHAR2
23 );
24
25 PROCEDURE calculate_tax(p_po_header_id IN NUMBER,
26 p_po_release_id IN NUMBER,
27 p_calling_program IN VARCHAR2,
28 x_return_status OUT NOCOPY VARCHAR2
29 );
30
31 PROCEDURE calculate_tax_requisition(p_requisition_header_id IN NUMBER,
32 p_calling_program IN VARCHAR2,
33 x_return_status OUT NOCOPY VARCHAR2);
34
35 PROCEDURE determine_recovery_po(p_po_header_id IN NUMBER,
36 x_return_status OUT NOCOPY VARCHAR2);
37
38 PROCEDURE determine_recovery_rel(p_po_release_id IN NUMBER,
39 x_return_status OUT NOCOPY VARCHAR2);
40
41 PROCEDURE determine_recovery_req(p_requisition_header_id IN NUMBER,
42 x_return_status OUT NOCOPY VARCHAR2);
43
44 FUNCTION calculate_tax_yes_no
45 (p_po_header_id IN NUMBER,
46 p_po_release_id IN NUMBER,
47 p_req_header_id IN NUMBER)
48 RETURN VARCHAR2;
49
50 PROCEDURE SHIPMENT_DIST_DELETED_FROM_OA
51 (
52 P_PO_HEADER_ID IN NUMBER,
53 P_DEL_SHIPMENT_TABLE IN PO_TBL_NUMBER,
54 P_DEL_DIST_SHIPMENT_TABLE IN PO_TBL_NUMBER
55 );
56
57 PROCEDURE initialize_global_error_record;
58
59 PROCEDURE append_error(p_error_level IN VARCHAR2,
60 p_document_type_code IN VARCHAR2,
61 p_document_id IN NUMBER,
62 p_document_num IN NUMBER,
63 p_line_id IN NUMBER,
64 p_line_num IN NUMBER,
65 p_line_location_id IN NUMBER,
66 p_shipment_num IN NUMBER,
67 p_distribution_id IN NUMBER,
68 p_distribution_num IN NUMBER,
69 p_message_text IN VARCHAR2);
70
71 FUNCTION any_tax_attributes_updated(
72 p_doc_type IN VARCHAR2,
73 p_doc_level IN VARCHAR2,
74 p_doc_level_id IN NUMBER,
75 p_trx_currency IN VARCHAR2 DEFAULT NULL,
76 p_rate_type IN VARCHAR2 DEFAULT NULL,
77 p_rate_date IN DATE DEFAULT NULL,
78 p_rate IN NUMBER DEFAULT NULL,
79 p_fob IN VARCHAR2 DEFAULT NULL,
80 p_vendor_id IN NUMBER DEFAULT NULL,
81 p_vendor_site_id IN NUMBER DEFAULT NULL,
82 p_bill_to_loc IN NUMBER DEFAULT NULL, --<ECO 5524555>
83 p_uom IN VARCHAR2 DEFAULT NULL,
84 p_price IN NUMBER DEFAULT NULL,
85 p_qty IN NUMBER DEFAULT NULL,
86 p_price_override IN NUMBER DEFAULT NULL, --<Bug 5647417>
87 p_amt IN NUMBER DEFAULT NULL,
88 p_ship_to_org IN NUMBER DEFAULT NULL,
89 p_ship_to_loc IN NUMBER DEFAULT NULL,
90 p_need_by_date IN DATE DEFAULT NULL,
91 p_src_doc IN NUMBER DEFAULT NULL,
92 p_src_ship IN NUMBER DEFAULT NULL,
93 p_ccid IN NUMBER DEFAULT NULL,
94 p_tax_rec_rate IN NUMBER DEFAULT NULL,
95 p_project IN NUMBER DEFAULT NULL,
96 p_task IN NUMBER DEFAULT NULL,
97 p_award IN NUMBER DEFAULT NULL,
98 p_exp_type IN VARCHAR2 DEFAULT NULL,
99 p_exp_org IN NUMBER DEFAULT NULL,
100 p_exp_date IN DATE DEFAULT NULL,
101 p_dist_quantity_ordered IN NUMBER DEFAULT NULL,
102 p_dist_amount_ordered IN NUMBER DEFAULT NULL
103 ) RETURN BOOLEAN;
104
105 -- Introduced with Bug 4695557.
106 PROCEDURE cancel_tax_lines(p_document_type IN VARCHAR2,
107 p_document_id IN NUMBER,
108 p_line_id IN NUMBER,
109 p_shipment_id IN NUMBER,
110 x_return_status OUT NOCOPY VARCHAR2,
111 x_msg_count OUT NOCOPY NUMBER,
112 x_msg_data OUT NOCOPY VARCHAR2);
113
114 PROCEDURE global_document_update(p_api_version IN NUMBER,
115 p_init_msg_list IN VARCHAR2,
116 p_commit IN VARCHAR2,
117 p_validation_level IN NUMBER,
118 x_return_status OUT NOCOPY VARCHAR2,
119 x_msg_count OUT NOCOPY NUMBER,
120 x_msg_data OUT NOCOPY VARCHAR2,
121 p_org_id IN NUMBER,
122 p_document_type IN VARCHAR2,
123 p_document_id IN NUMBER,
124 p_event_type_code IN VARCHAR2);
125
126 PROCEDURE unapprove_doc_header(p_document_id IN NUMBER,
127 p_document_type IN VARCHAR2,
128 x_return_status OUT NOCOPY VARCHAR2);
129
130 PROCEDURE unapprove_schedules(p_line_location_id_tbl IN PO_TBL_NUMBER,
131 x_return_status OUT NOCOPY VARCHAR2);
132
133 END PO_TAX_INTERFACE_PVT;