APPS.CSF_IB SQL Statements

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

Line: 211

Procedure Update_Product(
	p_api_version	in 	number,
	x_return_status OUT NOCOPY	varchar2,
	x_msg_count	 OUT NOCOPY	number,
	x_msg_data	 OUT NOCOPY	varchar2,
	p_cp_id		in	number ,
    p_customer_id	IN	NUMBER ,
	p_inv_item_id	IN	number ,
	p_quantity	in	number ,
	p_uom_code	in	varchar2,
	p_cp_status_id	in	number,
	p_config_parent_cp_id number,
    p_serial_number     in   varchar2     ,
    p_shipped_date      in   date         ) Is

l_abort_on_warn_flag	Cs_InstalledBase_Pub.Abort_Upd_On_Warn_Rec_Type;

Line: 227

l_cascade_updates_flag	Cs_InstalledBase_Pub.Cascade_Upd_Flag_Rec_Type;

Line: 258

	Cs_InstalledBase_Pub.Update_Product
	(
		p_api_version			=> 1.0,
		x_return_status          => x_return_status,
		x_msg_count              => x_msg_count,
		x_msg_data               => x_msg_data,
		p_cp_id                  => p_cp_id,
		p_cp_rec	         => l_cp_rec,
		p_ship_rec	         => l_ship_rec,
		p_abort_on_warn_flag	 => l_abort_on_warn_flag,
          p_cascade_updates_flag  => l_cascade_updates_flag
	);

Line: 271

End Update_Product;

Line: 273

Procedure Update_install_base (
    p_api_version                in  number,
    p_init_msg_list              in  varchar2 := fnd_api.g_false,
    p_commit                     in  varchar2 := fnd_api.g_false,
    p_validation_level           in  number := fnd_api.g_valid_level_full,
    x_return_status              OUT NOCOPY varchar2,
    x_msg_count                  OUT NOCOPY number,
    x_msg_data                   OUT NOCOPY varchar2,
    x_new_instance_id            OUT NOCOPY  number,
    p_in_out_flag                in  varchar2,
    p_transaction_type_id        in  number,
    p_txn_sub_type_id            in  number,
    p_instance_id                in  number,
    p_inventory_item_id          in  number,
    p_inv_organization_id        in  number,
    p_inv_subinventory_name      in  varchar2,
    p_inv_locator_id             in  number,
    p_quantity                   in  number,
    p_inv_master_organization_id in  number,
    p_mfg_serial_number_flag     in  varchar2,
    p_serial_number              in  varchar2,
    p_lot_number                 in  varchar2,
    p_revision                   in  varchar2,
    p_unit_of_measure            in  varchar2,
    p_party_id                   in  number,
    p_party_account_id           in  number,
    p_party_site_id              in  number,
    p_parent_instance_id         in  number,
 p_instance_status_id         in number := 9.99E125,  --fnd_api.g_miss_num) --added for bug 3192060
p_item_operational_status_code in varchar2
) is

  l_api_version             NUMBER := 1.0;

Line: 470

END UPDATE_INSTALL_BASE;