DBA Data[Home] [Help]

APPS.GMD_SEARCH_REPLACE_VERS dependencies on GMD_RECIPE_ORGN_RESOURCES

Line 644: FROM gmd_recipe_orgn_resources

640: X_actv_tbl rcp_actv;
641:
642: CURSOR Cur_get_rsrc IS
643: SELECT *
644: FROM gmd_recipe_orgn_resources
645: WHERE recipe_id = p_recipe_id;
646: TYPE rcp_rsrc IS TABLE OF Cur_get_rsrc%ROWTYPE INDEX BY BINARY_INTEGER;
647: X_rsrc_tbl rcp_rsrc;
648:

Line 911: INSERT INTO gmd_recipe_orgn_resources(recipe_id, organization_id, routingstep_id, oprn_line_id, resources, creation_date,

907: );
908: END LOOP;
909:
910: FOR i IN 1..X_rsrc_tbl.count LOOP
911: INSERT INTO gmd_recipe_orgn_resources(recipe_id, organization_id, routingstep_id, oprn_line_id, resources, creation_date,
912: created_by, last_updated_by, last_update_date, min_capacity, max_capacity,
913: last_update_login, text_code,
914: attribute1, attribute2, attribute3, attribute4, attribute5, attribute6,
915: attribute7, attribute8, attribute9, attribute10, attribute11, attribute12,