1 PACKAGE AP_INVOICES_POST_PROCESS_PKG AUTHID CURRENT_USER AS
2 /* $Header: apinvpps.pls 120.12.12010000.3 2010/02/10 08:52:04 asansari ship $ */
3
4 procedure create_holds (X_invoice_id IN number,
5 X_event IN varchar2 default 'UPDATE',
6 X_update_base IN varchar2 default 'N',
7 X_vendor_changed_flag IN varchar2 default 'N',
8 X_calling_sequence IN varchar2);
9
10 procedure insert_children (
11 X_invoice_id IN number,
12 X_Payment_Priority IN number,
13 X_Hold_count IN OUT NOCOPY number,
14 X_Line_count IN OUT NOCOPY number,
15 X_Line_Total IN OUT NOCOPY number,
16 X_calling_sequence IN varchar2,
17 X_Sched_Hold_count IN OUT NOCOPY NUMBER); -- bug 5334577
18
19
20 procedure invoice_pre_update (
21 X_invoice_id IN number,
22 X_invoice_amount IN number,
23 X_payment_status_flag IN OUT NOCOPY varchar2,
24 X_invoice_type_lookup_code IN varchar2,
25 X_last_updated_by IN number,
26 X_accts_pay_ccid IN number,
27 X_terms_id IN number,
28 X_terms_date IN date,
29 X_discount_amount IN number,
30 X_exchange_rate_type IN varchar2,
31 X_exchange_date IN date,
32 X_exchange_rate IN number,
33 X_vendor_id IN number,
34 X_payment_method_code IN varchar2, --4393358
35 X_message1 IN OUT NOCOPY varchar2,
36 X_message2 IN OUT NOCOPY varchar2,
37 X_reset_match_status IN OUT NOCOPY varchar2,
38 X_vendor_changed_flag IN OUT NOCOPY varchar2,
39 X_recalc_pay_sched IN OUT NOCOPY varchar2,
40 X_liability_adjusted_flag IN OUT NOCOPY varchar2,
41 X_external_bank_account_id IN NUMBER, --bug 7714053
42 X_payment_currency_code IN VARCHAR2, --Bug9294551
43 X_calling_sequence IN varchar2,
44 X_revalidate_ps IN OUT NOCOPY varchar2);
45
46 procedure invoice_post_update (
47 X_invoice_id IN number,
48 X_payment_priority IN number,
49 X_recalc_pay_sched IN OUT NOCOPY varchar2,
50 X_Hold_count IN OUT NOCOPY number,
51 X_update_base IN varchar2,
52 X_vendor_changed_flag IN varchar2,
53 X_calling_sequence IN varchar2,
54 X_Sched_Hold_count IN OUT NOCOPY number); -- bug 5334577
55
56
57 --Invoice Lines: Distributions
58 procedure post_forms_commit
59 (X_invoice_id IN number,
60 X_line_number IN number,
61 X_type_1099 IN varchar2,
62 X_income_tax_region IN varchar2,
63 X_vendor_changed_flag IN OUT NOCOPY varchar2,
64 X_update_base IN OUT NOCOPY varchar2,
65 X_reset_match_status IN OUT NOCOPY varchar2,
66 X_update_occurred IN OUT NOCOPY varchar2,
67 X_approval_status_lookup_code IN OUT NOCOPY varchar2,
68 X_holds_count IN OUT NOCOPY number,
69 X_posting_flag IN OUT NOCOPY varchar2,
70 X_amount_paid IN OUT NOCOPY number,
71 X_highest_line_num IN OUT NOCOPY number,
72 X_line_total IN OUT NOCOPY number,
73 X_actual_invoice_count IN OUT NOCOPY number,
74 X_actual_invoice_total IN OUT NOCOPY number,
75 X_calling_sequence IN varchar2,
76 X_sched_holds_count IN OUT NOCOPY number); -- bug 5334577
77
78 PROCEDURE Select_Summary(
79 X_Batch_ID IN NUMBER,
80 X_Total IN OUT NOCOPY NUMBER,
81 X_Total_Rtot_DB IN OUT NOCOPY NUMBER,
82 X_Calling_Sequence IN VARCHAR2);
83
84 END AP_INVOICES_POST_PROCESS_PKG;