DBA Data[Home] [Help]

APPS.GMD_SEARCH_REPLACE_VERS dependencies on FM_ROUT_DTL

Line 61: FROM fm_rout_dtl

57: WHERE routing_no = X_hdr_rec.routing_no;
58:
59: CURSOR Cur_get_dtl IS
60: SELECT *
61: FROM fm_rout_dtl
62: WHERE routing_id = p_routing_id;
63: TYPE detail_tab IS TABLE OF Cur_get_dtl%ROWTYPE INDEX BY BINARY_INTEGER;
64: X_dtl_tbl detail_tab;
65: X_return_status VARCHAR2(1);

Line 186: INSERT INTO fm_rout_dtl

182:
183:
184: /* Insert detail records */
185: FOR i IN 1..X_dtl_tbl.count LOOP
186: INSERT INTO fm_rout_dtl
187: (routing_id, routingstep_no, routingstep_id, oprn_id, step_qty, steprelease_type,
188: text_code, creation_date, created_by, last_update_login, last_update_date,
189: last_updated_by, attribute1, attribute2, attribute3, attribute4, attribute5,
190: attribute6, attribute7, attribute8, attribute9, attribute10,