1 PACKAGE PO_DAILY_CONVERSION_TYPES_SV1 AS
2 /* $Header: POXPIRTS.pls 120.0.12010000.1 2008/09/18 12:20:48 appldev noship $ */
3
4 /*==================================================================
5 FUNCTION NAME: val_rate_type_code()
6
7 DESCRIPTION: This API is used to validate rate_type and make
8 sure it is valid in gl_daily_conversion_types_v table.
9
10 PARAMETERS: x_rate_type_code IN VARCHAR2
11
12
13 DESIGN
14 REFERENCES: 832vlapi.doc
15
16 ALGORITHM: API will return TRUE if validation succeeds, FALSE
17 otherwise.
18
19 NOTES:
20
21 OPEN ISSUES:
22
23 CLOSE ISSUES:
24
25 CHANGE
26 HISTORY: Created 03-Mar-1996 Rajan
27 Modified 13-MAR-1996 Daisy Yu
28
29 =======================================================================*/
30 FUNCTION val_rate_type_code(x_rate_type_code IN VARCHAR2)
31 RETURN BOOLEAN;
32
33
34 /*==================================================================
35 FUNCTION NAME: derive_rate_type_code()
36
37 DESCRIPTION: This API is used to derive rate_type_code with
38 rate_type as input parameter.
39
40 PARAMETERS: x_rate_type IN VARCHAR2
41
42 DESIGN
43 REFERENCES: 832dvapi.dd
44
45 ALGORITHM: API returns conversion_type (VARCHAR2) if found;
46 NULL otherwise.
47 NOTES:
48
49 OPEN ISSUES:
50
51 CHANGE HISTORY: Created 03-Mar-1996 Rajan Odayar
52 Modified 12-MAR-1996 Daisy Yu
53
54 =======================================================================*/
55
56 FUNCTION derive_rate_type_code(X_rate_type IN VARCHAR2) return VARCHAR2;
57
58 END PO_DAILY_CONVERSION_TYPES_SV1;