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_PLA_TRXS

Line 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,

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
81: ,0)

Line 90: JAI_CMN_RG_PLA_TRXS A,

86: AND SOURCE_REGISTER_ID = (
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

Line 99: JAI_CMN_RG_PLA_TRXS C,

95: AND A.TRANSACTION_DATE = (
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

Line 128: JAI_CMN_RG_PLA_TRXS

124: ,0)) - SUM(NVL(DR_OTHER_ED
125: ,0))
126: INTO P_BED_OPEN_BAL,P_AED_OPEN_BAL,P_SED_OPEN_BAL
127: FROM
128: JAI_CMN_RG_PLA_TRXS
129: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
130: AND LOCATION_ID = P_LOCATION_ID
131: AND TRUNC(CREATION_DATE) <= TRUNC(P_TRN_FROM_DATE) - 1;
132: LV_TAX_TYPE := 'EXCISE_EDUCATION_CESS';

Line 380: JAI_CMN_RG_PLA_TRXS

376: CURSOR OPEN_BAL1(FRM_DT IN DATE) IS
377: SELECT
378: OPENING_BALANCE
379: FROM
380: JAI_CMN_RG_PLA_TRXS
381: WHERE TRUNC(CREATION_DATE) >= TRUNC(FRM_DT)
382: AND REGISTER_ID = (
383: SELECT
384: MIN(REGISTER_ID)

Line 386: JAI_CMN_RG_PLA_TRXS

382: AND REGISTER_ID = (
383: SELECT
384: MIN(REGISTER_ID)
385: FROM
386: JAI_CMN_RG_PLA_TRXS
387: WHERE TRUNC(CREATION_DATE) >= TRUNC(FRM_DT) );
388: CURSOR OPEN_BAL2 IS
389: SELECT
390: OPENING_BALANCE

Line 392: JAI_CMN_RG_PLA_TRXS

388: CURSOR OPEN_BAL2 IS
389: SELECT
390: OPENING_BALANCE
391: FROM
392: JAI_CMN_RG_PLA_TRXS
393: WHERE REGISTER_ID = (
394: SELECT
395: MIN(REGISTER_ID)
396: FROM

Line 397: JAI_CMN_RG_PLA_TRXS );

393: WHERE REGISTER_ID = (
394: SELECT
395: MIN(REGISTER_ID)
396: FROM
397: JAI_CMN_RG_PLA_TRXS );
398: OPEN_BAL NUMBER;
399: BEGIN
400: IF P_TRN_FROM_DATE IS NOT NULL THEN
401: OPEN OPEN_BAL1(P_TRN_FROM_DATE);

Line 425: JAI_CMN_RG_PLA_TRXS

421: ,0) - NVL(SUM(DR_BASIC_ED)
422: ,0)
423: INTO BASIC_BAL
424: FROM
425: JAI_CMN_RG_PLA_TRXS
426: WHERE TRUNC(CREATION_DATE) < TRUNC(P_TRN_FROM_DATE)
427: AND ORGANIZATION_ID = P_ORGANIZATION_ID
428: AND LOCATION_ID = P_LOCATION_ID;
429: EXCEPTION

Line 451: JAI_CMN_RG_PLA_TRXS

447: ,0) - NVL(SUM(DR_ADDITIONAL_ED)
448: ,0)
449: INTO ADDITIONAL_BAL
450: FROM
451: JAI_CMN_RG_PLA_TRXS
452: WHERE TRUNC(CREATION_DATE) < TRUNC(P_TRN_FROM_DATE)
453: AND ORGANIZATION_ID = P_ORGANIZATION_ID
454: AND LOCATION_ID = P_LOCATION_ID;
455: EXCEPTION

Line 478: JAI_CMN_RG_PLA_TRXS

474: ,0) - NVL(SUM(DR_OTHER_ED)
475: ,0)
476: INTO OTHER_BAL
477: FROM
478: JAI_CMN_RG_PLA_TRXS
479: WHERE TRUNC(CREATION_DATE) < TRUNC(P_TRN_FROM_DATE)
480: AND ORGANIZATION_ID = P_ORGANIZATION_ID
481: AND LOCATION_ID = P_LOCATION_ID;
482: EXCEPTION

Line 504: JAI_CMN_RG_PLA_TRXS B

500: FOR C_FETCH_ACK_DATE IN (SELECT
501: ACK_RECVD_DATE
502: FROM
503: JAI_CMN_RG_PLA_HDRS A,
504: JAI_CMN_RG_PLA_TRXS B
505: WHERE A.PLA_RG_SR_NO = B.SLNO
506: AND A.ORGANIZATION_ID = B.ORGANIZATION_ID
507: AND A.LOCATION_ID = B.LOCATION_ID
508: AND B.REGISTER_ID = CF_ACK_RECD_DATEFORMULA.REGISTER_ID

Line 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,

620: OPENING_BALANCE;
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

Line 636: JAI_CMN_RG_PLA_TRXS A,

632: AND SOURCE_REGISTER_ID = (
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

Line 645: JAI_CMN_RG_PLA_TRXS C,

641: AND A.TRANSACTION_DATE = (
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

Line 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,

923: ,0));
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

Line 939: JAI_CMN_RG_PLA_TRXS A,

935: AND SOURCE_REGISTER_ID = (
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

Line 948: JAI_CMN_RG_PLA_TRXS C,

944: AND A.TRANSACTION_DATE = (
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

Line 990: JAI_CMN_RG_PLA_TRXS

986: - NVL(CR_OTHER_ED
987: ,0) + NVL(DR_OTHER_ED
988: ,0) OTHER_ED
989: FROM
990: JAI_CMN_RG_PLA_TRXS
991: WHERE REGISTER_ID = CP_REGISTER_ID;
992: CURSOR C_RND_CESS_AMT(CP_REGISTER_ID IN NUMBER,CP_SOURCE_TYPE IN NUMBER,P_TAX_TYPE IN VARCHAR2) IS
993: SELECT
994: SUM(NVL(DEBIT

Line 1094: JAI_CMN_RG_PLA_TRXS JCRPT

1090: CURSOR CUR_REG_ID(CP_TAX_TYPE IN VARCHAR2,CP_FIN_YEAR IN NUMBER) IS
1091: SELECT
1092: JCRPT.REGISTER_ID
1093: FROM
1094: JAI_CMN_RG_PLA_TRXS JCRPT
1095: WHERE JCRPT.LOCATION_ID = P_LOCATION_ID
1096: AND JCRPT.ORGANIZATION_ID = P_ORGANIZATION_ID
1097: AND JCRPT.SLNO = (
1098: SELECT

Line 1101: JAI_CMN_RG_PLA_TRXS JCRPT1

1097: AND JCRPT.SLNO = (
1098: SELECT
1099: MAX(JCRPT1.SLNO)
1100: FROM
1101: JAI_CMN_RG_PLA_TRXS JCRPT1
1102: WHERE JCRPT1.LOCATION_ID = P_LOCATION_ID
1103: AND JCRPT1.ORGANIZATION_ID = P_ORGANIZATION_ID
1104: AND JCRPT1.CREATION_DATE < P_TRN_FROM_DATE
1105: AND JCRPT1.FIN_YEAR = CP_FIN_YEAR

Line 1130: LN_REG_ID JAI_CMN_RG_PLA_TRXS.REGISTER_ID%TYPE;

1126: LV_MAST_ORG_FLAG JAI_CMN_INVENTORY_ORGS.MASTER_ORG_FLAG%TYPE;
1127: LN_MIN_REG_ID NUMBER;
1128: LN_MAX_REG_ID NUMBER;
1129: LN_FIN_YEAR NUMBER;
1130: LN_REG_ID JAI_CMN_RG_PLA_TRXS.REGISTER_ID%TYPE;
1131: LN_EXC_SHE_CESS_OPEN_BAL NUMBER := 0;
1132: LN_CVD_SHE_CESS_OPEN_BAL NUMBER := 0;
1133: BEGIN
1134: OPEN CUR_FIN_YEAR(P_ORGANIZATION_ID,P_TRN_FROM_DATE);

Line 1146: JAI_CMN_RG_PLA_TRXS

1142: ,0) - NVL(SUM(DR_BASIC_ED)
1143: ,0)
1144: INTO BASIC_BAL
1145: FROM
1146: JAI_CMN_RG_PLA_TRXS
1147: WHERE TRUNC(CREATION_DATE) < TRUNC(P_TRN_FROM_DATE)
1148: AND ORGANIZATION_ID = P_ORGANIZATION_ID
1149: AND LOCATION_ID = P_LOCATION_ID;
1150: ELSE

Line 1165: JAI_CMN_RG_PLA_TRXS

1161: ,0) - NVL(SUM(DR_ADDITIONAL_ED)
1162: ,0)
1163: INTO ADDITIONAL_BAL
1164: FROM
1165: JAI_CMN_RG_PLA_TRXS
1166: WHERE TRUNC(CREATION_DATE) < TRUNC(P_TRN_FROM_DATE)
1167: AND ORGANIZATION_ID = P_ORGANIZATION_ID
1168: AND LOCATION_ID = P_LOCATION_ID;
1169: ELSE

Line 1184: JAI_CMN_RG_PLA_TRXS

1180: ,0) - NVL(SUM(DR_OTHER_ED)
1181: ,0)
1182: INTO OTHER_BAL
1183: FROM
1184: JAI_CMN_RG_PLA_TRXS
1185: WHERE TRUNC(CREATION_DATE) < TRUNC(P_TRN_FROM_DATE)
1186: AND ORGANIZATION_ID = P_ORGANIZATION_ID
1187: AND LOCATION_ID = P_LOCATION_ID;
1188: ELSE