1 PACKAGE FA_LEASE_PITEMS_PKG AUTHID CURRENT_USER AS
2 /* $Header: FAXLPIES.pls 120.2 2009/03/27 03:50:41 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,
10 X_Schedule_Amort_Line_Num IN NUMBER,
11 X_Export_Status IN VARCHAR2,
12 X_Lessor_ID IN NUMBER,
13 X_Lessor_Site_ID IN NUMBER,
14 X_Dist_Code_Combination_ID IN NUMBER,
15 X_Invoice_Number IN VARCHAR2,
16 X_Invoice_ID IN NUMBER,
17 X_Invoice_Line_ID IN NUMBER,
18 X_Terms_ID IN NUMBER,
19 X_Last_Updated_by IN NUMBER,
20 X_Last_Update_Date IN DATE,
21 X_Last_Update_Login IN NUMBER,
22 X_Created_by IN NUMBER,
23 X_Creation_Date IN DATE,
24 X_Request_ID IN NUMBER, p_log_level_rec IN FA_API_TYPES.log_level_rec_type);
25
26 /* This is a wrapper procedure for updating a row of table
27 FA_LEASE_PAYMENT_ITEMS.*/
28 PROCEDURE Update_Row(
29
30 X_Rowid IN VARCHAR2,
31 X_Lease_ID IN NUMBER,
32 X_Payment_Schedule_ID IN NUMBER,
33 X_Schedule_Amort_Line_Num IN NUMBER,
34 X_Export_Status IN VARCHAR2,
35 X_Lessor_ID IN NUMBER,
36 X_Lessor_Site_ID IN NUMBER,
37 X_Dist_Code_Combination_ID IN NUMBER,
38 X_Invoice_Number IN VARCHAR2,
39 X_Invoice_ID IN NUMBER,
40 X_Invoice_Line_ID IN NUMBER,
41 X_Terms_ID IN NUMBER,
42 X_Last_Updated_by IN NUMBER,
43 X_Last_Update_Date IN DATE,
44 X_Last_Update_Login IN NUMBER,
45 X_Created_by IN NUMBER,
46 X_Creation_Date IN DATE,
47 X_Request_ID IN NUMBER := NULL, p_log_level_rec IN FA_API_TYPES.log_level_rec_type);
48
49 /* Procedure Lock_Rows() locks all rows in FA_LEASE_PAYMENT_ITEMS
50 associated with the specified lease.*/
51 PROCEDURE Lock_Rows(
52 X_Lease_ID IN NUMBER, p_log_level_rec IN FA_API_TYPES.log_level_rec_type);
53
54 /* Procedure Delete_Rows() deletes all rows in FA_LEASE_PAYMENT_ITEMS
55 associated with the specified lease.*/
56 PROCEDURE Delete_Rows(
57 X_Lease_ID IN NUMBER, p_log_level_rec IN FA_API_TYPES.log_level_rec_type);
58
59 /* Function Payments_Itemize() will create payment items for a lease.
60 New rows will be inserted into table FA_LEASE_PAYMENT_ITEMS. It will
61 be called after a user associates a schedule with a lease. A user
62 can also sumbit a concurrent program to run it to create payment
63 items for existing leases. */
64 FUNCTION Payments_Itemize (
65
66 P_Lease_ID IN NUMBER,
67 P_Payment_Schedule_ID IN NUMBER,
68 P_Lessor_ID IN NUMBER,
69 P_Lessor_Site_ID IN NUMBER := NULL,
70 P_Dist_Code_Combination_ID IN NUMBER := NULL,
71 P_Terms_ID IN NUMBER, p_log_level_rec IN FA_API_TYPES.log_level_rec_type)
72
73 RETURN BOOLEAN;
74
75 END FA_LEASE_PITEMS_PKG;