[Home] [Help]
PACKAGE: APPS.AP_PAYMENT_SCHEDULES_PKG
Source
1 PACKAGE AP_PAYMENT_SCHEDULES_PKG AS
2 /* $Header: apipascs.pls 120.5.12010000.2 2008/11/11 13:00:34 dcshanmu ship $ */
3
4 PROCEDURE adjust_pay_schedule (X_invoice_id IN number,
5 X_invoice_amount IN number,
6 X_payment_status_flag IN OUT NOCOPY varchar2,
7 X_invoice_type_lookup_code IN varchar2,
8 X_last_updated_by IN number,
9 X_message1 IN OUT NOCOPY varchar2,
10 X_message2 IN OUT NOCOPY varchar2,
11 X_reset_match_status IN OUT NOCOPY varchar2,
12 X_liability_adjusted_flag IN OUT NOCOPY varchar2,
13 X_calling_sequence IN varchar2,
14 X_calling_mode IN varchar2,
15 x_revalidate_ps IN OUT NOCOPY varchar2);
16
17 --Bug 3484292, function added to get amount withheld per schedule
18 FUNCTION get_amt_withheld_per_sched(X_invoice_id IN NUMBER,
19 X_gross_amount IN NUMBER,
20 X_currency_code IN VARCHAR2)
21 RETURN NUMBER;
22
23 FUNCTION get_discount_available(X_invoice_id IN NUMBER,
24 X_payment_num IN NUMBER,
25 X_check_date IN DATE,
26 X_currency_code IN VARCHAR2)
27 RETURN NUMBER;
28 -- PRAGMA restrict_references(get_discount_available, WNDS, WNPS, RNPS);
29
30 FUNCTION get_discount_date(X_invoice_id IN NUMBER,
31 X_payment_num IN NUMBER,
32 X_check_date IN DATE)
33 RETURN DATE;
34 PRAGMA restrict_references(get_discount_date, WNDS, WNPS, RNPS);
35
36
37 PROCEDURE Lock_Row( X_Invoice_Id NUMBER,
38 X_Last_Updated_By NUMBER,
39 X_Last_Update_Date DATE,
40 X_Payment_Cross_Rate NUMBER,
41 X_Payment_Num NUMBER,
42 X_Amount_Remaining NUMBER,
43 X_Created_By NUMBER,
44 X_Creation_Date DATE,
45 X_Discount_Date DATE,
46 X_Due_Date DATE,
47 X_Future_Pay_Due_Date DATE,
48 X_Gross_Amount NUMBER,
49 X_Hold_Flag VARCHAR2,
50 X_Last_Update_Login NUMBER,
51 X_Payment_Method_Lookup_Code VARCHAR2 default null,
52 X_payment_method_code varchar2,
53 X_Payment_Priority NUMBER,
54 X_Payment_Status_Flag VARCHAR2,
55 X_Second_Discount_Date DATE,
56 X_Third_Discount_Date DATE,
57 X_Batch_Id NUMBER,
58 X_Discount_Amount_Available NUMBER,
59 X_Second_Disc_Amt_Available NUMBER,
60 X_Third_Disc_Amt_Available NUMBER,
61 X_Attribute1 VARCHAR2,
62 X_Attribute10 VARCHAR2,
63 X_Attribute11 VARCHAR2,
64 X_Attribute12 VARCHAR2,
65 X_Attribute13 VARCHAR2,
66 X_Attribute14 VARCHAR2,
67 X_Attribute15 VARCHAR2,
68 X_Attribute2 VARCHAR2,
69 X_Attribute3 VARCHAR2,
70 X_Attribute4 VARCHAR2,
71 X_Attribute5 VARCHAR2,
72 X_Attribute6 VARCHAR2,
73 X_Attribute7 VARCHAR2,
74 X_Attribute8 VARCHAR2,
75 X_Attribute9 VARCHAR2,
76 X_Attribute_Category VARCHAR2,
77 X_Discount_Amount_Remaining NUMBER,
78 X_Global_Attribute_Category VARCHAR2,
79 X_Global_Attribute1 VARCHAR2,
80 X_Global_Attribute2 VARCHAR2,
81 X_Global_Attribute3 VARCHAR2,
82 X_Global_Attribute4 VARCHAR2,
83 X_Global_Attribute5 VARCHAR2,
84 X_Global_Attribute6 VARCHAR2,
85 X_Global_Attribute7 VARCHAR2,
86 X_Global_Attribute8 VARCHAR2,
87 X_Global_Attribute9 VARCHAR2,
88 X_Global_Attribute10 VARCHAR2,
89 X_Global_Attribute11 VARCHAR2,
90 X_Global_Attribute12 VARCHAR2,
91 X_Global_Attribute13 VARCHAR2,
92 X_Global_Attribute14 VARCHAR2,
93 X_Global_Attribute15 VARCHAR2,
94 X_Global_Attribute16 VARCHAR2,
95 X_Global_Attribute17 VARCHAR2,
96 X_Global_Attribute18 VARCHAR2,
97 X_Global_Attribute19 VARCHAR2,
98 X_Global_Attribute20 VARCHAR2,
99 X_External_Bank_Account_Id NUMBER,
100 X_Inv_Curr_Gross_Amount NUMBER,
101 X_Org_Id NUMBER,
102 X_Calling_Sequence VARCHAR2,
103 --Third Party Payments
104 X_Remit_To_Supplier_Name VARCHAR2,
105 X_Remit_To_Supplier_Id NUMBER,
106 X_Remit_To_Supplier_Site VARCHAR2,
107 X_Remit_To_Supplier_Site_Id NUMBER,
108 X_Relationship_Id NUMBER
109 );
110
111 END AP_PAYMENT_SCHEDULES_PKG;