1 PACKAGE AR_INTEREST_HEADERS_PKG AUTHID CURRENT_USER AS
2 /* $Header: ARIIINVS.pls 120.1 2006/03/09 22:52:28 hyu noship $ */
3
4 FUNCTION get_header_amount
5 (p_interest_header_id IN NUMBER)
6 RETURN NUMBER;
7
8 PROCEDURE Lock_header
9 (P_INTEREST_HEADER_ID IN NUMBER,
10 P_INTEREST_BATCH_ID IN NUMBER,
11 P_CUSTOMER_ID IN NUMBER,
12 P_CUSTOMER_SITE_USE_ID IN NUMBER,
13 P_HEADER_TYPE IN VARCHAR2,
14 P_CURRENCY_CODE IN VARCHAR2,
15 P_LATE_CHARGE_CALCULATION_TRX IN VARCHAR2,
16 P_CREDIT_ITEMS_FLAG IN VARCHAR2,
17 P_DISPUTED_TRANSACTIONS_FLAG IN VARCHAR2,
18 P_PAYMENT_GRACE_DAYS IN NUMBER,
19 P_LATE_CHARGE_TERM_ID IN NUMBER,
20 P_INTEREST_PERIOD_DAYS IN NUMBER,
21 P_INTEREST_CALCULATION_PERIOD IN VARCHAR2,
22 P_CHARGE_ON_FINANCE_CHARGE_FLG IN VARCHAR2,
23 P_HOLD_CHARGED_INVOICES_FLAG IN VARCHAR2,
24 P_MESSAGE_TEXT_ID IN NUMBER,
25 P_MULTIPLE_INTEREST_RATES_FLAG IN VARCHAR2,
26 P_CHARGE_BEGIN_DATE IN DATE,
27 P_CUST_ACCT_PROFILE_AMT_ID IN NUMBER,
28 P_EXCHANGE_RATE IN NUMBER,
29 P_EXCHANGE_RATE_TYPE IN VARCHAR2,
30 P_MIN_FC_INVOICE_OVERDUE_TYPE IN VARCHAR2,
31 P_MIN_FC_INVOICE_AMOUNT IN NUMBER,
32 P_MIN_FC_INVOICE_PERCENT IN NUMBER,
33 P_MIN_FC_BALANCE_OVERDUE_TYPE IN VARCHAR2,
34 P_MIN_FC_BALANCE_AMOUNT IN NUMBER,
35 P_MIN_FC_BALANCE_PERCENT IN NUMBER,
36 P_MIN_INTEREST_CHARGE IN NUMBER,
37 P_MAX_INTEREST_CHARGE IN NUMBER,
38 P_INTEREST_TYPE IN VARCHAR2,
39 P_INTEREST_RATE IN NUMBER,
40 P_INTEREST_FIXED_AMOUNT IN NUMBER,
41 P_INTEREST_SCHEDULE_ID IN NUMBER,
42 P_PENALTY_TYPE IN VARCHAR2,
43 P_PENALTY_RATE IN NUMBER,
44 P_PENALTY_FIXED_AMOUNT IN NUMBER,
45 P_PENALTY_SCHEDULE_ID IN NUMBER,
46 P_LAST_ACCRUE_CHARGE_DATE IN DATE,
47 P_CUSTOMER_PROFILE_ID IN NUMBER,
48 P_COLLECTOR_ID IN NUMBER,
49 P_LEGAL_ENTITY_ID IN NUMBER,
50 P_LAST_UPDATE_DATE IN DATE,
51 P_LAST_UPDATED_BY IN NUMBER,
52 P_LAST_UPDATE_LOGIN IN NUMBER,
53 P_CREATED_BY IN NUMBER,
54 P_CREATION_DATE IN DATE,
55 P_ORG_ID IN NUMBER,
56 P_PROCESS_MESSAGE IN VARCHAR2,
57 P_PROCESS_STATUS IN VARCHAR2,
58 P_CUST_TRX_TYPE_ID IN NUMBER,
59 P_OBJECT_VERSION_NUMBER IN NUMBER,
60 x_return_status OUT NOCOPY VARCHAR2,
61 x_msg_count OUT NOCOPY NUMBER,
62 x_msg_data OUT NOCOPY VARCHAR2);
63
64 PROCEDURE validate_header
65 (p_action IN VARCHAR2,
66 p_old_rec IN ar_interest_headers%ROWTYPE,
67 p_new_rec IN ar_interest_headers%ROWTYPE,
68 p_updated_by_program IN VARCHAR2 DEFAULT 'ARIINR',
69 x_return_status IN OUT NOCOPY VARCHAR2);
70
71
72
73 PROCEDURE update_header
74 (p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
75 P_INTEREST_HEADER_ID IN NUMBER,
76 P_PROCESS_MESSAGE IN VARCHAR2,
77 P_PROCESS_STATUS IN VARCHAR2,
78 p_updated_by_program IN VARCHAR2 DEFAULT 'ARIINR',
79 x_object_version_number IN OUT NOCOPY NUMBER,
80 x_return_status OUT NOCOPY VARCHAR2,
81 x_msg_count OUT NOCOPY NUMBER,
82 x_msg_data OUT NOCOPY VARCHAR2);
83
84 PROCEDURE Delete_header
85 (p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
86 p_interest_header_id IN NUMBER,
87 x_object_version_number IN NUMBER,
88 x_return_status OUT NOCOPY VARCHAR2,
89 x_msg_count OUT NOCOPY NUMBER,
90 x_msg_data OUT NOCOPY VARCHAR2);
91
92 END AR_INTEREST_HEADERS_PKG;