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 JA_JAINASST_XMLP_PKG

Line 1: PACKAGE BODY JA_JAINASST_XMLP_PKG AS

1: PACKAGE BODY JA_JAINASST_XMLP_PKG AS
2: /* $Header: JAINASSTB.pls 120.1 2007/12/25 16:13:14 dwkrishn noship $ */
3: FUNCTION CF_1FORMULA RETURN VARCHAR2 IS
4: N VARCHAR2(100);
5: BEGIN

Line 52: AND START_DATE < JA_JAINASST_XMLP_PKG.START_DATE

48: FROM
49: JAI_FA_AST_BLOCKS
50: WHERE TYPE = CF_4FORMULA.TYPE
51: AND RATE = CF_4FORMULA.RATE
52: AND START_DATE < JA_JAINASST_XMLP_PKG.START_DATE
53: AND BOOK_TYPE_CODE = BOOK_NAME;
54: CURSOR SALE_CUR(CP_OWNED_LEASED IN FA_ADDITIONS.OWNED_LEASED%TYPE,CP_STATUS IN FA_RETIREMENTS.STATUS%TYPE) IS
55: SELECT
56: NVL(SUM(FAR.PROCEEDS_OF_SALE - FAR.COST_OF_REMOVAL)

Line 72: AND FAR.DATE_RETIRED between JA_JAINASST_XMLP_PKG.START_DATE

68: AND JABLOA.TYPE = CF_4FORMULA.TYPE
69: AND JABLOA.RATE = CF_4FORMULA.RATE
70: AND JBA.ASSET_ID = FAR.ASSET_ID
71: AND FAR.STATUS = CP_STATUS
72: AND FAR.DATE_RETIRED between JA_JAINASST_XMLP_PKG.START_DATE
73: AND JA_JAINASST_XMLP_PKG.END_DATE;
74: BEGIN
75: OPEN TYPE_RATE_CUR;
76: FETCH TYPE_RATE_CUR

Line 73: AND JA_JAINASST_XMLP_PKG.END_DATE;

69: AND JABLOA.RATE = CF_4FORMULA.RATE
70: AND JBA.ASSET_ID = FAR.ASSET_ID
71: AND FAR.STATUS = CP_STATUS
72: AND FAR.DATE_RETIRED between JA_JAINASST_XMLP_PKG.START_DATE
73: AND JA_JAINASST_XMLP_PKG.END_DATE;
74: BEGIN
75: OPEN TYPE_RATE_CUR;
76: FETCH TYPE_RATE_CUR
77: INTO V_TYPE,V_RATE;

Line 146: AND ( JABOA.START_DATE <= NVL(JA_JAINASST_XMLP_PKG.START_DATE

142: TYPE
143: FROM
144: JAI_FA_AST_BLOCKS
145: WHERE BLOCK_ID = CF_6FORMULA.BLOCK_ID )
146: AND ( JABOA.START_DATE <= NVL(JA_JAINASST_XMLP_PKG.START_DATE
147: ,JABOA.START_DATE)
148: OR JABOA.START_DATE BETWEEN NVL(JA_JAINASST_XMLP_PKG.START_DATE
149: ,JABOA.START_DATE)
150: AND NVL(END_DATE

Line 148: OR JABOA.START_DATE BETWEEN NVL(JA_JAINASST_XMLP_PKG.START_DATE

144: JAI_FA_AST_BLOCKS
145: WHERE BLOCK_ID = CF_6FORMULA.BLOCK_ID )
146: AND ( JABOA.START_DATE <= NVL(JA_JAINASST_XMLP_PKG.START_DATE
147: ,JABOA.START_DATE)
148: OR JABOA.START_DATE BETWEEN NVL(JA_JAINASST_XMLP_PKG.START_DATE
149: ,JABOA.START_DATE)
150: AND NVL(END_DATE
151: ,JABOA.YEAR_ENDED) );
152: CURSOR CUR_GET_ST_OP_BAL(CP_BLOCK_ID IN JAI_FA_AST_BLOCKS.BLOCK_ID%TYPE) IS

Line 189: AND B.START_DATE between NVL(JA_JAINASST_XMLP_PKG.START_DATE

185: AND A.BOOK_TYPE_CODE = B.BOOK_TYPE_CODE
186: AND A.BOOK_TYPE_CODE = BOOK_NAME
187: AND C.DATE_OF_ACQUISITION between D.START_DATE
188: AND D.END_DATE
189: AND B.START_DATE between NVL(JA_JAINASST_XMLP_PKG.START_DATE
190: ,B.START_DATE)
191: AND NVL(END_DATE
192: ,B.YEAR_ENDED)
193: AND D.START_DATE >= ADD_MONTHS(JA_JAINASST_XMLP_PKG.START_DATE,6)

Line 193: AND D.START_DATE >= ADD_MONTHS(JA_JAINASST_XMLP_PKG.START_DATE,6)

189: AND B.START_DATE between NVL(JA_JAINASST_XMLP_PKG.START_DATE
190: ,B.START_DATE)
191: AND NVL(END_DATE
192: ,B.YEAR_ENDED)
193: AND D.START_DATE >= ADD_MONTHS(JA_JAINASST_XMLP_PKG.START_DATE,6)
194: AND D.SLNO = 2
195: AND A.DATE_INEFFECTIVE is null
196: AND A.TRANSACTION_HEADER_ID_OUT is null;
197: CURSOR BLOCK_RET_CUR_FIR(P_BLOCK_TYPE IN VARCHAR2) IS

Line 214: AND D.START_DATE < ADD_MONTHS(JA_JAINASST_XMLP_PKG.START_DATE

210: AND B.ASSET_TYPE IN ( 'CAPITALIZED' , 'EXPENSED' )
211: AND TO_DATE(B.ATTRIBUTE1
212: ,'DD-MON-RRRR') between D.START_DATE
213: AND D.END_DATE
214: AND D.START_DATE < ADD_MONTHS(JA_JAINASST_XMLP_PKG.START_DATE
215: ,6)
216: AND D.SLNO = 1
217: AND B.ASSET_ID = C.ASSET_ID
218: AND C.STATUS = 'PROCESSED'

Line 221: AND C.DATE_RETIRED BETWEEN JA_JAINASST_XMLP_PKG.START_DATE

217: AND B.ASSET_ID = C.ASSET_ID
218: AND C.STATUS = 'PROCESSED'
219: AND A.TYPE = P_BLOCK_TYPE
220: AND A.BLOCK_ID = CF_6FORMULA.BLOCK_ID
221: AND C.DATE_RETIRED BETWEEN JA_JAINASST_XMLP_PKG.START_DATE
222: AND JA_JAINASST_XMLP_PKG.END_DATE;
223: CURSOR BLOCK_RET_CUR_SEC(P_BLOCK_TYPE IN VARCHAR2) IS
224: SELECT
225: NVL(SUM(C.PROCEEDS_OF_SALE - C.COST_OF_REMOVAL)

Line 222: AND JA_JAINASST_XMLP_PKG.END_DATE;

218: AND C.STATUS = 'PROCESSED'
219: AND A.TYPE = P_BLOCK_TYPE
220: AND A.BLOCK_ID = CF_6FORMULA.BLOCK_ID
221: AND C.DATE_RETIRED BETWEEN JA_JAINASST_XMLP_PKG.START_DATE
222: AND JA_JAINASST_XMLP_PKG.END_DATE;
223: CURSOR BLOCK_RET_CUR_SEC(P_BLOCK_TYPE IN VARCHAR2) IS
224: SELECT
225: NVL(SUM(C.PROCEEDS_OF_SALE - C.COST_OF_REMOVAL)
226: ,0) SALE

Line 240: AND D.START_DATE >= ADD_MONTHS(JA_JAINASST_XMLP_PKG.START_DATE

236: AND B.ASSET_TYPE IN ( 'CAPITALIZED' , 'EXPENSED' )
237: AND TO_DATE(B.ATTRIBUTE1
238: ,'DD-MON-RRRR') between D.START_DATE
239: AND D.END_DATE
240: AND D.START_DATE >= ADD_MONTHS(JA_JAINASST_XMLP_PKG.START_DATE
241: ,6)
242: AND D.SLNO = 2
243: AND B.ASSET_ID = C.ASSET_ID
244: AND C.STATUS = 'PROCESSED'

Line 247: AND C.DATE_RETIRED BETWEEN JA_JAINASST_XMLP_PKG.START_DATE

243: AND B.ASSET_ID = C.ASSET_ID
244: AND C.STATUS = 'PROCESSED'
245: AND A.TYPE = P_BLOCK_TYPE
246: AND A.BLOCK_ID = CF_6FORMULA.BLOCK_ID
247: AND C.DATE_RETIRED BETWEEN JA_JAINASST_XMLP_PKG.START_DATE
248: AND JA_JAINASST_XMLP_PKG.END_DATE;
249: V_COST NUMBER;
250: V_TOTAL1 NUMBER;
251: V_TOTAL2 NUMBER;

Line 248: AND JA_JAINASST_XMLP_PKG.END_DATE;

244: AND C.STATUS = 'PROCESSED'
245: AND A.TYPE = P_BLOCK_TYPE
246: AND A.BLOCK_ID = CF_6FORMULA.BLOCK_ID
247: AND C.DATE_RETIRED BETWEEN JA_JAINASST_XMLP_PKG.START_DATE
248: AND JA_JAINASST_XMLP_PKG.END_DATE;
249: V_COST NUMBER;
250: V_TOTAL1 NUMBER;
251: V_TOTAL2 NUMBER;
252: V_DEPRN NUMBER;

Line 562: END JA_JAINASST_XMLP_PKG;

558: ,'Asset ->' || P_ASSET_ID || ' Book_name ' || P_BOOK_NAME || 'value of ln_addition_cost is ' || LN_ADDITION_COST)*/NULL;
559: RETURN (LN_ADDITION_COST);
560: END CALCULATE_ACTUAL_COST;
561:
562: END JA_JAINASST_XMLP_PKG;
563:
564: