[Home] [Help]
173:
174: SELECT
175: nvl(step_qty, 0) * p_transfer_pct / 100 INTO l_transfer_qty
176: FROM
177: fm_rout_dtl
178: WHERE
179: routing_id = p_routing_id AND
180: routingstep_no = p_routingstep_no;
181:
748:
749: IF (p_update_release_type = 1 AND
750: p_enforce_step_dep = 1) THEN
751:
752: UPDATE fm_rout_dtl
753: SET steprelease_type = 1,
754: last_update_date = p_last_update_date,
755: last_updated_by = p_user_id,
756: last_update_login = p_user_id
898: x_return_code OUT NOCOPY VARCHAR2,
899: x_error_msg OUT NOCOPY VARCHAR2) IS
900:
901: l_text_code NUMBER(10);
902: l_routing_step_rec fm_rout_dtl%ROWTYPE;
903: l_return_status VARCHAR2(2);
904: l_message_count NUMBER;
905: l_message_list VARCHAR2(2000);
906: l_message VARCHAR2(1000);
1018: RECORD_CHANGED_EXCEPTION EXCEPTION;
1019:
1020: CURSOR Cur_get_step IS
1021: SELECT *
1022: FROM fm_rout_dtl
1023: WHERE routingstep_id = p_routingstep_id AND
1024: last_update_date = p_last_update_date_orig;
1025:
1026: l_step_rec Cur_get_step%ROWTYPE;
1395:
1396: SELECT
1397: routingstep_id INTO l_dummy
1398: FROM
1399: fm_rout_dtl
1400: WHERE
1401: routing_id = p_routing_id AND
1402: routingstep_id = p_routingstep_id AND
1403: last_update_date = p_last_update_date;
1488: WHERE routing_id = p_copy_from_routing_id;
1489:
1490: CURSOR Cur_get_dtl IS
1491: SELECT *
1492: FROM fm_rout_dtl
1493: WHERE routing_id = p_copy_from_routing_id;
1494:
1495: CURSOR Cur_get_dep IS
1496: SELECT *
1702: OPEN Get_Text_Code;
1703: FETCH Get_Text_Code INTO l_text_code;
1704: CLOSE Get_Text_Code;
1705:
1706: l_table_lnk := 'fm_rout_dtl' || '|' || x_routing_id || '|' || l_routingstep_id;
1707:
1708: WHILE (l_txt_ind <= l_dtl_text_tbl.COUNT AND
1709: l_dtl_text_tbl(l_txt_ind).text_code = x_dtl_tbl(i).text_code) LOOP
1710:
1733:
1734: END IF;
1735:
1736:
1737: INSERT INTO fm_rout_dtl
1738: (routing_id, routingstep_no, routingstep_id, oprn_id,
1739: step_qty, steprelease_type,
1740: text_code, creation_date, created_by, last_update_login,
1741: last_update_date,