28:
29: PROCEDURE debug(text IN VARCHAR2) IS
30: BEGIN
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:
931: )
932: SELECT
933: NVL(mtax.interface_line_id,ra_customer_trx_lines_s.nextval),
934: sysdate,
935: arp_standard.profile.user_id,
936: sysdate,
937: arp_standard.profile.user_id,
938: arp_standard.profile.user_id,
939: arp_standard.profile.program_id,
933: NVL(mtax.interface_line_id,ra_customer_trx_lines_s.nextval),
934: sysdate,
935: arp_standard.profile.user_id,
936: sysdate,
937: arp_standard.profile.user_id,
938: arp_standard.profile.user_id,
939: arp_standard.profile.program_id,
940: arp_standard.application_id,
941: zxt.trx_id,
934: sysdate,
935: arp_standard.profile.user_id,
936: sysdate,
937: arp_standard.profile.user_id,
938: arp_standard.profile.user_id,
939: arp_standard.profile.program_id,
940: arp_standard.application_id,
941: zxt.trx_id,
942: zxt.tax_line_number,
935: arp_standard.profile.user_id,
936: sysdate,
937: arp_standard.profile.user_id,
938: arp_standard.profile.user_id,
939: arp_standard.profile.program_id,
940: arp_standard.application_id,
941: zxt.trx_id,
942: zxt.tax_line_number,
943: arp_standard.sysparm.set_of_books_id,
936: sysdate,
937: arp_standard.profile.user_id,
938: arp_standard.profile.user_id,
939: arp_standard.profile.program_id,
940: arp_standard.application_id,
941: zxt.trx_id,
942: zxt.tax_line_number,
943: arp_standard.sysparm.set_of_books_id,
944: 'TAX',
939: arp_standard.profile.program_id,
940: arp_standard.application_id,
941: zxt.trx_id,
942: zxt.tax_line_number,
943: arp_standard.sysparm.set_of_books_id,
944: 'TAX',
945: zxt.trx_line_id,
946: plin.default_ussgl_transaction_code,
947: p_request_id,