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.FA_LEASE_SCHEDULE_PVT dependencies on FA_API_TYPES

Line 9: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS

5: -- CHECK FOR PAYMENT SCHEDULE NAME
6: -------------------------------------------
7: FUNCTION CHECK_PAYMENT_SCHEDULE (
8: P_PAYMENT_SCHEDULE_NAME IN FA_LEASE_SCHEDULES.PAYMENT_SCHEDULE_NAME%TYPE,
9: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS
10:
11: CURSOR C_PAYMENT_SCHEDULE_ID IS
12: SELECT PAYMENT_SCHEDULE_ID
13: FROM FA_LEASE_SCHEDULES

Line 52: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS

48: -- CHECK FOR CURRENCY CODE
49: -------------------------------------------
50: FUNCTION CHECK_CURRENCY_CODE(
51: P_CURRENCY_CODE IN FA_LEASE_SCHEDULES.CURRENCY_CODE%TYPE,
52: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS
53:
54: L_CURRENCY_CODE FA_LEASE_SCHEDULES.CURRENCY_CODE%TYPE;
55:
56: BEGIN

Line 85: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS

81: -- CHECK FOR LEASE FREQUENCY
82: -------------------------------------------
83: FUNCTION CHECK_LEASE_FREQUENCY(
84: P_FREQUENCY IN FA_LEASE_SCHEDULES.FREQUENCY%TYPE,
85: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS
86:
87: L_FRQUENCY VARCHAR2(15);
88:
89: BEGIN

Line 118: P_LEASE_PAYMENTS_TBL IN FA_API_TYPES.LEASE_PAYMENTS_TBL_TYPE,

114: -------------------------------------------
115: -- CHECK FOR START DATE
116: -------------------------------------------
117: FUNCTION CHECK_START_DATE (
118: P_LEASE_PAYMENTS_TBL IN FA_API_TYPES.LEASE_PAYMENTS_TBL_TYPE,
119: P_LEASE_INCEPTION_DATE IN DATE,
120: P_MONTHS_PER_PERIOD IN NUMBER,
121: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS
122: L_RETURN_FLAG BOOLEAN:=TRUE;

Line 121: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS

117: FUNCTION CHECK_START_DATE (
118: P_LEASE_PAYMENTS_TBL IN FA_API_TYPES.LEASE_PAYMENTS_TBL_TYPE,
119: P_LEASE_INCEPTION_DATE IN DATE,
120: P_MONTHS_PER_PERIOD IN NUMBER,
121: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS
122: L_RETURN_FLAG BOOLEAN:=TRUE;
123: BEGIN
124:
125: ------------------------------------------------------------

Line 178: P_LEASE_PAYMENTS_TBL IN FA_API_TYPES.LEASE_PAYMENTS_TBL_TYPE,

174: -------------------------------------------
175: -- CHECK FOR PAYMENT AMOUNT
176: -------------------------------------------
177: FUNCTION CHECK_PAYMENT_AMOUNT(
178: P_LEASE_PAYMENTS_TBL IN FA_API_TYPES.LEASE_PAYMENTS_TBL_TYPE,
179: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS
180: L_RETURN_FLAG BOOLEAN:=TRUE;
181: BEGIN
182: ------------------------------------------------------------

Line 179: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS

175: -- CHECK FOR PAYMENT AMOUNT
176: -------------------------------------------
177: FUNCTION CHECK_PAYMENT_AMOUNT(
178: P_LEASE_PAYMENTS_TBL IN FA_API_TYPES.LEASE_PAYMENTS_TBL_TYPE,
179: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS
180: L_RETURN_FLAG BOOLEAN:=TRUE;
181: BEGIN
182: ------------------------------------------------------------
183: -- PAYMENT AMOUNT CAN NOT BE NULL

Line 208: P_LEASE_PAYMENTS_TBL IN FA_API_TYPES.LEASE_PAYMENTS_TBL_TYPE,

204: -------------------------------------------
205: -- CHECK FOR NUMBER OF PAYMENTS
206: -------------------------------------------
207: FUNCTION CHECK_NO_OF_PAYMENTS (
208: P_LEASE_PAYMENTS_TBL IN FA_API_TYPES.LEASE_PAYMENTS_TBL_TYPE,
209: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS
210:
211: L_RETURN_FLAG BOOLEAN:=TRUE;
212:

Line 209: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS

205: -- CHECK FOR NUMBER OF PAYMENTS
206: -------------------------------------------
207: FUNCTION CHECK_NO_OF_PAYMENTS (
208: P_LEASE_PAYMENTS_TBL IN FA_API_TYPES.LEASE_PAYMENTS_TBL_TYPE,
209: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS
210:
211: L_RETURN_FLAG BOOLEAN:=TRUE;
212:
213: BEGIN

Line 247: P_LEASE_PAYMENTS_TBL IN FA_API_TYPES.LEASE_PAYMENTS_TBL_TYPE,

243: -------------------------------------------
244: -- CHECK FOR LEASE PAYMENT TYPE
245: -------------------------------------------
246: FUNCTION CHECK_PERIODS (
247: P_LEASE_PAYMENTS_TBL IN FA_API_TYPES.LEASE_PAYMENTS_TBL_TYPE,
248: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS
249:
250: L_RETURN_FLAG BOOLEAN:=TRUE;
251: L_PERIOD VARCHAR2(1);

Line 248: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS

244: -- CHECK FOR LEASE PAYMENT TYPE
245: -------------------------------------------
246: FUNCTION CHECK_PERIODS (
247: P_LEASE_PAYMENTS_TBL IN FA_API_TYPES.LEASE_PAYMENTS_TBL_TYPE,
248: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS
249:
250: L_RETURN_FLAG BOOLEAN:=TRUE;
251: L_PERIOD VARCHAR2(1);
252:

Line 296: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN DATE AS

292: FUNCTION CALC_END_DATE (
293: P_NUMBER_OF_PAYMENTS IN NUMBER,
294: P_MONTHS_PER_PERIOD IN NUMBER,
295: P_START_DATE IN DATE,
296: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN DATE AS
297: L_MONTHS_IN_LEASE INTEGER;
298: L_END_DATE DATE;
299: BEGIN
300: ------------------------------------------------------------

Line 323: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS

319: (P_PAYMENT_SCHEDULE_ID IN NUMBER,
320: X_MONTHS_PER_PERIOD OUT NOCOPY NUMBER,
321: X_CURRENCY_PRECISION OUT NOCOPY NUMBER,
322: X_PERIODS_PER_YEAR OUT NOCOPY NUMBER ,
323: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN AS
324:
325: CURSOR C1 IS
326: SELECT FREQUENCY,CURRENCY_CODE
327: FROM FA_LEASE_SCHEDULES

Line 388: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

384: FUNCTION CALCULATE_INTEREST
385: (P_PRINCIPAL IN NUMBER,
386: P_RATE_PER_PERIOD IN NUMBER,
387: P_NUM_PERIODS IN NUMBER,
388: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
389: RETURN NUMBER IS
390: INTEREST_AMOUNT NUMBER := 0;
391: RATE_FACTOR NUMBER := 0;
392: BEGIN

Line 421: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

417: -------------------------------------------
418: FUNCTION AMINIMUM2
419: (P_X NUMBER,
420: P_Y NUMBER,
421: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
422: RETURN NUMBER IS
423: MIN_NUMBER NUMBER;
424: BEGIN
425:

Line 452: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

448: FUNCTION AMINIMUM3
449: (P_X NUMBER,
450: P_Y NUMBER,
451: P_Z NUMBER,
452: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
453: RETURN NUMBER IS
454: MIN_NUMBER NUMBER;
455: BEGIN
456: --------------------------------------------------------------

Line 489: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

485: (P_PAYMENT_AMOUNT IN NUMBER,
486: P_NUMBER_PAYMENTS IN NUMBER,
487: P_INTEREST_RATE IN NUMBER,
488: P_CURRENCY_PRECISION IN NUMBER,
489: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
490: RETURN NUMBER IS
491: H_ROW_PV NUMBER := 0;
492: H_DENOMINATOR NUMBER := 0;
493: BEGIN

Line 524: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN NUMBER IS

520: (P_PAYMENT_AMOUNT IN NUMBER,
521: P_NUMBER_PAYMENTS IN NUMBER,
522: P_INTEREST_RATE IN NUMBER,
523: P_CURRENCY_PRECISION IN NUMBER,
524: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN NUMBER IS
525: H_ROW_PV NUMBER := 0 ;
526: H_NUMERATOR NUMBER := 0 ;
527: H_DENOMINATOR NUMBER := 0 ;
528: H_SUBDENOMINATOR NUMBER := 0 ;

Line 566: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN NUMBER IS

562: FUNCTION ANNUITY_DUE (P_PAYMENT_AMOUNT IN NUMBER,
563: P_NUMBER_PAYMENTS IN NUMBER,
564: P_INTEREST_RATE IN NUMBER,
565: P_CURRENCY_PRECISION IN NUMBER,
566: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN NUMBER IS
567: H_ROW_PV NUMBER := 0 ;
568: H_NUMERATOR NUMBER := 0 ;
569: H_DENOMINATOR NUMBER := 0 ;
570: H_SUBDENOMINATOR NUMBER := 0 ;

Line 610: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

606: (P_PAYMENT_SCHEDULE_ID IN NUMBER
607: ,P_MONTHS_PER_PERIOD IN NUMBER
608: ,P_INTEREST_PER_PERIOD IN NUMBER
609: ,P_CURRENCY_PRECISION IN NUMBER,
610: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
611: IS
612: CURSOR C_SCHEDULE IS
613: SELECT LEASE_INCEPTION_DATE,PRESENT_VALUE
614: FROM FA_LEASE_SCHEDULES

Line 734: PX_LEASE_SCHEDULES_REC IN OUT NOCOPY FA_API_TYPES.LEASE_SCHEDULES_REC_TYPE,

730: -- VALIDATE ALL THE SUPPLIED DATA
731: ------------------------------------------------------------
732:
733: FUNCTION VALIDATE_PAYMENTS (
734: PX_LEASE_SCHEDULES_REC IN OUT NOCOPY FA_API_TYPES.LEASE_SCHEDULES_REC_TYPE,
735: P_LEASE_PAYMENTS_TBL IN FA_API_TYPES.LEASE_PAYMENTS_TBL_TYPE,
736: P_MONTHS_PER_PERIOD OUT NOCOPY NUMBER,
737: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
738: RETURN BOOLEAN IS

Line 735: P_LEASE_PAYMENTS_TBL IN FA_API_TYPES.LEASE_PAYMENTS_TBL_TYPE,

731: ------------------------------------------------------------
732:
733: FUNCTION VALIDATE_PAYMENTS (
734: PX_LEASE_SCHEDULES_REC IN OUT NOCOPY FA_API_TYPES.LEASE_SCHEDULES_REC_TYPE,
735: P_LEASE_PAYMENTS_TBL IN FA_API_TYPES.LEASE_PAYMENTS_TBL_TYPE,
736: P_MONTHS_PER_PERIOD OUT NOCOPY NUMBER,
737: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
738: RETURN BOOLEAN IS
739: VALUE_ERROR_EXCEPTION EXCEPTION;

Line 737: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

733: FUNCTION VALIDATE_PAYMENTS (
734: PX_LEASE_SCHEDULES_REC IN OUT NOCOPY FA_API_TYPES.LEASE_SCHEDULES_REC_TYPE,
735: P_LEASE_PAYMENTS_TBL IN FA_API_TYPES.LEASE_PAYMENTS_TBL_TYPE,
736: P_MONTHS_PER_PERIOD OUT NOCOPY NUMBER,
737: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
738: RETURN BOOLEAN IS
739: VALUE_ERROR_EXCEPTION EXCEPTION;
740: L_MONTHS_PER_PERIOD NUMBER;
741: L_PERIODS_PER_YEAR NUMBER;

Line 918: P_TRANS_REC IN FA_API_TYPES.TRANS_REC_TYPE,

914: END VALIDATE_PAYMENTS;
915:
916: FUNCTION AMORTIZE(
917: P_PAYMENT_SCHEDULE_ID IN NUMBER,
918: P_TRANS_REC IN FA_API_TYPES.TRANS_REC_TYPE,
919: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
920: RETURN BOOLEAN IS
921:
922: VALUE_ERROR_EXCEPTION EXCEPTION;

Line 919: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

915:
916: FUNCTION AMORTIZE(
917: P_PAYMENT_SCHEDULE_ID IN NUMBER,
918: P_TRANS_REC IN FA_API_TYPES.TRANS_REC_TYPE,
919: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
920: RETURN BOOLEAN IS
921:
922: VALUE_ERROR_EXCEPTION EXCEPTION;
923: L_MONTHS_PER_PERIOD NUMBER:=NULL;