APPS.JA_JAINYEDE_XMLP_PKG dependencies on JAI_FA_EXEMPTIONS

Line 866: JAI_FA_EXEMPTIONS

862: SELECT
863: SUM(EXEMPT_AMOUNT) L_AMOUNT,
864: BLOCK_ID
865: FROM
866: JAI_FA_EXEMPTIONS
867: WHERE BLOCK_ID = P_BLOCK_ID
868: GROUP BY
869: BLOCK_ID;
870: CURSOR RETIRE_ASSET_CUR(P_ASSET_ID IN NUMBER,P_BLOCK_ID IN NUMBER) IS

Line 1445: JAI_FA_EXEMPTIONS

1441: SELECT
1442: SUM(EXEMPT_AMOUNT) L_AMOUNT,
1443: BLOCK_ID
1444: FROM
1445: JAI_FA_EXEMPTIONS
1446: WHERE BLOCK_ID = P_BLOCK_ID
1447: GROUP BY
1448: BLOCK_ID;
1449: CURSOR RETIRE_ASSET_CUR(P_ASSET_ID IN NUMBER,P_BLOCK_ID IN NUMBER) IS

Line 2091: INSERT INTO JAI_FA_EXEMPTIONS

2087: v_block_id ,
2088: ln_transaction_header_id_in
2089: ) LOOP
2090: V_COST_LESS := LESS_EXEMPT.COSTING;
2091: INSERT INTO JAI_FA_EXEMPTIONS
2092: (BLOCK_ID
2093: ,EXEMPT_AMOUNT
2094: ,FA_EXEMPTION_ID
2095: ,CREATED_BY

Line 2105: ,JAI_FA_EXEMPTIONS_S.NEXTVAL

2101: VALUES (V_BLOCK_ID
2102: ,ROUND(NVL(V_COST_LESS
2103: ,0)
2104: ,2)
2105: ,JAI_FA_EXEMPTIONS_S.NEXTVAL
2106: ,FND_GLOBAL.USER_ID
2107: ,SYSDATE
2108: ,FND_GLOBAL.USER_ID
2109: ,SYSDATE

Line 2113: ,'4.2 Inserted into JAI_FA_EXEMPTIONS, v_cost_less -> ' || V_COST_LESS || ', v_depn_slno -> ' || V_DEPN_SLNO)*/NULL;

2109: ,SYSDATE
2110: ,FND_GLOBAL.LOGIN_ID
2111: ,NULL);
2112: /*SRW.MESSAGE(1275
2113: ,'4.2 Inserted into JAI_FA_EXEMPTIONS, v_cost_less -> ' || V_COST_LESS || ', v_depn_slno -> ' || V_DEPN_SLNO)*/NULL;
2114: IF V_DEPN_SLNO = 0 THEN
2115: /*SRW.MESSAGE(1275
2116: ,'4.3 Inserted into JAI_FA_DEP_BLOCKS, V_block_id -> ' || V_BLOCK_ID || ', v_cost_less -> ' || NVL(V_COST_LESS
2117: ,0) || ', v_slno -> ' || V_SLNO)*/NULL;

Line 2609: DELETE FROM JAI_FA_EXEMPTIONS;

2605: OR DEPN_ADJ IS NOT NULL
2606: AND BOOK_TYPE_CODE = P_BOOK_NAME;
2607: /*SRW.MESSAGE(1275
2608: ,'8.1 After update of JAI_FA_AST_BLOCKS, cnt -> ' || SQL%ROWCOUNT)*/NULL;
2609: DELETE FROM JAI_FA_EXEMPTIONS;
2610: /*SRW.MESSAGE(1275
2611: ,'8.2 before commit and after delete of JAI_FA_EXEMPTIONS, cnt -> ' || SQL%ROWCOUNT)*/NULL;
2612: COMMIT;
2613: /*SRW.MESSAGE(1275

Line 2611: ,'8.2 before commit and after delete of JAI_FA_EXEMPTIONS, cnt -> ' || SQL%ROWCOUNT)*/NULL;

2607: /*SRW.MESSAGE(1275
2608: ,'8.1 After update of JAI_FA_AST_BLOCKS, cnt -> ' || SQL%ROWCOUNT)*/NULL;
2609: DELETE FROM JAI_FA_EXEMPTIONS;
2610: /*SRW.MESSAGE(1275
2611: ,'8.2 before commit and after delete of JAI_FA_EXEMPTIONS, cnt -> ' || SQL%ROWCOUNT)*/NULL;
2612: COMMIT;
2613: /*SRW.MESSAGE(1275
2614: ,'Committed the records....RUN_DEP')*/NULL;
2615: EXCEPTION

Line 2876: JAI_FA_EXEMPTIONS

2872: SELECT
2873: SUM(EXEMPT_AMOUNT) L_AMOUNT,
2874: BLOCK_ID
2875: FROM
2876: JAI_FA_EXEMPTIONS
2877: WHERE BLOCK_ID = P_BLOCK_ID
2878: GROUP BY
2879: BLOCK_ID;
2880: CURSOR RETIRE_ASSET_CUR(P_ASSET_ID IN NUMBER,P_BLOCK_ID IN NUMBER) IS

Line 3391: INSERT INTO JAI_FA_EXEMPTIONS

3387: END IF;
3388: FOR less_exempt IN COST_LESS_EXEMPT_UPTO_CUR(v_asset_id,v_start_date,
3389: v_end_date ,nvl(v_exempt_upto,0),v_block_id ) LOOP
3390: V_COST_LESS := LESS_EXEMPT.COSTING;
3391: INSERT INTO JAI_FA_EXEMPTIONS
3392: (BLOCK_ID
3393: ,EXEMPT_AMOUNT
3394: ,FA_EXEMPTION_ID
3395: ,CREATED_BY

Line 3405: ,JAI_FA_EXEMPTIONS_S.NEXTVAL

3401: VALUES (V_BLOCK_ID
3402: ,ROUND(NVL(V_COST_LESS
3403: ,0)
3404: ,2)
3405: ,JAI_FA_EXEMPTIONS_S.NEXTVAL
3406: ,FND_GLOBAL.USER_ID
3407: ,SYSDATE
3408: ,FND_GLOBAL.USER_ID
3409: ,SYSDATE

Line 3853: DELETE FROM JAI_FA_EXEMPTIONS;

3849: AND P_YEAR_END
3850: AND OPENING_WDV_ADJ is not null
3851: OR DEPN_ADJ is not null
3852: AND BOOK_TYPE_CODE = P_BOOK_NAME;
3853: DELETE FROM JAI_FA_EXEMPTIONS;
3854: COMMIT;
3855: END RUN_DEP_MASS;
3856:
3857: FUNCTION AFTERREPORT RETURN BOOLEAN IS