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.XTR_XTRTMSTM_XMLP_PKG dependencies on DUAL

Line 11: 'SELECT DECODE(:REFERENCE,''INCRSE'',''Princ. Incr'',''Repayment'') INTO :REF_TYPE FROM DUAL';

7:
8: FUNCTION REF_TYPE1FORMULA(REFERENCE varchar2) RETURN VARCHAR2 IS
9: BEGIN
10: /*EXECUTE IMMEDIATE
11: 'SELECT DECODE(:REFERENCE,''INCRSE'',''Princ. Incr'',''Repayment'') INTO :REF_TYPE FROM DUAL';
12: COMMIT;*/
13: SELECT DECODE(REFERENCE,'INCRSE','Princ. Incr','Repayment') INTO REF_TYPE FROM DUAL;
14: RETURN ('');
15: END REF_TYPE1FORMULA;

Line 13: SELECT DECODE(REFERENCE,'INCRSE','Princ. Incr','Repayment') INTO REF_TYPE FROM DUAL;

9: BEGIN
10: /*EXECUTE IMMEDIATE
11: 'SELECT DECODE(:REFERENCE,''INCRSE'',''Princ. Incr'',''Repayment'') INTO :REF_TYPE FROM DUAL';
12: COMMIT;*/
13: SELECT DECODE(REFERENCE,'INCRSE','Princ. Incr','Repayment') INTO REF_TYPE FROM DUAL;
14: RETURN ('');
15: END REF_TYPE1FORMULA;
16:
17: FUNCTION REF_TYPEFORMULA RETURN VARCHAR2 IS

Line 25: 'SELECT DECODE(:REFERENCE,''DEDUCTION'',:ADJUST_PRINCIPAL,0) INTO :PRIN_DED FROM DUAL';

21:
22: FUNCTION PRIN_DED1FORMULA(REFERENCE varchar2, ADJUST_PRINCIPAL number) RETURN VARCHAR2 IS
23: BEGIN
24: /*EXECUTE IMMEDIATE
25: 'SELECT DECODE(:REFERENCE,''DEDUCTION'',:ADJUST_PRINCIPAL,0) INTO :PRIN_DED FROM DUAL';
26: COMMIT;*/
27: SELECT DECODE(REFERENCE,'DEDUCTION',ADJUST_PRINCIPAL,0) INTO PRIN_DED FROM DUAL;
28: RETURN ('');
29: END PRIN_DED1FORMULA;

Line 27: SELECT DECODE(REFERENCE,'DEDUCTION',ADJUST_PRINCIPAL,0) INTO PRIN_DED FROM DUAL;

23: BEGIN
24: /*EXECUTE IMMEDIATE
25: 'SELECT DECODE(:REFERENCE,''DEDUCTION'',:ADJUST_PRINCIPAL,0) INTO :PRIN_DED FROM DUAL';
26: COMMIT;*/
27: SELECT DECODE(REFERENCE,'DEDUCTION',ADJUST_PRINCIPAL,0) INTO PRIN_DED FROM DUAL;
28: RETURN ('');
29: END PRIN_DED1FORMULA;
30:
31: FUNCTION PRIN_DEDFORMULA RETURN NUMBER IS

Line 39: 'SELECT (nvl(:ADJUST_INTEREST,0) + nvl(:ADJUST_PRIN,0)) INTO :PI_RECD FROM DUAL';

35:
36: FUNCTION PI_RECD1FORMULA(ADJUST_INTEREST number, ADJUST_PRIN number) RETURN VARCHAR2 IS
37: BEGIN
38: /*EXECUTE IMMEDIATE
39: 'SELECT (nvl(:ADJUST_INTEREST,0) + nvl(:ADJUST_PRIN,0)) INTO :PI_RECD FROM DUAL';
40: COMMIT;*/
41: SELECT (nvl(ADJUST_INTEREST,0) + nvl(ADJUST_PRIN,0)) INTO PI_RECD FROM DUAL;
42: RETURN ('');
43: END PI_RECD1FORMULA;

Line 41: SELECT (nvl(ADJUST_INTEREST,0) + nvl(ADJUST_PRIN,0)) INTO PI_RECD FROM DUAL;

37: BEGIN
38: /*EXECUTE IMMEDIATE
39: 'SELECT (nvl(:ADJUST_INTEREST,0) + nvl(:ADJUST_PRIN,0)) INTO :PI_RECD FROM DUAL';
40: COMMIT;*/
41: SELECT (nvl(ADJUST_INTEREST,0) + nvl(ADJUST_PRIN,0)) INTO PI_RECD FROM DUAL;
42: RETURN ('');
43: END PI_RECD1FORMULA;
44:
45: FUNCTION PI_RECDFORMULA RETURN NUMBER IS

Line 53: 'SELECT DECODE(:REFERENCE,''DEDUCTION'',:ADJUST_PRINCIPAL,:ADJUST_PRINCIPAL) INTO :ADJUST_PRIN FROM DUAL';

49:
50: FUNCTION ADJUST_PRIN1FORMULA(REFERENCE varchar2, ADJUST_PRINCIPAL number) RETURN VARCHAR2 IS
51: BEGIN
52: /*EXECUTE IMMEDIATE
53: 'SELECT DECODE(:REFERENCE,''DEDUCTION'',:ADJUST_PRINCIPAL,:ADJUST_PRINCIPAL) INTO :ADJUST_PRIN FROM DUAL';
54: COMMIT;*/
55: SELECT DECODE(REFERENCE,'DEDUCTION',ADJUST_PRINCIPAL,ADJUST_PRINCIPAL) INTO ADJUST_PRIN FROM DUAL;
56: RETURN to_char(ADJUST_PRIN);
57: END ADJUST_PRIN1FORMULA;

Line 55: SELECT DECODE(REFERENCE,'DEDUCTION',ADJUST_PRINCIPAL,ADJUST_PRINCIPAL) INTO ADJUST_PRIN FROM DUAL;

51: BEGIN
52: /*EXECUTE IMMEDIATE
53: 'SELECT DECODE(:REFERENCE,''DEDUCTION'',:ADJUST_PRINCIPAL,:ADJUST_PRINCIPAL) INTO :ADJUST_PRIN FROM DUAL';
54: COMMIT;*/
55: SELECT DECODE(REFERENCE,'DEDUCTION',ADJUST_PRINCIPAL,ADJUST_PRINCIPAL) INTO ADJUST_PRIN FROM DUAL;
56: RETURN to_char(ADJUST_PRIN);
57: END ADJUST_PRIN1FORMULA;
58:
59: FUNCTION ADJUST_PRINFORMULA RETURN NUMBER IS

Line 67: 'SELECT DECODE(:REFERENCE,''INCRSE'',:BALANCE_CFWD - NVL(:PRIN_DECRSE,0),:BALANCE_CFWD) INTO :ACTUAL_BAL FROM DUAL';

63:
64: FUNCTION ACTUAL_BAL1FORMULA(REFERENCE varchar2, BALANCE_CFWD number, PRIN_DECRSE number) RETURN VARCHAR2 IS
65: BEGIN
66: /*EXECUTE IMMEDIATE
67: 'SELECT DECODE(:REFERENCE,''INCRSE'',:BALANCE_CFWD - NVL(:PRIN_DECRSE,0),:BALANCE_CFWD) INTO :ACTUAL_BAL FROM DUAL';
68: COMMIT;*/
69: SELECT DECODE(REFERENCE,'INCRSE',BALANCE_CFWD - NVL(PRIN_DECRSE,0),BALANCE_CFWD) INTO ACTUAL_BAL FROM DUAL;
70: RETURN to_char(ACTUAL_BAL);
71: END ACTUAL_BAL1FORMULA;

Line 69: SELECT DECODE(REFERENCE,'INCRSE',BALANCE_CFWD - NVL(PRIN_DECRSE,0),BALANCE_CFWD) INTO ACTUAL_BAL FROM DUAL;

65: BEGIN
66: /*EXECUTE IMMEDIATE
67: 'SELECT DECODE(:REFERENCE,''INCRSE'',:BALANCE_CFWD - NVL(:PRIN_DECRSE,0),:BALANCE_CFWD) INTO :ACTUAL_BAL FROM DUAL';
68: COMMIT;*/
69: SELECT DECODE(REFERENCE,'INCRSE',BALANCE_CFWD - NVL(PRIN_DECRSE,0),BALANCE_CFWD) INTO ACTUAL_BAL FROM DUAL;
70: RETURN to_char(ACTUAL_BAL);
71: END ACTUAL_BAL1FORMULA;
72:
73: FUNCTION ACTUAL_BALFORMULA RETURN NUMBER IS

Line 86: 'SELECT nvl(:INTEREST_DUE,0) + nvl(:BALANCE_DUE,0) INTO :NET_DUE from DUAL';

82:
83: FUNCTION NET_DUE1FORMULA(INTEREST_DUE number, BALANCE_DUE number) RETURN VARCHAR2 IS
84: BEGIN
85: /*EXECUTE IMMEDIATE
86: 'SELECT nvl(:INTEREST_DUE,0) + nvl(:BALANCE_DUE,0) INTO :NET_DUE from DUAL';
87: COMMIT;*/
88: SELECT nvl(INTEREST_DUE,0) + nvl(BALANCE_DUE,0) INTO NET_DUE from DUAL;
89: RETURN ('');
90: END NET_DUE1FORMULA;

Line 88: SELECT nvl(INTEREST_DUE,0) + nvl(BALANCE_DUE,0) INTO NET_DUE from DUAL;

84: BEGIN
85: /*EXECUTE IMMEDIATE
86: 'SELECT nvl(:INTEREST_DUE,0) + nvl(:BALANCE_DUE,0) INTO :NET_DUE from DUAL';
87: COMMIT;*/
88: SELECT nvl(INTEREST_DUE,0) + nvl(BALANCE_DUE,0) INTO NET_DUE from DUAL;
89: RETURN ('');
90: END NET_DUE1FORMULA;
91:
92: FUNCTION NET_DUEFORMULA RETURN NUMBER IS

Line 113: DUAL;

109: ,10)
110: INTO
111: CP_PARA
112: FROM
113: DUAL;
114: RETURN (CP_PARA);
115: END CF_SET_PARAFORMULA;
116:
117: FUNCTION BEFOREREPORT RETURN BOOLEAN IS