1 package AP_CALC_WITHHOLDING_PKG as
2 /* $Header: apclawts.pls 120.7.12010000.2 2008/09/09 10:07:28 njakkula ship $ */
3
4 -- ====================================================================
5 -- P R I V A T E - G L O B A L V A R I A B L E S
6 -- ====================================================================
7 -- Added for Bug 7232736
8 g_org_id NUMBER(15); /* Bug3700128. MOAC Project */
9
10 PROCEDURE AP_Calculate_AWT_Amounts (
11 P_Invoice_Id IN NUMBER,
12 P_Awt_Date IN DATE,
13 P_Calling_Module IN VARCHAR2,
14 P_Create_Dists IN VARCHAR2,
15 P_Amount IN NUMBER,
16 P_Payment_Num IN NUMBER,
17 P_Checkrun_Name IN VARCHAR2,
18 P_Last_Updated_By IN NUMBER,
19 P_Last_Update_Login IN NUMBER,
20 P_Program_Application_Id IN NUMBER,
21 P_Program_Id IN NUMBER,
22 P_Request_Id IN NUMBER,
23 P_AWT_Success IN OUT NOCOPY VARCHAR2,
24 P_Calling_Sequence IN VARCHAR2,
25 P_Invoice_Payment_Id IN NUMBER DEFAULT NULL,
26 p_checkrun_id in number default null,
27 p_org_id in number default null);
28
29 PROCEDURE Handle_Bucket (
30 P_Awt_Period_Name IN VARCHAR2,
31 P_Amount_Subject IN NUMBER,
32 P_Amount_Withheld IN NUMBER,
33 P_Vendor_Id IN NUMBER,
34 P_Tax_Name IN VARCHAR2,
35 P_Calling_Module IN VARCHAR2,
36 P_Last_Updated_By IN NUMBER,
37 P_Last_Update_Login IN NUMBER,
38 P_Program_Application_Id IN NUMBER,
39 P_Program_Id IN NUMBER,
40 P_Request_Id IN NUMBER,
41 P_Calling_Sequence IN VARCHAR2);
42
43 PROCEDURE Insert_Temp_Distribution(
44 InvoiceId IN NUMBER,
45 SuppId IN NUMBER,
46 PaymentNum IN NUMBER,
47 GroupId IN NUMBER,
48 TaxName IN VARCHAR2,
49 CodeCombinationId IN NUMBER,
50 GrossAmount IN NUMBER,
51 WithheldAmount IN NUMBER,
52 AwtDate IN DATE,
53 GLPeriodName IN VARCHAR2,
54 AwtPeriodType IN VARCHAR2,
55 AwtPeriodName IN VARCHAR2,
56 -- P_Awt_Related_Id IN NUMBER DEFAULT NULL, --Bug 6168793
57 CheckrunName IN VARCHAR2,
58 WithheldRateId IN NUMBER,
59 ExchangeRate IN NUMBER,
60 CurrCode IN VARCHAR2,
61 BaseCurrCode IN VARCHAR2,
62 auto_offset_segs IN VARCHAR2,
63 P_Calling_Sequence IN VARCHAR2,
64 HandleBucket IN VARCHAR2 DEFAULT 'N',
65 LastUpdatedBy IN NUMBER DEFAULT NULL,
66 LastUpdateLogin IN NUMBER DEFAULT NULL,
67 ProgramApplicationId IN NUMBER DEFAULT NULL,
68 ProgramId IN NUMBER DEFAULT NULL,
69 RequestId IN NUMBER DEFAULT NULL,
70 CallingModule IN VARCHAR2 DEFAULT NULL,
71 P_Invoice_Payment_Id IN NUMBER DEFAULT NULL,
72 invoice_exchange_rate IN NUMBER DEFAULT NULL,
73 GLOBAL_ATTRIBUTE_CATEGORY IN VARCHAR2 DEFAULT NULL,
74 GLOBAL_ATTRIBUTE1 IN VARCHAR2 DEFAULT NULL,
75 GLOBAL_ATTRIBUTE2 IN VARCHAR2 DEFAULT NULL,
76 GLOBAL_ATTRIBUTE3 IN VARCHAR2 DEFAULT NULL,
77 GLOBAL_ATTRIBUTE4 IN VARCHAR2 DEFAULT NULL,
78 GLOBAL_ATTRIBUTE5 IN VARCHAR2 DEFAULT NULL,
79 GLOBAL_ATTRIBUTE6 IN VARCHAR2 DEFAULT NULL,
80 GLOBAL_ATTRIBUTE7 IN VARCHAR2 DEFAULT NULL,
81 GLOBAL_ATTRIBUTE8 IN VARCHAR2 DEFAULT NULL,
82 GLOBAL_ATTRIBUTE9 IN VARCHAR2 DEFAULT NULL,
83 GLOBAL_ATTRIBUTE10 IN VARCHAR2 DEFAULT NULL,
84 GLOBAL_ATTRIBUTE11 IN VARCHAR2 DEFAULT NULL,
85 GLOBAL_ATTRIBUTE12 IN VARCHAR2 DEFAULT NULL,
86 GLOBAL_ATTRIBUTE13 IN VARCHAR2 DEFAULT NULL,
87 GLOBAL_ATTRIBUTE14 IN VARCHAR2 DEFAULT NULL,
88 GLOBAL_ATTRIBUTE15 IN VARCHAR2 DEFAULT NULL,
89 GLOBAL_ATTRIBUTE16 IN VARCHAR2 DEFAULT NULL,
90 GLOBAL_ATTRIBUTE17 IN VARCHAR2 DEFAULT NULL,
91 GLOBAL_ATTRIBUTE18 IN VARCHAR2 DEFAULT NULL,
92 GLOBAL_ATTRIBUTE19 IN VARCHAR2 DEFAULT NULL,
93 GLOBAL_ATTRIBUTE20 IN VARCHAR2 DEFAULT NULL,
94 p_checkrun_id in number default null,
95 P_Awt_Related_Id IN NUMBER DEFAULT NULL --bug6524425
96 );
97
98 END AP_CALC_WITHHOLDING_PKG;