eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_WITHHOLDING_PKG dependencies on AP_AWT_BUCKETS

Line 3916: UPDATE ap_awt_buckets_all

3912: CLOSE c_get_awt_period;
3913:
3914:
3915:
3916: UPDATE ap_awt_buckets_all
3917: SET gross_amount_to_date = gross_amount_to_date -
3918: NVL(rec_temp_gross.gross_amount,0)
3919: , last_UPDATE_date = SYSDATE
3920: , last_UPDATEd_by = P_Last_Updated_By

Line 3996: debug_info := 'Update ap_awt_buckets';

3992: END IF;
3993:
3994: CLOSE c_get_awt_period;
3995:
3996: debug_info := 'Update ap_awt_buckets';
3997: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3998: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);
3999: END IF;
4000:

Line 4002: UPDATE ap_awt_buckets_all

3998: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);
3999: END IF;
4000:
4001: --Bug12594549 commented gross amount update
4002: UPDATE ap_awt_buckets_all
4003: /* SET gross_amount_to_date = gross_amount_to_date -
4004: NVL(rec_temp.gross_amount,0) */
4005: SET withheld_amount_to_date = withheld_amount_to_date -
4006: NVL(rec_temp.withholding_amount,0)

Line 4793: FROM ap_awt_buckets

4789: Period IN VARCHAR2,
4790: TaxCode IN VARCHAR2) IS
4791: SELECT gross_amount_to_date,
4792: withheld_amount_to_date
4793: FROM ap_awt_buckets
4794: WHERE vendor_id = VendorId
4795: AND period_name = Period
4796: AND tax_name = TaxCode
4797: FOR UPDATE;

Line 4799: gross_amt_to_date ap_awt_buckets.gross_amount_to_date%TYPE;

4795: AND period_name = Period
4796: AND tax_name = TaxCode
4797: FOR UPDATE;
4798:
4799: gross_amt_to_date ap_awt_buckets.gross_amount_to_date%TYPE;
4800: withheld_amt_to_date ap_awt_buckets.withheld_amount_to_date%TYPE;
4801: r_w_amount_to_date NUMBER := NULL; --Added for Bug#12594549
4802: r_gross_amount_to_date NUMBER := NULL; --Added for Bug#12594549
4803: DBG_Loc VARCHAR2(30) := 'Update_Bucket';

Line 4800: withheld_amt_to_date ap_awt_buckets.withheld_amount_to_date%TYPE;

4796: AND tax_name = TaxCode
4797: FOR UPDATE;
4798:
4799: gross_amt_to_date ap_awt_buckets.gross_amount_to_date%TYPE;
4800: withheld_amt_to_date ap_awt_buckets.withheld_amount_to_date%TYPE;
4801: r_w_amount_to_date NUMBER := NULL; --Added for Bug#12594549
4802: r_gross_amount_to_date NUMBER := NULL; --Added for Bug#12594549
4803: DBG_Loc VARCHAR2(30) := 'Update_Bucket';
4804: NOTHING_TO_DO exception;

Line 4854: UPDATE ap_awt_buckets

4850: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
4851: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);
4852: END IF;
4853:
4854: UPDATE ap_awt_buckets
4855: SET gross_amount_to_date = (gross_amt_to_date -
4856: ap_utilities_pkg.ap_round_currency(
4857: rec_awt_gross_dists.awt_gross_amount*
4858: NVL(l_invoice_exchange_rate,1),

Line 5372: FROM ap_awt_buckets

5368: Period IN VARCHAR2,
5369: TaxCode IN VARCHAR2) IS
5370: SELECT gross_amount_to_date,
5371: withheld_amount_to_date
5372: FROM ap_awt_buckets
5373: WHERE vendor_id = VendorId
5374: AND period_name = Period
5375: AND tax_name = TaxCode
5376: FOR UPDATE;

Line 5378: gross_amt_to_date ap_awt_buckets.gross_amount_to_date%TYPE;

5374: AND period_name = Period
5375: AND tax_name = TaxCode
5376: FOR UPDATE;
5377:
5378: gross_amt_to_date ap_awt_buckets.gross_amount_to_date%TYPE;
5379: withheld_amt_to_date ap_awt_buckets.withheld_amount_to_date%TYPE;
5380:
5381: DBG_Loc VARCHAR2(30) := 'Update_Bucket';
5382: NOTHING_TO_DO exception;

Line 5379: withheld_amt_to_date ap_awt_buckets.withheld_amount_to_date%TYPE;

5375: AND tax_name = TaxCode
5376: FOR UPDATE;
5377:
5378: gross_amt_to_date ap_awt_buckets.gross_amount_to_date%TYPE;
5379: withheld_amt_to_date ap_awt_buckets.withheld_amount_to_date%TYPE;
5380:
5381: DBG_Loc VARCHAR2(30) := 'Update_Bucket';
5382: NOTHING_TO_DO exception;
5383: BEGIN

Line 5432: UPDATE ap_awt_buckets

5428: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||DBG_Loc,debug_info);
5429: END IF;
5430:
5431: --Bug12594549
5432: UPDATE ap_awt_buckets
5433: SET
5434: /* gross_amount_to_date = (gross_amt_to_date -
5435: ap_utilities_pkg.ap_round_currency(
5436: rec_awt_dists.awt_gross_amount*

Line 5824: UPDATE ap_awt_buckets_all

5820: CLOSE c_get_awt_period;
5821:
5822: END;
5823:
5824: UPDATE ap_awt_buckets_all
5825: SET
5826: withheld_amount_to_date = withheld_amount_to_date -
5827: NVL(rec_orphan_awt_buckets_w.withholding_amount, 0),
5828: last_update_date = SYSDATE,

Line 5891: UPDATE ap_awt_buckets_all

5887: CLOSE c_get_awt_period;
5888:
5889: END;
5890:
5891: UPDATE ap_awt_buckets_all
5892: SET
5893: gross_amount_to_date = gross_amount_to_date -
5894: NVL(rec_orphan_awt_buckets_g.gross_amount, 0),
5895: last_update_date = SYSDATE,