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
10: ) RETURN BOOLEAN AS
11:
12: CURSOR C_PAYMENT_SCHEDULE_ID IS

Line 14: FROM FA_LEASE_SCHEDULES

10: ) RETURN BOOLEAN AS
11:
12: CURSOR C_PAYMENT_SCHEDULE_ID IS
13: SELECT PAYMENT_SCHEDULE_ID
14: FROM FA_LEASE_SCHEDULES
15: WHERE PAYMENT_SCHEDULE_NAME = P_PAYMENT_SCHEDULE_NAME;
16:
17: L_PAYMENT_SCHEDULE_ID NUMBER;
18: 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
53: ) RETURN BOOLEAN AS
54:
55: L_CURRENCY_CODE FA_LEASE_SCHEDULES.CURRENCY_CODE%TYPE;

Line 55: L_CURRENCY_CODE FA_LEASE_SCHEDULES.CURRENCY_CODE%TYPE;

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
53: ) RETURN BOOLEAN AS
54:
55: L_CURRENCY_CODE FA_LEASE_SCHEDULES.CURRENCY_CODE%TYPE;
56:
57: BEGIN
58: -------------------------------------------
59: -- 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
86: ) RETURN BOOLEAN AS
87:
88: L_FRQUENCY VARCHAR2(15);

Line 322: FROM FA_LEASE_SCHEDULES

318: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN AS
319:
320: CURSOR C1 IS
321: SELECT FREQUENCY,CURRENCY_CODE
322: FROM FA_LEASE_SCHEDULES
323: WHERE PAYMENT_SCHEDULE_ID = P_PAYMENT_SCHEDULE_ID;
324:
325: C1_NOT_FOUND EXCEPTION;
326: PAYMENTS_NOT_FOUND EXCEPTION;

Line 595: FROM FA_LEASE_SCHEDULES

591: ,P_CURRENCY_PRECISION IN NUMBER, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
592: IS
593: CURSOR C_SCHEDULE IS
594: SELECT LEASE_INCEPTION_DATE,PRESENT_VALUE
595: FROM FA_LEASE_SCHEDULES
596: WHERE PAYMENT_SCHEDULE_ID = P_PAYMENT_SCHEDULE_ID
597: FOR UPDATE OF PRESENT_VALUE;
598:
599: CURSOR C_PAYMENT IS

Line 699: UPDATE FA_LEASE_SCHEDULES

695: WHERE CURRENT OF C_PAYMENT;
696: L_TOTAL_ROW_PRESENT_VALUE := L_TOTAL_ROW_PRESENT_VALUE + L_ROW_PRESENT_VALUE;
697:
698: END LOOP;
699: UPDATE FA_LEASE_SCHEDULES
700: SET PRESENT_VALUE = L_TOTAL_ROW_PRESENT_VALUE
701: WHERE CURRENT OF C_SCHEDULE;
702: END LOOP;
703:

Line 1040: FROM FA_LEASE_SCHEDULES

1036: INTO
1037: L_INTEREST_RATE
1038: ,L_LEASE_INCEPTION_DATE
1039: ,L_PRESENT_VALUE
1040: FROM FA_LEASE_SCHEDULES
1041: WHERE PAYMENT_SCHEDULE_ID=P_PAYMENT_SCHEDULE_ID;
1042:
1043: L_INTEREST_PER_PERIOD := (L_INTEREST_RATE/100) / L_PERIODS_PER_YEAR;
1044: