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';
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,
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 */
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;
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;
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;
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;
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;
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;
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;
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;
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:
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 */
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
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 *
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 */
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),