1 PACKAGE AP_AIP_TABLE_HANDLER_PKG AUTHID CURRENT_USER AS
2 /*$Header: apaipths.pls 120.5 2005/04/15 01:42:53 yicao noship $*/
3
4 PROCEDURE insert_row(
5 P_invoice_id IN NUMBER,
6 P_check_id IN NUMBER,
7 P_payment_num IN NUMBER,
8 P_invoice_payment_id IN NUMBER,
9 P_old_invoice_payment_id IN NUMBER,
10 P_period_name IN VARCHAR2,
11 P_accounting_date IN DATE,
12 P_amount IN NUMBER,
13 P_discount_taken IN NUMBER,
14 P_discount_lost IN NUMBER,
15 P_invoice_base_amount IN NUMBER,
16 P_payment_base_amount IN NUMBER,
17 P_accrual_posted_flag IN VARCHAR2,
18 P_cash_posted_flag IN VARCHAR2,
19 P_posted_flag IN VARCHAR2,
20 P_set_of_books_id IN NUMBER,
21 P_last_updated_by IN NUMBER,
22 P_last_update_login IN NUMBER,
23 P_last_update_date IN DATE,
24 P_currency_code IN VARCHAR2,
25 P_base_currency_code IN VARCHAR2,
26 P_exchange_rate IN NUMBER,
27 P_exchange_rate_type IN VARCHAR2,
28 P_exchange_date IN DATE,
29 P_bank_account_id IN NUMBER,
30 P_bank_account_num IN VARCHAR2,
31 P_bank_account_type IN VARCHAR2,
32 P_bank_num IN VARCHAR2,
33 P_future_pay_posted_flag IN VARCHAR2,
34 P_exclusive_payment_flag IN VARCHAR2,
35 P_accts_pay_ccid IN NUMBER,
36 P_gain_ccid IN NUMBER,
37 P_loss_ccid IN NUMBER,
38 P_future_pay_ccid IN NUMBER,
39 P_asset_ccid IN NUMBER,
40 P_payment_dists_flag IN VARCHAR2,
41 P_payment_mode IN VARCHAR2,
42 P_replace_flag IN VARCHAR2,
43 P_attribute1 IN VARCHAR2,
44 P_attribute2 IN VARCHAR2,
45 P_attribute3 IN VARCHAR2,
46 P_attribute4 IN VARCHAR2,
47 P_attribute5 IN VARCHAR2,
48 P_attribute6 IN VARCHAR2,
49 P_attribute7 IN VARCHAR2,
50 P_attribute8 IN VARCHAR2,
51 P_attribute9 IN VARCHAR2,
52 P_attribute10 IN VARCHAR2,
53 P_attribute11 IN VARCHAR2,
54 P_attribute12 IN VARCHAR2,
55 P_attribute13 IN VARCHAR2,
56 P_attribute14 IN VARCHAR2,
57 P_attribute15 IN VARCHAR2,
58 P_attribute_category IN VARCHAR2,
59 P_global_attribute1 IN VARCHAR2 Default NULL,
60 P_global_attribute2 IN VARCHAR2 Default NULL,
61 P_global_attribute3 IN VARCHAR2 Default NULL,
62 P_global_attribute4 IN VARCHAR2 Default NULL,
63 P_global_attribute5 IN VARCHAR2 Default NULL,
64 P_global_attribute6 IN VARCHAR2 Default NULL,
65 P_global_attribute7 IN VARCHAR2 Default NULL,
66 P_global_attribute8 IN VARCHAR2 Default NULL,
67 P_global_attribute9 IN VARCHAR2 Default NULL,
68 P_global_attribute10 IN VARCHAR2 Default NULL,
69 P_global_attribute11 IN VARCHAR2 Default NULL,
70 P_global_attribute12 IN VARCHAR2 Default NULL,
71 P_global_attribute13 IN VARCHAR2 Default NULL,
72 P_global_attribute14 IN VARCHAR2 Default NULL,
73 P_global_attribute15 IN VARCHAR2 Default NULL,
74 P_global_attribute16 IN VARCHAR2 Default NULL,
75 P_global_attribute17 IN VARCHAR2 Default NULL,
76 P_global_attribute18 IN VARCHAR2 Default NULL,
77 P_global_attribute19 IN VARCHAR2 Default NULL,
78 P_global_attribute20 IN VARCHAR2 Default NULL,
79 P_global_attribute_category IN VARCHAR2 Default NULL,
80 P_calling_sequence IN VARCHAR2,
81 P_accounting_event_id IN NUMBER Default NULL,
82 P_org_id IN NUMBER Default NULL);
83
84
85 PROCEDURE Update_Amounts(
86 P_invoice_payment_id IN NUMBER,
87 P_amount IN NUMBER,
88 P_invoice_base_amount IN NUMBER,
89 P_payment_base_amount IN NUMBER,
90 P_calling_sequence IN VARCHAR2);
91
92
93 END AP_AIP_TABLE_HANDLER_PKG;