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.GMD_FORMULA_EFFECTIVITY_PVT dependencies on FM_FORM_EFF

Line 26: p_formula_effectivity_rec IN fm_form_eff%ROWTYPE

22: p_commit IN varchar2 ,
23: x_return_status OUT NOCOPY varchar2 ,
24: x_msg_count OUT NOCOPY NUMBER ,
25: x_msg_data OUT NOCOPY VARCHAR2 ,
26: p_formula_effectivity_rec IN fm_form_eff%ROWTYPE
27: )
28: IS
29: /* Local Variables definitions */
30: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_FORMULAEFFECTIVITY';

Line 62: INSERT INTO fm_form_eff

58: /* Modified p_formula_effectivity_rec.end_date and */
59: /* p_formula_effectivity_rec.start_date to use */
60: /* trunc(p_formula_effectivity_rec.end_date), */
61: /* trunc(p_formula_effectivity_rec.start_date) */
62: INSERT INTO fm_form_eff
63: (fmeff_id, orgn_code,
64: item_id, formula_use,
65: end_date, start_date,
66: inv_min_qty, inv_max_qty,

Line 158: p_formula_effectivity_rec IN fm_form_eff%ROWTYPE

154: p_commit IN VARCHAR2 ,
155: x_return_status OUT NOCOPY VARCHAR2 ,
156: x_msg_count OUT NOCOPY NUMBER ,
157: x_msg_data OUT NOCOPY VARCHAR2 ,
158: p_formula_effectivity_rec IN fm_form_eff%ROWTYPE
159: )
160: IS
161:
162: /* Local Variables definitions */

Line 165: l_fm_eff_rec fm_form_eff%ROWTYPE;

161:
162: /* Local Variables definitions */
163: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_FORMULAEFFECTIVITY';
164: l_api_version CONSTANT NUMBER := 1.0;
165: l_fm_eff_rec fm_form_eff%ROWTYPE;
166:
167: l_orgn_code fm_form_eff.orgn_code%TYPE;
168: l_formula_use fm_form_eff.formula_use%TYPE;
169: l_end_date fm_form_eff.end_date%TYPE;

Line 167: l_orgn_code fm_form_eff.orgn_code%TYPE;

163: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_FORMULAEFFECTIVITY';
164: l_api_version CONSTANT NUMBER := 1.0;
165: l_fm_eff_rec fm_form_eff%ROWTYPE;
166:
167: l_orgn_code fm_form_eff.orgn_code%TYPE;
168: l_formula_use fm_form_eff.formula_use%TYPE;
169: l_end_date fm_form_eff.end_date%TYPE;
170: l_start_date fm_form_eff.start_date%TYPE;
171: l_inv_min_qty fm_form_eff.inv_min_qty%TYPE;

Line 168: l_formula_use fm_form_eff.formula_use%TYPE;

164: l_api_version CONSTANT NUMBER := 1.0;
165: l_fm_eff_rec fm_form_eff%ROWTYPE;
166:
167: l_orgn_code fm_form_eff.orgn_code%TYPE;
168: l_formula_use fm_form_eff.formula_use%TYPE;
169: l_end_date fm_form_eff.end_date%TYPE;
170: l_start_date fm_form_eff.start_date%TYPE;
171: l_inv_min_qty fm_form_eff.inv_min_qty%TYPE;
172: l_inv_max_qty fm_form_eff.inv_max_qty%TYPE;

Line 169: l_end_date fm_form_eff.end_date%TYPE;

165: l_fm_eff_rec fm_form_eff%ROWTYPE;
166:
167: l_orgn_code fm_form_eff.orgn_code%TYPE;
168: l_formula_use fm_form_eff.formula_use%TYPE;
169: l_end_date fm_form_eff.end_date%TYPE;
170: l_start_date fm_form_eff.start_date%TYPE;
171: l_inv_min_qty fm_form_eff.inv_min_qty%TYPE;
172: l_inv_max_qty fm_form_eff.inv_max_qty%TYPE;
173: l_min_qty fm_form_eff.min_qty%TYPE;

Line 170: l_start_date fm_form_eff.start_date%TYPE;

166:
167: l_orgn_code fm_form_eff.orgn_code%TYPE;
168: l_formula_use fm_form_eff.formula_use%TYPE;
169: l_end_date fm_form_eff.end_date%TYPE;
170: l_start_date fm_form_eff.start_date%TYPE;
171: l_inv_min_qty fm_form_eff.inv_min_qty%TYPE;
172: l_inv_max_qty fm_form_eff.inv_max_qty%TYPE;
173: l_min_qty fm_form_eff.min_qty%TYPE;
174: l_max_qty fm_form_eff.max_qty%TYPE;

Line 171: l_inv_min_qty fm_form_eff.inv_min_qty%TYPE;

167: l_orgn_code fm_form_eff.orgn_code%TYPE;
168: l_formula_use fm_form_eff.formula_use%TYPE;
169: l_end_date fm_form_eff.end_date%TYPE;
170: l_start_date fm_form_eff.start_date%TYPE;
171: l_inv_min_qty fm_form_eff.inv_min_qty%TYPE;
172: l_inv_max_qty fm_form_eff.inv_max_qty%TYPE;
173: l_min_qty fm_form_eff.min_qty%TYPE;
174: l_max_qty fm_form_eff.max_qty%TYPE;
175: l_std_qty fm_form_eff.std_qty%TYPE;

Line 172: l_inv_max_qty fm_form_eff.inv_max_qty%TYPE;

168: l_formula_use fm_form_eff.formula_use%TYPE;
169: l_end_date fm_form_eff.end_date%TYPE;
170: l_start_date fm_form_eff.start_date%TYPE;
171: l_inv_min_qty fm_form_eff.inv_min_qty%TYPE;
172: l_inv_max_qty fm_form_eff.inv_max_qty%TYPE;
173: l_min_qty fm_form_eff.min_qty%TYPE;
174: l_max_qty fm_form_eff.max_qty%TYPE;
175: l_std_qty fm_form_eff.std_qty%TYPE;
176: l_item_um fm_form_eff.item_um%TYPE;

Line 173: l_min_qty fm_form_eff.min_qty%TYPE;

169: l_end_date fm_form_eff.end_date%TYPE;
170: l_start_date fm_form_eff.start_date%TYPE;
171: l_inv_min_qty fm_form_eff.inv_min_qty%TYPE;
172: l_inv_max_qty fm_form_eff.inv_max_qty%TYPE;
173: l_min_qty fm_form_eff.min_qty%TYPE;
174: l_max_qty fm_form_eff.max_qty%TYPE;
175: l_std_qty fm_form_eff.std_qty%TYPE;
176: l_item_um fm_form_eff.item_um%TYPE;
177: l_preference fm_form_eff.preference%TYPE;

Line 174: l_max_qty fm_form_eff.max_qty%TYPE;

170: l_start_date fm_form_eff.start_date%TYPE;
171: l_inv_min_qty fm_form_eff.inv_min_qty%TYPE;
172: l_inv_max_qty fm_form_eff.inv_max_qty%TYPE;
173: l_min_qty fm_form_eff.min_qty%TYPE;
174: l_max_qty fm_form_eff.max_qty%TYPE;
175: l_std_qty fm_form_eff.std_qty%TYPE;
176: l_item_um fm_form_eff.item_um%TYPE;
177: l_preference fm_form_eff.preference%TYPE;
178:

Line 175: l_std_qty fm_form_eff.std_qty%TYPE;

171: l_inv_min_qty fm_form_eff.inv_min_qty%TYPE;
172: l_inv_max_qty fm_form_eff.inv_max_qty%TYPE;
173: l_min_qty fm_form_eff.min_qty%TYPE;
174: l_max_qty fm_form_eff.max_qty%TYPE;
175: l_std_qty fm_form_eff.std_qty%TYPE;
176: l_item_um fm_form_eff.item_um%TYPE;
177: l_preference fm_form_eff.preference%TYPE;
178:
179: /* define cursor */

Line 176: l_item_um fm_form_eff.item_um%TYPE;

172: l_inv_max_qty fm_form_eff.inv_max_qty%TYPE;
173: l_min_qty fm_form_eff.min_qty%TYPE;
174: l_max_qty fm_form_eff.max_qty%TYPE;
175: l_std_qty fm_form_eff.std_qty%TYPE;
176: l_item_um fm_form_eff.item_um%TYPE;
177: l_preference fm_form_eff.preference%TYPE;
178:
179: /* define cursor */
180: CURSOR get_record(vfmeff_id NUMBER) IS

Line 177: l_preference fm_form_eff.preference%TYPE;

173: l_min_qty fm_form_eff.min_qty%TYPE;
174: l_max_qty fm_form_eff.max_qty%TYPE;
175: l_std_qty fm_form_eff.std_qty%TYPE;
176: l_item_um fm_form_eff.item_um%TYPE;
177: l_preference fm_form_eff.preference%TYPE;
178:
179: /* define cursor */
180: CURSOR get_record(vfmeff_id NUMBER) IS
181: SELECT *

Line 182: FROM fm_form_eff

178:
179: /* define cursor */
180: CURSOR get_record(vfmeff_id NUMBER) IS
181: SELECT *
182: FROM fm_form_eff
183: WHERE fmeff_id = vfmeff_id;
184:
185: BEGIN
186: /* Define Savepoint */

Line 289: UPDATE fm_form_eff SET

285:
286: /* Bug 2186284 Mohit Kapoor */
287: /* Modified l_end_date and l_start_date to use */
288: /* TRUNC(l_end_date), TRUNC(l_start_date) */
289: UPDATE fm_form_eff SET
290: orgn_code = l_orgn_code,
291: formula_use = l_formula_use,
292: end_date = TRUNC(l_end_date),
293: start_date = TRUNC(l_start_date),