APPS.GMD_ROUTING_STEPS_PVT dependencies on STANDARD

Line 213: IF (p_routings_step_dep_tbl(i).max_delay < p_routings_step_dep_tbl(i).standard_delay AND

209: l_transfer_qty := l_step_qty * p_routings_step_dep_tbl(i).transfer_pct * .01;
210:
211:
212: /* S.Dulyk - 12/27/02 Bug 2669986 Added validation for max_delay */
213: IF (p_routings_step_dep_tbl(i).max_delay < p_routings_step_dep_tbl(i).standard_delay AND
214: p_routings_step_dep_tbl(i).max_delay IS NOT NULL) THEN
215: FND_MESSAGE.SET_NAME('GMD','GMD_MAX_DELAY_VALIDATION');
216: FND_MSG_PUB.ADD;
217: x_return_status := FND_API.g_ret_sts_error;

Line 223: ,standard_delay ,minimum_delay ,max_delay ,transfer_qty ,routingstep_no_uom

219:
220:
221: INSERT INTO fm_rout_dep
222: (routingstep_no ,dep_routingstep_no ,routing_id ,dep_type ,rework_code
223: ,standard_delay ,minimum_delay ,max_delay ,transfer_qty ,routingstep_no_uom
224: ,text_code ,last_updated_by ,created_by ,last_update_date ,creation_date
225: ,last_update_login ,transfer_pct ) VALUES
226: (p_routingstep_no
227: ,p_routings_step_dep_tbl(i).dep_routingstep_no

Line 231: ,NVL(p_routings_step_dep_tbl(i).standard_delay,0)

227: ,p_routings_step_dep_tbl(i).dep_routingstep_no
228: ,p_routing_id
229: ,NVL(p_routings_step_dep_tbl(i).dep_type,0)
230: ,p_routings_step_dep_tbl(i).rework_code
231: ,NVL(p_routings_step_dep_tbl(i).standard_delay,0)
232: ,NVL(p_routings_step_dep_tbl(i).minimum_delay,0)
233: ,p_routings_step_dep_tbl(i).max_delay
234: ,NVL(l_transfer_qty,0)
235: ,p_routings_step_dep_tbl(i).routingstep_no_uom

Line 622: ELSIF (UPPER(p_update_table(i).p_col_to_update) = 'STANDARD_DELAY') THEN

618: IF (UPPER(p_update_table(i).p_col_to_update) = 'DEP_TYPE') THEN
619: l_old_stepDep_rec.DEP_TYPE := p_update_table(i).p_value;
620: ELSIF (UPPER(p_update_table(i).p_col_to_update) = 'REWORK_CODE') THEN
621: l_old_stepDep_rec.REWORK_CODE := p_update_table(i).p_value;
622: ELSIF (UPPER(p_update_table(i).p_col_to_update) = 'STANDARD_DELAY') THEN
623: l_old_stepDep_rec.STANDARD_DELAY := p_update_table(i).p_value;
624: /* S.Dulyk - 12/27/02 Bug 2669986 Added max_delay */
625: ELSIF (UPPER(p_update_table(i).p_col_to_update) = 'MAX_DELAY') THEN
626: l_old_stepDep_rec.MAX_DELAY := p_update_table(i).p_value;

Line 623: l_old_stepDep_rec.STANDARD_DELAY := p_update_table(i).p_value;

619: l_old_stepDep_rec.DEP_TYPE := p_update_table(i).p_value;
620: ELSIF (UPPER(p_update_table(i).p_col_to_update) = 'REWORK_CODE') THEN
621: l_old_stepDep_rec.REWORK_CODE := p_update_table(i).p_value;
622: ELSIF (UPPER(p_update_table(i).p_col_to_update) = 'STANDARD_DELAY') THEN
623: l_old_stepDep_rec.STANDARD_DELAY := p_update_table(i).p_value;
624: /* S.Dulyk - 12/27/02 Bug 2669986 Added max_delay */
625: ELSIF (UPPER(p_update_table(i).p_col_to_update) = 'MAX_DELAY') THEN
626: l_old_stepDep_rec.MAX_DELAY := p_update_table(i).p_value;
627: ELSIF (UPPER(p_update_table(i).p_col_to_update) = 'TRANSFER_PCT') THEN

Line 647: IF (l_old_stepDep_rec.max_delay < l_old_stepDep_rec.standard_delay AND

643: RAISE last_update_date_failure;
644: END IF;
645:
646: /* S.Dulyk - 12/27/02 Bug 2669986 Added validation for max_delay */
647: IF (l_old_stepDep_rec.max_delay < l_old_stepDep_rec.standard_delay AND
648: l_old_stepDep_rec.max_delay IS NOT NULL) THEN
649: FND_MESSAGE.SET_NAME('GMD','GMD_MAX_DELAY_VALIDATION');
650: FND_MSG_PUB.ADD;
651: x_return_status := FND_API.g_ret_sts_error;

Line 658: ,standard_delay = l_old_stepDep_rec.standard_delay

654: /* S.Dulyk - 12/27/02 Bug 2669986 Added max_delay */
655: UPDATE fm_rout_dep
656: SET dep_type = l_old_stepDep_rec.dep_type
657: ,rework_code = l_old_stepDep_rec.rework_code
658: ,standard_delay = l_old_stepDep_rec.standard_delay
659: ,max_delay = l_old_stepDep_rec.max_delay
660: ,text_code = l_old_stepDep_rec.text_code
661: ,last_updated_by = l_old_stepDep_rec.last_updated_by
662: ,last_update_date = NVL(l_old_stepDep_rec.last_update_date,SYSDATE)