DBA Data[Home] [Help]

APPS.GMD_VERSION_CONTROL dependencies on GMD_RECIPE_PROCESS_LOSS

Line 805: FROM gmd_recipe_process_loss

801: X_hdr_rec Cur_get_hdr%ROWTYPE;
802:
803: CURSOR Cur_process_loss IS
804: SELECT *
805: FROM gmd_recipe_process_loss
806: WHERE recipe_id = p_recipe_id;
807: TYPE proc_loss IS TABLE OF Cur_process_loss%ROWTYPE INDEX BY BINARY_INTEGER;
808: X_proc_loss_tbl proc_loss;
809:

Line 1016: INSERT INTO gmd_recipe_process_loss(recipe_id, organization_id, process_loss,

1012: l_text_code := NULL;
1013: END IF;
1014: -- Bug #2673008 (JKB) Added call to copy_text above.
1015: /* B6811759 */
1016: INSERT INTO gmd_recipe_process_loss(recipe_id, organization_id, process_loss,
1017: creation_date, created_by,
1018: last_updated_by, last_update_date, last_update_login,
1019: recipe_process_loss_id, text_code,fixed_process_loss,fixed_process_loss_uom)
1020: VALUES (x_recipe_id, X_proc_loss_tbl(i).organization_id,

Line 1023: gmd_recipe_process_loss_id_s.NEXTVAL, l_text_code,

1019: recipe_process_loss_id, text_code,fixed_process_loss,fixed_process_loss_uom)
1020: VALUES (x_recipe_id, X_proc_loss_tbl(i).organization_id,
1021: X_proc_loss_tbl(i).process_loss,
1022: SYSDATE, P_created_by, P_created_by, SYSDATE, P_login_id,
1023: gmd_recipe_process_loss_id_s.NEXTVAL, l_text_code,
1024: X_proc_loss_tbl(i).fixed_process_loss,
1025: X_proc_loss_tbl(i).fixed_process_loss_uom);
1026: -- Bug #2673008 (JKB) Changed above.
1027: END LOOP;