APPS.ZX_GL_EXTRACT_PKG dependencies on ZX_REP_TRX_DETAIL_T

Line 1563: INSERT into zx_rep_trx_detail_t

1559: FORALL i IN 1 .. nvl(gt_ledger_id.COUNT, 0)
1560:
1561: -- New insert code
1562:
1563: INSERT into zx_rep_trx_detail_t
1564: (application_id,
1565: detail_tax_line_id,
1566: ledger_id,
1567: trx_id,

Line 2106: SELECT zx_rep_trx_detail_t_s.nextval

2102: END IF;
2103:
2104: IF zx_rep_detail_csr%FOUND THEN
2105:
2106: SELECT zx_rep_trx_detail_t_s.nextval
2107: INTO gt_detail_tax_line_id(i)
2108: FROM DUAL;
2109:
2110: --

Line 2242: FROM zx_rep_trx_detail_t det,

2238: det.taxable_amt,
2239: det.taxable_amt_funcl_curr,
2240: ACT.ACTG_LINE_CCID,
2241: ACT.ACTG_EXT_LINE_ID
2242: FROM zx_rep_trx_detail_t det,
2243: zx_rep_actg_ext_t act
2244: WHERE det.extract_source_ledger = 'GL'
2245: AND det.request_id = c_request_id
2246: AND act.detail_tax_line_id(+) = det.detail_tax_line_id;

Line 2453: UPDATE ZX_REP_TRX_DETAIL_T SET

2449: END IF;
2450: END LOOP;
2451:
2452: FORALL i in 1..l_count
2453: UPDATE ZX_REP_TRX_DETAIL_T SET
2454: TAX_RATE_VAT_TRX_TYPE_DESC = GT_TAX_RATE_VAT_TRX_TYPE_DESC(i),
2455: TRX_CLASS_MNG = GT_TRX_CLASS_MNG(i),
2456: TAX_RATE_CODE_VAT_TRX_TYPE_MNG = GT_TAX_RATE_VAT_TRX_TYPE_MNG(i),
2457: TAX_TYPE_MNG = GT_TAX_TYPE_MNG(i),