DBA Data[Home] [Help]

APPS.GME_API_GRP dependencies on GMDFMVAL_PUB

Line 809: ,p_formula_dtl_tbl IN gmdfmval_pub.formula_detail_tbl

805: ,x_message_count OUT NOCOPY NUMBER
806: ,x_message_list OUT NOCOPY VARCHAR2
807: ,x_return_status OUT NOCOPY VARCHAR2
808: ,p_batch_header_rec IN gme_batch_header%rowtype
809: ,p_formula_dtl_tbl IN gmdfmval_pub.formula_detail_tbl
810: ,p_recipe_rout_tbl IN gmd_recipe_fetch_pub.recipe_rout_tbl
811: ,p_recipe_step_tbl IN gmd_recipe_fetch_pub.recipe_step_tbl
812: ,p_routing_depd_tbl IN gmd_recipe_fetch_pub.routing_depd_tbl
813: ,p_oprn_act_tbl IN gmd_recipe_fetch_pub.oprn_act_tbl

Line 1184: l_formula_tbl gmdfmval_pub.formula_detail_tbl;

1180: FROM fnd_new_messages
1181: WHERE application_id = 553
1182: AND message_name = v_msg_name;
1183:
1184: l_formula_tbl gmdfmval_pub.formula_detail_tbl;
1185: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
1186: l_material_details_tbl gme_common_pvt.material_details_tab;
1187: l_material_details_tbl_out gme_common_pvt.material_details_tab;
1188: l_material_detail_rec gme_material_details%ROWTYPE;

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

1271: -- nsinghi bug#5674398. Pass the ingredient substitution date rather than the material requirement date
1272: l_ingred_sub_date := gme_api_grp.get_ingr_sub_date(rec.batch_id,rec.material_detail_id);
1273:
1274: /* Though this call returns a table, we will be looking at the 1st record of the table */
1275: gmdfmval_pub.get_substitute_line_item (pformulaline_id => rec.formulaline_id,
1276: pitem_id => rec.inventory_item_id,
1277: pqty => rec.plan_qty,
1278: puom => rec.dtl_um,
1279: pscale_multiple => rec.scale_multiple,