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_JAINYEDE_XMLP_PKG dependencies on JAI_FA_DEP_BLOCKS

Line 463: JAI_FA_DEP_BLOCKS

459: CURSOR V_DEPN_ADJUSTMENT_CUR IS
460: SELECT
461: count(*)
462: FROM
463: JAI_FA_DEP_BLOCKS
464: WHERE TO_CHAR(BLOCK_ID) = TO_CHAR(P_BLOCK_ID)
465: AND SLNO = - 1;
466: BEGIN
467: /*SRW.MESSAGE(1051

Line 529: INSERT INTO JAI_FA_DEP_BLOCKS

525: ,'p_depn_adj is not null...DEPRECIATION1')*/NULL;
526: IF V_COUNT = 0 THEN
527: /*SRW.MESSAGE(1056
528: ,'v_count is 0...DEPRECIATION1')*/NULL;
529: INSERT INTO JAI_FA_DEP_BLOCKS
530: (BLOCK_DEPN_ID
531: ,BLOCK_ID
532: ,SLNO
533: ,DEPN_OF_ASSETS

Line 541: VALUES (JAI_FA_DEP_BLOCKS_S.NEXTVAL

537: ,CREATED_BY
538: ,LAST_UPDATE_DATE
539: ,LAST_UPDATE_LOGIN
540: ,LAST_UPDATED_BY)
541: VALUES (JAI_FA_DEP_BLOCKS_S.NEXTVAL
542: ,P_BLOCK_ID
543: ,-1
544: ,NULL
545: ,P_DEPN_ADJ

Line 553: ,'inserted into JAI_FA_DEP_BLOCKS...DEPRECIATION1')*/NULL;

549: ,SYSDATE
550: ,UID
551: ,UID);
552: /*SRW.MESSAGE(1057
553: ,'inserted into JAI_FA_DEP_BLOCKS...DEPRECIATION1')*/NULL;
554: ELSE
555: UPDATE
556: JAI_FA_DEP_BLOCKS
557: SET

Line 556: JAI_FA_DEP_BLOCKS

552: /*SRW.MESSAGE(1057
553: ,'inserted into JAI_FA_DEP_BLOCKS...DEPRECIATION1')*/NULL;
554: ELSE
555: UPDATE
556: JAI_FA_DEP_BLOCKS
557: SET
558: UNPLANNED_DEPN = P_DEPN_ADJ
559: WHERE TO_CHAR(BLOCK_ID) = TO_CHAR(P_BLOCK_ID)
560: AND SLNO = - 1;

Line 562: ,'updating JAI_FA_DEP_BLOCKS..3...DEPRECIATION1')*/NULL;

558: UNPLANNED_DEPN = P_DEPN_ADJ
559: WHERE TO_CHAR(BLOCK_ID) = TO_CHAR(P_BLOCK_ID)
560: AND SLNO = - 1;
561: /*SRW.MESSAGE(1058
562: ,'updating JAI_FA_DEP_BLOCKS..3...DEPRECIATION1')*/NULL;
563: /*SRW.MESSAGE(1059
564: ,'no.of rows updated JAI_FA_DEP_BLOCKS...DEPRECIATION1' || SQL%ROWCOUNT)*/NULL;
565: END IF;
566: END IF;

Line 564: ,'no.of rows updated JAI_FA_DEP_BLOCKS...DEPRECIATION1' || SQL%ROWCOUNT)*/NULL;

560: AND SLNO = - 1;
561: /*SRW.MESSAGE(1058
562: ,'updating JAI_FA_DEP_BLOCKS..3...DEPRECIATION1')*/NULL;
563: /*SRW.MESSAGE(1059
564: ,'no.of rows updated JAI_FA_DEP_BLOCKS...DEPRECIATION1' || SQL%ROWCOUNT)*/NULL;
565: END IF;
566: END IF;
567: END DEPRECIATION1;
568:

Line 576: JAI_FA_DEP_BLOCKS

572: SELECT
573: NVL(DEPN_OF_ASSETS
574: ,0)
575: FROM
576: JAI_FA_DEP_BLOCKS
577: WHERE UNPLANNED_DEPN = ASSET_ID
578: AND TO_CHAR(BLOCK_ID) = TO_CHAR(BLOCK_ID1);
579: V_DEPN_OF_ASSET NUMBER;
580: BEGIN

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 1021: JAI_FA_DEP_BLOCKS

1017: CURSOR COUNT_DEPN_CUR(P_BLOCK_ID IN NUMBER,P_SLNO IN NUMBER,P_ASSET_ID IN NUMBER) IS
1018: SELECT
1019: count(*)
1020: FROM
1021: JAI_FA_DEP_BLOCKS
1022: WHERE SLNO > 0
1023: AND BLOCK_ID = P_BLOCK_ID
1024: AND SLNO = P_SLNO
1025: AND UNPLANNED_DEPN = P_ASSET_ID;

Line 1030: JAI_FA_DEP_BLOCKS

1026: CURSOR UNPLANNED_DEPN_CUR(P_BLOCK_ID IN NUMBER) IS
1027: SELECT
1028: UNPLANNED_DEPN
1029: FROM
1030: JAI_FA_DEP_BLOCKS
1031: WHERE BLOCK_ID = P_BLOCK_ID
1032: AND SLNO = - 1;
1033: BEGIN
1034: LV_CAPITALIZED := 'CAPITALIZED';

Line 1109: INSERT INTO JAI_FA_DEP_BLOCKS

1105: ,UID
1106: ,SYSDATE
1107: ,UID
1108: ,UID);
1109: INSERT INTO JAI_FA_DEP_BLOCKS
1110: (BLOCK_DEPN_ID
1111: ,BLOCK_ID
1112: ,SLNO
1113: ,DEPN_OF_ASSETS

Line 1120: VALUES (JAI_FA_DEP_BLOCKS_S.NEXTVAL

1116: ,CREATED_BY
1117: ,LAST_UPDATE_DATE
1118: ,LAST_UPDATE_LOGIN
1119: ,LAST_UPDATED_BY)
1120: VALUES (JAI_FA_DEP_BLOCKS_S.NEXTVAL
1121: ,BLOCK_ID_NEW.BLOCK_ID
1122: ,0
1123: ,V_DEPRECIATION
1124: ,P_YEAR_END

Line 1132: JAI_FA_DEP_BLOCKS

1128: ,UID
1129: ,UID);
1130: ELSE
1131: UPDATE
1132: JAI_FA_DEP_BLOCKS
1133: SET
1134: DEPN_OF_ASSETS = V_DEPRECIATION
1135: WHERE BLOCK_ID = BLOCK_ID_NEW.BLOCK_ID
1136: AND SLNO = 0;

Line 1156: JAI_FA_DEP_BLOCKS

1152: ,YEAR_ENDED = P_YEAR_END
1153: WHERE BLOCK_ID = BLOCK_ID_NEW.BLOCK_ID;
1154: IF BLOCK_ID_NEW.DEPN_ADJ IS NOT NULL THEN
1155: UPDATE
1156: JAI_FA_DEP_BLOCKS
1157: SET
1158: UNPLANNED_DEPN = BLOCK_ID_NEW.DEPN_ADJ
1159: WHERE BLOCK_ID = BLOCK_ID_NEW.BLOCK_ID
1160: AND SLNO = 0;

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 1596: JAI_FA_DEP_BLOCKS

1592: CURSOR COUNT_DEPN_CUR(P_BLOCK_ID IN NUMBER,P_SLNO IN NUMBER,P_ASSET_ID IN NUMBER) IS
1593: SELECT
1594: COUNT(*)
1595: FROM
1596: JAI_FA_DEP_BLOCKS
1597: WHERE SLNO > 0
1598: AND BLOCK_ID = P_BLOCK_ID
1599: AND SLNO = P_SLNO
1600: AND UNPLANNED_DEPN = P_ASSET_ID;

Line 1605: JAI_FA_DEP_BLOCKS

1601: CURSOR UNPLANNED_DEPN_CUR(P_BLOCK_ID IN NUMBER) IS
1602: SELECT
1603: UNPLANNED_DEPN
1604: FROM
1605: JAI_FA_DEP_BLOCKS
1606: WHERE BLOCK_ID = P_BLOCK_ID
1607: AND SLNO = - 1;
1608: CURSOR COUNTER_CUR(P_BLOCK_ID IN NUMBER) IS
1609: SELECT

Line 1612: JAI_FA_DEP_BLOCKS

1608: CURSOR COUNTER_CUR(P_BLOCK_ID IN NUMBER) IS
1609: SELECT
1610: COUNT(*)
1611: FROM
1612: JAI_FA_DEP_BLOCKS
1613: WHERE BLOCK_ID = P_BLOCK_ID
1614: AND SLNO = 0;
1615: BEGIN
1616: LV_CAPITALIZED := 'CAPITALIZED';

Line 1768: INSERT INTO JAI_FA_DEP_BLOCKS

1764: ,UID
1765: ,UID);
1766: /*SRW.MESSAGE(1014
1767: ,'2.11 INSERT INTO JAI_FA_AST_BLOCKS')*/NULL;
1768: INSERT INTO JAI_FA_DEP_BLOCKS
1769: (BLOCK_DEPN_ID
1770: ,BLOCK_ID
1771: ,SLNO
1772: ,DEPN_OF_ASSETS

Line 1780: VALUES (JAI_FA_DEP_BLOCKS_S.NEXTVAL

1776: ,LAST_UPDATE_DATE
1777: ,LAST_UPDATE_LOGIN
1778: ,LAST_UPDATED_BY
1779: ,UNPLANNED_DEPN)
1780: VALUES (JAI_FA_DEP_BLOCKS_S.NEXTVAL
1781: ,CLOSING.BLOCK_ID
1782: ,0
1783: ,V_DEPRECIATION
1784: ,P_YEAR_END

Line 1792: ,'UPDATE INTO JAI_FA_DEP_BLOCKS')*/NULL;

1788: ,UID
1789: ,UID
1790: ,CLOSING.DEPN_ADJ);
1791: /*SRW.MESSAGE(1015
1792: ,'UPDATE INTO JAI_FA_DEP_BLOCKS')*/NULL;
1793: ELSE
1794: UPDATE
1795: JAI_FA_DEP_BLOCKS
1796: SET

Line 1795: JAI_FA_DEP_BLOCKS

1791: /*SRW.MESSAGE(1015
1792: ,'UPDATE INTO JAI_FA_DEP_BLOCKS')*/NULL;
1793: ELSE
1794: UPDATE
1795: JAI_FA_DEP_BLOCKS
1796: SET
1797: DEPN_OF_ASSETS = V_DEPRECIATION
1798: WHERE BLOCK_ID = CLOSING.BLOCK_ID
1799: AND SLNO = 0;

Line 1801: ,'2.12 update JAI_FA_DEP_BLOCKS ')*/NULL;

1797: DEPN_OF_ASSETS = V_DEPRECIATION
1798: WHERE BLOCK_ID = CLOSING.BLOCK_ID
1799: AND SLNO = 0;
1800: /*SRW.MESSAGE(1016
1801: ,'2.12 update JAI_FA_DEP_BLOCKS ')*/NULL;
1802: UPDATE
1803: JAI_FA_AST_BLOCKS
1804: SET
1805: OPENING_WDV = NVL(V_CLOSING_BALANCE

Line 1827: JAI_FA_DEP_BLOCKS

1823: IF CLOSING.DEPN_ADJ IS NOT NULL THEN
1824: /*SRW.MESSAGE(1018
1825: ,'2.15 IF closing.depn_adj IS NOT NULL THEN')*/NULL;
1826: UPDATE
1827: JAI_FA_DEP_BLOCKS
1828: SET
1829: UNPLANNED_DEPN = CLOSING.DEPN_ADJ
1830: WHERE BLOCK_ID = CLOSING.BLOCK_ID
1831: AND SLNO = 0;

Line 1879: ,'3.3 inserting INTO JAI_FA_DEP_BLOCKS, v_block_id -> ' || V_BLOCK_ID || ', v_depn_amount -> ' || NVL(V_DEPN_AMOUNT

1875: V_DEPN_AMOUNT := 0;
1876: ELSIF V_SERIAL_NUM1 <> V_SLNO THEN
1877: I := 0;
1878: /*SRW.MESSAGE(1022
1879: ,'3.3 inserting INTO JAI_FA_DEP_BLOCKS, v_block_id -> ' || V_BLOCK_ID || ', v_depn_amount -> ' || NVL(V_DEPN_AMOUNT
1880: ,0))*/NULL;
1881: INSERT INTO JAI_FA_DEP_BLOCKS
1882: (BLOCK_DEPN_ID
1883: ,BLOCK_ID

Line 1881: INSERT INTO JAI_FA_DEP_BLOCKS

1877: I := 0;
1878: /*SRW.MESSAGE(1022
1879: ,'3.3 inserting INTO JAI_FA_DEP_BLOCKS, v_block_id -> ' || V_BLOCK_ID || ', v_depn_amount -> ' || NVL(V_DEPN_AMOUNT
1880: ,0))*/NULL;
1881: INSERT INTO JAI_FA_DEP_BLOCKS
1882: (BLOCK_DEPN_ID
1883: ,BLOCK_ID
1884: ,SLNO
1885: ,DEPN_OF_ASSETS

Line 1893: VALUES (JAI_FA_DEP_BLOCKS_S.NEXTVAL

1889: ,LAST_UPDATE_DATE
1890: ,LAST_UPDATE_LOGIN
1891: ,LAST_UPDATED_BY
1892: ,UNPLANNED_DEPN)
1893: VALUES (JAI_FA_DEP_BLOCKS_S.NEXTVAL
1894: ,V_BLOCK_ID
1895: ,V_SERIAL_NUM1
1896: ,NVL(V_DEPN_AMOUNT
1897: ,0)

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 2045: INSERT INTO JAI_FA_DEP_BLOCKS

2041: ,'3.10 v_serial_num1 -> ' || V_SERIAL_NUM1)*/NULL;
2042: IF V_SERIAL_NUM1 = V_SLNO THEN
2043: /*SRW.MESSAGE(1275
2044: ,'3.11 v_depn_amount -> ' || V_DEPN_AMOUNT)*/NULL;
2045: INSERT INTO JAI_FA_DEP_BLOCKS
2046: (BLOCK_DEPN_ID
2047: ,BLOCK_ID
2048: ,SLNO
2049: ,DEPN_OF_ASSETS

Line 2057: VALUES (JAI_FA_DEP_BLOCKS_S.NEXTVAL

2053: ,LAST_UPDATE_DATE
2054: ,LAST_UPDATE_LOGIN
2055: ,LAST_UPDATED_BY
2056: ,UNPLANNED_DEPN)
2057: VALUES (JAI_FA_DEP_BLOCKS_S.NEXTVAL
2058: ,V_BLOCK_ID
2059: ,V_SERIAL_NUM1
2060: ,NVL(V_DEPN_AMOUNT
2061: ,0)

Line 2116: ,'4.3 Inserted into JAI_FA_DEP_BLOCKS, V_block_id -> ' || V_BLOCK_ID || ', v_cost_less -> ' || NVL(V_COST_LESS

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;
2118: INSERT INTO JAI_FA_DEP_BLOCKS
2119: (BLOCK_DEPN_ID
2120: ,BLOCK_ID

Line 2118: INSERT INTO JAI_FA_DEP_BLOCKS

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;
2118: INSERT INTO JAI_FA_DEP_BLOCKS
2119: (BLOCK_DEPN_ID
2120: ,BLOCK_ID
2121: ,SLNO
2122: ,DEPN_OF_ASSETS

Line 2131: VALUES (JAI_FA_DEP_BLOCKS_S.NEXTVAL

2127: ,LAST_UPDATE_DATE
2128: ,LAST_UPDATE_LOGIN
2129: ,LAST_UPDATED_BY
2130: ,UNPLANNED_DEPN)
2131: VALUES (JAI_FA_DEP_BLOCKS_S.NEXTVAL
2132: ,V_BLOCK_ID
2133: ,V_SLNO
2134: ,NVL(V_COST_LESS
2135: ,0)

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 2358: INSERT INTO JAI_FA_DEP_BLOCKS

2354: ,YEAR_ENDED = P_YEAR_END
2355: WHERE BLOCK_ID = TEMP_REC.BLOCK_ID;
2356: /*SRW.MESSAGE(1275
2357: ,'5.7 After update of JAI_FA_AST_BLOCKS, cnt -> ' || SQL%ROWCOUNT)*/NULL;
2358: INSERT INTO JAI_FA_DEP_BLOCKS
2359: (BLOCK_DEPN_ID
2360: ,BLOCK_ID
2361: ,SLNO
2362: ,DEPN_OF_ASSETS

Line 2370: VALUES (JAI_FA_DEP_BLOCKS_S.NEXTVAL

2366: ,LAST_UPDATE_DATE
2367: ,LAST_UPDATE_LOGIN
2368: ,LAST_UPDATED_BY
2369: ,UNPLANNED_DEPN)
2370: VALUES (JAI_FA_DEP_BLOCKS_S.NEXTVAL
2371: ,TEMP_REC.BLOCK_ID
2372: ,0
2373: ,NVL(V_AMOUNT1
2374: ,0)

Line 2423: JAI_FA_DEP_BLOCKS

2419: WHERE BLOCK_ID = TEMP_REC.BLOCK_ID;
2420: /*SRW.MESSAGE(1275
2421: ,'5.9 After update of JAI_FA_AST_BLOCKS, cnt -> ' || SQL%ROWCOUNT)*/NULL;
2422: UPDATE
2423: JAI_FA_DEP_BLOCKS
2424: SET
2425: DEPN_OF_ASSETS = NVL(V_AMOUNT1
2426: ,0)
2427: WHERE BLOCK_ID = TEMP_REC.BLOCK_ID

Line 2430: ,'5.10 After update of JAI_FA_DEP_BLOCKS, cnt -> ' || SQL%ROWCOUNT)*/NULL;

2426: ,0)
2427: WHERE BLOCK_ID = TEMP_REC.BLOCK_ID
2428: AND SLNO = 0;
2429: /*SRW.MESSAGE(1275
2430: ,'5.10 After update of JAI_FA_DEP_BLOCKS, cnt -> ' || SQL%ROWCOUNT)*/NULL;
2431: UPDATE
2432: JAI_FA_AST_BLOCKS
2433: SET
2434: OPENING_WDV = NVL(V_CLOSING_BALANCE

Line 2444: JAI_FA_DEP_BLOCKS

2440: /*SRW.MESSAGE(1275
2441: ,'5.11 After update of JAI_FA_AST_BLOCKS, cnt -> ' || SQL%ROWCOUNT)*/NULL;
2442: IF V_DEPN_ADJ IS NOT NULL THEN
2443: UPDATE
2444: JAI_FA_DEP_BLOCKS
2445: SET
2446: UNPLANNED_DEPN = V_DEPN_ADJ
2447: WHERE BLOCK_ID = TEMP_REC.BLOCK_ID
2448: AND SLNO = 0;

Line 2450: ,'5.12 After update of JAI_FA_DEP_BLOCKS, cnt -> ' || SQL%ROWCOUNT)*/NULL;

2446: UNPLANNED_DEPN = V_DEPN_ADJ
2447: WHERE BLOCK_ID = TEMP_REC.BLOCK_ID
2448: AND SLNO = 0;
2449: /*SRW.MESSAGE(1275
2450: ,'5.12 After update of JAI_FA_DEP_BLOCKS, cnt -> ' || SQL%ROWCOUNT)*/NULL;
2451: END IF;
2452: END IF;
2453: END IF;
2454: IF V_CLOSING < 0 THEN

Line 2468: INSERT INTO JAI_FA_DEP_BLOCKS

2464: IF NVL(V_COUNTER
2465: ,0) = 0 THEN
2466: /*SRW.MESSAGE(1275
2467: ,'6.2 insert into JAI_FA_AST_BLOCKS, temp_rec.block_id -> ' || TEMP_REC.BLOCK_ID)*/NULL;
2468: INSERT INTO JAI_FA_DEP_BLOCKS
2469: (BLOCK_DEPN_ID
2470: ,BLOCK_ID
2471: ,SLNO
2472: ,DEPN_OF_ASSETS

Line 2480: VALUES (JAI_FA_DEP_BLOCKS_S.NEXTVAL

2476: ,LAST_UPDATE_DATE
2477: ,LAST_UPDATE_LOGIN
2478: ,LAST_UPDATED_BY
2479: ,UNPLANNED_DEPN)
2480: VALUES (JAI_FA_DEP_BLOCKS_S.NEXTVAL
2481: ,TEMP_REC.BLOCK_ID
2482: ,0
2483: ,0
2484: ,P_YEAR_END

Line 2493: JAI_FA_DEP_BLOCKS

2489: ,UID
2490: ,V_DEPN_ADJ);
2491: ELSE
2492: UPDATE
2493: JAI_FA_DEP_BLOCKS
2494: SET
2495: DEPN_OF_ASSETS = 0
2496: WHERE BLOCK_ID = TEMP_REC.BLOCK_ID;
2497: /*SRW.MESSAGE(1275

Line 2498: ,'6.3 After update of JAI_FA_DEP_BLOCKS, cnt -> ' || SQL%ROWCOUNT)*/NULL;

2494: SET
2495: DEPN_OF_ASSETS = 0
2496: WHERE BLOCK_ID = TEMP_REC.BLOCK_ID;
2497: /*SRW.MESSAGE(1275
2498: ,'6.3 After update of JAI_FA_DEP_BLOCKS, cnt -> ' || SQL%ROWCOUNT)*/NULL;
2499: END IF;
2500: UPDATE
2501: JAI_FA_AST_BLOCKS
2502: SET

Line 2522: INSERT INTO JAI_FA_DEP_BLOCKS

2518: /*SRW.MESSAGE(1275
2519: ,'6.5 After update of JAI_FA_AST_BLOCKS, cnt -> ' || SQL%ROWCOUNT)*/NULL;
2520: IF NVL(V_COUNTER
2521: ,0) = 0 THEN
2522: INSERT INTO JAI_FA_DEP_BLOCKS
2523: (BLOCK_DEPN_ID
2524: ,BLOCK_ID
2525: ,SLNO
2526: ,DEPN_OF_ASSETS

Line 2534: VALUES (JAI_FA_DEP_BLOCKS_S.NEXTVAL

2530: ,LAST_UPDATE_DATE
2531: ,LAST_UPDATE_LOGIN
2532: ,LAST_UPDATED_BY
2533: ,UNPLANNED_DEPN)
2534: VALUES (JAI_FA_DEP_BLOCKS_S.NEXTVAL
2535: ,TEMP_REC.BLOCK_ID
2536: ,0
2537: ,0
2538: ,P_YEAR_END

Line 2546: ,'6.6 After insert into JAI_FA_DEP_BLOCKS')*/NULL;

2542: ,UID
2543: ,UID
2544: ,V_DEPN_ADJ);
2545: /*SRW.MESSAGE(1275
2546: ,'6.6 After insert into JAI_FA_DEP_BLOCKS')*/NULL;
2547: ELSE
2548: UPDATE
2549: JAI_FA_DEP_BLOCKS
2550: SET

Line 2549: JAI_FA_DEP_BLOCKS

2545: /*SRW.MESSAGE(1275
2546: ,'6.6 After insert into JAI_FA_DEP_BLOCKS')*/NULL;
2547: ELSE
2548: UPDATE
2549: JAI_FA_DEP_BLOCKS
2550: SET
2551: DEPN_OF_ASSETS = 0
2552: WHERE BLOCK_ID = TEMP_REC.BLOCK_ID;
2553: /*SRW.MESSAGE(1275

Line 2554: ,'6.7 After update of JAI_FA_DEP_BLOCKS, cnt -> ' || SQL%ROWCOUNT)*/NULL;

2550: SET
2551: DEPN_OF_ASSETS = 0
2552: WHERE BLOCK_ID = TEMP_REC.BLOCK_ID;
2553: /*SRW.MESSAGE(1275
2554: ,'6.7 After update of JAI_FA_DEP_BLOCKS, cnt -> ' || SQL%ROWCOUNT)*/NULL;
2555: END IF;
2556: UPDATE
2557: JAI_FA_AST_BLOCKS
2558: SET

Line 2578: JAI_FA_DEP_BLOCKS

2574: WHERE BLOCK_ID = TEMP_REC.BLOCK_ID;
2575: /*SRW.MESSAGE(1275
2576: ,'7.1 After update of JAI_FA_AST_BLOCKS, cnt -> ' || SQL%ROWCOUNT)*/NULL;
2577: UPDATE
2578: JAI_FA_DEP_BLOCKS
2579: SET
2580: DEPN_OF_ASSETS = 0
2581: WHERE BLOCK_ID = TEMP_REC.BLOCK_ID;
2582: /*SRW.MESSAGE(1275

Line 2583: ,'7.2 After update of JAI_FA_DEP_BLOCKS, cnt -> ' || SQL%ROWCOUNT)*/NULL;

2579: SET
2580: DEPN_OF_ASSETS = 0
2581: WHERE BLOCK_ID = TEMP_REC.BLOCK_ID;
2582: /*SRW.MESSAGE(1275
2583: ,'7.2 After update of JAI_FA_DEP_BLOCKS, cnt -> ' || SQL%ROWCOUNT)*/NULL;
2584: UPDATE
2585: JAI_FA_AST_BLOCKS
2586: SET
2587: OPENING_WDV = 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 3027: JAI_FA_DEP_BLOCKS

3023: CURSOR COUNT_DEPN_CUR(P_BLOCK_ID IN NUMBER,P_SLNO IN NUMBER,P_ASSET_ID IN NUMBER) IS
3024: SELECT
3025: count(*)
3026: FROM
3027: JAI_FA_DEP_BLOCKS
3028: WHERE SLNO > 0
3029: AND BLOCK_ID = P_BLOCK_ID
3030: AND SLNO = P_SLNO
3031: AND UNPLANNED_DEPN = P_ASSET_ID;

Line 3036: JAI_FA_DEP_BLOCKS

3032: CURSOR UNPLANNED_DEPN_CUR(P_BLOCK_ID IN NUMBER) IS
3033: SELECT
3034: UNPLANNED_DEPN
3035: FROM
3036: JAI_FA_DEP_BLOCKS
3037: WHERE BLOCK_ID = P_BLOCK_ID
3038: AND SLNO = - 1;
3039: CURSOR COUNTER_CUR(P_BLOCK_ID IN NUMBER) IS
3040: SELECT

Line 3043: JAI_FA_DEP_BLOCKS

3039: CURSOR COUNTER_CUR(P_BLOCK_ID IN NUMBER) IS
3040: SELECT
3041: COUNT(*)
3042: FROM
3043: JAI_FA_DEP_BLOCKS
3044: WHERE BLOCK_ID = P_BLOCK_ID
3045: AND SLNO = 0;
3046: BEGIN
3047: LV_CAPITALIZED := 'CAPITALIZED';

Line 3146: INSERT INTO JAI_FA_DEP_BLOCKS

3142: ,UID
3143: ,SYSDATE
3144: ,UID
3145: ,UID);
3146: INSERT INTO JAI_FA_DEP_BLOCKS
3147: (BLOCK_DEPN_ID
3148: ,BLOCK_ID
3149: ,SLNO
3150: ,DEPN_OF_ASSETS

Line 3158: VALUES (JAI_FA_DEP_BLOCKS_S.NEXTVAL

3154: ,LAST_UPDATE_DATE
3155: ,LAST_UPDATE_LOGIN
3156: ,LAST_UPDATED_BY
3157: ,UNPLANNED_DEPN)
3158: VALUES (JAI_FA_DEP_BLOCKS_S.NEXTVAL
3159: ,CLOSING.BLOCK_ID
3160: ,0
3161: ,V_DEPRECIATION
3162: ,P_YEAR_END

Line 3171: JAI_FA_DEP_BLOCKS

3167: ,UID
3168: ,CLOSING.DEPN_ADJ);
3169: ELSE
3170: UPDATE
3171: JAI_FA_DEP_BLOCKS
3172: SET
3173: DEPN_OF_ASSETS = V_DEPRECIATION
3174: WHERE BLOCK_ID = CLOSING.BLOCK_ID
3175: AND SLNO = 0;

Line 3195: JAI_FA_DEP_BLOCKS

3191: ,YEAR_ENDED = P_YEAR_END
3192: WHERE BLOCK_ID = CLOSING.BLOCK_ID;
3193: IF CLOSING.DEPN_ADJ IS NOT NULL THEN
3194: UPDATE
3195: JAI_FA_DEP_BLOCKS
3196: SET
3197: UNPLANNED_DEPN = CLOSING.DEPN_ADJ
3198: WHERE BLOCK_ID = CLOSING.BLOCK_ID
3199: AND SLNO = 0;

Line 3221: INSERT INTO JAI_FA_DEP_BLOCKS

3217: I := 1;
3218: V_DEPN_AMOUNT := 0;
3219: ELSIF V_SERIAL_NUM1 <> V_SLNO THEN
3220: I := 0;
3221: INSERT INTO JAI_FA_DEP_BLOCKS
3222: (BLOCK_DEPN_ID
3223: ,BLOCK_ID
3224: ,SLNO
3225: ,DEPN_OF_ASSETS

Line 3233: VALUES (JAI_FA_DEP_BLOCKS_S.NEXTVAL

3229: ,LAST_UPDATE_DATE
3230: ,LAST_UPDATE_LOGIN
3231: ,LAST_UPDATED_BY
3232: ,UNPLANNED_DEPN)
3233: VALUES (JAI_FA_DEP_BLOCKS_S.NEXTVAL
3234: ,V_BLOCK_ID
3235: ,V_SERIAL_NUM1
3236: ,NVL(V_DEPN_AMOUNT
3237: ,0)

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 3358: INSERT INTO JAI_FA_DEP_BLOCKS

3354: END LOOP;
3355: IF V_DEPN_SLNO = 0 THEN
3356: IF V_FLAG OR I = 1 THEN
3357: IF V_SERIAL_NUM1 = V_SLNO THEN
3358: INSERT INTO JAI_FA_DEP_BLOCKS
3359: (BLOCK_DEPN_ID
3360: ,BLOCK_ID
3361: ,SLNO
3362: ,DEPN_OF_ASSETS

Line 3370: VALUES (JAI_FA_DEP_BLOCKS_S.NEXTVAL

3366: ,LAST_UPDATE_DATE
3367: ,LAST_UPDATE_LOGIN
3368: ,LAST_UPDATED_BY
3369: ,UNPLANNED_DEPN)
3370: VALUES (JAI_FA_DEP_BLOCKS_S.NEXTVAL
3371: ,V_BLOCK_ID
3372: ,V_SERIAL_NUM1
3373: ,NVL(V_DEPN_AMOUNT
3374: ,0)

Line 3413: INSERT INTO JAI_FA_DEP_BLOCKS

3409: ,SYSDATE
3410: ,FND_GLOBAL.LOGIN_ID
3411: ,NULL);
3412: IF V_DEPN_SLNO = 0 THEN
3413: INSERT INTO JAI_FA_DEP_BLOCKS
3414: (BLOCK_DEPN_ID
3415: ,BLOCK_ID
3416: ,SLNO
3417: ,DEPN_OF_ASSETS

Line 3426: VALUES (JAI_FA_DEP_BLOCKS_S.NEXTVAL

3422: ,LAST_UPDATE_DATE
3423: ,LAST_UPDATE_LOGIN
3424: ,LAST_UPDATED_BY
3425: ,UNPLANNED_DEPN)
3426: VALUES (JAI_FA_DEP_BLOCKS_S.NEXTVAL
3427: ,V_BLOCK_ID
3428: ,V_SLNO
3429: ,NVL(V_COST_LESS
3430: ,0)

Line 3556: INSERT INTO JAI_FA_DEP_BLOCKS

3552: CLOSING_WDV = NVL(V_CLOSING_BALANCE
3553: ,0)
3554: ,YEAR_ENDED = P_YEAR_END
3555: WHERE BLOCK_ID = TEMP_REC.BLOCK_ID;
3556: INSERT INTO JAI_FA_DEP_BLOCKS
3557: (BLOCK_DEPN_ID
3558: ,BLOCK_ID
3559: ,SLNO
3560: ,DEPN_OF_ASSETS

Line 3568: VALUES (JAI_FA_DEP_BLOCKS_S.NEXTVAL

3564: ,LAST_UPDATE_DATE
3565: ,LAST_UPDATE_LOGIN
3566: ,LAST_UPDATED_BY
3567: ,UNPLANNED_DEPN)
3568: VALUES (JAI_FA_DEP_BLOCKS_S.NEXTVAL
3569: ,TEMP_REC.BLOCK_ID
3570: ,0
3571: ,NVL(V_AMOUNT1
3572: ,0)

Line 3618: JAI_FA_DEP_BLOCKS

3614: ,0)
3615: ,YEAR_ENDED = P_YEAR_END
3616: WHERE BLOCK_ID = TEMP_REC.BLOCK_ID;
3617: UPDATE
3618: JAI_FA_DEP_BLOCKS
3619: SET
3620: DEPN_OF_ASSETS = NVL(V_AMOUNT1
3621: ,0)
3622: WHERE BLOCK_ID = TEMP_REC.BLOCK_ID

Line 3635: JAI_FA_DEP_BLOCKS

3631: AND TYPE = V_TYPE;
3632: K := 1;
3633: IF V_DEPN_ADJ IS NOT NULL THEN
3634: UPDATE
3635: JAI_FA_DEP_BLOCKS
3636: SET
3637: UNPLANNED_DEPN = V_DEPN_ADJ
3638: WHERE BLOCK_ID = TEMP_REC.BLOCK_ID
3639: AND SLNO = 0;

Line 3653: INSERT INTO JAI_FA_DEP_BLOCKS

3649: ,CAPITAL_GAINS = ABS(V_CLOSING)
3650: WHERE BLOCK_ID = TEMP_REC.BLOCK_ID;
3651: IF NVL(V_COUNTER
3652: ,0) = 0 THEN
3653: INSERT INTO JAI_FA_DEP_BLOCKS
3654: (BLOCK_DEPN_ID
3655: ,BLOCK_ID
3656: ,SLNO
3657: ,DEPN_OF_ASSETS

Line 3665: VALUES (JAI_FA_DEP_BLOCKS_S.NEXTVAL

3661: ,LAST_UPDATE_DATE
3662: ,LAST_UPDATE_LOGIN
3663: ,LAST_UPDATED_BY
3664: ,UNPLANNED_DEPN)
3665: VALUES (JAI_FA_DEP_BLOCKS_S.NEXTVAL
3666: ,TEMP_REC.BLOCK_ID
3667: ,0
3668: ,0
3669: ,P_YEAR_END

Line 3678: JAI_FA_DEP_BLOCKS

3674: ,UID
3675: ,V_DEPN_ADJ);
3676: ELSE
3677: UPDATE
3678: JAI_FA_DEP_BLOCKS
3679: SET
3680: DEPN_OF_ASSETS = 0
3681: WHERE BLOCK_ID = TEMP_REC.BLOCK_ID;
3682: END IF;

Line 3701: INSERT INTO JAI_FA_DEP_BLOCKS

3697: ,CAPITAL_LOSS = NULL
3698: WHERE BLOCK_ID = TEMP_REC.BLOCK_ID;
3699: IF NVL(V_COUNTER
3700: ,0) = 0 THEN
3701: INSERT INTO JAI_FA_DEP_BLOCKS
3702: (BLOCK_DEPN_ID
3703: ,BLOCK_ID
3704: ,SLNO
3705: ,DEPN_OF_ASSETS

Line 3713: VALUES (JAI_FA_DEP_BLOCKS_S.NEXTVAL

3709: ,LAST_UPDATE_DATE
3710: ,LAST_UPDATE_LOGIN
3711: ,LAST_UPDATED_BY
3712: ,UNPLANNED_DEPN)
3713: VALUES (JAI_FA_DEP_BLOCKS_S.NEXTVAL
3714: ,TEMP_REC.BLOCK_ID
3715: ,0
3716: ,0
3717: ,P_YEAR_END

Line 3726: JAI_FA_DEP_BLOCKS

3722: ,UID
3723: ,V_DEPN_ADJ);
3724: ELSE
3725: UPDATE
3726: JAI_FA_DEP_BLOCKS
3727: SET
3728: DEPN_OF_ASSETS = 0
3729: WHERE BLOCK_ID = TEMP_REC.BLOCK_ID;
3730: END IF;

Line 3749: JAI_FA_DEP_BLOCKS

3745: ,CAPITAL_GAINS = NULL
3746: ,CAPITAL_LOSS = V_CLOSING
3747: WHERE BLOCK_ID = TEMP_REC.BLOCK_ID;
3748: UPDATE
3749: JAI_FA_DEP_BLOCKS
3750: SET
3751: DEPN_OF_ASSETS = 0
3752: WHERE BLOCK_ID = TEMP_REC.BLOCK_ID;
3753: UPDATE

Line 3784: JAI_FA_DEP_BLOCKS

3780: WHERE START_DATE = ADJUST.START_DATE
3781: AND BLOCK_ID = ADJUST.BLOCK_ID;
3782: IF ADJUST.CLOSING_WDV IS NOT NULL THEN
3783: UPDATE
3784: JAI_FA_DEP_BLOCKS
3785: SET
3786: DEPN_OF_ASSETS = V_DEPRECIATION
3787: WHERE BLOCK_ID = ADJUST.BLOCK_ID
3788: AND SLNO = 0;

Line 3823: JAI_FA_DEP_BLOCKS

3819: WHERE START_DATE = ADJUST.START_DATE
3820: AND BLOCK_ID = ADJUST.BLOCK_ID;
3821: IF ADJUST.CLOSING_WDV IS NOT NULL THEN
3822: UPDATE
3823: JAI_FA_DEP_BLOCKS
3824: SET
3825: DEPN_OF_ASSETS = V_DEPRECIATION
3826: WHERE BLOCK_ID = ADJUST.BLOCK_ID
3827: AND SLNO = 0;

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