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

Line 88: JAI_CMN_RG_OTHERS B

84: ,0) - NVL(DEBIT
85: ,0))
86: FROM
87: JAI_CMN_RG_23AC_II_TRXS A,
88: JAI_CMN_RG_OTHERS B
89: WHERE ORGANIZATION_ID = P_ORGANIZATION_ID
90: AND LOCATION_ID = P_LOCATION_ID
91: AND REGISTER_TYPE = P_REGISTER_TYPE
92: AND TRUNC(A.CREATION_DATE) > CP_DELTA_START_DATE

Line 526: CURSOR C_ROUNDED_EXCISE_CESS(CP_REGISTER_ID IN NUMBER,CP_TAX_TYPE IN JAI_CMN_RG_OTHERS.TAX_TYPE%TYPE) IS

522: V_PARENT_INCLUDED_CNT NUMBER;
523: V_TOTAL_ROUND_AMOUNT NUMBER := 0;
524: LN_EXCISE_CESS NUMBER := 0;
525: LN_CVD_CESS NUMBER := 0;
526: CURSOR C_ROUNDED_EXCISE_CESS(CP_REGISTER_ID IN NUMBER,CP_TAX_TYPE IN JAI_CMN_RG_OTHERS.TAX_TYPE%TYPE) IS
527: SELECT
528: NVL(DEBIT
529: ,0) - NVL(CREDIT
530: ,0)

Line 532: JAI_CMN_RG_OTHERS

528: NVL(DEBIT
529: ,0) - NVL(CREDIT
530: ,0)
531: FROM
532: JAI_CMN_RG_OTHERS
533: WHERE SOURCE_REGISTER_ID = CP_REGISTER_ID
534: AND SOURCE_TYPE = 1
535: AND TAX_TYPE = CP_TAX_TYPE;
536: CURSOR C_ROUNDED_CVD_CESS(CP_REGISTER_ID IN NUMBER,CP_TAX_TYPE IN JAI_CMN_RG_OTHERS.TAX_TYPE%TYPE) IS

Line 536: CURSOR C_ROUNDED_CVD_CESS(CP_REGISTER_ID IN NUMBER,CP_TAX_TYPE IN JAI_CMN_RG_OTHERS.TAX_TYPE%TYPE) IS

532: JAI_CMN_RG_OTHERS
533: WHERE SOURCE_REGISTER_ID = CP_REGISTER_ID
534: AND SOURCE_TYPE = 1
535: AND TAX_TYPE = CP_TAX_TYPE;
536: CURSOR C_ROUNDED_CVD_CESS(CP_REGISTER_ID IN NUMBER,CP_TAX_TYPE IN JAI_CMN_RG_OTHERS.TAX_TYPE%TYPE) IS
537: SELECT
538: NVL(DEBIT
539: ,0) - NVL(CREDIT
540: ,0)

Line 542: JAI_CMN_RG_OTHERS

538: NVL(DEBIT
539: ,0) - NVL(CREDIT
540: ,0)
541: FROM
542: JAI_CMN_RG_OTHERS
543: WHERE SOURCE_REGISTER_ID = CP_REGISTER_ID
544: AND SOURCE_TYPE = 1
545: AND TAX_TYPE = CP_TAX_TYPE;
546: CURSOR C_RCV_TRX_TYPE(CP_TRANSACTION_ID IN NUMBER) IS

Line 798: CURSOR CUR_CREDIT(CP_TAX_TYPE IN JAI_CMN_RG_OTHERS.TAX_TYPE%TYPE) IS

794: ,VENDOR_ID_1 IN NUMBER
795: ,VENDOR_SITE_ID_1 IN NUMBER
796: ,CUSTOMER_ID_1 IN NUMBER
797: ,CUSTOMER_SITE_ID_1 IN NUMBER) RETURN NUMBER IS
798: CURSOR CUR_CREDIT(CP_TAX_TYPE IN JAI_CMN_RG_OTHERS.TAX_TYPE%TYPE) IS
799: SELECT
800: SUM(NVL(CREDIT
801: ,0))
802: FROM

Line 803: JAI_CMN_RG_OTHERS

799: SELECT
800: SUM(NVL(CREDIT
801: ,0))
802: FROM
803: JAI_CMN_RG_OTHERS
804: WHERE SOURCE_REGISTER = DECODE(P_REGISTER_TYPE
805: ,'A'
806: ,'RG23A_P2'
807: ,'C'

Line 836: V_CREDIT JAI_CMN_RG_OTHERS.CREDIT%TYPE;

832: OR ( CUSTOMER_SITE_ID = CUSTOMER_SITE_ID_1 ) )
833: AND REGISTER_TYPE = P_REGISTER_TYPE
834: AND ORGANIZATION_ID = P_ORGANIZATION_ID
835: AND LOCATION_ID = P_LOCATION_ID );
836: V_CREDIT JAI_CMN_RG_OTHERS.CREDIT%TYPE;
837: BEGIN
838: OPEN CUR_CREDIT('CVD_EDUCATION_CESS');
839: FETCH CUR_CREDIT
840: INTO V_CREDIT;

Line 854: CURSOR CUR_CREDIT(CP_TAX_TYPE IN JAI_CMN_RG_OTHERS.TAX_TYPE%TYPE) IS

850: ,VENDOR_ID_1 IN NUMBER
851: ,VENDOR_SITE_ID_1 IN NUMBER
852: ,CUSTOMER_ID_1 IN NUMBER
853: ,CUSTOMER_SITE_ID_1 IN NUMBER) RETURN NUMBER IS
854: CURSOR CUR_CREDIT(CP_TAX_TYPE IN JAI_CMN_RG_OTHERS.TAX_TYPE%TYPE) IS
855: SELECT
856: SUM(NVL(CREDIT
857: ,0))
858: FROM

Line 859: JAI_CMN_RG_OTHERS

855: SELECT
856: SUM(NVL(CREDIT
857: ,0))
858: FROM
859: JAI_CMN_RG_OTHERS
860: WHERE SOURCE_REGISTER = DECODE(P_REGISTER_TYPE
861: ,'A'
862: ,'RG23A_P2'
863: ,'C'

Line 892: V_CREDIT JAI_CMN_RG_OTHERS.CREDIT%TYPE;

888: OR ( CUSTOMER_SITE_ID = CUSTOMER_SITE_ID_1 ) )
889: AND REGISTER_TYPE = P_REGISTER_TYPE
890: AND ORGANIZATION_ID = P_ORGANIZATION_ID
891: AND LOCATION_ID = P_LOCATION_ID );
892: V_CREDIT JAI_CMN_RG_OTHERS.CREDIT%TYPE;
893: BEGIN
894: OPEN CUR_CREDIT('EXCISE_EDUCATION_CESS');
895: FETCH CUR_CREDIT
896: INTO V_CREDIT;

Line 1007: JAI_CMN_RG_OTHERS

1003: SELECT
1004: SUM(NVL(CREDIT
1005: ,0))
1006: FROM
1007: JAI_CMN_RG_OTHERS
1008: WHERE SOURCE_REGISTER = DECODE(P_REGISTER_TYPE
1009: ,'A'
1010: ,'RG23A_P2'
1011: ,'C'

Line 1049: V_CREDIT JAI_CMN_RG_OTHERS.CREDIT%TYPE;

1045: ,TRUNC(CREATION_DATE))
1046: AND ( ( TRANSACTION_SOURCE_NUM IS NULL
1047: AND TRANSACTION_ID IS NULL )
1048: OR ( TRANSACTION_SOURCE_NUM = TRANSACTION_ID ) ) );
1049: V_CREDIT JAI_CMN_RG_OTHERS.CREDIT%TYPE;
1050: BEGIN
1051: OPEN CUR_CREDIT;
1052: FETCH CUR_CREDIT
1053: INTO V_CREDIT;

Line 1071: JAI_CMN_RG_OTHERS

1067: SELECT
1068: SUM(NVL(CREDIT
1069: ,0))
1070: FROM
1071: JAI_CMN_RG_OTHERS
1072: WHERE SOURCE_REGISTER = DECODE(P_REGISTER_TYPE
1073: ,'A'
1074: ,'RG23A_P2'
1075: ,'C'

Line 1113: V_CREDIT JAI_CMN_RG_OTHERS.CREDIT%TYPE;

1109: ,TRUNC(CREATION_DATE))
1110: AND ( ( TRANSACTION_SOURCE_NUM IS NULL
1111: AND TRANSACTION_ID IS NULL )
1112: OR ( TRANSACTION_SOURCE_NUM = TRANSACTION_ID ) ) );
1113: V_CREDIT JAI_CMN_RG_OTHERS.CREDIT%TYPE;
1114: BEGIN
1115: OPEN CUR_CREDIT;
1116: FETCH CUR_CREDIT
1117: INTO V_CREDIT;

Line 1135: JAI_CMN_RG_OTHERS

1131: SELECT
1132: SUM(NVL(DEBIT
1133: ,0))
1134: FROM
1135: JAI_CMN_RG_OTHERS
1136: WHERE SOURCE_REGISTER = DECODE(P_REGISTER_TYPE
1137: ,'A'
1138: ,'RG23A_P2'
1139: ,'C'

Line 1177: V_DEBIT JAI_CMN_RG_OTHERS.CREDIT%TYPE;

1173: ,TRUNC(CREATION_DATE))
1174: AND ( ( TRANSACTION_SOURCE_NUM IS NULL
1175: AND TRANSACTION_ID IS NULL )
1176: OR ( TRANSACTION_SOURCE_NUM = TRANSACTION_ID ) ) );
1177: V_DEBIT JAI_CMN_RG_OTHERS.CREDIT%TYPE;
1178: BEGIN
1179: OPEN CUR_DEBIT;
1180: FETCH CUR_DEBIT
1181: INTO V_DEBIT;

Line 1199: JAI_CMN_RG_OTHERS

1195: SELECT
1196: SUM(NVL(DEBIT
1197: ,0))
1198: FROM
1199: JAI_CMN_RG_OTHERS
1200: WHERE SOURCE_REGISTER = DECODE(P_REGISTER_TYPE
1201: ,'A'
1202: ,'RG23A_P2'
1203: ,'C'

Line 1241: V_DEBIT JAI_CMN_RG_OTHERS.CREDIT%TYPE;

1237: ,TRUNC(CREATION_DATE))
1238: AND ( ( TRANSACTION_SOURCE_NUM IS NULL
1239: AND TRANSACTION_ID IS NULL )
1240: OR ( TRANSACTION_SOURCE_NUM = TRANSACTION_ID ) ) );
1241: V_DEBIT JAI_CMN_RG_OTHERS.CREDIT%TYPE;
1242: BEGIN
1243: OPEN CUR_DEBIT;
1244: FETCH CUR_DEBIT
1245: INTO V_DEBIT;