APPS.FA_LEASE_PITEMS_PKG dependencies on FA_LEASE_PAYMENT_ITEMS

Line 5: FA_LEASE_PAYMENT_ITEMS.*/

1: PACKAGE BODY FA_LEASE_PITEMS_PKG AS
2: /* $Header: FAXLPIEB.pls 120.2 2005/07/28 00:19:42 tkawamur noship $ */
3:
4: /* This is a wrapper procedure for inserting a row into table
5: FA_LEASE_PAYMENT_ITEMS.*/
6: PROCEDURE Insert_Row(
7:
8: X_Lease_ID IN NUMBER,
9: X_Payment_Schedule_ID IN NUMBER,

Line 29: INSERT INTO FA_Lease_Payment_Items(

25: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
26:
27: BEGIN
28:
29: INSERT INTO FA_Lease_Payment_Items(
30:
31: Lease_ID,
32: Payment_Schedule_ID,
33: Schedule_Amort_Line_Num,

Line 81: FA_LEASE_PAYMENT_ITEMS.*/

77:
78: END Insert_Row;
79:
80: /* This is a wrapper procedure for updating a row of table
81: FA_LEASE_PAYMENT_ITEMS.*/
82: PROCEDURE Update_Row(
83:
84: X_Rowid IN VARCHAR2,
85: X_Lease_ID IN NUMBER,

Line 106: UPDATE FA_Lease_Payment_Items SET

102: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
103:
104: BEGIN
105:
106: UPDATE FA_Lease_Payment_Items SET
107:
108: Lease_ID = X_Lease_ID,
109: Payment_Schedule_ID = X_Payment_Schedule_ID,
110: Schedule_Amort_Line_Num = X_Schedule_Amort_Line_Num,

Line 139: /* Procedure Lock_Rows() locks all rows in FA_LEASE_PAYMENT_ITEMS

135: ,p_log_level_rec => p_log_level_rec);
136:
137: END Update_Row;
138:
139: /* Procedure Lock_Rows() locks all rows in FA_LEASE_PAYMENT_ITEMS
140: associated with the specified lease.*/
141: PROCEDURE Lock_Rows(
142: X_Lease_ID IN NUMBER,
143: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS

Line 148: FROM FA_LEASE_PAYMENT_ITEMS

144:
145: CURSOR payitems IS
146:
147: SELECT *
148: FROM FA_LEASE_PAYMENT_ITEMS
149: WHERE Lease_ID = X_Lease_ID
150: FOR UPDATE NOWAIT;
151:
152: V_Rowdata payitems%ROWTYPE;

Line 164: /* Procedure Delete_Rows() deletes all rows in FA_LEASE_PAYMENT_ITEMS

160: CLOSE payitems;
161:
162: END Lock_Rows;
163:
164: /* Procedure Delete_Rows() deletes all rows in FA_LEASE_PAYMENT_ITEMS
165: associated with the specified lease.*/
166: PROCEDURE Delete_Rows(
167:
168: X_Lease_ID IN NUMBER,

Line 174: DELETE FROM FA_LEASE_PAYMENT_ITEMS

170:
171: BEGIN
172:
173:
174: DELETE FROM FA_LEASE_PAYMENT_ITEMS
175: WHERE Lease_ID = X_Lease_ID;
176:
177: END Delete_Rows;
178:

Line 180: New rows will be inserted into table FA_LEASE_PAYMENT_ITEMS. It will

176:
177: END Delete_Rows;
178:
179: /* Procedure Payments_Itemize() will create payment items for a lease.
180: New rows will be inserted into table FA_LEASE_PAYMENT_ITEMS. It will
181: be called after a user associates a schedule with a lease. A user
182: can also sumbit a concurrent program to run it to create payment
183: items for existing leases. */
184: FUNCTION Payments_Itemize (

Line 244: -- insert rows into FA_LEASE_PAYMENT_ITEMS table

240: END IF;
241:
242: V_Terms_ID := P_Terms_ID;
243:
244: -- insert rows into FA_LEASE_PAYMENT_ITEMS table
245: FOR current_item IN payment_items LOOP
246:
247: --create an informative invoice number
248: V_Invoice_Number := 'FA-'||V_Lease_Number||'-'||current_item.Amort_Line_Num;