APPS.JA_JAINYEDE_XMLP_PKG dependencies on JAI_FA_DEP_BLOCKS_T

Line 847: JAI_FA_DEP_BLOCKS_T

843: SUM(SLNO) COST,
844: SUM(FULL_EXEMPT) COST_FULL,
845: BLOCK_ID
846: FROM
847: JAI_FA_DEP_BLOCKS_T
848: GROUP BY
849: BLOCK_ID;
850: CURSOR TYPE_CUR(P_BLOCK_ID IN NUMBER) IS
851: SELECT

Line 1424: JAI_FA_DEP_BLOCKS_T

1420: SUM(SLNO) COST,
1421: SUM(FULL_EXEMPT) COST_FULL,
1422: BLOCK_ID
1423: FROM
1424: JAI_FA_DEP_BLOCKS_T
1425: GROUP BY
1426: BLOCK_ID;
1427: CURSOR TYPE_CUR(P_BLOCK_ID IN NUMBER) IS
1428: SELECT

Line 1992: ,'3.81 Before insert into JAI_FA_DEP_BLOCKS_T block_id ' || V_BLOCK_ID || ' , ' || 'slno' || ROUND(NVL(V_COST

1988: ,0);
1989: /*SRW.MESSAGE(1275
1990: ,'3.8 v_depn_amount -> ' || V_DEPN_AMOUNT || ', v_closing_balance -> ' || V_CLOSING_BALANCE || ', v_cost -> ' || V_COST || ', v_more_amount -> ' || V_MORE_AMOUNT)*/NULL;
1991: /*SRW.MESSAGE(1275
1992: ,'3.81 Before insert into JAI_FA_DEP_BLOCKS_T block_id ' || V_BLOCK_ID || ' , ' || 'slno' || ROUND(NVL(V_COST
1993: ,0)
1994: ,2) || ' , ' || 'depn_of_assets ' || ROUND(NVL(V_MORE_AMOUNT
1995: ,0)
1996: ,2) || ' , ' || 'year_ended ' || P_YEAR_END || ' , ' || 'full_exempt ' || NVL(V_MORE_AMOUNT1

Line 2000: INSERT INTO JAI_FA_DEP_BLOCKS_T

1996: ,2) || ' , ' || 'year_ended ' || P_YEAR_END || ' , ' || 'full_exempt ' || NVL(V_MORE_AMOUNT1
1997: ,0) || ' , ' || 'total_balance ' || ROUND(NVL(V_CLOSING_BALANCE
1998: ,0)
1999: ,2) || ' , ' || 'unplanned_depn ' || V_SLNO || ' , ' || 'asset_id ' || V_ASSET_ID)*/NULL;
2000: INSERT INTO JAI_FA_DEP_BLOCKS_T
2001: (BLOCK_ID
2002: ,SLNO
2003: ,DEPN_OF_ASSETS
2004: ,YEAR_ENDED

Line 2035: ,'3.82 After insert into JAI_FA_DEP_BLOCKS_T')*/NULL;

2031: ,2)
2032: ,V_SLNO
2033: ,V_ASSET_ID);
2034: /*SRW.MESSAGE(1275
2035: ,'3.82 After insert into JAI_FA_DEP_BLOCKS_T')*/NULL;
2036: /*SRW.MESSAGE(1275
2037: ,'3.9 v_depn_slno -> ' || V_DEPN_SLNO)*/NULL;
2038: IF V_DEPN_SLNO = 0 THEN
2039: IF V_FLAG OR I = 1 THEN

Line 2155: ,'5.1 Start of processing tempoprary table JAI_FA_DEP_BLOCKS_T cursor temp_tab')*/NULL;

2151: END IF;
2152: END IF;
2153: END LOOP;
2154: /*SRW.MESSAGE(1275
2155: ,'5.1 Start of processing tempoprary table JAI_FA_DEP_BLOCKS_T cursor temp_tab')*/NULL;
2156: FOR temp_rec IN TEMP_TAB LOOP
2157: V_CLOSING := 0;
2158: V_CLOSING1 := 0;
2159: V_CLOSING_BALANCE := 0;

Line 2855: JAI_FA_DEP_BLOCKS_T

2851: SUM(SLNO) COST,
2852: SUM(FULL_EXEMPT) COST_FULL,
2853: BLOCK_ID
2854: FROM
2855: JAI_FA_DEP_BLOCKS_T
2856: GROUP BY
2857: BLOCK_ID;
2858: CURSOR TYPE_CUR(P_BLOCK_ID IN NUMBER) IS
2859: SELECT

Line 3322: INSERT INTO JAI_FA_DEP_BLOCKS_T

3318: V_DEPN_AMOUNT := V_DEPN_AMOUNT + V_MORE_AMOUNT;
3319: V_CLOSING_BALANCE := NVL(V_COST
3320: ,0) - NVL(V_MORE_AMOUNT
3321: ,0);
3322: INSERT INTO JAI_FA_DEP_BLOCKS_T
3323: (BLOCK_ID
3324: ,SLNO
3325: ,DEPN_OF_ASSETS
3326: ,YEAR_ENDED

Line 3859: DELETE FROM JAI_FA_DEP_BLOCKS_T;

3855: END RUN_DEP_MASS;
3856:
3857: FUNCTION AFTERREPORT RETURN BOOLEAN IS
3858: BEGIN
3859: DELETE FROM JAI_FA_DEP_BLOCKS_T;
3860: COMMIT;
3861: /*SRW.USER_EXIT('FND SRWEXIT')*/NULL;
3862: RETURN (TRUE);
3863: END AFTERREPORT;

Line 3871: JAI_FA_DEP_BLOCKS_T

3867: SELECT
3868: NVL(SUM(SLNO)
3869: ,0) COST
3870: FROM
3871: JAI_FA_DEP_BLOCKS_T
3872: WHERE ASSET_ID Not In (
3873: SELECT
3874: ASSET_ID
3875: FROM

Line 4047: JAI_FA_DEP_BLOCKS_T

4043: SELECT
4044: NVL(SUM(SLNO)
4045: ,0) COST
4046: FROM
4047: JAI_FA_DEP_BLOCKS_T
4048: WHERE BLOCK_ID = P_BLOCK_ID;
4049: CURSOR TOTOPBAL_CUR IS
4050: SELECT
4051: NVL(OPENING_WDV