APPS.ZX_GL_EXTRACT_PKG dependencies on ZX_REP_ACTG_EXT_T

Line 143: ZX_REP_ACTG_EXT_T.TRX_TAXABLE_ACCOUNT_DESC%TYPE INDEX BY BINARY_INTEGER;

139: gt_actg_ext_line_id zx_extract_pkg.actg_ext_line_id_tbl;
140: gt_accounting_date zx_extract_pkg.accounting_date_tbl;
141:
142: TYPE TRX_TAXABLE_ACCOUNT_DESC_tbl IS TABLE OF
143: ZX_REP_ACTG_EXT_T.TRX_TAXABLE_ACCOUNT_DESC%TYPE INDEX BY BINARY_INTEGER;
144:
145: TYPE TRX_TAXABLE_BALSEG_DESC_tbl IS TABLE OF
146: ZX_REP_ACTG_EXT_T.TRX_TAXABLE_BALSEG_DESC%TYPE INDEX BY BINARY_INTEGER;
147:

Line 146: ZX_REP_ACTG_EXT_T.TRX_TAXABLE_BALSEG_DESC%TYPE INDEX BY BINARY_INTEGER;

142: TYPE TRX_TAXABLE_ACCOUNT_DESC_tbl IS TABLE OF
143: ZX_REP_ACTG_EXT_T.TRX_TAXABLE_ACCOUNT_DESC%TYPE INDEX BY BINARY_INTEGER;
144:
145: TYPE TRX_TAXABLE_BALSEG_DESC_tbl IS TABLE OF
146: ZX_REP_ACTG_EXT_T.TRX_TAXABLE_BALSEG_DESC%TYPE INDEX BY BINARY_INTEGER;
147:
148: TYPE TRX_TAXABLE_NATACCT_DESC_tbl IS TABLE OF
149: ZX_REP_ACTG_EXT_T.TRX_TAXABLE_NATACCT_SEG_DESC%TYPE INDEX BY BINARY_INTEGER;
150:

Line 149: ZX_REP_ACTG_EXT_T.TRX_TAXABLE_NATACCT_SEG_DESC%TYPE INDEX BY BINARY_INTEGER;

145: TYPE TRX_TAXABLE_BALSEG_DESC_tbl IS TABLE OF
146: ZX_REP_ACTG_EXT_T.TRX_TAXABLE_BALSEG_DESC%TYPE INDEX BY BINARY_INTEGER;
147:
148: TYPE TRX_TAXABLE_NATACCT_DESC_tbl IS TABLE OF
149: ZX_REP_ACTG_EXT_T.TRX_TAXABLE_NATACCT_SEG_DESC%TYPE INDEX BY BINARY_INTEGER;
150:
151: TYPE TRX_CONTROL_ACCTFLEXFIELD_tbl IS TABLE OF
152: ZX_REP_ACTG_EXT_T.TRX_CONTROL_ACCOUNT_FLEXFIELD%TYPE INDEX BY BINARY_INTEGER;
153:

Line 152: ZX_REP_ACTG_EXT_T.TRX_CONTROL_ACCOUNT_FLEXFIELD%TYPE INDEX BY BINARY_INTEGER;

148: TYPE TRX_TAXABLE_NATACCT_DESC_tbl IS TABLE OF
149: ZX_REP_ACTG_EXT_T.TRX_TAXABLE_NATACCT_SEG_DESC%TYPE INDEX BY BINARY_INTEGER;
150:
151: TYPE TRX_CONTROL_ACCTFLEXFIELD_tbl IS TABLE OF
152: ZX_REP_ACTG_EXT_T.TRX_CONTROL_ACCOUNT_FLEXFIELD%TYPE INDEX BY BINARY_INTEGER;
153:
154: GT_TRX_CONTROL_ACCFLEXFIELD TRX_CONTROL_ACCTFLEXFIELD_tbl ;
155: GT_TRX_TAXABLE_ACCOUNT_DESC TRX_TAXABLE_ACCOUNT_DESC_tbl ;
156:

Line 1749: INSERT INTO ZX_REP_ACTG_EXT_T(

1745: g_ledger_name );
1746:
1747: IF g_include_accounting_segments='Y' THEN
1748: FORALL i IN 1 .. nvl(gt_ledger_id.COUNT, 0)
1749: INSERT INTO ZX_REP_ACTG_EXT_T(
1750: actg_ext_line_id,
1751: detail_tax_line_id,
1752: actg_line_ccid,
1753: period_name,

Line 1766: zx_rep_actg_ext_t_s.nextval,

1762: program_id,
1763: program_login_id,
1764: request_id)
1765: VALUES (
1766: zx_rep_actg_ext_t_s.nextval,
1767: gt_detail_tax_line_id(i),
1768: gt_actg_line_ccid(i),
1769: gt_period_name(i),
1770: 'Y',

Line 2243: zx_rep_actg_ext_t act

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;
2247:

Line 2468: UPDATE ZX_REP_ACTG_EXT_T

2464: WHERE DETAIL_TAX_LINE_ID = GT_DETAIL_TAX_LINE_ID(i);
2465:
2466: IF g_include_accounting_segments='Y' THEN
2467: FORALL i IN 1 .. l_count
2468: UPDATE ZX_REP_ACTG_EXT_T
2469: SET trx_arap_balancing_segment = gt_trx_arap_balancing_segment(i),
2470: trx_arap_natural_account = gt_trx_arap_natural_account(i),
2471: trx_taxable_balancing_segment = gt_trx_taxable_bal_seg(i),
2472: trx_taxable_natural_account = gt_trx_taxable_natural_account(i),