[Home] [Help]
25: TYPE t_bal_seg_desc_tbl IS TABLE OF VARCHAR2(240) INDEX BY BINARY_INTEGER;
26: TYPE t_acct_seg_tbl IS TABLE OF VARCHAR2(240) INDEX BY BINARY_INTEGER;
27: TYPE t_acct_seg_desc_tbl IS TABLE OF VARCHAR2(240) INDEX BY BINARY_INTEGER;
28: TYPE t_ccid_tbl IS TABLE OF NUMBER(15) INDEX BY BINARY_INTEGER;
29: TYPE t_acct_date_tbl IS TABLE OF ZX_REP_ACTG_EXT_T.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
30:
31: g_acct_all_tbl t_acct_all_tbl;
32: g_acct_all_desc_tbl t_acct_all_desc_tbl;
33: g_bal_seg_tbl t_bal_seg_tbl;
226:
227: /**
228: * PROCEDURE Name: insert_row
229: *
230: + This procedure insert fetched accounting info into zx_rep_actg_ext_t table
231: * and calculated tax/taxable amount into zx_rep_trx_jx_ext_t table
232: *
233: * @parameter: p_detail_tax_line_id_tbl
234: * @parameter: p_taxable_amt_tbl
282: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.insert_row()+',
283: 'g_balancing_seg : ');
284: END IF;
285:
286: /* INSERT INTO ZX_REP_ACTG_EXT_T
287: (
288: request_id,
289: created_by,
290: creation_date,
308: g_today,
309: g_user_id,
310: g_today,
311: g_login_id,
312: zx_rep_actg_ext_t_s.NEXTVAL,
313: p_detail_tax_line_id_tbl(i),
314: p_acct_date_tbl(i),
315: substrb(g_acct_all_tbl(p_ccid_tbl(i)),1,240),
316: g_acct_all_desc_tbl(p_ccid_tbl(i)),
1002: 0 taxable_amt, -- -1*zx_dist.taxable_amt taxable_amt,
1003: 0 taxable_amt_funcl_curr, -- -1*zx_dist.taxable_amt_funcl_curr taxable_amt_funcl_curr,
1004: 0 tax_amt, -- -1*zx_dist.prd_tax_amt tax_amt,
1005: 0 tax_amt_funcl_curr -- -1*zx_dist.prd_tax_amt_funcl_curr tax_amt_funcl_curr
1006: FROM zx_rep_actg_ext_t
1007: WHERE detail_tax_line_id = c_detail_tax_line_id;
1008:
1009: CURSOR c_ar_inv1(c_detail_tax_line_id in NUMBER,
1010: c_trx_id in NUMBER,