APPS.CS_CONBILLING_PVT SQL Statements

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

Line: 33

 PROCEDURE update_billing(
			p_api_version  		IN NUMBER,
			p_init_msg_list 		IN VARCHAR2 := FND_API.G_FALSE,
			p_commit 				IN VARCHAR2 := FND_API.G_FALSE,
			p_cp_service_trx_id 	IN NUMBER,
			p_contract_id 			IN NUMBER,
			p_trx_type_id 			IN NUMBER,
			p_trx_number 			IN NUMBER,
			p_trx_date 			IN DATE,
			p_tot_trx_amount 		IN NUMBER,
		     p_trx_pre_tax_amount 	IN NUMBER,
			p_contract_billing_id 	IN NUMBER,
			p_obj_version_number  	IN NUMBER,
			x_return_status 		OUT VARCHAR2,
			x_msg_count 			OUT NUMBER,
			x_msg_data 			OUT NUMBER) IS

l_api_name 	 CONSTANT VARCHAR2(30):='Update_Billing_Api';

Line: 77

	SELECT type INTO transaction_class
	FROM ra_cust_trx_types
	WHERE cust_trx_type_id=p_trx_type_id;

Line: 87

	/* update inv details in cs_contract_billing*/

	IF (transaction_class = 'INV') THEN

/*		UPDATE cs_contracts_billing
		SET trx_number=p_trx_number,
		    trx_date=p_trx_date,
		    trx_amount=p_tot_trx_amount,
		    trx_pre_tax_amount=p_trx_pre_tax_amount,
		    trx_class='INV'
		WHERE contract_billing_id=p_contract_billing_id;

Line: 101

		 CS_CONTRACTBILLING_PVT.Update_Row(
				p_api_version			=>  1.0,
				p_init_msg_list		=>  'T',
				p_validation_level		=>  100,
				p_commit				=>  'F',
				x_return_status		=>	v_return_status,
				x_msg_count			=>	v_msg_count,
			     x_msg_data			=>	v_msg_data,
				p_contract_billing_id	=>	p_contract_billing_id,
		     	p_object_version_number	=>   p_obj_version_number,
				p_trx_date			=>	p_trx_date,
				p_trx_number			=>	p_trx_number,
				p_trx_amount			=>	p_tot_trx_amount,
			     p_trx_pre_tax_amount	=>   p_trx_pre_tax_amount,
				p_trx_class			=>	'INV',
				x_object_version_number  =>   p_obj_ver_num
				);

Line: 122

		UPDATE cs_contracts_billing
		SET trx_number=p_trx_number,
		    trx_date=p_trx_date,
		    trx_amount=p_tot_trx_amount,
		    trx_pre_tax_amount=p_trx_pre_tax_amount,
		    trx_class='CM'
		WHERE contract_billing_id=p_contract_billing_id;

Line: 131

     	CS_CONTRACTBILLING_PVT.Update_Row(
				p_api_version			=>  1.0,
				p_init_msg_list		=>  'T',
				p_validation_level		=>  100,
				p_commit				=>  'F',
				x_return_status		=>	v_return_status,
				x_msg_count			=>	v_msg_count,
			     x_msg_data			=>	v_msg_data,
				p_contract_billing_id	=>	p_contract_billing_id,
				p_trx_date			=>	p_trx_date,
				p_object_version_number	=>   p_obj_version_number,
				p_trx_number			=>	p_trx_number,
				p_trx_amount			=>	p_tot_trx_amount,
			     p_trx_pre_tax_amount	=>   p_trx_pre_tax_amount,
				p_trx_class			=>	'CM',
				x_object_version_number	=> p_obj_ver_num
				);

Line: 202

END update_billing;