APPS.GMD_RECIPE_DESIGNER_PKG dependencies on GMD_RECIPE_STEP_MATERIALS

Line 473: | Create a row in GMD_RECIPE_STEP_MATERIALS

469: | PROCEDURE NAME
470: | Create_Step_Material_Link
471: |
472: | DESCRIPTION
473: | Create a row in GMD_RECIPE_STEP_MATERIALS
474: |
475: | INPUT PARAMETERS
476: | p_recipe_id NUMBER
477: | p_formulaline_id NUMBER

Line 510: INSERT INTO gmd_recipe_step_materials (

506: x_return_code := 'S';
507: x_error_msg := '';
508:
509:
510: INSERT INTO gmd_recipe_step_materials (
511: recipe_id
512: ,formulaline_id
513: ,routingstep_id
514: ,text_code

Line 552: | Delete a row in GMD_RECIPE_STEP_MATERIALS

548: | PROCEDURE NAME
549: | Delete_Step_Material_Link
550: |
551: | DESCRIPTION
552: | Delete a row in GMD_RECIPE_STEP_MATERIALS
553: |
554: | INPUT PARAMETERS
555: | p_recipe_id NUMBER
556: | p_formulaline_id NUMBER

Line 585: gmd_recipe_step_materials

581: CURSOR Get_Step (c_recipe_id NUMBER, c_formulaline_id NUMBER, routingstep_id NUMBER) IS
582: SELECT
583: last_update_date
584: FROM
585: gmd_recipe_step_materials
586: WHERE
587: recipe_id = c_recipe_id AND
588: formulaline_id = c_formulaline_id AND
589: routingstep_id = routingstep_id;

Line 600: gmd_recipe_step_materials

596: x_error_msg := '';
597:
598:
599: DELETE
600: gmd_recipe_step_materials
601: WHERE
602: recipe_id = p_recipe_id AND
603: formulaline_id = p_formulaline_id AND
604: routingstep_id = p_routingstep_id AND

Line 639: | Update a row in GMD_RECIPE_STEP_MATERIALS

635: | PROCEDURE NAME
636: | Update_Step_Material_Link
637: |
638: | DESCRIPTION
639: | Update a row in GMD_RECIPE_STEP_MATERIALS
640: |
641: | INPUT PARAMETERS
642: | p_recipe_id NUMBER
643: | p_formulaline_id NUMBER

Line 678: gmd_recipe_step_materials

674: x_error_msg := '';
675:
676:
677: UPDATE
678: gmd_recipe_step_materials
679: SET
680: text_code = p_text_code,
681: last_update_date = p_last_update_date,
682: last_updated_by = p_user_id,

Line 1806: FROM gmd_recipe_step_materials a, fm_rout_dtl b

1802: l_dummy NUMBER;
1803:
1804: CURSOR Get_Old_Stp_Mat IS
1805: SELECT a.routingstep_id
1806: FROM gmd_recipe_step_materials a, fm_rout_dtl b
1807: WHERE a.recipe_id = p_recipe_id
1808: AND a.routingstep_id = b.routingstep_id
1809: AND b.routing_id = l_recipe_rec.routing_id;
1810:

Line 1958: DELETE gmd_recipe_step_materials

1954:
1955: --- Delete old rows in step material table
1956: FOR old_step_mat IN Get_Old_Stp_Mat LOOP
1957:
1958: DELETE gmd_recipe_step_materials
1959: WHERE recipe_id = p_recipe_id AND
1960: routingstep_id = old_step_mat.routingstep_id;
1961:
1962: END LOOP;

Line 3260: FROM gmd_recipe_step_materials

3256: WHERE recipe_id = p_copy_from_recipe_id;
3257:
3258: CURSOR Cur_get_stp_mtl IS
3259: SELECT *
3260: FROM gmd_recipe_step_materials
3261: WHERE recipe_id = p_copy_from_recipe_id;
3262:
3263: CURSOR Cur_get_frm_hdr IS
3264: SELECT *

Line 4547: DELETE gmd_recipe_step_materials WHERE recipe_id = p_copy_from_recipe_id;

4543: ---
4544: l_txt_ind := 1;
4545:
4546: IF NOT l_copy_recipe THEN
4547: DELETE gmd_recipe_step_materials WHERE recipe_id = p_copy_from_recipe_id;
4548: END IF;
4549:
4550: FOR i IN 1..l_stp_mtl_tbl.count LOOP
4551:

Line 4563: l_table_lnk := 'gmd_recipe_step_materials' || '|' ||

4559: l_text_code := l_stp_mtl_tbl(i).text_code;
4560: DELETE fm_text_tbl WHERE text_code = l_text_code;
4561: END IF;
4562:
4563: l_table_lnk := 'gmd_recipe_step_materials' || '|' ||
4564: l_stp_mtl_tbl(i).formulaline_id ||
4565: '|' || l_stp_mtl_tbl(i).routingstep_id;
4566:
4567: WHILE (l_txt_ind <= l_stp_mtl_text_tbl.COUNT AND