PACKAGE: APPS.GL_CRM_UTILITIES_PKG

Source

1 PACKAGE GL_CRM_UTILITIES_PKG AUTHID CURRENT_USER AS
2    /* $Header: glcrmuts.pls 120.1.12010000.4 2010/04/26 12:23:04 sommukhe ship $ */
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       p_batch_number		 IN  VARCHAR2 DEFAULT NULL);
61 
62    FUNCTION submit_conc_request
63       RETURN NUMBER;
64 
65    PROCEDURE change_flag(
66       flag                                BOOLEAN);
67 END GL_CRM_UTILITIES_PKG;