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: 374


        UPDATE GME_BATCH_STEP_RESOURCES
        SET actual_rsrc_count = p_actual_resource_count
        WHERE BATCHSTEP_RESOURCE_ID=l_resource_transaction_rec_in.LINE_ID;

Line: 382


procedure update_resource_transaction (
p_resource_transaction_rec IN fnd_table_of_varchar2_255
, p_actual_resource_count IN NUMBER
,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: 394


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

Line: 398


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

Line: 401


        UPDATE GME_BATCH_STEP_RESOURCES
        SET actual_rsrc_count = p_actual_resource_count
        WHERE BATCHSTEP_RESOURCE_ID=l_resource_transaction_rec_in.LINE_ID;

Line: 405


END update_resource_transaction;

Line: 407


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: 418


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

Line: 422


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

Line: 427


END delete_resource_transaction;

Line: 446


	select * into l_batch_record from gme_batch_header where batch_id = p_batch_id;

Line: 451


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: 516


l_process_param_rec_in.LAST_UPDATED_BY        := p_process_param_rec(45);

Line: 517


l_process_param_rec_in.LAST_UPDATE_LOGIN      := p_process_param_rec(46);

Line: 518


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: 522


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: 628


x_process_param_rec(45) := l_process_param_rec_out.LAST_UPDATED_BY       ;

Line: 630


x_process_param_rec(46) := l_process_param_rec_out.LAST_UPDATE_LOGIN     ;

Line: 632


x_process_param_rec(47) := l_process_param_rec_out.LAST_UPDATE_DATE      ;

Line: 641


END update_process_parameter;

Line: 675


	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: 740


	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: 1067


        SELECT * FROM mtl_lot_numbers
        WHERE lot_number=cp_lot_number
        AND organization_id= cp_organization_id
        AND inventory_item_id = cp_inventory_item_id ;

Line: 1139


    inv_calculate_exp_date.update_inv_lot_attr(
                                x_return_status          => x_return_status
                              , x_msg_count              => x_message_count
                              , x_msg_data               => x_message_data
                              , p_inventory_item_id      => l_mtl_txn_rec.INVENTORY_ITEM_ID
                              , p_organization_id        => l_mtl_txn_rec.ORGANIZATION_ID
                              , p_lot_number             => l_mtl_lot_rec.LOT_NUMBER
                              , p_source                 => 1
                              , p_expiration_date        => l_lot_expiration_date
                              , p_grade_code             => l_mtl_lot_num_rec.grade_code
                              , p_origination_date       => l_orig_date
                              , p_origination_type       => l_mtl_lot_num_rec.origination_type
                              , p_status_id              => l_mtl_lot_num_rec.status_id
                              , p_retest_date            => l_mtl_lot_num_rec.retest_date
                              , p_maturity_date          => l_mtl_lot_num_rec.maturity_date
                              , p_supplier_lot_number    => l_mtl_lot_num_rec.supplier_lot_number
                              , p_expiration_action_code => l_mtl_lot_num_rec.expiration_action_code
                              , p_expiration_action_date => l_mtl_lot_num_rec.expiration_action_date
                              , p_hold_date              => l_mtl_lot_num_rec.hold_date
                              , p_c_attribute1           => l_mtl_lot_num_rec.c_attribute1
                              , p_c_attribute2           => l_mtl_lot_num_rec.c_attribute2
                              , p_c_attribute3           => l_mtl_lot_num_rec.c_attribute3
                              , p_c_attribute4           => l_mtl_lot_num_rec.c_attribute4
                              , p_c_attribute5           => l_mtl_lot_num_rec.c_attribute5
                              , p_c_attribute6           => l_mtl_lot_num_rec.c_attribute6
                              , p_c_attribute7           => l_mtl_lot_num_rec.c_attribute7
                              , p_c_attribute8           => l_mtl_lot_num_rec.c_attribute8
                              , p_c_attribute9           => l_mtl_lot_num_rec.c_attribute9
                              , p_c_attribute10          => l_mtl_lot_num_rec.c_attribute10
                              , p_c_attribute11          => l_mtl_lot_num_rec.c_attribute11
                              , p_c_attribute12          => l_mtl_lot_num_rec.c_attribute12
                              , p_c_attribute13          => l_mtl_lot_num_rec.c_attribute13
                              , p_c_attribute14          => l_mtl_lot_num_rec.c_attribute14
                              , p_c_attribute15          => l_mtl_lot_num_rec.c_attribute15
                              , p_c_attribute16          => l_mtl_lot_num_rec.c_attribute16
                              , p_c_attribute17          => l_mtl_lot_num_rec.c_attribute17
                              , p_c_attribute18          => l_mtl_lot_num_rec.c_attribute18
                              , p_c_attribute19          => l_mtl_lot_num_rec.c_attribute19
                              , p_c_attribute20          => l_mtl_lot_num_rec.c_attribute20
                              , p_d_attribute1           => l_mtl_lot_num_rec.d_attribute1
                              , p_d_attribute2           => l_mtl_lot_num_rec.d_attribute2
                              , p_d_attribute3           => l_mtl_lot_num_rec.d_attribute3
                              , p_d_attribute4           => l_mtl_lot_num_rec.d_attribute4
                              , p_d_attribute5           => l_mtl_lot_num_rec.d_attribute5
                              , p_d_attribute6           => l_mtl_lot_num_rec.d_attribute6
                              , p_d_attribute7           => l_mtl_lot_num_rec.d_attribute7
                              , p_d_attribute8           => l_mtl_lot_num_rec.d_attribute8
                              , p_d_attribute9           => l_mtl_lot_num_rec.d_attribute9
                              , p_d_attribute10          => l_mtl_lot_num_rec.d_attribute10
                              , p_n_attribute1           => l_mtl_lot_num_rec.n_attribute1
                              , p_n_attribute2           => l_mtl_lot_num_rec.n_attribute2
                              , p_n_attribute3           => l_mtl_lot_num_rec.n_attribute3
                              , p_n_attribute4           => l_mtl_lot_num_rec.n_attribute4
                              , p_n_attribute5           => l_mtl_lot_num_rec.n_attribute5
                              , p_n_attribute6           => l_mtl_lot_num_rec.n_attribute6
                              , p_n_attribute7           => l_mtl_lot_num_rec.n_attribute7
                              , p_n_attribute8           => l_mtl_lot_num_rec.n_attribute8
                              , p_n_attribute9           => l_mtl_lot_num_rec.n_attribute9
                              , p_n_attribute10          => l_mtl_lot_num_rec.n_attribute10
                              , p_description            => l_mtl_lot_num_rec.description
                              , p_vendor_name            => l_mtl_lot_num_rec.vendor_name
                              , p_date_code              => l_mtl_lot_num_rec.date_code
                              , p_change_date            => l_mtl_lot_num_rec.change_date
                              , p_age                    => l_mtl_lot_num_rec.age
                              , p_item_size              => l_mtl_lot_num_rec.item_size
                              , p_color                  => l_mtl_lot_num_rec.color
                              , p_volume                 => l_mtl_lot_num_rec.volume
                              , p_volume_uom             => l_mtl_lot_num_rec.volume_uom
                              , p_place_of_origin        => l_mtl_lot_num_rec.place_of_origin
                              , p_best_by_date           => l_mtl_lot_num_rec.best_by_date
                              , p_length                 => l_mtl_lot_num_rec.length
                              , p_length_uom             => l_mtl_lot_num_rec.length_uom
                              , p_recycled_content       => l_mtl_lot_num_rec.recycled_content
                              , p_thickness              => l_mtl_lot_num_rec.thickness
                              , p_thickness_uom          => l_mtl_lot_num_rec.thickness_uom
                              , p_width                  => l_mtl_lot_num_rec.width
                              , p_width_uom              => l_mtl_lot_num_rec.width_uom
                              , p_curl_wrinkle_fold      => l_mtl_lot_num_rec.curl_wrinkle_fold
                              , p_lot_attribute_category => l_mtl_lot_num_rec.lot_attribute_category
                              , p_territory_code         => l_mtl_lot_num_rec.territory_code
                              , p_vendor_id              => l_mtl_lot_num_rec.vendor_id
                              , p_parent_lot_number      => l_mtl_lot_num_rec.parent_lot_number
                            );

Line: 1249


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: 1293


  SAVEPOINT update_transaction;

Line: 1296


	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: 1304


  ROLLBACK TO update_transaction;

Line: 1317


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

Line: 1321


END update_material_transaction;

Line: 1324


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: 1367


	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: 1382


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

Line: 1386


END delete_material_transaction;

Line: 1406


l_lot_rec.LAST_UPDATE_DATE     := sysdate;

Line: 1407


l_lot_rec.LAST_UPDATED_BY      := FND_GLOBAL.USER_ID;

Line: 1410


l_lot_rec.LAST_UPDATE_LOGIN    := FND_GLOBAL.LOGIN_ID;

Line: 1538


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;

Line: 1575


  SELECT batch_id
  INTO v_batch_id
  FROM gme_batch_steps
  WHERE batchstep_id=p_batchstep_id;

Line: 1583


  SELECT *
  INTO l_batch_step_details
  FROM gme_batch_steps
  WHERE batchstep_id=p_batchstep_id
  AND batch_id=v_batch_id;

Line: 1591


  SELECT *
  INTO l_batch_header
  FROM gme_batch_header
  WHERE batch_id=v_batch_id;

Line: 1709


         SELECT Nvl(origination_date,p_transaction_date)
           INTO x_orig_date
           FROM mtl_lot_numbers
          WHERE inventory_item_id = p_inventory_item_id
           AND lot_number = p_lot_number
           AND organization_id = p_organization_id;