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 768: ZX_REP_TRX_JX_EXT_T.TAX_STATUS_MNG%TYPE INDEX BY BINARY_INTEGER;

764: P_LOOKUP_TYPE varchar2(500);
765: P_LOOKUP_CODE varchar2(1000); --Bug 5453806
766:
767: TYPE GOVERNMENT_TAX_TYPE_TBL is TABLE OF
768: ZX_REP_TRX_JX_EXT_T.TAX_STATUS_MNG%TYPE INDEX BY BINARY_INTEGER;
769:
770: TYPE DEDUCTIBLE_TYPE_TBL is TABLE OF
771: ZX_REP_TRX_JX_EXT_T.TRX_BUSINESS_CATEGORY_MNG%TYPE INDEX BY BINARY_INTEGER;
772:

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

767: TYPE GOVERNMENT_TAX_TYPE_TBL is TABLE OF
768: ZX_REP_TRX_JX_EXT_T.TAX_STATUS_MNG%TYPE INDEX BY BINARY_INTEGER;
769:
770: TYPE DEDUCTIBLE_TYPE_TBL is TABLE OF
771: ZX_REP_TRX_JX_EXT_T.TRX_BUSINESS_CATEGORY_MNG%TYPE INDEX BY BINARY_INTEGER;
772:
773: TYPE EXPORT_METHOD_TBL is TABLE OF
774: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER;
775:

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

770: TYPE DEDUCTIBLE_TYPE_TBL is TABLE OF
771: ZX_REP_TRX_JX_EXT_T.TRX_BUSINESS_CATEGORY_MNG%TYPE INDEX BY BINARY_INTEGER;
772:
773: TYPE EXPORT_METHOD_TBL is TABLE OF
774: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER;
775:
776: TYPE EXPORT_CERTIFICATE_NAME_TBL is TABLE OF
777: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER;
778:

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

773: TYPE EXPORT_METHOD_TBL is TABLE OF
774: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER;
775:
776: TYPE EXPORT_CERTIFICATE_NAME_TBL is TABLE OF
777: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER;
778:
779: TYPE EXPORT_TYPE_TBL is TABLE OF
780: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER;
781:

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

776: TYPE EXPORT_CERTIFICATE_NAME_TBL is TABLE OF
777: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER;
778:
779: TYPE EXPORT_TYPE_TBL is TABLE OF
780: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER;
781:
782: TYPE INVOICE_WORD_TBL is TABLE OF
783: ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT3%TYPE INDEX BY BINARY_INTEGER;
784:

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

779: TYPE EXPORT_TYPE_TBL is TABLE OF
780: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER;
781:
782: TYPE INVOICE_WORD_TBL is TABLE OF
783: ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT3%TYPE INDEX BY BINARY_INTEGER;
784:
785: TYPE INITIAL_TRX_NUM_TBL is TABLE OF
786: ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT2%TYPE INDEX BY BINARY_INTEGER;
787:

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

782: TYPE INVOICE_WORD_TBL is TABLE OF
783: ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT3%TYPE INDEX BY BINARY_INTEGER;
784:
785: TYPE INITIAL_TRX_NUM_TBL is TABLE OF
786: ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT2%TYPE INDEX BY BINARY_INTEGER;
787:
788: TYPE FINAL_TRX_NUM_TBL is TABLE OF
789: ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT4%TYPE INDEX BY BINARY_INTEGER;
790:

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

785: TYPE INITIAL_TRX_NUM_TBL is TABLE OF
786: ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT2%TYPE INDEX BY BINARY_INTEGER;
787:
788: TYPE FINAL_TRX_NUM_TBL is TABLE OF
789: ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT4%TYPE INDEX BY BINARY_INTEGER;
790:
791: TYPE REFERENCE_TRX_SRC_TBL is TABLE OF
792: ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT1%TYPE INDEX BY BINARY_INTEGER;
793:

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

788: TYPE FINAL_TRX_NUM_TBL is TABLE OF
789: ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT4%TYPE INDEX BY BINARY_INTEGER;
790:
791: TYPE REFERENCE_TRX_SRC_TBL is TABLE OF
792: ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT1%TYPE INDEX BY BINARY_INTEGER;
793:
794: TYPE ORG_TRX_NUMBER_TBL is TABLE OF
795: ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT9%TYPE INDEX BY BINARY_INTEGER;
796:

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

791: TYPE REFERENCE_TRX_SRC_TBL is TABLE OF
792: ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT1%TYPE INDEX BY BINARY_INTEGER;
793:
794: TYPE ORG_TRX_NUMBER_TBL is TABLE OF
795: ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT9%TYPE INDEX BY BINARY_INTEGER;
796:
797: TYPE GDF_RA_CUST_TRX_ATT4_TBL is TABLE OF
798: ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT4%TYPE INDEX BY BINARY_INTEGER;
799:

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

794: TYPE ORG_TRX_NUMBER_TBL is TABLE OF
795: ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT9%TYPE INDEX BY BINARY_INTEGER;
796:
797: TYPE GDF_RA_CUST_TRX_ATT4_TBL is TABLE OF
798: ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT4%TYPE INDEX BY BINARY_INTEGER;
799:
800: TYPE GDF_RA_CUST_TRX_ATT5_TBL is TABLE OF
801: ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT5%TYPE INDEX BY BINARY_INTEGER;
802:

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

797: TYPE GDF_RA_CUST_TRX_ATT4_TBL is TABLE OF
798: ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT4%TYPE INDEX BY BINARY_INTEGER;
799:
800: TYPE GDF_RA_CUST_TRX_ATT5_TBL is TABLE OF
801: ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT5%TYPE INDEX BY BINARY_INTEGER;
802:
803: TYPE GDF_RA_CUST_TRX_ATT6_TBL is TABLE OF
804: ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT6%TYPE INDEX BY BINARY_INTEGER;
805:

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

800: TYPE GDF_RA_CUST_TRX_ATT5_TBL is TABLE OF
801: ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT5%TYPE INDEX BY BINARY_INTEGER;
802:
803: TYPE GDF_RA_CUST_TRX_ATT6_TBL is TABLE OF
804: ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT6%TYPE INDEX BY BINARY_INTEGER;
805:
806: TYPE GDF_RA_CUST_TRX_ATT7_TBL is TABLE OF
807: ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT7%TYPE INDEX BY BINARY_INTEGER;
808:

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

803: TYPE GDF_RA_CUST_TRX_ATT6_TBL is TABLE OF
804: ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT6%TYPE INDEX BY BINARY_INTEGER;
805:
806: TYPE GDF_RA_CUST_TRX_ATT7_TBL is TABLE OF
807: ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT7%TYPE INDEX BY BINARY_INTEGER;
808:
809: TYPE GDF_RA_CUST_TRX_ATT8_TBL is TABLE OF
810: ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT7%TYPE INDEX BY BINARY_INTEGER;
811:

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

806: TYPE GDF_RA_CUST_TRX_ATT7_TBL is TABLE OF
807: ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT7%TYPE INDEX BY BINARY_INTEGER;
808:
809: TYPE GDF_RA_CUST_TRX_ATT8_TBL is TABLE OF
810: ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT7%TYPE INDEX BY BINARY_INTEGER;
811:
812: TYPE CNT_TAXABLE_AMT_TBL is TABLE OF
813: ZX_REP_TRX_JX_EXT_T.NUMERIC1%TYPE INDEX BY BINARY_INTEGER;
814:

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

809: TYPE GDF_RA_CUST_TRX_ATT8_TBL is TABLE OF
810: ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT7%TYPE INDEX BY BINARY_INTEGER;
811:
812: TYPE CNT_TAXABLE_AMT_TBL is TABLE OF
813: ZX_REP_TRX_JX_EXT_T.NUMERIC1%TYPE INDEX BY BINARY_INTEGER;
814:
815: TYPE WINE_CIGARETTE_TBL is TABLE OF
816: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
817:

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

812: TYPE CNT_TAXABLE_AMT_TBL is TABLE OF
813: ZX_REP_TRX_JX_EXT_T.NUMERIC1%TYPE INDEX BY BINARY_INTEGER;
814:
815: TYPE WINE_CIGARETTE_TBL is TABLE OF
816: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
817:
818: TYPE ATTRIBUTE1_TBL is TABLE OF
819: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
820:

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

815: TYPE WINE_CIGARETTE_TBL is TABLE OF
816: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
817:
818: TYPE ATTRIBUTE1_TBL is TABLE OF
819: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
820:
821:
822: X_GOVERNMENT_TAX_TYPE_TBL GOVERNMENT_TAX_TYPE_TBL;
823: X_DEDUCTIBLE_TYPE_TBL DEDUCTIBLE_TYPE_TBL;

Line 941: INSERT INTO ZX_REP_TRX_JX_EXT_T

937:
938: /****** Bulk Insert into Ext Table *******/
939: FORALL i in 1 .. nvl(l_detail_tax_line_id_tbl.last, 0)
940:
941: INSERT INTO ZX_REP_TRX_JX_EXT_T
942: (detail_tax_line_ext_id,
943: detail_tax_line_id,
944: tax_status_mng, -- government tax type meaning
945: trx_business_category_mng, -- deductible code meaning

Line 951: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

947: creation_date,
948: last_updated_by,
949: last_update_date,
950: last_update_login)
951: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
952: l_detail_tax_line_id_tbl(i),
953: X_GOVERNMENT_TAX_TYPE_TBL(i),
954: X_DEDUCTIBLE_TYPE_TBL(i),
955: fnd_global.user_id,

Line 1005: INSERT INTO ZX_REP_TRX_JX_EXT_T

1001: /****** Bulk Insert into Ext Table *******/
1002:
1003: FORALL i in 1 .. nvl(l_detail_tax_line_id_tbl.last, 0)
1004:
1005: INSERT INTO ZX_REP_TRX_JX_EXT_T
1006: (detail_tax_line_ext_id,
1007: detail_tax_line_id,
1008: tax_status_mng, -- government tax type meaning
1009: gdf_ra_cust_trx_att9, -- orginal transaction number ZXTWRUIL

Line 1020: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

1016: creation_date,
1017: last_updated_by,
1018: last_update_date,
1019: last_update_login)
1020: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
1021: l_detail_tax_line_id_tbl(i),
1022: X_GOVERNMENT_TAX_TYPE_TBL(i),
1023: X_ORG_TRX_NUMBER_TBL(i),
1024: X_REFERENCE_TRX_SRC_TBL(i),

Line 1037: 'After insertion into zx_rep_trx_jx_ext_t ');

1033: fnd_global.login_id);
1034:
1035: IF ( g_level_statement>= g_current_runtime_level ) THEN
1036: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar',
1037: 'After insertion into zx_rep_trx_jx_ext_t ');
1038: END IF;
1039: elsif P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME = 'ZXTWRZTR' and l_detail_tax_line_id_tbl.count <> 0 then
1040:
1041: /****** Populate the missing columns ********/

Line 1068: INSERT INTO ZX_REP_TRX_JX_EXT_T

1064: /****** Bulk Insert into Ext Table *******/
1065:
1066: FORALL i in 1 .. nvl(l_detail_tax_line_id_tbl.last, 0)
1067:
1068: INSERT INTO ZX_REP_TRX_JX_EXT_T
1069: (detail_tax_line_ext_id,
1070: detail_tax_line_id,
1071: attribute4, -- export method
1072: attribute5, -- export certificate name

Line 1084: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

1080: creation_date,
1081: last_updated_by,
1082: last_update_date,
1083: last_update_login)
1084: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
1085: l_detail_tax_line_id_tbl(i),
1086: X_EXPORT_METHOD_TBL(i),
1087: X_EXPORT_CERTIFICATE_NAME_TBL(i),
1088: X_EXPORT_TYPE_TBL(i),

Line 1102: 'After insertion into zx_rep_trx_jx_ext_t ');

1098: fnd_global.login_id);
1099:
1100: IF ( g_level_statement>= g_current_runtime_level ) THEN
1101: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar',
1102: 'After insertion into zx_rep_trx_jx_ext_t ');
1103: END IF;
1104: elsif P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME = 'JATWSEDI' and l_detail_tax_line_id_tbl.count <> 0 then
1105:
1106: /****** Populate the missing columns ********/

Line 1127: INSERT INTO ZX_REP_TRX_JX_EXT_T

1123: /****** Bulk Insert into Ext Table *******/
1124:
1125: FORALL i in 1 .. nvl(l_detail_tax_line_id_tbl.last, 0)
1126:
1127: INSERT INTO ZX_REP_TRX_JX_EXT_T
1128: (detail_tax_line_ext_id,
1129: detail_tax_line_id,
1130: numeric1, -- count of taxable amount
1131: attribute1, -- wine_cigarette

Line 1137: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

1133: creation_date,
1134: last_updated_by,
1135: last_update_date,
1136: last_update_login)
1137: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
1138: l_detail_tax_line_id_tbl(i),
1139: X_CNT_TAXABLE_AMT_TBL(i),
1140: X_WINE_CIGARETTE_TBL(i),
1141: fnd_global.user_id,

Line 1149: 'After insertion into zx_rep_trx_jx_ext_t ');

1145: fnd_global.login_id);
1146:
1147: IF ( g_level_statement>= g_current_runtime_level ) THEN
1148: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar',
1149: 'After insertion into zx_rep_trx_jx_ext_t ');
1150: END IF;
1151: elsif P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME = 'RXZXKVAT' THEN
1152:
1153: SELECT loc.location_code,

Line 1229: INSERT INTO ZX_REP_TRX_JX_EXT_T

1225:
1226:
1227: FORALL i in 1 .. nvl(l_detail_tax_line_id_tbl.last, 0)
1228:
1229: INSERT INTO ZX_REP_TRX_JX_EXT_T
1230: (detail_tax_line_ext_id,
1231: detail_tax_line_id,
1232: attribute1,
1233: attribute2,

Line 1251: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

1247: last_updated_by,
1248: last_update_date,
1249: last_update_login,
1250: request_id)
1251: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
1252: l_detail_tax_line_id_tbl(i),
1253: l_location_code_tbl(i),
1254: l_address_line_1_tbl(i),
1255: l_address_line_2_tbl(i),

Line 1279: 'After insertion into zx_rep_trx_jx_ext_t ');

1275: end if;
1276:
1277: IF ( g_level_statement>= g_current_runtime_level ) THEN
1278: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar',
1279: 'After insertion into zx_rep_trx_jx_ext_t ');
1280: END IF;
1281:
1282: IF (g_level_procedure >= g_current_runtime_level ) THEN
1283: FND_LOG.STRING(g_level_procedure, 'ZX.TRL.ZX_JA_EXTRACT_PKG.populate_ja_ar.END',

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

1343: IS
1344:
1345:
1346: TYPE GOVERNMENT_TAX_TYPE_TBL is TABLE OF
1347: ZX_REP_TRX_JX_EXT_T.TAX_STATUS_MNG%TYPE INDEX BY BINARY_INTEGER;
1348:
1349: TYPE DEDUCTIBLE_TYPE_TBL is TABLE OF
1350: ZX_REP_TRX_JX_EXT_T.TRX_BUSINESS_CATEGORY_MNG%TYPE INDEX BY BINARY_INTEGER;
1351:

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

1346: TYPE GOVERNMENT_TAX_TYPE_TBL is TABLE OF
1347: ZX_REP_TRX_JX_EXT_T.TAX_STATUS_MNG%TYPE INDEX BY BINARY_INTEGER;
1348:
1349: TYPE DEDUCTIBLE_TYPE_TBL is TABLE OF
1350: ZX_REP_TRX_JX_EXT_T.TRX_BUSINESS_CATEGORY_MNG%TYPE INDEX BY BINARY_INTEGER;
1351:
1352: TYPE GUI_TYPE_TBL is TABLE OF
1353: ZX_REP_TRX_JX_EXT_T.DOCUMENT_SUB_TYPE_MNG%TYPE INDEX BY BINARY_INTEGER;
1354:

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

1349: TYPE DEDUCTIBLE_TYPE_TBL is TABLE OF
1350: ZX_REP_TRX_JX_EXT_T.TRX_BUSINESS_CATEGORY_MNG%TYPE INDEX BY BINARY_INTEGER;
1351:
1352: TYPE GUI_TYPE_TBL is TABLE OF
1353: ZX_REP_TRX_JX_EXT_T.DOCUMENT_SUB_TYPE_MNG%TYPE INDEX BY BINARY_INTEGER;
1354:
1355: TYPE INVOICE_AMOUNT_TBL is TABLE OF
1356: ZX_REP_TRX_JX_EXT_T.NUMERIC12%TYPE INDEX BY BINARY_INTEGER;
1357:

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

1352: TYPE GUI_TYPE_TBL is TABLE OF
1353: ZX_REP_TRX_JX_EXT_T.DOCUMENT_SUB_TYPE_MNG%TYPE INDEX BY BINARY_INTEGER;
1354:
1355: TYPE INVOICE_AMOUNT_TBL is TABLE OF
1356: ZX_REP_TRX_JX_EXT_T.NUMERIC12%TYPE INDEX BY BINARY_INTEGER;
1357:
1358: TYPE BASE_AMOUNT_TBL is TABLE OF
1359: ZX_REP_TRX_JX_EXT_T.NUMERIC13%TYPE INDEX BY BINARY_INTEGER;
1360:

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

1355: TYPE INVOICE_AMOUNT_TBL is TABLE OF
1356: ZX_REP_TRX_JX_EXT_T.NUMERIC12%TYPE INDEX BY BINARY_INTEGER;
1357:
1358: TYPE BASE_AMOUNT_TBL is TABLE OF
1359: ZX_REP_TRX_JX_EXT_T.NUMERIC13%TYPE INDEX BY BINARY_INTEGER;
1360:
1361: TYPE PRINT_DATE_TBL is TABLE OF
1362: ZX_REP_TRX_JX_EXT_T.GDF_AP_INVOICES_ATT4%TYPE INDEX BY BINARY_INTEGER;
1363:

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

1358: TYPE BASE_AMOUNT_TBL is TABLE OF
1359: ZX_REP_TRX_JX_EXT_T.NUMERIC13%TYPE INDEX BY BINARY_INTEGER;
1360:
1361: TYPE PRINT_DATE_TBL is TABLE OF
1362: ZX_REP_TRX_JX_EXT_T.GDF_AP_INVOICES_ATT4%TYPE INDEX BY BINARY_INTEGER;
1363:
1364: TYPE INHOUSE_INV_AMT_TBL is TABLE OF
1365: ZX_REP_TRX_JX_EXT_T.NUMERIC1%TYPE INDEX BY BINARY_INTEGER;
1366:

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

1361: TYPE PRINT_DATE_TBL is TABLE OF
1362: ZX_REP_TRX_JX_EXT_T.GDF_AP_INVOICES_ATT4%TYPE INDEX BY BINARY_INTEGER;
1363:
1364: TYPE INHOUSE_INV_AMT_TBL is TABLE OF
1365: ZX_REP_TRX_JX_EXT_T.NUMERIC1%TYPE INDEX BY BINARY_INTEGER;
1366:
1367: TYPE SUPPLIER_INV_AMT_TBL is TABLE OF
1368: ZX_REP_TRX_JX_EXT_T.NUMERIC2%TYPE INDEX BY BINARY_INTEGER;
1369:

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

1364: TYPE INHOUSE_INV_AMT_TBL is TABLE OF
1365: ZX_REP_TRX_JX_EXT_T.NUMERIC1%TYPE INDEX BY BINARY_INTEGER;
1366:
1367: TYPE SUPPLIER_INV_AMT_TBL is TABLE OF
1368: ZX_REP_TRX_JX_EXT_T.NUMERIC2%TYPE INDEX BY BINARY_INTEGER;
1369:
1370: TYPE INHOUSE_TAX_AMT_TBL is TABLE OF
1371: ZX_REP_TRX_JX_EXT_T.NUMERIC3%TYPE INDEX BY BINARY_INTEGER;
1372:

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

1367: TYPE SUPPLIER_INV_AMT_TBL is TABLE OF
1368: ZX_REP_TRX_JX_EXT_T.NUMERIC2%TYPE INDEX BY BINARY_INTEGER;
1369:
1370: TYPE INHOUSE_TAX_AMT_TBL is TABLE OF
1371: ZX_REP_TRX_JX_EXT_T.NUMERIC3%TYPE INDEX BY BINARY_INTEGER;
1372:
1373: TYPE SUPPLIER_TAX_AMT_TBL is TABLE OF
1374: ZX_REP_TRX_JX_EXT_T.NUMERIC4%TYPE INDEX BY BINARY_INTEGER;
1375:

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

1370: TYPE INHOUSE_TAX_AMT_TBL is TABLE OF
1371: ZX_REP_TRX_JX_EXT_T.NUMERIC3%TYPE INDEX BY BINARY_INTEGER;
1372:
1373: TYPE SUPPLIER_TAX_AMT_TBL is TABLE OF
1374: ZX_REP_TRX_JX_EXT_T.NUMERIC4%TYPE INDEX BY BINARY_INTEGER;
1375:
1376: TYPE TAXABLE_GAINLOSS_TBL is TABLE OF
1377: ZX_REP_TRX_JX_EXT_T.NUMERIC5%TYPE INDEX BY BINARY_INTEGER;
1378:

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

1373: TYPE SUPPLIER_TAX_AMT_TBL is TABLE OF
1374: ZX_REP_TRX_JX_EXT_T.NUMERIC4%TYPE INDEX BY BINARY_INTEGER;
1375:
1376: TYPE TAXABLE_GAINLOSS_TBL is TABLE OF
1377: ZX_REP_TRX_JX_EXT_T.NUMERIC5%TYPE INDEX BY BINARY_INTEGER;
1378:
1379: TYPE TAX_GAINLOSS_TBL is TABLE OF
1380: ZX_REP_TRX_JX_EXT_T.NUMERIC6%TYPE INDEX BY BINARY_INTEGER;
1381:

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

1376: TYPE TAXABLE_GAINLOSS_TBL is TABLE OF
1377: ZX_REP_TRX_JX_EXT_T.NUMERIC5%TYPE INDEX BY BINARY_INTEGER;
1378:
1379: TYPE TAX_GAINLOSS_TBL is TABLE OF
1380: ZX_REP_TRX_JX_EXT_T.NUMERIC6%TYPE INDEX BY BINARY_INTEGER;
1381:
1382: TYPE ATTRIBUTE1_TBL is TABLE OF
1383: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
1384:

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

1379: TYPE TAX_GAINLOSS_TBL is TABLE OF
1380: ZX_REP_TRX_JX_EXT_T.NUMERIC6%TYPE INDEX BY BINARY_INTEGER;
1381:
1382: TYPE ATTRIBUTE1_TBL is TABLE OF
1383: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
1384:
1385: X_GOVERNMENT_TAX_TYPE_TBL GOVERNMENT_TAX_TYPE_TBL;
1386: X_DEDUCTIBLE_TYPE_TBL DEDUCTIBLE_TYPE_TBL;
1387: X_GUI_TYPE_TBL GUI_TYPE_TBL;

Line 1525: INSERT INTO ZX_REP_TRX_JX_EXT_T

1521:
1522: /****** Bulk Insert into Ext Table *******/
1523: FORALL i in 1 .. nvl(l_detail_tax_line_id_tbl.last, 0)
1524:
1525: INSERT INTO ZX_REP_TRX_JX_EXT_T
1526: (detail_tax_line_ext_id,
1527: detail_tax_line_id,
1528: tax_status_mng, -- government tax type meaning
1529: trx_business_category_mng, -- deductible code meaning

Line 1535: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

1531: creation_date,
1532: last_updated_by,
1533: last_update_date,
1534: last_update_login)
1535: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
1536: l_detail_tax_line_id_tbl(i),
1537: X_GOVERNMENT_TAX_TYPE_TBL(i),
1538: X_DEDUCTIBLE_TYPE_TBL(i),
1539: fnd_global.user_id,

Line 1547: 'After insertion into zx_rep_trx_jx_ext_t ');

1543: fnd_global.login_id);
1544:
1545: IF ( g_level_statement>= g_current_runtime_level ) THEN
1546: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1547: 'After insertion into zx_rep_trx_jx_ext_t ');
1548: END IF;
1549: elsif P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME = 'ZXTWSPRF' and l_detail_tax_line_id_tbl.count <> 0 then
1550:
1551: /****** Populate the missing columns ********/

Line 1595: 'Before into zx_rep_trx_jx_ext_t ap ');

1591: /****** Bulk Insert into Ext Table *******/
1592:
1593: IF ( g_level_statement>= g_current_runtime_level ) THEN
1594: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1595: 'Before into zx_rep_trx_jx_ext_t ap ');
1596: END IF;
1597:
1598: FORALL i in 1 .. nvl(l_detail_tax_line_id_tbl.last, 0)
1599:

Line 1600: INSERT INTO ZX_REP_TRX_JX_EXT_T

1596: END IF;
1597:
1598: FORALL i in 1 .. nvl(l_detail_tax_line_id_tbl.last, 0)
1599:
1600: INSERT INTO ZX_REP_TRX_JX_EXT_T
1601: (detail_tax_line_ext_id,
1602: detail_tax_line_id,
1603: tax_status_mng, -- government tax type meaning
1604: trx_business_category_mng, -- deductible code meaning

Line 1611: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

1607: creation_date,
1608: last_updated_by,
1609: last_update_date,
1610: last_update_login)
1611: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
1612: l_detail_tax_line_id_tbl(i),
1613: X_GOVERNMENT_TAX_TYPE_TBL(i),
1614: X_DEDUCTIBLE_TYPE_TBL(i),
1615: X_GUI_TYPE_TBL(i),

Line 1624: 'After insertion into zx_rep_trx_jx_ext_t ');

1620: fnd_global.login_id);
1621:
1622: IF ( g_level_statement>= g_current_runtime_level ) THEN
1623: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1624: 'After insertion into zx_rep_trx_jx_ext_t ');
1625: END IF;
1626: elsif P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME = ('ZXTWPSPC') and l_detail_tax_line_id_tbl.count <> 0 then
1627:
1628: /****** Populate the missing columns ********/

Line 1655: INSERT INTO ZX_REP_TRX_JX_EXT_T

1651:
1652: /****** Bulk Insert into Ext Table *******/
1653: FORALL i in 1 .. nvl(l_detail_tax_line_id_tbl.last, 0)
1654:
1655: INSERT INTO ZX_REP_TRX_JX_EXT_T
1656: (detail_tax_line_ext_id,
1657: detail_tax_line_id,
1658: gdf_ap_invoices_att4, -- print date
1659: numeric12, -- document amount

Line 1666: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

1662: creation_date,
1663: last_updated_by,
1664: last_update_date,
1665: last_update_login)
1666: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
1667: l_detail_tax_line_id_tbl(i),
1668: X_PRINT_DATE_TBL(i),
1669: X_INVOICE_AMOUNT_TBL(i),
1670: X_BASE_AMOUNT_TBL(i),

Line 1679: 'After insertion into zx_rep_trx_jx_ext_t ');

1675: fnd_global.login_id);
1676:
1677: IF ( g_level_statement>= g_current_runtime_level ) THEN
1678: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1679: 'After insertion into zx_rep_trx_jx_ext_t ');
1680: END IF;
1681: elsif P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME = 'ZXTWPPRD' and l_detail_tax_line_id_tbl.count <> 0 then
1682:
1683: /****** Populate the missing columns ********/

Line 1698: INSERT INTO ZX_REP_TRX_JX_EXT_T

1694:
1695: /****** Bulk Insert into Ext Table *******/
1696: FORALL i in 1 .. nvl(l_detail_tax_line_id_tbl.last, 0)
1697:
1698: INSERT INTO ZX_REP_TRX_JX_EXT_T
1699: (detail_tax_line_ext_id,
1700: detail_tax_line_id,
1701: numeric12, -- document amount
1702: numeric13, -- document base amount

Line 1708: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

1704: creation_date,
1705: last_updated_by,
1706: last_update_date,
1707: last_update_login)
1708: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
1709: l_detail_tax_line_id_tbl(i),
1710: X_INVOICE_AMOUNT_TBL(i),
1711: X_BASE_AMOUNT_TBL(i),
1712: fnd_global.user_id,

Line 1720: 'After insertion into zx_rep_trx_jx_ext_t ');

1716: fnd_global.login_id);
1717:
1718: IF ( g_level_statement>= g_current_runtime_level ) THEN
1719: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1720: 'After insertion into zx_rep_trx_jx_ext_t ');
1721: END IF;
1722: elsif P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME = 'ZXSGAGAL' and l_detail_tax_line_id_tbl.count <> 0 then
1723:
1724: /****** Populate the missing columns ********/

Line 1809: INSERT INTO ZX_REP_TRX_JX_EXT_T

1805:
1806: /****** Bulk Insert into Ext Table *******/
1807: FORALL i in 1 .. nvl(l_detail_tax_line_id_tbl.last, 0)
1808:
1809: INSERT INTO ZX_REP_TRX_JX_EXT_T
1810: (detail_tax_line_ext_id,
1811: detail_tax_line_id,
1812: numeric1, -- inhouse invoice amt
1813: numeric2, -- supplier invoice amt

Line 1823: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

1819: creation_date,
1820: last_updated_by,
1821: last_update_date,
1822: last_update_login)
1823: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
1824: l_detail_tax_line_id_tbl(i),
1825: X_INHOUSE_INV_AMT_TBL(i),
1826: X_SUPPLIER_INV_AMT_TBL(i),
1827: X_INHOUSE_TAX_AMT_TBL(i),

Line 1839: 'After insertion into zx_rep_trx_jx_ext_t ');

1835: fnd_global.login_id);
1836:
1837: IF ( g_level_statement>= g_current_runtime_level ) THEN
1838: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_JA_EXTRACT_PKG.POPULATE_JA_AP',
1839: 'After insertion into zx_rep_trx_jx_ext_t ');
1840: END IF;
1841:
1842:
1843: elsif P_TRL_GLOBAL_VARIABLES_REC.REPORT_NAME = 'RXZXKVAT' THEN

Line 1914: INSERT INTO ZX_REP_TRX_JX_EXT_T

1910:
1911:
1912: FORALL i in 1 .. nvl(l_detail_tax_line_id_tbl.last, 0)
1913:
1914: INSERT INTO ZX_REP_TRX_JX_EXT_T
1915: (detail_tax_line_ext_id,
1916: detail_tax_line_id,
1917: attribute1,
1918: attribute2,

Line 1936: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

1932: last_updated_by,
1933: last_update_date,
1934: last_update_login,
1935: request_id)
1936: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
1937: l_detail_tax_line_id_tbl(i),
1938: l_location_code_tbl(i),
1939: l_address_line_1_tbl(i),
1940: l_address_line_2_tbl(i),

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

2141: PROCEDURE GET_INVOICE_AMT
2142: (
2143: P_VENDOR_ID IN NUMBER,
2144: P_INVOICE_NUM IN VARCHAR2,
2145: X_INVOICE_AMT OUT NOCOPY ZX_REP_TRX_JX_EXT_T.NUMERIC12%TYPE,
2146: X_BASE_AMT OUT NOCOPY ZX_REP_TRX_JX_EXT_T.NUMERIC13%TYPE,
2147: X_PRINT_DATE OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_AP_INVOICES_ATT4%TYPE
2148: )
2149:

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

2142: (
2143: P_VENDOR_ID IN NUMBER,
2144: P_INVOICE_NUM IN VARCHAR2,
2145: X_INVOICE_AMT OUT NOCOPY ZX_REP_TRX_JX_EXT_T.NUMERIC12%TYPE,
2146: X_BASE_AMT OUT NOCOPY ZX_REP_TRX_JX_EXT_T.NUMERIC13%TYPE,
2147: X_PRINT_DATE OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_AP_INVOICES_ATT4%TYPE
2148: )
2149:
2150: IS

Line 2147: X_PRINT_DATE OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_AP_INVOICES_ATT4%TYPE

2143: P_VENDOR_ID IN NUMBER,
2144: P_INVOICE_NUM IN VARCHAR2,
2145: X_INVOICE_AMT OUT NOCOPY ZX_REP_TRX_JX_EXT_T.NUMERIC12%TYPE,
2146: X_BASE_AMT OUT NOCOPY ZX_REP_TRX_JX_EXT_T.NUMERIC13%TYPE,
2147: X_PRINT_DATE OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_AP_INVOICES_ATT4%TYPE
2148: )
2149:
2150: IS
2151: BEGIN

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

2218:
2219: PROCEDURE GET_GUI_SOURCE
2220: (
2221: P_TRX_SOURCE_NAME IN VARCHAR2,
2222: X_GDF_RA_BATCH_SOURCES_ATT1 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT1%TYPE, -- reference transaction source
2223: X_GDF_RA_BATCH_SOURCES_ATT2 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT2%TYPE, -- initial trx num
2224: X_GDF_RA_BATCH_SOURCES_ATT3 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT3%TYPE, -- invoice word
2225: X_GDF_RA_BATCH_SOURCES_ATT4 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT4%TYPE -- final trx num
2226:

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

2219: PROCEDURE GET_GUI_SOURCE
2220: (
2221: P_TRX_SOURCE_NAME IN VARCHAR2,
2222: X_GDF_RA_BATCH_SOURCES_ATT1 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT1%TYPE, -- reference transaction source
2223: X_GDF_RA_BATCH_SOURCES_ATT2 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT2%TYPE, -- initial trx num
2224: X_GDF_RA_BATCH_SOURCES_ATT3 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT3%TYPE, -- invoice word
2225: X_GDF_RA_BATCH_SOURCES_ATT4 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT4%TYPE -- final trx num
2226:
2227: )

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

2220: (
2221: P_TRX_SOURCE_NAME IN VARCHAR2,
2222: X_GDF_RA_BATCH_SOURCES_ATT1 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT1%TYPE, -- reference transaction source
2223: X_GDF_RA_BATCH_SOURCES_ATT2 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT2%TYPE, -- initial trx num
2224: X_GDF_RA_BATCH_SOURCES_ATT3 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT3%TYPE, -- invoice word
2225: X_GDF_RA_BATCH_SOURCES_ATT4 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT4%TYPE -- final trx num
2226:
2227: )
2228: IS

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

2221: P_TRX_SOURCE_NAME IN VARCHAR2,
2222: X_GDF_RA_BATCH_SOURCES_ATT1 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT1%TYPE, -- reference transaction source
2223: X_GDF_RA_BATCH_SOURCES_ATT2 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT2%TYPE, -- initial trx num
2224: X_GDF_RA_BATCH_SOURCES_ATT3 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT3%TYPE, -- invoice word
2225: X_GDF_RA_BATCH_SOURCES_ATT4 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_BATCH_SOURCES_ATT4%TYPE -- final trx num
2226:
2227: )
2228: IS
2229:

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

2404: PROCEDURE GET_ORG_TRX_NUMBER
2405: (
2406: P_TRX_SOURCE_ID IN NUMBER,
2407: P_TRX_ID IN NUMBER,
2408: X_ORG_TRX_NUMBER OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT9%TYPE -- org trx num
2409:
2410: )
2411: IS
2412:

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

2483:
2484: PROCEDURE GET_EXPORT_INFO
2485: (
2486: P_TRX_ID IN NUMBER,
2487: X_GDF_RA_CUST_TRX_ATT4 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT4%TYPE, -- export certificate number
2488: X_GDF_RA_CUST_TRX_ATT5 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT5%TYPE, -- export name
2489: X_GDF_RA_CUST_TRX_ATT6 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT6%TYPE, -- export method
2490: X_GDF_RA_CUST_TRX_ATT7 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT7%TYPE, -- export type
2491: X_GDF_RA_CUST_TRX_ATT8 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT8%TYPE -- export date

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

2484: PROCEDURE GET_EXPORT_INFO
2485: (
2486: P_TRX_ID IN NUMBER,
2487: X_GDF_RA_CUST_TRX_ATT4 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT4%TYPE, -- export certificate number
2488: X_GDF_RA_CUST_TRX_ATT5 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT5%TYPE, -- export name
2489: X_GDF_RA_CUST_TRX_ATT6 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT6%TYPE, -- export method
2490: X_GDF_RA_CUST_TRX_ATT7 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT7%TYPE, -- export type
2491: X_GDF_RA_CUST_TRX_ATT8 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT8%TYPE -- export date
2492: )

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

2485: (
2486: P_TRX_ID IN NUMBER,
2487: X_GDF_RA_CUST_TRX_ATT4 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT4%TYPE, -- export certificate number
2488: X_GDF_RA_CUST_TRX_ATT5 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT5%TYPE, -- export name
2489: X_GDF_RA_CUST_TRX_ATT6 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT6%TYPE, -- export method
2490: X_GDF_RA_CUST_TRX_ATT7 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT7%TYPE, -- export type
2491: X_GDF_RA_CUST_TRX_ATT8 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT8%TYPE -- export date
2492: )
2493: IS

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

2486: P_TRX_ID IN NUMBER,
2487: X_GDF_RA_CUST_TRX_ATT4 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT4%TYPE, -- export certificate number
2488: X_GDF_RA_CUST_TRX_ATT5 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT5%TYPE, -- export name
2489: X_GDF_RA_CUST_TRX_ATT6 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT6%TYPE, -- export method
2490: X_GDF_RA_CUST_TRX_ATT7 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT7%TYPE, -- export type
2491: X_GDF_RA_CUST_TRX_ATT8 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT8%TYPE -- export date
2492: )
2493: IS
2494:

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

2487: X_GDF_RA_CUST_TRX_ATT4 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT4%TYPE, -- export certificate number
2488: X_GDF_RA_CUST_TRX_ATT5 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT5%TYPE, -- export name
2489: X_GDF_RA_CUST_TRX_ATT6 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT6%TYPE, -- export method
2490: X_GDF_RA_CUST_TRX_ATT7 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT7%TYPE, -- export type
2491: X_GDF_RA_CUST_TRX_ATT8 OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_RA_CUST_TRX_ATT8%TYPE -- export date
2492: )
2493: IS
2494:
2495: BEGIN

Line 2616: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,

2612: OR l_account_id IS NOT NULL) THEN
2613: BEGIN
2614: FORALL i in 1 .. nvl(l_detail_tax_line_id_tbl.last, 0)
2615:
2616: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,
2617: detail_tax_line_id,
2618: attribute28, --bank ID
2619: attribute29, --Bracnh ID
2620: attribute30, --Account ID

Line 2626: VALUES ( zx_rep_trx_jx_ext_t_s.nextval,

2622: creation_date,
2623: last_updated_by,
2624: last_update_date,
2625: last_update_login)
2626: VALUES ( zx_rep_trx_jx_ext_t_s.nextval,
2627: l_detail_tax_line_id_tbl(i),
2628: l_bank_name,
2629: l_branch_name,
2630: l_bank_account_num,

Line 2641: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,

2637:
2638: ELSE
2639:
2640: BEGIN
2641: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,
2642: detail_tax_line_id,
2643: attribute28,
2644: attribute29,
2645: attribute30,

Line 2651: SELECT zx_rep_trx_jx_ext_t_s.nextval,

2647: creation_date,
2648: last_updated_by,
2649: last_update_date,
2650: last_update_login)
2651: SELECT zx_rep_trx_jx_ext_t_s.nextval,
2652: dtl.detail_tax_line_id,
2653: loc.global_attribute5,
2654: loc.global_attribute6,
2655: loc.global_attribute7,