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.JA_JAINTSLS_XMLP_PKG dependencies on JAI_CMN_TAXES_ALL

Line 38: LV_SALES JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;

34: WHERE REQUEST_ID = P_REQUEST_ID;
35: V_ENABLE_TRACE FND_CONCURRENT_PROGRAMS.ENABLE_TRACE%TYPE;
36: V_PROGRAM_ID FND_CONCURRENT_PROGRAMS.CONCURRENT_PROGRAM_ID%TYPE;
37: V_ORG_ID NUMBER;
38: LV_SALES JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
39: LV_CST JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
40: a boolean;
41: BEGIN
42: a:=P_END_DATEVALIDTRIGGER;

Line 39: LV_CST JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;

35: V_ENABLE_TRACE FND_CONCURRENT_PROGRAMS.ENABLE_TRACE%TYPE;
36: V_PROGRAM_ID FND_CONCURRENT_PROGRAMS.CONCURRENT_PROGRAM_ID%TYPE;
37: V_ORG_ID NUMBER;
38: LV_SALES JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
39: LV_CST JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
40: a boolean;
41: BEGIN
42: a:=P_END_DATEVALIDTRIGGER;
43: LP_END_DATE:=P_END_DATE;

Line 72: JAI_CMN_TAXES_ALL JITC,

68: JAI_AR_TRXS JCUTX,
69: RA_CUSTOMER_TRX_LINES_ALL CUTXL,
70: JAI_CMN_CUS_ADDRESSES JCUAD,
71: JAI_AR_TRX_TAX_LINES JRCTAXL,
72: JAI_CMN_TAXES_ALL JITC,
73: AR_PAYMENT_SCHEDULES_ALL ARPS
74: WHERE JCUTX.ORGANIZATION_ID = P_ORGANIZATION_ID
75: AND CUTX.CUSTOMER_TRX_ID = JCUTX.CUSTOMER_TRX_ID
76: AND CUTXL.CUSTOMER_TRX_ID = CUTX.CUSTOMER_TRX_ID

Line 92: LV_EXCISE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;

88: FUNCTION CF_1FORMULA0004(CUSTOMER_TRX_LINE_ID IN NUMBER) RETURN NUMBER IS
89: BEGIN
90: DECLARE
91: EXCISE_TAX NUMBER;
92: LV_EXCISE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
93: LV_ADDL_EXCISE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
94: LV_OTHER_EXCISE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
95: LV_EXC_EDU_CESS JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
96: LV_SH_EXC_EDU_CESS JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;

Line 93: LV_ADDL_EXCISE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;

89: BEGIN
90: DECLARE
91: EXCISE_TAX NUMBER;
92: LV_EXCISE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
93: LV_ADDL_EXCISE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
94: LV_OTHER_EXCISE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
95: LV_EXC_EDU_CESS JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
96: LV_SH_EXC_EDU_CESS JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
97: BEGIN

Line 94: LV_OTHER_EXCISE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;

90: DECLARE
91: EXCISE_TAX NUMBER;
92: LV_EXCISE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
93: LV_ADDL_EXCISE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
94: LV_OTHER_EXCISE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
95: LV_EXC_EDU_CESS JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
96: LV_SH_EXC_EDU_CESS JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
97: BEGIN
98: LV_EXCISE := 'EXCISE';

Line 95: LV_EXC_EDU_CESS JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;

91: EXCISE_TAX NUMBER;
92: LV_EXCISE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
93: LV_ADDL_EXCISE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
94: LV_OTHER_EXCISE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
95: LV_EXC_EDU_CESS JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
96: LV_SH_EXC_EDU_CESS JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
97: BEGIN
98: LV_EXCISE := 'EXCISE';
99: LV_ADDL_EXCISE := 'ADDL. EXCISE';

Line 96: LV_SH_EXC_EDU_CESS JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;

92: LV_EXCISE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
93: LV_ADDL_EXCISE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
94: LV_OTHER_EXCISE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
95: LV_EXC_EDU_CESS JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
96: LV_SH_EXC_EDU_CESS JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
97: BEGIN
98: LV_EXCISE := 'EXCISE';
99: LV_ADDL_EXCISE := 'ADDL. EXCISE';
100: LV_OTHER_EXCISE := 'OTHER EXCISE';

Line 108: JAI_CMN_TAXES_ALL B

104: SUM(A.TAX_AMOUNT)
105: INTO EXCISE_TAX
106: FROM
107: JAI_AR_TRX_TAX_LINES A,
108: JAI_CMN_TAXES_ALL B
109: WHERE A.LINK_TO_CUST_TRX_LINE_ID = CF_1FORMULA0004.CUSTOMER_TRX_LINE_ID
110: AND A.TAX_ID = B.TAX_ID
111: AND UPPER(B.TAX_TYPE) IN ( LV_EXCISE , LV_ADDL_EXCISE , LV_OTHER_EXCISE , LV_EXC_EDU_CESS , LV_SH_EXC_EDU_CESS );
112: CP_EXCISE_1 := EXCISE_TAX;

Line 122: LV_EXCISE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;

118: FUNCTION CF_2FORMULA(CUSTOMER_TRX_LINE_ID IN NUMBER) RETURN NUMBER IS
119: BEGIN
120: DECLARE
121: OTHER_TAX NUMBER;
122: LV_EXCISE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
123: LV_ADDL_EXCISE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
124: LV_OTHER_EXCISE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
125: LV_EXC_EDU_CESS JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
126: LV_SALES_TAX JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;

Line 123: LV_ADDL_EXCISE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;

119: BEGIN
120: DECLARE
121: OTHER_TAX NUMBER;
122: LV_EXCISE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
123: LV_ADDL_EXCISE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
124: LV_OTHER_EXCISE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
125: LV_EXC_EDU_CESS JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
126: LV_SALES_TAX JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
127: LV_CST JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;

Line 124: LV_OTHER_EXCISE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;

120: DECLARE
121: OTHER_TAX NUMBER;
122: LV_EXCISE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
123: LV_ADDL_EXCISE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
124: LV_OTHER_EXCISE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
125: LV_EXC_EDU_CESS JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
126: LV_SALES_TAX JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
127: LV_CST JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
128: LV_SH_EXC_EDU_CESS JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;

Line 125: LV_EXC_EDU_CESS JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;

121: OTHER_TAX NUMBER;
122: LV_EXCISE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
123: LV_ADDL_EXCISE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
124: LV_OTHER_EXCISE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
125: LV_EXC_EDU_CESS JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
126: LV_SALES_TAX JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
127: LV_CST JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
128: LV_SH_EXC_EDU_CESS JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
129: BEGIN

Line 126: LV_SALES_TAX JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;

122: LV_EXCISE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
123: LV_ADDL_EXCISE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
124: LV_OTHER_EXCISE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
125: LV_EXC_EDU_CESS JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
126: LV_SALES_TAX JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
127: LV_CST JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
128: LV_SH_EXC_EDU_CESS JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
129: BEGIN
130: LV_EXCISE := 'EXCISE';

Line 127: LV_CST JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;

123: LV_ADDL_EXCISE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
124: LV_OTHER_EXCISE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
125: LV_EXC_EDU_CESS JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
126: LV_SALES_TAX JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
127: LV_CST JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
128: LV_SH_EXC_EDU_CESS JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
129: BEGIN
130: LV_EXCISE := 'EXCISE';
131: LV_ADDL_EXCISE := 'ADDL. EXCISE';

Line 128: LV_SH_EXC_EDU_CESS JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;

124: LV_OTHER_EXCISE JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
125: LV_EXC_EDU_CESS JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
126: LV_SALES_TAX JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
127: LV_CST JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
128: LV_SH_EXC_EDU_CESS JAI_CMN_TAXES_ALL.TAX_TYPE%TYPE;
129: BEGIN
130: LV_EXCISE := 'EXCISE';
131: LV_ADDL_EXCISE := 'ADDL. EXCISE';
132: LV_OTHER_EXCISE := 'OTHER EXCISE';

Line 142: JAI_CMN_TAXES_ALL B

138: SUM(A.TAX_AMOUNT)
139: INTO OTHER_TAX
140: FROM
141: JAI_AR_TRX_TAX_LINES A,
142: JAI_CMN_TAXES_ALL B
143: WHERE A.LINK_TO_CUST_TRX_LINE_ID = CF_2FORMULA.CUSTOMER_TRX_LINE_ID
144: AND A.TAX_ID = B.TAX_ID
145: AND UPPER(B.TAX_TYPE) NOT IN ( LV_EXCISE , LV_ADDL_EXCISE , LV_OTHER_EXCISE , LV_EXC_EDU_CESS , LV_SALES_TAX , LV_CST , LV_SH_EXC_EDU_CESS );
146: CP_ADDL_OTHER_TAXES_1 := NVL(OTHER_TAX

Line 286: JAI_CMN_TAXES_ALL B

282: SUM(A.FUNC_TAX_AMOUNT)
283: INTO VAT_TAX
284: FROM
285: JAI_AR_TRX_TAX_LINES A,
286: JAI_CMN_TAXES_ALL B
287: WHERE A.LINK_TO_CUST_TRX_LINE_ID = CF_VAT_TAXES_1.CUSTOMER_TRX_LINE_ID
288: AND A.TAX_ID = B.TAX_ID
289: AND UPPER(B.TAX_TYPE) IN (
290: SELECT