[Home] [Help]
PACKAGE: APPS.GL_CA_UTILITY_PKG
Source
1 PACKAGE gl_ca_utility_pkg AS
2 /* $Header: glcauts.pls 120.5 2003/03/11 04:41:21 lpoon noship $ */
3
4 -- R11i.X Changes: Delete these data types which are no longer used
5 /*
6 TYPE id_arr IS TABLE OF NUMBER(15);
7 TYPE var_arr1 IS TABLE OF VARCHAR2(1);
8 TYPE var_arr15 IS TABLE OF VARCHAR2(15);
9 TYPE var_arr20 IS TABLE OF VARCHAR2(20);
10 TYPE var_arr30 IS TABLE OF VARCHAR2(30);
11 TYPE date_arr IS TABLE OF DATE;
12
13
14 TYPE r_sob_rec_col IS RECORD (
15 r_sob_id id_arr,
16 r_sob_name var_arr30,
17 r_sob_curr var_arr15
18 );
19
20 TYPE r_trans_info IS RECORD (
21 r_exchange_rate NUMBER,
22 r_exchange_date DATE,
23 r_exchange_rate_type VARCHAR2(30),
24 r_trans_currency VARCHAR2(15),
25 r_trans_date DATE
26 );
27 */
28 TYPE r_sob_rec IS RECORD (
29 r_sob_id NUMBER(15),
30 r_sob_name VARCHAR2(30),
31 r_sob_curr VARCHAR2(15),
32 conversion_type VARCHAR2(30),
33 conversion_date DATE,
34 conversion_rate NUMBER,
35 ap_second_type VARCHAR2(30),
36 ap_second_date DATE,
37 ap_second_rate NUMBER,
38 cleared_exchange_date DATE,
39 cleared_exchange_rate_type VARCHAR2(30),
40 cleared_exchange_rate NUMBER,
41 maturity_exchange_date DATE,
42 maturity_exchange_rate_type VARCHAR2(30),
43 maturity_exchange_rate NUMBER,
44 denominator_rate NUMBER,
45 numerator_rate NUMBER,
46 result_code VARCHAR2(25),
47 misc_number1 NUMBER,
48 misc_number2 NUMBER,
49 misc_number3 NUMBER,
50 misc_number4 NUMBER,
51 misc_number5 NUMBER,
52 misc_date1 DATE,
53 misc_date2 DATE,
54 misc_varchar1 VARCHAR2(30),
55 misc_varchar2 VARCHAR2(30)
56 );
57
58 TYPE r_sob_list IS TABLE OF r_sob_rec;
59
60 TYPE r_key_value_arr IS VARRAY(1000) of NUMBER(15);
61
62 PROCEDURE get_sob_type (p_sob_id IN NUMBER,
63 p_sob_type OUT NOCOPY VARCHAR2);
64
65 FUNCTION mrc_enabled (p_sob_id IN NUMBER,
66 p_appl_id IN NUMBER,
67 p_org_id IN NUMBER,
68 p_fa_book_code IN VARCHAR2 DEFAULT NULL
69 ) RETURN BOOLEAN;
70
71 PROCEDURE get_associated_sobs (p_sob_id IN NUMBER,
72 p_appl_id IN NUMBER,
73 p_org_id IN NUMBER,
74 p_fa_book_code IN VARCHAR2 DEFAULT NULL,
75 p_sob_list IN OUT NOCOPY r_sob_list);
76
77 PROCEDURE get_rate(
78 p_primary_set_of_books_id IN NUMBER,
79 p_trans_date IN DATE,
80 p_trans_currency_code IN VARCHAR2,
81 p_application_id IN NUMBER,
82 p_org_id IN NUMBER,
83 p_exchange_rate_date IN DATE,
84 p_exchange_rate IN NUMBER,
85 p_exchange_rate_type IN VARCHAR2,
86 p_fa_book_type_code IN VARCHAR2 DEFAULT NULL,
87 p_je_source_name IN VARCHAR2 DEFAULT NULL,
88 p_je_category_name IN VARCHAR2 DEFAULT NULL,
89 p_sob_list IN OUT NOCOPY r_sob_list );
90
91 END gl_ca_utility_pkg;