DBA Data[Home] [Help]

APPS.GMD_SEARCH_REPLACE_VERS dependencies on GMD_OPERATION_RESOURCES

Line 325: FROM gmd_operation_resources

321: X_actv_tbl actv_tab;
322:
323: CURSOR Cur_get_rsrc(V_oprn_line_id NUMBER) IS
324: SELECT *
325: FROM gmd_operation_resources
326: WHERE oprn_line_id = V_oprn_line_id;
327: TYPE rsrc_tab IS TABLE OF Cur_get_rsrc%ROWTYPE INDEX BY BINARY_INTEGER;
328: X_rsrc_tbl rsrc_tab;
329:

Line 468: INSERT INTO gmd_operation_resources

464: IF (X_rsrc_cnt > X_rsrc_tbl.count) THEN
465: EXIT;
466: END IF;
467: IF (X_actv_tbl(i).oprn_line_id = X_rsrc_tbl(X_rsrc_cnt).oprn_line_id) THEN
468: INSERT INTO gmd_operation_resources
469: (oprn_line_id, resources, resource_usage, resource_count, process_qty,
470: prim_rsrc_ind, scale_type, cost_analysis_code, cost_cmpntcls_id, resource_usage_uom,
471: offset_interval, delete_mark, text_code, created_by, last_updated_by,
472: last_update_date, creation_date, last_update_login, attribute1, attribute2,