APPS.FA_LEASE_SCHEDULE_PVT dependencies on FA_LEASE_SCHEDULES

Line 8: P_PAYMENT_SCHEDULE_NAME IN FA_LEASE_SCHEDULES.PAYMENT_SCHEDULE_NAME%TYPE,

4: -------------------------------------------
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

Line 13: FROM FA_LEASE_SCHEDULES

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
14: WHERE PAYMENT_SCHEDULE_NAME = P_PAYMENT_SCHEDULE_NAME;
15:
16: L_PAYMENT_SCHEDULE_ID NUMBER;
17: PAYMENT_SCHEDULE_FOUND EXCEPTION;

Line 51: P_CURRENCY_CODE IN FA_LEASE_SCHEDULES.CURRENCY_CODE%TYPE,

47: -------------------------------------------
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:

Line 54: L_CURRENCY_CODE FA_LEASE_SCHEDULES.CURRENCY_CODE%TYPE;

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
57: -------------------------------------------
58: -- CHECK IF CURRENCY CODE IS VALID

Line 84: P_FREQUENCY IN FA_LEASE_SCHEDULES.FREQUENCY%TYPE,

80: -------------------------------------------
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:

Line 327: FROM FA_LEASE_SCHEDULES

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
328: WHERE PAYMENT_SCHEDULE_ID = P_PAYMENT_SCHEDULE_ID;
329:
330: C1_NOT_FOUND EXCEPTION;
331: PAYMENTS_NOT_FOUND EXCEPTION;

Line 614: FROM FA_LEASE_SCHEDULES

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
615: WHERE PAYMENT_SCHEDULE_ID = P_PAYMENT_SCHEDULE_ID
616: FOR UPDATE OF PRESENT_VALUE;
617:
618: CURSOR C_PAYMENT IS

Line 718: UPDATE FA_LEASE_SCHEDULES

714: WHERE CURRENT OF C_PAYMENT;
715: L_TOTAL_ROW_PRESENT_VALUE := L_TOTAL_ROW_PRESENT_VALUE + L_ROW_PRESENT_VALUE;
716:
717: END LOOP;
718: UPDATE FA_LEASE_SCHEDULES
719: SET PRESENT_VALUE = L_TOTAL_ROW_PRESENT_VALUE
720: WHERE CURRENT OF C_SCHEDULE;
721: END LOOP;
722:

Line 1063: FROM FA_LEASE_SCHEDULES

1059: INTO
1060: L_INTEREST_RATE
1061: ,L_LEASE_INCEPTION_DATE
1062: ,L_PRESENT_VALUE
1063: FROM FA_LEASE_SCHEDULES
1064: WHERE PAYMENT_SCHEDULE_ID=P_PAYMENT_SCHEDULE_ID;
1065:
1066: L_INTEREST_PER_PERIOD := (L_INTEREST_RATE/100) / L_PERIODS_PER_YEAR;
1067: