DBA Data[Home] [Help]

APPS.GME_API_GRP dependencies on GMDFMVAL_PUB

Line 785: ,p_formula_dtl_tbl IN gmdfmval_pub.formula_detail_tbl

781: ,x_message_count OUT NOCOPY NUMBER
782: ,x_message_list OUT NOCOPY VARCHAR2
783: ,x_return_status OUT NOCOPY VARCHAR2
784: ,p_batch_header_rec IN gme_batch_header%rowtype
785: ,p_formula_dtl_tbl IN gmdfmval_pub.formula_detail_tbl
786: ,p_recipe_rout_tbl IN gmd_recipe_fetch_pub.recipe_rout_tbl
787: ,p_recipe_step_tbl IN gmd_recipe_fetch_pub.recipe_step_tbl
788: ,p_routing_depd_tbl IN gmd_recipe_fetch_pub.routing_depd_tbl
789: ,p_oprn_act_tbl IN gmd_recipe_fetch_pub.oprn_act_tbl

Line 1155: l_formula_tbl gmdfmval_pub.formula_detail_tbl;

1151: FROM fnd_new_messages
1152: WHERE application_id = 553
1153: AND message_name = v_msg_name;
1154:
1155: l_formula_tbl gmdfmval_pub.formula_detail_tbl;
1156: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
1157: l_material_details_tbl gme_common_pvt.material_details_tab;
1158: l_material_details_tbl_out gme_common_pvt.material_details_tab;
1159: l_material_detail_rec gme_material_details%ROWTYPE;

Line 1246: gmdfmval_pub.get_substitute_line_item (pformulaline_id => rec.formulaline_id,

1242: -- nsinghi bug#5674398. Pass the ingredient substitution date rather than the material requirement date
1243: l_ingred_sub_date := gme_api_grp.get_ingr_sub_date(rec.batch_id,rec.material_detail_id);
1244:
1245: /* Though this call returns a table, we will be looking at the 1st record of the table */
1246: gmdfmval_pub.get_substitute_line_item (pformulaline_id => rec.formulaline_id,
1247: pitem_id => rec.inventory_item_id,
1248: pqty => rec.plan_qty,
1249: puom => rec.dtl_um,
1250: pscale_multiple => rec.scale_multiple,