DBA Data[Home] [Help]

APPS.GMD_SEARCH_REPLACE_VERS dependencies on GMD_OPERATION_ACTIVITIES

Line 318: FROM gmd_operation_activities

314: WHERE oprn_no = X_hdr_rec.oprn_no;
315:
316: CURSOR Cur_get_actv IS
317: SELECT *
318: FROM gmd_operation_activities
319: WHERE oprn_id = p_oprn_id;
320: TYPE actv_tab IS TABLE OF Cur_get_actv%ROWTYPE INDEX BY BINARY_INTEGER;
321: X_actv_tbl actv_tab;
322:

Line 440: INSERT INTO gmd_operation_activities

436: FOR i IN 1..X_actv_tbl.count LOOP
437: OPEN Cur_gen_oprnline_id;
438: FETCH Cur_gen_oprnline_id INTO X_oprn_line_id;
439: CLOSE Cur_gen_oprnline_id;
440: INSERT INTO gmd_operation_activities
441: (oprn_id, oprn_line_id, activity, activity_factor, delete_mark, text_code, last_updated_by,
442: created_by, last_update_date, creation_date, last_update_login, attribute1, attribute2,
443: attribute3, attribute4, attribute5, attribute6, attribute7, attribute8, attribute9,
444: attribute10, attribute11, attribute12, attribute13, attribute14, attribute15, attribute16,