1 PACKAGE AP_INVOICES_POST_PROCESS_PKG AS
2 /* $Header: apinvpps.pls 120.12.12010000.2 2009/01/28 05:28:39 dcshanmu 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_calling_sequence IN varchar2,
43 X_revalidate_ps IN OUT NOCOPY varchar2);
44
45 procedure invoice_post_update (
46 X_invoice_id IN number,
47 X_payment_priority IN number,
48 X_recalc_pay_sched IN OUT NOCOPY varchar2,
49 X_Hold_count IN OUT NOCOPY number,
50 X_update_base IN varchar2,
51 X_vendor_changed_flag IN varchar2,
52 X_calling_sequence IN varchar2,
53 X_Sched_Hold_count IN OUT NOCOPY number); -- bug 5334577
54
55
56 --Invoice Lines: Distributions
57 procedure post_forms_commit
58 (X_invoice_id IN number,
59 X_line_number IN number,
60 X_type_1099 IN varchar2,
61 X_income_tax_region IN varchar2,
62 X_vendor_changed_flag IN OUT NOCOPY varchar2,
63 X_update_base IN OUT NOCOPY varchar2,
64 X_reset_match_status IN OUT NOCOPY varchar2,
65 X_update_occurred IN OUT NOCOPY varchar2,
66 X_approval_status_lookup_code IN OUT NOCOPY varchar2,
67 X_holds_count IN OUT NOCOPY number,
68 X_posting_flag IN OUT NOCOPY varchar2,
69 X_amount_paid IN OUT NOCOPY number,
70 X_highest_line_num IN OUT NOCOPY number,
71 X_line_total IN OUT NOCOPY number,
72 X_actual_invoice_count IN OUT NOCOPY number,
73 X_actual_invoice_total IN OUT NOCOPY number,
74 X_calling_sequence IN varchar2,
75 X_sched_holds_count IN OUT NOCOPY number); -- bug 5334577
76
77 PROCEDURE Select_Summary(
78 X_Batch_ID IN NUMBER,
79 X_Total IN OUT NOCOPY NUMBER,
80 X_Total_Rtot_DB IN OUT NOCOPY NUMBER,
81 X_Calling_Sequence IN VARCHAR2);
82
83 END AP_INVOICES_POST_PROCESS_PKG;