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_JAINPLA_XMLP_PKG dependencies on JAI_CMN_RG_OTHERS

Line 76: LV_TAX_TYPE JAI_CMN_RG_OTHERS.TAX_TYPE%TYPE;

72:
73: FUNCTION AFTERPFORM RETURN BOOLEAN IS
74: FOLIOMONTH DATE;
75: MAXENDDATE DATE;
76: LV_TAX_TYPE JAI_CMN_RG_OTHERS.TAX_TYPE%TYPE;
77: CURSOR CUR_OPEN_CESS_BAL(P_ORG_ID IN JAI_CMN_RG_PLA_TRXS.ORGANIZATION_ID%TYPE,P_LOC_ID IN JAI_CMN_RG_PLA_TRXS.LOCATION_ID%TYPE,P_TRN_FROM_DATE IN DATE,
78: P_TAX_TYPE IN JAI_CMN_RG_OTHERS.TAX_TYPE%TYPE,CP_SOURCE_REGISTER IN JAI_CMN_RG_OTHERS.SOURCE_REGISTER%TYPE) IS
79: SELECT
80: NVL(CLOSING_BALANCE

Line 78: P_TAX_TYPE IN JAI_CMN_RG_OTHERS.TAX_TYPE%TYPE,CP_SOURCE_REGISTER IN JAI_CMN_RG_OTHERS.SOURCE_REGISTER%TYPE) IS

74: FOLIOMONTH DATE;
75: MAXENDDATE DATE;
76: LV_TAX_TYPE JAI_CMN_RG_OTHERS.TAX_TYPE%TYPE;
77: CURSOR CUR_OPEN_CESS_BAL(P_ORG_ID IN JAI_CMN_RG_PLA_TRXS.ORGANIZATION_ID%TYPE,P_LOC_ID IN JAI_CMN_RG_PLA_TRXS.LOCATION_ID%TYPE,P_TRN_FROM_DATE IN DATE,
78: P_TAX_TYPE IN JAI_CMN_RG_OTHERS.TAX_TYPE%TYPE,CP_SOURCE_REGISTER IN JAI_CMN_RG_OTHERS.SOURCE_REGISTER%TYPE) IS
79: SELECT
80: NVL(CLOSING_BALANCE
81: ,0)
82: FROM

Line 83: JAI_CMN_RG_OTHERS

79: SELECT
80: NVL(CLOSING_BALANCE
81: ,0)
82: FROM
83: JAI_CMN_RG_OTHERS
84: WHERE SOURCE_REGISTER = CP_SOURCE_REGISTER
85: AND TAX_TYPE = P_TAX_TYPE
86: AND SOURCE_REGISTER_ID = (
87: SELECT

Line 91: JAI_CMN_RG_OTHERS B

87: SELECT
88: MAX(A.REGISTER_ID)
89: FROM
90: JAI_CMN_RG_PLA_TRXS A,
91: JAI_CMN_RG_OTHERS B
92: WHERE A.REGISTER_ID = B.SOURCE_REGISTER_ID
93: AND B.SOURCE_REGISTER = CP_SOURCE_REGISTER
94: AND B.TAX_TYPE = P_TAX_TYPE
95: AND A.TRANSACTION_DATE = (

Line 100: JAI_CMN_RG_OTHERS D

96: SELECT
97: MAX(C.TRANSACTION_DATE)
98: FROM
99: JAI_CMN_RG_PLA_TRXS C,
100: JAI_CMN_RG_OTHERS D
101: WHERE C.REGISTER_ID = D.SOURCE_REGISTER_ID
102: AND D.SOURCE_REGISTER = CP_SOURCE_REGISTER
103: AND D.TAX_TYPE = P_TAX_TYPE
104: AND TRUNC(C.TRANSACTION_DATE) < TRUNC(P_TRN_FROM_DATE)

Line 625: P_TRN_FRM_DATE IN DATE,CP_SOURCE_REGISTER IN JAI_CMN_RG_OTHERS.SOURCE_REGISTER%TYPE,CP_TAX_TYPE IN JAI_CMN_RG_OTHERS.TAX_TYPE%TYPE) IS

621: END BEFOREREPORT;
622:
623: FUNCTION CF_CESS_OPEN_BALFORMULA RETURN NUMBER IS
624: CURSOR CUR_CESS_OPEN_BAL(P_ORG_ID IN JAI_CMN_RG_PLA_TRXS.ORGANIZATION_ID%TYPE,P_LOC_ID IN JAI_CMN_RG_PLA_TRXS.LOCATION_ID%TYPE,
625: P_TRN_FRM_DATE IN DATE,CP_SOURCE_REGISTER IN JAI_CMN_RG_OTHERS.SOURCE_REGISTER%TYPE,CP_TAX_TYPE IN JAI_CMN_RG_OTHERS.TAX_TYPE%TYPE) IS
626: SELECT
627: CLOSING_BALANCE
628: FROM
629: JAI_CMN_RG_OTHERS

Line 629: JAI_CMN_RG_OTHERS

625: P_TRN_FRM_DATE IN DATE,CP_SOURCE_REGISTER IN JAI_CMN_RG_OTHERS.SOURCE_REGISTER%TYPE,CP_TAX_TYPE IN JAI_CMN_RG_OTHERS.TAX_TYPE%TYPE) IS
626: SELECT
627: CLOSING_BALANCE
628: FROM
629: JAI_CMN_RG_OTHERS
630: WHERE SOURCE_REGISTER = CP_SOURCE_REGISTER
631: AND TAX_TYPE = CP_TAX_TYPE
632: AND SOURCE_REGISTER_ID = (
633: SELECT

Line 637: JAI_CMN_RG_OTHERS B

633: SELECT
634: MAX(A.REGISTER_ID)
635: FROM
636: JAI_CMN_RG_PLA_TRXS A,
637: JAI_CMN_RG_OTHERS B
638: WHERE A.REGISTER_ID = B.SOURCE_REGISTER_ID
639: AND B.SOURCE_REGISTER = CP_SOURCE_REGISTER
640: AND B.TAX_TYPE = CP_TAX_TYPE
641: AND A.TRANSACTION_DATE = (

Line 646: JAI_CMN_RG_OTHERS D

642: SELECT
643: MAX(C.TRANSACTION_DATE)
644: FROM
645: JAI_CMN_RG_PLA_TRXS C,
646: JAI_CMN_RG_OTHERS D
647: WHERE C.REGISTER_ID = D.SOURCE_REGISTER_ID
648: AND D.SOURCE_REGISTER = CP_SOURCE_REGISTER
649: AND D.TAX_TYPE = CP_TAX_TYPE
650: AND TRUNC(C.TRANSACTION_DATE) < TRUNC(P_TRN_FRM_DATE)

Line 667: CURSOR CUR_CESS_BAL(CP_SOURCE_REGISTER IN JAI_CMN_RG_OTHERS.SOURCE_REGISTER%TYPE,CP_TAX_TYPE IN JAI_CMN_RG_OTHERS.TAX_TYPE%TYPE) IS

663: ,2));
664: END CF_CESS_OPEN_BALFORMULA;
665:
666: FUNCTION CF_CESS_CLOSE_BALFORMULA1(REGISTER_ID IN NUMBER) RETURN NUMBER IS
667: CURSOR CUR_CESS_BAL(CP_SOURCE_REGISTER IN JAI_CMN_RG_OTHERS.SOURCE_REGISTER%TYPE,CP_TAX_TYPE IN JAI_CMN_RG_OTHERS.TAX_TYPE%TYPE) IS
668: SELECT
669: NVL(SUM(CREDIT)
670: ,0) - NVL(SUM(DEBIT)
671: ,0)

Line 673: JAI_CMN_RG_OTHERS RG_OTH

669: NVL(SUM(CREDIT)
670: ,0) - NVL(SUM(DEBIT)
671: ,0)
672: FROM
673: JAI_CMN_RG_OTHERS RG_OTH
674: WHERE RG_OTH.SOURCE_REGISTER_ID = REGISTER_ID
675: AND RG_OTH.SOURCE_REGISTER = CP_SOURCE_REGISTER
676: AND RG_OTH.TAX_TYPE = CP_TAX_TYPE;
677:

Line 713: JAI_CMN_RG_OTHERS RG_OTH

709: NVL(SUM(CREDIT)
710: ,0) - NVL(SUM(DEBIT)
711: ,0)
712: FROM
713: JAI_CMN_RG_OTHERS RG_OTH
714: WHERE RG_OTH.SOURCE_REGISTER_ID = REGISTER_ID
715: AND RG_OTH.SOURCE_REGISTER = 'PLA'
716: AND SOURCE_TYPE = 2
717: AND RG_OTH.TAX_TYPE IN ( 'EXCISE_SH_EDU_CESS' );

Line 732: CURSOR CUR_CR_CESS(CP_SOURCE_REGISTER IN JAI_CMN_RG_OTHERS.SOURCE_REGISTER%TYPE,CP_TAX_TYPE IN JAI_CMN_RG_OTHERS.TAX_TYPE%TYPE) IS

728: ,0));
729: END CF_CESS_CLOSE_BALFORMULA2;
730:
731: FUNCTION CF_CR_CESSFORMULA(REGISTER_ID IN NUMBER) RETURN NUMBER IS
732: CURSOR CUR_CR_CESS(CP_SOURCE_REGISTER IN JAI_CMN_RG_OTHERS.SOURCE_REGISTER%TYPE,CP_TAX_TYPE IN JAI_CMN_RG_OTHERS.TAX_TYPE%TYPE) IS
733: SELECT
734: NVL(SUM(CREDIT)
735: ,0)
736: FROM

Line 737: JAI_CMN_RG_OTHERS RG_OTH

733: SELECT
734: NVL(SUM(CREDIT)
735: ,0)
736: FROM
737: JAI_CMN_RG_OTHERS RG_OTH
738: WHERE RG_OTH.SOURCE_REGISTER_ID = REGISTER_ID
739: AND RG_OTH.SOURCE_REGISTER = CP_SOURCE_REGISTER
740: AND RG_OTH.TAX_TYPE = CP_TAX_TYPE;
741: CURSOR CUR_SHE_CR_CESS IS

Line 746: JAI_CMN_RG_OTHERS RG_OTH

742: SELECT
743: NVL(SUM(CREDIT)
744: ,0)
745: FROM
746: JAI_CMN_RG_OTHERS RG_OTH
747: WHERE RG_OTH.SOURCE_REGISTER_ID = REGISTER_ID
748: AND RG_OTH.SOURCE_REGISTER = 'PLA'
749: AND RG_OTH.TAX_TYPE IN ( 'EXCISE_SH_EDU_CESS' );
750: LN_SHE_CR_CESS_AMT NUMBER := 0;

Line 768: CURSOR CUR_DB_CESS(CP_SOURCE_REGISTER IN JAI_CMN_RG_OTHERS.SOURCE_REGISTER%TYPE,CP_TAX_TYPE IN JAI_CMN_RG_OTHERS.TAX_TYPE%TYPE) IS

764: ,2));
765: END CF_CR_CESSFORMULA;
766:
767: FUNCTION CF_DB_CESSFORMULA(REGISTER_ID IN NUMBER) RETURN NUMBER IS
768: CURSOR CUR_DB_CESS(CP_SOURCE_REGISTER IN JAI_CMN_RG_OTHERS.SOURCE_REGISTER%TYPE,CP_TAX_TYPE IN JAI_CMN_RG_OTHERS.TAX_TYPE%TYPE) IS
769: SELECT
770: NVL(SUM(DEBIT)
771: ,0)
772: FROM

Line 773: JAI_CMN_RG_OTHERS RG_OTH

769: SELECT
770: NVL(SUM(DEBIT)
771: ,0)
772: FROM
773: JAI_CMN_RG_OTHERS RG_OTH
774: WHERE RG_OTH.SOURCE_REGISTER_ID = REGISTER_ID
775: AND RG_OTH.SOURCE_REGISTER = CP_SOURCE_REGISTER
776: AND RG_OTH.TAX_TYPE = CP_TAX_TYPE;
777: CURSOR CUR_SHE_DB_CESS IS

Line 782: JAI_CMN_RG_OTHERS RG_OTH

778: SELECT
779: NVL(SUM(DEBIT)
780: ,0)
781: FROM
782: JAI_CMN_RG_OTHERS RG_OTH
783: WHERE RG_OTH.SOURCE_REGISTER_ID = REGISTER_ID
784: AND RG_OTH.SOURCE_REGISTER = 'PLA'
785: AND RG_OTH.TAX_TYPE IN ( 'EXCISE_SH_EDU_CESS' );
786: LN_SHE_DB_CESS_AMT NUMBER := 0;

Line 805: CURSOR CUR_CR_CVD_CESS(CP_SOURCE_REGISTER IN JAI_CMN_RG_OTHERS.SOURCE_REGISTER%TYPE,CP_TAX_TYPE IN JAI_CMN_RG_OTHERS.TAX_TYPE%TYPE) IS

801: ,2));
802: END CF_DB_CESSFORMULA;
803:
804: FUNCTION CF_CR_CVD_CESSFORMULA(REGISTER_ID IN NUMBER) RETURN NUMBER IS
805: CURSOR CUR_CR_CVD_CESS(CP_SOURCE_REGISTER IN JAI_CMN_RG_OTHERS.SOURCE_REGISTER%TYPE,CP_TAX_TYPE IN JAI_CMN_RG_OTHERS.TAX_TYPE%TYPE) IS
806: SELECT
807: NVL(SUM(CREDIT)
808: ,0)
809: FROM

Line 810: JAI_CMN_RG_OTHERS RG_OTH

806: SELECT
807: NVL(SUM(CREDIT)
808: ,0)
809: FROM
810: JAI_CMN_RG_OTHERS RG_OTH
811: WHERE RG_OTH.SOURCE_REGISTER_ID = REGISTER_ID
812: AND RG_OTH.SOURCE_REGISTER = CP_SOURCE_REGISTER
813: AND RG_OTH.TAX_TYPE = CP_TAX_TYPE;
814: CURSOR CUR_SHE_CR_CVD_CESS IS

Line 819: JAI_CMN_RG_OTHERS RG_OTH

815: SELECT
816: NVL(SUM(CREDIT)
817: ,0)
818: FROM
819: JAI_CMN_RG_OTHERS RG_OTH
820: WHERE RG_OTH.SOURCE_REGISTER_ID = REGISTER_ID
821: AND RG_OTH.SOURCE_REGISTER = 'PLA'
822: AND RG_OTH.TAX_TYPE IN ( 'CVD_SH_EDU_CESS' );
823: LN_SHE_CR_CESS_CVD_AMT NUMBER := 0;

Line 841: CURSOR CUR_DB_CVD_CESS(CP_SOURCE_REGISTER IN JAI_CMN_RG_OTHERS.SOURCE_REGISTER%TYPE,CP_TAX_TYPE IN JAI_CMN_RG_OTHERS.TAX_TYPE%TYPE) IS

837: ,2));
838: END CF_CR_CVD_CESSFORMULA;
839:
840: FUNCTION CF_DB_CVD_CESSFORMULA(REGISTER_ID IN NUMBER) RETURN NUMBER IS
841: CURSOR CUR_DB_CVD_CESS(CP_SOURCE_REGISTER IN JAI_CMN_RG_OTHERS.SOURCE_REGISTER%TYPE,CP_TAX_TYPE IN JAI_CMN_RG_OTHERS.TAX_TYPE%TYPE) IS
842: SELECT
843: NVL(SUM(DEBIT)
844: ,0)
845: FROM

Line 846: JAI_CMN_RG_OTHERS RG_OTH

842: SELECT
843: NVL(SUM(DEBIT)
844: ,0)
845: FROM
846: JAI_CMN_RG_OTHERS RG_OTH
847: WHERE RG_OTH.SOURCE_REGISTER_ID = REGISTER_ID
848: AND RG_OTH.SOURCE_REGISTER = CP_SOURCE_REGISTER
849: AND RG_OTH.TAX_TYPE = CP_TAX_TYPE;
850: CURSOR CUR_SHE_DB_CVD_CESS IS

Line 855: JAI_CMN_RG_OTHERS RG_OTH

851: SELECT
852: NVL(SUM(DEBIT)
853: ,0)
854: FROM
855: JAI_CMN_RG_OTHERS RG_OTH
856: WHERE RG_OTH.SOURCE_REGISTER_ID = REGISTER_ID
857: AND RG_OTH.SOURCE_REGISTER = 'PLA'
858: AND RG_OTH.TAX_TYPE IN ( 'CVD_SH_EDU_CESS' );
859: LN_SHE_DB_CVD_CESS_AMT NUMBER := 0;

Line 878: CURSOR CUR_CESS_CVD_BAL(CP_SOURCE_REGISTER IN JAI_CMN_RG_OTHERS.SOURCE_REGISTER%TYPE,CP_TAX_TYPE IN JAI_CMN_RG_OTHERS.TAX_TYPE%TYPE) IS

874: ,2));
875: END CF_DB_CVD_CESSFORMULA;
876:
877: FUNCTION CF_CVD_CESS_CLOS_BALFORMULA(REGISTER_ID IN NUMBER) RETURN NUMBER IS
878: CURSOR CUR_CESS_CVD_BAL(CP_SOURCE_REGISTER IN JAI_CMN_RG_OTHERS.SOURCE_REGISTER%TYPE,CP_TAX_TYPE IN JAI_CMN_RG_OTHERS.TAX_TYPE%TYPE) IS
879: SELECT
880: NVL(SUM(CREDIT)
881: ,0) - NVL(SUM(DEBIT)
882: ,0)

Line 884: JAI_CMN_RG_OTHERS RG_OTH

880: NVL(SUM(CREDIT)
881: ,0) - NVL(SUM(DEBIT)
882: ,0)
883: FROM
884: JAI_CMN_RG_OTHERS RG_OTH
885: WHERE RG_OTH.SOURCE_REGISTER_ID = REGISTER_ID
886: AND RG_OTH.SOURCE_REGISTER = CP_SOURCE_REGISTER
887: AND RG_OTH.TAX_TYPE = CP_TAX_TYPE;
888: CURSOR CUR_SHE_CESS_CVD_BAL IS

Line 894: JAI_CMN_RG_OTHERS RG_OTH

890: NVL(SUM(CREDIT)
891: ,0) - NVL(SUM(DEBIT)
892: ,0)
893: FROM
894: JAI_CMN_RG_OTHERS RG_OTH
895: WHERE RG_OTH.SOURCE_REGISTER_ID = REGISTER_ID
896: AND RG_OTH.SOURCE_REGISTER = 'PLA'
897: AND RG_OTH.TAX_TYPE IN ( 'CVD_SH_EDU_CESS' );
898: LN_SHE_CESS_CVD_BAL NUMBER := 0;

Line 928: P_TRN_FRM_DATE IN DATE,CP_SOURCE_REGISTER IN JAI_CMN_RG_OTHERS.SOURCE_REGISTER%TYPE,CP_TAX_TYPE IN JAI_CMN_RG_OTHERS.TAX_TYPE%TYPE) IS

924: END CF_CVD_CESS_CLOS_BALFORMULA;
925:
926: FUNCTION CF_CVD_CESS_OPEN_BALFORMULA RETURN NUMBER IS
927: CURSOR CUR_CVD_CESS_OPEN_BAL(P_ORG_ID IN JAI_CMN_RG_PLA_TRXS.ORGANIZATION_ID%TYPE,P_LOC_ID IN JAI_CMN_RG_PLA_TRXS.LOCATION_ID%TYPE,
928: P_TRN_FRM_DATE IN DATE,CP_SOURCE_REGISTER IN JAI_CMN_RG_OTHERS.SOURCE_REGISTER%TYPE,CP_TAX_TYPE IN JAI_CMN_RG_OTHERS.TAX_TYPE%TYPE) IS
929: SELECT
930: CLOSING_BALANCE
931: FROM
932: JAI_CMN_RG_OTHERS

Line 932: JAI_CMN_RG_OTHERS

928: P_TRN_FRM_DATE IN DATE,CP_SOURCE_REGISTER IN JAI_CMN_RG_OTHERS.SOURCE_REGISTER%TYPE,CP_TAX_TYPE IN JAI_CMN_RG_OTHERS.TAX_TYPE%TYPE) IS
929: SELECT
930: CLOSING_BALANCE
931: FROM
932: JAI_CMN_RG_OTHERS
933: WHERE SOURCE_REGISTER = CP_SOURCE_REGISTER
934: AND TAX_TYPE = CP_TAX_TYPE
935: AND SOURCE_REGISTER_ID = (
936: SELECT

Line 940: JAI_CMN_RG_OTHERS B

936: SELECT
937: MAX(A.REGISTER_ID)
938: FROM
939: JAI_CMN_RG_PLA_TRXS A,
940: JAI_CMN_RG_OTHERS B
941: WHERE A.REGISTER_ID = B.SOURCE_REGISTER_ID
942: AND B.SOURCE_REGISTER = CP_SOURCE_REGISTER
943: AND B.TAX_TYPE = CP_TAX_TYPE
944: AND A.TRANSACTION_DATE = (

Line 949: JAI_CMN_RG_OTHERS D

945: SELECT
946: MAX(C.TRANSACTION_DATE)
947: FROM
948: JAI_CMN_RG_PLA_TRXS C,
949: JAI_CMN_RG_OTHERS D
950: WHERE C.REGISTER_ID = D.SOURCE_REGISTER_ID
951: AND D.SOURCE_REGISTER = CP_SOURCE_REGISTER
952: AND D.TAX_TYPE = CP_TAX_TYPE
953: AND TRUNC(C.TRANSACTION_DATE) < TRUNC(P_TRN_FRM_DATE)

Line 998: JAI_CMN_RG_OTHERS

994: SUM(NVL(DEBIT
995: ,0) - NVL(CREDIT
996: ,0))
997: FROM
998: JAI_CMN_RG_OTHERS
999: WHERE SOURCE_REGISTER_ID = CP_REGISTER_ID
1000: AND SOURCE_TYPE = CP_SOURCE_TYPE
1001: AND TAX_TYPE = P_TAX_TYPE;
1002: V_RND_BASIC_ED NUMBER;

Line 1110: JAI_CMN_RG_OTHERS JCRG

1106: AND EXISTS (
1107: SELECT
1108: 1
1109: FROM
1110: JAI_CMN_RG_OTHERS JCRG
1111: WHERE JCRG.SOURCE_REGISTER_ID = JCRPT1.REGISTER_ID
1112: AND JCRG.SOURCE_TYPE = 2
1113: AND JCRG.SOURCE_REGISTER = 'PLA'
1114: AND JCRG.TAX_TYPE = CP_TAX_TYPE ) )

Line 1120: JAI_CMN_RG_OTHERS

1116: CURSOR CUR_OPEN_BAL(CP_REGISTER_ID IN NUMBER,CP_TAX_TYPE IN VARCHAR2) IS
1117: SELECT
1118: CLOSING_BALANCE
1119: FROM
1120: JAI_CMN_RG_OTHERS
1121: WHERE SOURCE_REGISTER_ID = CP_REGISTER_ID
1122: AND TAX_TYPE = CP_TAX_TYPE
1123: AND SOURCE_REGISTER = 'PLA';
1124: LN_EXC_CESS_OPEN_BAL NUMBER := 0;