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