APPS.AP_CALC_WITHHOLDING_PKG dependencies on AP_AWT_BUCKETS

Line 49: l_withheld_amount_to_date ap_awt_buckets.withheld_amount_to_date%TYPE;

45: l_awt_period_name ap_other_periods.period_name%TYPE
46: := P_Awt_Period_Name;
47: l_awt_period_limit ap_tax_codes.awt_period_limit%TYPE
48: := P_Period_Limit;
49: l_withheld_amount_to_date ap_awt_buckets.withheld_amount_to_date%TYPE;
50: l_amount_withheld NUMBER;
51:
52: CURSOR c_get_bucket (PerName IN VARCHAR2)
53: IS

Line 55: FROM ap_awt_buckets bk

51:
52: CURSOR c_get_bucket (PerName IN VARCHAR2)
53: IS
54: SELECT bk.withheld_amount_to_date
55: FROM ap_awt_buckets bk
56: WHERE bk.period_name = PerName
57: AND bk.tax_name = P_Tax_Name
58: AND bk.vendor_id = P_Vendor_Id;
59:

Line 167: FROM ap_awt_buckets bk

163: debug_info VARCHAR2(100);
164:
165: CURSOR c_get_bucket IS
166: SELECT 'Y'
167: FROM ap_awt_buckets bk
168: WHERE bk.period_name = P_Awt_Period_Name
169: AND bk.tax_name = P_Tax_Name
170: AND bk.vendor_id = P_Vendor_Id
171: FOR UPDATE;

Line 199: UPDATE ap_awt_buckets

195:
196: -- Update existing bucket
197: debug_info := 'Update existing bucket';
198:
199: UPDATE ap_awt_buckets
200: SET gross_amount_to_date = gross_amount_to_date +
201: NVL(P_Amount_Subject, 0),
202: withheld_amount_to_date = withheld_amount_to_date +
203: NVL(P_Amount_Withheld, 0),

Line 216: INSERT INTO ap_awt_buckets

212: ELSE
213: -- Create new bucket
214: debug_info := 'Create new bucket';
215:
216: INSERT INTO ap_awt_buckets
217: (period_name
218: ,tax_name
219: ,vendor_id
220: ,withheld_amount_to_date

Line 1571: FROM ap_awt_buckets

1567: <>
1568: DECLARE
1569: CURSOR c_gross_amount_to_date IS
1570: SELECT gross_amount_to_date
1571: FROM ap_awt_buckets
1572: WHERE (period_name = AwtPeriodName)
1573: AND (tax_name = TaxName)
1574: AND (vendor_id = SuppId);
1575: gross_amount_to_date ap_awt_buckets.gross_amount_to_date%TYPE;

Line 1575: gross_amount_to_date ap_awt_buckets.gross_amount_to_date%TYPE;

1571: FROM ap_awt_buckets
1572: WHERE (period_name = AwtPeriodName)
1573: AND (tax_name = TaxName)
1574: AND (vendor_id = SuppId);
1575: gross_amount_to_date ap_awt_buckets.gross_amount_to_date%TYPE;
1576: new_number_of_ranges NUMBER := 0;
1577: i binary_integer := 1;
1578: DBG_Loc VARCHAR2(30) := 'Period_Basis_Is_Period';
1579: BEGIN