1 package fnd_release AUTHID CURRENT_USER as
2 /* $Header: AFINRELS.pls 120.3.12000000.1 2007/01/18 13:20:28 appldev ship $ */
3
4
5 --
6 -- get_release() will usually return TRUE
7 -- with RELEASE_NAME =
8 -- contents of RELEASE_NAME column in FND_PRODUCT_GROUPS
9 -- and OTHER_RELEASE_INFO = null
10 --
11 -- If FND_PRODUCT_GROUPS.RELEASE_NAME contains imbedded spaces:
12 --
13 -- get_release() will return TRUE
14 -- with RELEASE_NAME = FND_PRODUCT_GROUPS.RELEASE_NAME up to but
15 -- not including the first imbedded space
16 -- and OTHER_RELEASE_INFO = FND_PRODUCT_GROUPS.RELEASE_NAME
17 -- starting with the first non-space character after the first
18 -- imbedded space
19 --
20 -- On failure, get_release() returns FALSE. This will be a performance issue.
21 -- Both RELEASE_NAME and OTHER_RELEASE_INFO will be set to 'Unknown'.
22 -- This indicates that either:
23 -- 1) there are no rows in fnd_product_groups
24 -- - this can be resolved by populating the row and it will
25 -- be queried on the next call.
26 -- 2) there is more than one row in fnd_product_groups
27 -- - delete all but the one correct row from fnd_product_groups and it
28 -- will be queried on the next call. It's possible that the values
29 -- returned by release_* and *_version routines are still correct if
30 -- the first row in fnd_product_groups, ordered by product_group_id,
31 -- if the currect row, but this will still be a performance problem.
32 --
33
34 function get_release (release_name out nocopy varchar2,
35 other_release_info out nocopy varchar2)
36 return boolean;
37
38 pragma restrict_references (get_release, wnds);
39
40 --
41 -- returns the result of the initialization.
42 -- see get_release.
43 --
44 function result return boolean;
45
46 pragma restrict_references (result, wnds);
47
48 --
49 -- returns the release_name returned by get_release
50 -- will return null if no rows exist in fnd_product_groups.
51 --
52 function release_name return varchar2;
53
54 pragma restrict_references (release_name, wnds);
55
56 --
57 -- returns the release_info returned by get_release
58 -- will return null if no rows exist in fnd_product_groups
59 -- or no additional information exists in release_name.
60 --
61 function release_info return varchar2;
62
63 pragma restrict_references (release_info, wnds);
64
65 --
66 -- returns the major version number of the release_name
67 -- if an error occurs while parsing the release_name,
68 -- this value and minor_version will both be 0 and
69 -- point_version will be the sqlcode
70 --
71 function major_version return integer;
72
73 pragma restrict_references (major_version, wnds);
74
75 --
76 -- returns the minor version number of the release_name
77 -- if an error occurs while parsing the release_name,
78 -- this value and major_version will both be 0 and
79 -- point_version will be the sqlcode
80 --
81 function minor_version return integer;
82
83 pragma restrict_references (minor_version, wnds);
84
85 --
86 -- returns the point version number of the release_name
87 -- if an error occurs while parsing the release_name,
88 -- this value will contain the sqlcode and
89 -- both major_version and minor_version will be 0.
90 --
91 function point_version return integer;
92
93 pragma restrict_references (point_version, wnds);
94
95
96 end fnd_release;