DBA Data[Home] [Help]

APPS.GMD_ROUTING_STEPS_PUB dependencies on STANDARD

Line 345: l_step_dep_tab(k).standard_delay := p_routings_step_dep_tbl(j).standard_delay ;

341: l_step_dep_tab(k).dep_routingstep_no := p_routings_step_dep_tbl(j).dep_routingstep_no ;
342: l_step_dep_tab(k).routing_id := l_routing_id ;
343: l_step_dep_tab(k).dep_type := p_routings_step_dep_tbl(j).dep_type ;
344: l_step_dep_tab(k).rework_code := p_routings_step_dep_tbl(j).rework_code ;
345: l_step_dep_tab(k).standard_delay := p_routings_step_dep_tbl(j).standard_delay ;
346: l_step_dep_tab(k).minimum_delay := p_routings_step_dep_tbl(j).minimum_delay ;
347: l_step_dep_tab(k).max_delay := p_routings_step_dep_tbl(j).max_delay ;
348: l_step_dep_tab(k).transfer_qty := p_routings_step_dep_tbl(j).transfer_qty ;
349: l_step_dep_tab(k).routingstep_no_uom

Line 1131: ELSIF UPPER(p_update_table(a).p_col_to_update) = 'STANDARD_DELAY' THEN

1127: l_transfer_pct := p_update_table(a).p_value;
1128: /* Validation : Check if dependency type value is valid */
1129: ELSIF UPPER(p_update_table(a).p_col_to_update) = 'DEP_TYPE' THEN
1130: l_dep_type := p_update_table(a).p_value;
1131: ELSIF UPPER(p_update_table(a).p_col_to_update) = 'STANDARD_DELAY' THEN
1132: l_std_delay := p_update_table(a).p_value;
1133: END IF; /* UPPER(p_update_table(i).p_col_to_update) = 'TRANSFER_PCT' */
1134: END LOOP;
1135:

Line 1146: /* standard delay value should be in = or > 0 */

1142: FND_MSG_PUB.ADD;
1143: RAISE routing_update_dep_failure;
1144: END IF;
1145:
1146: /* standard delay value should be in = or > 0 */
1147: IF l_std_delay < 0 THEN
1148: IF (l_debug = 'Y') THEN
1149: gmd_debug.put_line ('Transfer pct value should be positive');
1150: END IF;