eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_RELEASE dependencies on FND_PRODUCT_GROUPS

Line 11: z_release_name fnd_product_groups.release_name%type;

7: z_result boolean := false;
8:
9: -- cached release_name
10: --
11: z_release_name fnd_product_groups.release_name%type;
12:
13: -- cached release_info
14: --
15: z_release_info fnd_product_groups.release_name%type;

Line 15: z_release_info fnd_product_groups.release_name%type;

11: z_release_name fnd_product_groups.release_name%type;
12:
13: -- cached release_info
14: --
15: z_release_info fnd_product_groups.release_name%type;
16:
17: -- cached major version number
18: -- e.g. release '11.5.10', the point release is 11
19: --

Line 45: from fnd_product_groups

41: return boolean is
42:
43: cursor get_rel_cursor is
44: select release_name
45: from fnd_product_groups
46: order by product_group_id;
47:
48: first_space number;
49:

Line 50: l_name fnd_product_groups.release_name%type := null;

46: order by product_group_id;
47:
48: first_space number;
49:
50: l_name fnd_product_groups.release_name%type := null;
51: l_info fnd_product_groups.release_name%type := null;
52:
53: begin
54:

Line 51: l_info fnd_product_groups.release_name%type := null;

47:
48: first_space number;
49:
50: l_name fnd_product_groups.release_name%type := null;
51: l_info fnd_product_groups.release_name%type := null;
52:
53: begin
54:
55: -- return cached values if available

Line 65: -- contents of RELEASE_NAME column in FND_PRODUCT_GROUPS

61:
62: --
63: -- get_release() will usually return TRUE
64: -- with RELEASE_NAME =
65: -- contents of RELEASE_NAME column in FND_PRODUCT_GROUPS
66: -- and OTHER_RELEASE_INFO = null
67: --
68: -- If FND_PRODUCT_GROUPS.RELEASE_NAME contains imbedded spaces:
69: --

Line 68: -- If FND_PRODUCT_GROUPS.RELEASE_NAME contains imbedded spaces:

64: -- with RELEASE_NAME =
65: -- contents of RELEASE_NAME column in FND_PRODUCT_GROUPS
66: -- and OTHER_RELEASE_INFO = null
67: --
68: -- If FND_PRODUCT_GROUPS.RELEASE_NAME contains imbedded spaces:
69: --
70: -- get_release() will return TRUE
71: -- with RELEASE_NAME = FND_PRODUCT_GROUPS.RELEASE_NAME up to but
72: -- not including the first imbedded space

Line 71: -- with RELEASE_NAME = FND_PRODUCT_GROUPS.RELEASE_NAME up to but

67: --
68: -- If FND_PRODUCT_GROUPS.RELEASE_NAME contains imbedded spaces:
69: --
70: -- get_release() will return TRUE
71: -- with RELEASE_NAME = FND_PRODUCT_GROUPS.RELEASE_NAME up to but
72: -- not including the first imbedded space
73: -- and OTHER_RELEASE_INFO = FND_PRODUCT_GROUPS.RELEASE_NAME
74: -- starting with the first non-space character after the first
75: -- imbedded space

Line 73: -- and OTHER_RELEASE_INFO = FND_PRODUCT_GROUPS.RELEASE_NAME

69: --
70: -- get_release() will return TRUE
71: -- with RELEASE_NAME = FND_PRODUCT_GROUPS.RELEASE_NAME up to but
72: -- not including the first imbedded space
73: -- and OTHER_RELEASE_INFO = FND_PRODUCT_GROUPS.RELEASE_NAME
74: -- starting with the first non-space character after the first
75: -- imbedded space
76: --
77: -- On failure, get_release() returns FALSE. This will be a performance issue.

Line 80: -- 1) there are no rows in fnd_product_groups

76: --
77: -- On failure, get_release() returns FALSE. This will be a performance issue.
78: -- Both RELEASE_NAME and OTHER_RELEASE_INFO will be set to 'Unknown'.
79: -- This indicates that either:
80: -- 1) there are no rows in fnd_product_groups
81: -- - this can be resolved by populating the row and it will
82: -- be queried on the next call.
83: -- 2) there is more than one row in fnd_product_groups
84: -- - delete all but the one correct row from fnd_product_groups and it

Line 83: -- 2) there is more than one row in fnd_product_groups

79: -- This indicates that either:
80: -- 1) there are no rows in fnd_product_groups
81: -- - this can be resolved by populating the row and it will
82: -- be queried on the next call.
83: -- 2) there is more than one row in fnd_product_groups
84: -- - delete all but the one correct row from fnd_product_groups and it
85: -- will be queried on the next call. It's possible that the values
86: -- returned by release_* and *_version routines are still correct if
87: -- the first row in fnd_product_groups, ordered by product_group_id,

Line 84: -- - delete all but the one correct row from fnd_product_groups and it

80: -- 1) there are no rows in fnd_product_groups
81: -- - this can be resolved by populating the row and it will
82: -- be queried on the next call.
83: -- 2) there is more than one row in fnd_product_groups
84: -- - delete all but the one correct row from fnd_product_groups and it
85: -- will be queried on the next call. It's possible that the values
86: -- returned by release_* and *_version routines are still correct if
87: -- the first row in fnd_product_groups, ordered by product_group_id,
88: -- if the currect row, but this will still be a performance problem.

Line 87: -- the first row in fnd_product_groups, ordered by product_group_id,

83: -- 2) there is more than one row in fnd_product_groups
84: -- - delete all but the one correct row from fnd_product_groups and it
85: -- will be queried on the next call. It's possible that the values
86: -- returned by release_* and *_version routines are still correct if
87: -- the first row in fnd_product_groups, ordered by product_group_id,
88: -- if the currect row, but this will still be a performance problem.
89:
90: release_name := UNKNOWN;
91: other_release_info := UNKNOWN;

Line 123: l_temp fnd_product_groups.release_name%type := null;

119:
120: -- Check for multiple rows in FPG
121:
122: declare
123: l_temp fnd_product_groups.release_name%type := null;
124: begin
125: fetch get_rel_cursor into l_temp;
126: -- return false if fetched another row
127: z_result := get_rel_cursor%notfound;

Line 155: l_name fnd_product_groups.release_name%type := null;

151: -- private initializer
152: --
153: procedure initialize is
154: l_temp boolean;
155: l_name fnd_product_groups.release_name%type := null;
156: l_info fnd_product_groups.release_name%type := null;
157: begin
158: l_temp := get_release(l_name,l_info);
159: end initialize;

Line 156: l_info fnd_product_groups.release_name%type := null;

152: --
153: procedure initialize is
154: l_temp boolean;
155: l_name fnd_product_groups.release_name%type := null;
156: l_info fnd_product_groups.release_name%type := null;
157: begin
158: l_temp := get_release(l_name,l_info);
159: end initialize;
160:

Line 212: t_release fnd_product_groups.release_name%type := z_release_name;

208: is
209: first integer;
210: second integer;
211: third integer;
212: t_release fnd_product_groups.release_name%type := z_release_name;
213: begin
214: -- initialize if needed
215: if t_release is null then
216: -- needs to be initialized