[Home] [Help]
31: fnd_file.put_line(FND_FILE.LOG, text);
32: -- arp_standard.debug(text);
33: END;
34:
35: /* Private Procedure - Inserts headers into ZX_TRX_HEADERS_GT
36:
37: 15-MAY-07 MRAYMOND 6033706 Added document_sub_type and
38: default_taxation_country
39: */
45: IF PG_DEBUG in ('Y', 'C') THEN
46: debug('arp_etax_autoinv_util.insert_headers()+');
47: END IF;
48:
49: INSERT INTO ZX_TRX_HEADERS_GT
50: (
51: internal_organization_id,
52: internal_org_location_id,
53: legal_entity_id,
169: g_headers_inserted := SQL%ROWCOUNT;
170:
171: /* 6033706 - set document_sub_type and default_taxaction_country */
172: /* also set tax_reporting_flag when necessary */
173: UPDATE ZX_TRX_HEADERS_GT HGT
174: SET (document_sub_type, default_taxation_country,
175: tax_reporting_flag) =
176: (SELECT MAX(document_sub_type),
177: MAX(default_taxation_country),
394: FROM
395: RA_CUSTOMER_TRX_LINES TL,
396: RA_CUSTOMER_TRX T,
397: RA_INTERFACE_LINES RIL,
398: ZX_TRX_HEADERS_GT ZTH,
399: HZ_CUST_ACCOUNTS STCA,
400: HZ_CUST_ACCT_SITES STPS,
401: HZ_CUST_SITE_USES STCSU,
402: RA_CUSTOMER_TRX IT,
519: debug('arp_etax_autoinv_util.insert_tax_lines()+');
520: END IF;
521:
522: /* Note that this code does not directly use p_phase
523: However, it does join to ZX_TRX_HEADERS_GT which
524: would implicitly restrict the appearance of
525: INV rows in CM phase. */
526:
527: INSERT INTO ZX_IMPORT_TAX_LINES_GT
573: 'N', -- no rows in zx_trx_tax_link_gt
574: RIL.interface_line_id -- 4698302
575: FROM
576: RA_INTERFACE_LINES RIL, -- tax lines
577: ZX_TRX_HEADERS_GT ZTH
578: WHERE
579: RIL.line_type = 'TAX'
580: AND RIL.request_id = p_request_id
581: AND RIL.customer_trx_id = ZTH.trx_id;
762: g_ebt_gt_populated := FALSE;
763: g_tax_detected := FALSE ; -- Bug6731444 retest for manual tax
764: END IF;
765:
766: /* Insert lines into ZX_TRX_HEADERS_GT */
767: insert_headers(p_request_id, p_phase);
768:
769: /* Insert lines into ZX_TRANSACTION_LINES_GT */
770: insert_lines(p_request_id, p_phase);