1 PACKAGE AP_ISP_UTILITIES_PKG AUTHID CURRENT_USER AS
2 /* $Header: apisputs.pls 120.18 2011/05/03 14:51:46 bgoyal ship $ */
3
4 PROCEDURE get_doc_sequence(
5 p_invoice_id IN NUMBER,
6 p_sequence_numbering IN VARCHAR2,
7 p_doc_category_code OUT NOCOPY VARCHAR,
8 p_db_sequence_value OUT NOCOPY NUMBER,
9 p_db_seq_name OUT NOCOPY VARCHAR2,
10 p_db_sequence_id OUT NOCOPY NUMBER,
11 p_calling_sequence IN VARCHAR2);
12
13 PROCEDURE get_payment_terms (
14 p_invoice_id IN NUMBER,
15 p_terms_id OUT NOCOPY NUMBER,
16 p_terms_date OUT NOCOPY DATE,
17 p_calling_sequence IN VARCHAR2);
18
19 PROCEDURE Cancel_Single_Invoice(
20 P_invoice_id IN NUMBER,
21 P_last_updated_by IN NUMBER,
22 P_last_update_login IN NUMBER,
23 P_accounting_date IN DATE,
24 P_message_name OUT NOCOPY VARCHAR2,
25 P_Token OUT NOCOPY VARCHAR2,
26 P_calling_sequence IN VARCHAR2);
27
28 /* Bug 5470344 XBuild11 Code cleanup
29 This code is not being used
30 PROCEDURE Discard_Inv_Line(
31 p_invoice_id IN ap_invoice_lines.invoice_id%TYPE,
32 p_line_number IN ap_invoice_lines.line_number%TYPE,
33 p_calling_mode IN VARCHAR2,
34 p_inv_cancellable IN VARCHAR2 DEFAULT NULL,
35 P_last_updated_by IN NUMBER,
36 P_last_update_login IN NUMBER,
37 P_error_code OUT NOCOPY VARCHAR2,
38 P_token OUT NOCOPY VARCHAR2,
39 P_calling_sequence IN VARCHAR2);
40 */
41 /* Bug 5407726 ISP Code cleanup XBuild9
42 This code is not being used
43 PROCEDURE invoke_ap_workflow(
44 P_item_key IN VARCHAR2,
45 p_invoice_id IN ap_invoices.invoice_id%TYPE,
46 p_org_id IN ap_invoices.org_id%TYPE,
47 P_calling_sequence IN VARCHAR2);
48 */
49
50 PROCEDURE override_tax(
51 P_Invoice_id IN NUMBER,
52 P_Calling_Mode IN VARCHAR2,
53 P_Override_Status IN VARCHAR2,
54 P_Event_Id IN NUMBER,
55 P_All_Error_Messages IN VARCHAR2,
56 P_Error_Code OUT NOCOPY VARCHAR2,
57 P_Calling_Sequence IN VARCHAR2);
58
59 PROCEDURE update_invoice_header(
60 p_invoice_id IN NUMBER,
61 p_sequence_numbering IN VARCHAR2,
62 p_calling_sequence IN VARCHAR2);
63
64 -- Bug 5605359
65 PROCEDURE update_invoice_header2(
66 p_invoice_id IN NUMBER,
67 p_calling_sequence IN VARCHAR2);
68
69 Procedure Match_Invoice_Lines(
70 P_Invoice_Id IN NUMBER,
71 P_Calling_Sequence IN VARCHAR2);
72
73
74 -- 5077334, added party_id
75 Procedure get_sec_attr_value (P_user_id IN NUMBER,
76 P_attr_code IN VARCHAR2,
77 P_attr_value OUT NOCOPY NUMBER,
78 P_attr_value1 OUT NOCOPY VARCHAR2,
79 P_party_id OUT NOCOPY NUMBER,
80 P_Calling_Sequence IN VARCHAR2);
81
82
83 --added for 5126689
84 -- Used by Negotiation
85 PROCEDURE Release_Hold(p_hold_id IN NUMBER);
86
87 -- Used by Negotiation
88 PROCEDURE update_po_matching_columns(p_line_location_id in number,
89 p_po_distribution_id in number,
90 p_quantity_change in number,
91 p_amount_change in number,
92 p_ap_uom in varchar2,
93 p_invoice_id in number,
94 p_line_number in number,
95 p_error_code out nocopy varchar2,
96 p_return_status out nocopy varchar2,
97 p_calling_sequence in varchar2);
98
99 /* Bug 5407726 ISP Code cleanup XBuild9
100 This code is not being used
101 PROCEDURE discard_and_rematch (p_invoice_id in number,
102 p_line_number in number,
103 p_error_code out nocopy varchar2,
104 p_token out nocopy varchar2);
105
106 */
107 --Bug 5500186
108 PROCEDURE populate_requester(p_first_name IN VARCHAR2,
109 p_last_name IN VARCHAR2,
110 p_email_address IN VARCHAR2,
111 p_requester_id IN OUT NOCOPY NUMBER);
112 -- 5659917
113 FUNCTION get_po_number_switcher(p_invoice_id IN NUMBER)
114 RETURN VARCHAR2;
115
116 FUNCTION get_po_number(p_invoice_id IN NUMBER)
117 RETURN VARCHAR2;
118
119 --Bug 5704381
120 FUNCTION get_po_header_id(p_invoice_id IN NUMBER)
121 RETURN NUMBER;
122
123 FUNCTION get_po_release(p_invoice_id IN NUMBER,
124 p_ret_value IN VARCHAR2)
125 RETURN NUMBER;
126
127 --Bug 8865603
128 PROCEDURE stop_approval(p_invoice_id NUMBER);
129
130 FUNCTION unsubmit_switcher(
131 p_wfapproval_status VARCHAR2,
132 p_approval_ready_flag VARCHAR2,
133 p_cancel_date DATE,
134 p_invoice_type VARCHAR2) RETURN VARCHAR2;
135
136 --Bug 8865603
137
138 -- Wrapper API created to invoke pa_acc_gen_wf_pkg.ap_inv_generate_account
139 -- from java layer. pa_acc_gen_wf_pkg.ap_inv_generate_account can not be
140 -- invoked directly as the PAI returns boolean which is not supported
141 -- from java.
142
143 FUNCTION ap_inv_generate_account_wrap
144 (
145 p_project_id IN pa_projects_all.project_id%TYPE,
146 p_task_id IN pa_tasks.task_id%TYPE,
147 p_expenditure_type IN pa_expenditure_types.expenditure_type%TYPE,
148 p_vendor_id IN po_vendors.vendor_id%type,
149 p_expenditure_organization_id IN hr_organization_units.organization_id%TYPE,
150 p_expenditure_item_date IN pa_expenditure_items_all.expenditure_item_date%TYPE,
151 p_billable_flag IN pa_tasks.billable_flag%TYPE,
152 p_chart_of_accounts_id IN NUMBER,
153 p_attribute_category IN ap_invoices_all.attribute_category%TYPE,
154 p_attribute1 IN ap_invoices_all.attribute1%TYPE,
155 p_attribute2 IN ap_invoices_all.attribute2%TYPE,
156 p_attribute3 IN ap_invoices_all.attribute3%TYPE,
157 p_attribute4 IN ap_invoices_all.attribute4%TYPE,
158 p_attribute5 IN ap_invoices_all.attribute5%TYPE,
159 p_attribute6 IN ap_invoices_all.attribute6%TYPE,
160 p_attribute7 IN ap_invoices_all.attribute7%TYPE,
161 p_attribute8 IN ap_invoices_all.attribute8%TYPE,
162 p_attribute9 IN ap_invoices_all.attribute9%TYPE,
163 p_attribute10 IN ap_invoices_all.attribute10%TYPE,
164 p_attribute11 IN ap_invoices_all.attribute11%TYPE,
165 p_attribute12 IN ap_invoices_all.attribute12%TYPE,
166 p_attribute13 IN ap_invoices_all.attribute13%TYPE,
167 p_attribute14 IN ap_invoices_all.attribute14%TYPE,
168 p_attribute15 IN ap_invoices_all.attribute15%TYPE,
169 p_dist_attribute_category IN ap_invoice_distributions_all.attribute_category%TYPE,
170 p_dist_attribute1 IN ap_invoice_distributions_all.attribute1%TYPE,
171 p_dist_attribute2 IN ap_invoice_distributions_all.attribute2%TYPE,
172 p_dist_attribute3 IN ap_invoice_distributions_all.attribute3%TYPE,
173 p_dist_attribute4 IN ap_invoice_distributions_all.attribute4%TYPE,
174 p_dist_attribute5 IN ap_invoice_distributions_all.attribute5%TYPE,
175 p_dist_attribute6 IN ap_invoice_distributions_all.attribute6%TYPE,
176 p_dist_attribute7 IN ap_invoice_distributions_all.attribute7%TYPE,
177 p_dist_attribute8 IN ap_invoice_distributions_all.attribute8%TYPE,
178 p_dist_attribute9 IN ap_invoice_distributions_all.attribute9%TYPE,
179 p_dist_attribute10 IN ap_invoice_distributions_all.attribute10%TYPE,
180 p_dist_attribute11 IN ap_invoice_distributions_all.attribute11%TYPE,
181 p_dist_attribute12 IN ap_invoice_distributions_all.attribute12%TYPE,
182 p_dist_attribute13 IN ap_invoice_distributions_all.attribute13%TYPE,
183 p_dist_attribute14 IN ap_invoice_distributions_all.attribute14%TYPE,
184 p_dist_attribute15 IN ap_invoice_distributions_all.attribute15%TYPE,
185 p_input_ccid IN gl_code_combinations.code_combination_id%TYPE default null,
186 x_return_ccid OUT NOCOPY gl_code_combinations.code_combination_id%TYPE,
187 x_concat_segs IN OUT NOCOPY VARCHAR2, -- Bug 5935019
188 x_concat_ids IN OUT NOCOPY VARCHAR2, -- Bug 5935019
189 x_concat_descrs IN OUT NOCOPY VARCHAR2, -- Bug 5935019
190 x_error_message OUT NOCOPY VARCHAR2,
191 X_award_set_id IN NUMBER DEFAULT NULL,
192 p_accounting_date IN ap_invoice_distributions_all.accounting_date%TYPE default NULL,
193 p_award_id IN NUMBER DEFAULT NULL,
194 p_expenditure_item_id IN NUMBER DEFAULT NULL )
195
196 RETURN NUMBER;
197
198 FUNCTION validatevendor(p_vendor_id IN NUMBER)
199 RETURN VARCHAR2;
200
201 END AP_ISP_UTILITIES_PKG;