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.3 2009/03/27 03:49:07 bridgway ship $ */
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 28: INSERT INTO FA_Lease_Payment_Items(

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

Line 79: FA_LEASE_PAYMENT_ITEMS.*/

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

Line 103: UPDATE FA_Lease_Payment_Items SET

99: X_Request_ID IN NUMBER := NULL , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
100:
101: BEGIN
102:
103: UPDATE FA_Lease_Payment_Items SET
104:
105: Lease_ID = X_Lease_ID,
106: Payment_Schedule_ID = X_Payment_Schedule_ID,
107: Schedule_Amort_Line_Num = X_Schedule_Amort_Line_Num,

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

131: CALLING_FN => 'FA_LEASE_PITEMS_PKG.Update_Row', p_log_level_rec => p_log_level_rec);
132:
133: END Update_Row;
134:
135: /* Procedure Lock_Rows() locks all rows in FA_LEASE_PAYMENT_ITEMS
136: associated with the specified lease.*/
137: PROCEDURE Lock_Rows(
138: X_Lease_ID IN NUMBER, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
139:

Line 143: FROM FA_LEASE_PAYMENT_ITEMS

139:
140: CURSOR payitems IS
141:
142: SELECT *
143: FROM FA_LEASE_PAYMENT_ITEMS
144: WHERE Lease_ID = X_Lease_ID
145: FOR UPDATE NOWAIT;
146:
147: V_Rowdata payitems%ROWTYPE;

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

155: CLOSE payitems;
156:
157: END Lock_Rows;
158:
159: /* Procedure Delete_Rows() deletes all rows in FA_LEASE_PAYMENT_ITEMS
160: associated with the specified lease.*/
161: PROCEDURE Delete_Rows(
162:
163: X_Lease_ID IN NUMBER, p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS

Line 168: DELETE FROM FA_LEASE_PAYMENT_ITEMS

164:
165: BEGIN
166:
167:
168: DELETE FROM FA_LEASE_PAYMENT_ITEMS
169: WHERE Lease_ID = X_Lease_ID;
170:
171: END Delete_Rows;
172:

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

170:
171: END Delete_Rows;
172:
173: /* Procedure Payments_Itemize() will create payment items for a lease.
174: New rows will be inserted into table FA_LEASE_PAYMENT_ITEMS. It will
175: be called after a user associates a schedule with a lease. A user
176: can also sumbit a concurrent program to run it to create payment
177: items for existing leases. */
178: FUNCTION Payments_Itemize (

Line 237: -- insert rows into FA_LEASE_PAYMENT_ITEMS table

233: END IF;
234:
235: V_Terms_ID := P_Terms_ID;
236:
237: -- insert rows into FA_LEASE_PAYMENT_ITEMS table
238: FOR current_item IN payment_items LOOP
239:
240: --create an informative invoice number
241: V_Invoice_Number := 'FA-'||V_Lease_Number||'-'||current_item.Amort_Line_Num;