1 PACKAGE AP_AUTO_PAYMENT_PKG AS
2 /* $Header: apautops.pls 120.3.12010000.2 2009/02/20 13:42:31 dawasthi ship $ */
3
4 --Bugfix 2124107 - Add one more parameter p_last_update_login
5
6 PROCEDURE Replace_Check
7 (P_Old_Check_Id IN NUMBER
8 ,P_Replace_Check_Id IN OUT NOCOPY NUMBER
9 ,P_Replace_Check_Date IN DATE
10 ,P_Replace_Period_Name IN VARCHAR2
11 ,P_Replace_Check_Num IN NUMBER
12 ,P_Replace_Voucher_Num IN NUMBER
13 ,P_Orig_Amount IN NUMBER
14 ,P_Orig_payment_Date IN DATE
15 ,P_Last_Updated_By IN NUMBER
16 ,P_Future_Pay_Ccid IN NUMBER
17 ,P_Quickcheck_Id IN VARCHAR2
18 ,P_Calling_Sequence IN VARCHAR2
19 ,P_Last_Update_Login IN NUMBER DEFAULT NULL
20 ,P_Remit_to_supplier_name IN VARCHAR2 DEFAULT NULL --Bug 8218410
21 ,P_Remit_to_supplier_id IN Number DEFAULT NULL
22 ,P_Remit_To_Supplier_Site IN VARCHAR2 DEFAULT NULL
23 ,P_Remit_To_Supplier_Site_Id IN NUMBER DEFAULT NULL
24 ,P_Relationship_Id IN NUMBER DEFAULT NULL --Bug 8218410 ends
25 );
26
27 --Bug 5061811 - remove obsoleted procedure INSERT_TEMP_RECORDS
28 --PROCEDURE Insert_Temp_Records
29 -- (P_Check_Id IN NUMBER
30 -- ,P_Calling_Sequence IN VARCHAR2
31 -- );
32
33 FUNCTION Selection_Criteria_Exists(P_Check_Id IN NUMBER) RETURN VARCHAR2;
34 PRAGMA RESTRICT_REFERENCES(Selection_Criteria_Exists, WNDS, WNPS, RNPS);
35
36 FUNCTION Get_Check_Stock_In_Use_By(p_check_stock_id IN NUMBER) RETURN VARCHAR2;
37 PRAGMA RESTRICT_REFERENCES(Get_Check_Stock_In_Use_By, WNDS, WNPS, RNPS);
38
39 FUNCTION OK_To_Call_Withholding(P_Invoice_Id IN NUMBER) RETURN BOOLEAN;
40 PRAGMA RESTRICT_REFERENCES(OK_To_Call_Withholding, WNDS, WNPS, RNPS);
41
42 END AP_AUTO_PAYMENT_PKG;
[Home] [Help]