APPS.ARP_ETAX_INVAPI_UTIL dependencies on ZX_TRX_HEADERS_GT

Line 33: /* Private Procedure - Inserts headers into ZX_TRX_HEADERS_GT

29: -- fnd_file.put_line(FND_FILE.LOG, text);
30: arp_standard.debug(text);
31: END;
32:
33: /* Private Procedure - Inserts headers into ZX_TRX_HEADERS_GT
34:
35: 15-MAY-07 MRAYMOND 6033706 Added document_sub_type and
36: default_taxation_country
37: */

Line 50: INSERT INTO ZX_TRX_HEADERS_GT

46: /* 4666566 added ship_to columns. Note that invoice API
47: only supports ship_to at header level at this time
48: */
49:
50: INSERT INTO ZX_TRX_HEADERS_GT
51: (
52: internal_organization_id,
53: internal_org_location_id,
54: legal_entity_id,

Line 171: UPDATE ZX_TRX_HEADERS_GT HGT

167: g_headers_inserted := SQL%ROWCOUNT;
168:
169: /* 6033706 - set document_sub_type and default_taxaction_country */
170: /* also set tax_reporting_flag */
171: UPDATE ZX_TRX_HEADERS_GT HGT
172: SET (document_sub_type, default_taxation_country,
173: tax_reporting_flag) =
174: (SELECT MAX(document_sub_type),
175: MAX(default_taxation_country),

Line 374: ZX_TRX_HEADERS_GT ZTH,

370: FROM
371: RA_CUSTOMER_TRX_LINES TL,
372: RA_CUSTOMER_TRX T,
373: AR_TRX_LINES_GT TLG,
374: ZX_TRX_HEADERS_GT ZTH,
375: HZ_CUST_ACCOUNTS STCA,
376: HZ_CUST_ACCT_SITES STPS,
377: HZ_CUST_SITE_USES STCSU,
378: RA_CUST_TRX_LINE_GL_DIST REC,

Line 510: ZX_TRX_HEADERS_GT ZTH

506: 'N', -- no lines in LINK table
507: GTL.trx_line_id -- 4698302
508: FROM
509: AR_TRX_LINES_GT GTL, -- tax lines
510: ZX_TRX_HEADERS_GT ZTH
511: WHERE
512: GTL.line_type = 'TAX'
513: AND GTL.customer_trx_id = ZTH.trx_id;
514:

Line 572: /* Insert lines into ZX_TRX_HEADERS_GT */

568: IF PG_DEBUG in ('Y', 'C') THEN
569: debug('arp_etax_invapi_util.populate_ebt_gt()+');
570: END IF;
571:
572: /* Insert lines into ZX_TRX_HEADERS_GT */
573: insert_headers(p_request_id);
574:
575: /* Insert lines into ZX_TRANSACTION_LINES_GT */
576: insert_lines(p_request_id);