APPS.ZX_JG_EXTRACT_PKG dependencies on ZX_REP_ACTG_EXT_T

Line 30: TYPE t_acct_date_tbl IS TABLE OF ZX_REP_ACTG_EXT_T.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;

26: TYPE t_bal_seg_desc_tbl IS TABLE OF VARCHAR2(240) INDEX BY BINARY_INTEGER;
27: TYPE t_acct_seg_tbl IS TABLE OF VARCHAR2(240) INDEX BY BINARY_INTEGER;
28: TYPE t_acct_seg_desc_tbl IS TABLE OF VARCHAR2(240) INDEX BY BINARY_INTEGER;
29: TYPE t_ccid_tbl IS TABLE OF NUMBER(15) INDEX BY BINARY_INTEGER;
30: TYPE t_acct_date_tbl IS TABLE OF ZX_REP_ACTG_EXT_T.ACCOUNTING_DATE%TYPE INDEX BY BINARY_INTEGER;
31:
32: g_acct_all_tbl t_acct_all_tbl;
33: g_acct_all_desc_tbl t_acct_all_desc_tbl;
34: g_bal_seg_tbl t_bal_seg_tbl;

Line 214: + This procedure insert fetched accounting info into zx_rep_actg_ext_t table

210:
211: /**
212: * PROCEDURE Name: insert_row
213: *
214: + This procedure insert fetched accounting info into zx_rep_actg_ext_t table
215: * and calculated tax/taxable amount into zx_rep_trx_jx_ext_t table
216: *
217: * @parameter: p_detail_tax_line_id_tbl
218: * @parameter: p_taxable_amt_tbl

Line 267: /* INSERT INTO ZX_REP_ACTG_EXT_T

263: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.zx_jg_extract.insert_row()+',
264: 'g_balancing_seg : ');
265: END IF;
266: */
267: /* INSERT INTO ZX_REP_ACTG_EXT_T
268: (
269: request_id,
270: created_by,
271: creation_date,

Line 293: zx_rep_actg_ext_t_s.NEXTVAL,

289: g_today,
290: g_user_id,
291: g_today,
292: g_login_id,
293: zx_rep_actg_ext_t_s.NEXTVAL,
294: p_detail_tax_line_id_tbl(i),
295: p_acct_date_tbl(i),
296: substrb(g_acct_all_tbl(p_ccid_tbl(i)),1,240),
297: g_acct_all_desc_tbl(p_ccid_tbl(i)),

Line 955: FROM zx_rep_actg_ext_t

951: 0 taxable_amt, -- -1*zx_dist.taxable_amt taxable_amt,
952: 0 taxable_amt_funcl_curr, -- -1*zx_dist.taxable_amt_funcl_curr taxable_amt_funcl_curr,
953: 0 tax_amt, -- -1*zx_dist.prd_tax_amt tax_amt,
954: 0 tax_amt_funcl_curr -- -1*zx_dist.prd_tax_amt_funcl_curr tax_amt_funcl_curr
955: FROM zx_rep_actg_ext_t
956: WHERE detail_tax_line_id = c_detail_tax_line_id;
957:
958:
959:

Line 1902: zx_rep_actg_ext_t act,

1898: zx_dist.rec_nrec_tax_dist_id,
1899: trl_tmp.detail_tax_line_id
1900: ) AS tax_line_change
1901: FROM zx_rep_trx_detail_t trl_tmp,
1902: zx_rep_actg_ext_t act,
1903: zx_rec_nrec_dist zx_dist,
1904: xla_distribution_links lnk,
1905: xla_ae_headers aeh,
1906: xla_ae_lines ael,

Line 1962: zx_rep_actg_ext_t act,

1958: zx_dist.rec_nrec_tax_dist_id,
1959: trl_tmp.detail_tax_line_id
1960: ) AS tax_line_change
1961: FROM zx_rep_trx_detail_t trl_tmp,
1962: zx_rep_actg_ext_t act,
1963: zx_rec_nrec_dist zx_dist,
1964: ap_invoice_distributions_all ap_dist,
1965: ap_prepay_app_dists pre_dist,
1966: xla_ae_headers aeh,