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.AP_APXKIRKI_XMLP_PKG dependencies on AP_OTHER_PERIODS

Line 73: AP_OTHER_PERIODS

69: RETURN (FALSE);
70: END IF;
71: IF C_STATUS = 'N' THEN
72: UPDATE
73: AP_OTHER_PERIODS
74: SET
75: STATUS = 'S'
76: WHERE PERIOD_NAME = P_PERIOD_NAME
77: AND MODULE = C_MODULE;

Line 99: AP_OTHER_PERIODS

95: RETURN (FALSE);
96: END IF;
97: END IF;
98: UPDATE
99: AP_OTHER_PERIODS
100: SET
101: STATUS = 'C'
102: WHERE PERIOD_NAME = P_PERIOD_NAME
103: AND MODULE = C_MODULE;

Line 256: AP_OTHER_PERIODS

252: IF (P_DEBUG_SWITCH = 'Y') THEN
253: /*SRW.MESSAGE('20'
254: ,'After SRWEXIT')*/NULL;
255: UPDATE
256: AP_OTHER_PERIODS
257: SET
258: STATUS = 'Y'
259: WHERE PERIOD_NAME = P_PERIOD_NAME
260: AND PERIOD_TYPE = C_PERIOD_TYPE

Line 314: L_PERIOD_YEAR AP_OTHER_PERIODS.PERIOD_YEAR%TYPE;

310: /*RAISE SRW.PROGRAM_ABORT*/RAISE_APPLICATION_ERROR(-20101,null);
311: END CALCULATE_RUN_TIME;
312:
313: FUNCTION PERIOD_DATA RETURN BOOLEAN IS
314: L_PERIOD_YEAR AP_OTHER_PERIODS.PERIOD_YEAR%TYPE;
315: L_PRIOR_PERIOD_YEAR AP_OTHER_PERIODS.PERIOD_YEAR%TYPE;
316: L_PERIOD_NUM AP_OTHER_PERIODS.PERIOD_NUM%TYPE;
317: L_PRIOR_PERIOD_NUM AP_OTHER_PERIODS.PERIOD_NUM%TYPE;
318: L_PRIOR_PERIOD_NAME AP_OTHER_PERIODS.PERIOD_NAME%TYPE;

Line 315: L_PRIOR_PERIOD_YEAR AP_OTHER_PERIODS.PERIOD_YEAR%TYPE;

311: END CALCULATE_RUN_TIME;
312:
313: FUNCTION PERIOD_DATA RETURN BOOLEAN IS
314: L_PERIOD_YEAR AP_OTHER_PERIODS.PERIOD_YEAR%TYPE;
315: L_PRIOR_PERIOD_YEAR AP_OTHER_PERIODS.PERIOD_YEAR%TYPE;
316: L_PERIOD_NUM AP_OTHER_PERIODS.PERIOD_NUM%TYPE;
317: L_PRIOR_PERIOD_NUM AP_OTHER_PERIODS.PERIOD_NUM%TYPE;
318: L_PRIOR_PERIOD_NAME AP_OTHER_PERIODS.PERIOD_NAME%TYPE;
319: L_PERIOD_TYPE AP_OTHER_PERIODS.PERIOD_TYPE%TYPE;

Line 316: L_PERIOD_NUM AP_OTHER_PERIODS.PERIOD_NUM%TYPE;

312:
313: FUNCTION PERIOD_DATA RETURN BOOLEAN IS
314: L_PERIOD_YEAR AP_OTHER_PERIODS.PERIOD_YEAR%TYPE;
315: L_PRIOR_PERIOD_YEAR AP_OTHER_PERIODS.PERIOD_YEAR%TYPE;
316: L_PERIOD_NUM AP_OTHER_PERIODS.PERIOD_NUM%TYPE;
317: L_PRIOR_PERIOD_NUM AP_OTHER_PERIODS.PERIOD_NUM%TYPE;
318: L_PRIOR_PERIOD_NAME AP_OTHER_PERIODS.PERIOD_NAME%TYPE;
319: L_PERIOD_TYPE AP_OTHER_PERIODS.PERIOD_TYPE%TYPE;
320: L_START_DATE AP_OTHER_PERIODS.START_DATE%TYPE;

Line 317: L_PRIOR_PERIOD_NUM AP_OTHER_PERIODS.PERIOD_NUM%TYPE;

313: FUNCTION PERIOD_DATA RETURN BOOLEAN IS
314: L_PERIOD_YEAR AP_OTHER_PERIODS.PERIOD_YEAR%TYPE;
315: L_PRIOR_PERIOD_YEAR AP_OTHER_PERIODS.PERIOD_YEAR%TYPE;
316: L_PERIOD_NUM AP_OTHER_PERIODS.PERIOD_NUM%TYPE;
317: L_PRIOR_PERIOD_NUM AP_OTHER_PERIODS.PERIOD_NUM%TYPE;
318: L_PRIOR_PERIOD_NAME AP_OTHER_PERIODS.PERIOD_NAME%TYPE;
319: L_PERIOD_TYPE AP_OTHER_PERIODS.PERIOD_TYPE%TYPE;
320: L_START_DATE AP_OTHER_PERIODS.START_DATE%TYPE;
321: L_PRIOR_START_DATE AP_OTHER_PERIODS.START_DATE%TYPE;

Line 318: L_PRIOR_PERIOD_NAME AP_OTHER_PERIODS.PERIOD_NAME%TYPE;

314: L_PERIOD_YEAR AP_OTHER_PERIODS.PERIOD_YEAR%TYPE;
315: L_PRIOR_PERIOD_YEAR AP_OTHER_PERIODS.PERIOD_YEAR%TYPE;
316: L_PERIOD_NUM AP_OTHER_PERIODS.PERIOD_NUM%TYPE;
317: L_PRIOR_PERIOD_NUM AP_OTHER_PERIODS.PERIOD_NUM%TYPE;
318: L_PRIOR_PERIOD_NAME AP_OTHER_PERIODS.PERIOD_NAME%TYPE;
319: L_PERIOD_TYPE AP_OTHER_PERIODS.PERIOD_TYPE%TYPE;
320: L_START_DATE AP_OTHER_PERIODS.START_DATE%TYPE;
321: L_PRIOR_START_DATE AP_OTHER_PERIODS.START_DATE%TYPE;
322: L_END_DATE AP_OTHER_PERIODS.END_DATE%TYPE;

Line 319: L_PERIOD_TYPE AP_OTHER_PERIODS.PERIOD_TYPE%TYPE;

315: L_PRIOR_PERIOD_YEAR AP_OTHER_PERIODS.PERIOD_YEAR%TYPE;
316: L_PERIOD_NUM AP_OTHER_PERIODS.PERIOD_NUM%TYPE;
317: L_PRIOR_PERIOD_NUM AP_OTHER_PERIODS.PERIOD_NUM%TYPE;
318: L_PRIOR_PERIOD_NAME AP_OTHER_PERIODS.PERIOD_NAME%TYPE;
319: L_PERIOD_TYPE AP_OTHER_PERIODS.PERIOD_TYPE%TYPE;
320: L_START_DATE AP_OTHER_PERIODS.START_DATE%TYPE;
321: L_PRIOR_START_DATE AP_OTHER_PERIODS.START_DATE%TYPE;
322: L_END_DATE AP_OTHER_PERIODS.END_DATE%TYPE;
323: L_PRIOR_END_DATE AP_OTHER_PERIODS.END_DATE%TYPE;

Line 320: L_START_DATE AP_OTHER_PERIODS.START_DATE%TYPE;

316: L_PERIOD_NUM AP_OTHER_PERIODS.PERIOD_NUM%TYPE;
317: L_PRIOR_PERIOD_NUM AP_OTHER_PERIODS.PERIOD_NUM%TYPE;
318: L_PRIOR_PERIOD_NAME AP_OTHER_PERIODS.PERIOD_NAME%TYPE;
319: L_PERIOD_TYPE AP_OTHER_PERIODS.PERIOD_TYPE%TYPE;
320: L_START_DATE AP_OTHER_PERIODS.START_DATE%TYPE;
321: L_PRIOR_START_DATE AP_OTHER_PERIODS.START_DATE%TYPE;
322: L_END_DATE AP_OTHER_PERIODS.END_DATE%TYPE;
323: L_PRIOR_END_DATE AP_OTHER_PERIODS.END_DATE%TYPE;
324: L_STATUS AP_OTHER_PERIODS.STATUS%TYPE;

Line 321: L_PRIOR_START_DATE AP_OTHER_PERIODS.START_DATE%TYPE;

317: L_PRIOR_PERIOD_NUM AP_OTHER_PERIODS.PERIOD_NUM%TYPE;
318: L_PRIOR_PERIOD_NAME AP_OTHER_PERIODS.PERIOD_NAME%TYPE;
319: L_PERIOD_TYPE AP_OTHER_PERIODS.PERIOD_TYPE%TYPE;
320: L_START_DATE AP_OTHER_PERIODS.START_DATE%TYPE;
321: L_PRIOR_START_DATE AP_OTHER_PERIODS.START_DATE%TYPE;
322: L_END_DATE AP_OTHER_PERIODS.END_DATE%TYPE;
323: L_PRIOR_END_DATE AP_OTHER_PERIODS.END_DATE%TYPE;
324: L_STATUS AP_OTHER_PERIODS.STATUS%TYPE;
325: PERIOD_NOT_DEFINED EXCEPTION;

Line 322: L_END_DATE AP_OTHER_PERIODS.END_DATE%TYPE;

318: L_PRIOR_PERIOD_NAME AP_OTHER_PERIODS.PERIOD_NAME%TYPE;
319: L_PERIOD_TYPE AP_OTHER_PERIODS.PERIOD_TYPE%TYPE;
320: L_START_DATE AP_OTHER_PERIODS.START_DATE%TYPE;
321: L_PRIOR_START_DATE AP_OTHER_PERIODS.START_DATE%TYPE;
322: L_END_DATE AP_OTHER_PERIODS.END_DATE%TYPE;
323: L_PRIOR_END_DATE AP_OTHER_PERIODS.END_DATE%TYPE;
324: L_STATUS AP_OTHER_PERIODS.STATUS%TYPE;
325: PERIOD_NOT_DEFINED EXCEPTION;
326: BEGIN

Line 323: L_PRIOR_END_DATE AP_OTHER_PERIODS.END_DATE%TYPE;

319: L_PERIOD_TYPE AP_OTHER_PERIODS.PERIOD_TYPE%TYPE;
320: L_START_DATE AP_OTHER_PERIODS.START_DATE%TYPE;
321: L_PRIOR_START_DATE AP_OTHER_PERIODS.START_DATE%TYPE;
322: L_END_DATE AP_OTHER_PERIODS.END_DATE%TYPE;
323: L_PRIOR_END_DATE AP_OTHER_PERIODS.END_DATE%TYPE;
324: L_STATUS AP_OTHER_PERIODS.STATUS%TYPE;
325: PERIOD_NOT_DEFINED EXCEPTION;
326: BEGIN
327: BEGIN

Line 324: L_STATUS AP_OTHER_PERIODS.STATUS%TYPE;

320: L_START_DATE AP_OTHER_PERIODS.START_DATE%TYPE;
321: L_PRIOR_START_DATE AP_OTHER_PERIODS.START_DATE%TYPE;
322: L_END_DATE AP_OTHER_PERIODS.END_DATE%TYPE;
323: L_PRIOR_END_DATE AP_OTHER_PERIODS.END_DATE%TYPE;
324: L_STATUS AP_OTHER_PERIODS.STATUS%TYPE;
325: PERIOD_NOT_DEFINED EXCEPTION;
326: BEGIN
327: BEGIN
328: SELECT

Line 337: AP_OTHER_PERIODS

333: END_DATE,
334: STATUS
335: INTO L_PERIOD_YEAR,L_PERIOD_NUM,L_PERIOD_TYPE,L_START_DATE,L_END_DATE,L_STATUS
336: FROM
337: AP_OTHER_PERIODS
338: WHERE ROWID = P_PERIOD_ROWID
339: AND MODULE = C_MODULE;
340: EXCEPTION
341: WHEN NO_DATA_FOUND THEN

Line 350: AP_OTHER_PERIODS

346: SELECT
347: MAX(PERIOD_NUM)
348: INTO L_PRIOR_PERIOD_NUM
349: FROM
350: AP_OTHER_PERIODS
351: WHERE PERIOD_TYPE = L_PERIOD_TYPE
352: AND PERIOD_YEAR = L_PRIOR_PERIOD_YEAR
353: AND MODULE = C_MODULE;
354: ELSE

Line 365: AP_OTHER_PERIODS

361: START_DATE,
362: END_DATE
363: INTO L_PRIOR_PERIOD_NAME,L_PRIOR_START_DATE,L_PRIOR_END_DATE
364: FROM
365: AP_OTHER_PERIODS
366: WHERE PERIOD_TYPE = L_PERIOD_TYPE
367: AND PERIOD_YEAR = L_PRIOR_PERIOD_YEAR
368: AND PERIOD_NUM = L_PRIOR_PERIOD_NUM
369: AND MODULE = C_MODULE;

Line 2219: AP_OTHER_PERIODS

2215: SELECT
2216: PERIOD_NAME
2217: INTO P_PERIOD_NAME
2218: FROM
2219: AP_OTHER_PERIODS
2220: WHERE ROWID = P_PERIOD_ROWID;
2221: RETURN (TRUE);
2222: END GET_PERIOD_NAME_FROM_ROWID;
2223: