eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_SPREAD_FETCH_PKG dependencies on GME_COMMON_PVT

Line 232: l_reservations_tbl gme_common_pvt.reservations_tab;

228: l_rec_count NUMBER(10);
229: l_tpformula_id NUMBER(10);
230:
231: l_recipe_validity_out GMD_VALIDITY_RULES.recipe_validity_tbl;
232: l_reservations_tbl gme_common_pvt.reservations_tab;
233: l_mmt_tbl gme_common_pvt.mtl_mat_tran_tbl;
234: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
235: BEGIN
236: gmd_debug.log_initialize ('simul');

Line 233: l_mmt_tbl gme_common_pvt.mtl_mat_tran_tbl;

229: l_tpformula_id NUMBER(10);
230:
231: l_recipe_validity_out GMD_VALIDITY_RULES.recipe_validity_tbl;
232: l_reservations_tbl gme_common_pvt.reservations_tab;
233: l_mmt_tbl gme_common_pvt.mtl_mat_tran_tbl;
234: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
235: BEGIN
236: gmd_debug.log_initialize ('simul');
237: /* Inserting the item and lot data from batch material tables to temp tables*/

Line 234: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;

230:
231: l_recipe_validity_out GMD_VALIDITY_RULES.recipe_validity_tbl;
232: l_reservations_tbl gme_common_pvt.reservations_tab;
233: l_mmt_tbl gme_common_pvt.mtl_mat_tran_tbl;
234: l_mmln_tbl gme_common_pvt.mtl_trans_lots_num_tbl;
235: BEGIN
236: gmd_debug.log_initialize ('simul');
237: /* Inserting the item and lot data from batch material tables to temp tables*/
238: l_user_id := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));

Line 961: l_materials gme_common_pvt.material_details_tab;

957: l_msg_data VARCHAR2(2000);
958: X_return_status VARCHAR2(1);
959: l_rec Cur_get_materials%ROWTYPE;
960: l_batch Cur_get_batch%ROWTYPE;
961: l_materials gme_common_pvt.material_details_tab;
962: l_materials_out gme_common_pvt.material_details_tab;
963: l_trolin inv_move_order_pub.trolin_tbl_type;
964:
965: create_mo_line_err EXCEPTION;

Line 962: l_materials_out gme_common_pvt.material_details_tab;

958: X_return_status VARCHAR2(1);
959: l_rec Cur_get_materials%ROWTYPE;
960: l_batch Cur_get_batch%ROWTYPE;
961: l_materials gme_common_pvt.material_details_tab;
962: l_materials_out gme_common_pvt.material_details_tab;
963: l_trolin inv_move_order_pub.trolin_tbl_type;
964:
965: create_mo_line_err EXCEPTION;
966: setup_failure EXCEPTION;

Line 969: IF NOT (gme_common_pvt.setup(P_org_id => V_orgn_id)) THEN

965: create_mo_line_err EXCEPTION;
966: setup_failure EXCEPTION;
967: BEGIN
968: l_user_id := TO_NUMBER (fnd_profile.VALUE ('USER_ID'));
969: IF NOT (gme_common_pvt.setup(P_org_id => V_orgn_id)) THEN
970: RAISE setup_failure;
971: END IF;
972: /* Inserting the item and lot data for the item entered in the form*/
973: OPEN Cur_line_id;

Line 1031: l_materials(1).creation_date := gme_common_pvt.g_timestamp;

1027: l_materials(1).plan_qty := 0;
1028: l_materials(1).dtl_um := l_rec.detail_uom;
1029: l_materials(1).line_type := V_line_type;
1030: l_materials(1).batch_id := V_entity_id;
1031: l_materials(1).creation_date := gme_common_pvt.g_timestamp;
1032: l_materials(1).created_by := gme_common_pvt.g_user_ident;
1033: l_materials(1).last_update_date := gme_common_pvt.g_timestamp;
1034: l_materials(1).last_updated_by := gme_common_pvt.g_user_ident;
1035:

Line 1032: l_materials(1).created_by := gme_common_pvt.g_user_ident;

1028: l_materials(1).dtl_um := l_rec.detail_uom;
1029: l_materials(1).line_type := V_line_type;
1030: l_materials(1).batch_id := V_entity_id;
1031: l_materials(1).creation_date := gme_common_pvt.g_timestamp;
1032: l_materials(1).created_by := gme_common_pvt.g_user_ident;
1033: l_materials(1).last_update_date := gme_common_pvt.g_timestamp;
1034: l_materials(1).last_updated_by := gme_common_pvt.g_user_ident;
1035:
1036: gme_move_orders_pvt.create_move_order_lines (p_move_order_header_id => v_move_order_header_id

Line 1033: l_materials(1).last_update_date := gme_common_pvt.g_timestamp;

1029: l_materials(1).line_type := V_line_type;
1030: l_materials(1).batch_id := V_entity_id;
1031: l_materials(1).creation_date := gme_common_pvt.g_timestamp;
1032: l_materials(1).created_by := gme_common_pvt.g_user_ident;
1033: l_materials(1).last_update_date := gme_common_pvt.g_timestamp;
1034: l_materials(1).last_updated_by := gme_common_pvt.g_user_ident;
1035:
1036: gme_move_orders_pvt.create_move_order_lines (p_move_order_header_id => v_move_order_header_id
1037: ,p_move_order_type => gme_common_pvt.g_invis_move_order_type

Line 1034: l_materials(1).last_updated_by := gme_common_pvt.g_user_ident;

1030: l_materials(1).batch_id := V_entity_id;
1031: l_materials(1).creation_date := gme_common_pvt.g_timestamp;
1032: l_materials(1).created_by := gme_common_pvt.g_user_ident;
1033: l_materials(1).last_update_date := gme_common_pvt.g_timestamp;
1034: l_materials(1).last_updated_by := gme_common_pvt.g_user_ident;
1035:
1036: gme_move_orders_pvt.create_move_order_lines (p_move_order_header_id => v_move_order_header_id
1037: ,p_move_order_type => gme_common_pvt.g_invis_move_order_type
1038: ,p_material_details_tbl => l_materials

Line 1037: ,p_move_order_type => gme_common_pvt.g_invis_move_order_type

1033: l_materials(1).last_update_date := gme_common_pvt.g_timestamp;
1034: l_materials(1).last_updated_by := gme_common_pvt.g_user_ident;
1035:
1036: gme_move_orders_pvt.create_move_order_lines (p_move_order_header_id => v_move_order_header_id
1037: ,p_move_order_type => gme_common_pvt.g_invis_move_order_type
1038: ,p_material_details_tbl => l_materials
1039: ,x_material_details_tbl => l_materials_out
1040: ,x_trolin_tbl => l_trolin
1041: ,x_return_status => l_return_status);