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_JAINASST_XMLP_PKG dependencies on FA_BOOKS

Line 118: LV_FLAG FA_BOOKS.CAPITALIZE_FLAG%TYPE;

114: ,OP_TOT IN NUMBER
115: ,COS_TOT IN NUMBER
116: ,RATE IN NUMBER) RETURN NUMBER IS
117: LV_ASSEST_CAPITALIZED JAI_FA_AST_BLOCK_DTLS.ASSET_TYPE%TYPE;
118: LV_FLAG FA_BOOKS.CAPITALIZE_FLAG%TYPE;
119: LV_ASSET_TYPE JAI_FA_AST_BLOCK_DTLS.ASSET_TYPE%TYPE;
120: CURSOR CUR_GET_VALID_ASSETS IS
121: SELECT
122: '1'

Line 125: FA_BOOKS FAB,

121: SELECT
122: '1'
123: FROM
124: JAI_FA_AST_BLOCK_DTLS JBA,
125: FA_BOOKS FAB,
126: JAI_FA_AST_BLOCKS JABOA
127: WHERE JBA.ASSET_ID = FAB.ASSET_ID
128: AND ( ( JBA.ASSET_TYPE = LV_ASSEST_CAPITALIZED
129: AND FAB.CAPITALIZE_FLAG = LV_FLAG )

Line 175: FA_BOOKS A,

171: A.COST,
172: A.TRANSACTION_HEADER_ID_IN,
173: A.DATE_EFFECTIVE
174: FROM
175: FA_BOOKS A,
176: JAI_FA_AST_BLOCKS B,
177: JAI_FA_AST_BLOCK_DTLS C,
178: JAI_FA_AST_PERIOD_RATES D
179: WHERE A.ASSET_ID = C.ASSET_ID

Line 339: LV_FLAG FA_BOOKS.CAPITALIZE_FLAG%TYPE;

335: END AFTERREPORT;
336:
337: FUNCTION CF_8FORMULA(BLOCK_ID IN NUMBER) RETURN NUMBER IS
338: LV_ASSEST_CAPITALIZED JAI_FA_AST_BLOCK_DTLS.ASSET_TYPE%TYPE;
339: LV_FLAG FA_BOOKS.CAPITALIZE_FLAG%TYPE;
340: LV_ASSET_TYPE JAI_FA_AST_BLOCK_DTLS.ASSET_TYPE%TYPE;
341: CURSOR ASSET_COST IS
342: SELECT
343: NVL(SUM(COST)

Line 346: FA_BOOKS A,

342: SELECT
343: NVL(SUM(COST)
344: ,0) COST
345: FROM
346: FA_BOOKS A,
347: JAI_FA_AST_BLOCK_DTLS B
348: WHERE A.ASSET_ID NOT IN (
349: SELECT
350: ASSET_ID

Line 453: 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

449: FUNCTION CF_ADDITIONS_COSTFORMULA(COST IN NUMBER
450: ,TRANSACTION_HEADER_ID_IN IN NUMBER
451: ,DATE_EFFECTIVE IN DATE
452: ,ASSET_ID IN NUMBER) RETURN NUMBER IS
453: 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
454: SELECT
455: TRANSACTION_HEADER_ID_IN,
456: DATE_EFFECTIVE,
457: FAB.COST

Line 459: FA_BOOKS FAB

455: TRANSACTION_HEADER_ID_IN,
456: DATE_EFFECTIVE,
457: FAB.COST
458: FROM
459: FA_BOOKS FAB
460: WHERE FAB.TRANSACTION_HEADER_ID_OUT = CP_TRANSACTION_HEADER_ID_IN
461: AND TRUNC(FAB.DATE_INEFFECTIVE) = TRUNC(CP_DATE_EFFECTIVE)
462: AND FAB.BOOK_TYPE_CODE = CP_BOOK_NAME
463: AND FAB.ASSET_ID = CP_ASSET_ID

Line 466: LN_ADDITION_COST FA_BOOKS.COST%TYPE;

462: AND FAB.BOOK_TYPE_CODE = CP_BOOK_NAME
463: AND FAB.ASSET_ID = CP_ASSET_ID
464: AND FAB.RETIREMENT_ID IS NOT NULL;
465: REC_CUR_GET_ADDITION_COST CUR_GET_ADDITION_COST%ROWTYPE;
466: LN_ADDITION_COST FA_BOOKS.COST%TYPE;
467: LN_TRANSACTION_HEADER_ID_IN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE;
468: LD_DATE_EFFECTIVE FA_BOOKS.DATE_EFFECTIVE%TYPE;
469: BEGIN
470: /*SRW.MESSAGE(1275

Line 467: LN_TRANSACTION_HEADER_ID_IN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE;

463: AND FAB.ASSET_ID = CP_ASSET_ID
464: AND FAB.RETIREMENT_ID IS NOT NULL;
465: REC_CUR_GET_ADDITION_COST CUR_GET_ADDITION_COST%ROWTYPE;
466: LN_ADDITION_COST FA_BOOKS.COST%TYPE;
467: LN_TRANSACTION_HEADER_ID_IN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE;
468: LD_DATE_EFFECTIVE FA_BOOKS.DATE_EFFECTIVE%TYPE;
469: BEGIN
470: /*SRW.MESSAGE(1275
471: ,'in cf8 formula column processing')*/NULL;

Line 468: LD_DATE_EFFECTIVE FA_BOOKS.DATE_EFFECTIVE%TYPE;

464: AND FAB.RETIREMENT_ID IS NOT NULL;
465: REC_CUR_GET_ADDITION_COST CUR_GET_ADDITION_COST%ROWTYPE;
466: LN_ADDITION_COST FA_BOOKS.COST%TYPE;
467: LN_TRANSACTION_HEADER_ID_IN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE;
468: LD_DATE_EFFECTIVE FA_BOOKS.DATE_EFFECTIVE%TYPE;
469: BEGIN
470: /*SRW.MESSAGE(1275
471: ,'in cf8 formula column processing')*/NULL;
472: IF NVL(COST

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

512: END IF;
513: RETURN (LN_CLOSING_WDV_TOTAL);
514: END CF_CLOSING_WDV_TOTALFORMULA;
515:
516: FUNCTION CALCULATE_ACTUAL_COST(P_TRANSACTION_HEADER_ID_IN IN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE
517: ,P_DATE_EFFECTIVE IN FA_BOOKS.DATE_EFFECTIVE%TYPE
518: ,P_BOOK_NAME IN FA_BOOKS.BOOK_TYPE_CODE%TYPE
519: ,P_ASSET_ID IN FA_BOOKS.ASSET_ID%TYPE
520: ,P_COST IN FA_BOOKS.COST%TYPE) RETURN NUMBER IS

Line 517: ,P_DATE_EFFECTIVE IN FA_BOOKS.DATE_EFFECTIVE%TYPE

513: RETURN (LN_CLOSING_WDV_TOTAL);
514: END CF_CLOSING_WDV_TOTALFORMULA;
515:
516: FUNCTION CALCULATE_ACTUAL_COST(P_TRANSACTION_HEADER_ID_IN IN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE
517: ,P_DATE_EFFECTIVE IN FA_BOOKS.DATE_EFFECTIVE%TYPE
518: ,P_BOOK_NAME IN FA_BOOKS.BOOK_TYPE_CODE%TYPE
519: ,P_ASSET_ID IN FA_BOOKS.ASSET_ID%TYPE
520: ,P_COST IN FA_BOOKS.COST%TYPE) RETURN NUMBER IS
521: 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 518: ,P_BOOK_NAME IN FA_BOOKS.BOOK_TYPE_CODE%TYPE

514: END CF_CLOSING_WDV_TOTALFORMULA;
515:
516: FUNCTION CALCULATE_ACTUAL_COST(P_TRANSACTION_HEADER_ID_IN IN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE
517: ,P_DATE_EFFECTIVE IN FA_BOOKS.DATE_EFFECTIVE%TYPE
518: ,P_BOOK_NAME IN FA_BOOKS.BOOK_TYPE_CODE%TYPE
519: ,P_ASSET_ID IN FA_BOOKS.ASSET_ID%TYPE
520: ,P_COST IN FA_BOOKS.COST%TYPE) RETURN NUMBER IS
521: 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
522: SELECT

Line 519: ,P_ASSET_ID IN FA_BOOKS.ASSET_ID%TYPE

515:
516: FUNCTION CALCULATE_ACTUAL_COST(P_TRANSACTION_HEADER_ID_IN IN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE
517: ,P_DATE_EFFECTIVE IN FA_BOOKS.DATE_EFFECTIVE%TYPE
518: ,P_BOOK_NAME IN FA_BOOKS.BOOK_TYPE_CODE%TYPE
519: ,P_ASSET_ID IN FA_BOOKS.ASSET_ID%TYPE
520: ,P_COST IN FA_BOOKS.COST%TYPE) RETURN NUMBER IS
521: 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
522: SELECT
523: TRANSACTION_HEADER_ID_IN,

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

516: FUNCTION CALCULATE_ACTUAL_COST(P_TRANSACTION_HEADER_ID_IN IN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE
517: ,P_DATE_EFFECTIVE IN FA_BOOKS.DATE_EFFECTIVE%TYPE
518: ,P_BOOK_NAME IN FA_BOOKS.BOOK_TYPE_CODE%TYPE
519: ,P_ASSET_ID IN FA_BOOKS.ASSET_ID%TYPE
520: ,P_COST IN FA_BOOKS.COST%TYPE) RETURN NUMBER IS
521: 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
522: SELECT
523: TRANSACTION_HEADER_ID_IN,
524: DATE_EFFECTIVE,

Line 521: 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

517: ,P_DATE_EFFECTIVE IN FA_BOOKS.DATE_EFFECTIVE%TYPE
518: ,P_BOOK_NAME IN FA_BOOKS.BOOK_TYPE_CODE%TYPE
519: ,P_ASSET_ID IN FA_BOOKS.ASSET_ID%TYPE
520: ,P_COST IN FA_BOOKS.COST%TYPE) RETURN NUMBER IS
521: 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
522: SELECT
523: TRANSACTION_HEADER_ID_IN,
524: DATE_EFFECTIVE,
525: FAB.COST

Line 527: FA_BOOKS FAB

523: TRANSACTION_HEADER_ID_IN,
524: DATE_EFFECTIVE,
525: FAB.COST
526: FROM
527: FA_BOOKS FAB
528: WHERE FAB.TRANSACTION_HEADER_ID_OUT = CP_TRANSACTION_HEADER_ID_IN
529: AND TRUNC(FAB.DATE_INEFFECTIVE) = TRUNC(CP_DATE_EFFECTIVE)
530: AND FAB.BOOK_TYPE_CODE = CP_BOOK_NAME
531: AND FAB.ASSET_ID = CP_ASSET_ID

Line 534: LN_ADDITION_COST FA_BOOKS.COST%TYPE;

530: AND FAB.BOOK_TYPE_CODE = CP_BOOK_NAME
531: AND FAB.ASSET_ID = CP_ASSET_ID
532: AND FAB.RETIREMENT_ID IS NOT NULL;
533: REC_CUR_GET_ADDITION_COST CUR_GET_ADDITION_COST%ROWTYPE;
534: LN_ADDITION_COST FA_BOOKS.COST%TYPE;
535: LN_TRANSACTION_HEADER_ID_IN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE;
536: LD_DATE_EFFECTIVE FA_BOOKS.DATE_EFFECTIVE%TYPE;
537: BEGIN
538: /*SRW.MESSAGE(1275

Line 535: LN_TRANSACTION_HEADER_ID_IN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE;

531: AND FAB.ASSET_ID = CP_ASSET_ID
532: AND FAB.RETIREMENT_ID IS NOT NULL;
533: REC_CUR_GET_ADDITION_COST CUR_GET_ADDITION_COST%ROWTYPE;
534: LN_ADDITION_COST FA_BOOKS.COST%TYPE;
535: LN_TRANSACTION_HEADER_ID_IN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE;
536: LD_DATE_EFFECTIVE FA_BOOKS.DATE_EFFECTIVE%TYPE;
537: BEGIN
538: /*SRW.MESSAGE(1275
539: ,'in function calculate_actual_cost for actual cost processing')*/NULL;

Line 536: LD_DATE_EFFECTIVE FA_BOOKS.DATE_EFFECTIVE%TYPE;

532: AND FAB.RETIREMENT_ID IS NOT NULL;
533: REC_CUR_GET_ADDITION_COST CUR_GET_ADDITION_COST%ROWTYPE;
534: LN_ADDITION_COST FA_BOOKS.COST%TYPE;
535: LN_TRANSACTION_HEADER_ID_IN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE;
536: LD_DATE_EFFECTIVE FA_BOOKS.DATE_EFFECTIVE%TYPE;
537: BEGIN
538: /*SRW.MESSAGE(1275
539: ,'in function calculate_actual_cost for actual cost processing')*/NULL;
540: LN_ADDITION_COST := P_COST;