DBA Data[Home] [Help]

APPS.OKI_REFRESH_PVT dependencies on OKI_REFRESHS

Line 6: g_request_id oki.oki_refreshs.request_id%TYPE;

2: /* $Header: OKIRRFHS.pls 115.18 2003/11/25 10:18:39 kbajaj ship $ */
3:
4: -- GLOBAL VARIABLES
5:
6: g_request_id oki.oki_refreshs.request_id%TYPE;
7: g_program_application_id oki.oki_refreshs.PROGRAM_APPLICATION_ID%TYPE;
8: g_program_id oki.oki_refreshs.PROGRAM_ID%TYPE;
9: g_program_update_date oki.oki_refreshs.PROGRAM_UPDATE_DATE%TYPE;
10:

Line 7: g_program_application_id oki.oki_refreshs.PROGRAM_APPLICATION_ID%TYPE;

3:
4: -- GLOBAL VARIABLES
5:
6: g_request_id oki.oki_refreshs.request_id%TYPE;
7: g_program_application_id oki.oki_refreshs.PROGRAM_APPLICATION_ID%TYPE;
8: g_program_id oki.oki_refreshs.PROGRAM_ID%TYPE;
9: g_program_update_date oki.oki_refreshs.PROGRAM_UPDATE_DATE%TYPE;
10:
11:

Line 8: g_program_id oki.oki_refreshs.PROGRAM_ID%TYPE;

4: -- GLOBAL VARIABLES
5:
6: g_request_id oki.oki_refreshs.request_id%TYPE;
7: g_program_application_id oki.oki_refreshs.PROGRAM_APPLICATION_ID%TYPE;
8: g_program_id oki.oki_refreshs.PROGRAM_ID%TYPE;
9: g_program_update_date oki.oki_refreshs.PROGRAM_UPDATE_DATE%TYPE;
10:
11:
12: FUNCTION get_conversion_rate( p_curr_date DATE

Line 9: g_program_update_date oki.oki_refreshs.PROGRAM_UPDATE_DATE%TYPE;

5:
6: g_request_id oki.oki_refreshs.request_id%TYPE;
7: g_program_application_id oki.oki_refreshs.PROGRAM_APPLICATION_ID%TYPE;
8: g_program_id oki.oki_refreshs.PROGRAM_ID%TYPE;
9: g_program_update_date oki.oki_refreshs.PROGRAM_UPDATE_DATE%TYPE;
10:
11:
12: FUNCTION get_conversion_rate( p_curr_date DATE
13: ,p_from_currency IN VARCHAR2