APPS.GMD_FORMULA_ANALYSIS dependencies on GMD_FETCH_VALIDITY_RULES

Line 411: X_vrules_tab gmd_fetch_validity_rules.recipe_validity_tbl;

407: --
408: --===================================================================== */
409: PROCEDURE check_explosion(p_formula_id NUMBER, p_organization_id NUMBER, p_laboratory_id IN NUMBER, p_rec IN OUT NOCOPY ing_rec,
410: p_explosion_rule NUMBER, x_return_status OUT NOCOPY VARCHAR2) IS
411: X_vrules_tab gmd_fetch_validity_rules.recipe_validity_tbl;
412: X_vrules_tab1 gmd_fetch_validity_rules.recipe_validity_tbl;
413: CURSOR Cur_product_qty(V_formula_id NUMBER, V_item_id NUMBER) IS
414: SELECT qty, detail_uom
415: FROM fm_matl_dtl

Line 412: X_vrules_tab1 gmd_fetch_validity_rules.recipe_validity_tbl;

408: --===================================================================== */
409: PROCEDURE check_explosion(p_formula_id NUMBER, p_organization_id NUMBER, p_laboratory_id IN NUMBER, p_rec IN OUT NOCOPY ing_rec,
410: p_explosion_rule NUMBER, x_return_status OUT NOCOPY VARCHAR2) IS
411: X_vrules_tab gmd_fetch_validity_rules.recipe_validity_tbl;
412: X_vrules_tab1 gmd_fetch_validity_rules.recipe_validity_tbl;
413: CURSOR Cur_product_qty(V_formula_id NUMBER, V_item_id NUMBER) IS
414: SELECT qty, detail_uom
415: FROM fm_matl_dtl
416: WHERE formula_id = V_formula_id

Line 874: X_vr_tbl OUT NOCOPY gmd_fetch_validity_rules.recipe_validity_tbl) IS

870: --
871: --===================================================================== */
872: PROCEDURE try_validity_rules(p_item_id NUMBER, p_organization_id NUMBER,
873: p_qty NUMBER, p_uom VARCHAR2,
874: X_vr_tbl OUT NOCOPY gmd_fetch_validity_rules.recipe_validity_tbl) IS
875: X_status VARCHAR2(10);
876: X_msg_cnt NUMBER;
877: X_msg_dat VARCHAR2(100);
878: X_ret_code NUMBER;

Line 880: gmd_fetch_validity_rules.get_validity_rules(p_api_version => 1.0,

876: X_msg_cnt NUMBER;
877: X_msg_dat VARCHAR2(100);
878: X_ret_code NUMBER;
879: BEGIN
880: gmd_fetch_validity_rules.get_validity_rules(p_api_version => 1.0,
881: p_init_msg_list => 'F',
882: p_recipe_id => NULL,
883: p_item_id => p_item_id,
884: p_organization_id => p_organization_id,