[Home] [Help]
71:
72: ----------------------------------------------------
73: -- EVERYTHING LOOKS OK LET'S INSERT THIS ROW
74: ----------------------------------------------------
75: SELECT FA_LEASE_SCHEDULES_S.NEXTVAL
76: INTO
77: L_PAYMENT_SCHEDULE_ID
78: FROM DUAL;
79:
81: THEN
82: FA_DEBUG_PKG.ADD('FA_LEASE_SCHEDULE_PUB', 'PAYMENT_SCHEDULE_ID', L_PAYMENT_SCHEDULE_ID, p_log_level_rec => g_log_level_rec);
83: END IF;
84:
85: INSERT INTO FA_LEASE_SCHEDULES
86: (PAYMENT_SCHEDULE_ID
87: ,PAYMENT_SCHEDULE_NAME
88: ,PRESENT_VALUE
89: ,INTEREST_RATE