[Home] [Help]
40: g_link_ctr NUMBER := 0;
41: g_bulk_fetch_rows NUMBER := 400;
42: g_override1 VARCHAR2(1);
43: g_override2 VARCHAR2(1);
44: g_br_cust_trx_line_id ra_customer_trx_lines.customer_trx_line_id%TYPE;
45: g_simul_app VARCHAR2(1);
46: g_ae_code_combination_id_app NUMBER;
47:
48: g_exec VARCHAR2(30);
351: p_cust_inv_rec IN ra_customer_trx%ROWTYPE,
352: p_adj_rec IN ar_adjustments%ROWTYPE,
353: p_ae_ctr IN OUT NOCOPY BINARY_INTEGER,
354: p_ae_line_tbl IN OUT NOCOPY ae_line_tbl_type,
355: p_br_cust_trx_line_id IN ra_customer_trx_lines.customer_trx_line_id%TYPE default NULL,
356: p_simul_app IN VARCHAR2 default NULL,
357: p_from_llca_call IN VARCHAR2 DEFAULT 'N',
358: p_gt_id IN NUMBER DEFAULT NULL,
359: -- this flag is introduced to indicate if the application need conversion
963: END IF;
964:
965: select ctl.customer_trx_id
966: into l_dummy
967: from ra_customer_trx_lines ctl
968: where ctl.customer_trx_id = p_invoice_id
969: and ctl.autorule_complete_flag||'' = 'N'
970: group by ctl.customer_trx_id;
971:
1404: det.from_amount ae_from_pro_amt,
1405: det.from_acctd_amount ae_from_pro_acctd_amt,
1406: det.ccid ref_dist_ccid,
1407: det.ref_mf_dist_flag
1408: FROM ra_customer_trx_lines ctl,
1409: ra_cust_trx_line_gl_dist gld,
1410: ra_customer_trx_lines line,
1411: ar_line_app_detail_gt det
1412: where ctl.customer_trx_id = p_invoice_id
1406: det.ccid ref_dist_ccid,
1407: det.ref_mf_dist_flag
1408: FROM ra_customer_trx_lines ctl,
1409: ra_cust_trx_line_gl_dist gld,
1410: ra_customer_trx_lines line,
1411: ar_line_app_detail_gt det
1412: where ctl.customer_trx_id = p_invoice_id
1413: and ctl.line_type = 'TAX'
1414: and gld.customer_trx_line_id = ctl.customer_trx_line_id
1420: AND det.ref_cust_trx_line_gl_dist_id = gld.cust_trx_line_gl_dist_id
1421: AND det.gt_id = g_id
1422: AND det.ledger_id = g_ae_sys_rec.set_of_books_id;
1423: /* and not exists (select 'x'
1424: from ra_customer_trx_lines ctl1
1425: where ctl1.customer_trx_id = p_invoice_id
1426: and ctl1.autorule_complete_flag = 'N') */
1427: /* nvl(tax.location_segment_id,tax.vat_tax_id),
1428: decode(tax.location_segment_id,
1848: --{ref_dist_ccid
1849: det.ccid ref_dist_ccid,
1850: det.ref_mf_dist_flag ref_mf_dist_flag
1851: --}
1852: from ra_customer_trx_lines ctl,
1853: ra_cust_trx_line_gl_dist gld,
1854: ar_line_app_detail_gt det,
1855: (select b4.ae_link_to_cust_trx_line_id ae_link_to_cust_trx_line_id,
1856: max(decode(g_ae_rule_rec.gl_account_source1,
1927: gld.gl_date,
1928: 'UNEDISC'),
1929: ''),
1930: '')) override_ccid2
1931: from ra_customer_trx_lines ctl,
1932: ra_cust_trx_line_gl_dist gld
1933: where gld.customer_trx_line_id = ctl.customer_trx_line_id
1934: and gld.account_set_flag = 'N'
1935: and ctl.customer_trx_id = p_invoice_id
1934: and gld.account_set_flag = 'N'
1935: and ctl.customer_trx_id = p_invoice_id
1936: and ctl.rowid in
1937: (select min(ctl1.rowid)
1938: from ra_customer_trx_lines ctl1,
1939: (select /*+ INDEX(ar_ae_alloc_rec_gt AR_AE_ALLOC_REC_GT_N3) */
1940: count(*) tax_count
1941: from ar_ae_alloc_rec_gt b3
1942: where b3.ae_id = g_id
1961: AND det.ref_cust_trx_line_gl_dist_id = gld.cust_trx_line_gl_dist_id
1962: AND det.ledger_id = g_ae_sys_rec.set_of_books_id
1963: AND det.gt_id = g_id;
1964: /* and not exists (select 'x'
1965: from ra_customer_trx_lines ctl1
1966: where ctl1.customer_trx_id = p_invoice_id
1967: and ctl1.autorule_complete_flag = 'N') */
1968: -- group by decode(gld.account_class,
1969: -- 'REV' ,'REVEARN',
8038:
8039: select sum(a1.tax_count)
8040: into l_count
8041: from (select 1 tax_count
8042: from ra_customer_trx_lines a2
8043: where a2.line_type = 'TAX'
8044: and a2.link_to_cust_trx_line_id = p_invoice_line_id
8045: group by nvl(a2.location_segment_id, a2.vat_tax_id),
8046: decode(a2.location_segment_id,
8932: arp_etax_util.get_tax_account(tl.customer_trx_line_id,
8933: trunc(sysdate),
8934: 'FINCHRG',
8935: 'TAX_LINE')
8936: FROM ra_customer_trx_lines tl
8937: WHERE tl.customer_trx_id = p_customer_trx_id
8938: AND tl.line_type = 'TAX'
8939: AND tl.tax_line_id IS NOT NULL;
8940: