APPS.ZX_AP_EXTRACT_PKG dependencies on ZX_REP_TRX_DETAIL_T

Line 3343: | This procedure inserts payables tax data into ZX_REP_TRX_DETAIL_T table|

3339: /*===========================================================================+
3340: | PROCEDURE |
3341: | insert_tax_info |
3342: | DESCRIPTION |
3343: | This procedure inserts payables tax data into ZX_REP_TRX_DETAIL_T table|
3344: | |
3345: | SCOPE - Private |
3346: | |
3347: | NOTES |

Line 3373: INSERT INTO ZX_REP_TRX_DETAIL_T(

3369: ' Record Count = ' ||to_char(GT_TRX_ID.COUNT));
3370: END IF;
3371:
3372: FORALL i IN 1 .. l_count
3373: INSERT INTO ZX_REP_TRX_DETAIL_T(
3374: DETAIL_TAX_LINE_ID,
3375: APPLICATION_ID,
3376: EXTRACT_REPORT_LINE_NUMBER,
3377: EVENT_CLASS_CODE,

Line 3558: ZX_REP_TRX_DETAIL_T_S.NEXTVAL,

3554: unit_price,
3555: gl_date, --Bug 5523095
3556: def_rec_settlement_option_code ) -- Bug10238948
3557: VALUES(
3558: ZX_REP_TRX_DETAIL_T_S.NEXTVAL,
3559: gt_application_id(i),
3560: gt_extract_rep_line_num(i),
3561: gt_event_class_code(i),
3562: gt_internal_organization_id(i),

Line 3946: FROM ZX_REP_TRX_DETAIL_T

3942: SUM(tax_amt_tax_curr),
3943: SUM(taxable_amt),
3944: SUM(taxable_amt_funcl_curr),
3945: MIN(detail_tax_line_id)
3946: FROM ZX_REP_TRX_DETAIL_T
3947: WHERE request_id = g_request_id
3948: AND application_id = 200
3949: AND entity_code = 'AP_INVOICES'
3950: AND EXTRACT_SOURCE_LEDGER = 'AP'

Line 4063: UPDATE ZX_REP_TRX_DETAIL_T

4059: gt_taxable_amt_funcl_curr,
4060: gt_detail_tax_line_id LIMIT 1000;
4061:
4062: FORALL i IN NVL(gt_detail_tax_line_id.first,1) .. NVL(gt_detail_tax_line_id.last,0)
4063: UPDATE ZX_REP_TRX_DETAIL_T
4064: SET trx_line_amt = gt_trx_line_amt(i),
4065: assessable_value = gt_assessable_value(i),
4066: nrec_tax_amt_tax_curr = gt_nrec_tax_amt_tax_curr(i),
4067: orig_rec_nrec_tax_amt = gt_orig_rec_nrec_tax_amt(i),

Line 4086: FROM ZX_REP_TRX_DETAIL_T

4082: END LOOP;
4083: CLOSE get_det_for_merging;
4084:
4085: DELETE
4086: FROM ZX_REP_TRX_DETAIL_T
4087: WHERE request_id = g_request_id
4088: AND application_id = 200
4089: AND entity_code = 'AP_INVOICES'
4090: AND taxable_item_source_id IS NOT NULL;

Line 4144: FROM ZX_REP_TRX_DETAIL_T DTL

4140: --3.Needs Revalidation and don't have any hold.
4141: --4.Needs Revalidation and have atleast one un-released accounting not allowed hold.
4142:
4143: DELETE
4144: FROM ZX_REP_TRX_DETAIL_T DTL
4145: WHERE REQUEST_ID = g_request_id
4146: AND DTL.EXTRACT_SOURCE_LEDGER = 'AP'
4147: AND EXISTS
4148: (SELECT /*+ no_unnest */ 1