APPS.JA_JAINVAR_XMLP_PKG dependencies on JAI_AR_TRX_LINES

Line 956: LV_CT2 JAI_AR_TRX_LINES.EXCISE_EXEMPT_TYPE%TYPE ;--'CT2';

952: END AFTERREPORT;
953:
954: FUNCTION F_10FORMATTRIGGER(CUSTOMER_TRX_ID1 IN NUMBER) RETURN NUMBER IS
955:
956: LV_CT2 JAI_AR_TRX_LINES.EXCISE_EXEMPT_TYPE%TYPE ;--'CT2';
957: LV_EXCISE_EXEMPT_CERT JAI_AR_TRX_LINES.EXCISE_EXEMPT_TYPE%TYPE ;--'EXCISE_EXEMPT_CERT';
958: LV_CRT2_OTH JAI_AR_TRX_LINES.EXCISE_EXEMPT_TYPE%TYPE ;--'CT2_OTH';
959: LV_EXCISE_EXEMPT_OTH JAI_AR_TRX_LINES.EXCISE_EXEMPT_TYPE%TYPE ;--'EXCISE_EXEMPT_CERT_OTH' ;
960:

Line 957: LV_EXCISE_EXEMPT_CERT JAI_AR_TRX_LINES.EXCISE_EXEMPT_TYPE%TYPE ;--'EXCISE_EXEMPT_CERT';

953:
954: FUNCTION F_10FORMATTRIGGER(CUSTOMER_TRX_ID1 IN NUMBER) RETURN NUMBER IS
955:
956: LV_CT2 JAI_AR_TRX_LINES.EXCISE_EXEMPT_TYPE%TYPE ;--'CT2';
957: LV_EXCISE_EXEMPT_CERT JAI_AR_TRX_LINES.EXCISE_EXEMPT_TYPE%TYPE ;--'EXCISE_EXEMPT_CERT';
958: LV_CRT2_OTH JAI_AR_TRX_LINES.EXCISE_EXEMPT_TYPE%TYPE ;--'CT2_OTH';
959: LV_EXCISE_EXEMPT_OTH JAI_AR_TRX_LINES.EXCISE_EXEMPT_TYPE%TYPE ;--'EXCISE_EXEMPT_CERT_OTH' ;
960:
961: CURSOR C1 IS

Line 958: LV_CRT2_OTH JAI_AR_TRX_LINES.EXCISE_EXEMPT_TYPE%TYPE ;--'CT2_OTH';

954: FUNCTION F_10FORMATTRIGGER(CUSTOMER_TRX_ID1 IN NUMBER) RETURN NUMBER IS
955:
956: LV_CT2 JAI_AR_TRX_LINES.EXCISE_EXEMPT_TYPE%TYPE ;--'CT2';
957: LV_EXCISE_EXEMPT_CERT JAI_AR_TRX_LINES.EXCISE_EXEMPT_TYPE%TYPE ;--'EXCISE_EXEMPT_CERT';
958: LV_CRT2_OTH JAI_AR_TRX_LINES.EXCISE_EXEMPT_TYPE%TYPE ;--'CT2_OTH';
959: LV_EXCISE_EXEMPT_OTH JAI_AR_TRX_LINES.EXCISE_EXEMPT_TYPE%TYPE ;--'EXCISE_EXEMPT_CERT_OTH' ;
960:
961: CURSOR C1 IS
962: SELECT COUNT(*)

Line 959: LV_EXCISE_EXEMPT_OTH JAI_AR_TRX_LINES.EXCISE_EXEMPT_TYPE%TYPE ;--'EXCISE_EXEMPT_CERT_OTH' ;

955:
956: LV_CT2 JAI_AR_TRX_LINES.EXCISE_EXEMPT_TYPE%TYPE ;--'CT2';
957: LV_EXCISE_EXEMPT_CERT JAI_AR_TRX_LINES.EXCISE_EXEMPT_TYPE%TYPE ;--'EXCISE_EXEMPT_CERT';
958: LV_CRT2_OTH JAI_AR_TRX_LINES.EXCISE_EXEMPT_TYPE%TYPE ;--'CT2_OTH';
959: LV_EXCISE_EXEMPT_OTH JAI_AR_TRX_LINES.EXCISE_EXEMPT_TYPE%TYPE ;--'EXCISE_EXEMPT_CERT_OTH' ;
960:
961: CURSOR C1 IS
962: SELECT COUNT(*)
963: FROM JAI_AR_TRX_LINES

Line 963: FROM JAI_AR_TRX_LINES

959: LV_EXCISE_EXEMPT_OTH JAI_AR_TRX_LINES.EXCISE_EXEMPT_TYPE%TYPE ;--'EXCISE_EXEMPT_CERT_OTH' ;
960:
961: CURSOR C1 IS
962: SELECT COUNT(*)
963: FROM JAI_AR_TRX_LINES
964: WHERE CUSTOMER_TRX_ID = CUSTOMER_TRX_ID1
965: AND EXCISE_EXEMPT_TYPE IN (LV_CT2, LV_EXCISE_EXEMPT_CERT, LV_CRT2_OTH, LV_EXCISE_EXEMPT_OTH) ;
966: --AND EXCISE_EXEMPT_TYPE IN ('CT2', 'EXCISE_EXEMPT_CERT','CT2_OTH', 'EXCISE_EXEMPT_CERT_OTH');
967: V_COUNT NUMBER;