DBA Data[Home] [Help]

PACKAGE: APPS.AP_ISP_UTILITIES_PKG

Source


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;