DBA Data[Home] [Help]

APPS.GMD_RESULT_TRANSFER_GRP dependencies on GMD_API_PUB

Line 172: --GMD_API_PUB.Log_Message('Deleting gmd_result_transfer_gt');

168:
169: BEGIN
170: x_return_status :=FND_API.G_RET_STS_SUCCESS;
171: FND_MSG_PUB.initialize;
172: --GMD_API_PUB.Log_Message('Deleting gmd_result_transfer_gt');
173: l_place := 0;
174: DELETE gmd_result_transfer_gt;
175: l_place := 10;
176: IF (p_transfer_type = 'S') THEN

Line 469: test_ids gmd_api_pub.number_tab;

465: where sample_id =p_sample_id)
466: order by orgn_code;
467: l_action_code c_action_code%ROWTYPE;
468: l_sample gmd_samples%rowtype;
469: test_ids gmd_api_pub.number_tab;
470: add_rslt_tab_out gmd_api_pub.gmd_results_tab;
471: add_spec_tab_out gmd_api_pub.gmd_spec_results_tab;
472: l_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE;
473: l_lot_number mtl_lot_numbers.lot_number%TYPE;

Line 470: add_rslt_tab_out gmd_api_pub.gmd_results_tab;

466: order by orgn_code;
467: l_action_code c_action_code%ROWTYPE;
468: l_sample gmd_samples%rowtype;
469: test_ids gmd_api_pub.number_tab;
470: add_rslt_tab_out gmd_api_pub.gmd_results_tab;
471: add_spec_tab_out gmd_api_pub.gmd_spec_results_tab;
472: l_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE;
473: l_lot_number mtl_lot_numbers.lot_number%TYPE;
474: l_update_instance_id NUMBER;

Line 471: add_spec_tab_out gmd_api_pub.gmd_spec_results_tab;

467: l_action_code c_action_code%ROWTYPE;
468: l_sample gmd_samples%rowtype;
469: test_ids gmd_api_pub.number_tab;
470: add_rslt_tab_out gmd_api_pub.gmd_results_tab;
471: add_spec_tab_out gmd_api_pub.gmd_spec_results_tab;
472: l_inventory_item_id mtl_system_items_b.inventory_item_id%TYPE;
473: l_lot_number mtl_lot_numbers.lot_number%TYPE;
474: l_update_instance_id NUMBER;
475:

Line 790: gmd_api_pub.RAISE2(

786:
787: IF l_return_status <> 'S' THEN
788: RAISE FND_API.G_EXC_ERROR;
789: ELSE
790: gmd_api_pub.RAISE2(
791: P_event_name =>'oracle.apps.gmd.qm.performtest',
792: P_event_key =>p_sample_id,
793: P_Parameter_name1 =>'TEST_ID',
794: P_Parameter_value1=> temp_table_rslt_row.test_id

Line 803: gmd_api_pub.raise (P_EVENT_NAME => 'oracle.apps.gmi.lotretestdate.update',

799: SELECT inventory_item_id, lot_number
800: INTO l_inventory_item_id, l_lot_number
801: FROM gmd_samples
802: WHERE sample_id = p_sample_id;
803: gmd_api_pub.raise (P_EVENT_NAME => 'oracle.apps.gmi.lotretestdate.update',
804: P_EVENT_KEY => to_char(l_inventory_item_id)
805: ||'-'|| l_lot_number);
806: END IF;
807: