APPS.GMD_FORMULA_DESIGNER_PKG dependencies on GMD_AUTO_STEP_CALC

Line 1528: l_calculatable_rec GMD_AUTO_STEP_CALC.CALCULATABLE_REC_TYPE;

1524: x_warning_message OUT NOCOPY VARCHAR2,
1525: x_return_code OUT NOCOPY VARCHAR2,
1526: x_error_msg OUT NOCOPY VARCHAR2) IS
1527:
1528: l_calculatable_rec GMD_AUTO_STEP_CALC.CALCULATABLE_REC_TYPE;
1529: l_recipe_tbl GMD_AUTO_STEP_CALC.RECIPE_ID_TBL;
1530: l_check_step_mat GMD_AUTO_STEP_CALC.CHECK_STEP_MAT_TYPE;
1531: l_return_status VARCHAR2(2);
1532: l_message_count NUMBER;

Line 1529: l_recipe_tbl GMD_AUTO_STEP_CALC.RECIPE_ID_TBL;

1525: x_return_code OUT NOCOPY VARCHAR2,
1526: x_error_msg OUT NOCOPY VARCHAR2) IS
1527:
1528: l_calculatable_rec GMD_AUTO_STEP_CALC.CALCULATABLE_REC_TYPE;
1529: l_recipe_tbl GMD_AUTO_STEP_CALC.RECIPE_ID_TBL;
1530: l_check_step_mat GMD_AUTO_STEP_CALC.CHECK_STEP_MAT_TYPE;
1531: l_return_status VARCHAR2(2);
1532: l_message_count NUMBER;
1533: l_msg_data VARCHAR2(2000);

Line 1530: l_check_step_mat GMD_AUTO_STEP_CALC.CHECK_STEP_MAT_TYPE;

1526: x_error_msg OUT NOCOPY VARCHAR2) IS
1527:
1528: l_calculatable_rec GMD_AUTO_STEP_CALC.CALCULATABLE_REC_TYPE;
1529: l_recipe_tbl GMD_AUTO_STEP_CALC.RECIPE_ID_TBL;
1530: l_check_step_mat GMD_AUTO_STEP_CALC.CHECK_STEP_MAT_TYPE;
1531: l_return_status VARCHAR2(2);
1532: l_message_count NUMBER;
1533: l_msg_data VARCHAR2(2000);
1534: l_message VARCHAR2(1000);

Line 1550: GMD_AUTO_STEP_CALC.Check_Del_From_Step_Mat(p_check => l_calculatable_rec,

1546: -- Count recipes where this formulaline exists in step/mat association,
1547: -- and where calculate_step_qty flag IS set (ASQC=Yes)
1548: -- and where delete_mark is NOT set
1549: -- and the recipe is NOT marked obsolete.
1550: GMD_AUTO_STEP_CALC.Check_Del_From_Step_Mat(p_check => l_calculatable_rec,
1551: p_recipe_tbl => l_recipe_tbl,
1552: p_check_step_mat => l_check_step_mat,
1553: p_msg_count => l_message_count,
1554: p_msg_stack => l_msg_data,

Line 1630: l_calculatable_rec GMD_AUTO_STEP_CALC.CALCULATABLE_REC_TYPE;

1626: */
1627: PROCEDURE Cascade_Update_Recipes(x_return_code OUT NOCOPY VARCHAR2,
1628: x_error_msg OUT NOCOPY VARCHAR2) IS
1629:
1630: l_calculatable_rec GMD_AUTO_STEP_CALC.CALCULATABLE_REC_TYPE;
1631: l_recipe_tbl GMD_AUTO_STEP_CALC.RECIPE_ID_TBL;
1632: l_check_step_mat GMD_AUTO_STEP_CALC.CHECK_STEP_MAT_TYPE;
1633: l_return_status VARCHAR2(2);
1634: l_message_count NUMBER;

Line 1631: l_recipe_tbl GMD_AUTO_STEP_CALC.RECIPE_ID_TBL;

1627: PROCEDURE Cascade_Update_Recipes(x_return_code OUT NOCOPY VARCHAR2,
1628: x_error_msg OUT NOCOPY VARCHAR2) IS
1629:
1630: l_calculatable_rec GMD_AUTO_STEP_CALC.CALCULATABLE_REC_TYPE;
1631: l_recipe_tbl GMD_AUTO_STEP_CALC.RECIPE_ID_TBL;
1632: l_check_step_mat GMD_AUTO_STEP_CALC.CHECK_STEP_MAT_TYPE;
1633: l_return_status VARCHAR2(2);
1634: l_message_count NUMBER;
1635: l_msg_data VARCHAR2(2000);

Line 1632: l_check_step_mat GMD_AUTO_STEP_CALC.CHECK_STEP_MAT_TYPE;

1628: x_error_msg OUT NOCOPY VARCHAR2) IS
1629:
1630: l_calculatable_rec GMD_AUTO_STEP_CALC.CALCULATABLE_REC_TYPE;
1631: l_recipe_tbl GMD_AUTO_STEP_CALC.RECIPE_ID_TBL;
1632: l_check_step_mat GMD_AUTO_STEP_CALC.CHECK_STEP_MAT_TYPE;
1633: l_return_status VARCHAR2(2);
1634: l_message_count NUMBER;
1635: l_msg_data VARCHAR2(2000);
1636: l_message VARCHAR2(1000);

Line 1653: GMD_AUTO_STEP_CALC.Cascade_Del_To_Step_Mat(p_check => g_calculatable_rec,

1649: g_calculatable_rec.last_update_login := g_login_id;
1650: g_calculatable_rec.creation_date := l_date;
1651: g_calculatable_rec.last_update_date := l_date;
1652:
1653: GMD_AUTO_STEP_CALC.Cascade_Del_To_Step_Mat(p_check => g_calculatable_rec,
1654: p_recipe_tbl => g_recipe_tbl,
1655: p_check_step_mat => g_check_step_mat,
1656: p_msg_count => l_message_count,
1657: p_msg_stack => l_msg_data,