1 PACKAGE AP_ISP_UTILITIES_PKG AS
2 /* $Header: apisputs.pls 120.15 2006/12/13 02:17:52 dgulraja noship $ */
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
128
129 END AP_ISP_UTILITIES_PKG;