[Home] [Help]
PACKAGE: APPS.GL_CRM_UTILITIES_PKG
Source
1 PACKAGE GL_CRM_UTILITIES_PKG AS
2 /* $Header: glcrmuts.pls 120.1 2005/05/05 02:03:20 kvora noship $ */
3 DEBUG_MODE BOOLEAN := FALSE;
4 enable_trigger BOOLEAN := FALSE;
5 page_line_numbers NUMBER := 65;
6 page_count NUMBER := 1;
7 page_line_count NUMBER := 1;
8
9 TYPE var_arr15 IS TABLE OF VARCHAR2(15);
10
11 TYPE var_arr30 IS TABLE OF VARCHAR2(30);
12
13 TYPE date_arr IS TABLE OF DATE;
14
15 TYPE num_arr IS TABLE OF NUMBER;
16
17 TYPE curr_rec IS RECORD(
18 r_from_curr var_arr15,
19 r_to_curr var_arr15
20 );
21
22 TYPE daily_rate_interface_rec IS RECORD(
23 r_from_curr var_arr15,
24 r_to_curr var_arr15,
25 r_from_date date_arr,
26 r_to_date date_arr,
27 r_type var_arr30,
28 r_rate num_arr,
29 r_inverse_rate num_arr,
30 r_error_code var_arr30
31 );
32
33 TYPE daily_rate_rec IS RECORD(
34 r_from_curr var_arr15,
35 r_to_curr var_arr15,
36 r_conversion_date date_arr,
37 r_type var_arr30,
38 r_rate num_arr,
39 r_rate_source_code var_arr30
40 );
41
42 PROCEDURE insert_cross_rate_set(
43 p_conversion_type IN VARCHAR2,
44 p_contra_currency IN VARCHAR2,
45 p_login_user IN NUMBER);
46
47 PROCEDURE update_cross_rate_set(
48 p_conversion_type IN VARCHAR2,
49 p_new_contra_currency IN VARCHAR2,
50 p_old_contra_currency IN VARCHAR2,
51 p_login_user IN NUMBER);
52
53 PROCEDURE delete_cross_rate_set(
54 p_conversion_type IN VARCHAR2,
55 p_contra_currency IN VARCHAR2);
56
57 PROCEDURE daily_rates_import(
58 errbuf OUT NOCOPY VARCHAR2,
59 retcode OUT NOCOPY NUMBER);
60
61 FUNCTION submit_conc_request
62 RETURN NUMBER;
63
64 PROCEDURE change_flag(
65 flag BOOLEAN);
66 END GL_CRM_UTILITIES_PKG;