1 PACKAGE AP_INVOICES_UTILITY_PKG AS
2 /* $Header: apinvuts.pls 120.17.12010000.2 2008/11/11 12:58:16 dcshanmu ship $ */
3
4 PROCEDURE CHECK_UNIQUE (
5 X_ROWID VARCHAR2,
6 X_INVOICE_NUM VARCHAR2,
7 X_VENDOR_ID NUMBER,
8 X_ORG_ID NUMBER, -- Bug 5407785
9 X_calling_sequence VARCHAR2);
10
11 PROCEDURE CHECK_UNIQUE_VOUCHER_NUM(
12 X_ROWID VARCHAR2,
13 X_VOUCHER_NUM VARCHAR2,
14 X_calling_sequence VARCHAR2);
15
16 FUNCTION get_prepay_number(l_prepay_dist_id IN NUMBER) RETURN VARCHAR2;
17
18 FUNCTION get_prepay_dist_number(l_prepay_dist_id IN NUMBER) RETURN VARCHAR2;
19
20 FUNCTION get_distribution_total(l_invoice_id IN NUMBER) RETURN NUMBER;
21
22 FUNCTION get_posting_status(l_invoice_id IN NUMBER) RETURN VARCHAR2;
23
24 FUNCTION get_approval_status(
25 l_invoice_id IN NUMBER,
26 l_invoice_amount IN NUMBER,
27 l_payment_status_flag IN VARCHAR2,
28 l_invoice_type_lookup_code IN VARCHAR2) return VARCHAR2;
29
30 FUNCTION get_po_number(l_invoice_id IN NUMBER) RETURN VARCHAR2;
31
32 FUNCTION get_release_number(l_invoice_id IN NUMBER) RETURN VARCHAR2;
33
34 FUNCTION get_receipt_number(l_invoice_id IN NUMBER) RETURN VARCHAR2;
35
36 FUNCTION get_po_number_list(l_invoice_id IN NUMBER) RETURN VARCHAR2;
37
38 FUNCTION get_amount_withheld(l_invoice_id IN NUMBER) RETURN NUMBER;
39
40 FUNCTION get_prepaid_amount(l_invoice_id IN NUMBER) RETURN NUMBER;
41
42 FUNCTION get_notes_count(l_invoice_id IN NUMBER) RETURN NUMBER;
43
44 FUNCTION get_holds_count(l_invoice_id IN NUMBER) RETURN NUMBER;
45
46 FUNCTION get_sched_holds_count(l_invoice_id IN NUMBER) RETURN NUMBER; -- Bug 5334577
47
48 FUNCTION get_amount_hold_flag(l_invoice_id IN NUMBER) RETURN VARCHAR2;
49
50 FUNCTION get_vendor_hold_flag(l_invoice_id IN NUMBER) RETURN VARCHAR2;
51
52 FUNCTION get_total_prepays(
53 l_vendor_id IN NUMBER,
54 l_org_id IN NUMBER) RETURN NUMBER;
55
56 FUNCTION get_available_prepays(
57 l_vendor_id IN NUMBER,
58 l_org_id IN NUMBER) RETURN NUMBER;
59
60 FUNCTION get_encumbered_flag(l_invoice_id IN NUMBER) RETURN VARCHAR2;
61
62 FUNCTION get_similar_drcr_memo(
63 P_vendor_id IN number,
64 P_vendor_site_id IN number,
65 P_invoice_amount IN number,
66 P_invoice_type_lookup_code IN varchar2,
67 P_invoice_currency_code IN varchar2,
68 P_calling_sequence IN varchar2) RETURN varchar2;
69
70 FUNCTION eft_bank_details_exist (
71 P_vendor_site_id IN number,
72 P_calling_sequence IN varchar2) RETURN boolean;
73
74 FUNCTION eft_bank_curr_details_exist (
75 P_vendor_site_id IN number,
76 P_currency_code IN varchar2,
77 P_calling_sequence IN varchar2) RETURN boolean;
78
79 FUNCTION selected_for_payment_flag (P_invoice_id IN number) RETURN varchar2;
80
81 FUNCTION get_unposted_void_payment (P_invoice_id IN number) RETURN varchar2;
82
83 FUNCTION get_discount_pay_dists_flag (P_invoice_id IN number) RETURN varchar2;
84
85 FUNCTION get_prepayments_applied_flag (P_invoice_id IN number) RETURN varchar2;
86
87 FUNCTION get_payments_exist_flag (P_invoice_id IN number) RETURN varchar2;
88
89 FUNCTION get_prepay_amount_applied (P_invoice_id IN number) RETURN number;
90
91 FUNCTION get_prepay_amount_remaining (P_invoice_id IN number) RETURN number;
92
93 FUNCTION get_prepay_amt_rem_set (P_invoice_id IN number) RETURN number; -- BUG 4413272
94
95 FUNCTION get_prepayment_type (P_invoice_id IN number) RETURN VARCHAR2;
96
97 FUNCTION get_packet_id (P_invoice_id IN number) RETURN number;
98
99 FUNCTION get_payment_status( p_invoice_id IN NUMBER ) RETURN VARCHAR2;
100
101 FUNCTION is_inv_pmt_prepay_posted(
102 P_invoice_id IN NUMBER,
103 P_org_id IN NUMBER,
104 P_discount_taken IN NUMBER,
105 P_prepaid_amount IN NUMBER,
106 P_automatic_offsets_flag IN VARCHAR2,
107 P_discount_dist_method IN VARCHAR2,
108 P_payment_status_flag IN VARCHAR2) RETURN boolean;
109
110 FUNCTION get_pp_amt_applied_on_date (
111 P_invoice_id IN NUMBER,
112 P_prepay_id IN NUMBER,
113 P_application_date IN DATE) RETURN number;
114
115 FUNCTION get_dist_count (p_invoice_id IN NUMBER) RETURN NUMBER;
116
117 FUNCTION get_amt_applied_per_prepay (
118 P_invoice_id IN NUMBER,
119 P_prepay_id IN NUMBER) RETURN number;
120
121 FUNCTION get_explines_count (p_expense_report_id IN NUMBER) RETURN NUMBER;
122
123 FUNCTION get_expense_type (
124 p_source in varchar2,
125 p_invoice_id in number) RETURN varchar2;
126
127 FUNCTION GET_MAX_INV_LINE_NUM(P_invoice_id IN NUMBER) RETURN NUMBER;
128
129 FUNCTION GET_LINE_TOTAL(P_invoice_id IN NUMBER) RETURN NUMBER;
130
131 -- table to hold the lines that can be adjusted for rounding -- bug 6892789
132 TYPE inv_line_num_tab_type IS
133 TABLE OF AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE
134 INDEX BY BINARY_INTEGER;
135
136 -- function modified to get the lines that can be adjusted -- bug 6892789
137 FUNCTION round_base_amts(
138 X_Invoice_Id IN NUMBER,
139 X_Reporting_Ledger_Id IN NUMBER DEFAULT NULL,
140 X_Rounded_Line_Numbers OUT NOCOPY inv_line_num_tab_type,
141 X_Rounded_Amt OUT NOCOPY NUMBER,
142 X_Debug_Info OUT NOCOPY VARCHAR2,
143 X_Debug_Context OUT NOCOPY VARCHAR2,
144 X_Calling_sequence IN VARCHAR2) RETURN BOOLEAN;
145
146 FUNCTION Is_Inv_Credit_Referenced( P_invoice_id IN NUMBER ) RETURN BOOLEAN;
147
148 FUNCTION Inv_With_PQ_Corrections(
149 P_Invoice_Id IN NUMBER,
150 P_Calling_sequence IN VARCHAR2) RETURN BOOLEAN;
151
152 FUNCTION Inv_With_Prepayments(
153 P_Invoice_Id IN NUMBER,
154 P_Calling_sequence IN VARCHAR2) RETURN BOOLEAN;
155
156 FUNCTION Invoice_Includes_Awt(
157 P_Invoice_Id IN NUMBER,
158 P_Calling_sequence IN VARCHAR2) RETURN BOOLEAN;
159
160 FUNCTION Inv_Matched_Finally_Closed_Po(
161 P_Invoice_Id IN NUMBER,
162 P_Calling_sequence IN VARCHAR2) RETURN BOOLEAN;
163
164 --Invoice Lines: Distributions
165 FUNCTION get_max_dist_line_num (P_invoice_id IN number,
166 P_invoice_line_number IN number) RETURN NUMBER;
167
168 --ETAX: Invwkb
169 FUNCTION get_invoice_num (P_Invoice_Id IN Number) RETURN VARCHAR2;
170
171 FUNCTION Get_Retained_Total
172 (P_Invoice_Id IN NUMBER, P_Org_Id IN NUMBER) RETURN NUMBER;
173
174 FUNCTION Get_Item_Total
175 (P_Invoice_Id IN NUMBER, P_Org_Id IN NUMBER) RETURN NUMBER;
176
177 FUNCTION Get_Freight_Total
178 (P_Invoice_Id IN NUMBER, P_Org_Id IN NUMBER) RETURN NUMBER;
179
180 FUNCTION Get_Misc_Total
181 (P_Invoice_Id IN NUMBER, P_Org_Id IN NUMBER) RETURN NUMBER;
182
183 FUNCTION Get_Prepay_App_Total
184 (P_Invoice_Id IN NUMBER, P_Org_Id IN NUMBER) RETURN NUMBER;
185
186 FUNCTION get_invoice_status(
187 p_invoice_id IN NUMBER,
188 p_invoice_amount IN NUMBER,
189 p_payment_status_flag IN VARCHAR2,
190 p_invoice_type_lookup_code IN VARCHAR2) return VARCHAR2;
191
192 PROCEDURE get_bank_details(
193 p_invoice_currency_code IN VARCHAR2,
194 p_party_id IN NUMBER,
195 p_party_site_id IN NUMBER,
196 p_supplier_site_id IN NUMBER,
197 p_org_id IN NUMBER,
198 x_bank_account_name OUT NOCOPY VARCHAR2,
199 x_bank_account_id OUT NOCOPY VARCHAR2,
200 x_bank_account_number OUT NOCOPY VARCHAR2);
201
202 END AP_INVOICES_UTILITY_PKG;