1 package AP_WITHHOLDING_PKG AUTHID CURRENT_USER as
2 /* $Header: apdoawts.pls 120.5.12010000.6 2009/11/16 08:11:15 imandal ship $ */
3
4 -- Public packaged variables:
5
6 l_create_dists ap_system_parameters.create_awt_dists_type%TYPE;
7 l_create_invoices ap_system_parameters.create_awt_invoices_type%TYPE;
8
9 PROCEDURE Ap_Do_Withholding(
10 P_Invoice_Id IN NUMBER,
11 P_Awt_Date IN DATE,
12 P_Calling_Module IN VARCHAR2,
13 P_Amount IN NUMBER,
14 P_Payment_Num IN NUMBER DEFAULT NULL,
15 P_Checkrun_Name IN VARCHAR2 DEFAULT NULL,
16 P_Last_Updated_By IN NUMBER,
17 P_Last_Update_Login IN NUMBER,
18 P_Program_Application_Id IN NUMBER DEFAULT NULL,
19 P_Program_Id IN NUMBER DEFAULT NULL,
20 P_Request_Id IN NUMBER DEFAULT NULL,
21 P_Awt_Success OUT NOCOPY VARCHAR2,
22 P_Invoice_Payment_Id IN NUMBER DEFAULT NULL,
23 P_Check_Id IN NUMBER DEFAULT NULL,
24 p_checkrun_id in number default null);
25
26 PROCEDURE Ap_Withhold_AutoSelect(
27 P_Checkrun_Name IN VARCHAR2,
28 P_Last_Updated_By IN NUMBER,
29 P_Last_Update_Login IN NUMBER,
30 P_Program_Application_Id IN NUMBER,
31 P_Program_Id IN NUMBER,
32 P_Request_Id IN NUMBER,
33 p_checkrun_id in number);
34
35 PROCEDURE Ap_Withhold_Confirm(
36 P_Checkrun_Name IN VARCHAR2,
37 P_Last_Updated_By IN NUMBER,
38 P_Last_Update_Login IN NUMBER,
39 P_Program_Application_Id IN NUMBER,
40 P_Program_Id IN NUMBER,
41 P_Request_Id IN NUMBER,
42 p_checkrun_id in number,
43 p_completed_pmts_group_id in number,
44 p_org_id in number,
45 p_check_date in date);
46
47 PROCEDURE Ap_Withhold_Cancel(
48 P_Checkrun_Name IN VARCHAR2,
49 P_Last_Updated_By IN NUMBER,
50 P_Last_Update_Login IN NUMBER,
51 P_Program_Application_Id IN NUMBER,
52 P_Program_Id IN NUMBER,
53 P_Request_Id IN NUMBER,
54 p_checkrun_id in number,
55 p_completed_pmts_group_id in number default null,
56 p_org_id in number default null);
57
58 PROCEDURE Ap_Undo_Temp_Withholding(
59 P_Invoice_Id IN NUMBER,
60 P_Vendor_Id IN NUMBER DEFAULT NULL,
61 P_Payment_Num IN NUMBER,
62 P_Checkrun_Name IN VARCHAR2,
63 P_Undo_Awt_Date IN DATE,
64 P_Calling_Module IN VARCHAR2,
65 P_Last_Updated_By IN NUMBER,
66 P_Last_Update_Login IN NUMBER,
67 P_Program_Application_Id IN NUMBER DEFAULT NULL,
68 P_Program_Id IN NUMBER DEFAULT NULL,
69 P_Request_Id IN NUMBER DEFAULT NULL,
70 P_Awt_Success OUT NOCOPY VARCHAR2,
71 P_checkrun_id in number default null);
72
73 PROCEDURE Ap_Undo_Withholding(
74 P_Parent_Id IN NUMBER,
75 P_Calling_Module IN VARCHAR2,
76 P_Awt_Date IN DATE,
77 P_New_Invoice_Payment_Id IN NUMBER DEFAULT NULL,
78 P_Last_Updated_By IN NUMBER,
79 P_Last_Update_Login IN NUMBER,
80 P_Program_Application_Id IN NUMBER DEFAULT NULL,
81 P_Program_Id IN NUMBER DEFAULT NULL,
82 P_Request_Id IN NUMBER DEFAULT NULL,
83 P_Awt_Success OUT NOCOPY VARCHAR2,
84 P_Inv_Line_No IN NUMBER DEFAULT NULL,
85 P_Dist_Line_No IN NUMBER DEFAULT NULL,
86 P_New_Invoice_Id IN NUMBER DEFAULT NULL,
87 P_New_Dist_Line_No IN NUMBER DEFAULT NULL);
88
89 PROCEDURE Create_AWT_Distributions(
90 P_Invoice_Id IN NUMBER,
91 P_Calling_Module IN VARCHAR2,
92 P_Create_Dists IN VARCHAR2,
93 P_Payment_Num IN NUMBER,
94 P_Currency_Code IN VARCHAR2,
95 P_Last_Updated_By IN NUMBER,
96 P_Last_Update_Login IN NUMBER,
97 P_Program_Application_Id IN NUMBER,
98 P_Program_Id IN NUMBER,
99 P_Request_Id IN NUMBER,
100 P_Calling_Sequence IN VARCHAR2,
101 P_Check_Id IN NUMBER DEFAULT NULL); --bug 8590059
102
103 PROCEDURE Create_AWT_Invoices(
104 P_Invoice_Id IN NUMBER,
105 P_Payment_Date IN DATE,
106 P_Last_Updated_By IN NUMBER,
107 P_Last_Update_Login IN NUMBER,
108 P_Program_Application_Id IN NUMBER,
109 P_Program_Id IN NUMBER,
110 P_Request_Id IN NUMBER,
111 P_Calling_Sequence IN VARCHAR2,
112 P_Calling_Module IN VARCHAR2 DEFAULT NULL, --Bug6660355 -- bug 8266021
113 P_Inv_Line_No IN NUMBER DEFAULT NULL,
114 P_Dist_Line_No IN NUMBER DEFAULT NULL,
115 P_New_Invoice_Id IN NUMBER DEFAULT NULL,
116 P_create_dists IN VARCHAR2 DEFAULT NULL); --Bug7685907 bug8207324 bug8236169
117 END AP_WITHHOLDING_PKG;