1: PACKAGE BODY AR_INTEREST_HEADERS_PKG AS
2: /*$Header: ARIIINVB.pls 120.3 2006/03/28 06:10:23 hyu noship $*/
3:
4: g_current_version NUMBER;
5: g_not VARCHAR2(30):= ARPT_SQL_FUNC_UTIL.get_lookup_meaning ('AR_PROCESS_STATUS','N');
6: g_error VARCHAR2(30):= ARPT_SQL_FUNC_UTIL.get_lookup_meaning ('AR_PROCESS_STATUS','E');
7: g_success VARCHAR2(30):= ARPT_SQL_FUNC_UTIL.get_lookup_meaning ('AR_PROCESS_STATUS','S');
8: g_draft VARCHAR2(30):= ARPT_SQL_FUNC_UTIL.get_lookup_meaning ('AR_RUN_TYPE','D');
9: g_final VARCHAR2(30):= ARPT_SQL_FUNC_UTIL.get_lookup_meaning ('AR_RUN_TYPE','F');
2: /*$Header: ARIIINVB.pls 120.3 2006/03/28 06:10:23 hyu noship $*/
3:
4: g_current_version NUMBER;
5: g_not VARCHAR2(30):= ARPT_SQL_FUNC_UTIL.get_lookup_meaning ('AR_PROCESS_STATUS','N');
6: g_error VARCHAR2(30):= ARPT_SQL_FUNC_UTIL.get_lookup_meaning ('AR_PROCESS_STATUS','E');
7: g_success VARCHAR2(30):= ARPT_SQL_FUNC_UTIL.get_lookup_meaning ('AR_PROCESS_STATUS','S');
8: g_draft VARCHAR2(30):= ARPT_SQL_FUNC_UTIL.get_lookup_meaning ('AR_RUN_TYPE','D');
9: g_final VARCHAR2(30):= ARPT_SQL_FUNC_UTIL.get_lookup_meaning ('AR_RUN_TYPE','F');
10:
3:
4: g_current_version NUMBER;
5: g_not VARCHAR2(30):= ARPT_SQL_FUNC_UTIL.get_lookup_meaning ('AR_PROCESS_STATUS','N');
6: g_error VARCHAR2(30):= ARPT_SQL_FUNC_UTIL.get_lookup_meaning ('AR_PROCESS_STATUS','E');
7: g_success VARCHAR2(30):= ARPT_SQL_FUNC_UTIL.get_lookup_meaning ('AR_PROCESS_STATUS','S');
8: g_draft VARCHAR2(30):= ARPT_SQL_FUNC_UTIL.get_lookup_meaning ('AR_RUN_TYPE','D');
9: g_final VARCHAR2(30):= ARPT_SQL_FUNC_UTIL.get_lookup_meaning ('AR_RUN_TYPE','F');
10:
11: FUNCTION get_header_amount
4: g_current_version NUMBER;
5: g_not VARCHAR2(30):= ARPT_SQL_FUNC_UTIL.get_lookup_meaning ('AR_PROCESS_STATUS','N');
6: g_error VARCHAR2(30):= ARPT_SQL_FUNC_UTIL.get_lookup_meaning ('AR_PROCESS_STATUS','E');
7: g_success VARCHAR2(30):= ARPT_SQL_FUNC_UTIL.get_lookup_meaning ('AR_PROCESS_STATUS','S');
8: g_draft VARCHAR2(30):= ARPT_SQL_FUNC_UTIL.get_lookup_meaning ('AR_RUN_TYPE','D');
9: g_final VARCHAR2(30):= ARPT_SQL_FUNC_UTIL.get_lookup_meaning ('AR_RUN_TYPE','F');
10:
11: FUNCTION get_header_amount
12: (p_interest_header_id IN NUMBER)
5: g_not VARCHAR2(30):= ARPT_SQL_FUNC_UTIL.get_lookup_meaning ('AR_PROCESS_STATUS','N');
6: g_error VARCHAR2(30):= ARPT_SQL_FUNC_UTIL.get_lookup_meaning ('AR_PROCESS_STATUS','E');
7: g_success VARCHAR2(30):= ARPT_SQL_FUNC_UTIL.get_lookup_meaning ('AR_PROCESS_STATUS','S');
8: g_draft VARCHAR2(30):= ARPT_SQL_FUNC_UTIL.get_lookup_meaning ('AR_RUN_TYPE','D');
9: g_final VARCHAR2(30):= ARPT_SQL_FUNC_UTIL.get_lookup_meaning ('AR_RUN_TYPE','F');
10:
11: FUNCTION get_header_amount
12: (p_interest_header_id IN NUMBER)
13: RETURN NUMBER