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.GMO_VBATCH_TASK_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 213


x_resource_transaction_rec(23) := p_resource_transaction_rec.DELETE_MARK;

Line: 312


x_resource_transaction_rec.DELETE_MARK               := p_resource_transaction_rec(23);

Line: 378


procedure update_resource_transaction (
p_resource_transaction_rec IN fnd_table_of_varchar2_255
,x_return_status	   OUT NOCOPY VARCHAR2
,x_message_count           OUT NOCOPY NUMBER
,x_message_data            OUT NOCOPY VARCHAR2
)
AS
l_resource_transaction_rec_in gme_resource_txns_gtmp%rowtype;

Line: 389


	gme_resource_engine_pvt.update_resource_trans (
		p_tran_rec => l_resource_transaction_rec_in,
		x_return_status => x_return_status);

Line: 393


	gme_api_grp.update_resource_txn (
		p_rsrc_txn_gtmp_rec => l_resource_transaction_rec_in,
		x_return_status => x_return_status);

Line: 397


END update_resource_transaction;

Line: 399


procedure delete_resource_transaction (
p_resource_transaction_rec IN fnd_table_of_varchar2_255
,x_return_status	   OUT NOCOPY VARCHAR2
,x_message_count           OUT NOCOPY NUMBER
,x_message_data            OUT NOCOPY VARCHAR2
)
AS
l_resource_transaction_rec_in gme_resource_txns_gtmp%rowtype;

Line: 410


	gme_resource_engine_pvt.delete_resource_trans (
		p_tran_rec => l_resource_transaction_rec_in,
		x_return_status => x_return_status);

Line: 414


	gme_api_grp.delete_resource_txn (
		p_rsrc_txn_gtmp_rec => l_resource_transaction_rec_in,
                x_return_status => x_return_status);

Line: 419


END delete_resource_transaction;

Line: 438


	select * into l_batch_record from gme_batch_header where batch_id = p_batch_id;

Line: 443


procedure update_process_parameter
(
p_batch_no              IN              VARCHAR2
,p_org_code              IN              VARCHAR2
,p_validate_flexfields   IN              VARCHAR2
,p_batchstep_no          IN              NUMBER
,p_activity              IN              VARCHAR2
,p_parameter             IN              VARCHAR2
,p_process_param_rec     IN              fnd_table_of_varchar2_255
,x_process_param_rec     OUT NOCOPY      fnd_table_of_varchar2_255
,x_return_status         OUT NOCOPY      VARCHAR2
,x_message_count         OUT NOCOPY      NUMBER
,x_message_data          OUT NOCOPY      VARCHAR2
) AS

l_process_param_rec_in gme_process_parameters%rowtype;

Line: 508


l_process_param_rec_in.LAST_UPDATED_BY        := p_process_param_rec(45);

Line: 509


l_process_param_rec_in.LAST_UPDATE_LOGIN      := p_process_param_rec(46);

Line: 510


l_process_param_rec_in.LAST_UPDATE_DATE       := fnd_date.displaydt_to_date(p_process_param_rec(47), FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE);

Line: 514


gme_api_pub.update_process_parameter
(
x_message_count     => x_message_count
,x_message_list     => x_message_data
,x_return_status    => x_return_status
,p_batch_no         => p_batch_no
,p_org_code         => p_org_code
,p_validate_flexfields => p_validate_flexfields
,p_batchstep_no     => p_batchstep_no
,p_activity         => p_activity
,p_parameter        => p_parameter
,p_process_param_rec  => l_process_param_rec_in
,x_process_param_rec  => l_process_param_rec_out
);

Line: 620


x_process_param_rec(45) := l_process_param_rec_out.LAST_UPDATED_BY       ;

Line: 622


x_process_param_rec(46) := l_process_param_rec_out.LAST_UPDATE_LOGIN     ;

Line: 624


x_process_param_rec(47) := l_process_param_rec_out.LAST_UPDATE_DATE      ;

Line: 633


END update_process_parameter;

Line: 667


	SELECT
		mmt.transaction_id, mmt.subinventory_code, mmt.transaction_quantity, mmt.transaction_uom,
		mmt.secondary_transaction_quantity, mmt.secondary_uom_code, mtlt.lot_number, mmt.revision,
		mmt.locator_id, (select concatenated_segments
					from mtl_item_locations_kfv
					where organization_id = mmt.organization_id
					and subinventory_code = mmt.subinventory_code
					and inventory_location_id=mmt.locator_id) locator_code,
		mmt.TRANSACTION_TYPE_ID
	FROM mtl_material_transactions mmt, mtl_transaction_lot_numbers mtlt
	WHERE mmt.transaction_source_id = p_batch_id
	AND mmt.trx_source_line_id = p_material_detail_id
	AND mmt.transaction_source_type_id = 5
	AND NOT EXISTS (SELECT transaction_id1
					FROM gme_transaction_pairs
					WHERE transaction_id1 = mmt.transaction_id
					AND pair_type = 1)
	and mtlt.transaction_id (+) = mmt.transaction_id
	and mmt.organization_id = p_organization_id;

Line: 732


	SELECT
		reservation_id, subinventory_code, primary_reservation_quantity, reservation_uom_code,
		secondary_reservation_quantity, secondary_uom_code, lot_number, revision,
		locator_id, (select concatenated_segments
					 from mtl_item_locations_kfv
					 where organization_id = mr.organization_id
					 and subinventory_code = mr.subinventory_code
					 and inventory_location_id=mr.locator_id)
		FROM mtl_reservations mr
		WHERE organization_id = p_organization_id
		AND demand_source_type_id = 5
		AND demand_source_header_id = p_batch_id
		AND demand_source_line_id = p_material_detail_id
		AND NOT EXISTS (SELECT 1
				FROM mtl_material_transactions_temp
				WHERE reservation_id = mr.reservation_id);

Line: 1107


procedure update_material_transaction(
p_mtl_txn_rec              IN fnd_table_of_varchar2_255
,p_mtl_lot_rec             IN fnd_table_of_varchar2_255
,x_return_status           OUT NOCOPY VARCHAR2
,x_message_count           OUT NOCOPY NUMBER
,x_message_data            OUT NOCOPY VARCHAR2
)
IS

l_mtl_txn_rec 	mtl_transactions_interface%ROWTYPE;

Line: 1151


	gme_api_grp.update_material_txn(
		p_transaction_id => l_mtl_txn_rec.TRANSACTION_INTERFACE_ID,
		p_mmti_rec => l_mtl_txn_rec,
	    p_mmli_tbl => l_mtl_lot_tbl,
        x_return_status   => x_return_status
	);

Line: 1168


                        FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_task_pvt.update_material_transaction', FALSE);

Line: 1172


END update_material_transaction;

Line: 1175


procedure delete_material_transaction(
p_mtl_txn_rec              IN fnd_table_of_varchar2_255
,p_mtl_lot_rec             IN fnd_table_of_varchar2_255
,x_return_status           OUT NOCOPY VARCHAR2
,x_message_count           OUT NOCOPY NUMBER
,x_message_data            OUT NOCOPY VARCHAR2
)
IS

l_mtl_txn_rec 	mtl_transactions_interface%ROWTYPE;

Line: 1218


	gme_api_grp.delete_material_txn(
		p_organization_id => l_mtl_txn_rec.ORGANIZATION_ID,
		p_transaction_id => l_mtl_txn_rec.TRANSACTION_INTERFACE_ID,
	        x_return_status   => x_return_status
	);

Line: 1233


                        FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_vbatch_task_pvt.delete_material_transaction', FALSE);

Line: 1237


END delete_material_transaction;

Line: 1257


l_lot_rec.LAST_UPDATE_DATE     := sysdate;

Line: 1258


l_lot_rec.LAST_UPDATED_BY      := FND_GLOBAL.USER_ID;

Line: 1261


l_lot_rec.LAST_UPDATE_LOGIN    := FND_GLOBAL.LOGIN_ID;

Line: 1389


select gen_object_id into x_lot_event_key from mtl_lot_numbers
where organization_id = p_organization_id
and inventory_item_id = p_inventory_item_id
and lot_number = p_lot_number;