APPS.ARP_ETAX_AUTOINV_UTIL dependencies on RA_CUSTOMER_TRX_LINES

Line 410: RA_CUSTOMER_TRX_LINES TL,

406: AND gld.account_class = 'REV'
407: AND gld.request_id = tl.request_id) account_ccid,
408: TL.description
409: FROM
410: RA_CUSTOMER_TRX_LINES TL,
411: RA_CUSTOMER_TRX T,
412: RA_INTERFACE_LINES RIL,
413: ZX_TRX_HEADERS_GT ZTH,
414: HZ_CUST_ACCOUNTS STCA,

Line 419: RA_CUSTOMER_TRX_LINES ITL,

415: HZ_CUST_ACCT_SITES STPS,
416: HZ_CUST_SITE_USES STCSU,
417: RA_CUSTOMER_TRX IT,
418: RA_CUST_TRX_TYPES ITT,
419: RA_CUSTOMER_TRX_LINES ITL,
420: RA_CUST_TRX_LINE_GL_DIST REC,
421: HZ_PARTY_SITES STPSU,
422: HZ_PARTY_SITES BTPSU,
423: HR_ALL_ORGANIZATION_UNITS HR,

Line 839: RA_CUSTOMER_TRX_LINES accordingly

835:
836: END populate_ebt_gt;
837:
838: /* Procedure to retrieve TAX lines from ZX and populate
839: RA_CUSTOMER_TRX_LINES accordingly
840:
841: 06-JAN-2006 M Raymond 4740826 - Added code to retrieve
842: tax classifications back
843: from etax and stamp them

Line 881: corresponding line in ra_customer_trx_lines.

877: 3-MAR-05 along with my suggestion which was to have them add
878: a 45th column for link_to_trx_line_id or perhaps applied_to_trx_line_id
879: The idea for this is that they pass me the eTax line_id of the target
880: tax line and I use that to fetch the customer_trx_line_id of the
881: corresponding line in ra_customer_trx_lines.
882:
883: However, I'll probably need an index based on tax_line_id in
884: RA_CUSTOMER_TRX_LINES table to make that search fast enough
885:

Line 884: RA_CUSTOMER_TRX_LINES table to make that search fast enough

880: tax line and I use that to fetch the customer_trx_line_id of the
881: corresponding line in ra_customer_trx_lines.
882:
883: However, I'll probably need an index based on tax_line_id in
884: RA_CUSTOMER_TRX_LINES table to make that search fast enough
885:
886: RESP: They are now allowing me to pass the interface_line_id
887: of the invoice lines and tax lines in -- and they pass them back
888: out. This should be enough to let me get what I need from

Line 902: /* Insert rows into RA_CUSTOMER_TRX_LINES for the

898: 6) ORA-28115 raised because we were not setting org_id
899: End Dev Notes */
900:
901:
902: /* Insert rows into RA_CUSTOMER_TRX_LINES for the
903: new TAX lines */
904: INSERT INTO RA_CUSTOMER_TRX_LINES
905: (
906: CUSTOMER_TRX_LINE_ID,

Line 904: INSERT INTO RA_CUSTOMER_TRX_LINES

900:
901:
902: /* Insert rows into RA_CUSTOMER_TRX_LINES for the
903: new TAX lines */
904: INSERT INTO RA_CUSTOMER_TRX_LINES
905: (
906: CUSTOMER_TRX_LINE_ID,
907: LAST_UPDATE_DATE,
908: LAST_UPDATED_BY,

Line 949: NVL(mtax.interface_line_id,ra_customer_trx_lines_s.nextval),

945: INTERFACE_LINE_ATTRIBUTE15,
946: ORG_ID
947: )
948: SELECT
949: NVL(mtax.interface_line_id,ra_customer_trx_lines_s.nextval),
950: sysdate,
951: arp_standard.profile.user_id,
952: sysdate,
953: arp_standard.profile.user_id,

Line 993: RA_CUSTOMER_TRX_LINES plin,

989: mtax.interface_line_attribute14,
990: mtax.interface_line_attribute15,
991: plin.org_id
992: FROM ZX_LINES zxt,
993: RA_CUSTOMER_TRX_LINES plin,
994: RA_INTERFACE_LINES mtax,
995: ZX_LINES inv_zxt,
996: RA_CUSTOMER_TRX_LINES inv_lin
997: WHERE plin.request_id = p_request_id

Line 996: RA_CUSTOMER_TRX_LINES inv_lin

992: FROM ZX_LINES zxt,
993: RA_CUSTOMER_TRX_LINES plin,
994: RA_INTERFACE_LINES mtax,
995: ZX_LINES inv_zxt,
996: RA_CUSTOMER_TRX_LINES inv_lin
997: WHERE plin.request_id = p_request_id
998: AND zxt.application_id = 222
999: AND zxt.entity_code = 'TRANSACTIONS'
1000: AND zxt.event_class_code in ('INVOICE','DEBIT_MEMO','CREDIT_MEMO')

Line 1182: /* Pull resulting tax lines and populate RA_CUSTOMER_TRX_LINES */

1178: THEN
1179: /* retrieve validation errors and populate RA_INTERFACE_ERRORS */
1180: retrieve_tax_validation_errors(p_error_count);
1181:
1182: /* Pull resulting tax lines and populate RA_CUSTOMER_TRX_LINES */
1183: build_ar_tax_lines(p_request_id, p_phase);
1184: END IF;
1185:
1186: IF PG_DEBUG in ('Y', 'C')