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 FA_BOOKS

Line 242: LV_FLAG FA_BOOKS.CAPITALIZE_FLAG%TYPE;

238: ,OP_TOT IN NUMBER
239: ,COS_TOT IN NUMBER
240: ,RATE IN NUMBER) RETURN NUMBER IS
241: LV_CAPITALIZED JAI_FA_AST_BLOCK_DTLS.ASSET_TYPE%TYPE;
242: LV_FLAG FA_BOOKS.CAPITALIZE_FLAG%TYPE;
243: LV_EXPENSED JAI_FA_AST_BLOCK_DTLS.ASSET_TYPE%TYPE;
244: START_DATE_T date;
245: CURSOR CUR_GET_VALID_ASSETS IS
246: SELECT

Line 250: FA_BOOKS FAB,

246: SELECT
247: '1'
248: FROM
249: JAI_FA_AST_BLOCK_DTLS JBA,
250: FA_BOOKS FAB,
251: JAI_FA_AST_BLOCKS JABOA
252: WHERE JBA.ASSET_ID = FAB.ASSET_ID
253: AND ( ( JBA.ASSET_TYPE = LV_CAPITALIZED
254: AND FAB.CAPITALIZE_FLAG = LV_FLAG )

Line 300: FA_BOOKS A,

296: A.COST,
297: A.TRANSACTION_HEADER_ID_IN,
298: A.DATE_EFFECTIVE
299: FROM
300: FA_BOOKS A,
301: JAI_FA_AST_BLOCKS B,
302: JAI_FA_AST_BLOCK_DTLS C,
303: JAI_FA_AST_PERIOD_RATES D
304: WHERE A.ASSET_ID = C.ASSET_ID

Line 594: LV_FLAG FA_BOOKS.CAPITALIZE_FLAG%TYPE;

590: PROCEDURE RETIRE(P_YEAR_START IN DATE
591: ,P_YEAR_END IN DATE
592: ,P_BOOK_NAME IN VARCHAR2) IS
593: LV_CAPITALIZED JAI_FA_AST_BLOCK_DTLS.ASSET_TYPE%TYPE;
594: LV_FLAG FA_BOOKS.CAPITALIZE_FLAG%TYPE;
595: LV_EXPENSED JAI_FA_AST_BLOCK_DTLS.ASSET_TYPE%TYPE;
596: LV_OWNED VARCHAR2(10);
597: K NUMBER;
598: I NUMBER := 0;

Line 675: FA_BOOKS D,

671: FROM
672: JAI_FA_AST_BLOCK_DTLS A,
673: JAI_FA_AST_BLOCKS B,
674: JAI_FA_AST_PERIOD_RATES C,
675: FA_BOOKS D,
676: FA_ADDITIONS E
677: WHERE E.OWNED_LEASED = LV_OWNED
678: AND E.ASSET_ID = A.ASSET_ID
679: AND NVL(A.ASSET_ID

Line 704: FA_BOOKS D,

700: FROM
701: JAI_FA_AST_BLOCK_DTLS A,
702: JAI_FA_AST_BLOCKS B,
703: JAI_FA_AST_PERIOD_RATES C,
704: FA_BOOKS D,
705: FA_ADDITIONS E
706: WHERE E.OWNED_LEASED = 'OWNED'
707: AND E.ASSET_ID = A.ASSET_ID
708: AND NVL(A.ASSET_ID

Line 793: FA_BOOKS A,

789: SUM(A.ORIGINAL_COST) COSTING,
790: A.ASSET_ID,
791: A.DATE_PLACED_IN_SERVICE
792: FROM
793: FA_BOOKS A,
794: JAI_FA_AST_BLOCK_DTLS B,
795: FA_ADDITIONS C
796: WHERE A.ASSET_ID = P_ASSET_ID
797: AND A.ASSET_ID = B.ASSET_ID

Line 819: FA_BOOKS A,

815: SUM(A.ORIGINAL_COST) COSTING,
816: A.ASSET_ID,
817: A.DATE_PLACED_IN_SERVICE
818: FROM
819: FA_BOOKS A,
820: JAI_FA_AST_BLOCK_DTLS B,
821: FA_ADDITIONS C
822: WHERE A.ASSET_ID = P_ASSET_ID
823: AND A.ASSET_ID = B.ASSET_ID

Line 1172: LV_FLAG FA_BOOKS.CAPITALIZE_FLAG%TYPE;

1168: PROCEDURE RUN_DEP(P_YEAR_START IN DATE
1169: ,P_YEAR_END IN DATE
1170: ,P_BOOK_NAME IN VARCHAR2) IS
1171: LV_CAPITALIZED JAI_FA_AST_BLOCK_DTLS.ASSET_TYPE%TYPE;
1172: LV_FLAG FA_BOOKS.CAPITALIZE_FLAG%TYPE;
1173: LV_EXPENSED JAI_FA_AST_BLOCK_DTLS.ASSET_TYPE%TYPE;
1174: LV_OWNED_LEASED FA_ADDITIONS.OWNED_LEASED%TYPE;
1175: LV_STATUS FA_RETIREMENTS.STATUS%TYPE;
1176: V_C NUMBER := 0;

Line 1240: LN_TRANSACTION_HEADER_ID_IN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE;

1236: V_CLOSING_BLOCK_ID NUMBER;
1237: V_UNPLANNED_DEPN NUMBER;
1238: V_RETIRED NUMBER;
1239: V_RETIRED1 NUMBER;
1240: LN_TRANSACTION_HEADER_ID_IN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE;
1241: V_NO_ASSETS VARCHAR2(3);
1242: CURSOR ASSET_BLOCK_CUR IS
1243: SELECT
1244: DISTINCT

Line 1262: FA_BOOKS D,

1258: FROM
1259: FA_ADDITIONS A,
1260: JAI_FA_AST_BLOCKS B,
1261: JAI_FA_AST_PERIOD_RATES C,
1262: FA_BOOKS D,
1263: JAI_FA_AST_BLOCK_DTLS E
1264: WHERE A.OWNED_LEASED = LV_OWNED_LEASED
1265: AND ( ( A.ASSET_TYPE = LV_CAPITALIZED
1266: AND D.CAPITALIZE_FLAG = LV_FLAG )

Line 1322: FA_BOOKS D

1318: FROM
1319: FA_RETIREMENTS A,
1320: JAI_FA_AST_BLOCK_DTLS B,
1321: JAI_FA_AST_BLOCKS C,
1322: FA_BOOKS D
1323: WHERE A.ASSET_ID = B.ASSET_ID
1324: AND ( ( B.ASSET_TYPE = LV_CAPITALIZED
1325: AND D.CAPITALIZE_FLAG = LV_FLAG )
1326: OR B.ASSET_TYPE = LV_EXPENSED )

Line 1370: CURSOR COST_LESS_EXEMPT_UPTO_CUR(P_ASSET_ID IN NUMBER,P_START_DATE IN DATE,P_END_DATE IN DATE,P_EXEMPT_UPTO IN NUMBER,P_BLOCK_ID IN NUMBER,CP_TRANSACTION_HEADER_ID_IN IN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE) IS

1366: AND A.DATE_RETIRED BETWEEN P_YEAR_START
1367: AND P_YEAR_END
1368: ORDER BY
1369: B.BLOCK_ID;
1370: CURSOR COST_LESS_EXEMPT_UPTO_CUR(P_ASSET_ID IN NUMBER,P_START_DATE IN DATE,P_END_DATE IN DATE,P_EXEMPT_UPTO IN NUMBER,P_BLOCK_ID IN NUMBER,CP_TRANSACTION_HEADER_ID_IN IN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE) IS
1371: SELECT
1372: A.COST COSTING,
1373: A.ASSET_ID,
1374: A.DATE_PLACED_IN_SERVICE

Line 1376: FA_BOOKS A,

1372: A.COST COSTING,
1373: A.ASSET_ID,
1374: A.DATE_PLACED_IN_SERVICE
1375: FROM
1376: FA_BOOKS A,
1377: FA_ADDITIONS B,
1378: JAI_FA_AST_BLOCK_DTLS C
1379: WHERE A.ASSET_ID = P_ASSET_ID
1380: AND A.ASSET_ID = C.ASSET_ID

Line 1392: CURSOR COST_MORE_EXEMPT_UPTO_CUR(P_ASSET_ID IN NUMBER,P_START_DATE IN DATE,P_END_DATE IN DATE,P_EXEMPT_UPTO IN NUMBER,P_BLOCK_ID IN NUMBER,CP_TRANSACTION_HEADER_ID_IN IN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE) IS

1388: AND C.DATE_OF_ACQUISITION BETWEEN P_START_DATE
1389: AND P_END_DATE
1390: AND ( A.COST / B.CURRENT_UNITS ) <= NVL(P_EXEMPT_UPTO
1391: ,0);
1392: CURSOR COST_MORE_EXEMPT_UPTO_CUR(P_ASSET_ID IN NUMBER,P_START_DATE IN DATE,P_END_DATE IN DATE,P_EXEMPT_UPTO IN NUMBER,P_BLOCK_ID IN NUMBER,CP_TRANSACTION_HEADER_ID_IN IN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE) IS
1393: SELECT
1394: A.COST COSTING,
1395: A.ASSET_ID,
1396: A.DATE_PLACED_IN_SERVICE

Line 1398: FA_BOOKS A,

1394: A.COST COSTING,
1395: A.ASSET_ID,
1396: A.DATE_PLACED_IN_SERVICE
1397: FROM
1398: FA_BOOKS A,
1399: FA_ADDITIONS B,
1400: JAI_FA_AST_BLOCK_DTLS C
1401: WHERE A.ASSET_ID = P_ASSET_ID
1402: AND A.ASSET_ID = C.ASSET_ID

Line 1486: FA_BOOKS D,

1482: FROM
1483: FA_ADDITIONS A,
1484: JAI_FA_AST_BLOCKS B,
1485: JAI_FA_AST_PERIOD_RATES C,
1486: FA_BOOKS D,
1487: JAI_FA_AST_BLOCK_DTLS E
1488: WHERE A.OWNED_LEASED = LV_OWNED_LEASED
1489: AND ( ( A.ASSET_TYPE = LV_CAPITALIZED
1490: AND D.CAPITALIZE_FLAG = LV_FLAG )

Line 2277: FA_BOOKS FAB,

2273: SELECT
2274: '1'
2275: FROM
2276: JAI_FA_AST_BLOCK_DTLS JBA,
2277: FA_BOOKS FAB,
2278: JAI_FA_AST_BLOCKS JABOA
2279: WHERE JBA.ASSET_ID = FAB.ASSET_ID
2280: AND ( ( JBA.ASSET_TYPE = 'CAPITALIZED'
2281: AND FAB.CAPITALIZE_FLAG = 'YES' )

Line 2626: LV_FLAG FA_BOOKS.CAPITALIZE_FLAG%TYPE;

2622: PROCEDURE RUN_DEP_MASS(P_YEAR_START IN DATE
2623: ,P_YEAR_END IN DATE
2624: ,P_BOOK_NAME IN VARCHAR2) IS
2625: LV_CAPITALIZED JAI_FA_AST_BLOCK_DTLS.ASSET_TYPE%TYPE;
2626: LV_FLAG FA_BOOKS.CAPITALIZE_FLAG%TYPE;
2627: LV_EXPENSED JAI_FA_AST_BLOCK_DTLS.ASSET_TYPE%TYPE;
2628: K NUMBER := 0;
2629: I NUMBER := 0;
2630: V_COUNT1 NUMBER;

Line 2710: FA_BOOKS D

2706: FROM
2707: FA_MASS_ADDITIONS A,
2708: JAI_FA_AST_BLOCKS B,
2709: JAI_FA_AST_PERIOD_RATES C,
2710: FA_BOOKS D
2711: WHERE NVL(A.MASS_ADDITION_ID
2712: ,0) = NVL(D.ASSET_ID
2713: ,0)
2714: AND TO_DATE(A.ATTRIBUTE1

Line 2737: FA_BOOKS D

2733: FROM
2734: FA_MASS_ADDITIONS A,
2735: JAI_FA_AST_BLOCKS B,
2736: JAI_FA_AST_PERIOD_RATES C,
2737: FA_BOOKS D
2738: WHERE NVL(A.MASS_ADDITION_ID
2739: ,0) = NVL(D.ASSET_ID
2740: ,0)
2741: AND TO_DATE(A.ATTRIBUTE1

Line 2802: FA_BOOKS A,

2798: SUM(A.ORIGINAL_COST) COSTING,
2799: A.ASSET_ID,
2800: A.DATE_PLACED_IN_SERVICE
2801: FROM
2802: FA_BOOKS A,
2803: FA_MASS_ADDITIONS B
2804: WHERE A.ASSET_ID = P_ASSET_ID
2805: AND A.ASSET_ID = B.MASS_ADDITION_ID
2806: AND A.DATE_INEFFECTIVE is null

Line 2827: FA_BOOKS A,

2823: SUM(A.ORIGINAL_COST) COSTING,
2824: A.ASSET_ID,
2825: A.DATE_PLACED_IN_SERVICE
2826: FROM
2827: FA_BOOKS A,
2828: FA_MASS_ADDITIONS B
2829: WHERE A.ASSET_ID = P_ASSET_ID
2830: AND A.ASSET_ID = B.MASS_ADDITION_ID
2831: AND A.DATE_INEFFECTIVE is null

Line 3901: LV_FLAG FA_BOOKS.CAPITALIZE_FLAG%TYPE;

3897: ,P_YEAR_END IN JAI_FA_AST_YEARS.YEAR_END%TYPE
3898: ,P_BLOCK_ID IN JAI_FA_AST_BLOCKS.BLOCK_ID%TYPE
3899: ,P_NO_ASSETS OUT NOCOPY VARCHAR2) RETURN NUMBER IS
3900: LV_CAPITALIZED JAI_FA_AST_BLOCK_DTLS.ASSET_TYPE%TYPE;
3901: LV_FLAG FA_BOOKS.CAPITALIZE_FLAG%TYPE;
3902: LV_EXPENSED JAI_FA_AST_BLOCK_DTLS.ASSET_TYPE%TYPE;
3903: LV_STATUS FA_RETIREMENTS.STATUS%TYPE;
3904: CURSOR CUR_GET_VALID_ASSETS IS
3905: SELECT

Line 3909: FA_BOOKS FAB,

3905: SELECT
3906: '1'
3907: FROM
3908: JAI_FA_AST_BLOCK_DTLS JBA,
3909: FA_BOOKS FAB,
3910: JAI_FA_AST_BLOCKS JABOA
3911: WHERE JBA.ASSET_ID = FAB.ASSET_ID
3912: AND ( ( JBA.ASSET_TYPE = LV_CAPITALIZED
3913: AND FAB.CAPITALIZE_FLAG = LV_FLAG )

Line 3959: FA_BOOKS A,

3955: A.COST,
3956: A.TRANSACTION_HEADER_ID_IN,
3957: A.DATE_EFFECTIVE
3958: FROM
3959: FA_BOOKS A,
3960: JAI_FA_AST_BLOCKS B,
3961: JAI_FA_AST_BLOCK_DTLS C,
3962: JAI_FA_AST_PERIOD_RATES D
3963: WHERE A.ASSET_ID = C.ASSET_ID

Line 4315: CURSOR CUR_GET_ADDITION_COST(CP_TRANSACTION_HEADER_ID_IN IN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE,CP_DATE_EFFECTIVE IN FA_BOOKS.DATE_EFFECTIVE%TYPE,CP_BOOK_NAME IN FA_BOOKS.BOOK_TYPE_CODE%TYPE,CP_ASSET_ID IN FA_BOOKS.ASSET_ID%TYPE) IS

4311: FUNCTION CF_8FORMULA(COST IN NUMBER
4312: ,TRANSACTION_HEADER_ID_IN IN NUMBER
4313: ,DATE_EFFECTIVE IN DATE
4314: ,ASSET_ID IN NUMBER) RETURN NUMBER IS
4315: CURSOR CUR_GET_ADDITION_COST(CP_TRANSACTION_HEADER_ID_IN IN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE,CP_DATE_EFFECTIVE IN FA_BOOKS.DATE_EFFECTIVE%TYPE,CP_BOOK_NAME IN FA_BOOKS.BOOK_TYPE_CODE%TYPE,CP_ASSET_ID IN FA_BOOKS.ASSET_ID%TYPE) IS
4316: SELECT
4317: TRANSACTION_HEADER_ID_IN,
4318: DATE_EFFECTIVE,
4319: FAB.COST

Line 4321: FA_BOOKS FAB

4317: TRANSACTION_HEADER_ID_IN,
4318: DATE_EFFECTIVE,
4319: FAB.COST
4320: FROM
4321: FA_BOOKS FAB
4322: WHERE FAB.TRANSACTION_HEADER_ID_OUT = CP_TRANSACTION_HEADER_ID_IN
4323: AND TRUNC(FAB.DATE_INEFFECTIVE) = TRUNC(CP_DATE_EFFECTIVE)
4324: AND FAB.BOOK_TYPE_CODE = CP_BOOK_NAME
4325: AND FAB.ASSET_ID = CP_ASSET_ID

Line 4328: LN_ADDITION_COST FA_BOOKS.COST%TYPE;

4324: AND FAB.BOOK_TYPE_CODE = CP_BOOK_NAME
4325: AND FAB.ASSET_ID = CP_ASSET_ID
4326: AND FAB.RETIREMENT_ID IS NOT NULL;
4327: REC_CUR_GET_ADDITION_COST CUR_GET_ADDITION_COST%ROWTYPE;
4328: LN_ADDITION_COST FA_BOOKS.COST%TYPE;
4329: LN_TRANSACTION_HEADER_ID_IN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE;
4330: LD_DATE_EFFECTIVE FA_BOOKS.DATE_EFFECTIVE%TYPE;
4331: BEGIN
4332: /*SRW.MESSAGE(1275

Line 4329: LN_TRANSACTION_HEADER_ID_IN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE;

4325: AND FAB.ASSET_ID = CP_ASSET_ID
4326: AND FAB.RETIREMENT_ID IS NOT NULL;
4327: REC_CUR_GET_ADDITION_COST CUR_GET_ADDITION_COST%ROWTYPE;
4328: LN_ADDITION_COST FA_BOOKS.COST%TYPE;
4329: LN_TRANSACTION_HEADER_ID_IN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE;
4330: LD_DATE_EFFECTIVE FA_BOOKS.DATE_EFFECTIVE%TYPE;
4331: BEGIN
4332: /*SRW.MESSAGE(1275
4333: ,'in cf8 formula column processing')*/NULL;

Line 4330: LD_DATE_EFFECTIVE FA_BOOKS.DATE_EFFECTIVE%TYPE;

4326: AND FAB.RETIREMENT_ID IS NOT NULL;
4327: REC_CUR_GET_ADDITION_COST CUR_GET_ADDITION_COST%ROWTYPE;
4328: LN_ADDITION_COST FA_BOOKS.COST%TYPE;
4329: LN_TRANSACTION_HEADER_ID_IN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE;
4330: LD_DATE_EFFECTIVE FA_BOOKS.DATE_EFFECTIVE%TYPE;
4331: BEGIN
4332: /*SRW.MESSAGE(1275
4333: ,'in cf8 formula column processing')*/NULL;
4334: IF NVL(COST

Line 4361: FUNCTION GET_TRANSACTION_HEADER_ID(P_BOOK_NAME IN FA_BOOKS.BOOK_TYPE_CODE%TYPE

4357: RETURN 0;
4358: END IF;
4359: END CF_8FORMULA;
4360:
4361: FUNCTION GET_TRANSACTION_HEADER_ID(P_BOOK_NAME IN FA_BOOKS.BOOK_TYPE_CODE%TYPE
4362: ,P_ASSET_ID IN FA_BOOKS.ASSET_ID%TYPE
4363: ,P_BLOCK_ID IN JAI_FA_AST_BLOCKS.BLOCK_ID%TYPE) RETURN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE IS
4364: CURSOR CUR_GET_ACTIVE_TRANSACTION_ID IS
4365: SELECT

Line 4362: ,P_ASSET_ID IN FA_BOOKS.ASSET_ID%TYPE

4358: END IF;
4359: END CF_8FORMULA;
4360:
4361: FUNCTION GET_TRANSACTION_HEADER_ID(P_BOOK_NAME IN FA_BOOKS.BOOK_TYPE_CODE%TYPE
4362: ,P_ASSET_ID IN FA_BOOKS.ASSET_ID%TYPE
4363: ,P_BLOCK_ID IN JAI_FA_AST_BLOCKS.BLOCK_ID%TYPE) RETURN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE IS
4364: CURSOR CUR_GET_ACTIVE_TRANSACTION_ID IS
4365: SELECT
4366: FAB.TRANSACTION_HEADER_ID_IN,

Line 4363: ,P_BLOCK_ID IN JAI_FA_AST_BLOCKS.BLOCK_ID%TYPE) RETURN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE IS

4359: END CF_8FORMULA;
4360:
4361: FUNCTION GET_TRANSACTION_HEADER_ID(P_BOOK_NAME IN FA_BOOKS.BOOK_TYPE_CODE%TYPE
4362: ,P_ASSET_ID IN FA_BOOKS.ASSET_ID%TYPE
4363: ,P_BLOCK_ID IN JAI_FA_AST_BLOCKS.BLOCK_ID%TYPE) RETURN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE IS
4364: CURSOR CUR_GET_ACTIVE_TRANSACTION_ID IS
4365: SELECT
4366: FAB.TRANSACTION_HEADER_ID_IN,
4367: FAB.DATE_EFFECTIVE,

Line 4370: FA_BOOKS FAB,

4366: FAB.TRANSACTION_HEADER_ID_IN,
4367: FAB.DATE_EFFECTIVE,
4368: FAB.COST
4369: FROM
4370: FA_BOOKS FAB,
4371: JAI_FA_AST_BLOCK_DTLS JBA
4372: WHERE FAB.ASSET_ID = JBA.ASSET_ID
4373: AND JBA.BLOCK_ID = P_BLOCK_ID
4374: AND JBA.ASSET_ID = P_ASSET_ID

Line 4378: CURSOR CUR_GET_TRANSACTION_ID_IN(CP_TRANSACTION_HEADER_ID_IN IN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE,CP_DATE_EFFECTIVE IN FA_BOOKS.DATE_EFFECTIVE%TYPE,CP_BOOK_NAME IN FA_BOOKS.BOOK_TYPE_CODE%TYPE,CP_ASSET_ID IN FA_BOOKS.ASSET_ID%TYPE) IS

4374: AND JBA.ASSET_ID = P_ASSET_ID
4375: AND FAB.TRANSACTION_HEADER_ID_OUT IS NULL
4376: AND FAB.DATE_INEFFECTIVE IS NULL
4377: AND FAB.BOOK_TYPE_CODE = P_BOOK_NAME;
4378: CURSOR CUR_GET_TRANSACTION_ID_IN(CP_TRANSACTION_HEADER_ID_IN IN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE,CP_DATE_EFFECTIVE IN FA_BOOKS.DATE_EFFECTIVE%TYPE,CP_BOOK_NAME IN FA_BOOKS.BOOK_TYPE_CODE%TYPE,CP_ASSET_ID IN FA_BOOKS.ASSET_ID%TYPE) IS
4379: SELECT
4380: TRANSACTION_HEADER_ID_IN,
4381: DATE_EFFECTIVE
4382: FROM

Line 4383: FA_BOOKS FAB

4379: SELECT
4380: TRANSACTION_HEADER_ID_IN,
4381: DATE_EFFECTIVE
4382: FROM
4383: FA_BOOKS FAB
4384: WHERE FAB.TRANSACTION_HEADER_ID_OUT = CP_TRANSACTION_HEADER_ID_IN
4385: AND TRUNC(FAB.DATE_INEFFECTIVE) = TRUNC(CP_DATE_EFFECTIVE)
4386: AND FAB.BOOK_TYPE_CODE = CP_BOOK_NAME
4387: AND FAB.ASSET_ID = CP_ASSET_ID

Line 4391: LN_TRANSACTION_HEADER_ID_IN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE;

4387: AND FAB.ASSET_ID = CP_ASSET_ID
4388: AND FAB.RETIREMENT_ID IS NOT NULL;
4389: REC_CUR_GET_ACT_TRANS_ID CUR_GET_ACTIVE_TRANSACTION_ID%ROWTYPE;
4390: REC_CUR_GET_TRANS_ID_IN CUR_GET_TRANSACTION_ID_IN%ROWTYPE;
4391: LN_TRANSACTION_HEADER_ID_IN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE;
4392: LD_DATE_EFFECTIVE FA_BOOKS.DATE_EFFECTIVE%TYPE;
4393: BEGIN
4394: OPEN CUR_GET_ACTIVE_TRANSACTION_ID;
4395: FETCH CUR_GET_ACTIVE_TRANSACTION_ID

Line 4392: LD_DATE_EFFECTIVE FA_BOOKS.DATE_EFFECTIVE%TYPE;

4388: AND FAB.RETIREMENT_ID IS NOT NULL;
4389: REC_CUR_GET_ACT_TRANS_ID CUR_GET_ACTIVE_TRANSACTION_ID%ROWTYPE;
4390: REC_CUR_GET_TRANS_ID_IN CUR_GET_TRANSACTION_ID_IN%ROWTYPE;
4391: LN_TRANSACTION_HEADER_ID_IN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE;
4392: LD_DATE_EFFECTIVE FA_BOOKS.DATE_EFFECTIVE%TYPE;
4393: BEGIN
4394: OPEN CUR_GET_ACTIVE_TRANSACTION_ID;
4395: FETCH CUR_GET_ACTIVE_TRANSACTION_ID
4396: INTO REC_CUR_GET_ACT_TRANS_ID;

Line 4443: FUNCTION CALCULATE_ACTUAL_COST(P_TRANSACTION_HEADER_ID_IN IN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE

4439: END IF;
4440: RETURN (LN_CLOSING_WDV_TOTAL);
4441: END CF_CLOSING_WDV_TOTFORMULA;
4442:
4443: FUNCTION CALCULATE_ACTUAL_COST(P_TRANSACTION_HEADER_ID_IN IN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE
4444: ,P_DATE_EFFECTIVE IN FA_BOOKS.DATE_EFFECTIVE%TYPE
4445: ,P_BOOK_NAME IN FA_BOOKS.BOOK_TYPE_CODE%TYPE
4446: ,P_ASSET_ID IN FA_BOOKS.ASSET_ID%TYPE
4447: ,P_COST IN FA_BOOKS.COST%TYPE) RETURN NUMBER IS

Line 4444: ,P_DATE_EFFECTIVE IN FA_BOOKS.DATE_EFFECTIVE%TYPE

4440: RETURN (LN_CLOSING_WDV_TOTAL);
4441: END CF_CLOSING_WDV_TOTFORMULA;
4442:
4443: FUNCTION CALCULATE_ACTUAL_COST(P_TRANSACTION_HEADER_ID_IN IN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE
4444: ,P_DATE_EFFECTIVE IN FA_BOOKS.DATE_EFFECTIVE%TYPE
4445: ,P_BOOK_NAME IN FA_BOOKS.BOOK_TYPE_CODE%TYPE
4446: ,P_ASSET_ID IN FA_BOOKS.ASSET_ID%TYPE
4447: ,P_COST IN FA_BOOKS.COST%TYPE) RETURN NUMBER IS
4448: CURSOR CUR_GET_ADDITION_COST(CP_TRANSACTION_HEADER_ID_IN IN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE,CP_DATE_EFFECTIVE IN FA_BOOKS.DATE_EFFECTIVE%TYPE,CP_BOOK_NAME IN FA_BOOKS.BOOK_TYPE_CODE%TYPE,CP_ASSET_ID IN FA_BOOKS.ASSET_ID%TYPE) IS

Line 4445: ,P_BOOK_NAME IN FA_BOOKS.BOOK_TYPE_CODE%TYPE

4441: END CF_CLOSING_WDV_TOTFORMULA;
4442:
4443: FUNCTION CALCULATE_ACTUAL_COST(P_TRANSACTION_HEADER_ID_IN IN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE
4444: ,P_DATE_EFFECTIVE IN FA_BOOKS.DATE_EFFECTIVE%TYPE
4445: ,P_BOOK_NAME IN FA_BOOKS.BOOK_TYPE_CODE%TYPE
4446: ,P_ASSET_ID IN FA_BOOKS.ASSET_ID%TYPE
4447: ,P_COST IN FA_BOOKS.COST%TYPE) RETURN NUMBER IS
4448: CURSOR CUR_GET_ADDITION_COST(CP_TRANSACTION_HEADER_ID_IN IN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE,CP_DATE_EFFECTIVE IN FA_BOOKS.DATE_EFFECTIVE%TYPE,CP_BOOK_NAME IN FA_BOOKS.BOOK_TYPE_CODE%TYPE,CP_ASSET_ID IN FA_BOOKS.ASSET_ID%TYPE) IS
4449: SELECT

Line 4446: ,P_ASSET_ID IN FA_BOOKS.ASSET_ID%TYPE

4442:
4443: FUNCTION CALCULATE_ACTUAL_COST(P_TRANSACTION_HEADER_ID_IN IN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE
4444: ,P_DATE_EFFECTIVE IN FA_BOOKS.DATE_EFFECTIVE%TYPE
4445: ,P_BOOK_NAME IN FA_BOOKS.BOOK_TYPE_CODE%TYPE
4446: ,P_ASSET_ID IN FA_BOOKS.ASSET_ID%TYPE
4447: ,P_COST IN FA_BOOKS.COST%TYPE) RETURN NUMBER IS
4448: CURSOR CUR_GET_ADDITION_COST(CP_TRANSACTION_HEADER_ID_IN IN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE,CP_DATE_EFFECTIVE IN FA_BOOKS.DATE_EFFECTIVE%TYPE,CP_BOOK_NAME IN FA_BOOKS.BOOK_TYPE_CODE%TYPE,CP_ASSET_ID IN FA_BOOKS.ASSET_ID%TYPE) IS
4449: SELECT
4450: TRANSACTION_HEADER_ID_IN,

Line 4447: ,P_COST IN FA_BOOKS.COST%TYPE) RETURN NUMBER IS

4443: FUNCTION CALCULATE_ACTUAL_COST(P_TRANSACTION_HEADER_ID_IN IN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE
4444: ,P_DATE_EFFECTIVE IN FA_BOOKS.DATE_EFFECTIVE%TYPE
4445: ,P_BOOK_NAME IN FA_BOOKS.BOOK_TYPE_CODE%TYPE
4446: ,P_ASSET_ID IN FA_BOOKS.ASSET_ID%TYPE
4447: ,P_COST IN FA_BOOKS.COST%TYPE) RETURN NUMBER IS
4448: CURSOR CUR_GET_ADDITION_COST(CP_TRANSACTION_HEADER_ID_IN IN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE,CP_DATE_EFFECTIVE IN FA_BOOKS.DATE_EFFECTIVE%TYPE,CP_BOOK_NAME IN FA_BOOKS.BOOK_TYPE_CODE%TYPE,CP_ASSET_ID IN FA_BOOKS.ASSET_ID%TYPE) IS
4449: SELECT
4450: TRANSACTION_HEADER_ID_IN,
4451: DATE_EFFECTIVE,

Line 4448: CURSOR CUR_GET_ADDITION_COST(CP_TRANSACTION_HEADER_ID_IN IN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE,CP_DATE_EFFECTIVE IN FA_BOOKS.DATE_EFFECTIVE%TYPE,CP_BOOK_NAME IN FA_BOOKS.BOOK_TYPE_CODE%TYPE,CP_ASSET_ID IN FA_BOOKS.ASSET_ID%TYPE) IS

4444: ,P_DATE_EFFECTIVE IN FA_BOOKS.DATE_EFFECTIVE%TYPE
4445: ,P_BOOK_NAME IN FA_BOOKS.BOOK_TYPE_CODE%TYPE
4446: ,P_ASSET_ID IN FA_BOOKS.ASSET_ID%TYPE
4447: ,P_COST IN FA_BOOKS.COST%TYPE) RETURN NUMBER IS
4448: CURSOR CUR_GET_ADDITION_COST(CP_TRANSACTION_HEADER_ID_IN IN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE,CP_DATE_EFFECTIVE IN FA_BOOKS.DATE_EFFECTIVE%TYPE,CP_BOOK_NAME IN FA_BOOKS.BOOK_TYPE_CODE%TYPE,CP_ASSET_ID IN FA_BOOKS.ASSET_ID%TYPE) IS
4449: SELECT
4450: TRANSACTION_HEADER_ID_IN,
4451: DATE_EFFECTIVE,
4452: FAB.COST

Line 4454: FA_BOOKS FAB

4450: TRANSACTION_HEADER_ID_IN,
4451: DATE_EFFECTIVE,
4452: FAB.COST
4453: FROM
4454: FA_BOOKS FAB
4455: WHERE FAB.TRANSACTION_HEADER_ID_OUT = CP_TRANSACTION_HEADER_ID_IN
4456: AND TRUNC(FAB.DATE_INEFFECTIVE) = TRUNC(CP_DATE_EFFECTIVE)
4457: AND FAB.BOOK_TYPE_CODE = CP_BOOK_NAME
4458: AND FAB.ASSET_ID = CP_ASSET_ID

Line 4461: LN_ADDITION_COST FA_BOOKS.COST%TYPE;

4457: AND FAB.BOOK_TYPE_CODE = CP_BOOK_NAME
4458: AND FAB.ASSET_ID = CP_ASSET_ID
4459: AND FAB.RETIREMENT_ID IS NOT NULL;
4460: REC_CUR_GET_ADDITION_COST CUR_GET_ADDITION_COST%ROWTYPE;
4461: LN_ADDITION_COST FA_BOOKS.COST%TYPE;
4462: LN_TRANSACTION_HEADER_ID_IN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE;
4463: LD_DATE_EFFECTIVE FA_BOOKS.DATE_EFFECTIVE%TYPE;
4464: BEGIN
4465: /*SRW.MESSAGE(1275

Line 4462: LN_TRANSACTION_HEADER_ID_IN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE;

4458: AND FAB.ASSET_ID = CP_ASSET_ID
4459: AND FAB.RETIREMENT_ID IS NOT NULL;
4460: REC_CUR_GET_ADDITION_COST CUR_GET_ADDITION_COST%ROWTYPE;
4461: LN_ADDITION_COST FA_BOOKS.COST%TYPE;
4462: LN_TRANSACTION_HEADER_ID_IN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE;
4463: LD_DATE_EFFECTIVE FA_BOOKS.DATE_EFFECTIVE%TYPE;
4464: BEGIN
4465: /*SRW.MESSAGE(1275
4466: ,'in function calculate_actual_cost for actual cost processing')*/NULL;

Line 4463: LD_DATE_EFFECTIVE FA_BOOKS.DATE_EFFECTIVE%TYPE;

4459: AND FAB.RETIREMENT_ID IS NOT NULL;
4460: REC_CUR_GET_ADDITION_COST CUR_GET_ADDITION_COST%ROWTYPE;
4461: LN_ADDITION_COST FA_BOOKS.COST%TYPE;
4462: LN_TRANSACTION_HEADER_ID_IN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE;
4463: LD_DATE_EFFECTIVE FA_BOOKS.DATE_EFFECTIVE%TYPE;
4464: BEGIN
4465: /*SRW.MESSAGE(1275
4466: ,'in function calculate_actual_cost for actual cost processing')*/NULL;
4467: LN_ADDITION_COST := P_COST;