APPS.GMD_SEARCH_REPLACE_VERS dependencies on GMD_RECIPE_PROCESS_LOSS

Line 608: FROM gmd_recipe_process_loss

604: X_hdr_rec Cur_get_hdr%ROWTYPE;
605:
606: CURSOR Cur_process_loss IS
607: SELECT *
608: FROM gmd_recipe_process_loss
609: WHERE recipe_id = p_recipe_id;
610: TYPE proc_loss IS TABLE OF Cur_process_loss%ROWTYPE INDEX BY BINARY_INTEGER;
611: X_proc_loss_tbl proc_loss;
612:

Line 796: INSERT INTO gmd_recipe_process_loss(recipe_id, organization_id, process_loss, contiguous_ind, creation_date, created_by,

792: X_FIXED_PROCESS_LOSS => X_hdr_rec.fixed_process_loss, /*RLNAGARA 6811759*/
793: X_FIXED_PROCESS_LOSS_UOM => X_hdr_rec.fixed_process_loss_uom);
794:
795: FOR i IN 1..X_proc_loss_tbl.count LOOP
796: INSERT INTO gmd_recipe_process_loss(recipe_id, organization_id, process_loss, contiguous_ind, creation_date, created_by,
797: last_updated_by, last_update_date, last_update_login,
798: recipe_process_loss_id, text_code)
799: VALUES (x_recipe_id, X_proc_loss_tbl(i).organization_id, X_proc_loss_tbl(i).process_loss,
800: X_proc_loss_tbl(i).contiguous_ind, SYSDATE, P_created_by, P_created_by, SYSDATE, P_login_id,

Line 801: gmd_recipe_process_loss_id_s.NEXTVAL, X_proc_loss_tbl(i).text_code);

797: last_updated_by, last_update_date, last_update_login,
798: recipe_process_loss_id, text_code)
799: VALUES (x_recipe_id, X_proc_loss_tbl(i).organization_id, X_proc_loss_tbl(i).process_loss,
800: X_proc_loss_tbl(i).contiguous_ind, SYSDATE, P_created_by, P_created_by, SYSDATE, P_login_id,
801: gmd_recipe_process_loss_id_s.NEXTVAL, X_proc_loss_tbl(i).text_code);
802: END LOOP;
803: FOR i IN 1..X_cust_tbl.count LOOP
804: INSERT INTO gmd_recipe_customers(recipe_id, customer_id, created_by, creation_date, last_updated_by,
805: last_update_login, text_code, last_update_date)