1 PACKAGE AR_INTEREST_LINES_PKG AS
2 /* $Header: ARIILINES.pls 120.1 2006/03/09 22:53:52 hyu noship $ */
3
4 PROCEDURE Lock_line
5 (P_INTEREST_LINE_ID IN NUMBER,
6 P_INTEREST_HEADER_ID IN NUMBER,
7 P_PAYMENT_SCHEDULE_ID IN NUMBER,
8 P_TYPE IN VARCHAR2,
9 P_ORIGINAL_TRX_CLASS IN VARCHAR2,
10 P_DAILY_INTEREST_CHARGE IN NUMBER,
11 P_OUTSTANDING_AMOUNT IN NUMBER,
12 P_DAYS_OVERDUE_LATE IN NUMBER,
13 P_DAYS_OF_INTEREST IN NUMBER,
14 P_INTEREST_CHARGED IN NUMBER,
15 P_PAYMENT_DATE IN DATE,
16 P_FINANCE_CHARGE_CHARGED IN NUMBER,
17 P_AMOUNT_DUE_ORIGINAL IN NUMBER,
18 P_AMOUNT_DUE_REMAINING IN NUMBER,
19 P_ORIGINAL_TRX_ID IN NUMBER,
20 P_RECEIVABLES_TRX_ID IN NUMBER,
21 P_LAST_CHARGE_DATE IN DATE,
22 P_DUE_DATE IN DATE,
23 P_ACTUAL_DATE_CLOSED IN DATE,
24 P_INTEREST_RATE IN NUMBER,
25 P_RATE_START_DATE IN DATE,
26 P_RATE_END_DATE IN DATE,
27 P_SCHEDULE_DAYS_FROM IN NUMBER,
28 P_SCHEDULE_DAYS_TO IN NUMBER,
29 P_LAST_UPDATE_DATE IN DATE,
30 P_LAST_UPDATED_BY IN NUMBER,
31 P_LAST_UPDATE_LOGIN IN NUMBER,
32 P_PROCESS_STATUS IN VARCHAR2,
33 P_PROCESS_MESSAGE IN VARCHAR2,
34 P_ORG_ID IN NUMBER,
35 P_OBJECT_VERSION_NUMBER IN NUMBER,
36 x_return_status OUT NOCOPY VARCHAR2,
37 x_msg_count OUT NOCOPY NUMBER,
38 x_msg_data OUT NOCOPY VARCHAR2);
39
40
41
42
43 PROCEDURE validate_line
44 (p_action IN VARCHAR2,
45 p_old_rec IN ar_interest_lines%ROWTYPE,
46 p_new_rec IN ar_interest_lines%ROWTYPE,
47 x_return_status IN OUT NOCOPY VARCHAR2);
48
49
50 PROCEDURE Update_line
51 (p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
52 P_INTEREST_LINE_ID IN NUMBER,
53 P_PROCESS_STATUS IN VARCHAR2,
54 P_PROCESS_MESSAGE IN VARCHAR2,
55 x_object_version_number IN OUT NOCOPY NUMBER,
56 x_return_status OUT NOCOPY VARCHAR2,
57 x_msg_count OUT NOCOPY NUMBER,
58 x_msg_data OUT NOCOPY VARCHAR2);
59
60 PROCEDURE Delete_line
61 (p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
62 p_interest_line_id IN NUMBER,
63 x_object_version_number IN NUMBER,
64 x_return_status OUT NOCOPY VARCHAR2,
65 x_msg_count OUT NOCOPY NUMBER,
66 x_msg_data OUT NOCOPY VARCHAR2);
67
68 END AR_INTEREST_LINES_PKG;