[Home] [Help]
PACKAGE: APPS.JG_EXTENDED_WITHHOLDING_PKG
Source
1 PACKAGE JG_EXTENDED_WITHHOLDING_PKG AUTHID CURRENT_USER AS
2 /* $Header: jgexawts.pls 120.3 2005/10/26 00:14:51 dbetanco ship $ */
3
4
5 /**************************************************************************
6 * *
7 * Name : Jg_Do_Extended_Withholding *
8 * Purpose : Regional Extended Routine for the Withholding Tax *
9 * Calculation *
10 * *
11 **************************************************************************/
12 FUNCTION JG_DO_EXTENDED_WITHHOLDING
13 (P_Invoice_Id IN Number,
14 P_Awt_Date IN Date,
15 P_Calling_Module IN Varchar2,
16 P_Amount IN Number,
17 P_Payment_Num IN Number Default null,
18 P_Checkrun_Name IN Varchar2 Default null,
19 P_Checkrun_id IN Number Default null,
20 P_Last_Updated_By IN Number,
21 P_Last_Update_Login IN Number,
22 P_Program_Application_Id IN Number Default null,
23 P_Program_Id IN Number Default null,
24 P_Request_Id IN Number Default null,
25 P_Invoice_Payment_Id IN Number Default null,
26 P_Check_Id IN Number Default null)
27 RETURN NUMBER;
28
29
30
31 /**************************************************************************
32 * *
33 * Name : Jg_Undo_Extended_Withholding *
34 * Purpose : Regional Extended Routine for the Withholding Tax *
35 * Reversion *
36 * *
37 **************************************************************************/
38 FUNCTION JG_UNDO_EXTENDED_WITHHOLDING
39 (P_Parent_Id IN Number,
40 P_Calling_Module IN Varchar2,
41 P_Awt_Date IN Date,
42 P_New_Invoice_Payment_Id IN Number Default null,
43 P_Last_Updated_By IN Number,
44 P_Last_Update_Login IN Number,
45 P_Program_Application_Id IN Number Default null,
46 P_Program_Id IN Number Default null,
47 P_Request_Id IN Number Default null,
48 P_Dist_Line_No IN Number Default null,
49 P_New_Invoice_Id IN Number Default null,
50 P_New_Dist_Line_No IN Number Default null)
51 RETURN NUMBER;
52
53
54
55
56 /**************************************************************************
57 * *
58 * Name : Jg_Undo_Temp_Ext_Withholding *
59 * Purpose : Regional Extended Routine to Reverse Temporary *
60 * Withholding Distributions *
61 * *
62 **************************************************************************/
63 FUNCTION JG_UNDO_TEMP_EXT_WITHHOLDING
64 (P_Invoice_Id IN Number,
65 P_Vendor_Id IN Number Default null,
66 P_Payment_Num IN Number,
67 P_Checkrun_Name IN Varchar2,
68 P_Checkrun_id IN Number,
69 P_Undo_Awt_Date IN Date,
70 P_Calling_Module IN Varchar2,
71 P_Last_Updated_By IN Number,
72 P_Last_Update_Login IN Number,
73 P_Program_Application_Id IN Number Default null,
74 P_Program_Id IN Number Default null,
75 P_Request_Id IN Number Default null)
76 RETURN NUMBER;
77
78
79
80
81 /**************************************************************************
82 * *
83 * Name : Jg_Ext_Withholding_Default *
84 * Purpose : Regional Extended Routine to Default Withholding Tax *
85 * Information *
86 * -- Bug 4559472 *
87 **************************************************************************/
88 FUNCTION JG_EXT_WITHHOLDING_DEFAULT (P_Invoice_Id IN Number,
89 P_Inv_Line_Num IN Number,
90 P_Inv_Dist_Id IN ap_invoice_distributions_all.invoice_distribution_id%TYPE,
91 P_Calling_Module IN Varchar2,
92 P_Parent_Dist_ID IN Number)
93 RETURN NUMBER;
94
95 /**************************************************************************
96 * *
97 * Name : Jg_Extended_Match *
98 * Purpose : Regional Extended Routine for Matching *
99 * -- Bug 4559478 *
100 **************************************************************************/
101 PROCEDURE JG_EXTENDED_MATCH
102 (P_Credit_Id IN Number,
103 P_Invoice_Id IN Number Default null,
104 P_Inv_Line_Num IN Number Default null,
105 P_Distribution_id IN Number Default null,
106 P_Parent_Dist_ID IN Number Default null);
107
108
109 /**************************************************************************
110 * *
111 * Name : Jg_Extended_Insert_Dist *
112 * Purpose : Regional Extended Routine for Insertion *
113 * *
114 **************************************************************************/
115 PROCEDURE JG_EXTENDED_INSERT_DIST
116 (P_Invoice_Id IN Number,
117 P_Invoice_Distribution_id IN Number, -- Add new Column
118 P_Distribution_Line_Number IN Number,
119 P_Line_Type IN Varchar2,
120 P_GL_Date IN Date,
121 P_Period_Name IN Varchar2,
122 P_Type_1099 IN Varchar2,
123 P_Income_Tax_Region IN Varchar2,
124 P_Amount IN Number,
125 P_Tax_Code_ID IN Number, -- Add new Column
126 P_Code_Combination_Id IN Number,
127 P_PA_Quantity IN Number,
128 P_Description IN Varchar2,
129 P_tax_recoverable_flag IN Varchar2, -- Add new Column
130 P_tax_recovery_rate IN Number, -- Add new Column
131 P_tax_code_override_flag IN Varchar2, -- Add new Column
132 P_tax_recovery_override_flag IN Varchar2, -- Add new Column
133 P_po_distribution_id IN Number, -- Add new Column
134 P_Attribute_Category IN Varchar2,
135 P_Attribute1 IN Varchar2,
136 P_Attribute2 IN Varchar2,
137 P_Attribute3 IN Varchar2,
138 P_Attribute4 IN Varchar2,
139 P_Attribute5 IN Varchar2,
140 P_Attribute6 IN Varchar2,
141 P_Attribute7 IN Varchar2,
142 P_Attribute8 IN Varchar2,
143 P_Attribute9 IN Varchar2,
144 P_Attribute10 IN Varchar2,
145 P_Attribute11 IN Varchar2,
146 P_Attribute12 IN Varchar2,
147 P_Attribute13 IN Varchar2,
148 P_Attribute14 IN Varchar2,
149 P_Attribute15 IN Varchar2,
150 P_Calling_Sequence IN Varchar2
151 );
152
153 /**************************************************************************
154 * *
155 * Name : Jg_Ext_Withholdings_Prepay *
156 * Purpose : Regional Extended Routine for Insertion on Prepay line *
157 * *
158 **************************************************************************/
159 FUNCTION Jg_Ext_Withholding_Prepay
160 (P_prepay_dist_id IN Number,
161 P_invoice_id IN Number,
162 -- Bug 4559474
163 P_inv_dist_id IN Number,
164 P_user_id IN Number,
165 P_last_update_login IN Number,
166 P_calling_sequence IN Varchar2
167 )
168 RETURN NUMBER;
169
170
171 END JG_EXTENDED_WITHHOLDING_PKG;