DBA Data[Home] [Help]

APPS.AR_INTEREST_HEADERS_PKG dependencies on ARPT_SQL_FUNC_UTIL

Line 5: g_not VARCHAR2(30):= ARPT_SQL_FUNC_UTIL.get_lookup_meaning ('AR_PROCESS_STATUS','N');

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');

Line 6: g_error VARCHAR2(30):= ARPT_SQL_FUNC_UTIL.get_lookup_meaning ('AR_PROCESS_STATUS','E');

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:

Line 7: g_success VARCHAR2(30):= ARPT_SQL_FUNC_UTIL.get_lookup_meaning ('AR_PROCESS_STATUS','S');

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

Line 8: g_draft VARCHAR2(30):= ARPT_SQL_FUNC_UTIL.get_lookup_meaning ('AR_RUN_TYPE','D');

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)

Line 9: g_final VARCHAR2(30):= ARPT_SQL_FUNC_UTIL.get_lookup_meaning ('AR_RUN_TYPE','F');

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