APPS.CS_CONTRACT_TPL_PUB SQL Statements

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

Line: 17

      		SELECT *
 		FROM cs_contracts
       		WHERE contract_id = p_contract_id;

Line: 21

      		SELECT *
 		FROM cs_cp_services
       		WHERE contract_id = p_contract_id;

Line: 80

    		l_ContractTmpl_Rec.last_update_date               := sysdate;

Line: 81

    		l_ContractTmpl_Rec.last_updated_by                := FND_GLOBAL.user_id;

Line: 85

    		l_ContractTmpl_Rec.last_update_login              := FND_GLOBAL.login_id;

Line: 106

	--dbms_output.put_line('Before inserting template');

Line: 107

	-- Call insert API for cs_contracts_template
		CS_ContractTmpl_Pvt.Insert_Row
  		(
    			p_api_version                  => 1.0,
    			p_init_msg_list                => TAPI_DEV_KIT.G_FALSE,
    			p_validation_level             => 100,
    			p_commit                       => TAPI_DEV_KIT.G_FALSE,
    			x_return_status                => l_return_status,
    			x_msg_count                    => l_msg_count,
    			x_msg_data                     => l_msg_data,
    			p_contracttmpl_rec             => l_ContractTmpl_Rec,
    			x_contract_template_id         => l_contract_template_id,
    			x_object_version_number        => l_object_version_number
		);

Line: 121

	--dbms_output.put_line('After inserting template');

Line: 124

			--- insert into cs_contract_line_tplts
			CS_CONTRACTLTMPL_PVT.Insert_Row
  			(
    			p_api_version                  => 1.0,
    			p_init_msg_list                => TAPI_DEV_KIT.G_FALSE,
    			p_validation_level             => 100,
    			p_commit                       => TAPI_DEV_KIT.G_FALSE,
    			x_return_status                => l_return_status,
    			x_msg_count                    => l_msg_count,
    			x_msg_data                     => l_msg_data,
    			p_contract_template_id         => l_contract_template_id,
    			p_coverage_id                  => l_Service_Rec.coverage_schedule_id,
    			p_service_manufacturing_org_id  => l_Service_Rec.service_manufacturing_org_id,
    			p_service_inventory_item_id    => l_Service_Rec.service_inventory_item_id,
    			p_workflow                     => l_Service_Rec.workflow,
    			p_original_system_reference    => l_Service_Rec.original_system_line_reference,
    			p_duration              		 => l_Service_Rec.duration_quantity,
    			p_unit_of_measure_code         => l_Service_Rec.unit_of_measure_code,
    			p_last_update_date             => sysdate,
    			p_last_updated_by              => FND_GLOBAL.user_id,
    			p_creation_date                => sysdate,
    			p_created_by                   => FND_GLOBAL.user_id,
    			p_last_update_login            => FND_GLOBAL.login_id,
    			p_start_date_active            => NULL,
    			p_end_date_active              => NULL,
    			p_attribute1                   => l_Service_Rec.attribute1,
    			p_attribute2                   => l_Service_Rec.attribute2,
    			p_attribute3                   => l_Service_Rec.attribute3,
    			p_attribute4                   => l_Service_Rec.attribute4,
    			p_attribute5                   => l_Service_Rec.attribute5,
    			p_attribute6                   => l_Service_Rec.attribute6,
    			p_attribute7                   => l_Service_Rec.attribute7,
    			p_attribute8                   => l_Service_Rec.attribute8,
    			p_attribute9                   => l_Service_Rec.attribute9,
    			p_attribute10                  => l_Service_Rec.attribute10,
    			p_attribute11                  => l_Service_Rec.attribute11,
    			p_attribute12                  => l_Service_Rec.attribute12,
    			p_attribute13                  => l_Service_Rec.attribute13,
    			p_attribute14                  => l_Service_Rec.attribute14,
    			p_attribute15                  => l_Service_Rec.attribute15,
    			p_context                      => l_Service_Rec.context,
    			p_object_version_number        => 1,
    			x_contract_line_template_id    => l_contract_line_template_id,
    			x_object_version_number        => l_object_version_number
			);

Line: 241

		Select * from cs_contract_templates
	where contract_template_id = p_template_id;

Line: 244

		Select * from cs_contract_line_tplts
			where contract_template_id =  p_template_id;

Line: 323

    	l_contract_rec.last_update_date               := sysdate;

Line: 324

    	l_contract_rec.last_updated_by                := FND_GLOBAL.user_id;

Line: 327

    	l_contract_rec.last_update_login              := FND_GLOBAL.login_id;

Line: 348

	--dbms_output.put_line('before insert');

Line: 349

	CS_CONTRACT_PVT.insert_row
  	(
    		p_api_version                  => 1.0,
    		p_init_msg_list                => TAPI_DEV_KIT.G_FALSE,
    		p_validation_level             => 100,
    		p_commit                       => TAPI_DEV_KIT.G_FALSE,
    		x_return_status                => l_return_status,
    		x_msg_count                    => l_msg_count,
    		x_msg_data                     => l_msg_data,
    		p_contract_rec                 => l_contract_rec,
    		x_contract_id                  => l_contract_id,
    		x_object_version_number        => l_object_version_number
	);

Line: 364

		--dbms_output.put_line('Inserted lines');

Line: 365

		CS_SERVICES_PVT.Insert_Service
  		(
    			p_api_version                  => 1.0,
    			p_init_msg_list                => TAPI_DEV_KIT.G_FALSE,
    			p_validation_level             => 100,
    			p_commit                       => TAPI_DEV_KIT.G_FALSE,
    			x_return_status                => l_return_status,
    			x_msg_count                    => l_msg_count,
    			x_msg_data                     => l_msg_data,
    			p_contract_line_template_id    => l_Tmpl_Rec.contract_line_template_id,
    			p_contract_id                  => l_contract_id,
			p_contract_line_status_id	=> FND_PROFILE.VALUE('CS_CONTRACTS_DEFAULT_LINE_STATUS'),
    			p_service_inventory_item_id    => l_Tmpl_Rec.service_inventory_item_id,
    			p_service_manufacturing_org_id => l_Tmpl_Rec.service_manufacturing_org_id,
    			p_original_start_date          => l_Tmpl_Rec.start_date_active,
    			p_original_end_date            => l_Tmpl_Rec.end_date_active,
    			p_workflow                     => l_Tmpl_Rec.workflow,
    			p_riginl_systm_lin_rfrnc       => l_Tmpl_Rec.original_system_reference,
    			p_duration_quantity            => l_Tmpl_Rec.duration,
    			p_unit_of_measure_code         => l_Tmpl_Rec.unit_of_measure_code,
    			p_creation_date                => sysdate,
    			p_created_by                   => FND_GLOBAL.user_id,
    			p_last_update_date             => sysdate,
    			p_last_updated_by              => FND_GLOBAL.user_id,
    			p_last_update_login            => FND_GLOBAL.login_id,
    			p_start_date_active            => l_Tmpl_Rec.start_date_active,
    			p_end_date_active              => l_Tmpl_Rec.end_date_active,
    			x_cp_service_id                => l_cp_service_id
		);