eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_JA_EXTRACT_PKG dependencies on ZX_REP_TRX_JX_EXT_T

Line 33: X_INVOICE_AMT OUT NOCOPY ZX_REP_TRX_JX_EXT_T.NUMERIC12%TYPE,

29: PROCEDURE GET_INVOICE_AMT
30: (
31: P_VENDOR_ID IN NUMBER,
32: P_INVOICE_NUM IN VARCHAR2,
33: X_INVOICE_AMT OUT NOCOPY ZX_REP_TRX_JX_EXT_T.NUMERIC12%TYPE,
34: X_BASE_AMT OUT NOCOPY ZX_REP_TRX_JX_EXT_T.NUMERIC13%TYPE,
35: X_PRINT_DATE OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_AP_INVOICES_ATT4%TYPE
36: );
37:

Line 34: X_BASE_AMT OUT NOCOPY ZX_REP_TRX_JX_EXT_T.NUMERIC13%TYPE,

30: (
31: P_VENDOR_ID IN NUMBER,
32: P_INVOICE_NUM IN VARCHAR2,
33: X_INVOICE_AMT OUT NOCOPY ZX_REP_TRX_JX_EXT_T.NUMERIC12%TYPE,
34: X_BASE_AMT OUT NOCOPY ZX_REP_TRX_JX_EXT_T.NUMERIC13%TYPE,
35: X_PRINT_DATE OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_AP_INVOICES_ATT4%TYPE
36: );
37:
38: PROCEDURE UPDATE_PRINT_DATE

Line 35: X_PRINT_DATE OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_AP_INVOICES_ATT4%TYPE

31: P_VENDOR_ID IN NUMBER,
32: P_INVOICE_NUM IN VARCHAR2,
33: X_INVOICE_AMT OUT NOCOPY ZX_REP_TRX_JX_EXT_T.NUMERIC12%TYPE,
34: X_BASE_AMT OUT NOCOPY ZX_REP_TRX_JX_EXT_T.NUMERIC13%TYPE,
35: X_PRINT_DATE OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_AP_INVOICES_ATT4%TYPE
36: );
37:
38: PROCEDURE UPDATE_PRINT_DATE
39: (

Line 47: X_GDF_RA_BATCH_SOURCES_ATT1 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT1%TYPE, -- reference transaction source

43:
44: PROCEDURE GET_GUI_SOURCE
45: (
46: P_TRX_SOURCE_NAME IN VARCHAR2,
47: X_GDF_RA_BATCH_SOURCES_ATT1 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT1%TYPE, -- reference transaction source
48: X_GDF_RA_BATCH_SOURCES_ATT2 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT2%TYPE, -- initial trx num
49: X_GDF_RA_BATCH_SOURCES_ATT3 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT3%TYPE, -- invoice word
50: X_GDF_RA_BATCH_SOURCES_ATT4 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT4%TYPE -- final trx num
51: );

Line 48: X_GDF_RA_BATCH_SOURCES_ATT2 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT2%TYPE, -- initial trx num

44: PROCEDURE GET_GUI_SOURCE
45: (
46: P_TRX_SOURCE_NAME IN VARCHAR2,
47: X_GDF_RA_BATCH_SOURCES_ATT1 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT1%TYPE, -- reference transaction source
48: X_GDF_RA_BATCH_SOURCES_ATT2 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT2%TYPE, -- initial trx num
49: X_GDF_RA_BATCH_SOURCES_ATT3 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT3%TYPE, -- invoice word
50: X_GDF_RA_BATCH_SOURCES_ATT4 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT4%TYPE -- final trx num
51: );
52:

Line 49: X_GDF_RA_BATCH_SOURCES_ATT3 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT3%TYPE, -- invoice word

45: (
46: P_TRX_SOURCE_NAME IN VARCHAR2,
47: X_GDF_RA_BATCH_SOURCES_ATT1 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT1%TYPE, -- reference transaction source
48: X_GDF_RA_BATCH_SOURCES_ATT2 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT2%TYPE, -- initial trx num
49: X_GDF_RA_BATCH_SOURCES_ATT3 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT3%TYPE, -- invoice word
50: X_GDF_RA_BATCH_SOURCES_ATT4 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT4%TYPE -- final trx num
51: );
52:
53:

Line 50: X_GDF_RA_BATCH_SOURCES_ATT4 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT4%TYPE -- final trx num

46: P_TRX_SOURCE_NAME IN VARCHAR2,
47: X_GDF_RA_BATCH_SOURCES_ATT1 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT1%TYPE, -- reference transaction source
48: X_GDF_RA_BATCH_SOURCES_ATT2 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT2%TYPE, -- initial trx num
49: X_GDF_RA_BATCH_SOURCES_ATT3 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT3%TYPE, -- invoice word
50: X_GDF_RA_BATCH_SOURCES_ATT4 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT4%TYPE -- final trx num
51: );
52:
53:
54: PROCEDURE GET_ORG_TRX_NUMBER

Line 58: X_ORG_TRX_NUMBER OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT9%TYPE -- org trx num

54: PROCEDURE GET_ORG_TRX_NUMBER
55: (
56: P_TRX_SOURCE_ID IN NUMBER,
57: P_TRX_ID IN NUMBER,
58: X_ORG_TRX_NUMBER OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT9%TYPE -- org trx num
59: );
60:
61:
62: PROCEDURE GET_EXPORT_INFO

Line 65: X_GDF_RA_CUST_TRX_ATT4 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT4%TYPE, -- export certificate number

61:
62: PROCEDURE GET_EXPORT_INFO
63: (
64: P_TRX_ID IN NUMBER,
65: X_GDF_RA_CUST_TRX_ATT4 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT4%TYPE, -- export certificate number
66: X_GDF_RA_CUST_TRX_ATT5 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT5%TYPE, -- export name
67: X_GDF_RA_CUST_TRX_ATT6 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT6%TYPE, -- export method
68: X_GDF_RA_CUST_TRX_ATT7 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT7%TYPE, -- export type
69: X_GDF_RA_CUST_TRX_ATT8 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT8%TYPE -- export date

Line 66: X_GDF_RA_CUST_TRX_ATT5 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT5%TYPE, -- export name

62: PROCEDURE GET_EXPORT_INFO
63: (
64: P_TRX_ID IN NUMBER,
65: X_GDF_RA_CUST_TRX_ATT4 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT4%TYPE, -- export certificate number
66: X_GDF_RA_CUST_TRX_ATT5 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT5%TYPE, -- export name
67: X_GDF_RA_CUST_TRX_ATT6 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT6%TYPE, -- export method
68: X_GDF_RA_CUST_TRX_ATT7 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT7%TYPE, -- export type
69: X_GDF_RA_CUST_TRX_ATT8 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT8%TYPE -- export date
70: );

Line 67: X_GDF_RA_CUST_TRX_ATT6 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT6%TYPE, -- export method

63: (
64: P_TRX_ID IN NUMBER,
65: X_GDF_RA_CUST_TRX_ATT4 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT4%TYPE, -- export certificate number
66: X_GDF_RA_CUST_TRX_ATT5 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT5%TYPE, -- export name
67: X_GDF_RA_CUST_TRX_ATT6 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT6%TYPE, -- export method
68: X_GDF_RA_CUST_TRX_ATT7 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT7%TYPE, -- export type
69: X_GDF_RA_CUST_TRX_ATT8 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT8%TYPE -- export date
70: );
71:

Line 68: X_GDF_RA_CUST_TRX_ATT7 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT7%TYPE, -- export type

64: P_TRX_ID IN NUMBER,
65: X_GDF_RA_CUST_TRX_ATT4 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT4%TYPE, -- export certificate number
66: X_GDF_RA_CUST_TRX_ATT5 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT5%TYPE, -- export name
67: X_GDF_RA_CUST_TRX_ATT6 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT6%TYPE, -- export method
68: X_GDF_RA_CUST_TRX_ATT7 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT7%TYPE, -- export type
69: X_GDF_RA_CUST_TRX_ATT8 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT8%TYPE -- export date
70: );
71:
72: --

Line 69: X_GDF_RA_CUST_TRX_ATT8 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT8%TYPE -- export date

65: X_GDF_RA_CUST_TRX_ATT4 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT4%TYPE, -- export certificate number
66: X_GDF_RA_CUST_TRX_ATT5 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT5%TYPE, -- export name
67: X_GDF_RA_CUST_TRX_ATT6 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT6%TYPE, -- export method
68: X_GDF_RA_CUST_TRX_ATT7 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT7%TYPE, -- export type
69: X_GDF_RA_CUST_TRX_ATT8 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT8%TYPE -- export date
70: );
71:
72: --
73:

Line 780: ZX_REP_TRX_JX_EXT_T.TAX_STATUS_MNG%TYPE INDEX BY BINARY_INTEGER;

776: P_LOOKUP_TYPE varchar2(500);
777: P_LOOKUP_CODE varchar2(1000); --Bug 5453806
778:
779: TYPE GOVERNMENT_TAX_TYPE_TBL is TABLE OF
780: ZX_REP_TRX_JX_EXT_T.TAX_STATUS_MNG%TYPE INDEX BY BINARY_INTEGER;
781:
782: TYPE DEDUCTIBLE_TYPE_TBL is TABLE OF
783: ZX_REP_TRX_JX_EXT_T.TRX_BUSINESS_CATEGORY_MNG%TYPE INDEX BY BINARY_INTEGER;
784:

Line 783: ZX_REP_TRX_JX_EXT_T.TRX_BUSINESS_CATEGORY_MNG%TYPE INDEX BY BINARY_INTEGER;

779: TYPE GOVERNMENT_TAX_TYPE_TBL is TABLE OF
780: ZX_REP_TRX_JX_EXT_T.TAX_STATUS_MNG%TYPE INDEX BY BINARY_INTEGER;
781:
782: TYPE DEDUCTIBLE_TYPE_TBL is TABLE OF
783: ZX_REP_TRX_JX_EXT_T.TRX_BUSINESS_CATEGORY_MNG%TYPE INDEX BY BINARY_INTEGER;
784:
785: TYPE EXPORT_METHOD_TBL is TABLE OF
786: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER;
787:

Line 786: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER;

782: TYPE DEDUCTIBLE_TYPE_TBL is TABLE OF
783: ZX_REP_TRX_JX_EXT_T.TRX_BUSINESS_CATEGORY_MNG%TYPE INDEX BY BINARY_INTEGER;
784:
785: TYPE EXPORT_METHOD_TBL is TABLE OF
786: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER;
787:
788: TYPE EXPORT_CERTIFICATE_NAME_TBL is TABLE OF
789: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER;
790:

Line 789: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER;

785: TYPE EXPORT_METHOD_TBL is TABLE OF
786: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER;
787:
788: TYPE EXPORT_CERTIFICATE_NAME_TBL is TABLE OF
789: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER;
790:
791: TYPE EXPORT_TYPE_TBL is TABLE OF
792: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER;
793:

Line 792: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER;

788: TYPE EXPORT_CERTIFICATE_NAME_TBL is TABLE OF
789: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER;
790:
791: TYPE EXPORT_TYPE_TBL is TABLE OF
792: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER;
793:
794: TYPE INVOICE_WORD_TBL is TABLE OF
795: ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT3%TYPE INDEX BY BINARY_INTEGER;
796:

Line 795: ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT3%TYPE INDEX BY BINARY_INTEGER;

791: TYPE EXPORT_TYPE_TBL is TABLE OF
792: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER;
793:
794: TYPE INVOICE_WORD_TBL is TABLE OF
795: ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT3%TYPE INDEX BY BINARY_INTEGER;
796:
797: TYPE INITIAL_TRX_NUM_TBL is TABLE OF
798: ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT2%TYPE INDEX BY BINARY_INTEGER;
799:

Line 798: ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT2%TYPE INDEX BY BINARY_INTEGER;

794: TYPE INVOICE_WORD_TBL is TABLE OF
795: ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT3%TYPE INDEX BY BINARY_INTEGER;
796:
797: TYPE INITIAL_TRX_NUM_TBL is TABLE OF
798: ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT2%TYPE INDEX BY BINARY_INTEGER;
799:
800: TYPE FINAL_TRX_NUM_TBL is TABLE OF
801: ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT4%TYPE INDEX BY BINARY_INTEGER;
802:

Line 801: ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT4%TYPE INDEX BY BINARY_INTEGER;

797: TYPE INITIAL_TRX_NUM_TBL is TABLE OF
798: ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT2%TYPE INDEX BY BINARY_INTEGER;
799:
800: TYPE FINAL_TRX_NUM_TBL is TABLE OF
801: ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT4%TYPE INDEX BY BINARY_INTEGER;
802:
803: TYPE REFERENCE_TRX_SRC_TBL is TABLE OF
804: ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT1%TYPE INDEX BY BINARY_INTEGER;
805:

Line 804: ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT1%TYPE INDEX BY BINARY_INTEGER;

800: TYPE FINAL_TRX_NUM_TBL is TABLE OF
801: ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT4%TYPE INDEX BY BINARY_INTEGER;
802:
803: TYPE REFERENCE_TRX_SRC_TBL is TABLE OF
804: ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT1%TYPE INDEX BY BINARY_INTEGER;
805:
806: TYPE ORG_TRX_NUMBER_TBL is TABLE OF
807: ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT9%TYPE INDEX BY BINARY_INTEGER;
808:

Line 807: ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT9%TYPE INDEX BY BINARY_INTEGER;

803: TYPE REFERENCE_TRX_SRC_TBL is TABLE OF
804: ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT1%TYPE INDEX BY BINARY_INTEGER;
805:
806: TYPE ORG_TRX_NUMBER_TBL is TABLE OF
807: ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT9%TYPE INDEX BY BINARY_INTEGER;
808:
809: TYPE GDF_RA_CUST_TRX_ATT4_TBL is TABLE OF
810: ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT4%TYPE INDEX BY BINARY_INTEGER;
811:

Line 810: ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT4%TYPE INDEX BY BINARY_INTEGER;

806: TYPE ORG_TRX_NUMBER_TBL is TABLE OF
807: ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT9%TYPE INDEX BY BINARY_INTEGER;
808:
809: TYPE GDF_RA_CUST_TRX_ATT4_TBL is TABLE OF
810: ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT4%TYPE INDEX BY BINARY_INTEGER;
811:
812: TYPE GDF_RA_CUST_TRX_ATT5_TBL is TABLE OF
813: ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT5%TYPE INDEX BY BINARY_INTEGER;
814:

Line 813: ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT5%TYPE INDEX BY BINARY_INTEGER;

809: TYPE GDF_RA_CUST_TRX_ATT4_TBL is TABLE OF
810: ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT4%TYPE INDEX BY BINARY_INTEGER;
811:
812: TYPE GDF_RA_CUST_TRX_ATT5_TBL is TABLE OF
813: ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT5%TYPE INDEX BY BINARY_INTEGER;
814:
815: TYPE GDF_RA_CUST_TRX_ATT6_TBL is TABLE OF
816: ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT6%TYPE INDEX BY BINARY_INTEGER;
817:

Line 816: ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT6%TYPE INDEX BY BINARY_INTEGER;

812: TYPE GDF_RA_CUST_TRX_ATT5_TBL is TABLE OF
813: ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT5%TYPE INDEX BY BINARY_INTEGER;
814:
815: TYPE GDF_RA_CUST_TRX_ATT6_TBL is TABLE OF
816: ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT6%TYPE INDEX BY BINARY_INTEGER;
817:
818: TYPE GDF_RA_CUST_TRX_ATT7_TBL is TABLE OF
819: ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT7%TYPE INDEX BY BINARY_INTEGER;
820:

Line 819: ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT7%TYPE INDEX BY BINARY_INTEGER;

815: TYPE GDF_RA_CUST_TRX_ATT6_TBL is TABLE OF
816: ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT6%TYPE INDEX BY BINARY_INTEGER;
817:
818: TYPE GDF_RA_CUST_TRX_ATT7_TBL is TABLE OF
819: ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT7%TYPE INDEX BY BINARY_INTEGER;
820:
821: TYPE GDF_RA_CUST_TRX_ATT8_TBL is TABLE OF
822: ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT7%TYPE INDEX BY BINARY_INTEGER;
823:

Line 822: ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT7%TYPE INDEX BY BINARY_INTEGER;

818: TYPE GDF_RA_CUST_TRX_ATT7_TBL is TABLE OF
819: ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT7%TYPE INDEX BY BINARY_INTEGER;
820:
821: TYPE GDF_RA_CUST_TRX_ATT8_TBL is TABLE OF
822: ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT7%TYPE INDEX BY BINARY_INTEGER;
823:
824: TYPE CNT_TAXABLE_AMT_TBL is TABLE OF
825: ZX_REP_TRX_JX_EXT_T.NUMERIC1%TYPE INDEX BY BINARY_INTEGER;
826:

Line 825: ZX_REP_TRX_JX_EXT_T.NUMERIC1%TYPE INDEX BY BINARY_INTEGER;

821: TYPE GDF_RA_CUST_TRX_ATT8_TBL is TABLE OF
822: ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT7%TYPE INDEX BY BINARY_INTEGER;
823:
824: TYPE CNT_TAXABLE_AMT_TBL is TABLE OF
825: ZX_REP_TRX_JX_EXT_T.NUMERIC1%TYPE INDEX BY BINARY_INTEGER;
826:
827: TYPE WINE_CIGARETTE_TBL is TABLE OF
828: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
829:

Line 828: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;

824: TYPE CNT_TAXABLE_AMT_TBL is TABLE OF
825: ZX_REP_TRX_JX_EXT_T.NUMERIC1%TYPE INDEX BY BINARY_INTEGER;
826:
827: TYPE WINE_CIGARETTE_TBL is TABLE OF
828: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
829:
830: TYPE ATTRIBUTE1_TBL is TABLE OF
831: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
832:

Line 831: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;

827: TYPE WINE_CIGARETTE_TBL is TABLE OF
828: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
829:
830: TYPE ATTRIBUTE1_TBL is TABLE OF
831: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
832:
833:
834: X_GOVERNMENT_TAX_TYPE_TBL GOVERNMENT_TAX_TYPE_TBL;
835: X_DEDUCTIBLE_TYPE_TBL DEDUCTIBLE_TYPE_TBL;

Line 954: INSERT INTO ZX_REP_TRX_JX_EXT_T

950:
951: /****** Bulk Insert into Ext Table *******/
952: FORALL i in 1 .. nvl(l_detail_tax_line_id_tbl.last, 0)
953:
954: INSERT INTO ZX_REP_TRX_JX_EXT_T
955: (detail_tax_line_ext_id,
956: detail_tax_line_id,
957: tax_status_mng, -- government tax type meaning
958: trx_business_category_mng, -- deductible code meaning

Line 965: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

961: last_updated_by,
962: last_update_date,
963: last_update_login,
964: request_id)
965: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
966: l_detail_tax_line_id_tbl(i),
967: X_GOVERNMENT_TAX_TYPE_TBL(i),
968: X_DEDUCTIBLE_TYPE_TBL(i),
969: fnd_global.user_id,

Line 1020: INSERT INTO ZX_REP_TRX_JX_EXT_T

1016: /****** Bulk Insert into Ext Table *******/
1017:
1018: FORALL i in 1 .. nvl(l_detail_tax_line_id_tbl.last, 0)
1019:
1020: INSERT INTO ZX_REP_TRX_JX_EXT_T
1021: (detail_tax_line_ext_id,
1022: detail_tax_line_id,
1023: tax_status_mng, -- government tax type meaning
1024: gdf_ra_cust_trx_att9, -- orginal transaction number ZXTWRUIL

Line 1036: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

1032: last_updated_by,
1033: last_update_date,
1034: last_update_login,
1035: request_id)
1036: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
1037: l_detail_tax_line_id_tbl(i),
1038: X_GOVERNMENT_TAX_TYPE_TBL(i),
1039: X_ORG_TRX_NUMBER_TBL(i),
1040: X_REFERENCE_TRX_SRC_TBL(i),

Line 1054: 'After insertion into zx_rep_trx_jx_ext_t ');

1050: p_trl_global_variables_rec.request_id);
1051:
1052: IF ( g_level_statement>= g_current_runtime_level ) THEN
1053: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar',
1054: 'After insertion into zx_rep_trx_jx_ext_t ');
1055: END IF;
1056: elsif P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME = 'ZXTWRZTR' and l_detail_tax_line_id_tbl.count <> 0 then
1057:
1058: /****** Populate the missing columns ********/

Line 1085: INSERT INTO ZX_REP_TRX_JX_EXT_T

1081: /****** Bulk Insert into Ext Table *******/
1082:
1083: FORALL i in 1 .. nvl(l_detail_tax_line_id_tbl.last, 0)
1084:
1085: INSERT INTO ZX_REP_TRX_JX_EXT_T
1086: (detail_tax_line_ext_id,
1087: detail_tax_line_id,
1088: attribute4, -- export method
1089: attribute5, -- export certificate name

Line 1102: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

1098: last_updated_by,
1099: last_update_date,
1100: last_update_login,
1101: request_id)
1102: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
1103: l_detail_tax_line_id_tbl(i),
1104: X_EXPORT_METHOD_TBL(i),
1105: X_EXPORT_CERTIFICATE_NAME_TBL(i),
1106: X_EXPORT_TYPE_TBL(i),

Line 1121: 'After insertion into zx_rep_trx_jx_ext_t ');

1117: p_trl_global_variables_rec.request_id);
1118:
1119: IF ( g_level_statement>= g_current_runtime_level ) THEN
1120: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar',
1121: 'After insertion into zx_rep_trx_jx_ext_t ');
1122: END IF;
1123: elsif P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME = 'ZXTWSEDI' and l_detail_tax_line_id_tbl.count <> 0 then
1124: INSERT INTO ZX_REP_TRX_JX_EXT_T(
1125: detail_tax_line_ext_id,

Line 1124: INSERT INTO ZX_REP_TRX_JX_EXT_T(

1120: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar',
1121: 'After insertion into zx_rep_trx_jx_ext_t ');
1122: END IF;
1123: elsif P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME = 'ZXTWSEDI' and l_detail_tax_line_id_tbl.count <> 0 then
1124: INSERT INTO ZX_REP_TRX_JX_EXT_T(
1125: detail_tax_line_ext_id,
1126: detail_tax_line_id,
1127: document_sub_type_mng,
1128: created_by,

Line 1136: zx_rep_trx_jx_ext_t_s.nextval,

1132: last_update_login,
1133: request_id
1134: )
1135: SELECT
1136: zx_rep_trx_jx_ext_t_s.nextval,
1137: dtl.detail_tax_line_id,
1138: types.global_attribute1,
1139: fnd_global.user_id,
1140: sysdate,

Line 1154: 'After insertion into zx_rep_trx_jx_ext_t ');

1150: and types.org_id = dtl.internal_organization_id ;
1151:
1152: IF ( g_level_statement>= g_current_runtime_level ) THEN
1153: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar',
1154: 'After insertion into zx_rep_trx_jx_ext_t ');
1155: END IF;
1156: elsif P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME = 'RXZXKVAT' THEN
1157:
1158: SELECT loc.location_code,

Line 1234: INSERT INTO ZX_REP_TRX_JX_EXT_T

1230:
1231:
1232: FORALL i in 1 .. nvl(l_detail_tax_line_id_tbl.last, 0)
1233:
1234: INSERT INTO ZX_REP_TRX_JX_EXT_T
1235: (detail_tax_line_ext_id,
1236: detail_tax_line_id,
1237: attribute1,
1238: attribute2,

Line 1256: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

1252: last_updated_by,
1253: last_update_date,
1254: last_update_login,
1255: request_id)
1256: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
1257: l_detail_tax_line_id_tbl(i),
1258: l_location_code_tbl(i),
1259: l_address_line_1_tbl(i),
1260: l_address_line_2_tbl(i),

Line 1284: 'After insertion into zx_rep_trx_jx_ext_t ');

1280: end if;
1281:
1282: IF ( g_level_statement>= g_current_runtime_level ) THEN
1283: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar',
1284: 'After insertion into zx_rep_trx_jx_ext_t ');
1285: END IF;
1286:
1287: IF (g_level_procedure >= g_current_runtime_level ) THEN
1288: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar.END',

Line 1352: ZX_REP_TRX_JX_EXT_T.TAX_STATUS_MNG%TYPE INDEX BY BINARY_INTEGER;

1348: IS
1349:
1350:
1351: TYPE GOVERNMENT_TAX_TYPE_TBL is TABLE OF
1352: ZX_REP_TRX_JX_EXT_T.TAX_STATUS_MNG%TYPE INDEX BY BINARY_INTEGER;
1353:
1354: TYPE DEDUCTIBLE_TYPE_TBL is TABLE OF
1355: ZX_REP_TRX_JX_EXT_T.TRX_BUSINESS_CATEGORY_MNG%TYPE INDEX BY BINARY_INTEGER;
1356:

Line 1355: ZX_REP_TRX_JX_EXT_T.TRX_BUSINESS_CATEGORY_MNG%TYPE INDEX BY BINARY_INTEGER;

1351: TYPE GOVERNMENT_TAX_TYPE_TBL is TABLE OF
1352: ZX_REP_TRX_JX_EXT_T.TAX_STATUS_MNG%TYPE INDEX BY BINARY_INTEGER;
1353:
1354: TYPE DEDUCTIBLE_TYPE_TBL is TABLE OF
1355: ZX_REP_TRX_JX_EXT_T.TRX_BUSINESS_CATEGORY_MNG%TYPE INDEX BY BINARY_INTEGER;
1356:
1357: TYPE GUI_TYPE_TBL is TABLE OF
1358: ZX_REP_TRX_JX_EXT_T.DOCUMENT_SUB_TYPE_MNG%TYPE INDEX BY BINARY_INTEGER;
1359:

Line 1358: ZX_REP_TRX_JX_EXT_T.DOCUMENT_SUB_TYPE_MNG%TYPE INDEX BY BINARY_INTEGER;

1354: TYPE DEDUCTIBLE_TYPE_TBL is TABLE OF
1355: ZX_REP_TRX_JX_EXT_T.TRX_BUSINESS_CATEGORY_MNG%TYPE INDEX BY BINARY_INTEGER;
1356:
1357: TYPE GUI_TYPE_TBL is TABLE OF
1358: ZX_REP_TRX_JX_EXT_T.DOCUMENT_SUB_TYPE_MNG%TYPE INDEX BY BINARY_INTEGER;
1359:
1360: TYPE INVOICE_AMOUNT_TBL is TABLE OF
1361: ZX_REP_TRX_JX_EXT_T.NUMERIC12%TYPE INDEX BY BINARY_INTEGER;
1362:

Line 1361: ZX_REP_TRX_JX_EXT_T.NUMERIC12%TYPE INDEX BY BINARY_INTEGER;

1357: TYPE GUI_TYPE_TBL is TABLE OF
1358: ZX_REP_TRX_JX_EXT_T.DOCUMENT_SUB_TYPE_MNG%TYPE INDEX BY BINARY_INTEGER;
1359:
1360: TYPE INVOICE_AMOUNT_TBL is TABLE OF
1361: ZX_REP_TRX_JX_EXT_T.NUMERIC12%TYPE INDEX BY BINARY_INTEGER;
1362:
1363: TYPE BASE_AMOUNT_TBL is TABLE OF
1364: ZX_REP_TRX_JX_EXT_T.NUMERIC13%TYPE INDEX BY BINARY_INTEGER;
1365:

Line 1364: ZX_REP_TRX_JX_EXT_T.NUMERIC13%TYPE INDEX BY BINARY_INTEGER;

1360: TYPE INVOICE_AMOUNT_TBL is TABLE OF
1361: ZX_REP_TRX_JX_EXT_T.NUMERIC12%TYPE INDEX BY BINARY_INTEGER;
1362:
1363: TYPE BASE_AMOUNT_TBL is TABLE OF
1364: ZX_REP_TRX_JX_EXT_T.NUMERIC13%TYPE INDEX BY BINARY_INTEGER;
1365:
1366: TYPE PRINT_DATE_TBL is TABLE OF
1367: ZX_REP_TRX_JX_EXT_T.GDF_AP_INVOICES_ATT4%TYPE INDEX BY BINARY_INTEGER;
1368:

Line 1367: ZX_REP_TRX_JX_EXT_T.GDF_AP_INVOICES_ATT4%TYPE INDEX BY BINARY_INTEGER;

1363: TYPE BASE_AMOUNT_TBL is TABLE OF
1364: ZX_REP_TRX_JX_EXT_T.NUMERIC13%TYPE INDEX BY BINARY_INTEGER;
1365:
1366: TYPE PRINT_DATE_TBL is TABLE OF
1367: ZX_REP_TRX_JX_EXT_T.GDF_AP_INVOICES_ATT4%TYPE INDEX BY BINARY_INTEGER;
1368:
1369: TYPE INHOUSE_INV_AMT_TBL is TABLE OF
1370: ZX_REP_TRX_JX_EXT_T.NUMERIC1%TYPE INDEX BY BINARY_INTEGER;
1371:

Line 1370: ZX_REP_TRX_JX_EXT_T.NUMERIC1%TYPE INDEX BY BINARY_INTEGER;

1366: TYPE PRINT_DATE_TBL is TABLE OF
1367: ZX_REP_TRX_JX_EXT_T.GDF_AP_INVOICES_ATT4%TYPE INDEX BY BINARY_INTEGER;
1368:
1369: TYPE INHOUSE_INV_AMT_TBL is TABLE OF
1370: ZX_REP_TRX_JX_EXT_T.NUMERIC1%TYPE INDEX BY BINARY_INTEGER;
1371:
1372: TYPE SUPPLIER_INV_AMT_TBL is TABLE OF
1373: ZX_REP_TRX_JX_EXT_T.NUMERIC2%TYPE INDEX BY BINARY_INTEGER;
1374:

Line 1373: ZX_REP_TRX_JX_EXT_T.NUMERIC2%TYPE INDEX BY BINARY_INTEGER;

1369: TYPE INHOUSE_INV_AMT_TBL is TABLE OF
1370: ZX_REP_TRX_JX_EXT_T.NUMERIC1%TYPE INDEX BY BINARY_INTEGER;
1371:
1372: TYPE SUPPLIER_INV_AMT_TBL is TABLE OF
1373: ZX_REP_TRX_JX_EXT_T.NUMERIC2%TYPE INDEX BY BINARY_INTEGER;
1374:
1375: TYPE INHOUSE_TAX_AMT_TBL is TABLE OF
1376: ZX_REP_TRX_JX_EXT_T.NUMERIC3%TYPE INDEX BY BINARY_INTEGER;
1377:

Line 1376: ZX_REP_TRX_JX_EXT_T.NUMERIC3%TYPE INDEX BY BINARY_INTEGER;

1372: TYPE SUPPLIER_INV_AMT_TBL is TABLE OF
1373: ZX_REP_TRX_JX_EXT_T.NUMERIC2%TYPE INDEX BY BINARY_INTEGER;
1374:
1375: TYPE INHOUSE_TAX_AMT_TBL is TABLE OF
1376: ZX_REP_TRX_JX_EXT_T.NUMERIC3%TYPE INDEX BY BINARY_INTEGER;
1377:
1378: TYPE SUPPLIER_TAX_AMT_TBL is TABLE OF
1379: ZX_REP_TRX_JX_EXT_T.NUMERIC4%TYPE INDEX BY BINARY_INTEGER;
1380:

Line 1379: ZX_REP_TRX_JX_EXT_T.NUMERIC4%TYPE INDEX BY BINARY_INTEGER;

1375: TYPE INHOUSE_TAX_AMT_TBL is TABLE OF
1376: ZX_REP_TRX_JX_EXT_T.NUMERIC3%TYPE INDEX BY BINARY_INTEGER;
1377:
1378: TYPE SUPPLIER_TAX_AMT_TBL is TABLE OF
1379: ZX_REP_TRX_JX_EXT_T.NUMERIC4%TYPE INDEX BY BINARY_INTEGER;
1380:
1381: TYPE TAXABLE_GAINLOSS_TBL is TABLE OF
1382: ZX_REP_TRX_JX_EXT_T.NUMERIC5%TYPE INDEX BY BINARY_INTEGER;
1383:

Line 1382: ZX_REP_TRX_JX_EXT_T.NUMERIC5%TYPE INDEX BY BINARY_INTEGER;

1378: TYPE SUPPLIER_TAX_AMT_TBL is TABLE OF
1379: ZX_REP_TRX_JX_EXT_T.NUMERIC4%TYPE INDEX BY BINARY_INTEGER;
1380:
1381: TYPE TAXABLE_GAINLOSS_TBL is TABLE OF
1382: ZX_REP_TRX_JX_EXT_T.NUMERIC5%TYPE INDEX BY BINARY_INTEGER;
1383:
1384: TYPE TAX_GAINLOSS_TBL is TABLE OF
1385: ZX_REP_TRX_JX_EXT_T.NUMERIC6%TYPE INDEX BY BINARY_INTEGER;
1386:

Line 1385: ZX_REP_TRX_JX_EXT_T.NUMERIC6%TYPE INDEX BY BINARY_INTEGER;

1381: TYPE TAXABLE_GAINLOSS_TBL is TABLE OF
1382: ZX_REP_TRX_JX_EXT_T.NUMERIC5%TYPE INDEX BY BINARY_INTEGER;
1383:
1384: TYPE TAX_GAINLOSS_TBL is TABLE OF
1385: ZX_REP_TRX_JX_EXT_T.NUMERIC6%TYPE INDEX BY BINARY_INTEGER;
1386:
1387: TYPE ATTRIBUTE1_TBL is TABLE OF
1388: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
1389:

Line 1388: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;

1384: TYPE TAX_GAINLOSS_TBL is TABLE OF
1385: ZX_REP_TRX_JX_EXT_T.NUMERIC6%TYPE INDEX BY BINARY_INTEGER;
1386:
1387: TYPE ATTRIBUTE1_TBL is TABLE OF
1388: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
1389:
1390: X_GOVERNMENT_TAX_TYPE_TBL GOVERNMENT_TAX_TYPE_TBL;
1391: X_DEDUCTIBLE_TYPE_TBL DEDUCTIBLE_TYPE_TBL;
1392: X_GUI_TYPE_TBL GUI_TYPE_TBL;

Line 1530: INSERT INTO ZX_REP_TRX_JX_EXT_T

1526:
1527: /****** Bulk Insert into Ext Table *******/
1528: FORALL i in 1 .. nvl(l_detail_tax_line_id_tbl.last, 0)
1529:
1530: INSERT INTO ZX_REP_TRX_JX_EXT_T
1531: (detail_tax_line_ext_id,
1532: detail_tax_line_id,
1533: tax_status_mng, -- government tax type meaning
1534: trx_business_category_mng, -- deductible code meaning

Line 1541: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

1537: last_updated_by,
1538: last_update_date,
1539: last_update_login,
1540: request_id)
1541: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
1542: l_detail_tax_line_id_tbl(i),
1543: X_GOVERNMENT_TAX_TYPE_TBL(i),
1544: X_DEDUCTIBLE_TYPE_TBL(i),
1545: fnd_global.user_id,

Line 1554: 'After insertion into zx_rep_trx_jx_ext_t ');

1550: p_trl_global_variables_rec.request_id);
1551:
1552: IF ( g_level_statement>= g_current_runtime_level ) THEN
1553: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1554: 'After insertion into zx_rep_trx_jx_ext_t ');
1555: END IF;
1556: elsif P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME = 'ZXTWSPRF' and l_detail_tax_line_id_tbl.count <> 0 then
1557:
1558: /****** Populate the missing columns ********/

Line 1602: 'Before into zx_rep_trx_jx_ext_t ap ');

1598: /****** Bulk Insert into Ext Table *******/
1599:
1600: IF ( g_level_statement>= g_current_runtime_level ) THEN
1601: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1602: 'Before into zx_rep_trx_jx_ext_t ap ');
1603: END IF;
1604:
1605: FORALL i in 1 .. nvl(l_detail_tax_line_id_tbl.last, 0)
1606:

Line 1607: INSERT INTO ZX_REP_TRX_JX_EXT_T

1603: END IF;
1604:
1605: FORALL i in 1 .. nvl(l_detail_tax_line_id_tbl.last, 0)
1606:
1607: INSERT INTO ZX_REP_TRX_JX_EXT_T
1608: (detail_tax_line_ext_id,
1609: detail_tax_line_id,
1610: tax_status_mng, -- government tax type meaning
1611: trx_business_category_mng, -- deductible code meaning

Line 1619: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

1615: last_updated_by,
1616: last_update_date,
1617: last_update_login,
1618: request_id)
1619: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
1620: l_detail_tax_line_id_tbl(i),
1621: X_GOVERNMENT_TAX_TYPE_TBL(i),
1622: X_DEDUCTIBLE_TYPE_TBL(i),
1623: X_GUI_TYPE_TBL(i),

Line 1633: 'After insertion into zx_rep_trx_jx_ext_t ');

1629: p_trl_global_variables_rec.request_id);
1630:
1631: IF ( g_level_statement>= g_current_runtime_level ) THEN
1632: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1633: 'After insertion into zx_rep_trx_jx_ext_t ');
1634: END IF;
1635: elsif P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME = ('ZXTWPSPC') and l_detail_tax_line_id_tbl.count <> 0 then
1636:
1637: /****** Populate the missing columns ********/

Line 1664: INSERT INTO ZX_REP_TRX_JX_EXT_T

1660:
1661: /****** Bulk Insert into Ext Table *******/
1662: FORALL i in 1 .. nvl(l_detail_tax_line_id_tbl.last, 0)
1663:
1664: INSERT INTO ZX_REP_TRX_JX_EXT_T
1665: (detail_tax_line_ext_id,
1666: detail_tax_line_id,
1667: gdf_ap_invoices_att4, -- print date
1668: numeric12, -- document amount

Line 1676: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

1672: last_updated_by,
1673: last_update_date,
1674: last_update_login,
1675: request_id)
1676: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
1677: l_detail_tax_line_id_tbl(i),
1678: X_PRINT_DATE_TBL(i),
1679: X_INVOICE_AMOUNT_TBL(i),
1680: X_BASE_AMOUNT_TBL(i),

Line 1690: 'After insertion into zx_rep_trx_jx_ext_t ');

1686: p_trl_global_variables_rec.request_id);
1687:
1688: IF ( g_level_statement>= g_current_runtime_level ) THEN
1689: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1690: 'After insertion into zx_rep_trx_jx_ext_t ');
1691: END IF;
1692: elsif P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME = 'ZXTWPPRD' and l_detail_tax_line_id_tbl.count <> 0 then
1693:
1694: /****** Populate the missing columns ********/

Line 1709: INSERT INTO ZX_REP_TRX_JX_EXT_T

1705:
1706: /****** Bulk Insert into Ext Table *******/
1707: FORALL i in 1 .. nvl(l_detail_tax_line_id_tbl.last, 0)
1708:
1709: INSERT INTO ZX_REP_TRX_JX_EXT_T
1710: (detail_tax_line_ext_id,
1711: detail_tax_line_id,
1712: numeric12, -- document amount
1713: numeric13, -- document base amount

Line 1720: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

1716: last_updated_by,
1717: last_update_date,
1718: last_update_login,
1719: request_id)
1720: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
1721: l_detail_tax_line_id_tbl(i),
1722: X_INVOICE_AMOUNT_TBL(i),
1723: X_BASE_AMOUNT_TBL(i),
1724: fnd_global.user_id,

Line 1733: 'After insertion into zx_rep_trx_jx_ext_t ');

1729: p_trl_global_variables_rec.request_id);
1730:
1731: IF ( g_level_statement>= g_current_runtime_level ) THEN
1732: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1733: 'After insertion into zx_rep_trx_jx_ext_t ');
1734: END IF;
1735:
1736: ELSIF P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME = 'ZXTWSEDI' AND l_detail_tax_line_id_tbl.count <> 0 then
1737:

Line 1743: INSERT INTO zx_rep_trx_jx_ext_t (

1739: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JE_AP',
1740: 'P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME : '||P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME);
1741: END IF;
1742:
1743: INSERT INTO zx_rep_trx_jx_ext_t (
1744: request_id,
1745: created_by,
1746: creation_date,
1747: last_updated_by,

Line 1765: zx_rep_trx_jx_ext_t_s.NEXTVAL,

1761: sysdate,
1762: fnd_global.user_id,
1763: sysdate,
1764: fnd_global.login_id,
1765: zx_rep_trx_jx_ext_t_s.NEXTVAL,
1766: detail_tax_line_id,
1767: document_sub_type,
1768: CASE WHEN tax_line_change= 1 OR tax_recoverable_flag = 'N' THEN taxable_amt
1769: ELSE 0

Line 1880: INSERT INTO ZX_REP_TRX_JX_EXT_T

1876:
1877: /****** Bulk Insert into Ext Table *******/
1878: FORALL i in 1 .. nvl(l_detail_tax_line_id_tbl.last, 0)
1879:
1880: INSERT INTO ZX_REP_TRX_JX_EXT_T
1881: (detail_tax_line_ext_id,
1882: detail_tax_line_id,
1883: numeric1, -- inhouse invoice amt
1884: numeric2, -- supplier invoice amt

Line 1895: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

1891: last_updated_by,
1892: last_update_date,
1893: last_update_login,
1894: request_id)
1895: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
1896: l_detail_tax_line_id_tbl(i),
1897: X_INHOUSE_INV_AMT_TBL(i),
1898: X_SUPPLIER_INV_AMT_TBL(i),
1899: X_INHOUSE_TAX_AMT_TBL(i),

Line 1912: 'After insertion into zx_rep_trx_jx_ext_t ');

1908: p_trl_global_variables_rec.request_id);
1909:
1910: IF ( g_level_statement>= g_current_runtime_level ) THEN
1911: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1912: 'After insertion into zx_rep_trx_jx_ext_t ');
1913: END IF;
1914:
1915:
1916: elsif P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME = 'RXZXKVAT' THEN

Line 1987: INSERT INTO ZX_REP_TRX_JX_EXT_T

1983:
1984:
1985: FORALL i in 1 .. nvl(l_detail_tax_line_id_tbl.last, 0)
1986:
1987: INSERT INTO ZX_REP_TRX_JX_EXT_T
1988: (detail_tax_line_ext_id,
1989: detail_tax_line_id,
1990: attribute1,
1991: attribute2,

Line 2009: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

2005: last_updated_by,
2006: last_update_date,
2007: last_update_login,
2008: request_id)
2009: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
2010: l_detail_tax_line_id_tbl(i),
2011: l_location_code_tbl(i),
2012: l_address_line_1_tbl(i),
2013: l_address_line_2_tbl(i),

Line 2218: X_INVOICE_AMT OUT NOCOPY ZX_REP_TRX_JX_EXT_T.NUMERIC12%TYPE,

2214: PROCEDURE GET_INVOICE_AMT
2215: (
2216: P_VENDOR_ID IN NUMBER,
2217: P_INVOICE_NUM IN VARCHAR2,
2218: X_INVOICE_AMT OUT NOCOPY ZX_REP_TRX_JX_EXT_T.NUMERIC12%TYPE,
2219: X_BASE_AMT OUT NOCOPY ZX_REP_TRX_JX_EXT_T.NUMERIC13%TYPE,
2220: X_PRINT_DATE OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_AP_INVOICES_ATT4%TYPE
2221: )
2222:

Line 2219: X_BASE_AMT OUT NOCOPY ZX_REP_TRX_JX_EXT_T.NUMERIC13%TYPE,

2215: (
2216: P_VENDOR_ID IN NUMBER,
2217: P_INVOICE_NUM IN VARCHAR2,
2218: X_INVOICE_AMT OUT NOCOPY ZX_REP_TRX_JX_EXT_T.NUMERIC12%TYPE,
2219: X_BASE_AMT OUT NOCOPY ZX_REP_TRX_JX_EXT_T.NUMERIC13%TYPE,
2220: X_PRINT_DATE OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_AP_INVOICES_ATT4%TYPE
2221: )
2222:
2223: IS

Line 2220: X_PRINT_DATE OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_AP_INVOICES_ATT4%TYPE

2216: P_VENDOR_ID IN NUMBER,
2217: P_INVOICE_NUM IN VARCHAR2,
2218: X_INVOICE_AMT OUT NOCOPY ZX_REP_TRX_JX_EXT_T.NUMERIC12%TYPE,
2219: X_BASE_AMT OUT NOCOPY ZX_REP_TRX_JX_EXT_T.NUMERIC13%TYPE,
2220: X_PRINT_DATE OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_AP_INVOICES_ATT4%TYPE
2221: )
2222:
2223: IS
2224: BEGIN

Line 2295: X_GDF_RA_BATCH_SOURCES_ATT1 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT1%TYPE, -- reference transaction source

2291:
2292: PROCEDURE GET_GUI_SOURCE
2293: (
2294: P_TRX_SOURCE_NAME IN VARCHAR2,
2295: X_GDF_RA_BATCH_SOURCES_ATT1 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT1%TYPE, -- reference transaction source
2296: X_GDF_RA_BATCH_SOURCES_ATT2 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT2%TYPE, -- initial trx num
2297: X_GDF_RA_BATCH_SOURCES_ATT3 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT3%TYPE, -- invoice word
2298: X_GDF_RA_BATCH_SOURCES_ATT4 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT4%TYPE -- final trx num
2299:

Line 2296: X_GDF_RA_BATCH_SOURCES_ATT2 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT2%TYPE, -- initial trx num

2292: PROCEDURE GET_GUI_SOURCE
2293: (
2294: P_TRX_SOURCE_NAME IN VARCHAR2,
2295: X_GDF_RA_BATCH_SOURCES_ATT1 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT1%TYPE, -- reference transaction source
2296: X_GDF_RA_BATCH_SOURCES_ATT2 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT2%TYPE, -- initial trx num
2297: X_GDF_RA_BATCH_SOURCES_ATT3 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT3%TYPE, -- invoice word
2298: X_GDF_RA_BATCH_SOURCES_ATT4 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT4%TYPE -- final trx num
2299:
2300: )

Line 2297: X_GDF_RA_BATCH_SOURCES_ATT3 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT3%TYPE, -- invoice word

2293: (
2294: P_TRX_SOURCE_NAME IN VARCHAR2,
2295: X_GDF_RA_BATCH_SOURCES_ATT1 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT1%TYPE, -- reference transaction source
2296: X_GDF_RA_BATCH_SOURCES_ATT2 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT2%TYPE, -- initial trx num
2297: X_GDF_RA_BATCH_SOURCES_ATT3 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT3%TYPE, -- invoice word
2298: X_GDF_RA_BATCH_SOURCES_ATT4 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT4%TYPE -- final trx num
2299:
2300: )
2301: IS

Line 2298: X_GDF_RA_BATCH_SOURCES_ATT4 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT4%TYPE -- final trx num

2294: P_TRX_SOURCE_NAME IN VARCHAR2,
2295: X_GDF_RA_BATCH_SOURCES_ATT1 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT1%TYPE, -- reference transaction source
2296: X_GDF_RA_BATCH_SOURCES_ATT2 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT2%TYPE, -- initial trx num
2297: X_GDF_RA_BATCH_SOURCES_ATT3 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT3%TYPE, -- invoice word
2298: X_GDF_RA_BATCH_SOURCES_ATT4 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT4%TYPE -- final trx num
2299:
2300: )
2301: IS
2302:

Line 2481: X_ORG_TRX_NUMBER OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT9%TYPE -- org trx num

2477: PROCEDURE GET_ORG_TRX_NUMBER
2478: (
2479: P_TRX_SOURCE_ID IN NUMBER,
2480: P_TRX_ID IN NUMBER,
2481: X_ORG_TRX_NUMBER OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT9%TYPE -- org trx num
2482:
2483: )
2484: IS
2485:

Line 2560: X_GDF_RA_CUST_TRX_ATT4 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT4%TYPE, -- export certificate number

2556:
2557: PROCEDURE GET_EXPORT_INFO
2558: (
2559: P_TRX_ID IN NUMBER,
2560: X_GDF_RA_CUST_TRX_ATT4 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT4%TYPE, -- export certificate number
2561: X_GDF_RA_CUST_TRX_ATT5 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT5%TYPE, -- export name
2562: X_GDF_RA_CUST_TRX_ATT6 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT6%TYPE, -- export method
2563: X_GDF_RA_CUST_TRX_ATT7 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT7%TYPE, -- export type
2564: X_GDF_RA_CUST_TRX_ATT8 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT8%TYPE -- export date

Line 2561: X_GDF_RA_CUST_TRX_ATT5 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT5%TYPE, -- export name

2557: PROCEDURE GET_EXPORT_INFO
2558: (
2559: P_TRX_ID IN NUMBER,
2560: X_GDF_RA_CUST_TRX_ATT4 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT4%TYPE, -- export certificate number
2561: X_GDF_RA_CUST_TRX_ATT5 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT5%TYPE, -- export name
2562: X_GDF_RA_CUST_TRX_ATT6 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT6%TYPE, -- export method
2563: X_GDF_RA_CUST_TRX_ATT7 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT7%TYPE, -- export type
2564: X_GDF_RA_CUST_TRX_ATT8 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT8%TYPE -- export date
2565: )

Line 2562: X_GDF_RA_CUST_TRX_ATT6 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT6%TYPE, -- export method

2558: (
2559: P_TRX_ID IN NUMBER,
2560: X_GDF_RA_CUST_TRX_ATT4 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT4%TYPE, -- export certificate number
2561: X_GDF_RA_CUST_TRX_ATT5 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT5%TYPE, -- export name
2562: X_GDF_RA_CUST_TRX_ATT6 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT6%TYPE, -- export method
2563: X_GDF_RA_CUST_TRX_ATT7 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT7%TYPE, -- export type
2564: X_GDF_RA_CUST_TRX_ATT8 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT8%TYPE -- export date
2565: )
2566: IS

Line 2563: X_GDF_RA_CUST_TRX_ATT7 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT7%TYPE, -- export type

2559: P_TRX_ID IN NUMBER,
2560: X_GDF_RA_CUST_TRX_ATT4 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT4%TYPE, -- export certificate number
2561: X_GDF_RA_CUST_TRX_ATT5 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT5%TYPE, -- export name
2562: X_GDF_RA_CUST_TRX_ATT6 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT6%TYPE, -- export method
2563: X_GDF_RA_CUST_TRX_ATT7 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT7%TYPE, -- export type
2564: X_GDF_RA_CUST_TRX_ATT8 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT8%TYPE -- export date
2565: )
2566: IS
2567:

Line 2564: X_GDF_RA_CUST_TRX_ATT8 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT8%TYPE -- export date

2560: X_GDF_RA_CUST_TRX_ATT4 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT4%TYPE, -- export certificate number
2561: X_GDF_RA_CUST_TRX_ATT5 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT5%TYPE, -- export name
2562: X_GDF_RA_CUST_TRX_ATT6 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT6%TYPE, -- export method
2563: X_GDF_RA_CUST_TRX_ATT7 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT7%TYPE, -- export type
2564: X_GDF_RA_CUST_TRX_ATT8 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT8%TYPE -- export date
2565: )
2566: IS
2567:
2568: BEGIN

Line 2689: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,

2685: OR l_account_id IS NOT NULL) THEN
2686: BEGIN
2687: FORALL i in 1 .. nvl(l_detail_tax_line_id_tbl.last, 0)
2688:
2689: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,
2690: detail_tax_line_id,
2691: attribute28, --bank ID
2692: attribute29, --Bracnh ID
2693: attribute30, --Account ID

Line 2700: VALUES ( zx_rep_trx_jx_ext_t_s.nextval,

2696: last_updated_by,
2697: last_update_date,
2698: last_update_login,
2699: request_id)
2700: VALUES ( zx_rep_trx_jx_ext_t_s.nextval,
2701: l_detail_tax_line_id_tbl(i),
2702: l_bank_name,
2703: l_branch_name,
2704: l_bank_account_num,

Line 2716: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,

2712:
2713: ELSE
2714:
2715: BEGIN
2716: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,
2717: detail_tax_line_id,
2718: attribute28,
2719: attribute29,
2720: attribute30,

Line 2727: SELECT zx_rep_trx_jx_ext_t_s.nextval,

2723: last_updated_by,
2724: last_update_date,
2725: last_update_login,
2726: request_id)
2727: SELECT zx_rep_trx_jx_ext_t_s.nextval,
2728: dtl.detail_tax_line_id,
2729: loc.global_attribute5,
2730: loc.global_attribute6,
2731: loc.global_attribute7,